From b43b300e7dd6744a382c2f8ec6576d0c8e5ca1de Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Wed, 8 Mar 2017 17:20:02 +0100
Subject: bugfix: get lmcd for player upserts from db, don't update every time

---
 api.py | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'api.py')

diff --git a/api.py b/api.py
index b316a6b..47e779f 100644
--- a/api.py
+++ b/api.py
@@ -150,7 +150,10 @@ class Processor(joblib.worker.Worker):
         """Upsert a player named tuple into a table.
         Return the object id."""
         # save lmcd to restore later
-        lmcd = data["last_match_created_date"]
+        lmcd = await conn.fetchval("""
+            SELECT last_match_created_date FROM player
+            WHERE api_id=$1
+        """, data["api_id"])
 
         obj = await self._into(conn, data, table, conflict="""
             DO UPDATE SET ("{1}") = ({2})
-- 
cgit v1.3.1