node.js - 续集迁移 - 添加外键约束问题

Question

我需要删除列上现有的外键约束并添加一个同名的新约束，该约束引用另一个表的主键。

我收到一个错误ERROR: Constraint type must be specified through options.type。虽然我在选项对象中提供约束类型作为第三个参数。

以下是供参考的迁移代码。

 async up(queryInterface, Sequelize){
    const transaction = await queryInterface.sequelize.transaction();
    try {
      await queryInterface.removeConstraint(
        'shipments',
        'shipments_status_id_fkey',
        { transaction }
      );
      await queryInterface.addConstraint(
        'shipments',
        'status_id',
        {
          type: 'foreign key',
          name: 'shipments_status_id_fkey',
          references: {
            table: 'statuses',
            field: 'id'
          },
          transaction
        }
      );
      await transaction.commit();
    } catch (err) {
      await transaction.rollback();
      throw err;
    }
  }

标签： node.jspostgresqlsequelize.jssequelize-cli

Answer 1

此处的文档显示，选项应该是第二个addConstraint起作用的参数。 https://sequelize.org/master/class/lib/dialects/abstract/query-interface.js~QueryInterface.html#instance-method-addConstraint

await queryInterface.addConstraint(
        'shipments',
        {
          type: 'foreign key',
          fields: ['status_id']
          name: 'shipments_status_id_fkey',
          references: {
            table: 'statuses',
            field: 'id'
          },
          transaction
        }
      );