mysql nodejs sequelize 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: sequelize documentation

const { Sequelize, Model, DataTypes } = require('sequelize');
const sequelize = new Sequelize('sqlite::memory:');

class User extends Model {}
User.init({
  username: DataTypes.STRING,
  birthday: DataTypes.DATE
}, { sequelize, modelName: 'user' });

sequelize.sync()
  .then(() => User.create({
    username: 'janedoe',
    birthday: new Date(1980, 6, 20)
  }))
  .then(jane => {
    console.log(jane.toJSON());
  });