aboutsummaryrefslogtreecommitdiff
path: root/backend
diff options
context:
space:
mode:
authorTerry Truong <terry06890@gmail.com>2022-05-24 12:21:55 +1000
committerTerry Truong <terry06890@gmail.com>2022-05-24 12:21:55 +1000
commit2824ec8bfbea23dad75c4908a73a483c044a8b47 (patch)
tree25cf7d7919c02652b351a8ddcef9d6950ee40324 /backend
parentf8897729154dc25aaef8af40eb3b0d6851ca13b1 (diff)
Fix small sql-param mismatch bug
Diffstat (limited to 'backend')
-rwxr-xr-xbackend/server.py3
1 files changed, 2 insertions, 1 deletions
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]}