Sequelize.js -按关系id列表查找对象

const { Sequelize, Model, DataTypes } = require('sequelize');

// 创建Sequelize实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

// 定义模型
class User extends Model {}
User.init({
  name: DataTypes.STRING,
  age: DataTypes.INTEGER
}, { sequelize, modelName: 'user' });

// 按关系id列表查找对象
const findUsersByRelationIds = async (relationIds) => {
  try {
    const users = await User.findAll({
      where: {
        id: relationIds
      }
    });
    return users;
  } catch (error) {
    console.error('Error:', error);
    throw error;
  }
};

// 调用方法进行查询
const relationIds = [1, 2, 3];
findUsersByRelationIds(relationIds)
  .then(users => {
    console.log('Users:', users);
  })
  .catch(error => {
    console.error('Error:', error);
  });