mysql - 如何使用 sequelize 做表别名？

Question

我需要做这样的事情。您可以在列名称前放置别名的位置。哦。 C。等等

SELECT o.OrderID, o.OrderDate, c.CustomerName FROM...

这是我试图在 sequelize 中复制的整个查询

SELECT c.id AS comment_id, c.comment, r.id AS reply_id, r.parent_comment_id, r.comment AS reply_comment FROM (comments c) LEFT JOIN comments r ON c.id = r.parent_comment_id

我尝试过的

attributes: ['c.id', ['comment_id'], 'c.comment', 'r.id', ['reply_id'], 'r.parent_comment_id', 'r.comment', ['reply_comment']]

sequelize 的文档只展示了如何做一个属性

Model.findAll({
  attributes: ['foo', ['baz']]
});

选择 foo 作为 baz ...

Answer 1

每个你想要别名的字段，你需要作为一个二元组传递。

Model.findAll({
  attributes: [
    'foo', // do not use alias
    ['bar', 'baz'],       // uses alias 'baz' for column 'bar'
    [Sequelize.col('related.foo'), 'related_foo']  // alias on includes
  ],
  includes: [
    {
      model: related,
      attributes: [] // empty to not generate nested atributes.
    }
  ]
});