Sequelize -在findAll之后，使用单个查询删除

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

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

// 定义模型
const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING,
    allowNull: false
  },
  age: {
    type: DataTypes.INTEGER,
    allowNull: false
  }
});

// 查询数据库中所有记录
User.findAll().then(users => {
  // 选择需要删除的记录
  const userToDelete = users.find(user => user.name === 'John');

  // 删除记录
  User.destroy({
    where: {
      id: userToDelete.id
    }
  }).then(() => {
    console.log('Record deleted successfully');
  }).catch(error => {
    console.error('Error deleting record:', error);
  });
}).catch(error => {
  console.error('Error querying database:', error);
});