diff options
| author | Vainsocial root <root@vainsocial> | 2017-03-12 14:50:25 +0000 |
|---|---|---|
| committer | Vainsocial root <root@vainsocial> | 2017-03-12 14:50:25 +0000 |
| commit | 582c4b2708d2d18a276905598296acd6bca95411 (patch) | |
| tree | bf69a6c7e65a7cce4ead8bbf9d38a1d1d77494e2 /queries/player.sql | |
| parent | b8d696eaed3510666014d57e114556ea7ef8ab42 (diff) | |
| parent | 5df8cc227bf8969fa4d9eca5a67b38b43be91b5b (diff) | |
| download | processor-release/1.0.0.tar.gz processor-release/1.0.0.zip | |
Merge branch 'releases/1.0.0' of https://github.com/vainglorygame/processor into releases/1.0.0release/1.0.0
Diffstat (limited to 'queries/player.sql')
| -rw-r--r-- | queries/player.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/queries/player.sql b/queries/player.sql index 209aabb..d718391 100644 --- a/queries/player.sql +++ b/queries/player.sql @@ -9,6 +9,7 @@ participants AS (SELECT JSONB_ARRAY_ELEMENTS(rosters.roster->'relations') AS participant FROM rosters), players AS (SELECT + participants.participant->'data'->'attributes'->'stats'->>'skillTier' AS skill_tier, shardid, matchdate, JSONB_ARRAY_ELEMENTS(participants.participant->'relations') AS player @@ -27,7 +28,7 @@ players.player->'data'->'attributes'->>'name' AS "name", (players.player->'data'->'attributes'->'stats'->>'wins')::int AS "wins", (players.player->'data'->'attributes'->'stats'->>'lifetimeGold')::float AS "lifetime_gold", matchdate AS "last_match_created_date", - +skill_tier AS "skill_tier", 0 AS "streak" FROM players |