diff options
Diffstat (limited to 'queries/participant')
| -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) |