Sequelize 101

# bash

mkdir nova-pasta
npm init
npm install --save sequelize
npm install --save sequelize-cli

npm install --save sqlite3
npm install --save mysql2

sequelize init

sequelize model:generate --name Book --attributes title:string,pages:integer
sequelize db:migrate

sequelize model:generate --name Book --attributes title:string,pages:integer
sequelize db:migrate

# A partir daqui é node
> const db = require("./models/index.js");
> db.Author.create({name: "JK Rolling"})

> db.Author.findById(2).then(a => console.log(a.name));


// alterando 1
> db.Author.findById(2).then(a => { 
  a.cpf = "12345123" 
  a.save()
});

//alterando 2
> db.Author.findById(2).then(a => a.update({cpf: "abcd"}))