diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-15 14:35:55 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-03-15 14:35:55 +0100 |
| commit | 2123a546286aca104ff7394980acf09780649971 (patch) | |
| tree | c3b7b5ef638283ce2e5f4449ef4f01484a0169b8 | |
| parent | 74f667b311a525b367f61d82cdb26b6e60c45711 (diff) | |
| download | apigrabber-2123a546286aca104ff7394980acf09780649971.tar.gz apigrabber-2123a546286aca104ff7394980acf09780649971.zip | |
do not filter match types in SQL (fixes vainglorygame/meta#65
| -rw-r--r-- | insert.sql | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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 ) |
