From 0a0acb5ad79cd1a15c5c715fa5f6abae0dc25736 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Mon, 20 Feb 2017 17:17:27 +0100
Subject: process partitions concurrently

---
 queries/participant.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'queries/participant.sql')

diff --git a/queries/participant.sql b/queries/participant.sql
index b7685a9..e9f8264 100644
--- a/queries/participant.sql
+++ b/queries/participant.sql
@@ -25,4 +25,4 @@ attributes->'stats'->'itemSells' AS "itemSells",
 attributes->'stats'->'itemUses' AS "itemUses",
 attributes->'stats'->'items' AS "items"
 
-FROM participant
+FROM "participant"
-- 
cgit v1.3.1


From 9ae212a23754035be50e9125a7966544e2d525fb Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Mon, 20 Feb 2017 17:33:26 +0100
Subject: update queries to work with vainsocial.com#develop

---
 queries/match.sql       | 6 +++---
 queries/participant.sql | 2 +-
 2 files changed, 4 insertions(+), 4 deletions(-)

(limited to 'queries/participant.sql')

diff --git a/queries/match.sql b/queries/match.sql
index 2963172..5dfa692 100644
--- a/queries/match.sql
+++ b/queries/match.sql
@@ -7,9 +7,9 @@ attributes->>'gameMode' AS "gameMode",
 COALESCE(NULLIF(attributes->>'patchVersion', ''), '0') AS "patchVersion",
 attributes->>'shardId' AS "shardId",
 attributes->'stats'->>'endGameReason' AS "endGameReason",
-attributes->'stats'->>'queue' AS "queue",
+attributes->'stats'->>'queue' AS "queue" --,
 
-relationships->'rosters'->'data'->0->>'id' as roster_1,
-relationships->'rosters'->'data'->1->>'id' as roster_2
+--relationships->'rosters'->'data'->0->>'id' as "roster_1",
+--relationships->'rosters'->'data'->1->>'id' as "roster_2"
 
 FROM "match"
diff --git a/queries/participant.sql b/queries/participant.sql
index e9f8264..d1d81ce 100644
--- a/queries/participant.sql
+++ b/queries/participant.sql
@@ -1,7 +1,7 @@
 SELECT
 
 id AS "apiId",
-relationships->'player'->'data'->>'id' AS "player_apiId",
+relationships->'player'->'data'->>'id' AS "playerId",
 
 attributes->>'actor' AS "hero",
 (attributes->'stats'->>'assists')::int AS "assists",
-- 
cgit v1.3.1

