Using Value Objects (VOs)

Now that we have our user table (assuming you're already visited Setup and made the needed changes), we will start out by creating, updating, then deleting a single row in the database.

Creating New Instances/Rows

Let's start by creating a user instance, giving it some values, and then placing it in the database.


				$newUser = new UserVO();

				$newUser->setUsername("UsernameNow" . rand(0,99));

				$newUser->setPwd("NewPwdNow" . rand(0,99));

				if( $newUser->insertNow() ){//Call insertNow() to execute the insert immediately.

				  echo "<hr/>Inserted new user: " . $newUser;//All ValueObjects implement __toString()
				to describe themselves when echoed.

				} else {

				  echo "Failed inserting!<br />";

				}

				
					UserVO::setUsername() setting new value: “UsernameNow74”
UserVO::setPwd() setting new value: “NewPwdNow30”
AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “UsernameNow74”, pwd: “NewPwdNow30” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41894”
Inserted new user: (UserVO) { Key: 41894, user_id: 41894, username: “UsernameNow74”, pwd: “NewPwdNow30” }

Updating

Now we will use the same instance to change the username and update it immediately. More on “immediately” on DbExchange where the distinction of immediate and deferred database synchronization will be obvious. The VOs were designed to defer calls to the database until all operations have been performed. This prevents extra changes being written to the database before an object is in its “final” state. However, I left these methods public to use at your own discretion / convenience.


				$newUser->setUsername("immediateUpdatedName");

				if( $newUser->updateNow() ){

				  echo "<hr/>Updated new user: " . $newUser;

				} else {

				  echo "Failed Updating!<br/>";

				}

				
					UserVO::setUsername() setting new value: “immediateUpdatedName”
AbstractValueObject::updateNow()  delegating to concrete map...
UserDbMap::updateNow() Updated: (UserVO) { Key: 41894, user_id: 41894, username: “immediateUpdatedName”, pwd: “NewPwdNow30” }
Updated new user: (UserVO) { Key: 41894, user_id: 41894, username: “immediateUpdatedName”, pwd: “NewPwdNow30” } in the database.

The VO setter methods are chainable. This allows us to write shorter code that does the same things.


				$success = $newUser->setPwd("anotherPassword")->setUsername("anotherUsername")->updateNow();

				if( $success ){

				  echo "<hr/>Updated new user again: " . $newUser;

				} else {

				  echo "Failed Updating immediately!<br/>";

				}

				
					UserVO::setPwd() setting new value: “anotherPassword”
UserVO::setUsername() setting new value: “anotherUsername”
AbstractValueObject::updateNow()  delegating to concrete map...
UserDbMap::updateNow() Updated: (UserVO) { Key: 41894, user_id: 41894, username: “anotherUsername”, pwd: “anotherPassword” }
Updated new user again: (UserVO) { Key: 41894, user_id: 41894, username: “anotherUsername”, pwd: “anotherPassword” } in the database.

Deleting

Now we will use the instance to tell it to remove it's corresponding row from the database.


				if( $newUser->deleteNow() ){

				  echo "<hr/>Deleted new user: " . $newUser;

				} else {

				  echo "Failed Deleting immediately!<br/>";

				}
				
					AbstractValueObject::deleteNow()  delegating to concrete map...
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41894, user_id: 41894, username: “anotherUsername”, pwd: “anotherPassword” }
Deleted new user: (UserVO) { Key: 41894, user_id: 41894, username: “anotherUsername”, pwd: “anotherPassword” }

At this point, looking in the database `user` table you'll see that the row with user_id = 41894 is missing.

Adding Several Rows For Examples

