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/reviewImgsToMerge.py | |
| parent | 3402f3d6e906afb500b95448d7d0b136b6b5ee86 (diff) | |
Separate node-wiki_id association from 'descs' table
Diffstat (limited to 'backend/data/reviewImgsToMerge.py')
| -rwxr-xr-x | backend/data/reviewImgsToMerge.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/backend/data/reviewImgsToMerge.py b/backend/data/reviewImgsToMerge.py index 4120b14..d177a5e 100755 --- a/backend/data/reviewImgsToMerge.py +++ b/backend/data/reviewImgsToMerge.py @@ -51,7 +51,7 @@ print("Looking through enwiki images") if os.path.exists(enwikiImgDir): for filename in os.listdir(enwikiImgDir): (wikiId, _, _) = filename.partition(".") - query = "SELECT nodes.id FROM nodes INNER JOIN descs ON nodes.name = descs.name WHERE descs.wiki_id = ?" + query = "SELECT nodes.id FROM nodes INNER JOIN wiki_ids ON nodes.name = wiki_ids.name WHERE wiki_ids._id = ?" found = False for (otolId,) in dbCur.execute(query, (int(wikiId),)): if otolId not in nodeToImgs: |