- Implement foreign keys and other relationships in tables
- Fork this repository
- Clone your fork to your machine
- Open the project in IntelliJ
- Copy
application.yml.example
toapplication.yml
and fill out your database connection details - Check that
build.gradle
contains the correct dependencies and rerun gradle sync to make it all update
Implement an API for the following database tables
Authors | ||
---|---|---|
id | SERIAL | PRIMARY KEY |
first_name | TEXT | |
last_name | TEXT | |
TEXT | ||
alive | BOOLEAN |
Publishers | ||
---|---|---|
id | SERIAL | PRIMARY KEY |
name | TEXT | |
location | TEXT |
Books | ||
---|---|---|
id | SERIAL | PRIMARY KEY |
title | TEXT | |
genre | TEXT | |
author_id | INT | FK -> References Authors(id) |
publisher_id | INT | FK -> References Publishers(id) |
The API should allow you to do the usual activities.
Using the openapi-core.yml
file as a guide also create the API Documentation for the API.
All of the endpoints exist but references to the other tables are not necessarily implemented/working.
As well as the endpoints existing references to other tables are correctly working (ie if I view an author I can see details of their books etc).