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/roster.sql | |
| parent | e84c88441ed7e455ad708b8c3246046f0f400f00 (diff) | |
| download | processor-2ba860f0452ce4147b845db75d79014d059c27ec.tar.gz processor-2ba860f0452ce4147b845db75d79014d059c27ec.zip | |
Col case changes
Diffstat (limited to 'queries/roster.sql')
| -rw-r--r-- | queries/roster.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/queries/roster.sql b/queries/roster.sql index 2344c7f..f6500fb 100644 --- a/queries/roster.sql +++ b/queries/roster.sql @@ -3,16 +3,16 @@ WITH rosters AS (SELECT JSONB_ARRAY_ELEMENTS(match.data->'relations') AS roster FROM match WHERE id=$1) SELECT -roster->'data'->>'id' AS "apiId", -matchid AS "match_apiId", -(roster->'data'->'attributes'->'stats'->>'acesEarned')::int AS "acesEarned", +roster->'data'->>'id' AS "api_id", +matchid AS "match_api_id", +(roster->'data'->'attributes'->'stats'->>'acesEarned')::int AS "aces_earned", (roster->'data'->'attributes'->'stats'->>'gold')::int AS "gold", -(roster->'data'->'attributes'->'stats'->>'heroKills')::int AS "heroKills", -(roster->'data'->'attributes'->'stats'->>'krakenCaptures')::int AS "krakenCaptures", +(roster->'data'->'attributes'->'stats'->>'heroKills')::int AS "hero_kills", +(roster->'data'->'attributes'->'stats'->>'krakenCaptures')::int AS "kraken_captures", roster->'data'->'attributes'->'stats'->>'side' AS "side", -roster->'data'->'attributes'->'stats'->>'side' AS "teamColor", -(roster->'data'->'attributes'->'stats'->>'turretKills')::int AS "turretKills", -(roster->'data'->'attributes'->'stats'->>'turretsRemaining')::int AS "turretsRemaining", +roster->'data'->'attributes'->'stats'->>'side' AS "team_color", +(roster->'data'->'attributes'->'stats'->>'turretKills')::int AS "turret_kills", +(roster->'data'->'attributes'->'stats'->>'turretsRemaining')::int AS "turrets_remaining", roster->'relations'->0->'data'->>'id' AS "participant_1", roster->'relations'->1->'data'->>'id' AS "participant_2", |