From b394597a0d010cb6edbd565fc439f83aaefac095 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Wed, 21 Mar 2018 12:36:10 +0100 Subject: [PATCH] Fix incorrect criteria for active lists --- loader/pglister_sync.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/loader/pglister_sync.py b/loader/pglister_sync.py index 0cce637..32c6820 100755 --- a/loader/pglister_sync.py +++ b/loader/pglister_sync.py @@ -69,7 +69,7 @@ if __name__=="__main__": print "Added list %s" % name else: listid, name = curs.fetchone() - curs.execute("UPDATE lists SET shortdesc=%(name)s, description=%(desc)s, groupid=(SELECT groupid FROM listgroups WHERE groupname=%(groupname)s), active=true WHERE listid=%(id)s AND NOT (shortdesc=%(name)s AND description=%(desc)s AND groupid=(SELECT groupid FROM listgroups WHERE groupname=%(groupname)s)) OR NOT active RETURNING listname", { + curs.execute("UPDATE lists SET shortdesc=%(name)s, description=%(desc)s, groupid=(SELECT groupid FROM listgroups WHERE groupname=%(groupname)s), active=true WHERE listid=%(id)s AND NOT (active AND shortdesc=%(name)s AND description=%(desc)s AND groupid=(SELECT groupid FROM listgroups WHERE groupname=%(groupname)s)) RETURNING listname", { 'id': listid, 'name': l['listname'], 'desc': l['longdesc'], -- 2.39.5