From 07f17264500c388cb039eb33cdd89bc4f54d9505 Mon Sep 17 00:00:00 2001 From: Kapil Viren Ahuja Date: Thu, 16 Feb 2017 22:18:04 +0530 Subject: 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. --- queries/player.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'queries/player.sql') 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 -- cgit v1.3.1