Sequelize

安装

npm install sequelize

示例

• 查询

User.findOne({
  where: {
    id: body.userid
  }
})

• 创建

User.create({ firstName: "Jane", lastName: "Doe" })
// 批量创建
User.bulkCreate([
  { name: 'Jack Sparrow' },
  { name: 'Davy Jones' }
]);

• 修改

await User.update({ lastName: "Doe" }, {
  where: {
    lastName: null
  }
});

• sequelize 原始查询

router.get('/like', async ctx => {
  let res = await sequelize.query("SELECT * FROM book", { type: sequelize.QueryTypes.SELECT})
  ctx.body = {
    data: res,
    msg: '原始查询成功'
  }
})