Adding to the EPG

[markm]

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?

[sub]

How does gbpvr manage this when it does an EPG update?

GB-PVR check if the show exists prior to insert. Its not that slow, and it usually doesnt matter if its slow anyway (normally an unattended process).

How/when does old EPG data get dropped from the database?

Show information that is more than a day or so old, and no longer referenced by recording and deleted during the EPG update process.

[markm]

Show information that is more than a day or so old, and no longer referenced by recording and deleted during the EPG update process.

So the programs I add will get flushed by gbpvr when it does it's update, and I won't have to worry about it? I'm assuming it's simply purging based on either start or end date.

[sub]

yes, thats correct.

Be warned though, the EPG update process is also responsible for scheduling season recordings etc.

[markm]

I don't think season recording should affect me. The programs I'm inserting aren't likely to be recorded in a recurring fashion.

Now I'm just stuck on why I can't do a query against a date in access. I'm doing something stupid, I just can't figure out what. As best I've determined so far, access doesn't use the normal SQL date string of yyyy-mm-dd hh:mms. But even when I convert it to the access format, it still throws an error. :mad:

I'm generating query strings like:

Code:

select oid from programme where channel_oid = 128 and start_time = #04/01/2005 15:00:00#

I keep getting a "COUNT field incorrect" error.

[sub]

I dont use date strings for my queries, so I'm not sure what the format is supposed to be. It might have something to do with no quotes around the date.

[markm]

How do you check to see if the program exists before you insert it? I thought you might use the unique_identifier, but that's not unigue

[KingArgyle]

You can also use the access CDate function.

start_time = Cdate('2004-12-04')

[sub]

I use dates in my queries, but I use ADO.NET parameters, so I'm never actually converting it to a string which seems to be your problem.

[jrockintuitive]

sub, can you post some code with ado.net parameters for dates.

I tried with guide2j and failed miserably.