egg Sequelize query Or-ing where and include statements

vx6bjr1n 于 5个月前发布在其他

关注(0)|答案(1)|浏览(66)

在此输入你需要反馈的 Bug 具体信息（Bug in Detail）：

https://stackoverflow.com/questions/49837932/sequelize-query-or-ing-where-and-include-statements
看一下这个文档，我想用 sequelize 做一样的查询操作但是看了半天文档也不清楚在egg.js里怎样来用。
我的 model 定义如下：

app.model.Blog.belongsTo(app.model.Relation, {
      foreignKey: "userId",
      targetKey: "followerId",
      as: "follower",
    });

查询时候的代码如下：

include: [
        {
          model: Relation,
          as: "follower",
          attributes: [],
        },
      ],
      where: {
        [app.Sequelize.Op.or]: [
          {
            userId: userId,
          },
          {
            "$follower.userId$": {
              [app.Sequelize.Op.eq]: userId,
            },
          },
        ],
      },

但是最终会报错 nodejs.SequelizeDatabaseError: Unknown column 'follower.userId' in 'where clause'
不清楚是不是写法不对，还是egg内部处理的问题呢，辛苦帮忙看看。