Now we will add a few more rows and leave them for other examples. This time we will use the value object's “init()” method to (re)set the instance values. Note: Since user_id is an auto-increment primary key, I'm using a default value of "-1"


				$names = array("aUsername","Alexia","theUsername","Bob","YourName","MyName","Jimbo","Therese","Anaximenes");

				for ($i = 2; $i < 15; $i++){

				  $pwd = substr( md5($i), 0,  rand(3,6)) . "_" . $i;

				  $username = $names[ rand(0, count($names)-1 ) ] . "_" . $i;

				  $valueAry = array("user_id" => -1, "username" => $username, "pwd" => "$pwd");

				  $newUser->init($valueAry);

				  if( $newUser->insertNow()){

				    echo "<hr/>Inserted User: {$newUser->getKeyStr()}<hr/>";

				  } else {

				    echo "Error inserting: $newUser.<br/>" . DbTest::Mysqli()->error;

				  }

				}
				
					UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Jimbo_2
    [pwd] => c81e7_2
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Jimbo_2”, pwd: “c81e7_2” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41895”
Inserted User: (UserVO) { Key: 41895, user_id: 41895, username: “Jimbo_2”, pwd: “c81e7_2” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Anaximenes_3
    [pwd] => eccbc8_3
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Anaximenes_3”, pwd: “eccbc8_3” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41896”
Inserted User: (UserVO) { Key: 41896, user_id: 41896, username: “Anaximenes_3”, pwd: “eccbc8_3” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Anaximenes_4
    [pwd] => a87_4
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Anaximenes_4”, pwd: “a87_4” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41897”
Inserted User: (UserVO) { Key: 41897, user_id: 41897, username: “Anaximenes_4”, pwd: “a87_4” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => theUsername_5
    [pwd] => e4da3_5
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “theUsername_5”, pwd: “e4da3_5” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41898”
Inserted User: (UserVO) { Key: 41898, user_id: 41898, username: “theUsername_5”, pwd: “e4da3_5” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => aUsername_6
    [pwd] => 16_6
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “aUsername_6”, pwd: “16_6” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41899”
Inserted User: (UserVO) { Key: 41899, user_id: 41899, username: “aUsername_6”, pwd: “16_6” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => theUsername_7
    [pwd] => 8f1_7
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “theUsername_7”, pwd: “8f1_7” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41900”
Inserted User: (UserVO) { Key: 41900, user_id: 41900, username: “theUsername_7”, pwd: “8f1_7” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => MyName_8
    [pwd] => c9f0f895_8
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “MyName_8”, pwd: “c9f0f895_8” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41901”
Inserted User: (UserVO) { Key: 41901, user_id: 41901, username: “MyName_8”, pwd: “c9f0f895_8” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Therese_9
    [pwd] => 45_9
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Therese_9”, pwd: “45_9” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41902”
Inserted User: (UserVO) { Key: 41902, user_id: 41902, username: “Therese_9”, pwd: “45_9” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => YourName_10
    [pwd] => d3d9446_10
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “YourName_10”, pwd: “d3d9446_10” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41903”
Inserted User: (UserVO) { Key: 41903, user_id: 41903, username: “YourName_10”, pwd: “d3d9446_10” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => YourName_11
    [pwd] => 6512_11
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “YourName_11”, pwd: “6512_11” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41904”
Inserted User: (UserVO) { Key: 41904, user_id: 41904, username: “YourName_11”, pwd: “6512_11” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Jimbo_12
    [pwd] => c2_12
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Jimbo_12”, pwd: “c2_12” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41905”
Inserted User: (UserVO) { Key: 41905, user_id: 41905, username: “Jimbo_12”, pwd: “c2_12” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Anaximenes_13
    [pwd] => c5_13
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Anaximenes_13”, pwd: “c5_13” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41906”
Inserted User: (UserVO) { Key: 41906, user_id: 41906, username: “Anaximenes_13”, pwd: “c5_13” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => YourName_14
    [pwd] => aa_14
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “YourName_14”, pwd: “aa_14” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41907”
Inserted User: (UserVO) { Key: 41907, user_id: 41907, username: “YourName_14”, pwd: “aa_14” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => theUsername_15
    [pwd] => 9bf31_15
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “theUsername_15”, pwd: “9bf31_15” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41908”
Inserted User: (UserVO) { Key: 41908, user_id: 41908, username: “theUsername_15”, pwd: “9bf31_15” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Alexia_16
    [pwd] => c74d97b_16
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Alexia_16”, pwd: “c74d97b_16” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41909”
Inserted User: (UserVO) { Key: 41909, user_id: 41909, username: “Alexia_16”, pwd: “c74d97b_16” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => MyName_17
    [pwd] => 70efdf2_17
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “MyName_17”, pwd: “70efdf2_17” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41910”
Inserted User: (UserVO) { Key: 41910, user_id: 41910, username: “MyName_17”, pwd: “70efdf2_17” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => theUsername_18
    [pwd] => 6f49_18
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “theUsername_18”, pwd: “6f49_18” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41911”
Inserted User: (UserVO) { Key: 41911, user_id: 41911, username: “theUsername_18”, pwd: “6f49_18” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => YourName_19
    [pwd] => 1f0_19
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “YourName_19”, pwd: “1f0_19” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41912”
Inserted User: (UserVO) { Key: 41912, user_id: 41912, username: “YourName_19”, pwd: “1f0_19” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Alexia_20
    [pwd] => 98f1370_20
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Alexia_20”, pwd: “98f1370_20” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41913”
Inserted User: (UserVO) { Key: 41913, user_id: 41913, username: “Alexia_20”, pwd: “98f1370_20” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Jimbo_21
    [pwd] => 3c59dc0_21
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Jimbo_21”, pwd: “3c59dc0_21” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41914”
Inserted User: (UserVO) { Key: 41914, user_id: 41914, username: “Jimbo_21”, pwd: “3c59dc0_21” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => theUsername_22
    [pwd] => b6d76_22
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “theUsername_22”, pwd: “b6d76_22” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41915”
Inserted User: (UserVO) { Key: 41915, user_id: 41915, username: “theUsername_22”, pwd: “b6d76_22” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => MyName_23
    [pwd] => 37693cf_23
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “MyName_23”, pwd: “37693cf_23” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41916”
Inserted User: (UserVO) { Key: 41916, user_id: 41916, username: “MyName_23”, pwd: “37693cf_23” }
UserVO::init() Setting Properties With: Array
(
    [user_id] => -1
    [username] => Bob_24
    [pwd] => 1ff_24
)

AbstractValueObject::insertNow() delegating to concrete map...
UserDbMap::insertNow()
 Inserting  (UserVO) { Key: -1, user_id: -1, username: “Bob_24”, pwd: “1ff_24” } in `user`
UserDbMap::insertNow() Insert successful
Setting new user id...
UserVO::setUserId() setting new value: “41917”
Inserted User: (UserVO) { Key: 41917, user_id: 41917, username: “Bob_24”, pwd: “1ff_24” }

Db Maintenance

The following is output from code that has been added to prevent the database from inflating and the getAll() demonstration on the Selectors page returning a huge number of rows.



				
					UserSelector current "where" clause: “ WHERE `user`.`user_id` > 24”
AbstractSelector::fetch() using query: “SELECT * FROM `user` WHERE `user`.`user_id` > 24”
AbstractCollection::__toString()
Raw VO Data (Total = 23):
Raw 0: Array
(
    [user_id] => 41917
    [username] => Bob_24
    [pwd] => 1ff_24
)

Raw 1: Array
(
    [user_id] => 41916
    [username] => MyName_23
    [pwd] => 37693cf_23
)

Raw 2: Array
(
    [user_id] => 41915
    [username] => theUsername_22
    [pwd] => b6d76_22
)

Raw 3: Array
(
    [user_id] => 41914
    [username] => Jimbo_21
    [pwd] => 3c59dc0_21
)

Raw 4: Array
(
    [user_id] => 41913
    [username] => Alexia_20
    [pwd] => 98f1370_20
)

Raw 5: Array
(
    [user_id] => 41912
    [username] => YourName_19
    [pwd] => 1f0_19
)

Raw 6: Array
(
    [user_id] => 41911
    [username] => theUsername_18
    [pwd] => 6f49_18
)

Raw 7: Array
(
    [user_id] => 41910
    [username] => MyName_17
    [pwd] => 70efdf2_17
)

Raw 8: Array
(
    [user_id] => 41909
    [username] => Alexia_16
    [pwd] => c74d97b_16
)

Raw 9: Array
(
    [user_id] => 41908
    [username] => theUsername_15
    [pwd] => 9bf31_15
)

Raw 10: Array
(
    [user_id] => 41907
    [username] => YourName_14
    [pwd] => aa_14
)

Raw 11: Array
(
    [user_id] => 41906
    [username] => Anaximenes_13
    [pwd] => c5_13
)

Raw 12: Array
(
    [user_id] => 41905
    [username] => Jimbo_12
    [pwd] => c2_12
)

Raw 13: Array
(
    [user_id] => 41904
    [username] => YourName_11
    [pwd] => 6512_11
)

Raw 14: Array
(
    [user_id] => 41903
    [username] => YourName_10
    [pwd] => d3d9446_10
)

Raw 15: Array
(
    [user_id] => 41902
    [username] => Therese_9
    [pwd] => 45_9
)

Raw 16: Array
(
    [user_id] => 41901
    [username] => MyName_8
    [pwd] => c9f0f895_8
)

Raw 17: Array
(
    [user_id] => 41900
    [username] => theUsername_7
    [pwd] => 8f1_7
)

Raw 18: Array
(
    [user_id] => 41899
    [username] => aUsername_6
    [pwd] => 16_6
)

Raw 19: Array
(
    [user_id] => 41898
    [username] => theUsername_5
    [pwd] => e4da3_5
)

Raw 20: Array
(
    [user_id] => 41897
    [username] => Anaximenes_4
    [pwd] => a87_4
)

Raw 21: Array
(
    [user_id] => 41896
    [username] => Anaximenes_3
    [pwd] => eccbc8_3
)

Raw 22: Array
(
    [user_id] => 41895
    [username] => Jimbo_2
    [pwd] => c81e7_2
)

Built UserVO Objects (Total = 0 of 23):

AbstractCollection::valid() validating #0 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #0
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41917
    [username] => Bob_24
    [pwd] => 1ff_24
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41917, user_id: 41917, username: “Bob_24”, pwd: “1ff_24” }.
Added to aryDeleted: (UserVO) { Key: 41917, user_id: 41917, username: “Bob_24”, pwd: “1ff_24” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41917, user_id: 41917, username: “Bob_24”, pwd: “1ff_24” }
AbstractCollection::valid() validating #1 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #1
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41916
    [username] => MyName_23
    [pwd] => 37693cf_23
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41916, user_id: 41916, username: “MyName_23”, pwd: “37693cf_23” }.
Added to aryDeleted: (UserVO) { Key: 41916, user_id: 41916, username: “MyName_23”, pwd: “37693cf_23” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41916, user_id: 41916, username: “MyName_23”, pwd: “37693cf_23” }
AbstractCollection::valid() validating #2 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #2
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41915
    [username] => theUsername_22
    [pwd] => b6d76_22
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41915, user_id: 41915, username: “theUsername_22”, pwd: “b6d76_22” }.
Added to aryDeleted: (UserVO) { Key: 41915, user_id: 41915, username: “theUsername_22”, pwd: “b6d76_22” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41915, user_id: 41915, username: “theUsername_22”, pwd: “b6d76_22” }
AbstractCollection::valid() validating #3 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #3
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41914
    [username] => Jimbo_21
    [pwd] => 3c59dc0_21
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41914, user_id: 41914, username: “Jimbo_21”, pwd: “3c59dc0_21” }.
Added to aryDeleted: (UserVO) { Key: 41914, user_id: 41914, username: “Jimbo_21”, pwd: “3c59dc0_21” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41914, user_id: 41914, username: “Jimbo_21”, pwd: “3c59dc0_21” }
AbstractCollection::valid() validating #4 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #4
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41913
    [username] => Alexia_20
    [pwd] => 98f1370_20
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41913, user_id: 41913, username: “Alexia_20”, pwd: “98f1370_20” }.
Added to aryDeleted: (UserVO) { Key: 41913, user_id: 41913, username: “Alexia_20”, pwd: “98f1370_20” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41913, user_id: 41913, username: “Alexia_20”, pwd: “98f1370_20” }
AbstractCollection::valid() validating #5 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #5
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41912
    [username] => YourName_19
    [pwd] => 1f0_19
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41912, user_id: 41912, username: “YourName_19”, pwd: “1f0_19” }.
Added to aryDeleted: (UserVO) { Key: 41912, user_id: 41912, username: “YourName_19”, pwd: “1f0_19” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41912, user_id: 41912, username: “YourName_19”, pwd: “1f0_19” }
AbstractCollection::valid() validating #6 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #6
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41911
    [username] => theUsername_18
    [pwd] => 6f49_18
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41911, user_id: 41911, username: “theUsername_18”, pwd: “6f49_18” }.
Added to aryDeleted: (UserVO) { Key: 41911, user_id: 41911, username: “theUsername_18”, pwd: “6f49_18” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41911, user_id: 41911, username: “theUsername_18”, pwd: “6f49_18” }
AbstractCollection::valid() validating #7 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #7
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41910
    [username] => MyName_17
    [pwd] => 70efdf2_17
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41910, user_id: 41910, username: “MyName_17”, pwd: “70efdf2_17” }.
Added to aryDeleted: (UserVO) { Key: 41910, user_id: 41910, username: “MyName_17”, pwd: “70efdf2_17” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41910, user_id: 41910, username: “MyName_17”, pwd: “70efdf2_17” }
AbstractCollection::valid() validating #8 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #8
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41909
    [username] => Alexia_16
    [pwd] => c74d97b_16
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41909, user_id: 41909, username: “Alexia_16”, pwd: “c74d97b_16” }.
Added to aryDeleted: (UserVO) { Key: 41909, user_id: 41909, username: “Alexia_16”, pwd: “c74d97b_16” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41909, user_id: 41909, username: “Alexia_16”, pwd: “c74d97b_16” }
AbstractCollection::valid() validating #9 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #9
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41908
    [username] => theUsername_15
    [pwd] => 9bf31_15
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41908, user_id: 41908, username: “theUsername_15”, pwd: “9bf31_15” }.
Added to aryDeleted: (UserVO) { Key: 41908, user_id: 41908, username: “theUsername_15”, pwd: “9bf31_15” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41908, user_id: 41908, username: “theUsername_15”, pwd: “9bf31_15” }
AbstractCollection::valid() validating #10 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #10
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41907
    [username] => YourName_14
    [pwd] => aa_14
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41907, user_id: 41907, username: “YourName_14”, pwd: “aa_14” }.
Added to aryDeleted: (UserVO) { Key: 41907, user_id: 41907, username: “YourName_14”, pwd: “aa_14” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41907, user_id: 41907, username: “YourName_14”, pwd: “aa_14” }
AbstractCollection::valid() validating #11 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #11
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41906
    [username] => Anaximenes_13
    [pwd] => c5_13
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41906, user_id: 41906, username: “Anaximenes_13”, pwd: “c5_13” }.
Added to aryDeleted: (UserVO) { Key: 41906, user_id: 41906, username: “Anaximenes_13”, pwd: “c5_13” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41906, user_id: 41906, username: “Anaximenes_13”, pwd: “c5_13” }
AbstractCollection::valid() validating #12 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #12
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41905
    [username] => Jimbo_12
    [pwd] => c2_12
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41905, user_id: 41905, username: “Jimbo_12”, pwd: “c2_12” }.
Added to aryDeleted: (UserVO) { Key: 41905, user_id: 41905, username: “Jimbo_12”, pwd: “c2_12” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41905, user_id: 41905, username: “Jimbo_12”, pwd: “c2_12” }
AbstractCollection::valid() validating #13 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #13
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41904
    [username] => YourName_11
    [pwd] => 6512_11
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41904, user_id: 41904, username: “YourName_11”, pwd: “6512_11” }.
Added to aryDeleted: (UserVO) { Key: 41904, user_id: 41904, username: “YourName_11”, pwd: “6512_11” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41904, user_id: 41904, username: “YourName_11”, pwd: “6512_11” }
AbstractCollection::valid() validating #14 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #14
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41903
    [username] => YourName_10
    [pwd] => d3d9446_10
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41903, user_id: 41903, username: “YourName_10”, pwd: “d3d9446_10” }.
Added to aryDeleted: (UserVO) { Key: 41903, user_id: 41903, username: “YourName_10”, pwd: “d3d9446_10” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41903, user_id: 41903, username: “YourName_10”, pwd: “d3d9446_10” }
AbstractCollection::valid() validating #15 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #15
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41902
    [username] => Therese_9
    [pwd] => 45_9
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41902, user_id: 41902, username: “Therese_9”, pwd: “45_9” }.
Added to aryDeleted: (UserVO) { Key: 41902, user_id: 41902, username: “Therese_9”, pwd: “45_9” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41902, user_id: 41902, username: “Therese_9”, pwd: “45_9” }
AbstractCollection::valid() validating #16 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #16
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41901
    [username] => MyName_8
    [pwd] => c9f0f895_8
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41901, user_id: 41901, username: “MyName_8”, pwd: “c9f0f895_8” }.
Added to aryDeleted: (UserVO) { Key: 41901, user_id: 41901, username: “MyName_8”, pwd: “c9f0f895_8” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41901, user_id: 41901, username: “MyName_8”, pwd: “c9f0f895_8” }
AbstractCollection::valid() validating #17 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #17
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41900
    [username] => theUsername_7
    [pwd] => 8f1_7
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41900, user_id: 41900, username: “theUsername_7”, pwd: “8f1_7” }.
Added to aryDeleted: (UserVO) { Key: 41900, user_id: 41900, username: “theUsername_7”, pwd: “8f1_7” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41900, user_id: 41900, username: “theUsername_7”, pwd: “8f1_7” }
AbstractCollection::valid() validating #18 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #18
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41899
    [username] => aUsername_6
    [pwd] => 16_6
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41899, user_id: 41899, username: “aUsername_6”, pwd: “16_6” }.
Added to aryDeleted: (UserVO) { Key: 41899, user_id: 41899, username: “aUsername_6”, pwd: “16_6” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41899, user_id: 41899, username: “aUsername_6”, pwd: “16_6” }
AbstractCollection::valid() validating #19 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #19
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41898
    [username] => theUsername_5
    [pwd] => e4da3_5
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41898, user_id: 41898, username: “theUsername_5”, pwd: “e4da3_5” }.
Added to aryDeleted: (UserVO) { Key: 41898, user_id: 41898, username: “theUsername_5”, pwd: “e4da3_5” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41898, user_id: 41898, username: “theUsername_5”, pwd: “e4da3_5” }
AbstractCollection::valid() validating #20 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #20
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41897
    [username] => Anaximenes_4
    [pwd] => a87_4
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41897, user_id: 41897, username: “Anaximenes_4”, pwd: “a87_4” }.
Added to aryDeleted: (UserVO) { Key: 41897, user_id: 41897, username: “Anaximenes_4”, pwd: “a87_4” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41897, user_id: 41897, username: “Anaximenes_4”, pwd: “a87_4” }
AbstractCollection::valid() validating #21 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #21
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41896
    [username] => Anaximenes_3
    [pwd] => eccbc8_3
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41896, user_id: 41896, username: “Anaximenes_3”, pwd: “eccbc8_3” }.
Added to aryDeleted: (UserVO) { Key: 41896, user_id: 41896, username: “Anaximenes_3”, pwd: “eccbc8_3” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41896, user_id: 41896, username: “Anaximenes_3”, pwd: “eccbc8_3” }
AbstractCollection::valid() validating #22 (Result: 1)
AbstractCollection::getRow()
Building and returning UserVO #22
AbstractDbTableMap::getVO() delegating to concrete class....
UserDbMap::getInstance()  Creating new UserVO and calling init()
UserVO::init() Setting Properties With: Array
(
    [user_id] => 41895
    [username] => Jimbo_2
    [pwd] => c81e7_2
)

