diff options
Diffstat (limited to 'spec')
-rw-r--r-- | spec/arel/delete_manager_spec.rb | 42 | ||||
-rw-r--r-- | spec/arel/select_manager_spec.rb | 25 |
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 |