[mythtv-users] List of recordings by disc drive

[Hika van den Hoven]

Hoi Mike's,

Monday, February 9, 2015, 4:11:52 AM, you wrote:


> I wonder if someone has already written a MySQL query to extract 
> a list of recordings by disc drive?

> When I am using Dolphin to manage a device, the file name 
> appears to be a channel number plus a time stamp.  Having to 
> play the video for minutes to identify the show/movie and 
> episode is tedious.  It would be helpful to have a list that I 
> could look up 1382_2012011303000.mpg and find that it is Back To 
> The Future IV, or the Simpsons episode where Homer becomes 
> intelligent.

> The ideal query would extract a file with the:  device, file 
> name, and the recording information (series name, episode 
> title...).

> I've been reluctant to write my own, as I'm concerned about 
> unintentionally modifying the database.

> Has anyone done this who would like to share it?  If not, maybe 
> a hint about the tables to access and linkage?

> Mike
> _______________________________________________

That's as basic as it gets:
select title from recorded where basename = ...



Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens