adding a "not" factory method for creating Not nodes

2 files changed, 25 insertions, 0 deletions

diff --git a/test/nodes/test_not.rb b/test/nodes/test_not.rb
new file mode 100644
index 0000000000..7dffdea0c8
--- /dev/null
+++ b/test/nodes/test_not.rb
@@ -0,0 +1,20 @@
+require 'helper'
+
+module Arel
+  module Nodes
+    describe 'not' do
+      describe '#not' do
+        it 'makes a NOT node' do
+          attr = Table.new(:users)[:id]
+          left  = attr.eq(10)
+          right = attr.eq(11)
+          node  = left.or right
+          node.expr.left.must_equal left
+          node.expr.right.must_equal right
+
+          knot = node.or(right).not
+        end
+      end
+    end
+  end
+end
diff --git a/test/visitors/test_to_sql.rb b/test/visitors/test_to_sql.rb
index b84730eeb4..89f3f60de2 100644
--- a/test/visitors/test_to_sql.rb
+++ b/test/visitors/test_to_sql.rb
@@ -33,6 +33,11 @@ module Arel
         @visitor.accept 2.14
       end
 
+      it "should visit_Not" do
+        sql = @visitor.accept Nodes::Not.new(Arel.sql("foo"))
+        sql.must_be_like "NOT foo"
+      end
+
       it "should visit_Bignum" do
         @visitor.accept 8787878092
       end