Playlist Debugging

[Anonymous]

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

[rpedde]

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

foo@bar:~$ 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”

[Anonymous]

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

[rpedde]

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.

[Anonymous]

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

[rpedde]

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%’

[Anonymous]

That worked, thanks. 🙂

Andy

[rpedde]

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

[Anonymous]

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

Andy

[rpedde]

Yup. Everything.

[Author]

Posts