filter Sequelize belongsToMany

Question

I have the following problem:

I defined my tables (product and collection) like this:

module.exports = (sequelize, type) => {
    return sequelize.define('product', {
        id: {
            type: type.UUID,
            primaryKey: true,
            defaultValue: type.UUIDV4,
        },
        title: {
            type: type.STRING,
            allowNull: false,
        },
        description: {
            type: type.TEXT,
            allowNull: false,
        },
        width: {
            type: type.FLOAT,
            allowNull: false,
        },
        height: {
            type: type.FLOAT,
            allowNull: false,
        },
        weight: {
            type: type.FLOAT,
            allowNull: false,
        },
        length: {
            type: type.FLOAT,
            allowNull: false,
        },
        vendor: {
            type: type.STRING,
            allowNull: false,
        },
        status: {
            type: type.ENUM,
            values: ['inactive', 'active'],
            defaultValue: 'active',
            allowNull: false,
        },
    })
}

module.exports = (sequelize, type) => {
    return sequelize.define('collection', {
        id: {
            type: type.UUID,
            primaryKey: true,
            defaultValue: type.UUIDV4,
        },
        name: {
            type: type.STRING,
            allowNull: false,
        },
        image: {
            type: type.STRING,
            allowNull: true,
        },
        createdAt: {
            type: type.DATE,
            allowNull: false,
        },
        updatedAt: {
            type: type.DATE,
            allowNull: false,
        },
        status: {
            type: type.ENUM,
            values: ['inactive', 'active'],
            defaultValue: 'active',
            allowNull: false,
        },
    })
}

Then, I need associated the tables (product and collection) with belongsToMany association and i did it like this:

const ProductModel = require('../api/product/model')
const CategoryModel = require('../api/category/model')

const Product = ProductModel(sequelize, Sequelize)
const Collection = CollectionModel(sequelize, Sequelize)

Product.belongsToMany(Collection, {
    through: ProductCollection,
    foreignKey: 'productId',
    otherKey: 'collectionId',
    unique: false,        
})

Collection.belongsToMany(Product, {
    through: ProductCollection,
    foreignKey: 'collectionId',
    otherKey: 'productId',
    unique: false,        
})

Now, i want to get all the products of a collection given by the id sent from the body of the request, i have little time working with sequelize and i don´t know how to do this kind of query.

Can you help me with that?

score 0 · Answer 1 · answered Dec 17 '19 at 10:20

you can use something like this

  let products = Collection.findAll({
            where: {
                id: collection.id,
            },
            attributes: ['id', 'name'],
            include: [{
                model: Product,
                through: {
                    model: ProductCollection,
                },
                as: 'products',
                attributes: ['id', 'title', 'description']
            }],
        });

        return products

        hope it helps

filter Sequelize belongsToMany

1 Answers1