write a test that confirms that all the flatio references in our db are found

[hcientist]

In PartTransposition, we have a bunch of pairs of scoreId and sharingKey (with the backend running locally, take a look at the corresponding admin pages to get a glimpse). In my testing right now, Deep River Melody for Concert Pitch TC which was originally created with these values (which were obtained from the row that's currently #176 in the MusicXML Needs Google Sheet) turns out to be not found. Perhaps this could be as simple as a google sheet script that fetches value in column D and alerts us if it gets an erroneous error code?

In my testing:

1. a working one, responds with a 200
   • e.g. https://flat.io/score/64d060b0a6876936e7f83f28?sharingKey=4010013a628e31f47be999260ed512c4ccf68cdf2146f0589ccc8cbbad013ad6375447d8af35be6a6cc623eb8845c487cb39290e0272a01757917ccbe49463e7
2. while the broken one in question responds with a 404
   • https://flat.io/score/62ec124a2e1d0f00137bdab5?sharingKey=63c6af6e48945b8bc06b8698d2571e494aeeaf2531ca2d9f82a96680a233483a5b1ac1b4962b58b63f38fa6a6fc76c21e6c549f1cc29eeae0695709e2303d4a6

[hcientist]

I made a little poc and feel pretty confident in the results. Right now it looks like only 2 have gone awry. Amazingly I “lucked” into both during manual testing yesterday. I need to push the code somewhere then share the link here

[hcientist]

here's what worked as a quick attempt https://github.com/JMU-CIME/flatio-playground/blob/main/test-all-urls.html