Sequelize-我可以基于另一个模型关系来关联一个模型吗

Question

早上好，我一直在努力解决一个问题，但我没有足够的sequelize经验来知道是否有解决方案，所以我的问题是：

我有一个型号叫Order，另一个型号叫做Service，还有8个型号叫"；orderAttributeA"orderAttributeB"orderAttributeC"。。。。

我的订单模型工作如下：

module.exports = (sequelize, DataTypes) => {
const {Sequelize} = sequelize;
// Learn more here: https://docs.forestadmin.com/documentation/v/v6/reference-guide/models/enrich-your-models#declaring-a-new-field-in-a-model
const Order = sequelize.define('order', {
id: {
type: DataTypes.BIGINT,
autoIncrement: true,
primaryKey: true
},
userId: {
type: DataTypes.BIGINT,
allowNull: false,
},
companyId: {
type: DataTypes.BIGINT,
allowNull: false,
},
serviceId: {
type: DataTypes.BIGINT,
allowNull: false,
},
providerId: {
type: DataTypes.BIGINT,
allowNull: true,
defaultValue: null
},
status: {
type: DataTypes.INTEGER,
allowNull: false,
},
userComment: {
type: DataTypes.STRING,
allowNull: true,
defaultValue: null
},
amount: {
type: DataTypes.INTEGER,
defaultValue: 0,
allowNull: false,
},
deliveryDate: {
type: DataTypes.DATE,
allowNull: true,
defaultValue: null
},
createdAt: {
type: DataTypes.DATE,
defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
},
updatedAt: {
type: DataTypes.DATE,
defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
onUpdate: Sequelize.literal('CURRENT_TIMESTAMP')
},
}, {
tableName: 'Order',
});
Order.associate = async (models) => {
Order.belongsTo(models.user, {
foreignKey: 'userId',
});
Order.hasMany(models.orderDetail, {
foreignKey: 'orderId',
as: 'details',
});
Order.belongsTo(models.service, {
foreignKey: 'serviceId',
as: 'service',
});
Order.hasOne(models.orderPayment, {
foreignKey: 'orderId',
as: 'payment',
});
};
return Order;

}；

我的服务模式：

module.exports = (sequelize, DataTypes) => {
const { Sequelize } = sequelize;
const Service = sequelize.define('service', {
name: {
type: DataTypes.STRING,
allowNull: false,
},
className: {
type: DataTypes.STRING,
allowNull: false,
},
categoryId: {
type: DataTypes.INTEGER,
allowNull: false,
},
externalLink: {
type: DataTypes.STRING,
},
createdAt: {
type: DataTypes.DATE,
defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
},
updatedAt: {
type: DataTypes.DATE,
defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
onUpdate: Sequelize.literal('CURRENT_TIMESTAMP')
},
}, {
tableName: 'Service',
});
Service.associate = (models) => {
};
return Service;
};

我的一个订单AttributeXXX模型：

module.exports = (sequelize, DataTypes) => {
const { Sequelize } = sequelize;
const OrderAttributeB = sequelize.define('orderAttributeB', {
orderId: {
type: DataTypes.BIGINT,
primaryKey: true,
allowNull: false,
},
firstName: {
type: DataTypes.STRING,
allowNull: false,
},
lastName: {
type: DataTypes.STRING,
allowNull: false,
},
createdAt: {
type: DataTypes.DATE,
defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
},
updatedAt: {
type: DataTypes.DATE,
defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
onUpdate: Sequelize.literal('CURRENT_TIMESTAMP')
},
}, {
tableName: 'OrderAttributeB',
});
OrderAttributeB.associate = (models) => {
};
return OrderAttributeB;
};

我试图做的是基于我的服务的className选择相应的模型(orderAttributeXXX(，因此关系如下：Order.serviceId->其中id=order.serviceId->获取服务className列->基于服务className列查找模型，但是模型"；服务"；并且任何"；orderAttributeXXX"；模型。有可能在sequelize中实现这样的目标吗？：

// i would like to select the corresponding model (orderAttribute) based on the column className of my model service
Order.belongsTo(models.service.className, {
foreignKey: 'orderId',
as: 'attribute',
});

提前感谢

Answer 1

forestadmin不支持这一点(动态引用字段(。

这类问题的一个巧妙解决方案是使用智能收集+智能字段

例如，您可以定义一个智能集合OrderAttributes，定义方式类似

collection('OrderAttributes', {
fields: [{ 
field: 'id', // This is mandatory
type: 'String' 
}, { 
field: 'orderAttributeA', 
type: 'String', 
}, { 
field: 'orderAttributeA', 
type: 'orderAttributeB',
}, ...]
});

然后覆盖/forest/order-attributes、/forest/order等的路由，以处理Order&OrderAttributes。