ruby-on-rails - Rails 查询 - 求和结果

Question

Score.where(period: ["q1", "q2"]).pluck(:game_id, :home_score, :away_score)

此查询返回如下结果:

[[57927, 26, 19], [57927, 28, 23], 
[57928, 12, 21], [57928, 17, 25], 
[57929, 28, 15], [57929, 24, 20]]

我怎样才能将同一个 :game_id 的 :home_score 和 :away_score 结果相加，得到这个

[[57927, 54, 42], 
[57928, 29, 46], 
[57929, 52, 35]]

Answer 1

假设 game_id 是映射到 Game 对象的外键，尝试:

Game.joins(:scores).select("#{Game.table_name}.id, SUM(#{Game.table_name}.home_score) AS home_total, SUM(#{Game.table_name}.away_score) AS total_away").group("#{Game.table_name}.id").pluck[:id, :home_total, :away_total]

无法测试它，但它应该适用于单个数据库查询。