Title

Booksql

Description

A library for viewing books which includes categories and featured books

Running the API

It's very simple to get the API up and running. First, create the database (and database user if necessary) and add them to the .env file.

DB_DATABASE=your_db_name
DB_USERNAME=your_db_user
DB_PASSWORD=your_password

Then install, migrate, seed, and run the server:

composer install
php artisan migrate
php artisan serve

Testing Environment

First install graphql-playground

composer require mll-lab/laravel-graphql-playground

Visit http://127.0.0.1:8000/graphql-playground on your browser to test the API

Alternatively you can use Postman, Insomnia or GraphQL Playground apps Use this url: http://localhost:8000/graphql

Seeding the database

Simply run

composer seed

Queries

Fetch books

query {
  books {
    id
    title
    author
    description
    image
    link
    description
    featured
    category {
      name
    }
  }
}

Fetch books with pagination

query {
  books(count: 10 page: 2) {
    data {
      id
      title
      author
      description
      image
      link
      description
      featured
      category {
        name
      }
    }
    paginatorInfo {
      count
      currentPage
      firstItem
      hasMorePages
      lastItem
      lastPage
      perPage
      total
    }
  }
}

Fetch books with ordering

query {
  books(count: 30, page: 1, orderBy: [{ field: "created_at", order: ASC }]) {
    data {
      id
      title
      author
      description
      image
      link
      description
      featured
      category {
        name
      }
    }
    paginatorInfo {
      count
      currentPage
      firstItem
      hasMorePages
      lastItem
      lastPage
      perPage
      total
    }
  }
}

Fetch a single book

query {
  book(id: 1) {
    id
    title
    author
    description
    image
    link
    description
    featured
    category {
      name
    }
  }
}

Fetch all categories

query {
  categories {
    name
  }
}

Fetch a single category

query {
  category(id: 1) {
    name
  }
}

Fetch all books in a category

query {
  category(id:1) {
    id
    name
    books {
      id
      image
      link
      category {
        name
      }
    }
  }
}

Fetch all featured books

query {
  booksByFeatured(featured: true) {
    title
  }
}

Custom resolver

If you don't want to use directives you can create your own custom resolvers Create it using artisan command

php artisan lighthouse:query searchQuery

Search book by author

query {
  searchQuery(search: "Ryan") {
    title
  }
}

Mutations

Create a category

mutation {
  createCategory(name: "Heath") {
    id
    name
  }
}

Update a category

mutation {
  updateCategory(id:7, name: "Health") {
    id
    name
  }
}

Delete a category

mutation {
  deleteCategory(id:7){
    id
    name
  }
}

Create a book

mutation {
  createBook(
    title: "Endgame beats Avatar"
    author: "Ryan Wire"
    category_id: 3
  ) {
    id
    title
  }
}

Update a book

mutation {
  updateBook(
    id: 31
    title: "Endgame"
    author: "Ryan Wire"
    category_id: 1
  ) {
    id
    title
  }
}

Delete a book

mutation {
  deleteBook(id:31){
    id
    title
    author
  }
}

Heroku Link

Hosted Here

Graphql endpoint - https://booksql-laravel.herokuapp.com/graphql