Expanding NPVR.db3

[mvallevand]

Sub would it be problematic if I was to add my own node to event_details in the SCHEDULED_RECORDINGS table after a file has been recorded? I'd like to be able to update Season and Episode to valid numbers, plus I'd like to add a new node to show that I have searched it.

Martin

[sub]

I'm not that keen on others updating the data (or structure) in the npvr.db3, but you can probably do it though. I cant guarantee the data isnt lost during various activities though, like exporting/importing etc.

[mvallevand]

Thanks, I would expect it would be lost too and hope the utilities write event_details in there entirety.

Martin

[imilne]

I'm not that keen on others updating the data (or structure) in the npvr.db3, but you can probably do it though. I cant guarantee the data isnt lost during various activities though, like exporting/importing etc.

I'd added a couple of extra tables - that don't interact in any way shape or form with the rest of the database - for my Videos+ plugin. I only put them there because, well, it was easy to do so. Your API already talks to that database and handles setting up the connection and so on. It meant I didn't even need the sqlite libraries as part of my project.

However, if you'd rather I didn't do that then I can put them in their own separate database instead.

And blow you a big raspberry while I'm at it

Iain

[sub]

While I'm not fond of the idea, I can understand it is most straight forward thing to do, so I wont ask you to remove them. Definitely dont modify the structure of existing tables though, and dont do anything that'll hurt performance, like changing indexes or adding triggers on the existing tables.

[imilne]

Thanks sub. On further thought though, I think I will remove them and give them a home of their own. They're probably the last thing you'd want to see when debugging a DB file someone's sent you.

Iain

[mvallevand]

Sub, when sorting recording for an alpha sort in Recordings, I assume the key is the name field or date. Is there are secondary key or is the order of episodes displayed however sqlite wants to optimize it?

Martin

[sub]

Its sorted in code, not using criteria sort criteria in the SQL. From memory, yes its name and date.

[mvallevand]

Sub, next question, in processing the EPG XML it looks like NPVR parses the sub-title data and removes a trailing dot (but not all trailing dots) for some reason. Is there any other odd parsing that goes on? It is not parsing it to make it filename friendly ? and : are in there.

Martin

[sub]

Sub, next question, in processing the EPG XML it looks like NPVR parses the sub-title data and removes a trailing dot (but not all trailing dots) for some reason.

I dont remember it doing that, except for when it's deciding on a filename for a recording.

Is there any other odd parsing that goes on? It is not parsing it to make it filename friendly ? and : are in there.

Nothing specific springs to mind, but it does do quite a bit of manipulation of the characters when constructing a valid filename when starting a recording.