sequelize.js - 复杂的销毁查询

Question

我正在尝试想出一些代码(除了 RAW Sequelize 查询)，这将允许我在一个事务/查询中删除给定模型的除 N 最新行之外的所有行。

我已经尝试了在 offset 方法中使用 order 和 Model.detroy 的天真方法。

Model.destroy({
  order: ["createdAt", "DESC"],
  offset: N,
  where: {
    parentModelId: someId,
  }
})

What I expected is that the code above constructed a query such as:

```sql
DELETE FROM model WHERE "parentModelId" = 'someId' ORDER BY "createdAt" DESC OFFSET N;

相反，生成的查询是:

DELETE FROM model WHERE "parentModelId" = 'someId';

Answer 1

编辑:刚刚意识到问题不在于 Sequelize.js 本身，而在于 PostgreSQL 不允许这样的查询。实现此目的的适当方法是通过查询:

DELETE FROM models WHERE is IN (
  SELECT id FROM models WHERE "parentModelId" = 'someId'
    ORDER BY "createdAt" DESC
    OFFSET N
);

不幸的是，在 Sequelize.js 中执行此操作的唯一方法是通过原始查询。 http://docs.sequelizejs.com/manual/raw-queries.html