From 90a5e15bb824b84e5bb60337d6a57a1394090dc6 Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Wed, 4 May 2022 01:17:06 +1000 Subject: Add scripts for obtaining/sending/displaying wikipedia descriptions Add backend/data/enwiki/ directory containing scripts and instructive READMEs. Adjust some other scripts to generate 'eol_ids' sqlite table separate from 'names'. Make server respond to /data/desc requests, and have client TileInfo component display response data. Also adjust .gitignore entries to be root-relative. --- backend/server.py | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'backend/server.py') diff --git a/backend/server.py b/backend/server.py index 1c09ad7..580b4fb 100755 --- a/backend/server.py +++ b/backend/server.py @@ -52,9 +52,10 @@ def lookupNode(name): nodeObj["img"] = nodeNameToFile(match.group(1), cur) if nodeObj["img"] == None: nodeObj["img"] = nodeNameToFile(match.group(2), cur) + # return nodeObj; def nodeNameToFile(name, cur): - row = cur.execute("SELECT name, eol_id FROM names WHERE name = ?", (name,)).fetchone() + row = cur.execute("SELECT name, id FROM eol_ids WHERE name = ?", (name,)).fetchone() if row == None: return None eolId = row[1] @@ -92,6 +93,10 @@ def lookupName(name): hasMore = True del results[-1] return json.dumps([results, hasMore]) +def lookupDesc(name): + cur = dbCon.cursor() + row = cur.execute("SELECT desc, redirected from descs WHERE descs.name = ?", (name,)).fetchone() + return json.dumps([row[0], row[1] == 1] if row != None else None) class DbServer(BaseHTTPRequestHandler): def do_GET(self): @@ -158,6 +163,9 @@ class DbServer(BaseHTTPRequestHandler): elif reqType == "search": self.respondJson(lookupName(name)) return + elif reqType == "desc": + self.respondJson(lookupDesc(name)) + return self.send_response(404) self.end_headers() self.end_headers() -- cgit v1.2.3