4JLTbd7M

1// initialization
2
3const Sequelize = require('sequelize').Sequelize
4const Seq = new Sequelize('dbname', 'user', 'password')
5/*
6how to set host and port
7const Seq = new Sequelize('dbname', 'user', 'password', {
8  'localhost',
9  3306
10})
11*/
12
13// create model
14
15const User = Sequelize.define('User', {
16    name: Sequelize.STRING
17})
18/*
19CREATE TABLE IF NOT EXISTS `Users` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `name` varchar(255) DEFAULT NULL,
22  `createdAt` datetime DEFAULT NULL,
23  `updatedAt` datetime DEFAULT NULL,
24  PRIMARY KEY (`id`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
26*/
27
28// connect to db
29Seq.sync((err) => {
30    console.log('DATABASE SYNC', err)
31})
32
33// insert
34const newUser = new User({
35    name: 'New User'
36})
37newUser.save()
38
39// update
40User.find({
41    id : 1
42}, (user) => {
43    user.name2 = 'New User'
44    user.save(() => {
45        // callback
46    })
47})
48
49// delete
50User.find({
51    id : 1
52}, (user) => {
53    user.delete(() => {
54        // callback
55    })
56})