diff options
| author | Kapil Viren Ahuja <k.v.ahuja@gmail.com> | 2017-03-15 13:28:14 +0530 |
|---|---|---|
| committer | Kapil Viren Ahuja <k.v.ahuja@gmail.com> | 2017-03-15 13:28:14 +0530 |
| commit | 1d03692ad017e9a34eaed250023259ba83583eac (patch) | |
| tree | bf524961a015cbdc3c8e00e31e07811020a51656 /queries | |
| parent | e1277af939c30e3f2e4bb74cc7792a8764dca1cb (diff) | |
| download | processor-1d03692ad017e9a34eaed250023259ba83583eac.tar.gz processor-1d03692ad017e9a34eaed250023259ba83583eac.zip | |
Fix https://github.com/vainglorygame/meta/issues/44.
We will need a query to update this in production - I doubt we can fix older data as we don’t have anything from Raw…
Diffstat (limited to 'queries')
| -rw-r--r-- | queries/participant.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/queries/participant.sql b/queries/participant.sql index 8b20858..8e86e3d 100644 --- a/queries/participant.sql +++ b/queries/participant.sql @@ -29,7 +29,7 @@ COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'level', ''), '0'): 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", +COALESCE(NULLIF(participant->'data'->'attributes'->'stats'->>'turretCaptures', ''), '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 "item_grants", |