You are here: Home » Topic » Playlist Debugging

Playlist Debugging

This topic contains 9 replies, has 2 voices, and was last updated by  rpedde 11 years, 7 months ago.

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #198

    ajayre
    Participant

    I have about 2,500 tracks, 98% of which are either rock, pop or alternative.
    I have the following playlist:

    genre includes “rock” OR genre includes “pop” OR genre includes “alt”

    so this playlist should have 2,000+ tracks in it.

    I’ve been playing this playlist on my SoundBridge using shuffle for the last few days (total of maybe 6-8 hours), however I keep hearing Queen’s Bohemian Rhapsody for some reason. Probably 5 or 6 times now. It also seems to play tracks from certain albums a lot as well.

    OK, so I believe that the SoundBridge performs the shuffling, but how I can I found out how large this playlist is in terms of number of tracks? I want to work out if the playlist is not right or the SoundBridge shuffle doesn’t work properly (or how I expect)?

    Thanks.

    Andy

    Post edited by: ajayre, at: 2006/03/09 20:53

    #4087

    rpedde
    Participant

    it’s in the playlists table, in the “items” column.


    [email protected]:~$ sqlite3 /path/to/songs3.db
    sqlite> select name, items from playlists;
    Library|0
    Some playlist|20
    Some other playlist|50

    — Ron

    p.s. if you are using sqlite2, then it’s “sqlite /path/to/songs.db”

    #4088

    ajayre
    Participant

    I did the following:

    sqlite> select title, items from playlists;

    and got:


    80's Music|0
    90's Music|0
    Music from Today|0
    Rock, Pop and Alternative|0
    80's Rock|0
    80's Pop|0
    80's Alternative|0
    90's and Later Rock|0
    90's and Later Pop|0
    90's and Later Alternative|0
    Recently Played|0
    Recently Added|0

    which doesn’t appear to be right.

    Andy

    #4089

    rpedde
    Participant

    It should update playlist counts when you connect. That’s really strange.

    Try connecting with iTunes, then disconnecting. Then see if the total are updated.

    #4090

    ajayre
    Participant

    Even with the SoundBridge connected and playing, and after turning off the SB, it shows the same result. Only two playlists have values and those are the iTunes xml playlists.

    Andy

    #4091

    rpedde
    Participant

    Dunno. Should be updating playlist item counts after every scan.

    You can always enter that query manually:

    select count(*) from songs where genre like ‘%rock%’ or genre like ‘%pop%’ or genre like ‘%alt%’

    #4092

    ajayre
    Participant

    That worked, thanks. 🙂

    Andy

    #4093

    rpedde
    Participant

    If you have firefox or explorer, or a browser capable of displaying xml without a dtd (NOT safari), then you could also do something like:


    http://server:port/databases/1/containers?output=xml

    then you’d see all your playlists, including the dmap.itemid of a playlist you wanted to inspect. Say the dmap.itemid was 307. To see what files are on that playlist, do:


    http://server:port/databases/1/containers/307/items?output=xml

    and you’ll have a list of all your items, probably just with itemkind, itemid, and itemname. To see more interesting stuff, try something like this:


    http://server:port/databases/1/containers/307/items?output=xml&meta=daap.songartist,daap.songalbum,dmap.itemid,dmap.itemname

    See, wouldn’t a nice ajaxian front-end on the web server be cool?

    sigh.

    — Ron

    #4094

    ajayre
    Participant

    Pretty nice. Can you use this interface to get things like play_count, bpm, etc?

    Andy

    #4095

    rpedde
    Participant

    Yup. Everything.

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic.