Sequelize -将两个布尔属性合并为一个别名

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

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

// 定义模型
const User = sequelize.define('User', {
  isAdult: {
    type: DataTypes.BOOLEAN,
    allowNull: false,
    defaultValue: false,
  },
  hasLicense: {
    type: DataTypes.BOOLEAN,
    allowNull: false,
    defaultValue: false,
  },
});

// 查询并合并两个布尔属性为一个别名
User.findAll({
  attributes: [
    'id',
    'isAdult',
    'hasLicense',
    [
      Sequelize.literal('IF(isAdult = true AND hasLicense = true, "Yes", "No")'),
      'isAdultWithLicense',
    ],
  ],
})
  .then((users) => {
    console.log(users);
  })
  .catch((error) => {
    console.error(error);
  });