From 22add9e90e2c62a3a08d64b8c73a66b8de77bc97 Mon Sep 17 00:00:00 2001
From: kvahuja <k.v.ahuja@gmail.com>
Date: Sat, 18 Feb 2017 15:42:48 +0530
Subject: refactoring as part of
 https://github.com/vainglorygame/vainsocial.com/issues/17

---
 queries/match_participation.sql | 24 ------------------------
 1 file changed, 24 deletions(-)
 delete mode 100644 queries/match_participation.sql

(limited to 'queries/match_participation.sql')

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
-- 
cgit v1.3.1

