From 2123a546286aca104ff7394980acf09780649971 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Wed, 15 Mar 2017 14:35:55 +0100
Subject: do not filter match types in SQL (fixes vainglorygame/meta#65

---
 insert.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'insert.sql')

diff --git a/insert.sql b/insert.sql
index 3064e9b..bc6485d 100644
--- a/insert.sql
+++ b/insert.sql
@@ -67,7 +67,7 @@ linked_matches AS (
 ),
 -- insert!
 insert_matches AS (
-  INSERT INTO match(id, data) SELECT * FROM linked_matches WHERE linked_matches.data->'data'->'attributes'->>'gameMode'='casual' OR linked_matches.data->'data'->'attributes'->>'gameMode'='ranked'
+  INSERT INTO match(id, data) SELECT * FROM linked_matches
   ON CONFLICT(id) DO NOTHING
   RETURNING id
 )
-- 
cgit v1.3.1

