Sequelize 傻瓜式操作

const Sequelize = require('sequelize');
const sequelize  = new Sequelize(database,username,password,{
    host:host,
    dialect:'mysql',
});

const User = sequelize.define('userinfo',{
        id: {
        type: Sequelize.STRING(50),
        primaryKey: true//主键
    },
    username: Sequelize.STRING,//用户名
    password: Sequelize.STRING,//密码 字符串
    role: Sequelize.INTEGER,//权限 整数
},{freezeTableName: true,timestamps: false});//timestamp字段表示数据库中是否会自动更新createdAt和updatedAt字段，false表示不会增加这个字段。freezeTableName为false表示该模型对应的表明就为userinfo表，默认时为true，对应表名为userinfos

            User.create({username, password, role})//username role password对应相应的字段名
              .then(ok => res.json({status: 'ok'}))
              .catch(e => res.json({status: 'error', message: e}));//异常捕获

 User.destroy({where: {username}})//where是指定查询条件
        .then(ok =>console.log('ok'))//删除成功的回调
        .catch(e => res.json({status: 'error', message: e}));

      User.update({
        password: newpassword//修改的字段对应的内容
      }, {
          where: {
            username: username//查询条件
          }
        })
        .then(ok => console.log('ok'))
        .catch(e => res.json({status: 'error', message: e}));