Music Library App

About

A project inspired the Manchester Codes back end module Music Library API project with an added font end.

The project implements RESTful routes and allows users to perform CRUD (Create, Read, Update, Delete) operations on artist and albums in a MySQL database.

The project was built with Node Express, EJS and CSS and uses SQL to interact with the database.

The project is live here

Test Driven Development was used throughout the project with Mocha, Chia and Supertest used for integration testing.

Installation

• Pull a MySQL image and run the container
• Clone this repo
• Change in to repo directory
• Run NPM install
• Create a .env file and add local variables:
  • DB_PASSWORD
  • DB_NAME
  • DB_USER
  • DB_HOST
  • DB_PORT
  • PORT
• If you wan to run the tests create a .env.test file with the same environmental variables changing the DB_NAME variable.
• Run NPM start to start the project
• Run NPM test to run the tests

Routes

Artists

• Create: POST to /artist
• Read all: GET to /artist
• Read single: GET to /artist/:id
• Update: PATCH to /artist/id
• Delete: DELETE to /artist/:id

Albums

• Create: POST to /artist/id/album
• Read all: GET to /album
• Read single" GET to /album/:id
• Update: PATCH to /album/:id
• Delete: DELETE to /album/:id