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