Sequlize js有条件地选择当内部连接涉及到

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

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

// 定义模型
class User extends Model {}
User.init({
  username: DataTypes.STRING,
  email: DataTypes.STRING,
}, { sequelize, modelName: 'user' });

class Post extends Model {}
Post.init({
  title: DataTypes.STRING,
  content: DataTypes.TEXT,
}, { sequelize, modelName: 'post' });

// 建立模型之间的关系
User.hasMany(Post);
Post.belongsTo(User);

// 执行内部连接查询
User.findAll({
  include: [{
    model: Post,
    where: {
      title: 'Sequelize Tutorial',
    },
  }],
}).then(users => {
  console.log(users);
}).catch(error => {
  console.error(error);
});