In this short practice, you will be using Sequelize models to insert data into a database.

Download starter.

Execute the setup-commands.sh script from the root directory of this practice.

sh setup-commands.sh

View the contents of the script to see the commands that are executed. View the results in the terminal to confirm that setup was successful in creating the following Puppies table in your database:

Start the development server with npm run dev and navigate to /puppies to ensure that application has been initialized correctly. You should see all ten puppies from the seeder file displayed in the browser.

In this practice you will be utilizing the Sequelize Puppy to create new records in the Puppies table of the database. The first two steps work solely with Sequelize in the test.js file. The last step will have you implement a POST route, combining your Express and Sequelize knowledge.

In test.js, implement the following code in the first try/catch block. This block of code should utilize the build method of your model in order to create a new instance of a Puppy. Use the following attributes for this instance:

Remember to save the instance of the Puppy model to the database after it has been built.

When run, the test.js file will rebuild, migrate, and seed your database. Do so with npm test after you implement the code. After running the file, check that the new puppy has been inserted into the database. Use either sqlite3 and a SQL query to directly view the contents, or navigate to /puppies in your browser.

In test.js, implement the following code in the second try/catch block. This block of code should utilize the create method of your model in order to create a new instance of a Puppy. Use the following attributes for this instance:

Comment out the code in the first try/catch block before running test.js again.

When run, the test.js file will rebuild, migrate, and seed your database. Do so with npm test after you implement the code. After running the file, check that the new puppy has been inserted into the database. Use either sqlite3 and a SQL query to directly view the contents, or navigate to /puppies in your browser.

Compare the two methods of inserting a new record that you utilized in these first two steps.

In app.js there are two endpoints associated with /puppies. The GET route has been completed for you. This endpoint allows you to navigate to /puppies in your browser to see the contents of the Puppies table. In this step, you will complete the POST route. This endpoint will accept attributes from the body of a request and create a new Puppies record.

Capture the name, age_yrs, breed, weight_lbs, and microchipped attributes from the body of the request (req.body), and use those values to create a new instance of a Puppy. Utilize either of the methods from the two previous steps.

After the record has been saved to the database, create a JSON response, with a message key indicating that the record was successfully saved, as well as a data key with the newly created Puppy as its value.

Test that this route is working as intended by utilizing Postman. Make a POST request to /puppies with the following JSON request body:

{
  "name": "George",
  "age_yrs": 1.2,
  "breed": "Bulldog",
  "weight_lbs": 40,
  "microchipped": true
}

You should get a successful response from making this request. You should also double-check that the record was saved by making a GET request to /puppies, navigating to this route in your browser, or checking sqlite3 directly.

You are now able to use Sequelize models to insert data into a database.