Page MenuHomePhabricator

CCC: Image lookup SQL logic
Closed, ResolvedPublic

Description

Image lookup SQL logic needs to be updated to rely on the image's Commons ID and this ID also needs to now be stored. Using the image ID is ideal as it does not change regardless of if the file is renamed (flaw of current way).

  • Update database table structure to accommodate this additional field
  • Update update_entry query in database_stuff.py
  • Update have_seen_image() query inside database_stuff.py
  • Update parameters accepted by update_entry() and method logic in database_stuff.py to also take in image page ID
  • Update parameters accepted by store_image() and method logic in database_stuff.py to also take in image page ID
  • Update tests_database.py's method calls to accommodate these changes

Revisions and Commits