diff options
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", |