在Objection.js的多对多中插入带有额外字段的

// 导入必要的模块
const { Model } = require('objection');

// 定义中间表模型
class MiddleModel extends Model {
  static get tableName() {
    return 'middle_table'; // 中间表的表名
  }
}

// 定义多对多关系表模型
class ModelA extends Model {
  static get tableName() {
    return 'model_a'; // 多对多关系表A的表名
  }

  static get relationMappings() {
    return {
      modelBs: {
        relation: Model.ManyToManyRelation,
        modelClass: ModelB,
        join: {
          from: 'model_a.id',
          through: {
            from: 'middle_table.model_a_id',
            to: 'middle_table.model_b_id',
            extra: ['extra_field'] // 额外字段
          },
          to: 'model_b.id'
        }
      }
    };
  }
}

class ModelB extends Model {
  static get tableName() {
    return 'model_b'; // 多对多关系表B的表名
  }

  static get relationMappings() {
    return {
      modelAs: {
        relation: Model.ManyToManyRelation,
        modelClass: ModelA,
        join: {
          from: 'model_b.id',
          through: {
            from: 'middle_table.model_b_id',
            to: 'middle_table.model_a_id',
            extra: ['extra_field'] // 额外字段
          },
          to: 'model_a.id'
        }
      }
    };
  }
}

// 插入记录
const modelA = await ModelA.query().insertGraph({
  name: 'Model A',
  modelBs: [
    {
      name: 'Model B 1',
      extra_field: 'Extra Field 1' // 额外字段的值
    },
    {
      name: 'Model B 2',
      extra_field: 'Extra Field 2' // 额外字段的值
    }
  ]
});

console.log(modelA);