From da667908f6c84ecb5dbf7c3e2b9d22ffe4c386a7 Mon Sep 17 00:00:00 2001 From: Nick Kallen Date: Sat, 23 Feb 2008 16:51:54 -0800 Subject: updating functionality --- spec/active_relation/unit/relations/update_spec.rb | 27 ++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 spec/active_relation/unit/relations/update_spec.rb 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 -- cgit v1.2.3