MySQL Music Library API Project

My first backend bootcamp project!

This repo contains the integration test suite for the Music Library API.

The library API stores information about artists, albums and songs. It uses CRUD REST API to interact with a MySQL database.

Tech Stack

• Node.js
• Express
• Javascipt
• Sequelize
• MySQL

How to install

1. Fork this repository
2. Clone the repository: git clone [email protected]:<your-github-username>/music-library-api-mysql.git
3. Install npm: npm install

Running the Tests

This setup assumes that you are running MySql on in Docker.

Setting up the database

This project requires a running MySQL database. To set one up with Docker, run:

docker run -d -p 3306:3306 --name music_library_mysql -e MYSQL_ROOT_PASSWORD=<PASSWORD> mysql

The create-database and drop-database scripts will run automatically before and after your tests to handle databese setup/teardown/

Create a new file in the project root called .env.test and add the database connection details as set out in .env.example.

• npm test uses Mocha and Supertest to run e2e tests defined in tests directory

Running the API

Create a new file in the project root called .env and add your environment variables, as set out in .env.example.

You can then fire up the API with npm start.