diff options
| author | Kapil Viren Ahuja <kvahuja@users.noreply.github.com> | 2017-02-27 20:32:36 +0530 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-02-27 20:32:36 +0530 |
| commit | fc8542da9dae524b6f02cbdccdd4438e841c9fe6 (patch) | |
| tree | 707dca988c8c1bae8db0b8d79c84eda97150b6e7 /queries | |
| parent | d039f8246106306b0f1c80050ad3d95dba00df23 (diff) | |
| parent | 3c420196975ac8bd5f77fefffc1539eba43e2785 (diff) | |
| download | processor-fc8542da9dae524b6f02cbdccdd4438e841c9fe6.tar.gz processor-fc8542da9dae524b6f02cbdccdd4438e841c9fe6.zip | |
Merge pull request #27 from vainglorygame/participant-roster-ref
reference from participant to roster
Diffstat (limited to 'queries')
| -rw-r--r-- | queries/participant.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/queries/participant.sql b/queries/participant.sql index e11179c..7022d90 100644 --- a/queries/participant.sql +++ b/queries/participant.sql @@ -2,11 +2,13 @@ WITH rosters AS (SELECT JSONB_ARRAY_ELEMENTS(match.data->'relations') AS roster FROM match WHERE id=$1), participants AS (SELECT + rosters.roster->'data'->>'id' AS rosterid, JSONB_ARRAY_ELEMENTS(rosters.roster->'relations') AS participant FROM rosters) SELECT participant->'data'->>'id' AS "apiId", +rosterid AS "roster_apiId", participant->'relations'->0->'data'->>'id' AS "player_apiId", participant->'data'->'attributes'->>'actor' AS "hero", |