#!/usr/bin/env ruby
%w|rubygems active_record irb|.each {|lib| require lib}
class Vendor < ActiveRecord::Base
  has_many :vendor_models
end
 
class VendorModel < ActiveRecord::Base
  belongs_to :vendor
  has_many :servers
end
 
class Rack < ActiveRecord::Base
  has_many :servers
end
 
class Server < ActiveRecord::Base
  belongs_to :rack
  belongs_to :vendor_model
end
 
ActiveRecord::Base.logger = Logger.new(STDOUT)
ActiveRecord::Base.establish_connection(
  :adapter => "sqlite3",
  :database => ":memory:"
)
 
ActiveRecord::Schema.define do
  create_table :racks do |t|
    t.string :building
    t.string :room
    t.string :row
  end
  create_table :servers do |t|
    t.string :name
    t.string :ip
    t.string :os
    t.integer :vendor_model_id
    t.integer :rack_id
  end
  create_table :vendors do |t|
    t.string :name
  end
  create_table :vendor_models do |t|
    t.string :name
    t.integer :vendor_id
  end  
end
 
rack1 = Rack.create(:building => "The big one", :room => "something", :row => "12a")
dell = Vendor.create(:name => "Dell")
power_edge = VendorModel.create(:vendor => dell, :name => "PowerEdge R905")
server1 = Server.create(
  :name => "web01",
  :vendor_model => power_edge,
  :rack => rack1,
  :ip => "123.456.789.0",
  :os => "Ubuntu bitches"
)
 
IRB.start if __FILE__ == $0