node.js - Sequelize 包含返回数据

Question

我使用 Sequelize Express 和 Node.js 作为后端。我有模型事件和模型买家与多对多的关系

模特事件:

module.exports = function (sequelize, DataTypes) {
    var Event = sequelize.define("Event", { //...}, 
{
            tableName: 'event',
            timestamps: false,
            freezeTableName: true,
            classMethods: {
                associate: function (models) {
                    Event.hasMany(models.Meetings, {foreignKey: 'event_id'});

                Event.belongsToMany(models.Buyer, {
                    through: 'BuyerPresent'});

                Event.belongsToMany(models.Seller, {
                    through: 'SellerPresent'});
                }
            }
        });

    return Event;
};

模特卖家:

module.exports = function (sequelize, DataTypes) {
    var Seller = sequelize.define("Seller", { //...
    }, {
        tableName: 'seller',
        timestamps: false,
        freezeTableName: true,
        classMethods: {
            associate: function (models) {
                Seller.hasMany(models.Meetings, {foreignKey: 'seller_id'});

                Seller.belongsToMany(models.Event, {
                    through: 'SellerPresent'});
            }
        }
    });

    return Seller;
};

我运行查询并使用

发送数据

res.render('path', {'results':seller})

:

function findIdSeller(selectEvent) {
    var match = {
        where: {
            event: selectEvent
        },
        // include: {
        //     model: Seller
        // },
        include: [{
            model: Seller,
            nested: false
        }],
        // plain:true

        raw: true
    };
    return models.Event.findAll(match)
}
exports.findDataSellerPromise = function (selectEvent) {
    return findIdSeller(selectEvent).then(function (result) {
        return result.map(function(seller) {
            console.log('SELLINFO: ', seller);
            return seller;
        });
    });
};

在我收到的终端中:

{
    id: 4,
    incoming: 2,
    event: 4,
    'Sellers.id': 1,
    'Sellers.name_firm': 'kdm srl',
    'Sellers.site': 'www.terrebasse.com'
}

如何将商品退回:

{
    id: 4,
    incoming: 2,
    event: 4,
    Sellers: {
        id': 1,
        name_firm: 'kdm srl',
        site: 'www.terrebasse.com'
    }
}

Answer 1

从查询中删除 raw: true这将为卖家提供每个事件的实例

类似

{
   //Event1 properties
   Sellers: {
      // Associated sellers properties
    }
}

我猜我参加聚会已经太晚了..但对于面临类似问题的其他人来说