aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/base_test.rb
diff options
context:
space:
mode:
authorJeremy Kemper <jeremy@bitsweat.net>2007-03-17 15:48:47 +0000
committerJeremy Kemper <jeremy@bitsweat.net>2007-03-17 15:48:47 +0000
commita38f28fff1e9e3faeeb22ac9b7c6b3cdcb7e2b29 (patch)
treee0f0d882ca5bfd56704dad93f56235c43266f5c7 /activerecord/test/base_test.rb
parentf87db851c680164b6474d783d5f29b6cb4c013c0 (diff)
downloadrails-a38f28fff1e9e3faeeb22ac9b7c6b3cdcb7e2b29.tar.gz
rails-a38f28fff1e9e3faeeb22ac9b7c6b3cdcb7e2b29.tar.bz2
rails-a38f28fff1e9e3faeeb22ac9b7c6b3cdcb7e2b29.zip
Base.update_all :order and :limit options. Useful for MySQL updates that must be ordered to avoid violating unique constraints.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6440 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/test/base_test.rb')
-rwxr-xr-xactiverecord/test/base_test.rb6
1 files changed, 6 insertions, 0 deletions
diff --git a/activerecord/test/base_test.rb b/activerecord/test/base_test.rb
index cbc144f57a..c3ae9a08b9 100755
--- a/activerecord/test/base_test.rb
+++ b/activerecord/test/base_test.rb
@@ -569,6 +569,12 @@ class BasicsTest < Test::Unit::TestCase
end
end
+ if current_adapter?(:MysqlAdapter)
+ def test_update_all_with_order_and_limit
+ assert_equal 1, Topic.update_all("content = 'bulk updated!'", nil, :limit => 1, :order => 'id DESC')
+ end
+ end
+
def test_update_many
topic_data = { 1 => { "content" => "1 updated" }, 2 => { "content" => "2 updated" } }
updated = Topic.update(topic_data.keys, topic_data.values)