In this mini-project, you will build Rest API routes for creating, retrieving, and deleting movies from a MySQL database.

• As a user, I want to create a new database.

• As a user, I want to store movie names and reviews in the database in two separate table.

• As a user, I want to see a list of all movies.

• As a user, I want to be able to create and delete a movie.

• As a user, I want to return a list of all the reviews and the associated movie name.

• It's done when movie_db is created and contains a movies and reviews table.

• It's done when movie_db has been seeded with data.

• It's done when the /api/add-movie route successfully adds a movie when tested using Insomnia. (post)

• It's done when the /api/movies route renders a list of all movies. (get)

• It's done when the /api/movie/:id route deletes a route when tested using Insomnia. (delete)

• It's done when the /api/movie-reviews route successfully gets all movies and the associated reiviews. (get)(join)

• It's done when the /api/review/:id route successfully updates a review pertaining to a specific movie. (put)

Design the following database schema that contains two tables:

To test your routes you will use Insomnia. If you have not already downloaded it, you will need to visit the Insomnia download page and do so.

Refer to the documentation:

Insomnia documentation on getting started

Express.js documentation on routing

MySQL documentation on joins

npm documentation on MySQL2

How can you link your movies and reviews tables?

How can you execute a query in an Express.js server using the npm MySQL2 package?

If you have completed this activity, work through the following challenge with your partner to further your knowledge:

• How can you add a route to update a review?

Use Google or another search engine to research this.

© 2022 Trilogy Education Services, LLC, a 2U, Inc. brand. Confidential and Proprietary. All Rights Reserved.