From 26c13d2eca48072f28cc8f8298aa244f487f41ff Mon Sep 17 00:00:00 2001 From: schneefux Date: Tue, 28 Feb 2017 19:13:02 +0100 Subject: pass apiId to compiler instead of id --- api.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/api.py b/api.py index c62b3c4..2d0a92f 100644 --- a/api.py +++ b/api.py @@ -128,7 +128,7 @@ class Worker(object): VALUES ({1}, 'epoch'::timestamp) ON CONFLICT("apiId") DO UPDATE SET ("{0}") = ({1}) WHERE player.played < EXCLUDED.played - RETURNING id + RETURNING "apiId" """.format( "\", \"".join(keys), ", ".join(placeholders)) objid = await conn.fetchval(query, *data.values()) @@ -148,7 +148,7 @@ class Worker(object): items = list(data.items()) keys, values = [x[0] for x in items], [x[1] for x in items] placeholders = ["${}".format(i) for i, _ in enumerate(values, 1)] - query = "INSERT INTO {} (\"{}\") VALUES ({}) ON CONFLICT DO NOTHING RETURNING id".format( + query = "INSERT INTO {} (\"{}\") VALUES ({}) ON CONFLICT DO NOTHING RETURNING \"apiId\"".format( table, "\", \"".join(keys), ", ".join(placeholders)) return await conn.fetchval(query, (*data)) -- cgit v1.3.1