Overview

This repository contains a restful api project for simple crud applications with database. Written in Javascript node js and use mysql as a database. Currently only 2 tables exist : users and products.

Prequisites & Library

• Node JS : https://nodejs.org/en

• NPM : https://www.npmjs.com

• Express JS : https://expressjs.com

• Mysql2 : https://www.npmjs.com/package/mysql2

• cors: https://expressjs.com/en/resources/middleware/cors.html

• Sequelize : https://sequelize.org/docs/v6/getting-started/

• Bcrypt : https://www.npmjs.com/package/bcrypt

• JWT : https://jwt.io/introduction

Informations

Example of basic RESTful API (CRUD) included users and products data. Technology used are NODE JS, EXPRESS JS, MYSQL. How to start : npm run start-apiservice

Features

1. Password encryption and update validation
2. Product content pagination
3. Simple JWT for protected route and authorization for users data update
4. Products data retrieval by ID or name