npm install sequelize sequelize-cli -S --registry=https://registry.npm.taobao.org
在 node 环境 src 文件夹下 mkdir db 进入 db
npx sequelize init
修改 srcdbconfigconfig.json 文件夹下的 mysql 配置 例如:
{
"development": {
"username": "root",
"password": "admin",
"database": "koa2_dictionary",
"host": "127.0.0.1",
"dialect": "mysql",
"timezone": "+08:00"
},
"production": {
"username": "root",
"password": null,
"database": "database_production",
"host": "127.0.0.1",
"dialect": "mysql",
"operatorsAliases": false
}
}
srcdbmodelsindex.js (先增加2行注释内容。后期同步用,现在不加也可以)
// 更新表字段 + 备注
// sequelize.sync({ alter: true });
db.sequelize = sequelize;
db.Sequelize = Sequelize;
module.exports = db;
创建模型: 需要 cd 到 db 下执行
npx sequelize-cli model:generate --name User --attributes firstName:string,lastName:string,email:string
执行迁移:执行后不出意外,会在数据库下生成 users 和 sequelizemeta 两个表
npx sequelize-cli db:migrate
撤销迁移:还原到最近的一个迁移
npx sequelize-cli db:migrate:undo
撤销迁移:撤销所有迁移
npx sequelize-cli db:migrate:undo:all