path: root/spec/arel/engines/sql/unit/relations/table_spec.rb

require File.join(File.dirname(__FILE__), '..', '..', '..', '..', '..', 'spec_helper')

module Arel
  describe Table do
    before do
      @relation = Table.new(:users)
    end

    describe '#to_sql' do
      it "manufactures a simple select query" do
        sql = @relation.to_sql

        adapter_is :mysql do
          sql.should be_like(%Q{
            SELECT `users`.`id`, `users`.`name`
            FROM `users`
          })
        end

        adapter_is_not :mysql do
          sql.should be_like(%Q{
            SELECT "users"."id", "users"."name"
            FROM "users"
          })
        end
      end
    end

    describe '#column_for' do
      it "returns the column corresponding to the attribute" do
        @relation.column_for(@relation[:id]).should == @relation.columns.detect { |c| c.name == 'id' }
      end
    end

    describe '#attributes' do
      it 'manufactures attributes corresponding to columns in the table' do
        @relation.attributes.should == [
          Attribute.new(@relation, :id),
          Attribute.new(@relation, :name)
        ]
      end

      describe '#reset' do
        it "reloads columns from the database" do
          lambda { stub(@relation.engine).columns { [] } }.should_not change { @relation.attributes }
          lambda { @relation.reset                       }.should     change { @relation.attributes }
        end
      end
    end

    describe 'hashing' do
      it "implements hash equality" do
        Table.new(:users).should     hash_the_same_as(Table.new(:users))
        Table.new(:users).should_not hash_the_same_as(Table.new(:photos))
      end
    end

    describe '#engine' do
      it "defaults to global engine" do
        Table.engine = engine = Sql::Engine.new
        Table.new(:users).engine.should == engine
      end

      it "can be specified" do
        Table.new(:users, engine = Sql::Engine.new).engine.should == engine
      end
    end
  end
end