osmand_map_creation
osmand_map_creation copied to clipboard
filter complex tries to delete records already taken care of
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:
- run clean_db.py
- view log file
- 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.