Col case changes

4 files changed, 37 insertions, 37 deletions

diff --git a/queries/match.sql b/queries/match.sql
index 1e6d37f..0b992f9 100644
--- a/queries/match.sql
+++ b/queries/match.sql
@@ -1,12 +1,12 @@
 SELECT
 
-match.id AS "apiId",
-(match.data->'data'->'attributes'->>'createdAt')::timestamp as "createdAt",
+match.id AS "api_id",
+(match.data->'data'->'attributes'->>'createdAt')::timestamp as "created_at",
 (match.data->'data'->'attributes'->>'duration')::int AS "duration",
-match.data->'data'->'attributes'->>'gameMode' AS "gameMode",
-COALESCE(NULLIF(match.data->'data'->'attributes'->>'patchVersion', ''), '0') AS "patchVersion",
-match.data->'data'->'attributes'->>'shardId' AS "shardId",
-match.data->'data'->'attributes'->'stats'->>'endGameReason' AS "endGameReason",
+match.data->'data'->'attributes'->>'gameMode' AS "game_mode",
+COALESCE(NULLIF(match.data->'data'->'attributes'->>'patch_version', '2.2'), '0') AS "patch_version",
+match.data->'data'->'attributes'->>'shardId' AS "shard_id",
+match.data->'data'->'attributes'->'stats'->>'endGameReason' AS "end_game_reason",
 match.data->'data'->'attributes'->'stats'->>'queue' AS "queue",
 
 match.data->'relations'->0->'data'->>'id' as "roster_1",
diff --git a/queries/participant.sql b/queries/participant.sql
index d4490e9..a65bdde 100644
--- a/queries/participant.sql
+++ b/queries/participant.sql
@@ -7,31 +7,31 @@ participants AS (SELECT
 FROM rosters)
 SELECT
 
-participant->'data'->>'id' AS "apiId",
-rosterid AS "roster_apiId",
-participant->'relations'->0->'data'->>'id' AS "player_apiId",
+participant->'data'->>'id' AS "api_id",
+rosterid AS "roster_api_id",
+participant->'relations'->0->'data'->>'id' AS "player_api_id",
 
 participant->'data'->'attributes'->>'actor' AS "hero",
 (participant->'data'->'attributes'->'stats'->>'assists')::int AS "assists",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'crystalMineCaptures', ''), '0')::int AS "crystalMineCaptures",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'crystalMineCaptures', ''), '0')::int AS "crystal_mine_captures",
 (participant->'data'->'attributes'->'stats'->>'deaths')::int AS "deaths",
 (participant->'data'->'attributes'->'stats'->>'farm')::float AS "farm",
-(participant->'data'->'attributes'->'stats'->>'firstAfkTime')::float AS "firstAfkTime",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'goldMineCaptures', ''), '0')::int AS "goldMineCaptures",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'jungleKills', ''), '0')::int AS "jungleKills",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'karmaLevel', ''), '0')::int AS "karmaLevel",
+(participant->'data'->'attributes'->'stats'->>'firstAfkTime')::float AS "first_afk_time",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'goldMineCaptures', ''), '0')::int AS "gold_mine_captures",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'jungleKills', ''), '0')::int AS "jungle_kills",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'karmaLevel', ''), '0')::int AS "karma_level",
 COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'kills', ''), '0')::int AS "kills",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'krakenCaptures', ''), '0')::int AS "krakenCaptures",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'krakenCaptures', ''), '0')::int AS "kraken_captures",
 COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'level', ''), '0')::int AS "level",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'minionKills', ''), '0')::int AS "minionKills",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'skillTier', ''), '0')::int AS "skillTier",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'skinKey', ''), '0') AS "skinKey",
-COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'turretKills', ''), '0')::int AS "turretKills",
-(participant->'data'->'attributes'->'stats'->>'wentAfk')::bool AS "wentAfk",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'minionKills', ''), '0')::int AS "minion_kills",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'skillTier', ''), '0')::int AS "skill_tier",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'skinKey', ''), '0') AS "skin_key",
+COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'turretKills', ''), '0')::int AS "turret_kills",
+(participant->'data'->'attributes'->'stats'->>'wentAfk')::bool AS "went_afk",
 (participant->'data'->'attributes'->'stats'->>'winner')::bool AS "winner",
-participant->'data'->'attributes'->'stats'->'itemGrants' AS "itemGrants",
-participant->'data'->'attributes'->'stats'->'itemSells' AS "itemSells",
-participant->'data'->'attributes'->'stats'->'itemUses' AS "itemUses",
+participant->'data'->'attributes'->'stats'->'itemGrants' AS "item_grants",
+participant->'data'->'attributes'->'stats'->'itemSells' AS "item_sells",
+participant->'data'->'attributes'->'stats'->'itemUses' AS "item_uses",
 participant->'data'->'attributes'->'stats'->'items' AS "items"
 
 FROM participants
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"
 
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",