From 2123a546286aca104ff7394980acf09780649971 Mon Sep 17 00:00:00 2001 From: schneefux 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