Couple of questions about hacking npvr.db3

[drmargarit]

1) I am adding season and episode data to the subtitle of scheduled_recording. ie. "S08E03 Sheldon and Leonard jump a shark."
---The utility runs in the PostEPGUpdate batch file.
---Does NPVR care if the subtitle changes like that or if it doesn't match what is in epg_event?

2) I want to scan the epg_event table every day and look for series premiers (S01E01) in prime time and automatically add a recurring recording rule for it.
--- If I just add a record to recurring_recording, will NPVR honor that entry? Choke on it?

Once I get this up and running the WAF will be high enough to go live and let SageTV go dark.

Thanks,

Jim Margarit

[sub]

1) I am adding season and episode data to the subtitle of scheduled_recording. ie. "S08E03 Sheldon and Leonard jump a shark."
---The utility runs in the PostEPGUpdate batch file.
---Does NPVR care if the subtitle changes like that or if it doesn't match what is in epg_event?

That should be fine. I don't think it'll cause any problems.

2) I want to scan the epg_event table every day and look for series premiers (S01E01) in prime time and automatically add a recurring recording rule for it.
--- If I just add a record to recurring_recording, will NPVR honor that entry? Choke on it?

If the entry you make is exactly the same as one NextPVR would make, then it should be fine. When it next updates the EPG, and processes the recurring recordings, it'll load and process your new recurring recording.

[drmargarit]

That should be fine. I don't think it'll cause any problems.

If the entry you make is exactly the same as one NextPVR would make, then it should be fine. When it next updates the EPG, and processes the recurring recordings, it'll load and process your new recurring recording.

Great news! Thanks for the ultra quick response.

Jim Margarit

[mvallevand]

If the entry you make is exactly the same as one NextPVR would make, then it should be fine. When it next updates the EPG, and processes the recurring recordings, it'll load and process your new recurring recording.

Note there is a 24 hr gap. If you use the NUtility.ScheduleHelper API in your code you can avoid this

Martin

[sub]

Yep, but my assumption is that his machine is probably going to spot the new shows several days out, so probably not a big problem. Yes, he use the scheduler helper API to avoid waiting for the next day, or manually run -updateepg (assuming he's not running up UpdateEPG.bat/PostUpdateEPG.bat, creating recursion problem)

[mvallevand]

To avoid recursion what about using -recurring

Martin

[sub]

Yep, could probably run "NextPVR -recurring" to tell the server to reprocess recurring recordings.