aboutsummaryrefslogtreecommitdiffstats
path: root/test/test_update_manager.rb
diff options
context:
space:
mode:
Diffstat (limited to 'test/test_update_manager.rb')
-rw-r--r--test/test_update_manager.rb90
1 files changed, 90 insertions, 0 deletions
diff --git a/test/test_update_manager.rb b/test/test_update_manager.rb
new file mode 100644
index 0000000000..670f19d621
--- /dev/null
+++ b/test/test_update_manager.rb
@@ -0,0 +1,90 @@
+require 'spec_helper'
+
+module Arel
+ describe 'update manager' do
+ describe 'new' do
+ it 'takes an engine' do
+ Arel::UpdateManager.new Table.engine
+ end
+ end
+
+ describe 'set' do
+ it "updates with null" do
+ table = Table.new(:users)
+ um = Arel::UpdateManager.new Table.engine
+ um.table table
+ um.set [[table[:name], nil]]
+ um.to_sql.must_be_like %{ UPDATE "users" SET "name" = NULL }
+ end
+
+ it 'takes a string' do
+ table = Table.new(:users)
+ um = Arel::UpdateManager.new Table.engine
+ um.table table
+ um.set Nodes::SqlLiteral.new "foo = bar"
+ um.to_sql.must_be_like %{ UPDATE "users" SET foo = bar }
+ end
+
+ it 'takes a list of lists' do
+ table = Table.new(:users)
+ um = Arel::UpdateManager.new Table.engine
+ um.table table
+ um.set [[table[:id], 1], [table[:name], 'hello']]
+ um.to_sql.must_be_like %{
+ UPDATE "users" SET "id" = 1, "name" = 'hello'
+ }
+ end
+
+ it 'chains' do
+ table = Table.new(:users)
+ um = Arel::UpdateManager.new Table.engine
+ um.set([[table[:id], 1], [table[:name], 'hello']]).must_equal um
+ end
+ end
+
+ describe 'table' do
+ it 'generates an update statement' do
+ um = Arel::UpdateManager.new Table.engine
+ um.table Table.new(:users)
+ um.to_sql.must_be_like %{ UPDATE "users" }
+ end
+
+ it 'chains' do
+ um = Arel::UpdateManager.new Table.engine
+ um.table(Table.new(:users)).must_equal um
+ end
+ end
+
+ describe 'where' do
+ it 'generates a where clause' do
+ table = Table.new :users
+ um = Arel::UpdateManager.new Table.engine
+ um.table table
+ um.where table[:id].eq(1)
+ um.to_sql.must_be_like %{
+ UPDATE "users" WHERE "users"."id" = 1
+ }
+ end
+
+ it 'chains' do
+ table = Table.new :users
+ um = Arel::UpdateManager.new Table.engine
+ um.table table
+ um.where(table[:id].eq(1)).must_equal um
+ end
+ end
+
+ # HACK
+ # describe "TreeManager" do
+ # subject do
+ # table = Table.new :users
+ # Arel::UpdateManager.new(Table.engine).tap do |manager|
+ # manager.table table
+ # manager.where table[:id].eq(1)
+ # end
+ # end
+ #
+ # it_should_behave_like "TreeManager"
+ # end
+ end
+end