aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record
diff options
context:
space:
mode:
authorDavid Heinemeier Hansson <david@loudthinking.com>2005-01-25 12:45:01 +0000
committerDavid Heinemeier Hansson <david@loudthinking.com>2005-01-25 12:45:01 +0000
commitefa81dad5158eb61243d00811e4664248dd2c167 (patch)
tree161e540cd3382f82afd867e5d1a876619ad61b2f /activerecord/lib/active_record
parent256b594a03f184e63c4682a427a1982cbf99f6fa (diff)
downloadrails-efa81dad5158eb61243d00811e4664248dd2c167.tar.gz
rails-efa81dad5158eb61243d00811e4664248dd2c167.tar.bz2
rails-efa81dad5158eb61243d00811e4664248dd2c167.zip
Added the option of supplying an array of ids and attributes to Base#update, so that multiple records can be updated at once (inspired by #526/Duane Johnson). Added the option of supplying an array of attributes to Base#create, so that multiple records can be created at once. Added that Base#delete and Base#destroy both can take an array of ids to delete/destroy #336. Added that has_many association build and create methods can take arrays of record data like Base#create and Base#build to build/create multiple records at once.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@504 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'activerecord/lib/active_record')
-rw-r--r--activerecord/lib/active_record/associations/association_collection.rb10
-rw-r--r--activerecord/lib/active_record/associations/has_many_association.rb14
-rwxr-xr-xactiverecord/lib/active_record/base.rb71
3 files changed, 36 insertions, 59 deletions
diff --git a/activerecord/lib/active_record/associations/association_collection.rb b/activerecord/lib/active_record/associations/association_collection.rb
index 9507822f40..cf1d0ecefc 100644
--- a/activerecord/lib/active_record/associations/association_collection.rb
+++ b/activerecord/lib/active_record/associations/association_collection.rb
@@ -53,9 +53,13 @@ module ActiveRecord
def create(attributes = {})
# Can't use Base.create since the foreign key may be a protected attribute.
- record = build(attributes)
- record.save unless @owner.new_record?
- record
+ if attributes.is_a?(Array)
+ attributes.collect { |attr| create(attr) }
+ else
+ record = build(attributes)
+ record.save unless @owner.new_record?
+ record
+ end
end
# Returns the size of the collection by executing a SELECT COUNT(*) query if the collection hasn't been loaded and
diff --git a/activerecord/lib/active_record/associations/has_many_association.rb b/activerecord/lib/active_record/associations/has_many_association.rb
index f3ab6bcdab..0d72b9b0c5 100644
--- a/activerecord/lib/active_record/associations/has_many_association.rb
+++ b/activerecord/lib/active_record/associations/has_many_association.rb
@@ -9,11 +9,15 @@ module ActiveRecord
end
def build(attributes = {})
- load_target
- record = @association_class.new(attributes)
- record[@association_class_primary_key_name] = @owner.id unless @owner.new_record?
- @target << record
- record
+ if attributes.is_a?(Array)
+ attributes.collect { |attr| create(attr) }
+ else
+ load_target
+ record = @association_class.new(attributes)
+ record[@association_class_primary_key_name] = @owner.id unless @owner.new_record?
+ @target << record
+ record
+ end
end
def find_all(runtime_conditions = nil, orderings = nil, limit = nil, joins = nil)
diff --git a/activerecord/lib/active_record/base.rb b/activerecord/lib/active_record/base.rb
index cb13f78f7d..b0ad90b10b 100755
--- a/activerecord/lib/active_record/base.rb
+++ b/activerecord/lib/active_record/base.rb
@@ -340,28 +340,38 @@ module ActiveRecord #:nodoc:
# Creates an object, instantly saves it as a record (if the validation permits it), and returns it. If the save
# fail under validations, the unsaved object is still returned.
def create(attributes = nil)
- object = new(attributes)
- object.save
- object
+ if attributes.is_a?(Array)
+ attributes.collect { |attr| create(attr) }
+ else
+ object = new(attributes)
+ object.save
+ object
+ end
end
# Finds the record from the passed +id+, instantly saves it with the passed +attributes+ (if the validation permits it),
# and returns it. If the save fail under validations, the unsaved object is still returned.
def update(id, attributes)
- object = find(id)
- object.attributes = attributes
- object.save
- object
+ if id.is_a?(Array)
+ idx = -1
+ id.collect { |id| idx += 1; update(id, attributes[idx]) }
+ else
+ object = find(id)
+ object.update_attributes(attributes)
+ object
+ end
end
- # Deletes the record with the given +id+ without instantiating an object first.
+ # Deletes the record with the given +id+ without instantiating an object first. If an array of ids is provided, all of them
+ # are deleted.
def delete(id)
- delete_all([ "#{primary_key} = ?", id ])
+ delete_all([ "#{primary_key} IN (?)", id ])
end
# Destroys the record with the given +id+ by instantiating the object and calling #destroy (all the callbacks are the triggered).
+ # If an array of ids is provided, all of them are destroyed.
def destroy(id)
- find(id).destroy
+ id.is_a?(Array) ? id.each { |id| destroy(id) } : find(id).destroy
end
# Updates all records with the SET-part of an SQL update statement in +updates+ and returns an integer with the number of rows updates.
@@ -373,47 +383,6 @@ module ActiveRecord #:nodoc:
return connection.update(sql, "#{name} Update")
end
- # Updates several records at a time using the pattern of a hash that contains id => {attributes} pairs as contained in +id_and_attributes_pairs+.
- # If there are certain conditions that must be met in order for the update to occur, an optional block
- # containing a conditional statement may be used. Example:
- # Person.update_collection { 23 => { "first_name" => "John", "last_name" => "Peterson" },
- # 25 => { "first_name" => "Duane", "last_name" => "Johnson" } }
- #
- # # Updates only those records whose first name begins with 'duane' or 'Duane'
- # Person.update_collection @params['people'] do |activerecord_object, new_attributes|
- # activerecord_object.first_name =~ /^[dD]uane.*/
- # end
- #
- # The conditional block may also be of use when you have more than one kind of key in the +id_and_attributes_pairs+ hash.
- # For example, if you have a view that contains form elements of both existing and new records, you might end up with
- # a hash that looks like this:
- # @params['people'] = { "1" => { "first_name" => "Bob", "last_name" => "Schilling" },
- # "2" => { "first_name" => "Joe", "last_name" => "Tycoon" },
- # "new_person" => { "first_name" => "Mary", "last_name" => "Smith" } }
- # In such a case, you could discriminate against 'updating' the new_person record with the following code:
- # Person.update_collection(@params['people']) { |ar, attrs| ar.id.to_i > 0 }
- #
- # This works because the to_i method converts all non-integer strings to 0.
- def update_collection(id_and_attributes_pairs)
- updated_records = Array.new
-
- transaction do
- records = find(id_and_attributes_pairs.keys)
- id_and_attributes_pairs.each do |id, attrs|
- record = records.select { |r| r.id.to_s == id }.first
-
- # Update each record unless the closure is false
- if (!block_given? || (block_given? && yield(record, attrs)))
- record.update_attributes(attrs)
- updated_records << record
- end
- end
- end
-
- return updated_records
- end
-
-
# Destroys the objects for all the records that matches the +condition+ by instantiating each object and calling
# the destroy method. Example:
# Person.destroy_all "last_login < '2004-04-04'"