How to pass array of objects in replacement

[rohitpatil7892]

I want to pass an array of objects into replacement
Example:

let testdata  = [{name: 'test1', version:1},{name:'test2',version:2}]

let query = 'SELECT id FROM testTable where name= :name AND version: :version';

let result = dbConnection.sequelize.query(query, {
			type: dbConnection.sequelize.QueryTypes.SELECT,
			replacements: testdata
		})

I want this to improve my performance, Can you please help me to resolve this or open for better suggestions

Thanks in advance :)

• Sequelize version: 6.x
• Node.js version: 14.17.x
• Database & Version: MySQL 8

[ephys]

Try this:

const result = await sequelize.query('SELECT id FROM `testTable` WHERE (name, version) IN (:data)', {
  replacements: [
    ['test1', 1],
    ['test2', 2],
  ],
  // ... other options
});

It should produce this query:

SELECT id FROM `testTable` WHERE (name, version) IN (('test1', 1), ('test2', 2))