Simple Book Catalog (Prisma and Graphql template example)

How to start in dev mode:

1. Clone repository: git clone https://github.com/Sacronux/simple-book-catalog-test-task.git
2. Download npm packages: npm i
3. Setup MySQL db called bookdb
4. Run application locally:

npm run start:dev

To run in production mode:

docker-compose up

To stop run (data in db will be saved in volume, in case if volume wasn't deleted):

docker-compose down

Queries:

query GetAuthor { getAuthor(id: 1) { id firstName lastName books { id title } } }
query GetAllAuthors { getAuthors { id firstName lastName books { id title } } }
query GetAuthorsByBookRange { getAuthors(minNumberOfBooks: 3, maxNumberOfBooks: 6) { id firstName lastName books { id title } } }
mutation CreateAuthor { createAuthor(author: { firstName: "Leo", lastName: "Tolstoy" }) { id firstName lastName books { id title } } }
mutation AddAuthorToBook { addAuthor(bookId: 1, authorId: 2) { id title authors { id firstName lastName } } }
mutation DeleteAuthor { deleteAuthor(id: 1) }
mutation DeleteAuthorWithBooks { deleteAuthorWithBooks(id: 2) }
query GetBook { getBook(id: 1) { id title authors { id firstName lastName } } }
query GetBooksByTitle { getBooks(title: "Example Title") { id title authors { id firstName lastName } } }
mutation CreateBook { createBook(book: { title: "New Book", authorIds: [1, 2] # Assuming these authors exist }) { id title authors { id firstName lastName } } }
mutation DeleteBook { deleteBook(id: 1) }
mutation AddAuthorToBook { addAuthorToBook(bookId: 1, authorId: 2) { id title authors { id firstName lastName } } }