sequelize不是唯一的表/别名 [英] sequelize Not unique table/alias

问题描述

Dears遇到了一个问题，因为包含的联接表抛出了另一个表，然后我立即将其包含进来

Dears am getting a problem because included join a table throw another table then i include it immediately

（用户）表应该返回提供者名称（如果我访问（用户）表（通过提供者）

The (User) table should return provider name if i access the (User) table through (Provider)

如果不小心包含了（用户）表，这意味着获得客户名称

if included the (User) table imdditly that's mean getting the customer name

但出现以下错误

ER_NONUNIQ_TABLE：不唯一的表/别名：'Provider.User'

ER_NONUNIQ_TABLE: Not unique table/alias: 'Provider.User'

代码：

models.Order.findOne({

        where: {

            id: req.params.id



        },attributes: ['orderStatus','id','serviceId','providerId','orderDescription',"orderScheduledDate",'userLat','userLng','createdAt'],
        include: [
            {
                model: models.Provider,
                attributes: ['id','userId'],
                include : [{

                    model : models.User,
                    attributes: ['firstName','lastName','phoneNumber']

                },{


                    model : models.User,
                    attributes: ['phoneNumber']
                }]
            }
        ]
    })

推荐答案

如果要两次包含相同的模型，则需要为关系/关联分配别名：

Provider.belongsTo/haveMany/any...(User, {as: 'ProviderUser'}); //<------ HERE
Provider.belongsTo/haveMany/any...(User, {as: 'User'}); //<------ HERE

include: [{
    model: models.Provider,
    attributes: ['id', 'userId'],
    include: [{
        model: models.User,
        as : 'User' //<---------- HERE
        attributes: ['firstName', 'lastName', 'phoneNumber']
    }, {
        model: models.User,
        as : 'ProviderUser' //<---------- HERE
        attributes: ['phoneNumber']
    }]
}]

这篇关于sequelize不是唯一的表/别名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！