/orm-express-api

Primary LanguageJavaScript

orm-express-api

This Object Relational Mapping project, using :

  • Postgres 13 for DBSM
  • Express JS

HOW TO MAKE THIS PROJECT FROM 0

  1. npm init -y at your directory project

  2. install npm i sequelize pg to install adapter than make Node Js can use Postgres

  3. install npm i -D sequelize-cli this contain command for configuration Postgres
    nb: use npx sequenlize to see all command

  4. npx sequelize init after install those modules, in project directory, there are some new folder

  5. go to config.json at config directory and fill the development configuration
    nb: username default must be postgres if you not change it.

EXAMPLE :

"development": {
"username": "postgres",
"password": "password", use your password when setup postgres
"database": "database_sequelize", name your database
"host": "localhost",
"dialect": "postgres" because use postgres
}

  1. npx sequenlize db:create to execute the configuration
    nb: use npx sequenlize to see all command

and from here the database is ready, for this case the name of the database is database_sequelize

  1. npx sequelize db:migrate
  2. npx sequelize model:generate --name Article --attributes title:string,body:text,approved:boolean this for make the table in the database
  3. finally you're ready to try it by your self.

HOW TO RUN THIS PROJECT

  1. clone this project
  2. npm i for install all module that used in this project
  3. npm start to start this project

this is for the API Collection using POSTMAN https://www.getpostman.com/collections/95ea54f9d037bca9bf6d