AbstractValueObject::markDeleted() 
DbExchange::addDeleted()
Added to aryAll: (UserVO) { Key: 41895, user_id: 41895, username: “Jimbo_2”, pwd: “c81e7_2” }.
Added to aryDeleted: (UserVO) { Key: 41895, user_id: 41895, username: “Jimbo_2”, pwd: “c81e7_2” }.
Trimming aryNew, aryClean, and aryDirty
Marked As Deleted: (UserVO) { Key: 41895, user_id: 41895, username: “Jimbo_2”, pwd: “c81e7_2” }
AbstractCollection::valid() validating #23 (Result: )
Deleting (23) VO objects...
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41917, user_id: 41917, username: “Bob_24”, pwd: “1ff_24” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41916, user_id: 41916, username: “MyName_23”, pwd: “37693cf_23” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41915, user_id: 41915, username: “theUsername_22”, pwd: “b6d76_22” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41914, user_id: 41914, username: “Jimbo_21”, pwd: “3c59dc0_21” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41913, user_id: 41913, username: “Alexia_20”, pwd: “98f1370_20” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41912, user_id: 41912, username: “YourName_19”, pwd: “1f0_19” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41911, user_id: 41911, username: “theUsername_18”, pwd: “6f49_18” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41910, user_id: 41910, username: “MyName_17”, pwd: “70efdf2_17” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41909, user_id: 41909, username: “Alexia_16”, pwd: “c74d97b_16” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41908, user_id: 41908, username: “theUsername_15”, pwd: “9bf31_15” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41907, user_id: 41907, username: “YourName_14”, pwd: “aa_14” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41906, user_id: 41906, username: “Anaximenes_13”, pwd: “c5_13” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41905, user_id: 41905, username: “Jimbo_12”, pwd: “c2_12” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41904, user_id: 41904, username: “YourName_11”, pwd: “6512_11” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41903, user_id: 41903, username: “YourName_10”, pwd: “d3d9446_10” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41902, user_id: 41902, username: “Therese_9”, pwd: “45_9” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41901, user_id: 41901, username: “MyName_8”, pwd: “c9f0f895_8” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41900, user_id: 41900, username: “theUsername_7”, pwd: “8f1_7” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41899, user_id: 41899, username: “aUsername_6”, pwd: “16_6” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41898, user_id: 41898, username: “theUsername_5”, pwd: “e4da3_5” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41897, user_id: 41897, username: “Anaximenes_4”, pwd: “a87_4” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41896, user_id: 41896, username: “Anaximenes_3”, pwd: “eccbc8_3” }
Trim aryAll & aryDeleted
UserDbMap::deleteNow() Deleted: (UserVO) { Key: 41895, user_id: 41895, username: “Jimbo_2”, pwd: “c81e7_2” }
Trim aryAll & aryDeleted