From 68571be9fc497ecd87a2f61df6d98de2aac161b5 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Wed, 21 Mar 2018 12:31:06 +0100 Subject: [PATCH] Set lists synced from pglister to active automatically The whole definition of active is that the list is in pglister, so make sure we sync that value over. --- 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 23cfd8f..97b0785 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) WHERE listid=%(id)s AND NOT (shortdesc=%(name)s AND description=%(desc)s AND groupid=(SELECT groupid FROM listgroups WHERE groupname=%(groupname)s)) 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 (shortdesc=%(name)s AND description=%(desc)s AND groupid=(SELECT groupid FROM listgroups WHERE groupname=%(groupname)s)) OR NOT active RETURNING listname", { 'id': listid, 'name': l['listname'], 'desc': l['longdesc'], -- 2.39.5