不要怂,就是干,撸起袖子干!

include.ts 713 Bytes
import { Model, Sequelize, HasMany } from 'sequelize';

class MyModel extends Model {
	public static associations: {
		relation: HasMany
	};
}

class AssociatedModel extends Model {}

MyModel.findAll({
    include: [
        {
            limit: 1,
            model: AssociatedModel,
            on: {
              a: 1,
            },
            order: [['id', 'DESC']],
            separate: true,
            where: { state: Sequelize.col('project.state') },
        },
    ],
});

MyModel.findAll({
	include: [{ all: true }],
});

MyModel.findAll({
	include: [{
		limit: 1,
		association: 'relation',
		order: [['id', 'DESC']],
		separate: true,
		where: { state: Sequelize.col('project.state') },
	}]
});