Maybe one day, I'll convince myself that using MySQL transactions is a good idea, and start using them whenever I do SQL writes.
In related news, I just NULLed out all my coverdata fields in my mythTV's mythvideo table. Regenerating all of that crap is really tedious, as the website's API I use gets flaky after I hit it with a few hundred requests in a matter of minutes. :(
Sigh.
Update:
All fixed. Took ~90 lines of python. Good script to have around anyway: looks for entries with no/missing/invalid coverfile and tries to re-fetch it from thetvdb.com. One day I'll get all this crap into SVN. I'm getting quite the collection of these handy scripts. :)
0 comments:
Post a Comment