[mythtv-users] HD Homerun Prime Scripting

[Ozzy Lash]

On Mon, Oct 17, 2011 at 11:51 PM, Kirk Bocek <t004 at kbocek.com> wrote:
>
>
> On 10/17/2011 5:32 PM, Gary Buhrmaster wrote:
>> On Mon, Oct 17, 2011 at 23:57, Kirk Bocek<t004 at kbocek.com>  wrote:
>> ....
>>> So let me phrase it in terms of what seems like a widely used utility:
>>> scte65scan. Bill Lash here extracted some simple SQL here for inserting
>>> records into dtv_multiplex. Can I get anyone to comment on *that* code?
>>
>> I am not a MythTV developer, and therefore have no standing,  but.....
>>
>> I consider that I run it at my own risk, and should something "weird"
>> happen with MythTV, it is all my fault, and until I reproduce any issues
>> with a clean database, the presumption *should* be that I messed
>> something up.  Full disclosure, I also occasionally use direct
>> database updates.  The moment I type 'mysql' I consider that the
>> MythTV database is "tainted" in the same terms that the Linux kernel
>> developers do.  That is, I am completely and utterly on my own, and
>> should ask no one for assistance.
>>
>> Gary
>
> Gary, I'm not sure if you're telling me I shouldn't be asking questions
> here. I have a script that is certainly going to help *me*. It's going
> to save broken recordings which is currently how I find out Comcast has
> changed channels on me. If it's going to help me, it must also help
> others if they choose to use it.
>
> I'd like that script to be as bullet-proof as possible and to play as
> nicely as possible with Myth. It seems reasonable to ask for guidance on
> what I'm doing. Robert has very good reasons for why that guidance is
> not likely to come. I'm a little put off by that answer. So I'll
> strengthen the warnings in my script, incorporate Robert's philosophy
> about direct database manipulation and just put it out there and hope it
> helps others.
>
> Kirk Bocek
>

While I understand Robert's concern, I think anyone using clear qam
today is doing some sort of database manipulation to get the channels
in the database.  I like his suggestion of trying to get what you are
trying to do in mythtv itself, but I think there are some issues with
that, since you are updating information for your clear qam sources
with information from a cablecard source.

I do think that you have a good script for maintaining clear qam
channels.  I think it would be pretty easy to create something like
scte65scan which would work using the hdhrcc to get an initial set of
channels.  The process would be something like:

1. use hdhomerun_config to scan all the channels selecting any
programs that aren't marked as encrypted.
2. tune to each of the non-encrypted channels using the frequency and
programid from the initial scan, and get the vchannel, and other
information (channel name, ...)
3. match the frequency up with the dtv_multiplex table


I may be missing a few clear qam channels today that have crept in
since my initial scte65scan.  My guess is, that they aren't channels
that I care about, but there might be something there.

Bill