diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-05-18 21:09:05 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-05-18 21:42:32 +1000 |
| commit | 52560266b585e63742a81e27a3b6f1ef194470c6 (patch) | |
| tree | d1dd7bb0b0f778d59bf8ed62a5360daf747a737f /backend/data/genEnwikiData.py | |
| parent | eaaa97c186a2f8e2ba0768bd208120c0054ec0d3 (diff) | |
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.
Diffstat (limited to 'backend/data/genEnwikiData.py')
| -rwxr-xr-x | backend/data/genEnwikiData.py | 3 |
1 files changed, 2 insertions, 1 deletions
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() |