Ivago: make populate_ivago remove deleted entries #34

Open
opened 2021-04-17 23:09:37 +02:00 by Jef Roosens · 1 comment
Owner

The scraper currently constantly adds new entries, but doesn't remove old ones. This should be fixed.

The scraper currently constantly adds new entries, but doesn't remove old ones. This should be fixed.
Author
Owner

The best method will probably be to keep track of the last time a street name was inserted/update:

  • Auto-refresh the timestamp column when inserting/updating the table using a trigger
  • Each time the scraper is run, we delete any entries that are too old after the refresh
The best method will probably be to keep track of the last time a street name was inserted/update: * Auto-refresh the timestamp column when inserting/updating the table using a trigger * Each time the scraper is run, we delete any entries that are too old after the refresh
Commenting is not possible because the repository is archived.
No project
No assignees
1 participant
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Reference
Chewing_Bever/fej#34
No description provided.