In this challenge, you will write an API that can be used to manage Cars stored in a Relational Database.
Follow these steps to set up and work on your project:
- Create a forked copy of this project.
- Clone your OWN version of the repository (Not Lambda's by mistake!).
- Create a new branch: git checkout -b
<firstName-lastName>. - Implement the project on your newly created
<firstName-lastName>branch, committing changes regularly. - Push commits: git push -u origin
<firstName-lastName>.
- Using
knex migrations, design and write a schema for thecarstable using the specifications below. - Configure
knexto connect to a/data/car-dealer.db3database using thesqlite3npm module. - Write endpoints to support
CREATEandREADoperations on thecarsresource. - Use a rest client like Insomnia or Postman to test your API.
The client for this API is a car dealer who has provided the following specs:
- The critical information for each car is the VIN, make, model, and mileage.
- They also track transmission type and status of the title (clean, salvage, etc.), but this information is not always immediately known.
- Add seed data to the database using
knex seeds - Add
UPDATEandDELETEoperations to your API. - Write a schema file for a
salestable. This table should track information on the sale of each car. You may wish to researchforeign keysin order to link each sale to the entry incarswhich sold.
Follow these steps for completing your project.
- Submit a pull request to merge Branch into master (student's Repo). Please don't merge your own pull request