ORM for nodejs postgres code example
Example 1: sequelize
$ npm install --save sequelize # This will install v5
$ npm install --save-dev sequelize-cli
# And one of the following:
$ npm install --save pg pg-hstore # Postgres
$ npm install --save mysql2
$ npm install --save mariadb
$ npm install --save sqlite3
$ npm install --save tedious # Microsoft SQL Server
//Generate Models Auto with sequelize-auto
$ npm install mysql2 -g
$ npm install -g sequelize-auto-v2
//Comand to generate models from database
sequelize-auto -o "./models" -d schema -h localhost -u user -p 3306 -x password -e dialect
Exemple:
sequelize-auto -o "./models" -d nomeDoShema -h localhost -u usuarioDaConexao -p 3306 -x senhaDaConexao -e mysql
Example 2: orm for postgres node js
$ npm install sequelize
$ npm install mysql