Problem
We need a frontend that will display data about shipped orders retrieved from a database in Neon.
We need to be able to look at orders in chronological order (most recently shipped orders display at the top of the page)
Goal
Create a simple frontend page that will retrieve all the data from a neon db table
Display in tabular format (i.e. how it looks in the database with its columns and column headers)
Make it a one-stop shop for data access when it comes to shipped orders
Requirements
Make sure the orders on the page are sorted by most recently shipped at the top
Display the data in tabular form (column headers at the top)
Create an .env file and expect a variable in there called PG_DB_URL. include it in an example env file.
For any decimal values, round up to two decimal places
Ensure all data is retrieved from tables and captured correctly (i.e. no blanks in any of the fields unless specifically retrieved as such)
Include a header title at the top of the page that says "Fulfilled Orders"
Include logs in the code after the data is retrieved from the Neon db, and display the retrieved data via foreach loop
Ensure validation throughout the code in regards to data format and avoid any exceptions
Data format
Retrieve the data found in the neon tables and prepare the expected model format to mirror that.
Notes
In your PR description, include a section that indicates how to test this code
create a test file that can be used to test access to the Neon db.
Problem
We need a frontend that will display data about shipped orders retrieved from a database in Neon.
We need to be able to look at orders in chronological order (most recently shipped orders display at the top of the page)
Goal
Create a simple frontend page that will retrieve all the data from a neon db table
Display in tabular format (i.e. how it looks in the database with its columns and column headers)
Make it a one-stop shop for data access when it comes to shipped orders
Requirements
Make sure the orders on the page are sorted by most recently shipped at the top
Display the data in tabular form (column headers at the top)
Create an .env file and expect a variable in there called PG_DB_URL. include it in an example env file.
For any decimal values, round up to two decimal places
Ensure all data is retrieved from tables and captured correctly (i.e. no blanks in any of the fields unless specifically retrieved as such)
Include a header title at the top of the page that says "Fulfilled Orders"
Include logs in the code after the data is retrieved from the Neon db, and display the retrieved data via foreach loop
Ensure validation throughout the code in regards to data format and avoid any exceptions
Data format
Retrieve the data found in the neon tables and prepare the expected model format to mirror that.
Notes
In your PR description, include a section that indicates how to test this code
create a test file that can be used to test access to the Neon db.