diff options
author | Carl Lerche <carllerche@mac.com> | 2010-03-12 14:46:37 -0800 |
---|---|---|
committer | Carl Lerche <carllerche@mac.com> | 2010-03-12 14:46:37 -0800 |
commit | e13420c86afb5c31e90cff800f121bd49255b939 (patch) | |
tree | 7089d188061b2a676143add52227e107a5cf9b45 /spec/arel/engines/sql/unit/predicates/equality_spec.rb | |
parent | 0b8b87fb947a746d4e58d11ea73ef20cfb23f576 (diff) | |
download | rails-e13420c86afb5c31e90cff800f121bd49255b939.tar.gz rails-e13420c86afb5c31e90cff800f121bd49255b939.tar.bz2 rails-e13420c86afb5c31e90cff800f121bd49255b939.zip |
We're obviously writing specs for arel. No need for a sub directory.
Diffstat (limited to 'spec/arel/engines/sql/unit/predicates/equality_spec.rb')
-rw-r--r-- | spec/arel/engines/sql/unit/predicates/equality_spec.rb | 75 |
1 files changed, 0 insertions, 75 deletions
diff --git a/spec/arel/engines/sql/unit/predicates/equality_spec.rb b/spec/arel/engines/sql/unit/predicates/equality_spec.rb deleted file mode 100644 index bfd61185f2..0000000000 --- a/spec/arel/engines/sql/unit/predicates/equality_spec.rb +++ /dev/null @@ -1,75 +0,0 @@ -require 'spec_helper' - -module Arel - module Predicates - describe Equality do - before do - @relation1 = Arel::Table.new(:users) - @relation2 = Arel::Table.new(:photos) - @attribute1 = @relation1[:id] - @attribute2 = @relation2[:user_id] - end - - describe '#to_sql' do - describe 'when relating to a non-nil value' do - it "manufactures an equality predicate" do - sql = Equality.new(@attribute1, @attribute2).to_sql - - adapter_is :mysql do - sql.should be_like(%Q{`users`.`id` = `photos`.`user_id`}) - end - - adapter_is :oracle do - sql.should be_like(%Q{"USERS"."ID" = "PHOTOS"."USER_ID"}) - end - - adapter_is_not :mysql, :oracle do - sql.should be_like(%Q{"users"."id" = "photos"."user_id"}) - end - end - end - - describe 'when relation to a nil value' do - before do - @nil = nil - end - - it "manufactures an is null predicate" do - sql = Equality.new(@attribute1, @nil).to_sql - - adapter_is :mysql do - sql.should be_like(%Q{`users`.`id` IS NULL}) - end - - adapter_is :oracle do - sql.should be_like(%Q{"USERS"."ID" IS NULL}) - end - - adapter_is_not :mysql, :oracle do - sql.should be_like(%Q{"users"."id" IS NULL}) - end - end - end - - describe "when relating to a nil Value" do - it "manufactures an IS NULL predicate" do - value = nil.bind(@relation1) - sql = Equality.new(@attribute1, value).to_sql - - adapter_is :mysql do - sql.should be_like(%Q{`users`.`id` IS NULL}) - end - - adapter_is :oracle do - sql.should be_like(%Q{"USERS"."ID" IS NULL}) - end - - adapter_is_not :mysql, :oracle do - sql.should be_like(%Q{"users"."id" IS NULL}) - end - end - end - end - end - end -end |