From 2824ec8bfbea23dad75c4908a73a483c044a8b47 Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Tue, 24 May 2022 12:21:55 +1000 Subject: Fix small sql-param mismatch bug --- backend/server.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/backend/server.py b/backend/server.py index 5152503..09277ac 100755 --- a/backend/server.py +++ b/backend/server.py @@ -142,7 +142,8 @@ def lookupNodeInfo(name, useReducedTree): # Get info for compound-image parts imgData = [None, None] idsToLookup = [int(n[:-4]) for n in nodeObj["imgName"] if n != None] - query = "SELECT eol_id, source_url, license, copyright_owner FROM images WHERE eol_id IN (?, ?)" + query = "SELECT eol_id, source_url, license, copyright_owner FROM" \ + " images WHERE eol_id IN ({})".format(",".join(["?"] * len(idsToLookup))) for row in cur.execute(query, idsToLookup): if str(row[0]) == nodeObj["imgName"][0][:-4]: imgData[0] = {"eolId": row[0], "sourceUrl": row[1], "license": row[2], "copyrightOwner": row[3]} -- cgit v1.2.3