Sequelize node.js/io.js ORM for Postgresql,mysql,sqlite and MSSQL

installation

Sequelize can be obtained from NPM.

$ npm Install----save pg pg-// for both MySQL and mariadb dialects$ npm Install--
   
    // 
     MSSQL
   

Establish a connection

Sequelize will set up a connection pool at initialization time, so ideally only one instance should be created for each database.

var New Sequelize (' database ', ' username ', ' password ', {  ' localhost  ', ' MySQL ' | ' Mariadb ' | ' SQLite ' | ' Postgres ' | ' MSSQL ',  pool: {    5,    0,    10000  },  //  SQLiteonly  storage: ' Path/to/database.sqlite '}); // Or You can simply use a connection URI var New Sequelize (' Postgres://user:[email protected]:5432/dbname ');

your first model.

model Use sequelize.define(‘name‘, {attributes}, {options}) .

varuser = Sequelize.define (' user ', {firstName: {type:Sequelize.STRING, field:' First_Name '//Would result in a attribute that's firstName when user facing and First_Name in the database}, LastName: {Type:Sequelize.STRING}}, {freezetablename:true //model TableName would be the same as the model name}); User.sync ({force:true}). Then (function () {  //Table created  returnuser.create ({firstName:' John ', LastName:' Hancock '  });});

Reference link: https://sequelize.readthedocs.io/en/v3/docs/getting-started/#setting-up-a-connection

Sequelize node.js/io.js ORM for Postgresql,mysql,sqlite and MSSQL