patch to assist scheduling unique (new) movies

[tom@…]

I run a terabyte server which I use to store edited movies. The server is accessable to mythtv via nfs. This the "Utilities/setup | Setup | Media setup | Videos settings | General settings" and "directory which holds videos" (mounted as '/VideoLib?'). Currently, I have 300+ movies in that directory. I found two issues with the stock behavior of "Manage recordings | Schedule recordings | Search lists | Movies" which made the scheduling rather tedious:

1) by nature, the schedule is organized by date + time + title. This causes replications I had to weed my way through, I found that I would duplicate recording of the same movie twice as I forgot that I had already scheduled an earlier showing.

2) Once I got up around 80 or so movies in /VideoLib? I started to schedule movies that I already had on the video server. Once I had gone through the list of movies and scheduled them for recording, I would then have to tediously check for duplicates.

This patch does two things:

A) it changes the display of the movie list so that it is sorted by: title + unique. B) it also removes titles which currently exist within the /VideoLib? (current copies on the Video Library).

I did this by modifying the proglist.cpp so that an additional choice was added to the popup menu: "Unique". By selecting "Unique", a new mysql command is issued to do the "unique" and "left join" to present me with the desired listing. This has made the scheduling of new movies so much easier and I would like to see this added to upcoming releases of MythTV so I won't have to re-patch?

Regards,

TomW

[tom@…]

patch to schedule from unique lists movies minus those already in video libary

[tom@…]

patch to schedule from unique lists movies minus those already in video libary

[bjm <bjm@…>]

First, the title sort will list one item per title. GROUP BY is no good because it doesn't have to return the earliest time. "videometadata" is not a table of the TV module and putting entries into the oldrecorded table would be a more sensible to indicate that a title doesn't need to be recorded again. If you wanted to record titles excluding those that are in "videometadata", you could do so with a custom rule. "Unique" is always ambigous and never clearly defines what something is or what it does. Finally, this really isn't something that is of general interest to most users (in fact, it may be confusing or useless to anyone but yourself). So to avoid creeping featurism I see no reason to impose this on anyone else. You may certainly apply this to your own tree if you find it useful.

Post any discussion to the mailing list and not to this database.