1 files changed, 65 insertions, 0 deletions
diff --git a/spec/arel/engines/sql/unit/predicates/predicates_spec.rb b/spec/arel/engines/sql/unit/predicates/predicates_spec.rb
new file mode 100644
index 0000000000..d55e178e43
--- /dev/null
+++ b/spec/arel/engines/sql/unit/predicates/predicates_spec.rb
@@ -0,0 +1,65 @@
+require File.join(File.dirname(__FILE__), '..', '..', '..', '..', '..', 'spec_helper')
+
+module Arel
+  describe Predicate do
+    before do
+      @relation = Table.new(:users)
+      @attribute1 = @relation[:id]
+      @attribute2 = @relation[:name]
+      @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
+          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 :sqlite3 do
+            sql.should be_like(%Q{
+              ("users"."id" = 1 AND "users"."name" = 'name')
+            })
+          end
+
+          adapter_is :postgresql do
+            sql.should be_like(%Q{
+              ("users"."id" = 1 AND "users"."name" = E'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
+          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 :sqlite3 do
+            sql.should be_like(%Q{
+              ("users"."id" = 1 OR "users"."name" = 'name')
+            })
+          end
+
+          adapter_is :postgresql do
+            sql.should be_like(%Q{
+              ("users"."id" = 1 OR "users"."name" = E'name')
+            })
+          end
+        end
+      end
+    end
+  end
+end