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.

1 files changed, 9 insertions, 1 deletions

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()