Custom recording rules

[mvallevand]

I have an earlier request to only record HD channels open (if that is what no response means) but it might never happen which might be find. Looking over the For The Record options I found an option "NotOnChannels" that got me thinking I might be able to make myself a utility or even work via UJB's NEWA to add more option there and to avoid more options to NextPVR. I assume advancedRules get merged with another string, Is this the one you use?

Code:

select * from EPG_EVENT where title=? and end_time>? order by start_time
@time

For information I have broken down the NextPVR options and the other options in FTR that need a custom rule

Code:

AroundTime                   Record the timeslot closest to the given start time (usually combined with TitleEquals).  
StartingBetween              Record a program when its start time is between the two given times.  
OnDate                       Record on this specific date (mutually exclusive with DaysOfWeek).  
DaysOfWeek                   Record on these days of the week (mutually exclusive with OnDate), with second optional starting date argument.  
TitleEquals                  Record program with the given title.  
TitleStartsWith              Record program who's title starts with the given text.  
ManualSchedule               If this rule is added the schedule is a manual schedule with the given datetime and duration (ScheduleTime) arguments. When this rule is specified the TvChannels rule must be present with exactly one channel. The DaysOfWeek rule with one argument is optional, and no other rules are allowed.  
NewEpisodesOnly              If this is true, don't include programs that were already recorded before custom logic in NextPVR
NewTitlesOnly                If this is true, don't include programs that were already recorded before (based on new flag only).  not in FTR

Channels                     Record on the given channel(s). Arguments are one or more channel IDs.  
NotOnChannels                Do not record on the given channel(s). Arguments are one or more channel IDs.  

SubTitleEquals               Record program with the given sub-title.  
SubTitleStartsWith           Record program who's sub-title starts with the given text.  
SubTitleContains             Record program who's sub-title contains the given text. If more than one text is given an OR will be applied.  
SubTitleDoesNotContain       Record program who's sub-title does not contain the given text, only valid in combination with at least one SubTitleContains rule.  

EpisodeNumberEquals          Record program with the given episode number.  
EpisodeNumberContains        Record program who's episode number contains the given text. If more than one text is given an OR will be applied.  
EpisodeNumberDoesNotContain  Record program who's episode number does not contain the given text, only valid in combination with at least one EpisodeNumberContains rule.  
EpisodeNumberStartsWith      Record program who's episode number starts with the given text.  

TitleContains                Record program who's title contains the given text. If more than one text is given an OR will be applied.  
TitleDoesNotContain          Record program who's title does not contain the given text, only valid in combination with at least one TitleContains rule.  

DescriptionContains          Record program who's description contains the given text. If more than one text is given an OR will be applied.  
DescriptionDoesNotContain    Record program who's description does not contain the given text, only valid in combination with at least one DescriptionContains rule.  
CategoryEquals               Record programs from any of the categories given as arguments.  
CategoryDoesNotEqual         Don't record programs in any of the categories given as arguments.  
DirectedBy                   Record program directed by given name.  
WithActor                    Record program which has the actor by the given name.  
SkipRepeats                  Only record first-run (non-repeat) programs if the argument to this rule is true.  
NewEpisodesOnly              If this is true, don't include programs that were already recorded before (based on title/sub-title/episode number).  
NewTitlesOnly                If this is true, don't include programs that were already recorded before (based on title only).  
ProgramInfoContains          Record program who's title, episode or description contains the given text. If more than one text is given an OR will be applied.  
ProgramInfoDoesNotContain    Record program who's title, episode or description does not contain the given text, only valid in combination with at least one ProgramInfoContains rule.

Martin

[toricred]

This would be awesome.

[mvallevand]

Sub, did you have a chance to look at my question on the select you used?

Martin

[sub]

It's pretty much "select * from EPG_EVENT where [advanced_rules] order by start_time"

[mvallevand]

Ok thanks that will work well.

Martin

[mvallevand]

Would there be anyway to have a few variables available? The one that I think I need is the SCHEDULED_RECORDING oid that you are processing to make a little fancier duplicate handling.

Thanks,

Martin

[sub]

The attached patch will replace [RECURRING_OID] with the OID.

If you'd need any other variables, you'd need to tell me what you'd want.

[mvallevand]

Because FTR doesn't have the zap2it numbers I need to find a way to skips duplicates based on subtitle which is common http://www.mythtv.org/wiki/Duplicate_matching. I want to use this Nutility call

NUtility.ScheduledRecording ScheduleRecording(string name, int channelOID, bool onlyNewEpisodes, System.DateTime startTime, System.DateTime endTime, int prePadding, int postPadding, NUtility.DayMask dayMask, int keepCount, NUtility.RecordingQuality quality, string advancedRules)

And use advancedRules to against schedule_recording. If subtitle was a separate field I think I'd be there now with

Code:

where title like "some show"
and subtitle not in
(select subtitle from scheduled_recording
where recurrence_oid =  [RECURRING_OID] )

Martin

[sub]

Sorry, I cant easily help you with that one. If any related EPG info exists for a SCHEDULED_RECORDING, it's serialised into the event_details column. It'd be a big change, so not practical for me to change the design of this table to make that logic work.

[mvallevand]

That's why I was thinking of options (so I don't have to write a second database. If you included this line

Code:

[SQLiteFunction(Name = "SubTitle", Arguments = 1, FuncType = FunctionType.Scalar)]
    class MyRegEx1 : SQLiteFunction
    {
        public override object Invoke(object[] args)
        {
            Regex regex = new Regex("<SubTitle>(.+?)</SubTitle>", RegexOptions.IgnoreCase | RegexOptions.Multiline);
            Match match1;
            match1 = regex.Match(Convert.ToString(args[0]));
            if (match1.Success)
            {
                return match1.Groups[1];
            }
            return "";
        }
    }

I might be able to use

Code:

where title like "some show"
and subtitle not in
(select SubTitle(event_details)  from scheduled_recording
where recurrence_oid =  [RECURRING_OID] )

Martin