aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/engines/sql/unit/predicates/equality_spec.rb
diff options
context:
space:
mode:
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