node.js - 查询中的序列化查询

Question

我有 2 个模型 Shop 和 Beacon。我必须返回分配给每个商店的总和信标。我知道如何在 SQL 中做到这一点:

SELECT Shops.*, (SELECT COUNT(id) FROM Beacons WHERE shopId = Shops.id) FROM Shops 

但是我对 Sequelize 有问题，我尝试了如下操作:

models.Shop.findAll({
  attributes: ['id', sqz.fn('count', sqz.col('shopId'))],
  include: [
    {
      model: models.Beacon
    }
  ]
});

Answer 1

此解决方案有效，但返回查询:

SELECT Shop.*, count(shopId) FROM Shops LEFT OUTER JOIN Beacons ON Shop.id = Beacons.shopId