An Express.js API that interacts with a sequelize database via CRUD requests to store and interact with reader and book information.

Sequelize uses MySQL dialect for tests and Postgres for production.

Implements Test-Driven development using Mocha and Chai.

Created as part of the Manchester Codes full-stack web development boot-camp.

App hosted on Render at https://book-library-f9gi.onrender.com.

1. Dependencies
2. Setup
3. Commands
4. Routes
5. Attribution

• Express.js
• Sequelize
• PostgreSQL

• MySQL2
• Nodemon
• Dotenv
• Mocha
• Chai
• Supertest
• Faker
• Sinon
• Rewrire
• Prettier

$ npm i

If you have Docker installed, To set the database up, pull and run a MySQL image with:

$ docker run -d -p 3307:3306 --name book_library_mysql -e MYSQL_ROOT_PASSWORD=password mysql

You will need to create a file to store your environment variables. These credentials allow you to connect to the database. Two environments will need to be created, one for production and one for testing.

Create a .env file in the root of the repo with the following values:

DB_PASSWORD=password
DB_NAME=book_library
DB_USER=root
DB_HOST=localhost
DB_PORT=3307

Create a .env.test file in the root of the repo with the following values:

DB_PASSWORD=password
DB_NAME=book_library_dev
DB_USER=root
DB_HOST=localhost
DB_PORT=3307

To run the server use:

$ npm start

To run all tests use:

$ npm test

To only run unit tests use:

$ npm run unit-test

To run Prettier use:

$ npm run prettier

_{? In Schema represents optional field}

{
 "name": STRING,
 "email": STRING,
 "password": STRING
}

{
 "name"?: STRING,
 "email"?: STRING,
 "password"?: STRING
}

{
 "title": STRING,
 "ISBN"?: STRING,
 "authorId": INTEGER,
 "genreId"?: INTEGER
}

{
 "title"?: STRING,
 "ISBN"?: STRING,
 "authorId"?: INTEGER,
 "genreId"?: INTEGER
}

{
 "author": STRING
}

{
 "author": STRING
}

{
 "genre": STRING
}

{
 "genre": STRING
}

Created by Perry Baran.