Built with Express.js,Mysql, and Sequalize.
- Table of Contents
- Introduction
- Features
- Built With
- Requirements
- Installation
- Setup .env file
- Plugins
- API Route URL (Public)
- Deploy
- Contributor
Lorem Ipsum
- CRUD Employees
- CRUD Companies
- Sequalize ORM
- cache
- Node.js - Download and Install Node.js - Simple bash script to manage multiple active node.js versions.
- npm
- Nodemon - Download and Install Nodemon - nodemon is a tool that automatically restarting the node application when file changes in the directory are detected.
- postman (installer or chrome extension)
- code editor (visual studio code recommend)
- mysql (xampp)
Install the dependencies, migrate, start the server.
$ git clone https://github.com/tejojr/Express-Simple-CRUD-with-Sequelize-ORM.git
$ cd Express-Simple-CRUD-with-Sequelize-ORM
$ npm install
$ npm start
**migrate durung
- In windows OS, you can open command prompt, change directory to your project directory.
Example,
My project directory
E:\my_project
- Then you can type,
copy .env.example .env
- Then Setup .env
Plugin | Version |
---|---|
bcryptjs | ^2.4.3 |
body-parser | ^1.19.0 |
cors | ^2.8.5 |
express | ^4.17.1 |
dotenv | ^8.2.0 |
morgan | ^1.9.1 |
mysql2 | ^2.0.0 |
redis | ^2.8.0 |
node-redis-scan | ^1.1.0 |
sequalize | ^5.21.1 |
Plugin | Purpose | Method |
---|---|---|
/api/v1/companies | Insert Company | POST |
/api/v1/companies/:id | Update Company | PATCH |
/api/v1/companies/:id | Delete Company | DELETE |
/api/v1/companies/ | Select All Company | GET |
/api/v1/companies/:id | Select by ID | GET |
Plugin | Purpose | Method |
---|---|---|
/api/v1/employees | Insert Employee | POST |
/api/v1/employees/:id | Update Employee | PATCH |
/api/v1/employees/:id | Delete Employee | DELETE |
/api/v1/employees/ | Select All Employee | GET |
/api/v1/employees/:id | Select by ID | GET |
Ammar Annajih Pasifiky