Changing the recording priority on recurring recordings

[cbgifford]

I have a large household and record quite a bit and I have a need to be able to change the recording priority from time to time. I normally have enough tuners to record everything but sometimes I want to be able to watch a show as soon as it comes on.

I've looked at the recurring_recording table and I've got a pretty good concept of what needs to be done. I would need to reorder everything below a recording that I moved up and visa versa on a recording that I moved down. Then I would need to update the recurrence_oid for everything in the scheduled_recording table. Since the OID and priority fields are the same I would keep them the same, however, I don't see an underlying reason to do so as long as the recurrence_oid matched the oid. Have I missed anything?

I probably would not be good at writing a plug in but more as a stand-alone utility managing the database tables.

[mvallevand]

Did you consider using the UI to move them, kind of a manual bubble sort?

Martin

[cbgifford]

Did you consider using the UI to move them, kind of a manual bubble sort?

Martin

If you're talking about the Sort option on the menu at the top of the Recurring recordings display, it appears to be appearance only, A-Z, Z-A, Priority Ascending, Priority Descending. If you mean in the SQLite DB browser app, I'm not sure how I would be able to accomplish that programmatically. If you're talking about some other UI, I would have no idea where. I was under the impression after searching the forums that there is no way to do it and it's one of the things Sub has on his to-do list

[sub]

If you've got one of the priority orders selected, you can use the skip buttons to move the selected item up/down the priority list.

[Kiwi]

The keyboard equivalent for "skip left" and "skip right" are the Ctrl-Left and Ctrl-Right.