sqLite recording table

[fvfv]

I'm writing a little php utility to rename shows a bit more "Library" friendly, such as "Under the Dome.S01E03.ts" using thetvdb api. I'm sure there are many renamers out there, but none that fit my needs so far.

I'm extremely curious as to how does NPVR pick up the actual file name from the RECORDED table, being that the definition for filename in the recorded table is only varchar(50). How does it know when you have a long folder name like
"c:/media/tvshows/recordings/Beauty and the Beast (2012)/Season 1/Beauty and The Beast_part1.S01E13.20080925110101.ts",
Which obviously is longer than 50 characters.

I know all about the :metadata.xml stream that is part of the actual recording file, but that means that NPVR would have to scan the physical folder at start up to get the actual file name.

Is there another table where the filename is stored ?

My object is to rename the physical file as well as the SQLite database so that I can play the recording with NPVR or any other player.

[martint123]

I thought I'd read a post from sub about this, but can't find it. However, from the sqlite documentation:-

The following table shows how many common datatype names from more traditional SQL implementations are converted into affinities by the five rules of the previous section. This table shows only a small subset of the datatype names that SQLite will accept. Note that numeric arguments in parentheses that following the type name (ex: "VARCHAR(255)") are ignored by SQLite - SQLite does not impose any length restrictions (other than the large global SQLITE_MAX_LENGTH limit) on the length of strings, BLOBs or numeric values.

[sub]

Yep, what he said. SQLite ignores the length specified on a VARCHAR field.

[sub]

BTW, you can also run the following to update the database:

NScriptHelper.exe -rename <old-file-name> <new-file-name>

[fvfv]

No way !!!! Wish I'd known this before.

[sub]

yes way

[johnsonx42]

or you can use Martin's ImageGrabLite utility; as the name implies it started life as an image grabber, but has added renaming and .nfo generation to it's bag of tricks. I realize you said you were writing your own, but IGL already does exactly what you said you wanted. http://www.nextpvr.com/nwiki/pmwiki.php?...geGrabLite

[fvfv]

It turns out I was using sqliteadmin, a pretty old tool for querying sqlite and it "seemed" that the filename was truncated at 50 but in reality sqlite does not impose restrictions on the length.

[mvallevand]

I am now using a full update to IGL for the next version of NextPVR, which is going to be needed because of sqlite changes and also the fact that themoviedb is killing off their XML interface for JSON. If there is some feature you'd like to see let me know. Even you if you prefer your own code, it might be something other IGL users would like.

Martin

[fvfv]

My php script simply queries tvdb and parses out the XML returned. Since I have not tried IGL yet, does it generate NFO files ?, because that would be a really nice feature to have.