Today’s project was this little python script. This runs on a Mac, but goes out and grabs the sqlite database from a system that’s running Boxee, finds anything that’s been watched in Boxee in the last two days, then talks to iTunes and marks things watched there as well. This is so if we watch something on Boxee, the blue “unplayed” dot will also go away on the AppleTV in the other room.
Next project, I suppose, is doing the same thing in reverse: letting Boxee know when we’ve watched something on the AppleTV. That’s only possible with the old AppleTV right now, the new one doesn’t even sync the watched flag with iTunes any more. I hope they will add that in an update, but the rental model is their main push right now, not helping me out with my crazy setup.
This requires appscript and tvnamer for Python. tvnamer is a great Python module that is able to parse filenames and turn them into structured TV episode data. It’s often used in conjunction with tvdb_api to get descriptions, banners, etc. in media center applications based on nothing but filenames. I have another project that does just that, but today’s script only needs tvnamer.
This is the first time I’ve used the applescript binding for python, I was happy to see how easy it was. Applescript itself is an awful language, hurray for not actually having to write any! It’s also the first time I’ve used sqlite in a program, though I’ve messed with other programs’ databases by hand before.