osmand_map_creation icon indicating copy to clipboard operation
osmand_map_creation copied to clipboard

filter complex tries to delete records already taken care of

Open pnoll1 opened this issue 11 months ago • 0 comments

Describe the bug filter complex tries to delete records that are already deleted

To Reproduce Steps to reproduce the behavior, Mention an exact address if possible:

  1. run clean_db.py
  2. view log file
  3. see duplicate deletion entries eg
2024-03-07 14:40:53,275 root INFO us_me_statewide_addresses_state DELETE 22 N St
2024-03-07 14:40:53,308 root INFO us_me_statewide_addresses_state DELETE 0 N St

Expected behavior delete all data once found and move onto next

Additional context Filter complex pulls entire table into list then loops through list. The database has been cleaned on first record but script keeps trying to delete from db based on out of date list.

pnoll1 avatar Mar 10 '24 20:03 pnoll1