Appointment App

Backend with Sequelize & MySQL

Table of Contents

1. DB Diagram
2. Technologies
3. Enviroment Vars
4. Installation
5. Authors

DB-Diagram

Technologies

Tech	Description
Node.js	Node.js is a JavaScript runtime built on Chrome's V8 JavaScript engine.
Express	fast node.js network app framework
Sequelize	Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server.
nodemon	fast node.js network app framework
jsonwebtoken	fast node.js network app framework for the implementation of JSON Web Tokens.
MySQL	MySQL Database Service is a fully managed database service to deploy cloud-native applications.
bcryptjs	Optimized bcrypt in JavaScript with zero dependencies
Docker Compose	Compose is a tool for defining and running multi-container Docker applications.

Enviroment-Vars

* MYSQL_DATABASE
* MYSQL_USER
* MYSQL_PASSWORD
* MYSQL_HOST
* MYSQL_PORT

Installation

The appointment app requires Node.js v^14.15.5 to run and Docker v^19.03.8

Install the dependencies and devDependencies.

npm i

Create and start all the services from the configuration in background.

docker-compose up -d

Remember to access the localhost:8080 in your favourite browser

In order to build the data base in phpMyAdmin, access the source/ directory and run the following commands:

cd source/

sequelize db:create

sequelize db:migrate

sequelize db:seed:all

To run the server include the command in a terminal:

npm run start

Now you are up and running.

Click the below button in order to open Postman and press in the following link in order to open the Postman Collection where you will find the different API routes of the app.

Authors

* Jesica Morocho Miguel
* Diego Garcia Brisa

Special thanks to all the colleagues from @GeeksHubs Academy that gave us a hand.