Album duration possible?

[simbun]

I guess it depends how bad you want it ;-)

If you have a Windows PC then there is a way to do it with foobar2000 and the foo_sqlite plugin. The plugin allows you to run SQL against your music collection (it stores all the tags internally during indexing) which is amazingly useful. I've used the plugin for various purposes before including to pull data for use in MinimServer tagUpdate scripts, but I hadn't tried updating tags before.

I've only run this against a small sample of albums so I have no idea how this would scale, but all you'd need to run is:

Code:

update PlaylistUpdatable
  set album_duration=(select cast(floor(sum(length_seconds)/60) as varchar) || ':' || cast(printf('%02.0f',floor(sum(length_seconds)%60)) as varchar)
                        from Playlist
                        where     playlist_index = active_playlist()
                              and PlaylistUpdatable.album = Playlist.album
                        group by album)
  where playlist_index = active_playlist();

There is another line that creates the PlaylistUpdateable virtual table, but it's causing the post to fail, so I'll leave it out for now just to keep it formatted nicely.

I doubt you want to go to these lengths, but I can't think of another way of doing it.