From 2463ca7ace76a3b8bb9216910ca6f6d8e3f40e15 Mon Sep 17 00:00:00 2001
From: Sander Marechal <s.marechal@jejik.com>
Date: Thu, 3 Mar 2011 08:12:52 +0100
Subject: Update multiple properties at once

This change alters the `set` method so you can update multiple
properties at once, by passing an associative array top `set`.
---
 README.markdown       |  8 +++++++-
 idiorm.php            | 15 +++++++++++----
 test/test_queries.php |  6 ++++++
 3 files changed, 24 insertions(+), 5 deletions(-)

diff --git a/README.markdown b/README.markdown
index 2e6e6b5..b40e5f1 100644
--- a/README.markdown
+++ b/README.markdown
@@ -333,7 +333,7 @@ The `as_array` method takes column names as optional arguments. If one or more o
 
 ### Updating records ###
 
-To update the database, change one or more of the properties of the object, then call the `save` method to commit the changes to the database. Again, you can change the values of the object's properties either by using the `set` method or by setting the value of the property directly:
+To update the database, change one or more of the properties of the object, then call the `save` method to commit the changes to the database. Again, you can change the values of the object's properties either by using the `set` method or by setting the value of the property directly. By using the `set` method it is also possible to update multiple properties at once, by passing in an associative array:
 
     $person = ORM::for_table('person')->find_one(5);
 
@@ -341,6 +341,12 @@ To update the database, change one or more of the properties of the object, then
     $person->set('name', 'Bob Smith');
     $person->age = 20;
 
+    // This is equivalent to the above two assignments
+    $person->set(array(
+        'name' => 'Bob Smith',
+        'age'  => 20,
+    ));
+
     // Syncronise the object with the database
     $person->save();
 
diff --git a/idiorm.php b/idiorm.php
index 4d454cb..e546d12 100644
--- a/idiorm.php
+++ b/idiorm.php
@@ -1023,12 +1023,19 @@
 
         /**
          * Set a property to a particular value on this object.
-         * Flags that property as 'dirty' so it will be saved to the
+         * To set multiple properties at once, pass an associative array
+         * as the first parameter and leave out the second parameter.
+         * Flags the properties as 'dirty' so they will be saved to the
          * database when save() is called.
          */
-        public function set($key, $value) {
-            $this->_data[$key] = $value;
-            $this->_dirty_fields[$key] = $value;
+        public function set($key, $value = null) {
+            if (!is_array($key)) {
+                $key = array($key => $value);
+            }
+            foreach ($key as $field => $value) {
+                $this->_data[$field] = $value;
+                $this->_dirty_fields[$field] = $value;
+            }
         }
 
         /**
diff --git a/test/test_queries.php b/test/test_queries.php
index 329ebc9..6262534 100644
--- a/test/test_queries.php
+++ b/test/test_queries.php
@@ -205,6 +205,12 @@
     $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10' WHERE `id` = '1'";
     Tester::check_equal("Update data", $expected);
 
+    $widget = ORM::for_table('widget')->find_one(1);
+    $widget->set(array("name" => "Fred", "age" => 10));
+    $widget->save();
+    $expected = "UPDATE `widget` SET `name` = 'Fred', `age` = '10' WHERE `id` = '1'";
+    Tester::check_equal("Update multiple fields", $expected);
+
     $widget = ORM::for_table('widget')->find_one(1);
     $widget->delete();
     $expected = "DELETE FROM `widget` WHERE `id` = '1'";
-- 
cgit v1.2.3