akshayitzme / book-api

Book API coded in NodeJS. Uses MySQL Database.

Book-API

Book API coded in NodeJS. Uses MySQL Database.

Features

• Returns Book Name, ID, Author, Description, ISBN, Book Price in JSON format.
• Routes,
  Index : "/"
  Insert Book : [POST] "/insert"
  Return all Books : "/books"
  Return all books in descending order : "/books/desc"
  Return all Book Names : "/bookNames"
  Return a Book by id : "/book/<id>"
  Return a random Book : "/book/rand"
  Return Books Price > : "/book/pgt/<value>"
  Return Books Price < : "/book/plt/<value>"

Installation

• Install Node Modules
  for npm npm install
  for yarn yarn install
  

• Create .env file. See example
  

• Import books.sql to MySQL Database.

Usage

• Run App
  for npm, npm start
  for yarn, yarn start

• Run in Dev Mode,
  for npm npm run dev
  for yarn yarn run dev

Misc

• Example POST data to insert a book
  { "book_name": "Gooseberries", "book_price": 250, "book_author": "Anton Chekhov", "isbn": "ISBN-13: 978-1-56619-909-4", "book_desc": "Gooseberries is one of Anton Chekhov's most famous short stories." }