From 64eea97456e1c45e8f08f3d18fcf86143f94cd53 Mon Sep 17 00:00:00 2001 From: schneefux Date: Fri, 3 Mar 2017 22:23:51 +0100 Subject: fixed lastMatchCreatedDate being updated on any player --- api.py | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/api.py b/api.py index bf58ea1..8cb18a2 100644 --- a/api.py +++ b/api.py @@ -136,9 +136,10 @@ class Worker(object): if do_upsert_date: # upsert lmcd because it was an explicit request await conn.execute(""" - UPDATE player SET "lastMatchCreatedDate"=$1 - WHERE player."lastMatchCreatedDate" < $1 - """, lmcd) + UPDATE player SET "lastMatchCreatedDate"=$2 + WHERE player."apiId"=$1 AND + player."lastMatchCreatedDate" < $2 + """, objid, lmcd) return objid -- cgit v1.3.1