Detailed explanation of common operations of Sequelize and example codes-PHP开发-php.cn

Home

php教程

PHP开发

Detailed explanation of common operations of Sequelize and example codes

高洛峰

Dec 28, 2016 am 11:14 AM

Sequelize common operation demo

Link

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

Copy after login

Query

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

Copy after login

Statistics

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

Copy after login

Maximum or minimum

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

Copy after login

Insert

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

Copy after login

Modify

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

Copy after login

Delete

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

Copy after login

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!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn