aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/engines/sql/unit/predicates/in_spec.rb
diff options
context:
space:
mode:
Diffstat (limited to 'spec/arel/engines/sql/unit/predicates/in_spec.rb')
-rw-r--r--spec/arel/engines/sql/unit/predicates/in_spec.rb110
1 files changed, 56 insertions, 54 deletions
diff --git a/spec/arel/engines/sql/unit/predicates/in_spec.rb b/spec/arel/engines/sql/unit/predicates/in_spec.rb
index 4a3eff79ec..bb00733e60 100644
--- a/spec/arel/engines/sql/unit/predicates/in_spec.rb
+++ b/spec/arel/engines/sql/unit/predicates/in_spec.rb
@@ -1,83 +1,85 @@
require 'spec_helper'
module Arel
- describe In do
- before do
- @relation = Table.new(:users)
- @attribute = @relation[:id]
- end
+ module Predicates
+ describe In do
+ before do
+ @relation = Table.new(:users)
+ @attribute = @relation[:id]
+ end
- describe '#to_sql' do
- describe 'when relating to an array' do
- describe 'when the array\'s elements are the same type as the attribute' do
- before do
- @array = [1, 2, 3]
- end
+ describe '#to_sql' do
+ describe 'when relating to an array' do
+ describe 'when the array\'s elements are the same type as the attribute' do
+ before do
+ @array = [1, 2, 3]
+ end
- it 'manufactures sql with a comma separated list' do
- sql = In.new(@attribute, @array).to_sql
+ it 'manufactures sql with a comma separated list' do
+ sql = In.new(@attribute, @array).to_sql
- adapter_is :mysql do
- sql.should be_like(%Q{`users`.`id` IN (1, 2, 3)})
+ adapter_is :mysql do
+ sql.should be_like(%Q{`users`.`id` IN (1, 2, 3)})
+ end
+
+ adapter_is_not :mysql do
+ sql.should be_like(%Q{"users"."id" IN (1, 2, 3)})
+ end
end
+ end
- adapter_is_not :mysql do
- sql.should be_like(%Q{"users"."id" IN (1, 2, 3)})
+ describe 'when the array\'s elements are not same type as the attribute' do
+ before do
+ @array = ['1-asdf', 2, 3]
+ end
+
+ it 'formats values in the array as the type of the attribute' do
+ sql = In.new(@attribute, @array).to_sql
+
+ adapter_is :mysql do
+ sql.should be_like(%Q{`users`.`id` IN (1, 2, 3)})
+ end
+
+ adapter_is_not :mysql do
+ sql.should be_like(%Q{"users"."id" IN (1, 2, 3)})
+ end
end
end
end
- describe 'when the array\'s elements are not same type as the attribute' do
+ describe 'when relating to a range' do
before do
- @array = ['1-asdf', 2, 3]
+ @range = 1..2
end
- it 'formats values in the array as the type of the attribute' do
- sql = In.new(@attribute, @array).to_sql
+ it 'manufactures sql with a between' do
+ sql = In.new(@attribute, @range).to_sql
adapter_is :mysql do
- sql.should be_like(%Q{`users`.`id` IN (1, 2, 3)})
+ sql.should be_like(%Q{`users`.`id` BETWEEN 1 AND 2})
end
adapter_is_not :mysql do
- sql.should be_like(%Q{"users"."id" IN (1, 2, 3)})
+ sql.should be_like(%Q{"users"."id" BETWEEN 1 AND 2})
end
end
end
- end
-
- describe 'when relating to a range' do
- before do
- @range = 1..2
- end
-
- it 'manufactures sql with a between' do
- sql = In.new(@attribute, @range).to_sql
-
- adapter_is :mysql do
- sql.should be_like(%Q{`users`.`id` BETWEEN 1 AND 2})
- end
-
- adapter_is_not :mysql do
- sql.should be_like(%Q{"users"."id" BETWEEN 1 AND 2})
- end
- end
- end
- describe 'when relating to a relation' do
- it 'manufactures sql with a subselect' do
- sql = In.new(@attribute, @relation).to_sql
+ describe 'when relating to a relation' do
+ it 'manufactures sql with a subselect' do
+ sql = In.new(@attribute, @relation).to_sql
- adapter_is :mysql do
- sql.should be_like(%Q{
- `users`.`id` IN (SELECT `users`.`id`, `users`.`name` FROM `users`)
- })
- end
+ adapter_is :mysql do
+ sql.should be_like(%Q{
+ `users`.`id` IN (SELECT `users`.`id`, `users`.`name` FROM `users`)
+ })
+ end
- adapter_is_not :mysql do
- sql.should be_like(%Q{
- "users"."id" IN (SELECT "users"."id", "users"."name" FROM "users")
- })
+ adapter_is_not :mysql do
+ sql.should be_like(%Q{
+ "users"."id" IN (SELECT "users"."id", "users"."name" FROM "users")
+ })
+ end
end
end
end