diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-14 20:48:43 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-14 20:48:43 +0100 |
| commit | d18b4c4a5f7f8a2d1505bd03c91a3c2c989dadad (patch) | |
| tree | e9e16db7e23bcdea134ed801a65c78bf319fd651 | |
| parent | 0a3421d87d7e55707062f1186cf64f2c54734444 (diff) | |
| download | compiler-d18b4c4a5f7f8a2d1505bd03c91a3c2c989dadad.tar.gz compiler-d18b4c4a5f7f8a2d1505bd03c91a3c2c989dadad.zip | |
fix participant_stats query
| -rw-r--r-- | queries/participant/stats.sql | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/queries/participant/stats.sql b/queries/participant/stats.sql index 05a9697..6a6d540 100644 --- a/queries/participant/stats.sql +++ b/queries/participant/stats.sql @@ -1,13 +1,17 @@ WITH stats AS ( SELECT - api_id, + participant.api_id, + match.patch_version, CASE WHEN roster.hero_kills=0 THEN 0 ELSE (kills+assists)/roster.hero_kills::float - END AS kill_participation - FROM participant JOIN roster ON roster.api_id=participant.roster_api_id + END AS kills_participation + FROM participant + JOIN roster ON roster.api_id=participant.roster_api_id + JOIN match ON match.api_id=roster.match_api_id + WHERE participant.api_id = $1 ) -INSERT INTO participant_stats(participant_api_id, kill_participation) +INSERT INTO participant_stats(participant_api_id, patch_version, kills_participation) SELECT * FROM stats ON CONFLICT(participant_api_id) DO -UPDATE SET(participant_api_id, kill_participation) = (SELECT * FROM stats) +UPDATE SET(participant_api_id, patch_version, kills_participation) = (SELECT * FROM stats) |