[mythtv-users] MythMusic Playlists Based on Directory Structure

[Jan Ceuleers]

moodyjunk at frontiernet.net wrote:
> I want to generate playlists based on my directory structure (all mp3s  
> inside a particular directory subtree) but can't find a way to do that  
> in MythMusic.  Any suggestions?

Here's a hint (extract from an SQL script I use for this purpose):

delete from music_playlists where playlist_name="Alternative dir";

select song_id from music_songs,music_directories where 
music_songs.directory_id=music_directories.directory_id and 
music_directories.path like "Alternative%" order by 
reverse(music_songs.name) into outfile "/tmp/Alternative.out" lines 
terminated by ",";

insert into music_playlists set playlist_name="Alternative 
dir",hostname="fe2",playlist_songs=load_file("/tmp/Alternative.out"),length=10,songcount=5;
insert into musicplaylist set name="Alternative dir", 
hostname="fe2",songlist=load_file("/tmp/Alternative.out");

HTH, Jan