diff options
author | Jeremy Kemper <jeremy@bitsweat.net> | 2007-12-10 09:12:18 +0000 |
---|---|---|
committer | Jeremy Kemper <jeremy@bitsweat.net> | 2007-12-10 09:12:18 +0000 |
commit | 4b055a4a6a32fa14b2e05718279ce5c8a1ed895b (patch) | |
tree | b3bd73d5128e25a7dcd45e628fb0c4ae7a5bf94d /activerecord | |
parent | 9208390f32bc28fc3af85b21d7c6a58675c658ab (diff) | |
download | rails-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/CHANGELOG | 2 | ||||
-rwxr-xr-x | activerecord/lib/active_record/base.rb | 31 |
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)) |