From d7feb37b5d562a6ced0ae39198652e4878d56436 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Wed, 21 Mar 2018 11:03:15 +0100 Subject: [PATCH] Synchronize list description from longdesc field pglister has now learned about a longer description, so use that one to synchronize the description that's shown on the website front. --- loader/pglister_sync.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/loader/pglister_sync.py b/loader/pglister_sync.py index 0691353..14a860e 100755 --- a/loader/pglister_sync.py +++ b/loader/pglister_sync.py @@ -62,7 +62,7 @@ if __name__=="__main__": if curs.rowcount == 0: curs.execute("INSERT INTO lists (listname, shortdesc, description, active, groupid) SELECT %(name)s, %(name)s, %(desc)s, 't', groupid FROM listgroups WHERE groupname=%(groupname)s RETURNING listid, listname", { 'name': l['listname'], - 'desc': l['shortdesc'], + 'desc': l['longdesc'], 'groupname': l['group']['groupname'], }) listid, name = curs.fetchone() @@ -72,7 +72,7 @@ if __name__=="__main__": 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 groupid=(SELECT groupid FROM listgroups WHERE groupname=%(groupname)s)) RETURNING listname", { 'id': listid, 'name': l['listname'], - 'desc': l['shortdesc'], + 'desc': l['longdesc'], 'groupname': l['group']['groupname'], }) for n, in curs.fetchall(): -- 2.39.5