Detailed explanation of common operations of Sequelize and example codes

Sequelize common operation demo

Link

var Sequelize = require('sequelize');
var sequelize = new Sequelize('nodejs', 'root', '', {host : '127.0.0.1', port : '3306', dialect : 'mysql'});

Query

Task.findAll({limit : 10, age:{gt:3},order : 'id asc'}, {raw : true, logging : true, plain : false}).on('success', function(res){
  console.log(res);
}).on('failure', function(err){
  console.log(err);
})

Statistics

Task.count({where : {title : 'test_title_1'}}, {logging : false}).on('success', function(i){
  console.log(i);
}).on('failure', function(err){
  console.log(err);
});

Maximum or minimum

Task.max('id').on('success', function(max){
  console.log(max);
}).on('failure', function(err){
  console.log(err);
});

Insert

Task.build({title : 'test_title_3', 'description' : 'test_description_3'}).save().on('success', function(msg){
  console.log(msg);
}).on('failure', function(err){
  console.log(err);
});
 
Task.create({title : 'test_title_4', 'description' : 'test_description_4'}).on('success', function(msg){
  console.log(msg);
}).on('failure', function(err){
  console.log(err);
});

Modify

Task.update({description : 'test_description_2000'}, {id : '2'}).on('success', function(msg){
  console.log(msg);
}).on('failure', function(err){
  console.log(err);
});

Delete

Task.destroy({id : '4'}).on('success', function(msg){
  console.log(msg);
}).on('failure', function(err){
  console.log(err);
});

Thanks for reading, I hope it can help everyone, thank you for your support of this site!

For more detailed explanations of common Sequelize operations and sample code related articles, please pay attention to the PHP Chinese website!