diff options
| author | kvahuja <k.v.ahuja@gmail.com> | 2017-02-18 15:42:48 +0530 |
|---|---|---|
| committer | kvahuja <k.v.ahuja@gmail.com> | 2017-02-18 15:42:48 +0530 |
| commit | 22add9e90e2c62a3a08d64b8c73a66b8de77bc97 (patch) | |
| tree | d77b0a7a6e2425b1f2c27178edeb75b1d38dbbe8 /queries/match_participation.sql | |
| parent | b7e442270e0427c8ebf0d246edd91c26d1ad37a1 (diff) | |
| download | processor-22add9e90e2c62a3a08d64b8c73a66b8de77bc97.tar.gz processor-22add9e90e2c62a3a08d64b8c73a66b8de77bc97.zip | |
refactoring as part of https://github.com/vainglorygame/vainsocial.com/issues/17
Diffstat (limited to 'queries/match_participation.sql')
| -rw-r--r-- | queries/match_participation.sql | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/queries/match_participation.sql b/queries/match_participation.sql deleted file mode 100644 index 43785c6..0000000 --- a/queries/match_participation.sql +++ /dev/null @@ -1,24 +0,0 @@ -SELECT - -relationships->'player'->'data'->>'id' AS player_id, -0 AS "match_id", -0 AS "rosterId", -0 AS "fk_player_id", -0 AS "fk_match_results_id", -attributes->>'actor' AS "hero", -COALESCE(NULLIF(attributes->'stats'->>'kills', ''), '0')::int AS "kills", -(attributes->'stats'->>'deaths')::int AS "deaths", -(attributes->'stats'->>'assists')::int AS "assists", -0.0 AS "KD", -0.0 AS "KDA", -0 AS "killParticipation", -COALESCE(NULLIF(attributes->'stats'->>'nonJungleMinionKills', ''), '0')::int AS "laneMinionsSlayed", -COALESCE(NULLIF(attributes->'stats'->>'minionKills', ''), '0')::int AS "jungleMinionsSlayed", -COALESCE(NULLIF(attributes->'stats'->>'turretCaptures', ''), '0')::int AS "turretsDestroyed", -COALESCE(NULLIF(attributes->'stats'->>'krakenCaptures', ''), '0')::int AS "krakenCaptures", -COALESCE(NULLIF(attributes->'stats'->>'goldMineCaptures', ''), '0')::int AS "goldMineCaptures", -COALESCE(NULLIF(attributes->'stats'->>'crystalMineCaptures', ''), '0')::int AS "crystalMineCaptures", -(attributes->'stats'->>'wentAfk')::bool::int AS "wentAfk", -FALSE AS "perfectGame" - -FROM participant |