[mythtv-users] mysql query failing after upgrade to 5.5 (Services API solution)

[Bill Meek]

On 08/13/2014 04:13 PM, Karl Newman wrote:
> Hello list,
>
> I'm hoping the resident SQL experts can help me out with this one. For the
> last few months I've been running this SQL statement to find any movies
> which we've recorded that might be re-airing on commercial-free (i.e.,
> premium) channels so I can re-record them:
...

Hi,

Have you considered using Python and the Services API? I believe
you'd have more control over your selection and have the ability
to actually schedule new recording rules.

Something like this: http://pastebin.com/0dtcs0Wg

You might need to change some logic in the section:

     ###########################################
     # Develop a list of programs to schedule. #
     ###########################################

If you try it, just *don't* use the --send option initially
and no recording rules will go your backend. --send is turned
off by default.

Try: rr.py --host=yourMBE --verbose --debug=1

You can add --days=14 to search that many days of guide data
but if you've got a large number of channels/programs, it will
be slower. The default category for the searches is movies
but can be changed with --category=...

There are 4 'canned' programs that will show up if you use
--debug=9. *And if* you modify their data to match yours,
the recording rules can be created for them (again, if --send
is used.) Look under the comment: # For testing only.

Also, by default, only the next day's worth of guide data is
retrieved. Use --days=14 to get everything.

It was tested on 0.28-pre. --help works and may be a good place
to start.

-- 
Bill