I have updated the SVN release, which in and of itself isn’t news, but I think we’re getting closer to a proper release. A few things to note:

* I have added an option to manageshows.pl (-s) to allow you to import an existing .shows file. It *should* pull in your shows, qualities and templates, but please be sure to check the DB manually to make sure everything imported correctly.

* There have been some schema changes (sorry!). Due to limitations in sqlite (no alter column allowed) we cannot just update the schema so you’ll need to reinit your DB. The good news is that it never hurts to reinitialize, and now with being able to import a .shows file hopefully this will be less painful. I am trying to anticipate any data we could want to use and get it into the schema now, so that we won’t have to mess about with this stuff once we’ve made the release.

For anyone who is interested, you can get the latest head here: https://nzbivo.svn.sourceforge.net/svnroot/nzbivo/

The rev notes and code changes for this rev is here:
http://nzbivo.svn.sourceforge.net/viewvc/nzbivo?view=rev&revision=31

Completely off topic (and on my soapbox), here is to Liverpool overtaking Man U in the Premiere League… C. Ronaldo can suck it

OK, so I took some time to stop and think about what I was doing, and I decided that the OO path I took with NG of nzbivo was dumb.

So, I have rewritten it. The main thing we’re sporting this time, which is frikkin slick, is sqlite3 DB support. This allows us to offload a lot of the logic to the DB via simple SQL queries.

You may have to add some new modules (such as DBI and DBD::SQlite, and Maybe LWP::UserAgent::WithCache), but I think it’s worth it.

A few other notes, since everything is done via the DB, you have to get shows in there to start with. I have included a basic script for adding and removing shows from the DB named (cleverly enough) "manageshows.pl". Usage is pretty easy, the first time you run it, it’ll initialize the DB for you. You just do manageshows.pl -a "name of show" to add a show, -d to delete, etc. You can also use -q to add the quality attribute to the show, and you add templates with -t. The templates need to be a comma separated list. So essentially, each <Search> item you had in your .shows file previously.

This is still pretty rough around the edges. It currently doesn’t do very much TZ logic, so there will be some issues there. Also, if you want to make changes to a show once it’s been added to the DB, you either have to remove and readd it, or edit it by hand with the sqlite client.

I think thats about it, it’s in subversion as revision 19, so if you’re feeling lucky, go wild. (0 comments)