updating functionality

1 files changed, 27 insertions, 0 deletions

diff --git a/spec/active_relation/unit/relations/update_spec.rb b/spec/active_relation/unit/relations/update_spec.rb
new file mode 100644
index 0000000000..c26e7fb525
--- /dev/null
+++ b/spec/active_relation/unit/relations/update_spec.rb
@@ -0,0 +1,27 @@
+require File.join(File.dirname(__FILE__), '..', '..', '..', 'spec_helper')
+
+module ActiveRelation
+  describe Update do
+    before do
+      @relation = Table.new(:users)
+    end
+  
+    describe '#to_sql' do
+      it 'manufactures sql updating attributes' do
+        Update.new(@relation, @relation[:name] => "nick").to_sql.should be_like("""
+          UPDATE `users`
+          SET `users`.`name` = 'nick'
+        """)
+      end
+      
+      it 'manufactures sql updating a selection relation' do
+        Update.new(@relation.select(@relation[:id].equals(1)), @relation[:name] => "nick").to_sql.should be_like("""
+          UPDATE `users`
+          SET `users`.`name` = 'nick'
+          WHERE `users`.`id` = 1
+        """)
+      end
+      
+    end
+  end
+end
\ No newline at end of file