delete manager added

2 files changed, 67 insertions, 0 deletions

diff --git a/spec/arel/delete_manager_spec.rb b/spec/arel/delete_manager_spec.rb
new file mode 100644
index 0000000000..88d4df061a
--- /dev/null
+++ b/spec/arel/delete_manager_spec.rb
@@ -0,0 +1,42 @@
+require 'spec_helper'
+
+module Arel
+  describe 'delete manager' do
+    describe 'new' do
+      it 'takes an engine' do
+        Arel::DeleteManager.new Table.engine
+      end
+    end
+
+    describe 'from' do
+      it 'uses from' do
+        table = Table.new(:users)
+        dm = Arel::DeleteManager.new Table.engine
+        dm.from table
+        dm.to_sql.should be_like %{ DELETE FROM "users" }
+      end
+
+      it 'chains' do
+        table = Table.new(:users)
+        dm = Arel::DeleteManager.new Table.engine
+        check dm.from(table).should == dm
+      end
+    end
+
+    describe 'where' do
+      it 'uses where values' do
+        table = Table.new(:users)
+        dm = Arel::DeleteManager.new Table.engine
+        dm.from table
+        dm.where table[:id].eq(10)
+        dm.to_sql.should be_like %{ DELETE FROM "users" WHERE "users"."id" = 10}
+      end
+
+      it 'chains' do
+        table = Table.new(:users)
+        dm = Arel::DeleteManager.new Table.engine
+        check dm.where(table[:id].eq(10)).should == dm
+      end
+    end
+  end
+end
diff --git a/spec/arel/select_manager_spec.rb b/spec/arel/select_manager_spec.rb
index a728366e0e..01d1b35004 100644
--- a/spec/arel/select_manager_spec.rb
+++ b/spec/arel/select_manager_spec.rb
@@ -23,6 +23,31 @@ module Arel
   end
 
   describe 'select manager' do
+    describe 'delete' do
+      it "copies from" do
+        engine  = EngineProxy.new Table.engine
+        table   = Table.new :users
+        manager = Arel::SelectManager.new engine
+        manager.from table
+        manager.delete
+
+        engine.executed.last.should be_like %{ DELETE FROM "users" }
+      end
+
+      it "copies where" do
+        engine  = EngineProxy.new Table.engine
+        table   = Table.new :users
+        manager = Arel::SelectManager.new engine
+        manager.from table
+        manager.where table[:id].eq 10
+        manager.delete
+
+        engine.executed.last.should be_like %{
+          DELETE FROM "users" WHERE "users"."id" = 10
+        }
+      end
+    end
+
     describe 'update' do
       it 'takes a string' do
         engine  = EngineProxy.new Table.engine