From dfa0872dd7940b6d2759d8901274f459edf1b46e Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Tue, 28 Mar 2017 18:30:06 +0200
Subject: rewrite in NodeJS

---
 queries/match.sql | 15 ---------------
 1 file changed, 15 deletions(-)
 delete mode 100644 queries/match.sql

(limited to 'queries/match.sql')

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
-- 
cgit v1.3.1

