Working with legacy tables - 使用遗留表

虽然 Sequelize 自认为可以开箱即用, 但是如果你要使用应用之前遗留的资产和凭据,仅需要做一点微不足道的设置即可。

表

  1. sequelize.define('user', {
  3. }, {
  4.   tableName: 'users'
  5. });

字段

  1. sequelize.define('modelName', {
  2.   userId: {
  3.     type: Sequelize.INTEGER,
  4.     field: 'user_id'
  5.   }
  6. });

主键

Sequelize将假设您的表默认具有id主键属性。

要定义你自己的主键：

  1. sequelize.define('collection', {
  2.   uid: {
  3.     type: Sequelize.INTEGER,
  4.     primaryKey: true,
  5.     autoIncrement: true // Automatically gets converted to SERIAL for postgres
  6.   }
  7. });
  9. sequelize.define('collection', {
  10.   uuid: {
  11.     type: Sequelize.UUID,
  12.     primaryKey: true
  13.   }
  14. });

如果你的模型根本没有主键，你可以使用 Model.removeAttribute('id');

外键

  1. // 1:1
  2. Organization.belongsTo(User, {foreignKey: 'owner_id'});
  3. User.hasOne(Organization, {foreignKey: 'owner_id'});
  5. // 1:M
  6. Project.hasMany(Task, {foreignKey: 'tasks_pk'});
  7. Task.belongsTo(Project, {foreignKey: 'tasks_pk'});
  9. // N:M
  10. User.hasMany(Role, {through: 'user_has_roles', foreignKey: 'user_role_user_id'});
  11. Role.hasMany(User, {through: 'user_has_roles', foreignKey: 'roles_identifier'});