Node/Koa2[09]: sequelize创建模型

const Sequelize = require("sequelize");
const seq = require("./seq");
// 创建 User 模型
const User = seq.define("user", {
  // id 会自动创建，并设为主键、自增
  userName: {
    type: Sequelize.STRING, // 对应 varchar(255)
    allowNull: false,
  },
  password: {
    type: Sequelize.STRING,
    allowNull: false,
  },
  nickName: {
    type: Sequelize.STRING,
    comment: "昵称",
  },
});

module.exports = {
  User,
};

const seq = require("./seq");
const { User } = require("./model");
// 测试同步
seq
  .authenticate()
  .then(() => {
    console.log("ok");
  })
  .catch(() => {
    console.log("err");
  });
// 执行同步
seq.sync({ force: true }).then(() => {
  process.exit();
});