From 52560266b585e63742a81e27a3b6f1ef194470c6 Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Wed, 18 May 2022 21:09:05 +1000 Subject: Add wikipedia-link to tile-info display Add 'wiki_id' and 'from_dbp' columns to 'descs' table, adjust dbpedia data to include wikipedia IDs, adjust data generations scripts, make server send extra data, and make TileInfo display it. --- backend/data/genEnwikiData.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'backend/data/genEnwikiData.py') diff --git a/backend/data/genEnwikiData.py b/backend/data/genEnwikiData.py index 879ecf6..d33fd5d 100755 --- a/backend/data/genEnwikiData.py +++ b/backend/data/genEnwikiData.py @@ -63,7 +63,8 @@ for (name, pageId) in nodeToPageId.items(): # row = enwikiCur.execute("SELECT desc FROM descs where descs.id = ?", (pageId,)).fetchone() if row != None: - dbCur.execute("INSERT INTO descs VALUES (?, ?, ?)", (name, row[0], 1 if name in redirectingNames else 0)) + dbCur.execute("INSERT INTO descs VALUES (?, ?, ?, ?, ?)", + (name, row[0], 1 if name in redirectingNames else 0, pageId, 0)) # Close dbs dbCon.commit() dbCon.close() -- cgit v1.2.3