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/participant.sql | |
| parent | e84c88441ed7e455ad708b8c3246046f0f400f00 (diff) | |
| download | processor-2ba860f0452ce4147b845db75d79014d059c27ec.tar.gz processor-2ba860f0452ce4147b845db75d79014d059c27ec.zip | |
Col case changes
Diffstat (limited to 'queries/participant.sql')
| -rw-r--r-- | queries/participant.sql | 34 |
1 files changed, 17 insertions, 17 deletions
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 |