diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-07-08 11:13:20 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-07-08 11:13:20 +1000 |
| commit | f2c4909c5e8bdbd7f520cd2806c9a2e9e0047108 (patch) | |
| tree | 35aa69dfa647f025381da29472d0e75895f3f82f /backend | |
| parent | ef4a9b9223d6019f0b782eb2f944f3cfe2b6ed41 (diff) | |
Hard-code root-name in cgi script
Diffstat (limited to 'backend')
| -rwxr-xr-x | backend/cgi-bin/data.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/backend/cgi-bin/data.py b/backend/cgi-bin/data.py index 3579a18..1334dfc 100755 --- a/backend/cgi-bin/data.py +++ b/backend/cgi-bin/data.py @@ -9,6 +9,7 @@ dbFile = "data/data.db" DEFAULT_SUGG_LIM = 5 MAX_SUGG_LIM = 50 CORS_ANY_ORIGIN = True # Used during development to avoid Cross-Origin Resource Sharing restrictions +ROOT_NAME = 'cellular organisms' usageInfo = f""" Usage: {sys.argv[0]} @@ -242,8 +243,9 @@ def handleReq(dbCur): # Set vars from params name = queryDict["name"][0] if "name" in queryDict else None if name == None: # Get root node - query = "SELECT name FROM nodes LEFT JOIN edges ON nodes.name = edges.child WHERE edges.parent IS NULL LIMIT 1" - (name,) = dbCur.execute(query).fetchone() + name = ROOT_NAME # Hard-coding this is significantly faster (in testing, querying could take 0.5 seconds) + #query = "SELECT name FROM nodes LEFT JOIN edges ON nodes.name = edges.child WHERE edges.parent IS NULL LIMIT 1" + #(name,) = dbCur.execute(query).fetchone() reqType = queryDict["type"][0] if "type" in queryDict else None tree = queryDict["tree"][0] if "tree" in queryDict else "images" # Check for valid 'tree' |