Sequelize get last update或create value

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

class User extends Model {}

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

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

  // 创建一个新用户
  const newUser = await User.create({ username: 'john_doe', email: 'john@example.com' });
  console.log('创建时间:', newUser.createdAt);

  // 更新用户信息
  await newUser.update({ email: 'john_new@example.com' });
  console.log('更新时间:', newUser.updatedAt);
})();

const lastUser = await User.findOne({
  order: [['createdAt', 'DESC']] // 或者 ['updatedAt', 'DESC']
});

console.log('最后一条记录的创建时间:', lastUser.createdAt);
console.log('最后一条记录的更新时间:', lastUser.updatedAt);

User.init({
  username: DataTypes.STRING,
  email: DataTypes.STRING
}, {
  sequelize,
  modelName: 'user',
  timestamps: true // 确保启用时间戳
});