summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorschneefux <schneefux+commit@schneefux.xyz>2017-03-15 14:35:55 +0100
committerschneefux <schneefux+commit@schneefux.xyz>2017-03-15 14:35:55 +0100
commit2123a546286aca104ff7394980acf09780649971 (patch)
treec3b7b5ef638283ce2e5f4449ef4f01484a0169b8
parent74f667b311a525b367f61d82cdb26b6e60c45711 (diff)
downloadapigrabber-2123a546286aca104ff7394980acf09780649971.tar.gz
apigrabber-2123a546286aca104ff7394980acf09780649971.zip
do not filter match types in SQL (fixes vainglorygame/meta#65
-rw-r--r--insert.sql2
1 files changed, 1 insertions, 1 deletions
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
)