songbird.rb

gistfile1.txt

require 'rubygems'
require 'sequel'
require 'cgi'
require 'splat'

home = File.expand_path '~'
profiles = "#{home}/Library/Application Support/Songbird2/Profiles"
profile = "e6rg7czm.default"
db_path = "#{profiles}/#{profile}/db/main@library.songbirdnest.com.db"

db = Sequel.sqlite db_path

total_tracks = db[:media_items].count
loop do
  id = (rand * total_tracks).to_i
  row = db[:media_items][:media_item_id=>id]
  if row
    path = CGI.unescape(row[:content_url].slice(7..-1)) if row[:content_url] =~ /^file/
    if path
      puts path
      "\"#{path}\"".to_player if path
    end
  end
end

the story so far

/Users/Shared/Music/N/Nada Surf/North 6th Street/03 Ice Box (Demo).mp3
/Users/Shared/Music/S/Swervedriver/Ejector Seat Reservation/05 I Am Superman.mp3
/Users/Shared/Music/T/Twilight Hotel/2008 01 29 Highway Prayer/09 The Critic.mp3
/Users/Shared/Music/A/Laurie Anderson/1982 Big Science/04 Walking & Falling.mp3
/Users/Shared/Music/W/Wasinger, Tom & Harvey, Jim/1991 - Track to Bumbliwa/12 Uluru.mp3
/Users/Shared/Music/B/The Bicycles/2006 00 00 The Good, the Bad, and the Cuddly/05 I Know We Have to Be Apart.mp3
/Users/Shared/Music/T/TrinityRoots/2003 06 True/01 True.mp3
/Users/Shared/Music/G/Guns N' Roses/1991 - Use Your Illusion/03 Live and Let Die.mp3
/Users/Shared/Music/S/Something For Kate/Echolalia/10 Manmade Horse.mp3
/Users/Shared/Music/S/Supertramp/1986 - The Autobiography Of/05 Rudy.mp3