2005-04-02, 11:26 PM
There's a perl script available for MythTV to grab the PPV listings for Dish Network, and insert it into Myth's guide.
I'm trying to modify this for gbpvr, and I'm running into a few questions.
The method this script uses to do it's updates on the DB, is to basically flush all the existing shows, and re-insert them each time it's run. I think if I were to do that, I'd break any scheduled recordings for those shows.
From what I can gather, scheduled recordings are stored in recording_schedule table, and reference the program's oid in the programme table. If I drop and re-insert the show, it's oid will change.
My next approach was going to be to do the insert if it doesn't exist route, which is probably going to be horribly slow.
There must be a better way, I'm just drawning a blank.
How does gbpvr manage this when it does an EPG update?
How/when does old EPG data get dropped from the database?
I'm trying to modify this for gbpvr, and I'm running into a few questions.
The method this script uses to do it's updates on the DB, is to basically flush all the existing shows, and re-insert them each time it's run. I think if I were to do that, I'd break any scheduled recordings for those shows.
From what I can gather, scheduled recordings are stored in recording_schedule table, and reference the program's oid in the programme table. If I drop and re-insert the show, it's oid will change.
My next approach was going to be to do the insert if it doesn't exist route, which is probably going to be horribly slow.
There must be a better way, I'm just drawning a blank.
How does gbpvr manage this when it does an EPG update?
How/when does old EPG data get dropped from the database?