From 2463ca7ace76a3b8bb9216910ca6f6d8e3f40e15 Mon Sep 17 00:00:00 2001 From: Sander Marechal 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`. --- test/test_queries.php | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'test') 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