require "test/unit"
require "rubygems"
require "ruby-debug"
require "active_record"
require File.dirname(__FILE__) + '/../test_libs/acts_as_tree'
require File.dirname(__FILE__) + '/../test_libs/ordered_hash'
require File.dirname(__FILE__) + '/../test_libs/rexml_fix'
require File.dirname(__FILE__) + '/../lib/searchgasm'

ActiveRecord::Base.establish_connection(:adapter => "sqlite3", :dbfile => ":memory:")

class Account < ActiveRecord::Base
  has_one :admin, :class_name => "User", :conditions => {:first_name => "Ben"}
  has_many :users, :dependent => :destroy
  has_many :orders, :through => :users
  
  named_scope :scope1, :conditions => {:users => {:first_name_contains => "Ben"}}
end

class UserGroup < ActiveRecord::Base
  has_and_belongs_to_many :users
end

class User < ActiveRecord::Base
  acts_as_tree
  belongs_to :account
  has_many :orders, :dependent => :destroy
  has_many :cats, :dependent => :destroy
  has_many :dogs, :dependent => :destroy
  has_and_belongs_to_many :user_groups
end

class Order < ActiveRecord::Base
  belongs_to :user
end

# STI
class Animal < ActiveRecord::Base
end

class Dog < Animal
end

class Cat < Animal
end

class Test::Unit::TestCase
  def setup_db
    ActiveRecord::Schema.define(:version => 1) do
      create_table :accounts do |t|
        t.datetime  :created_at    
        t.datetime  :updated_at
        t.string    :name
        t.boolean   :active
      end

      create_table :user_groups do |t|
        t.datetime  :created_at      
        t.datetime  :updated_at
        t.string    :name
      end
      
      create_table :user_groups_users, :id => false do |t|
        t.integer :user_group_id
        t.integer :user_id
      end
      
      create_table :users do |t|
        t.datetime  :created_at      
        t.datetime  :updated_at
        t.integer   :account_id
        t.integer   :parent_id
        t.string    :first_name
        t.string    :last_name
        t.boolean   :active
        t.text      :bio
      end

      create_table :orders do |t|
        t.datetime  :created_at      
        t.datetime  :updated_at
        t.integer   :user_id
        t.float     :total
        t.text      :description
        t.binary    :receipt
      end
      
      create_table :animals do |t|
        t.datetime  :created_at      
        t.datetime  :updated_at
        t.string   :type
        t.text     :description
      end
    end
  end
  
  def load_fixtures
    fixtures = [:accounts, :orders, :users, :user_groups, :dogs, :cats]
    fixtures.each do |fixture|
      records = YAML.load(File.read(File.dirname(__FILE__) + "/fixtures/#{fixture.to_s}.yml"))
      records.each do |name, attributes|
        record = fixture.to_s.singularize.classify.constantize.new
        attributes.each { |k, v| record.send("#{k}=", v) }
        record.save!
      end
    end
    
    # Not sure why I have to do this, but sick of dealing with it
    UserGroup.all.each do |user_group|
      user_ids = user_group.user_ids.uniq!
      user_group.users.clear
      user_group.user_ids = user_ids
      user_group.save!
    end
    
    # Create the cached virtual classes
    fixtures.each { |fixture| fixture.to_s.classify.constantize.new_search }
  end
  
  def teardown_db
    ActiveRecord::Base.connection.tables.each do |table|
      ActiveRecord::Base.connection.drop_table(table)
    end
  end
  
  def setup
    setup_db
    load_fixtures
  end
  
  def teardown
    teardown_db
  end
end