From 0455416095e0347d644716d4438fb2b8b14c8db2 Mon Sep 17 00:00:00 2001 From: schneefux Date: Wed, 15 Feb 2017 16:02:32 +0100 Subject: load processor queries from sql files --- queries/match_results.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 queries/match_results.sql (limited to 'queries/match_results.sql') diff --git a/queries/match_results.sql b/queries/match_results.sql new file mode 100644 index 0000000..b1e750b --- /dev/null +++ b/queries/match_results.sql @@ -0,0 +1,22 @@ +SELECT + +attributes->'stats'->>'side' AS "team", +FALSE AS "winner", +FALSE AS "surrender", +0 AS "teamSize", +'' AS "hero_1", +'' AS "hero_2", +'' AS "hero_3", +0 AS "laneMinionsSlayed", +0 AS "jungleMinionsSlayed", +(attributes->'stats'->>'turretKills')::int AS "turretsDestroyed", +(attributes->'stats'->>'heroKills')::int AS "kills", +0 AS "assists", +0 AS "deaths", +(attributes->'stats'->>'krakenCaptures')::int AS "krakenCaptures", +0 AS "goldMineCaptures", +0 AS "crystalMineCaptures", +0 AS "afkCount", +0 AS "afkTime" + +FROM apidata WHERE type='roster' -- cgit v1.3.1