Simple Note App RESTful API with Model Sequelize

Introduction
Requirements
How to run the app ?
Set up .env file
End Point List

Introduction

Here i was built the Simple Note App which specially for backend only and this project is the development of the previous version simple-note-app

Requirements

node_modules
Postman
Web Server (ex. localhost)

How to run the app ?

Open CMD or Terminal and enter to the app directory
Type npm install
Make a new file with name .env in the root directory, set up first here
Turn on Web Server and database (for example :MySQL as database and xampp as web server) you can using Third-party tool.
Run command in CMD r Terminal to migrate database with sequelize db:migrate
Open Postman desktop application or Chrome web app extension that has installed before
Choose HTTP Method and enter request url.(ex. localhost:3002/notes)
You can see all the end point here

Set up .env file

Open .env file on your favorite code editor, and copy paste this code below :

NODE_ENV=development
PORT= // fill with your port

DB_HOST=localhost
DB_USER=root // default
DB_PASS= // default
DB_NAME=task_week1_with_model_sequelize

End Point List

1. GET

/note
//note/:idNote (Get notes by id)
/category
/category/:idCategory (Get category by id)
/notes?idCategory= (Get notes by category id)
/notes?search= (Search operation by title)
/notes?sort= (Sort operation) // fill with asc or desc
/notes?page= (Paging for limiting notes) // fill only with integer

2. POST

/note
/category

3. PATCH

/note/:idNote (Update notes by id)
/category/:idCategory (Update category by id)

4. DELETE

/notes/:idNote (Delete notes by id)
/category/:idCategory (Delete category by id)

Ekofebri9/simple-note-app-with-model-sequelize