diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-05-24 12:21:55 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-05-24 12:21:55 +1000 |
| commit | 2824ec8bfbea23dad75c4908a73a483c044a8b47 (patch) | |
| tree | 25cf7d7919c02652b351a8ddcef9d6950ee40324 /backend | |
| parent | f8897729154dc25aaef8af40eb3b0d6851ca13b1 (diff) | |
Fix small sql-param mismatch bug
Diffstat (limited to 'backend')
| -rwxr-xr-x | backend/server.py | 3 |
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]} |
