使用带有Sequelize.js的节点将值追加到where条件

const { Sequelize, DataTypes, Model } = require('sequelize');
const sequelize = new Sequelize('sqlite::memory:'); // 示例使用 SQLite 内存数据库

class User extends Model {}

User.init({
  username: DataTypes.STRING,
  age: DataTypes.INTEGER
}, { sequelize, modelName: 'user' });

(async () => {
  await sequelize.sync({ force: true });

  // 创建一些示例数据
  await User.bulkCreate([
    { username: 'Alice', age: 20 },
    { username: 'Bob', age: 17 },
    { username: 'Charlie', age: 25 }
  ]);

  // 追加年龄大于 18 岁的条件
  const users = await User.findAll({
    where: {
      age: {
        [Sequelize.Op.gt]: 18
      }
    }
  });

  console.log(users.map(user => user.username));
})();

const users = await User.findAll({
  where: {
    age: {
      [Sequelize.Op.gt]: 18 // 确保这里的 18 是整数
    }
  }
});