Sequelize -使用MySQL选择超过5分钟的所有记录的抽象查询

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

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

// 定义模型
class Record extends Model {}
Record.init({
  // 定义模型属性
  id: {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  timestamp: {
    type: DataTypes.DATE,
    allowNull: false
  },
  // 其他属性...
}, {
  sequelize,
  modelName: 'record'
});

// 查询超过5分钟的记录
const records = await Record.findAll({
  where: {
    timestamp: {
      [Sequelize.Op.gt]: Sequelize.literal('DATE_SUB(NOW(), INTERVAL 5 MINUTE)')
    }
  }
});

// 打印查询结果
console.log(records);