From e99586d17fcfa791758f54181a1723762fc4f43c Mon Sep 17 00:00:00 2001 From: Karl Pinc Date: Mon, 5 Aug 2024 00:36:53 -0400 Subject: [PATCH] Properly call psycopg.param_execute() --- src/pgwui_upcen/views/upcen.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/src/pgwui_upcen/views/upcen.py b/src/pgwui_upcen/views/upcen.py index 873b388..f14edb4 100644 --- a/src/pgwui_upcen/views/upcen.py +++ b/src/pgwui_upcen/views/upcen.py @@ -61,7 +61,7 @@ class SaveUCLine(pgwui_core.core.DataLineProcessor, def get_sname(self, udl): sname = udl[0].strip() - self.execute(SNAME_EXISTS_QUERY, sname) + self.execute(SNAME_EXISTS_QUERY, (sname,)) if self.cur.fetchone() is None: raise upcen_ex.UnknownSnameError( udl.lineno, @@ -119,7 +119,7 @@ class SaveUCLine(pgwui_core.core.DataLineProcessor, errors.append(err) else: self.param_execute( - INSERT_STMT, sname, date, self.group, status) + INSERT_STMT, (sname, date, self.group, status)) col -= 1 if errors: @@ -146,7 +146,7 @@ class UpCenUploadHandler(BaseTableUploadHandler): def get_group(self, headers): group = headers.tuples[0].strip() - self.execute(GROUP_EXISTS_QUERY, group) + self.execute(GROUP_EXISTS_QUERY, (group,)) if self.cur.fetchone() is None: raise upcen_ex.UnknownGroupError( 'The first column of the first line must be a GROUPS.GID', -- 2.34.1