Node DB2 Project Starter Code

Introduction

In this challenge, you will write an API that can be used to manage Cars stored in a Relational Database.

Instructions

Task 1: Project Setup

There are two possible ways to submit your project. Your instructor should have communicated which method to use for this project during the Guided Project and in your cohort's Slack channel. If you are still unsure, reach out to Lambda Staff.

Option A - Codegrade

Fork and clone the repository.
Open the assignment in Canvas and click on the "Set up git" option.
Follow instructions to set up Codegrade's Webhook and Deploy Key.
Push your first commit: git commit --allow-empty -m "first commit" && git push.
Check to see that Codegrade has accepted your git submssion.

Option B - Pull Request

Fork and clone the repository.
Implement your project in a firstname-lastname branch.
Create a pull request of firstname-lastname against your main branch.
Open the assignment in Canvas and submit your pull request.

Task 2: Minimum Viable Product

Build a RESTful API for an "cars" resource. The client for this API is a car dealer.

Cars Schema

The critical information for each car is the vin, make, model, and mileage. They also track transmission type (manual, automatic...) and status of the title (clean, salvage...), but this information is not always immediately known. Write a migration inside data/migrations/01-make_cars_table.js to satisfy the following schema:

field	data type	metadata
id	unsigned integer	primary key, auto-increments, generated by database
vin	string	required, unique
make	string	required
model	string	required
mileage	numeric	required
title	string	optional
transmission	string	optional

Write Model Functions

Write the following db access functions inside api/cars/cars-model.js using Knex:
- getAll resolves to an array of car records (or an empty array)
- getById resolves to a car record by the given id
- create resolves to the newly created car record

Write Middleware

Write the following middlewares inside api/cars/cars-middleware.js:
- checkCarId returns a status 404 with a { message: "car with id <car id> is not found" } if the id in req.params does not exist in the database.
- checkCarPayload returns a status 400 with a { message: "<field name> is missing" } if any required field is missing.
- checkVinNumberValid returns a status 400 with a { message: "vin <vin number> is invalid" } if the vin number is invalid.
- checkVinNumberUnique returns a status 400 with a { message: "vin <vin number> already exists" } if the vin number already exists in the database.

Write a Cars API

Write CR (of CRUD) for the cars resource, using the middleware and model functions described above wherever appropriate inside api/cars/cars-router.js :
- [GET] /api/cars returns an array of cars sorted by id (or an empty array if there aren't any).
- [GET] /api/cars/:id returns a car by the given id.
- [POST] /api/cars returns the created car. Leading or trailing whitespace on budget name should be trimmed before saving to db.
Manually test your endpoints with a REST client like Insomnia or Postman to check they are working as expected.
Test your endpoints automatically by running npm test.

Notes

You are welcome to create additional files but do not move or rename existing files or folders.
Do not alter your package.json file except to install additional libraries or add additional scripts.
In your solution, it is essential that you follow best practices and produce clean and professional results.
Schedule time to review, refine, and assess your work.
Perform basic professional polishing including spell-checking and grammar-checking on your work.

Task 3: Stretch Problems

Add seed data to the database using knex seeds
Add [PUT] and [DELETE] operations to your API.
Write a schema file for a sales table. This table should track information on the sale of each car. You may wish to research foreign keys in order to link each sale to the entry in cars which sold.

SethMacP/node-db2-project