diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-06-15 20:48:31 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-06-15 20:48:31 +1000 |
| commit | eabec97d80e5f43e4710dd4c8327d0bc8519ab8c (patch) | |
| tree | 0fd6d93f306b6dc7db2b9233ce63b65ebdc994bc /backend/data/genEnwikiNameData.py | |
| parent | 3402f3d6e906afb500b95448d7d0b136b6b5ee86 (diff) | |
Separate node-wiki_id association from 'descs' table
Diffstat (limited to 'backend/data/genEnwikiNameData.py')
| -rwxr-xr-x | backend/data/genEnwikiNameData.py | 2 |
1 files changed, 1 insertions, 1 deletions
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 |