diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-02 18:36:32 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-02 18:36:32 +0100 |
| commit | a547f80e220921be7b7c8c5068838cc278b630f5 (patch) | |
| tree | 2f86018c7b058e33e8bf7248208204e5cf4e7973 | |
| parent | 72154860c353f87841ede8752adada095f09c2e3 (diff) | |
| download | compiler-a547f80e220921be7b7c8c5068838cc278b630f5.tar.gz compiler-a547f80e220921be7b7c8c5068838cc278b630f5.zip | |
process missing stats
| -rw-r--r-- | queries/player/count_player_matches.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/queries/player/count_player_matches.sql b/queries/player/count_player_matches.sql index ddfbb66..db5a2de 100644 --- a/queries/player/count_player_matches.sql +++ b/queries/player/count_player_matches.sql @@ -1,7 +1,7 @@ with stats as ( with plr as ( select - 'a' as patch_version, + 'a'::text as "patchVersion", player."apiId" as player_api_id, match."gameMode" as game_mode, participant."winner" as winner @@ -14,12 +14,14 @@ where player."apiId" = $1) select (select distinct(player_api_id) from plr), + (select distinct("patchVersion") as "patchVersion" from plr), (select count(*) as played from plr), (select count(*) as wins from plr where winner = true), (select count(*) as casual_played from plr where game_mode like '%casual%'), (select count(*) as casual_wins from plr where game_mode like '%casual%' and winner = true), (select count(*) as ranked_played from plr where game_mode like '%ranked%'), - (select count(*) as ranked_wins from plr where game_mode like '%ranked%' and winner = true) + (select count(*) as ranked_wins from plr where game_mode like '%ranked%' and winner = true), + (select 0 as streak) ) -INSERT INTO player_stats("player_apiId", played, wins, casual_played, casual_wins, ranked_played, ranked_wins) +INSERT INTO player_stats("player_apiId", "patchVersion", played, wins, casual_played, casual_wins, ranked_played, ranked_wins, streak) SELECT * FROM stats |