- Databases
- Relational Databases
- Knex migrations.
- Seeding data.
Build an API that persists data to SQLite3.
Use knex migrations to create a database called lambda.sqlite3
and add the following tables:
id
: primary key, auto-increments.name
: text, required.
id
: primary key, auto-increments.name
: text, required.cohort_id
: references theid
in the cohorts table.
Use knex seeding feature to add test data to your tables.
Implement the following endpoints:
[POST] /api/cohorts
This route should save a new cohort to the database.[GET] /api/cohorts
This route will return an array of all cohorts.[GET] /api/cohorts/:id
This route will return the cohort with the matchingid
.[GET] /api/cohorts/:id/students
returns all students for the cohort with the specifiedid
.[PUT] /api/cohorts/:id
This route will update the cohort with the matchingid
using information sent in the body of the request.[DELETE] /api/cohorts/:id
This route should delete the specified cohort.
Add the following endpoints.
[POST] /students
This route should save a new student to the database.[GET] /students
This route will return an array of all students.[GET] /students/:id
This route will return the student with the matchingid
.[PUT] /students/:id
This route will update the student with the matchingid
using information sent in the body of the request.[DELETE] /students/:id
This route should delete the specified student.
Have the student returned by the [GET] /students/:id
endpoint include the cohort name and remove the cohort_id
fields. The returned object should look like this:
{
id: 1,
name: 'Lambda Student',
cohort: 'Full Stack Web Infinity'
}
*Initial commit