blob: 0b992f9fca645b3844419af7224d5002e35c2abb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SELECT
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 "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",
match.data->'relations'->1->'data'->>'id' as "roster_2"
FROM match WHERE id=$1
|
