This repo provides a very basic template for using sqlite with express.
To get started and poke around the package, first install the dependencies:
npm iRun the following command to start the server:
npm run testwhich will run nodemon on index.ts.
Write the rest of the missing endpoints in index.ts to create a simple backend for a CRUD app. This will require you to write code in db.ts as well!
The documentation for sqlite3 will be very helpful.
Make sure that you return the correct HTTP status code as well.
Most of this file should look familiar. Look at past assignments to review what each section of this file does.
You can ignore the middleware code -- at a very basic level, this code allows us to test our front end later on in this course.
The database foo.db contains one table named user.
Use DB Browser to explore this database before you write any code!