require 'net/http'
require 'xml/libxml'
require 'rubygems'
require_gem 'activerecord'
# require 'db_address.rb'

ActiveRecord::Base.establish_connection(
    :adapter  => "mysql",
    :username => "root",
    :host     => "localhost",
    :password => "*****",
    :database => "mfinger_cms_db"
)

class Address < ActiveRecord::Base
    self.inheritance_column = "address";
end
class Filename < ActiveRecord::Base
    self.inheritance_column = "filename";
end

Address.find(:all).each do |address|
  # Get the address to the xml document
  http_address = Net::HTTP.new(address.address, 80)
  response = http_address.get(address.filename, nil)

  if response.message == "OK"
    doc = XML::Document.file(response)
    root = doc.root

    puts "Collected prices: #{root.name}"

    elem3 = root.find('elem3').to_a.first
    puts "Elem3: #{elem3['attr']}"

    doc.find('//root_node/foo/bar').each do |node|
      puts "Node path: #{node.path} \t Contents: #{node}"
    end
  end
end