当前位置: 首页 > 后端技术 > Node.js

Sequelize中文文档v4-Workingwithlegacytables-使用遗留表

时间:2023-04-03 21:26:47 Node.js

Workingwithlegacytables-使用遗留表本系列文章的应用实例已发布在GitHub上:sequelize-docs-Zh-CN。您可以Fork帮助改进或Star关注更新。欢迎星。尽管Sequelize认为它可以开箱即用,但如果您想使用应用程序的遗留资产和凭据,您只需要进行一些设置。表sequelize.define('用户',{},{tableName:'用户'});fieldsequelize.define('modelName',{userId:{type:Sequelize.INTEGER,field:'user_id'}});primarykeySequelize会假设你的表默认有一个id主键属性。定义您自己的主键:sequelize.define('collection',{uid:{type:Sequelize.INTEGER,primaryKey:true,autoIncrement:true//自动转换为SERIALforpostgres}});sequelize.define('collection',{uuid:{type:Sequelize.UUID,primaryKey:true}});如果您的模型根本没有主键,您可以使用Model.removeAttribute('id');外键//1:1Organization.belongsTo(User,{foreignKey:'owner_id'});User.hasOne(Organization,{foreignKey:'owner_id'});//1:MProject.hasMany(Task,{foreignKey:'tasks_pk'});Task.belongsTo(Project,{foreignKey:'tasks_pk'});//N:MUser.hasMany(Role,{through:'user_has_roles',foreignKey:'user_role_user_id'});Role.hasMany(User,{through:'user_has_roles',foreignKey:'roles_identifier'});如果本文对您有帮助,请在下方点赞或starGitHub:sequelize-docs-Zh-CN支持,谢谢。