aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/engines/sql/unit/predicates/equality_spec.rb
diff options
context:
space:
mode:
authorCarl Lerche <carllerche@mac.com>2010-03-12 14:46:37 -0800
committerCarl Lerche <carllerche@mac.com>2010-03-12 14:46:37 -0800
commite13420c86afb5c31e90cff800f121bd49255b939 (patch)
tree7089d188061b2a676143add52227e107a5cf9b45 /spec/arel/engines/sql/unit/predicates/equality_spec.rb
parent0b8b87fb947a746d4e58d11ea73ef20cfb23f576 (diff)
downloadrails-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.rb75
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