aboutsummaryrefslogtreecommitdiffstats
path: root/spec/arel/unit/predicates/predicates_spec.rb
diff options
context:
space:
mode:
authorBryan Helmkamp <bryan@brynary.com>2009-05-16 21:13:32 -0400
committerBryan Helmkamp <bryan@brynary.com>2009-05-17 13:17:07 -0400
commit49d119ae84bbb7cd180ca855cf48997dc731554c (patch)
tree3bae397d3e2b5ee76bd89a87ccbf421d814fec74 /spec/arel/unit/predicates/predicates_spec.rb
parent4096d192a1e7cdf0115f5a4cf33d102b176cb8cd (diff)
downloadrails-49d119ae84bbb7cd180ca855cf48997dc731554c.tar.gz
rails-49d119ae84bbb7cd180ca855cf48997dc731554c.tar.bz2
rails-49d119ae84bbb7cd180ca855cf48997dc731554c.zip
Adding spec:mysql and spec:sqlite3 tasks
Diffstat (limited to 'spec/arel/unit/predicates/predicates_spec.rb')
-rw-r--r--spec/arel/unit/predicates/predicates_spec.rb36
1 files changed, 28 insertions, 8 deletions
diff --git a/spec/arel/unit/predicates/predicates_spec.rb b/spec/arel/unit/predicates/predicates_spec.rb
index d11637cabe..8f9cec5376 100644
--- a/spec/arel/unit/predicates/predicates_spec.rb
+++ b/spec/arel/unit/predicates/predicates_spec.rb
@@ -9,23 +9,43 @@ module Arel
@operand1 = Equality.new(@attribute1, 1)
@operand2 = Equality.new(@attribute2, "name")
end
-
+
describe "when being combined with another predicate with AND logic" do
describe "#to_sql" do
it "manufactures sql with an AND operation" do
- @operand1.and(@operand2).to_sql.should be_like("
- (`users`.`id` = 1 AND `users`.`name` = 'name')
- ")
+ sql = @operand1.and(@operand2).to_sql
+
+ adapter_is :mysql do
+ sql.should be_like(%Q{
+ (`users`.`id` = 1 AND `users`.`name` = 'name')
+ })
+ end
+
+ adapter_is_not :mysql do
+ sql.should be_like(%Q{
+ ("users"."id" = 1 AND "users"."name" = 'name')
+ })
+ end
end
end
end
-
+
describe "when being combined with another predicate with OR logic" do
describe "#to_sql" do
it "manufactures sql with an OR operation" do
- @operand1.or(@operand2).to_sql.should be_like("
- (`users`.`id` = 1 OR `users`.`name` = 'name')
- ")
+ sql = @operand1.or(@operand2).to_sql
+
+ adapter_is :mysql do
+ sql.should be_like(%Q{
+ (`users`.`id` = 1 OR `users`.`name` = 'name')
+ })
+ end
+
+ adapter_is_not :mysql do
+ sql.should be_like(%Q{
+ ("users"."id" = 1 OR "users"."name" = 'name')
+ })
+ end
end
end
end