trujilloj / memory-1 Goto Github PK

You're making an API that can list, create, read, update, and delete a collection of New Year's resolutions. The problem is that you're missing a critical part of the API-- the database! Create a database for this API, and interface with it via Knex.js.

Make a local database and setup a knexfile to connect to it.

Make a migration that creates the following database table:

resolution

Seed your database with some data:

Make sure your next auto-incrementing integer starts with 4!

Make a connection to your database in the database-connection.js file with the appropriate environment data.

Fill out the queries.js file with the following:

• list() should return a promise that resolves with all of the data in the resolution table as an array
• read(id) should return a promise that resolves with the record with a matching id as an object
• create(resolution) should return a promise that inserts a resolution object and resolves to the created database record as an object
• update(id, resolution) should return a promise that updates a resolution record matching id with the data in resolution and resolves to the updated database record as an object
• delete(id) should return a promise that removes the record matching id and resolves to nothing

Deploy this API. Note that you'll need to create a remote database, run your migration and seeds on it, and connect to it in production and your local database in development.

• You can test your API locally with npm test

Add a link to your deployed API here.