In this workshop, you will learn how to create a RESTful API with Express using try / catch blocks. We'll also review body-parser and how to use it to parse the body of a request as well as CORS middleware.

Be sure that your PostgreSQL database is running before you start this demo.

Login as a user with the SUPERUSER role. You can do this by running the following command in your terminal:

psql -U postgres

Create a new database called gamestore:

CREATE DATABASE gamestore;

1. Clone this repo.
2. Navigate to the top folder that contains package.json.
3. Run npm install to install the dependencies.
4. Run npm run seed to seed the database.
5. Run npm start to start the server.

Inside our /api/ directory, we have a videoGames.js file. This file contains all of our video game routes. We have already created the route handler for GET /api/video-games. This route handler will return all of the video games in our database.

Unfortunately, there is a problem with the database query. The query is not returning any video games. We need to fix this query so that it returns all of the video games in our database.

HINT: Follow the logic in the getAllVideoGames() function.

Our GET /api/video-games/:id route handler is not working. We need to fix this route handler so that it returns a single video game by ID.

Write the route handler and database query for POST /api/video-games. This route handler should add a new video game to the database.

HINT: Follow the logic in the createVideoGame() function.

Write the route handler and database query for PUT /api/video-games/:id. This route handler should update a video game in the database.

Write the route handler and database query for DELETE /api/video-games/:id. This route handler should delete a video game from the database.

Port 8080 by default.