summaryrefslogtreecommitdiff
path: root/queries/player.sql
diff options
context:
space:
mode:
authorKapil Viren Ahuja <kvahuja@users.noreply.github.com>2017-02-16 22:18:04 +0530
committerschneefux <schneefux+github@schneefux.xyz>2017-02-16 17:48:04 +0100
commit07f17264500c388cb039eb33cdd89bc4f54d9505 (patch)
tree3820fe6620ab170242fca870311798d5246c4d3d /queries/player.sql
parent5a932151539247fef874c9bcb8e49b8483c529cd (diff)
downloadshrinker-07f17264500c388cb039eb33cdd89bc4f54d9505.tar.gz
shrinker-07f17264500c388cb039eb33cdd89bc4f54d9505.zip
1. using the right table names in SQL. 2. also put in some exception handling which spits out the error and moves on instead of exiting (#11)
* 1. using the right table names in SQL. 2. also put in some exception handling which spits out the error and moves on instead of exiting * ID in participant table is participant ID. we need a mapping for player ID in Web to get a player's matches.
Diffstat (limited to 'queries/player.sql')
-rw-r--r--queries/player.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/queries/player.sql b/queries/player.sql
index cf71d20..4f37018 100644
--- a/queries/player.sql
+++ b/queries/player.sql
@@ -18,4 +18,4 @@ attributes->'stats'->>'lifetimeGold' AS "lifeTimeGold",
0 AS "lifeTimeKD",
0 AS "lifeTimeKDA"
-FROM apidata WHERE type='player'
+FROM player