This forum has been archived. All content is frozen. Please use KDE Discuss instead.

what mysql query does 'smart playlist make'?

Tags: None
(comma "," separated)
svarog
Karma
0
Hello I am trying to make a script to make browsing my collection easy
see all artists which have certain genre and so on

i keep coming up with crazy stuff

        for i in `seq 1 $totalartists`;
        do
            artist=$(dcop amarok collection query "select name from artist where id = $i;")
        for i in $(dcop amarok collection query "select album from tags where artist = $i;" | sort | uniq | grep -v [2*];)
do line=$(echo -n $artist"@" ;dcop amarok collection query "select name from album where id ="$i"")

the way amarok does it in smart playlist is so nice


"Match all of the following conditions"

Comment contains Blah
and Genre contains bleh

etc, is there any way to see what query amarok makes when i set that?
oneCellar
Registered Member
Posts
2
Karma
0
etc, is there any way to see what query amarok makes when i set that?


You should find it in "~/.kde/share/apps/amarok/smartplaylistbrowser_save.xml". It's encloused in tags.

greets, oC


Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], Google [Bot], Yahoo [Bot]