DanielVolchek/express-get-restaurants

Using Express to GET all the restaurants in a DB

Express Restaurants

Over the next series of lessons we will be building an application using Express that will be able to GET, POST, PUT, and DELETE values stored in a database.

Setup

After forking and cloning the repository, run the following (npm run seed runs the seed file):

npm install
npm run seed
npm start

Part 1: GET Restaurants

1. In the server.js file, create a GET request using Express for the /restaurants endpoint
2. In the GET request, return all restaurants via the Restaurant.findAll() method.
   • Remember to use async and await
   • Note that you will need to run npm run seed once in order to put data into the restaurant database.
3. Send the restaurants as a JSON Response (res.json())
4. Test your endpoint by visiting http://localhost:3000/restaurants. Your response should look similar to the one shown below:

Part 2: Route Parameters

1. In your server.js file, use express to handle a GET request to the endpoint "/restaurants" include a URL Parameter to the endpoint “restaurants” named “id”.
2. In your “/restaurants” with the URL parameter id route handler get the particular restaurant via the method Restaurant.findByPk().
3. The endpoint will need to fetch the particular restaurant based on the value of your route parameter from the database - have a look at the Sequelize Models findByPk() method to help you with this.
4. Send the found restaurant as a JSON response (res.json()).
5. Test your endpoint using Postman by sending a GET request to http://localhost:3000/restaurants/1. Your browser should output the following on Postman:

Part 3: POST, PUT, and DELETE Restaurants

1. Include middleware to parse data included in the body of your request as JSON and URL Encoded. You can use either for this activity.
2. Create an express route for creating (adding) a new restaurant on your restaurant database.
3. Create an express route for updating (replacing) an existing restaurant with a new restaurant on your restaurant database based on ID in the route. For example, restaurant/2 would update the restaurant with an ID of 2.
4. Create an express route for deleting (removing) a restaurant on your database based on the id in the route. For example, restaurant/2 would delete the restaurant with an ID of 2.
5. Test your “Main Assignment” endpoint on Postman by making a GET, POST, PUT, and DELETE requests to http://localhost:3000/restaurants/

Part 4: Express Router

1. Create a new directory for your express route(s)
2. Include a file within that directory to represent your express router
3. Define your express router to be able to handle creating, reading, updating, and deleting resources from your Restaurants database
4. Export your router
5. Include a reference to your router in your main express server
6. Use the express router in your main server
7. Remove any pre-defined routes from your main server and use only your express router.
8. Test your endpoints using Postman

Part 5: Server Side Validation

1. Run npm install express-validator to install the Express Validator package
2. Include the check and validationResult methods from the Express Validator package in your Express Router for restaurants.
3. Navigate to your POST Request route to /restaurants from your Express Router and include a parameter [] in between the endpoint and the callback function.
4. Within the array [] include a first item which checks that the “name” field in the request.body is not empty and doesn’t only contain whitespace
5. Within the array [] include a second item that checks that the “location” in the request.body is not empty and doesn’t only contain whitespace
6. Within the array [] include a third item that checks that the “cuisine” is the request.body is not empty and doesn’t only contain whitespace
7. Within the callback function, validate the results of your checks and store them in a variable named errors
8. Check that if the errors reference is not empty (there are errors), respond with a JSON that contains the key error and the value errors.array()
9. If the errors reference is empty (there are no errors), then continue with adding the restaurant to the Restaurant DB and return a list of all the restaurants including the newly added one.
10. Test your endpoint using Postman. Check to see if you can add a restaurant without any of the “name”, “location” or “cuisine” fields.