From eabec97d80e5f43e4710dd4c8327d0bc8519ab8c Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Wed, 15 Jun 2022 20:48:31 +1000 Subject: Separate node-wiki_id association from 'descs' table --- backend/data/genEnwikiNameData.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'backend/data/genEnwikiNameData.py') diff --git a/backend/data/genEnwikiNameData.py b/backend/data/genEnwikiNameData.py index 1beb522..71960a5 100755 --- a/backend/data/genEnwikiNameData.py +++ b/backend/data/genEnwikiNameData.py @@ -23,7 +23,7 @@ dbCur = dbCon.cursor() # Get nodes with wiki-ids print("Getting nodes with wiki IDs") nodeToWikiId = {} -for row in dbCur.execute("SELECT name, wiki_id from descs"): +for row in dbCur.execute("SELECT name, id from wiki_ids"): nodeToWikiId[row[0]] = row[1] print(f"Found {len(nodeToWikiId)} nodes") # Find wiki-ids that redirect to each node -- cgit v1.2.3