#!/usr/local/bin/ruby

require 'rubygems'
require 'activerecord'

class Genre < ActiveRecord::Base
  has_many :songs
end

class Song < ActiveRecord::Base
  belongs_to :genre
  belongs_to :album
  has_and_belongs_to_many :nodes
end

class Node < ActiveRecord::Base
  has_and_belongs_to_many :songs
end

ActiveRecord::Base.establish_connection(
  :hostname => 'localhost',
  :username => 'music_app',
  :password => 'music_app',
  :adapter => 'mysql',
  :database => 'music_app'
)

g = Genre.find_by_name('Rap')

p 'Rap is...'
p g.description

rap_songs = g.songs

rap_songs.each do |song|
  p song.title
end