dvbsknd / codecademy-expresso-start Goto Github PK

To complete this project, you will need to create the database tables and API routes specified below.

To test this functionality you can run the testing suite and interact with the API via the provided front-end. If you want more data to interact with in the front-end, you can run the seed.js file to add data to your database.

We've provided an empty migration.js file for you to write table creation logic in.

• Create and export your Express app from a root-level file called server.js
• Accept and set an optional port argument for your server to listen on from process.env.PORT
• If process.env.PORT is not set, server should run on port 4000 (this is where the provided front-end will make requests to)
• Accept and set an optional database file argument from process.env.TEST_DATABASE in all Express route files that open and modify your database
• Use the root-level database.sqlite as your API's database
• Note: When loading database.sqlite in your JavaScript files, sqlite3 will always try to load database.sqlite from the root directory path, ./database.sqlite, regardless of where the current file is located. Therefore your code will always be new sqlite3.Database(process.env.TEST_DATABASE || './database.sqlite') regardless of the file you are writing in