From 3b105e543a0e2e7097e3156d3daa1bdc0bd3fc2b Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Sat, 4 Jun 2022 14:09:05 +1000 Subject: Add tile-info otol links --- backend/server.py | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'backend/server.py') diff --git a/backend/server.py b/backend/server.py index c564466..05cba2d 100755 --- a/backend/server.py +++ b/backend/server.py @@ -35,9 +35,10 @@ def lookupNodes(names, useReducedTree): nodesTable = "nodes" if not useReducedTree else "r_nodes" edgesTable = "edges" if not useReducedTree else "r_edges" queryParamStr = ",".join(["?"] * len(names)) - query = f"SELECT name, tips FROM {nodesTable} WHERE name IN ({queryParamStr})" - for (nodeName, tips) in cur.execute(query, names): + query = f"SELECT name, id, tips FROM {nodesTable} WHERE name IN ({queryParamStr})" + for (nodeName, otolId, tips) in cur.execute(query, names): nodeObjs[nodeName] = { + "otolId": otolId, "children": [], "parent": None, "tips": tips, -- cgit v1.2.3