Better way to handle changing file names?

[rkiddy]

There are times where file names are changing and it is not important to track them. Or rather, all we have to do is automatically see that the file desired is still there but has changed its name in an unimportant manner.

For example, I am seeing covid-19-outbreak-data as broken.

Right now, we have this in the sources:

mysql> select file_name from sources where ds_pk = 120;
+-------------------------------------------------------------------------------------------+
| file_name                                                                                 |
+-------------------------------------------------------------------------------------------+
| covid-19-outbreaks-by-month-of-onset-outbreaks-reported-to-cdph-jan-1-2021-dec-2-2024.csv |
| datapackage.json                                                                          |
| covid-19-outbreaks-by-month-of-onset-outbreaks-reported-to-cdph-jan-1-2021-jan-6-2025.csv |
| total-covid-19-outbreaks-by-industry-outbreaks-with-onset-after-jan-1-2021.csv            |
+-------------------------------------------------------------------------------------------+

But these are the files we have:

% ls sources
covid-19-outbreak-data-08rcefzi.zip
covid-19-outbreaks-by-month-of-onset-outbreaks-reported-to-cdph-jan-1-2021-mar-3-2025.csv
datapackage.json
deets.sh
sources
TODO.txt
total-covid-19-outbreaks-by-industry-outbreaks-with-onset-after-jan-1-2021.csv
% 

The TODO.txt notes that the file was:

covid-19-outbreaks-by-month-of-onset-outbreaks-reported-to-cdph-jan-1-2021-dec-2-2024.csv

and become:

covid-19-outbreaks-by-month-of-onset-outbreaks-reported-to-cdph-jan-1-2021-jan-6-2025.csv

and, as of now, I am seeing it as:

covid-19-outbreaks-by-month-of-onset-outbreaks-reported-to-cdph-jan-1-2021-mar-3-2025.csv

It is stupid to try to chase these changes.