diff options
| author | Kapil Viren Ahuja <k.v.ahuja@gmail.com> | 2017-03-04 11:42:14 +0530 |
|---|---|---|
| committer | Kapil Viren Ahuja <k.v.ahuja@gmail.com> | 2017-03-04 11:42:14 +0530 |
| commit | 2ba860f0452ce4147b845db75d79014d059c27ec (patch) | |
| tree | 141ed9c17862f6aef78782ba815afce41af1bcac /queries/player.sql | |
| parent | e84c88441ed7e455ad708b8c3246046f0f400f00 (diff) | |
| download | shrinker-2ba860f0452ce4147b845db75d79014d059c27ec.tar.gz shrinker-2ba860f0452ce4147b845db75d79014d059c27ec.zip | |
Col case changes
Diffstat (limited to 'queries/player.sql')
| -rw-r--r-- | queries/player.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/queries/player.sql b/queries/player.sql index 0619ee6..585858d 100644 --- a/queries/player.sql +++ b/queries/player.sql @@ -1,5 +1,5 @@ WITH rosters AS (SELECT - match.data->'data'->'attributes'->>'createdAt' AS matchdate, + match.data->'data'->'attributes'->>'created_at' AS matchdate, JSONB_ARRAY_ELEMENTS(match.data->'relations') AS roster FROM match WHERE id=$1), participants AS (SELECT @@ -13,16 +13,16 @@ FROM participants) SELECT -players.player->'data'->>'id' AS "apiId", +players.player->'data'->>'id' AS "api_id", players.player->'data'->'attributes'->>'name' AS "name", (players.player->'data'->'attributes'->'stats'->>'level')::int AS "level", (players.player->'data'->'attributes'->'stats'->>'xp')::int AS "xp", (players.player->'data'->'attributes'->'stats'->>'played')::int AS "played", -(players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "playedRanked", -(players.player->'data'->'attributes'->'stats'->>'played')::int - (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "playedCasual", +(players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_ranked", +(players.player->'data'->'attributes'->'stats'->>'played')::int - (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_casual", (players.player->'data'->'attributes'->'stats'->>'wins')::int AS "wins", -(players.player->'data'->'attributes'->'stats'->>'lifetimeGold')::float AS "lifetimeGold", -CASE WHEN players.player->'data'->'attributes'->>'name'=$2 THEN matchdate ELSE 'epoch'::timestamp::text END AS "lastMatchCreatedDate", +(players.player->'data'->'attributes'->'stats'->>'lifetimeGold')::float AS "lifetime_gold", +CASE WHEN players.player->'data'->'attributes'->>'name'=$2 THEN matchdate ELSE 'epoch'::timestamp::text END AS "last_match_created_date", 0 AS "streak" |