aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord
diff options
context:
space:
mode:
authorJeremy Kemper <jeremy@bitsweat.net>2007-12-10 09:12:18 +0000
committerJeremy Kemper <jeremy@bitsweat.net>2007-12-10 09:12:18 +0000
commit4b055a4a6a32fa14b2e05718279ce5c8a1ed895b (patch)
treeb3bd73d5128e25a7dcd45e628fb0c4ae7a5bf94d /activerecord
parent9208390f32bc28fc3af85b21d7c6a58675c658ab (diff)
downloadrails-4b055a4a6a32fa14b2e05718279ce5c8a1ed895b.tar.gz
rails-4b055a4a6a32fa14b2e05718279ce5c8a1ed895b.tar.bz2
rails-4b055a4a6a32fa14b2e05718279ce5c8a1ed895b.zip
Update destroy_all and delete_all documentation to better describe their tradeoffs. Closes #10447.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@8367 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord')
-rw-r--r--activerecord/CHANGELOG2
-rwxr-xr-xactiverecord/lib/active_record/base.rb31
2 files changed, 28 insertions, 5 deletions
diff --git a/activerecord/CHANGELOG b/activerecord/CHANGELOG
index 152e42485d..12ff96f64f 100644
--- a/activerecord/CHANGELOG
+++ b/activerecord/CHANGELOG
@@ -1,6 +1,6 @@
*SVN*
-* Document Active Record exceptions. #10444 [Michael Klishin]
+* Documentation: Active Record exceptions, destroy_all and delete_all. #10444, #10447 [Michael Klishin]
*2.0.1* (December 7th, 2007)
diff --git a/activerecord/lib/active_record/base.rb b/activerecord/lib/active_record/base.rb
index 68f21bc89b..03aff854fa 100755
--- a/activerecord/lib/active_record/base.rb
+++ b/activerecord/lib/active_record/base.rb
@@ -678,16 +678,39 @@ module ActiveRecord #:nodoc:
connection.update(sql, "#{name} Update")
end
- # Destroys the objects for all the records that match the +conditions+ by instantiating each object and calling
- # the destroy method. Example:
+ # Destroys the records matching +conditions+ by instantiating each record and calling the destroy method.
+ # This means at least 2*N database queries to destroy N records, so avoid destroy_all if you are deleting
+ # many records. If you want to simply delete records without worrying about dependent associations or
+ # callbacks, use the much faster +delete_all+ method instead.
+ #
+ # ==== Options
+ #
+ # +conditions+ Conditions are specified the same way as with +find+ method.
+ #
+ # ==== Example
+ #
# Person.destroy_all "last_login < '2004-04-04'"
+ #
+ # This loads and destroys each person one by one, including its dependent associations and before_ and
+ # after_destroy callbacks.
def destroy_all(conditions = nil)
find(:all, :conditions => conditions).each { |object| object.destroy }
end
- # Deletes all the records that match the +conditions+ without instantiating the objects first (and hence not
- # calling the destroy method). Example:
+ # Deletes the records matching +conditions+ without instantiating the records first, and hence not
+ # calling the destroy method and invoking callbacks. This is a single SQL query, much more efficient
+ # than destroy_all.
+ #
+ # ==== Options
+ #
+ # +conditions+ Conditions are specified the same way as with +find+ method.
+ #
+ # ==== Example
+ #
# Post.delete_all "person_id = 5 AND (category = 'Something' OR category = 'Else')"
+ #
+ # This deletes the affected posts all at once with a single DELETE query. If you need to destroy dependent
+ # associations or call your before_ or after_destroy callbacks, use the +destroy_all+ method instead.
def delete_all(conditions = nil)
sql = "DELETE FROM #{quoted_table_name} "
add_conditions!(sql, conditions, scope(:find))