sql - Rails 查询到 SQL 语句

Question

我正在尝试写一个写这个:

Team.last.players.sum("goals")

错误:

SELECT SUM("players"."goals") 
FROM "players" 
WHERE "players"."team_id" = $1  [["team_id", 2]]

如何重写它以便我可以在方法中使用它:

def sql_search
  sql = "SELECT SUM \"players\".\"goals\" FROM \"players\" WHERE \"players\".\"team_id\" = $1 [[\"team_id\", #{self.id}"
  connection.execute(sql);
end

不断出现这个错误:

PG::SyntaxError: ERROR:  syntax error at or near "."
LINE 1: SELECT SUM "players"."goals" FROM "players" WHERE "players"....

任何想法将不胜感激

Answer 1

sql语句中不需要添加\"，去掉即可。

def sql_search
    sql = "SELECT sum(goals) FROM players WHERE team_id = #{self.id};"
    connection.execute(sql);
end