diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-28 18:30:06 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-28 18:30:06 +0200 |
| commit | dfa0872dd7940b6d2759d8901274f459edf1b46e (patch) | |
| tree | 761d559790e496cf750908fa9018671124435236 /queries/match.sql | |
| parent | 57ac9c2b03f9e46de6ea4a16eb3954868d1427c9 (diff) | |
| download | shrinker-dfa0872dd7940b6d2759d8901274f459edf1b46e.tar.gz shrinker-dfa0872dd7940b6d2759d8901274f459edf1b46e.zip | |
rewrite in NodeJS
Diffstat (limited to 'queries/match.sql')
| -rw-r--r-- | queries/match.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/queries/match.sql b/queries/match.sql deleted file mode 100644 index fc8ab7e..0000000 --- a/queries/match.sql +++ /dev/null @@ -1,15 +0,0 @@ -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') 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 |