Sequelize: How to match atleast 1 value from array stored in db with array in the request

Question

I have a table in psql db like below.

[{
 name="ABC",
 email="xyz",
 animals=["cats","dogs","elephants","giraffes"]
},
{
 name="BCD",
 email="fgh",
 animals=["giraffes"]
}]
....

and an array that I'll get in the request like below

hasAnimals=["lion","cheetah","dog","cat"]

How do I use sequelize where clause to get the records of all the people in the above table who have at least 1 of the animals from the hasAnimals array.

For eg. the stated example should fetch me the user with name ABC as ABC has cats & dogs and so does the array that I got in the request

Hardik Aswal · Accepted Answer · 2021-11-10 08:37:32Z

4

The solution turned out to be really simple.

const { Op } = require("sequelize");

let arr = []
for(let animal of animals) {
    arr.push({
        [Op.contains]: [animal],
    });
}

abc.findAll({
   where: {
      animals: {
         [Op.or]: arr
      }
   },    
})

answered Nov 10, 2021 at 8:37

Hardik Aswal

2274 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Edouard · Accepted Answer · 2021-11-09 22:05:30Z

0

sql solution could be something like :

SELECT *
  FROM your_table
 WHERE your_json_column :: jsonb @? '$[*].animals[*] ? (@ <@ HasAnimals)'

answered Nov 9, 2021 at 22:05

Edouard

7,1291 gold badge11 silver badges24 bronze badges

Collectives™ on Stack Overflow

Sequelize: How to match atleast 1 value from array stored in db with array in the request

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related