summaryrefslogtreecommitdiff
path: root/insert.sql
diff options
context:
space:
mode:
authorschneefux <schneefux+commit@schneefux.xyz>2017-02-26 13:32:23 +0100
committerschneefux <schneefux+commit@schneefux.xyz>2017-02-26 13:32:23 +0100
commitbdcc5add4e5114746b47c4d481e316b7ee3415e4 (patch)
tree195290dc7b72be073b85310f2acfd8e387e1bf0f /insert.sql
parent568ec9e3194c61b8e489b0ea6b9204c9297e07e8 (diff)
parentce1f18227b3b8e3d087e2b920151d63d0061fe33 (diff)
downloadapigrabber-bdcc5add4e5114746b47c4d481e316b7ee3415e4.tar.gz
apigrabber-bdcc5add4e5114746b47c4d481e316b7ee3415e4.zip
Merge branch 'pass-type' into develop
Diffstat (limited to 'insert.sql')
-rw-r--r--insert.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/insert.sql b/insert.sql
index a47906e..9e95e0f 100644
--- a/insert.sql
+++ b/insert.sql
@@ -68,15 +68,15 @@
insert_matches AS (
INSERT INTO match SELECT * FROM linked_matches
ON CONFLICT(id) DO NOTHING
- RETURNING id -- TODO conflict shouldn't happen in prod
+ RETURNING type, id -- TODO conflict shouldn't happen in prod
),
insert_players AS (
INSERT INTO player SELECT * FROM linked_players
ON CONFLICT(id) DO
UPDATE SET attributes=EXCLUDED.attributes
WHERE (player.attributes->'stats'->>'played')::int < (EXCLUDED.attributes->'stats'->>'played')::int
- RETURNING id
+ RETURNING type, id
)
- SELECT * FROM insert_matches
+ SELECT type, id FROM insert_matches
UNION
- SELECT * FROM insert_players
+ SELECT type, id FROM insert_players