From 903ae8a581fac1e6917fc3e31d2ad8fb91df80c3 Mon Sep 17 00:00:00 2001
From: ctrlaltca <>
Date: Thu, 12 Jul 2012 11:21:01 +0000
Subject: standardize the use of unix eol; use svn properties to enforce native
 eol

---
 tests/simple_unit/SqlMap/StatementTest.php | 2268 ++++++++++++++--------------
 1 file changed, 1134 insertions(+), 1134 deletions(-)

(limited to 'tests/simple_unit/SqlMap/StatementTest.php')

diff --git a/tests/simple_unit/SqlMap/StatementTest.php b/tests/simple_unit/SqlMap/StatementTest.php
index 3ac0a3ab..f9c3fb13 100644
--- a/tests/simple_unit/SqlMap/StatementTest.php
+++ b/tests/simple_unit/SqlMap/StatementTest.php
@@ -1,1135 +1,1135 @@
-<?php
-require_once(dirname(__FILE__).'/BaseCase.php');
-
-/**
- * @package System.DataAccess.SQLMap
- */
-class StatementTest extends BaseCase
-{
-	function __construct()
-	{
-		parent::__construct();
-		$this->initSqlMap();
-
-		//force autoload
-		new Account;
-		new Order;
-		new LineItem;
-		new LineItemCollection;
-		new A; new B; new C; new D; new E; new F;
-	}
-
-	public function setup()
-	{
-
-	}
-
-	function resetDatabase()
-	{
-		$this->initScript('account-init.sql');
-		$this->initScript('order-init.sql');
-		$this->initScript('line-item-init.sql');
-//		$this->initScript('enumeration-init.sql');
-		$this->initScript('other-init.sql');
-	}
-
-
-	#region Object Query tests
-
-	/**
-	 * Test Open connection with a connection string
-	 */
-	function testOpenConnection()
-	{
-		$conn = $this->sqlmap->getDbConnection();
-		$conn->setActive(true);
-		$account= $this->sqlmap->QueryForObject("SelectWithProperty");
-		$conn->setActive(false);
-		$this->assertAccount1($account);
-	}
-
-	/**
-	 * Test use a statement with property subtitution
-	 * (JIRA 22)
-	 */
-	function testSelectWithProperty()
-	{
-		$account= $this->sqlmap->QueryForObject("SelectWithProperty");
-		$this->assertAccount1($account);
-	}
-
-	/**
-	 * Test ExecuteQueryForObject Via ColumnName
-	 */
-	function testExecuteQueryForObjectViaColumnName()
-	{
-		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
-		$this->assertAccount1($account);
-	}
-
-	/**
-	 * Test ExecuteQueryForObject Via ColumnIndex
-	 */
-	function testExecuteQueryForObjectViaColumnIndex()
-	{
-		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnIndex", 1);
-		$this->assertAccount1($account);
-	}
-
-	/**
-	 * Test ExecuteQueryForObject Via ResultClass
-	 */
-	function testExecuteQueryForObjectViaResultClass()
-	{
-		$account= $this->sqlmap->QueryForObject("GetAccountViaResultClass", 1);
-		$this->assertAccount1($account);
-	}
-
-	/**
-	 * Test ExecuteQueryForObject With simple ResultClass : string
-	 */
-	function testExecuteQueryForObjectWithSimpleResultClass()
-	{
-		$email = $this->sqlmap->QueryForObject("GetEmailAddressViaResultClass", 1);
-		$this->assertIdentical("Joe.Dalton@somewhere.com", $email);
-	}
-
-	/**
-	 * Test ExecuteQueryForObject With simple ResultMap : string
-	 */
-	function testExecuteQueryForObjectWithSimpleResultMap()
-	{
-		$email = $this->sqlmap->QueryForObject("GetEmailAddressViaResultMap", 1);
-		$this->assertIdentical("Joe.Dalton@somewhere.com", $email);
-	}
-
-	/**
-	 * Test Primitive ReturnValue : TDateTime
-	 */
-	function testPrimitiveReturnValue()
-	{
-		$CardExpiry = $this->sqlmap->QueryForObject("GetOrderCardExpiryViaResultClass", 1);
-		$date = @mktime(8, 15, 00, 2, 15, 2003);
-		$this->assertIdentical($date, $CardExpiry->getTimeStamp());
-	}
-
-	/**
-	 * Test ExecuteQueryForObject with result object : Account
-	 */
-	function testExecuteQueryForObjectWithResultObject()
-	{
-		$account= new Account();
-		$testAccount = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1, $account);
-		$this->assertAccount1($account);
-		$this->assertTrue($account == $testAccount);
-	}
-
-	/**
-	 * Test ExecuteQueryForObject as array
-	 */
-	function testExecuteQueryForObjectAsHashArray()
-	{
-		$account = $this->sqlmap->QueryForObject("GetAccountAsHashtable", 1);
-		$this->assertAccount1AsHashArray($account);
-	}
-
-	/**
-	 * Test ExecuteQueryForObject as Hashtable ResultClass
-	 */
-	function testExecuteQueryForObjectAsHashtableResultClass()
-	{
-		$account = $this->sqlmap->QueryForObject("GetAccountAsHashtableResultClass", 1);
-		$this->assertAccount1AsHashArray($account);
-	}
-
-	/**
-	 * Test ExecuteQueryForObject via Hashtable
-	 */
-	function testExecuteQueryForObjectViaHashtable()
-	{
-		$param["LineItem_ID"] = 2;
-		$param["Order_ID"] = 9;
-
-		$testItem = $this->sqlmap->QueryForObject("GetSpecificLineItem", $param);
-
-		$this->assertNotNull($testItem);
-		$this->assertIdentical("TSM-12", $testItem->getCode());
-	}
-	/**/
-
-	//TODO: Test Query Dynamic Sql Element
-	function testQueryDynamicSqlElement()
-	{
-		//$list = $this->sqlmap->QueryForList("GetDynamicOrderedEmailAddressesViaResultMap", "Account_ID");
-
-		//$this->assertIdentical("Joe.Dalton@somewhere.com", $list[0]);
-
-		//list = $this->sqlmap->QueryForList("GetDynamicOrderedEmailAddressesViaResultMap", "Account_FirstName");
-
-		//$this->assertIdentical("Averel.Dalton@somewhere.com", $list[0]);
-
-	}
-
-	// TODO: Test Execute QueryForList With ResultMap With Dynamic Element
-	function testExecuteQueryForListWithResultMapWithDynamicElement()
-	{
-		//$list = $this->sqlmap->QueryForList("GetAllAccountsViaResultMapWithDynamicElement", "LIKE");
-
-		//$this->assertAccount1$list[0]);
-		//$this->assertIdentical(3, $list->getCount());
-		//$this->assertIdentical(1, $list[0]->getID());
-		//$this->assertIdentical(2, $list[1]->getID());
-		//$this->assertIdentical(4, $list[2]->getID());
-
-		//list = $this->sqlmap->QueryForList("GetAllAccountsViaResultMapWithDynamicElement", "=");
-
-		//$this->assertIdentical(0, $list->getCount());
-	}
-
-
-
-	/**
-	 * Test Get Account Via Inline Parameters
-	 */
-	function testExecuteQueryForObjectViaInlineParameters()
-	{
-		$account= new Account();
-		$account->setID(1);
-
-		$testAccount = $this->sqlmap->QueryForObject("GetAccountViaInlineParameters", $account);
-
-		$this->assertAccount1($testAccount);
-	}
-	/**/
-
-	// TODO: Test ExecuteQuery For Object With Enum property
-
-	function testExecuteQueryForObjectWithEnum()
-	{
-		//$enumClass = $this->sqlmap->QueryForObject("GetEnumeration", 1);
-
-		//$this->assertIdentical(enumClass.Day, Days.Sat);
-		//$this->assertIdentical(enumClass.Color, Colors.Red);
-		//$this->assertIdentical(enumClass.Month, Months.August);
-
-		//enumClass = $this->sqlmap->QueryForObject("GetEnumeration", 3) as Enumeration;
-
-		//$this->assertIdentical(enumClass.Day, Days.Mon);
-		//$this->assertIdentical(enumClass.Color, Colors.Blue);
-		//$this->assertIdentical(enumClass.Month, Months.September);*/
-	}
-
-	#endregion
-
-	#region  List Query tests
-
-	/**
-	 * Test QueryForList with Hashtable ResultMap
-	 */
-	function testQueryForListWithHashtableResultMap()
-	{
-		$this->initScript('account-init.sql');
-		$list = $this->sqlmap->QueryForList("GetAllAccountsAsHashMapViaResultMap");
-
-		$this->assertAccount1AsHashArray($list[0]);
-		$this->assertIdentical(5, count($list));
-
-		$this->assertIdentical(1, (int)$list[0]["Id"]);
-		$this->assertIdentical(2, (int)$list[1]["Id"]);
-		$this->assertIdentical(3, (int)$list[2]["Id"]);
-		$this->assertIdentical(4, (int)$list[3]["Id"]);
-		$this->assertIdentical(5, (int)$list[4]["Id"]);
-	}
-
-	/**
-	 * Test QueryForList with Hashtable ResultClass
-	 */
-	function testQueryForListWithHashtableResultClass()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllAccountsAsHashtableViaResultClass");
-
-		$this->assertAccount1AsHashArray($list[0]);
-		$this->assertIdentical(5, count($list));
-
-		$this->assertIdentical(1, (int)$list[0]["Id"]);
-		$this->assertIdentical(2, (int)$list[1]["Id"]);
-		$this->assertIdentical(3, (int)$list[2]["Id"]);
-		$this->assertIdentical(4, (int)$list[3]["Id"]);
-		$this->assertIdentical(5, (int)$list[4]["Id"]);
-	}
-
-	/**
-	 * Test QueryForList with IList ResultClass
-	 */
-	function testQueryForListWithIListResultClass()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllAccountsAsArrayListViaResultClass");
-
-		$listAccount = $list[0];
-
-		$this->assertIdentical(1,(int)$listAccount[0]);
-		$this->assertIdentical("Joe",$listAccount[1]);
-		$this->assertIdentical("Dalton",$listAccount[2]);
-		$this->assertIdentical("Joe.Dalton@somewhere.com",$listAccount[3]);
-
-		$this->assertIdentical(5, count($list));
-
-		$listAccount = $list[0];
-		$this->assertIdentical(1, (int)$listAccount[0]);
-		$listAccount = $list[1];
-		$this->assertIdentical(2, (int)$listAccount[0]);
-		$listAccount = $list[2];
-		$this->assertIdentical(3, (int)$listAccount[0]);
-		$listAccount = $list[3];
-		$this->assertIdentical(4, (int)$listAccount[0]);
-		$listAccount = $list[4];
-		$this->assertIdentical(5, (int)$listAccount[0]);
-	}
-
-	/**
-	 * Test QueryForList With ResultMap, result collection as ArrayList
-	 */
-	function testQueryForListWithResultMap()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllAccountsViaResultMap");
-
-		$this->assertAccount1($list[0]);
-		$this->assertIdentical(5, count($list));
-		$this->assertIdentical(1, $list[0]->getID());
-		$this->assertIdentical(2, $list[1]->getID());
-		$this->assertIdentical(3, $list[2]->getID());
-		$this->assertIdentical(4, $list[3]->getID());
-		$this->assertIdentical(5, $list[4]->getID());
-	}
-
-	/**
-	 * Test ExecuteQueryForPaginatedList
-	 */
-	function testExecuteQueryForPaginatedList()
-	{
-		// Get List of all 5
-		$list = $this->sqlmap->QueryForPagedList("GetAllAccountsViaResultMap", null, 2);
-
-		// Test initial state (page 0)
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertTrue($list->getIsNextPageAvailable());
-		$this->assertAccount1($list[0]);
-		$this->assertIdentical(2, $list->getCount());
-		$this->assertIdentical(1, $list[0]->getID());
-		$this->assertIdentical(2, $list[1]->getID());
-
-		// Test illegal previous page (no effect, state should be same)
-		$list->PreviousPage();
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertTrue($list->getIsNextPageAvailable());
-		$this->assertAccount1($list[0]);
-		$this->assertIdentical(2, $list->getCount());
-		$this->assertIdentical(1, $list[0]->getID());
-		$this->assertIdentical(2, $list[1]->getID());
-
-		// Test next (page 1)
-		$list->NextPage();
-		$this->assertTrue($list->getIsPreviousPageAvailable());
-		$this->assertTrue($list->getIsNextPageAvailable());
-		$this->assertIdentical(2, $list->getCount());
-		$this->assertIdentical(3, $list[0]->getID());
-		$this->assertIdentical(4, $list[1]->getID());
-
-		// Test next (page 2 -last)
-		$list->NextPage();
-		$this->assertTrue($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(1, $list->getCount());
-		$this->assertIdentical(5, $list[0]->getID());
-
-		// Test previous (page 1)
-		$list->PreviousPage();
-		$this->assertTrue($list->getIsPreviousPageAvailable());
-		$this->assertTrue($list->getIsNextPageAvailable());
-		$this->assertIdentical(2, $list->getCount());
-		$this->assertIdentical(3, $list[0]->getID());
-		$this->assertIdentical(4, $list[1]->getID());
-
-		// Test previous (page 0 -first)
-		$list->PreviousPage();
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertTrue($list->getIsNextPageAvailable());
-		$this->assertAccount1($list[0]);
-		$this->assertIdentical(2, $list->getCount());
-		$this->assertIdentical(1, $list[0]->getID());
-		$this->assertIdentical(2, $list[1]->getID());
-
-		// Test goto (page 0)
-		$list->GotoPage(0);
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertTrue($list->getIsNextPageAvailable());
-		$this->assertIdentical(2, $list->getCount());
-		$this->assertIdentical(1, $list[0]->getID());
-		$this->assertIdentical(2, $list[1]->getID());
-
-		// Test goto (page 1)
-		$list->GotoPage(1);
-		$this->assertTrue($list->getIsPreviousPageAvailable());
-		$this->assertTrue($list->getIsNextPageAvailable());
-		$this->assertIdentical(2, $list->getCount());
-		$this->assertIdentical(3, $list[0]->getID());
-		$this->assertIdentical(4, $list[1]->getID());
-
-		// Test goto (page 2)
-		$list->GotoPage(2);
-		$this->assertTrue($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(1, $list->getCount());
-		$this->assertIdentical(5, $list[0]->getID());
-
-		// Test illegal goto (page 0)
-		$list->GotoPage(3);
-		$this->assertTrue($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(0, $list->getCount());
-
-		$list = $this->sqlmap->QueryForPagedList("GetNoAccountsViaResultMap", null, 2);
-
-		// Test empty list
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(0, $list->getCount());
-
-		// Test next
-		$list->NextPage();
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(0, $list->getCount());
-
-		// Test previous
-		$list->PreviousPage();
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(0, $list->getCount());
-
-		// Test previous
-		$list->GotoPage(0);
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(0, $list->getCount());
-		$list = $this->sqlmap->QueryForPagedList("GetFewAccountsViaResultMap", null, 2);
-
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(1, $list->getCount());
-
-		// Test next
-		$list->NextPage();
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(1, $list->getCount());
-		// Test previous
-		$list->PreviousPage();
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(1, $list->getCount());
-
-		// Test previous
-		$list->GotoPage(0);
-		$this->assertFalse($list->getIsPreviousPageAvailable());
-		$this->assertFalse($list->getIsNextPageAvailable());
-		$this->assertIdentical(1, $list->getCount());
-
-
-		$list = $this->sqlmap->QueryForPagedList("GetAllAccountsViaResultMap", null, 5);
-
-		$this->assertIdentical(5, $list->getCount());
-
-		$list->NextPage();
-		$this->assertIdentical(5, $list->getCount());
-
-		$b = $list->getIsPreviousPageAvailable();
-		$list->PreviousPage();
-		$this->assertIdentical(5, $list->getCount());
-	}
-
-	/**
-	 * Test QueryForList with ResultObject :
-	 * AccountCollection strongly typed collection
-	 */
-	function testQueryForListWithResultObject()
-	{
-		$accounts = new AccountCollection();
-
-		$this->sqlmap->QueryForList("GetAllAccountsViaResultMap", null, $accounts);
-		$this->assertAccount1($accounts[0]);
-		$this->assertIdentical(5, $accounts->getCount());
-		$this->assertIdentical(1, $accounts[0]->getID());
-		$this->assertIdentical(2, $accounts[1]->getID());
-		$this->assertIdentical(3, $accounts[2]->getID());
-		$this->assertIdentical(4, $accounts[3]->getID());
-		$this->assertIdentical(5, $accounts[4]->GetId());
-	}
-
-	/**
-	 * Test QueryForList with ListClass : LineItemCollection
-	 */
-	function testQueryForListWithListClass()
-	{
-		$linesItem = $this->sqlmap->QueryForList("GetLineItemsForOrderWithListClass", 10);
-
-		$this->assertNotNull($linesItem);
-		$this->assertIdentical(2, $linesItem->getCount());
-		$this->assertIdentical("ESM-34", $linesItem[0]->getCode());
-		$this->assertIdentical("QSM-98", $linesItem[1]->getCode());
-	}
-
-	/**
-	 * Test QueryForList with no result.
-	 */
-	function testQueryForListWithNoResult()
-	{
-		$list = $this->sqlmap->QueryForList("GetNoAccountsViaResultMap");
-
-		$this->assertIdentical(0, count($list));
-	}
-
-	/**
-	 * Test QueryForList with ResultClass : Account.
-	 */
-	function testQueryForListResultClass()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllAccountsViaResultClass");
-
-		$this->assertAccount1($list[0]);
-		$this->assertIdentical(5, count($list));
-		$this->assertIdentical(1, $list[0]->getID());
-		$this->assertIdentical(2, $list[1]->getID());
-		$this->assertIdentical(3, $list[2]->getID());
-		$this->assertIdentical(4, $list[3]->getID());
-		$this->assertIdentical(5, $list[4]->getID());
-	}
-
-	/**
-	 * Test QueryForList with simple resultClass : string
-	 */
-	function testQueryForListWithSimpleResultClass()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllEmailAddressesViaResultClass");
-
-		$this->assertIdentical("Joe.Dalton@somewhere.com", $list[0]);
-		$this->assertIdentical("Averel.Dalton@somewhere.com", $list[1]);
-		$this->assertIdentical('', $list[2]);
-		$this->assertIdentical("Jack.Dalton@somewhere.com", $list[3]);
-		$this->assertIdentical('', $list[4]);
-	}
-
-	/**
-	 * Test  QueryForList with simple ResultMap : string
-	 */
-	function testQueryForListWithSimpleResultMap()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllEmailAddressesViaResultMap");
-
-		$this->assertIdentical("Joe.Dalton@somewhere.com", $list[0]);
-		$this->assertIdentical("Averel.Dalton@somewhere.com", $list[1]);
-		$this->assertIdentical('', $list[2]);
-		$this->assertIdentical("Jack.Dalton@somewhere.com", $list[3]);
-		$this->assertIdentical('', $list[4]);
-	}
-
-	/**
-	 * Test QueryForListWithSkipAndMax
-	 */
-	function testQueryForListWithSkipAndMax()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllAccountsViaResultMap", null, null, 2, 2);
-
-		$this->assertIdentical(2, count($list));
-		$this->assertIdentical(3, $list[0]->getID());
-		$this->assertIdentical(4, $list[1]->getID());
-	}
-
-
-	/**
-	 * Test row delegate
-	 */
-	function testQueryWithRowDelegate()
-	{
-		//$handler = new SqlMapper.RowDelegate(this.RowHandler);
-
-		//$list = $this->sqlmap->QueryWithRowDelegate("GetAllAccountsViaResultMap", null, handler);
-
-		//$this->assertIdentical(5, _index);
-		//$this->assertIdentical(5, $list->getCount());
-		//$this->assertAccount1$list[0]);
-		//$this->assertIdentical(1, $list[0]->getID());
-		//$this->assertIdentical(2, $list[1]->getID());
-		//$this->assertIdentical(3, $list[2]->getID());
-		//$this->assertIdentical(4, $list[3]->getID());
-		//$this->assertIdentical(5, $list[4]->getID());
-	}
-
-	#endregion
-
-	#region  Map Tests
-
-	/**
-	 * Test ExecuteQueryForMap : Hashtable.
-	 */
-	function testExecuteQueryForMap()
-	{
-		$map = $this->sqlmap->QueryForMap("GetAllAccountsViaResultClass", null, "FirstName");
-
-		$this->assertIdentical(5, count($map));
-		$this->assertAccount1($map["Joe"]);
-
-		$this->assertIdentical(1, $map["Joe"]->getID());
-		$this->assertIdentical(2, $map["Averel"]->getID());
-		$this->assertIdentical(3, $map["William"]->getID());
-		$this->assertIdentical(4, $map["Jack"]->getID());
-		$this->assertIdentical(5, $map["Gilles"]->getID());
-	}
-
-	/**
-	 * Test ExecuteQueryForMap : Hashtable.
-	 *
-	 * If the keyProperty is an integer, you must acces the map
-	 * by map[integer] and not by map["integer"]
-	 */
-	function testExecuteQueryForMap2()
-	{
-		$map = $this->sqlmap->QueryForMap("GetAllOrderWithLineItems", null, "PostalCode");
-
-		$this->assertIdentical(11, count($map));
-		$order = $map["T4H 9G4"];
-
-		$this->assertIdentical(2, $order->getLineItemsList()->getCount());
-	}
-
-	/**
-	 * Test ExecuteQueryForMap with value property :
-	 * "FirstName" as key, "EmailAddress" as value
-	 */
-	function testExecuteQueryForMapWithValueProperty()
-	{
-		$map = $this->sqlmap->QueryForMap("GetAllAccountsViaResultClass", null,
-						"FirstName", "EmailAddress");
-
-		$this->assertIdentical(5, count($map));
-
-		$this->assertIdentical("Joe.Dalton@somewhere.com", $map["Joe"]);
-		$this->assertIdentical("Averel.Dalton@somewhere.com", $map["Averel"]);
-		$this->assertNull($map["William"]);
-		$this->assertIdentical("Jack.Dalton@somewhere.com", $map["Jack"]);
-		$this->assertNull($map["Gilles"]);
-	}
-
-	/**
-	 * Test ExecuteQueryForWithJoined
-	 */
-	function testExecuteQueryForWithJoined()
-	{
-		$order = $this->sqlmap->QueryForObject("GetOrderJoinWithAccount",10);
-
-		$this->assertNotNull($order->getAccount());
-
-		$order = $this->sqlmap->QueryForObject("GetOrderJoinWithAccount",11);
-
-		$this->assertNull($order->getAccount());
-	}
-
-	/**
-	 * Test ExecuteQueryFor With Complex Joined
-	 *
-	 * A->B->C
-	 *  ->E
-	 *  ->F
-	 */
-	function testExecuteQueryForWithComplexJoined()
-	{
-		$a = $this->sqlmap->QueryForObject("SelectComplexJoined");
-		$this->assertNotNull($a);
-		$this->assertNotNull($a->getB());
-		$this->assertNotNull($a->getB()->getC());
-		$this->assertNull($a->getB()->getD());
-		$this->assertNotNull($a->getE());
-		$this->assertNull($a->getF());
-	}
-	#endregion
-
-	#region Extends statement
-
-	/**
-	 * Test base Extends statement
-	 */
-	function testExtendsGetAllAccounts()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllAccounts");
-
-		$this->assertAccount1($list[0]);
-		$this->assertIdentical(5, count($list));
-		$this->assertIdentical(1, $list[0]->getID());
-		$this->assertIdentical(2, $list[1]->getID());
-		$this->assertIdentical(3, $list[2]->getID());
-		$this->assertIdentical(4, $list[3]->getID());
-		$this->assertIdentical(5, $list[4]->getID());
-	}
-
-	/**
-	 * Test Extends statement GetAllAccountsOrderByName extends GetAllAccounts
-	 */
-	function testExtendsGetAllAccountsOrderByName()
-	{
-		$list = $this->sqlmap->QueryForList("GetAllAccountsOrderByName");
-
-		$this->assertAccount1($list[3]);
-		$this->assertIdentical(5, count($list));
-
-		$this->assertIdentical(2, $list[0]->getID());
-		$this->assertIdentical(5, $list[1]->getID());
-		$this->assertIdentical(4, $list[2]->getID());
-		$this->assertIdentical(1, $list[3]->getID());
-		$this->assertIdentical(3, $list[4]->getID());
-	}
-
-	/**
-	 * Test Extends statement GetOneAccount extends GetAllAccounts
-	 */
-	function testExtendsGetOneAccount()
-	{
-		$account= $this->sqlmap->QueryForObject("GetOneAccount", 1);
-		$this->assertAccount1($account);
-	}
-
-	/**
-	 * Test Extends statement GetSomeAccount extends GetAllAccounts
-	 */
-	function testExtendsGetSomeAccount()
-	{
-		$param["lowID"] = 2;
-		$param["hightID"] = 4;
-
-		$list = $this->sqlmap->QueryForList("GetSomeAccount", $param);
-
-		$this->assertIdentical(3, count($list));
-
-		$this->assertIdentical(2, $list[0]->getID());
-		$this->assertIdentical(3, $list[1]->getID());
-		$this->assertIdentical(4, $list[2]->getID());
-	}
-
-	#endregion
-
-	#region Update tests
-
-
-	/**
-	 * Test Insert account via public fields
-	 */
-	function testInsertAccountViaPublicFields()
-	{
-		$this->initScript('account-init.sql');
-
-		$account = new AccountBis();
-
-		$account->Id = 10;
-		$account->FirstName = "Luky";
-		$account->LastName = "Luke";
-		$account->EmailAddress = "luly.luke@somewhere.com";
-
-		$this->sqlmap->Insert("InsertAccountViaPublicFields", $account);
-
-		$testAccount = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 10);
-
-		$this->assertNotNull($testAccount);
-
-		$this->assertIdentical(10, $testAccount->getID());
-
-		$this->initScript('account-init.sql');
-	}
-
-	/**
-	 *
-	 */
-	function testInsertOrderViaProperties()
-	{
-		$this->initScript('account-init.sql');
-		$this->initScript('order-init.sql');
-		$account= $this->NewAccount6();
-
-		$this->sqlmap->Insert("InsertAccountViaParameterMap", $account);
-
-		$order = new Order();
-		$order->setId(99);
-		$order->setCardExpiry("09/11");
-		$order->setAccount($account);
-		$order->setCardNumber("154564656");
-		$order->setCardType("Visa");
-		$order->setCity("Lyon");
-		$order->setDate('2005-05-20');
-		$order->setPostalCode("69004");
-		$order->setProvince("Rhone");
-		$order->setStreet("rue Durand");
-
-		$this->sqlmap->Insert("InsertOrderViaPublicFields", $order);
-
-		$this->initScript('account-init.sql');
-		$this->initScript('order-init.sql');
-	}
-
-
-	/**
-	 * Test Insert account via inline parameters
-	 */
-	function testInsertAccountViaInlineParameters()
-	{
-		$this->initScript('account-init.sql');
-		$account= new Account();
-
-		$account->setId(10);
-		$account->setFirstName("Luky");
-		$account->setLastName("Luke");
-		$account->setEmailAddress("luly.luke@somewhere.com");
-
-		$this->sqlmap->Insert("InsertAccountViaInlineParameters", $account);
-
-		$testAccount = $this->sqlmap->QueryForObject("GetAccountViaColumnIndex", 10);
-
-		$this->assertNotNull($testAccount);
-		$this->assertIdentical(10, $testAccount->getId());
-		$this->initScript('account-init.sql');
-	}
-
-	/**
-	 * Test Insert account via parameterMap
-	 */
-	function testInsertAccountViaParameterMap()
-	{
-		$this->initScript('account-init.sql');
-		$account= $this->NewAccount6();
-		$this->sqlmap->Insert("InsertAccountViaParameterMap", $account);
-
-		$account = $this->sqlmap->QueryForObject("GetAccountNullableEmail", 6);
-		$this->AssertAccount6($account);
-
-		$this->initScript('account-init.sql');
-	}
-
-	/**
-	 * Test Update via parameterMap
-	 */
-	function testUpdateViaParameterMap()
-	{
-		$this->initScript('account-init.sql');
-		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
-
-		$account->setEmailAddress("new@somewhere.com");
-		$this->sqlmap->Update("UpdateAccountViaParameterMap", $account);
-
-		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
-
-		$this->assertIdentical("new@somewhere.com", $account->getEmailAddress());
-		$this->initScript('account-init.sql');
-	}
-
-	/**
-	 * Test Update via parameterMap V2
-	 */
-	function testUpdateViaParameterMap2()
-	{
-		$this->initScript('account-init.sql');
-		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
-
-		$account->setEmailAddress("new@somewhere.com");
-		$this->sqlmap->Update("UpdateAccountViaParameterMap2", $account);
-
-		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
-
-		$this->assertIdentical("new@somewhere.com", $account->getEmailAddress());
-		$this->initScript('account-init.sql');
-	}
-
-	/**
-	 * Test Update with inline parameters
-	 */
-	function testUpdateWithInlineParameters()
-	{
-		$this->initScript('account-init.sql');
-		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
-
-		$account->setEmailAddress("new@somewhere.com");
-		$this->sqlmap->Update("UpdateAccountViaInlineParameters", $account);
-
-		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
-
-		$this->assertIdentical("new@somewhere.com", $account->getEmailAddress());
-		$this->initScript('account-init.sql');
-	}
-
-	/**
-	 * Test Execute Update With Parameter Class
-	 */
-	function testExecuteUpdateWithParameterClass()
-	{
-		$this->initScript('account-init.sql');
-		$account= $this->NewAccount6();
-
-		$this->sqlmap->Insert("InsertAccountViaParameterMap", $account);
-
-		$noRowsDeleted = $this->sqlmap->Update("DeleteAccount", null);
-
-		$this->sqlmap->Update("DeleteAccount", $account);
-
-		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 6);
-
-		$this->assertNull($account);
-		$this->assertIdentical(0, $noRowsDeleted);
-		$this->initScript('account-init.sql');
-	}
-
-	/**
-	 * Test Execute Delete
-	 */
-	function testExecuteDelete()
-	{
-		$this->initScript('account-init.sql');
-		$account= $this->NewAccount6();
-
-		$this->sqlmap->Insert("InsertAccountViaParameterMap", $account);
-
-		$account = null;
-		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 6);
-
-		$this->assertTrue($account->getId() == 6);
-
-		$rowNumber = $this->sqlmap->Delete("DeleteAccount", $account);
-		$this->assertTrue($rowNumber == 1);
-
-		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 6);
-
-		$this->assertNull($account);
-		$this->initScript('account-init.sql');
-	}
-
-	/**
-	 * Test Execute Delete
-	 */
-	function testDeleteWithComments()
-	{
-		$this->initScript('line-item-init.sql');
-		$rowNumber = $this->sqlmap->Delete("DeleteWithComments");
-
-		$this->assertIdentical($rowNumber, 2);
-		$this->initScript('line-item-init.sql');
-	}
-
-
-
-	#endregion
-
-	#region Row delegate
-
-	private $_index = 0;
-
-	function RowHandler($sender, $paramterObject, $list)
-	{
-		//_index++;
-		//$this->assertIdentical(_index, (($account) obj).Id);
-		//$list->Add(obj);
-	}
-
-	#endregion
-
-	#region JIRA Tests
-
-	/**
-	 * Test JIRA 30 (repeating property)
-	 */
-	function testJIRA30()
-	{
-		$account= new Account();
-		$account->setId(1);
-		$account->setFirstName("Joe");
-		$account->setLastName("Dalton");
-		$account->setEmailAddress("Joe.Dalton@somewhere.com");
-
-		$result = $this->sqlmap->QueryForObject("GetAccountWithRepeatingProperty", $account);
-
-		$this->assertAccount1($result);
-	}
-
-	/**
-	 * Test Bit column
-	 */
-	function testJIRA42()
-	{
-		$other = new Other();
-
-		$other->setInt(100);
-		$other->setBool(true);
-		$other->setLong(789456321);
-
-		$this->sqlmap->Insert("InsertBool", $other);
-	}
-
-	/**
-	 * Test for access a result map in a different namespace
-	 */
-	function testJIRA45()
-	{
-		$account= $this->sqlmap->QueryForObject("GetAccountJIRA45", 1);
-		$this->assertAccount1($account);
-	}
-
-	/**
-	 * Test : Whitespace is not maintained properly when CDATA tags are used
-	 */
-	function testJIRA110()
-	{
-		$account= $this->sqlmap->QueryForObject("Get1Account");
-		$this->assertAccount1($account);
-	}
-
-	/**
-	 * Test : Whitespace is not maintained properly when CDATA tags are used
-	 */
-	function testJIRA110Bis()
-	{
-		$list = $this->sqlmap->QueryForList("GetAccounts");
-
-		$this->assertAccount1($list[0]);
-		$this->assertIdentical(5, count($list));
-	}
-
-	/**
-	 * Test for cache stats only being calculated on CachingStatments
-	 */
-	function testJIRA113()
-	{
-	  //	$this->sqlmap->FlushCaches();
-
-		// taken from TestFlushDataCache()
-		// first query is not cached, second query is: 50% cache hit
-		/*$list = $this->sqlmap->QueryForList("GetCachedAccountsViaResultMap");
-		$firstId = HashCodeProvider.GetIdentityHashCode(list);
-		list = $this->sqlmap->QueryForList("GetCachedAccountsViaResultMap");
-		int secondId = HashCodeProvider.GetIdentityHashCode(list);
-		$this->assertIdentical(firstId, secondId);
-
-		string cacheStats = $this->sqlmap->GetDataCacheStats();
-
-		$this->assertNotNull(cacheStats);*/
-	}
-
-	#endregion
-
-	#region CustomTypeHandler tests
-
-	/**
-	 * Test CustomTypeHandler
-	 */
-	function testExecuteQueryWithCustomTypeHandler()
-	{
-		$this->sqlmap->registerTypeHandler(new HundredsBool());
-		$this->sqlmap->registerTypeHandler(new OuiNonBool());
-
-		$list = $this->sqlmap->QueryForList("GetAllAccountsViaCustomTypeHandler");
-
-		$this->assertAccount1($list[0]);
-		$this->assertIdentical(5, count($list));
-		$this->assertIdentical(1, $list[0]->getID());
-		$this->assertIdentical(2, $list[1]->getID());
-		$this->assertIdentical(3, $list[2]->getID());
-		$this->assertIdentical(4, $list[3]->getID());
-		$this->assertIdentical(5, $list[4]->getID());
-
-		$this->assertFalse($list[0]->getCartOptions());
-		$this->assertFalse($list[1]->getCartOptions());
-		$this->assertTrue($list[2]->getCartOptions());
-		$this->assertTrue($list[3]->getCartOptions());
-		$this->assertTrue($list[4]->getCartOptions());
-
-		$this->assertTrue($list[0]->getBannerOptions());
-		$this->assertTrue($list[1]->getBannerOptions());
-		$this->assertFalse($list[2]->getBannerOptions());
-		$this->assertFalse($list[3]->getBannerOptions());
-		$this->assertTrue($list[4]->getBannerOptions());
-	}
-
-	/**
-	 * Test CustomTypeHandler Oui/Non
-	 */
-	function testCustomTypeHandler()
-	{
-		$this->initScript('other-init.sql');
-		$this->initScript('account-init.sql');
-
-		$this->sqlmap->registerTypeHandler(new OuiNonBool());
-
-		$other = new Other();
-		$other->setInt(99);
-		$other->setLong(1966);
-		$other->setBool(true);
-		$other->setBool2(false);
-		$this->sqlmap->Insert("InsertCustomTypeHandler", $other);
-
-		$anOther = $this->sqlmap->QueryForObject("SelectByInt", 99);
-		$this->assertNotNull( $anOther );
-		$this->assertIdentical(99, (int)$anOther->getInt());
-		$this->assertIdentical(1966, (int)$anOther->getLong());
-		$this->assertIdentical(true, (boolean)$anOther->getBool());
-		$this->assertIdentical(false, (boolean)$anOther->getBool2());
-
-	}
-
-	/**
-	 * Test CustomTypeHandler Oui/Non
-	 */
-	function testInsertInlineCustomTypeHandlerV1()
-	{
-		$this->initScript('other-init.sql');
-		$this->initScript('account-init.sql');
-
-		$other = new Other();
-		$other->setInt(99);
-		$other->setLong(1966);
-		$other->setBool(true);
-		$other->setBool2(false);
-
-		$this->sqlmap->Insert("InsertInlineCustomTypeHandlerV1", $other);
-
-		$anOther = $this->sqlmap->QueryForObject("SelectByIntV1", 99);
-
-		$this->assertNotNull( $anOther );
-		$this->assertIdentical(99, (int)$anOther->getInt());
-		$this->assertIdentical(1966, (int)$anOther->getLong());
-		$this->assertIdentical(true, (boolean)$anOther->getBool());
-		$this->assertIdentical(false, (boolean)$anOther->getBool2());
-
-	}
-
-	/**
-	 * Test CustomTypeHandler Oui/Non
-	 */
-	function testInsertInlineCustomTypeHandlerV2()
-	{
-		$this->initScript('other-init.sql');
-		$this->initScript('account-init.sql');
-
-		$other = new Other();
-		$other->setInt(99);
-		$other->setLong(1966);
-		$other->setBool(true);
-		$other->setBool2(false);
-
-		$this->sqlmap->Insert("InsertInlineCustomTypeHandlerV2", $other);
-
-		$anOther = $this->sqlmap->QueryForObject("SelectByInt", 99);
-
-		$this->assertNotNull( $anOther );
-		$this->assertIdentical(99, (int)$anOther->getInt());
-		$this->assertIdentical(1966, (int)$anOther->getLong());
-		$this->assertIdentical(true, (boolean)$anOther->getBool());
-		$this->assertIdentical(false, (boolean)$anOther->getBool2());
-	}
-	#endregion
-	/**/
-}
-
+<?php
+require_once(dirname(__FILE__).'/BaseCase.php');
+
+/**
+ * @package System.DataAccess.SQLMap
+ */
+class StatementTest extends BaseCase
+{
+	function __construct()
+	{
+		parent::__construct();
+		$this->initSqlMap();
+
+		//force autoload
+		new Account;
+		new Order;
+		new LineItem;
+		new LineItemCollection;
+		new A; new B; new C; new D; new E; new F;
+	}
+
+	public function setup()
+	{
+
+	}
+
+	function resetDatabase()
+	{
+		$this->initScript('account-init.sql');
+		$this->initScript('order-init.sql');
+		$this->initScript('line-item-init.sql');
+//		$this->initScript('enumeration-init.sql');
+		$this->initScript('other-init.sql');
+	}
+
+
+	#region Object Query tests
+
+	/**
+	 * Test Open connection with a connection string
+	 */
+	function testOpenConnection()
+	{
+		$conn = $this->sqlmap->getDbConnection();
+		$conn->setActive(true);
+		$account= $this->sqlmap->QueryForObject("SelectWithProperty");
+		$conn->setActive(false);
+		$this->assertAccount1($account);
+	}
+
+	/**
+	 * Test use a statement with property subtitution
+	 * (JIRA 22)
+	 */
+	function testSelectWithProperty()
+	{
+		$account= $this->sqlmap->QueryForObject("SelectWithProperty");
+		$this->assertAccount1($account);
+	}
+
+	/**
+	 * Test ExecuteQueryForObject Via ColumnName
+	 */
+	function testExecuteQueryForObjectViaColumnName()
+	{
+		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
+		$this->assertAccount1($account);
+	}
+
+	/**
+	 * Test ExecuteQueryForObject Via ColumnIndex
+	 */
+	function testExecuteQueryForObjectViaColumnIndex()
+	{
+		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnIndex", 1);
+		$this->assertAccount1($account);
+	}
+
+	/**
+	 * Test ExecuteQueryForObject Via ResultClass
+	 */
+	function testExecuteQueryForObjectViaResultClass()
+	{
+		$account= $this->sqlmap->QueryForObject("GetAccountViaResultClass", 1);
+		$this->assertAccount1($account);
+	}
+
+	/**
+	 * Test ExecuteQueryForObject With simple ResultClass : string
+	 */
+	function testExecuteQueryForObjectWithSimpleResultClass()
+	{
+		$email = $this->sqlmap->QueryForObject("GetEmailAddressViaResultClass", 1);
+		$this->assertIdentical("Joe.Dalton@somewhere.com", $email);
+	}
+
+	/**
+	 * Test ExecuteQueryForObject With simple ResultMap : string
+	 */
+	function testExecuteQueryForObjectWithSimpleResultMap()
+	{
+		$email = $this->sqlmap->QueryForObject("GetEmailAddressViaResultMap", 1);
+		$this->assertIdentical("Joe.Dalton@somewhere.com", $email);
+	}
+
+	/**
+	 * Test Primitive ReturnValue : TDateTime
+	 */
+	function testPrimitiveReturnValue()
+	{
+		$CardExpiry = $this->sqlmap->QueryForObject("GetOrderCardExpiryViaResultClass", 1);
+		$date = @mktime(8, 15, 00, 2, 15, 2003);
+		$this->assertIdentical($date, $CardExpiry->getTimeStamp());
+	}
+
+	/**
+	 * Test ExecuteQueryForObject with result object : Account
+	 */
+	function testExecuteQueryForObjectWithResultObject()
+	{
+		$account= new Account();
+		$testAccount = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1, $account);
+		$this->assertAccount1($account);
+		$this->assertTrue($account == $testAccount);
+	}
+
+	/**
+	 * Test ExecuteQueryForObject as array
+	 */
+	function testExecuteQueryForObjectAsHashArray()
+	{
+		$account = $this->sqlmap->QueryForObject("GetAccountAsHashtable", 1);
+		$this->assertAccount1AsHashArray($account);
+	}
+
+	/**
+	 * Test ExecuteQueryForObject as Hashtable ResultClass
+	 */
+	function testExecuteQueryForObjectAsHashtableResultClass()
+	{
+		$account = $this->sqlmap->QueryForObject("GetAccountAsHashtableResultClass", 1);
+		$this->assertAccount1AsHashArray($account);
+	}
+
+	/**
+	 * Test ExecuteQueryForObject via Hashtable
+	 */
+	function testExecuteQueryForObjectViaHashtable()
+	{
+		$param["LineItem_ID"] = 2;
+		$param["Order_ID"] = 9;
+
+		$testItem = $this->sqlmap->QueryForObject("GetSpecificLineItem", $param);
+
+		$this->assertNotNull($testItem);
+		$this->assertIdentical("TSM-12", $testItem->getCode());
+	}
+	/**/
+
+	//TODO: Test Query Dynamic Sql Element
+	function testQueryDynamicSqlElement()
+	{
+		//$list = $this->sqlmap->QueryForList("GetDynamicOrderedEmailAddressesViaResultMap", "Account_ID");
+
+		//$this->assertIdentical("Joe.Dalton@somewhere.com", $list[0]);
+
+		//list = $this->sqlmap->QueryForList("GetDynamicOrderedEmailAddressesViaResultMap", "Account_FirstName");
+
+		//$this->assertIdentical("Averel.Dalton@somewhere.com", $list[0]);
+
+	}
+
+	// TODO: Test Execute QueryForList With ResultMap With Dynamic Element
+	function testExecuteQueryForListWithResultMapWithDynamicElement()
+	{
+		//$list = $this->sqlmap->QueryForList("GetAllAccountsViaResultMapWithDynamicElement", "LIKE");
+
+		//$this->assertAccount1$list[0]);
+		//$this->assertIdentical(3, $list->getCount());
+		//$this->assertIdentical(1, $list[0]->getID());
+		//$this->assertIdentical(2, $list[1]->getID());
+		//$this->assertIdentical(4, $list[2]->getID());
+
+		//list = $this->sqlmap->QueryForList("GetAllAccountsViaResultMapWithDynamicElement", "=");
+
+		//$this->assertIdentical(0, $list->getCount());
+	}
+
+
+
+	/**
+	 * Test Get Account Via Inline Parameters
+	 */
+	function testExecuteQueryForObjectViaInlineParameters()
+	{
+		$account= new Account();
+		$account->setID(1);
+
+		$testAccount = $this->sqlmap->QueryForObject("GetAccountViaInlineParameters", $account);
+
+		$this->assertAccount1($testAccount);
+	}
+	/**/
+
+	// TODO: Test ExecuteQuery For Object With Enum property
+
+	function testExecuteQueryForObjectWithEnum()
+	{
+		//$enumClass = $this->sqlmap->QueryForObject("GetEnumeration", 1);
+
+		//$this->assertIdentical(enumClass.Day, Days.Sat);
+		//$this->assertIdentical(enumClass.Color, Colors.Red);
+		//$this->assertIdentical(enumClass.Month, Months.August);
+
+		//enumClass = $this->sqlmap->QueryForObject("GetEnumeration", 3) as Enumeration;
+
+		//$this->assertIdentical(enumClass.Day, Days.Mon);
+		//$this->assertIdentical(enumClass.Color, Colors.Blue);
+		//$this->assertIdentical(enumClass.Month, Months.September);*/
+	}
+
+	#endregion
+
+	#region  List Query tests
+
+	/**
+	 * Test QueryForList with Hashtable ResultMap
+	 */
+	function testQueryForListWithHashtableResultMap()
+	{
+		$this->initScript('account-init.sql');
+		$list = $this->sqlmap->QueryForList("GetAllAccountsAsHashMapViaResultMap");
+
+		$this->assertAccount1AsHashArray($list[0]);
+		$this->assertIdentical(5, count($list));
+
+		$this->assertIdentical(1, (int)$list[0]["Id"]);
+		$this->assertIdentical(2, (int)$list[1]["Id"]);
+		$this->assertIdentical(3, (int)$list[2]["Id"]);
+		$this->assertIdentical(4, (int)$list[3]["Id"]);
+		$this->assertIdentical(5, (int)$list[4]["Id"]);
+	}
+
+	/**
+	 * Test QueryForList with Hashtable ResultClass
+	 */
+	function testQueryForListWithHashtableResultClass()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllAccountsAsHashtableViaResultClass");
+
+		$this->assertAccount1AsHashArray($list[0]);
+		$this->assertIdentical(5, count($list));
+
+		$this->assertIdentical(1, (int)$list[0]["Id"]);
+		$this->assertIdentical(2, (int)$list[1]["Id"]);
+		$this->assertIdentical(3, (int)$list[2]["Id"]);
+		$this->assertIdentical(4, (int)$list[3]["Id"]);
+		$this->assertIdentical(5, (int)$list[4]["Id"]);
+	}
+
+	/**
+	 * Test QueryForList with IList ResultClass
+	 */
+	function testQueryForListWithIListResultClass()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllAccountsAsArrayListViaResultClass");
+
+		$listAccount = $list[0];
+
+		$this->assertIdentical(1,(int)$listAccount[0]);
+		$this->assertIdentical("Joe",$listAccount[1]);
+		$this->assertIdentical("Dalton",$listAccount[2]);
+		$this->assertIdentical("Joe.Dalton@somewhere.com",$listAccount[3]);
+
+		$this->assertIdentical(5, count($list));
+
+		$listAccount = $list[0];
+		$this->assertIdentical(1, (int)$listAccount[0]);
+		$listAccount = $list[1];
+		$this->assertIdentical(2, (int)$listAccount[0]);
+		$listAccount = $list[2];
+		$this->assertIdentical(3, (int)$listAccount[0]);
+		$listAccount = $list[3];
+		$this->assertIdentical(4, (int)$listAccount[0]);
+		$listAccount = $list[4];
+		$this->assertIdentical(5, (int)$listAccount[0]);
+	}
+
+	/**
+	 * Test QueryForList With ResultMap, result collection as ArrayList
+	 */
+	function testQueryForListWithResultMap()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllAccountsViaResultMap");
+
+		$this->assertAccount1($list[0]);
+		$this->assertIdentical(5, count($list));
+		$this->assertIdentical(1, $list[0]->getID());
+		$this->assertIdentical(2, $list[1]->getID());
+		$this->assertIdentical(3, $list[2]->getID());
+		$this->assertIdentical(4, $list[3]->getID());
+		$this->assertIdentical(5, $list[4]->getID());
+	}
+
+	/**
+	 * Test ExecuteQueryForPaginatedList
+	 */
+	function testExecuteQueryForPaginatedList()
+	{
+		// Get List of all 5
+		$list = $this->sqlmap->QueryForPagedList("GetAllAccountsViaResultMap", null, 2);
+
+		// Test initial state (page 0)
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertTrue($list->getIsNextPageAvailable());
+		$this->assertAccount1($list[0]);
+		$this->assertIdentical(2, $list->getCount());
+		$this->assertIdentical(1, $list[0]->getID());
+		$this->assertIdentical(2, $list[1]->getID());
+
+		// Test illegal previous page (no effect, state should be same)
+		$list->PreviousPage();
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertTrue($list->getIsNextPageAvailable());
+		$this->assertAccount1($list[0]);
+		$this->assertIdentical(2, $list->getCount());
+		$this->assertIdentical(1, $list[0]->getID());
+		$this->assertIdentical(2, $list[1]->getID());
+
+		// Test next (page 1)
+		$list->NextPage();
+		$this->assertTrue($list->getIsPreviousPageAvailable());
+		$this->assertTrue($list->getIsNextPageAvailable());
+		$this->assertIdentical(2, $list->getCount());
+		$this->assertIdentical(3, $list[0]->getID());
+		$this->assertIdentical(4, $list[1]->getID());
+
+		// Test next (page 2 -last)
+		$list->NextPage();
+		$this->assertTrue($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(1, $list->getCount());
+		$this->assertIdentical(5, $list[0]->getID());
+
+		// Test previous (page 1)
+		$list->PreviousPage();
+		$this->assertTrue($list->getIsPreviousPageAvailable());
+		$this->assertTrue($list->getIsNextPageAvailable());
+		$this->assertIdentical(2, $list->getCount());
+		$this->assertIdentical(3, $list[0]->getID());
+		$this->assertIdentical(4, $list[1]->getID());
+
+		// Test previous (page 0 -first)
+		$list->PreviousPage();
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertTrue($list->getIsNextPageAvailable());
+		$this->assertAccount1($list[0]);
+		$this->assertIdentical(2, $list->getCount());
+		$this->assertIdentical(1, $list[0]->getID());
+		$this->assertIdentical(2, $list[1]->getID());
+
+		// Test goto (page 0)
+		$list->GotoPage(0);
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertTrue($list->getIsNextPageAvailable());
+		$this->assertIdentical(2, $list->getCount());
+		$this->assertIdentical(1, $list[0]->getID());
+		$this->assertIdentical(2, $list[1]->getID());
+
+		// Test goto (page 1)
+		$list->GotoPage(1);
+		$this->assertTrue($list->getIsPreviousPageAvailable());
+		$this->assertTrue($list->getIsNextPageAvailable());
+		$this->assertIdentical(2, $list->getCount());
+		$this->assertIdentical(3, $list[0]->getID());
+		$this->assertIdentical(4, $list[1]->getID());
+
+		// Test goto (page 2)
+		$list->GotoPage(2);
+		$this->assertTrue($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(1, $list->getCount());
+		$this->assertIdentical(5, $list[0]->getID());
+
+		// Test illegal goto (page 0)
+		$list->GotoPage(3);
+		$this->assertTrue($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(0, $list->getCount());
+
+		$list = $this->sqlmap->QueryForPagedList("GetNoAccountsViaResultMap", null, 2);
+
+		// Test empty list
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(0, $list->getCount());
+
+		// Test next
+		$list->NextPage();
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(0, $list->getCount());
+
+		// Test previous
+		$list->PreviousPage();
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(0, $list->getCount());
+
+		// Test previous
+		$list->GotoPage(0);
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(0, $list->getCount());
+		$list = $this->sqlmap->QueryForPagedList("GetFewAccountsViaResultMap", null, 2);
+
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(1, $list->getCount());
+
+		// Test next
+		$list->NextPage();
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(1, $list->getCount());
+		// Test previous
+		$list->PreviousPage();
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(1, $list->getCount());
+
+		// Test previous
+		$list->GotoPage(0);
+		$this->assertFalse($list->getIsPreviousPageAvailable());
+		$this->assertFalse($list->getIsNextPageAvailable());
+		$this->assertIdentical(1, $list->getCount());
+
+
+		$list = $this->sqlmap->QueryForPagedList("GetAllAccountsViaResultMap", null, 5);
+
+		$this->assertIdentical(5, $list->getCount());
+
+		$list->NextPage();
+		$this->assertIdentical(5, $list->getCount());
+
+		$b = $list->getIsPreviousPageAvailable();
+		$list->PreviousPage();
+		$this->assertIdentical(5, $list->getCount());
+	}
+
+	/**
+	 * Test QueryForList with ResultObject :
+	 * AccountCollection strongly typed collection
+	 */
+	function testQueryForListWithResultObject()
+	{
+		$accounts = new AccountCollection();
+
+		$this->sqlmap->QueryForList("GetAllAccountsViaResultMap", null, $accounts);
+		$this->assertAccount1($accounts[0]);
+		$this->assertIdentical(5, $accounts->getCount());
+		$this->assertIdentical(1, $accounts[0]->getID());
+		$this->assertIdentical(2, $accounts[1]->getID());
+		$this->assertIdentical(3, $accounts[2]->getID());
+		$this->assertIdentical(4, $accounts[3]->getID());
+		$this->assertIdentical(5, $accounts[4]->GetId());
+	}
+
+	/**
+	 * Test QueryForList with ListClass : LineItemCollection
+	 */
+	function testQueryForListWithListClass()
+	{
+		$linesItem = $this->sqlmap->QueryForList("GetLineItemsForOrderWithListClass", 10);
+
+		$this->assertNotNull($linesItem);
+		$this->assertIdentical(2, $linesItem->getCount());
+		$this->assertIdentical("ESM-34", $linesItem[0]->getCode());
+		$this->assertIdentical("QSM-98", $linesItem[1]->getCode());
+	}
+
+	/**
+	 * Test QueryForList with no result.
+	 */
+	function testQueryForListWithNoResult()
+	{
+		$list = $this->sqlmap->QueryForList("GetNoAccountsViaResultMap");
+
+		$this->assertIdentical(0, count($list));
+	}
+
+	/**
+	 * Test QueryForList with ResultClass : Account.
+	 */
+	function testQueryForListResultClass()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllAccountsViaResultClass");
+
+		$this->assertAccount1($list[0]);
+		$this->assertIdentical(5, count($list));
+		$this->assertIdentical(1, $list[0]->getID());
+		$this->assertIdentical(2, $list[1]->getID());
+		$this->assertIdentical(3, $list[2]->getID());
+		$this->assertIdentical(4, $list[3]->getID());
+		$this->assertIdentical(5, $list[4]->getID());
+	}
+
+	/**
+	 * Test QueryForList with simple resultClass : string
+	 */
+	function testQueryForListWithSimpleResultClass()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllEmailAddressesViaResultClass");
+
+		$this->assertIdentical("Joe.Dalton@somewhere.com", $list[0]);
+		$this->assertIdentical("Averel.Dalton@somewhere.com", $list[1]);
+		$this->assertIdentical('', $list[2]);
+		$this->assertIdentical("Jack.Dalton@somewhere.com", $list[3]);
+		$this->assertIdentical('', $list[4]);
+	}
+
+	/**
+	 * Test  QueryForList with simple ResultMap : string
+	 */
+	function testQueryForListWithSimpleResultMap()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllEmailAddressesViaResultMap");
+
+		$this->assertIdentical("Joe.Dalton@somewhere.com", $list[0]);
+		$this->assertIdentical("Averel.Dalton@somewhere.com", $list[1]);
+		$this->assertIdentical('', $list[2]);
+		$this->assertIdentical("Jack.Dalton@somewhere.com", $list[3]);
+		$this->assertIdentical('', $list[4]);
+	}
+
+	/**
+	 * Test QueryForListWithSkipAndMax
+	 */
+	function testQueryForListWithSkipAndMax()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllAccountsViaResultMap", null, null, 2, 2);
+
+		$this->assertIdentical(2, count($list));
+		$this->assertIdentical(3, $list[0]->getID());
+		$this->assertIdentical(4, $list[1]->getID());
+	}
+
+
+	/**
+	 * Test row delegate
+	 */
+	function testQueryWithRowDelegate()
+	{
+		//$handler = new SqlMapper.RowDelegate(this.RowHandler);
+
+		//$list = $this->sqlmap->QueryWithRowDelegate("GetAllAccountsViaResultMap", null, handler);
+
+		//$this->assertIdentical(5, _index);
+		//$this->assertIdentical(5, $list->getCount());
+		//$this->assertAccount1$list[0]);
+		//$this->assertIdentical(1, $list[0]->getID());
+		//$this->assertIdentical(2, $list[1]->getID());
+		//$this->assertIdentical(3, $list[2]->getID());
+		//$this->assertIdentical(4, $list[3]->getID());
+		//$this->assertIdentical(5, $list[4]->getID());
+	}
+
+	#endregion
+
+	#region  Map Tests
+
+	/**
+	 * Test ExecuteQueryForMap : Hashtable.
+	 */
+	function testExecuteQueryForMap()
+	{
+		$map = $this->sqlmap->QueryForMap("GetAllAccountsViaResultClass", null, "FirstName");
+
+		$this->assertIdentical(5, count($map));
+		$this->assertAccount1($map["Joe"]);
+
+		$this->assertIdentical(1, $map["Joe"]->getID());
+		$this->assertIdentical(2, $map["Averel"]->getID());
+		$this->assertIdentical(3, $map["William"]->getID());
+		$this->assertIdentical(4, $map["Jack"]->getID());
+		$this->assertIdentical(5, $map["Gilles"]->getID());
+	}
+
+	/**
+	 * Test ExecuteQueryForMap : Hashtable.
+	 *
+	 * If the keyProperty is an integer, you must acces the map
+	 * by map[integer] and not by map["integer"]
+	 */
+	function testExecuteQueryForMap2()
+	{
+		$map = $this->sqlmap->QueryForMap("GetAllOrderWithLineItems", null, "PostalCode");
+
+		$this->assertIdentical(11, count($map));
+		$order = $map["T4H 9G4"];
+
+		$this->assertIdentical(2, $order->getLineItemsList()->getCount());
+	}
+
+	/**
+	 * Test ExecuteQueryForMap with value property :
+	 * "FirstName" as key, "EmailAddress" as value
+	 */
+	function testExecuteQueryForMapWithValueProperty()
+	{
+		$map = $this->sqlmap->QueryForMap("GetAllAccountsViaResultClass", null,
+						"FirstName", "EmailAddress");
+
+		$this->assertIdentical(5, count($map));
+
+		$this->assertIdentical("Joe.Dalton@somewhere.com", $map["Joe"]);
+		$this->assertIdentical("Averel.Dalton@somewhere.com", $map["Averel"]);
+		$this->assertNull($map["William"]);
+		$this->assertIdentical("Jack.Dalton@somewhere.com", $map["Jack"]);
+		$this->assertNull($map["Gilles"]);
+	}
+
+	/**
+	 * Test ExecuteQueryForWithJoined
+	 */
+	function testExecuteQueryForWithJoined()
+	{
+		$order = $this->sqlmap->QueryForObject("GetOrderJoinWithAccount",10);
+
+		$this->assertNotNull($order->getAccount());
+
+		$order = $this->sqlmap->QueryForObject("GetOrderJoinWithAccount",11);
+
+		$this->assertNull($order->getAccount());
+	}
+
+	/**
+	 * Test ExecuteQueryFor With Complex Joined
+	 *
+	 * A->B->C
+	 *  ->E
+	 *  ->F
+	 */
+	function testExecuteQueryForWithComplexJoined()
+	{
+		$a = $this->sqlmap->QueryForObject("SelectComplexJoined");
+		$this->assertNotNull($a);
+		$this->assertNotNull($a->getB());
+		$this->assertNotNull($a->getB()->getC());
+		$this->assertNull($a->getB()->getD());
+		$this->assertNotNull($a->getE());
+		$this->assertNull($a->getF());
+	}
+	#endregion
+
+	#region Extends statement
+
+	/**
+	 * Test base Extends statement
+	 */
+	function testExtendsGetAllAccounts()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllAccounts");
+
+		$this->assertAccount1($list[0]);
+		$this->assertIdentical(5, count($list));
+		$this->assertIdentical(1, $list[0]->getID());
+		$this->assertIdentical(2, $list[1]->getID());
+		$this->assertIdentical(3, $list[2]->getID());
+		$this->assertIdentical(4, $list[3]->getID());
+		$this->assertIdentical(5, $list[4]->getID());
+	}
+
+	/**
+	 * Test Extends statement GetAllAccountsOrderByName extends GetAllAccounts
+	 */
+	function testExtendsGetAllAccountsOrderByName()
+	{
+		$list = $this->sqlmap->QueryForList("GetAllAccountsOrderByName");
+
+		$this->assertAccount1($list[3]);
+		$this->assertIdentical(5, count($list));
+
+		$this->assertIdentical(2, $list[0]->getID());
+		$this->assertIdentical(5, $list[1]->getID());
+		$this->assertIdentical(4, $list[2]->getID());
+		$this->assertIdentical(1, $list[3]->getID());
+		$this->assertIdentical(3, $list[4]->getID());
+	}
+
+	/**
+	 * Test Extends statement GetOneAccount extends GetAllAccounts
+	 */
+	function testExtendsGetOneAccount()
+	{
+		$account= $this->sqlmap->QueryForObject("GetOneAccount", 1);
+		$this->assertAccount1($account);
+	}
+
+	/**
+	 * Test Extends statement GetSomeAccount extends GetAllAccounts
+	 */
+	function testExtendsGetSomeAccount()
+	{
+		$param["lowID"] = 2;
+		$param["hightID"] = 4;
+
+		$list = $this->sqlmap->QueryForList("GetSomeAccount", $param);
+
+		$this->assertIdentical(3, count($list));
+
+		$this->assertIdentical(2, $list[0]->getID());
+		$this->assertIdentical(3, $list[1]->getID());
+		$this->assertIdentical(4, $list[2]->getID());
+	}
+
+	#endregion
+
+	#region Update tests
+
+
+	/**
+	 * Test Insert account via public fields
+	 */
+	function testInsertAccountViaPublicFields()
+	{
+		$this->initScript('account-init.sql');
+
+		$account = new AccountBis();
+
+		$account->Id = 10;
+		$account->FirstName = "Luky";
+		$account->LastName = "Luke";
+		$account->EmailAddress = "luly.luke@somewhere.com";
+
+		$this->sqlmap->Insert("InsertAccountViaPublicFields", $account);
+
+		$testAccount = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 10);
+
+		$this->assertNotNull($testAccount);
+
+		$this->assertIdentical(10, $testAccount->getID());
+
+		$this->initScript('account-init.sql');
+	}
+
+	/**
+	 *
+	 */
+	function testInsertOrderViaProperties()
+	{
+		$this->initScript('account-init.sql');
+		$this->initScript('order-init.sql');
+		$account= $this->NewAccount6();
+
+		$this->sqlmap->Insert("InsertAccountViaParameterMap", $account);
+
+		$order = new Order();
+		$order->setId(99);
+		$order->setCardExpiry("09/11");
+		$order->setAccount($account);
+		$order->setCardNumber("154564656");
+		$order->setCardType("Visa");
+		$order->setCity("Lyon");
+		$order->setDate('2005-05-20');
+		$order->setPostalCode("69004");
+		$order->setProvince("Rhone");
+		$order->setStreet("rue Durand");
+
+		$this->sqlmap->Insert("InsertOrderViaPublicFields", $order);
+
+		$this->initScript('account-init.sql');
+		$this->initScript('order-init.sql');
+	}
+
+
+	/**
+	 * Test Insert account via inline parameters
+	 */
+	function testInsertAccountViaInlineParameters()
+	{
+		$this->initScript('account-init.sql');
+		$account= new Account();
+
+		$account->setId(10);
+		$account->setFirstName("Luky");
+		$account->setLastName("Luke");
+		$account->setEmailAddress("luly.luke@somewhere.com");
+
+		$this->sqlmap->Insert("InsertAccountViaInlineParameters", $account);
+
+		$testAccount = $this->sqlmap->QueryForObject("GetAccountViaColumnIndex", 10);
+
+		$this->assertNotNull($testAccount);
+		$this->assertIdentical(10, $testAccount->getId());
+		$this->initScript('account-init.sql');
+	}
+
+	/**
+	 * Test Insert account via parameterMap
+	 */
+	function testInsertAccountViaParameterMap()
+	{
+		$this->initScript('account-init.sql');
+		$account= $this->NewAccount6();
+		$this->sqlmap->Insert("InsertAccountViaParameterMap", $account);
+
+		$account = $this->sqlmap->QueryForObject("GetAccountNullableEmail", 6);
+		$this->AssertAccount6($account);
+
+		$this->initScript('account-init.sql');
+	}
+
+	/**
+	 * Test Update via parameterMap
+	 */
+	function testUpdateViaParameterMap()
+	{
+		$this->initScript('account-init.sql');
+		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
+
+		$account->setEmailAddress("new@somewhere.com");
+		$this->sqlmap->Update("UpdateAccountViaParameterMap", $account);
+
+		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
+
+		$this->assertIdentical("new@somewhere.com", $account->getEmailAddress());
+		$this->initScript('account-init.sql');
+	}
+
+	/**
+	 * Test Update via parameterMap V2
+	 */
+	function testUpdateViaParameterMap2()
+	{
+		$this->initScript('account-init.sql');
+		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
+
+		$account->setEmailAddress("new@somewhere.com");
+		$this->sqlmap->Update("UpdateAccountViaParameterMap2", $account);
+
+		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
+
+		$this->assertIdentical("new@somewhere.com", $account->getEmailAddress());
+		$this->initScript('account-init.sql');
+	}
+
+	/**
+	 * Test Update with inline parameters
+	 */
+	function testUpdateWithInlineParameters()
+	{
+		$this->initScript('account-init.sql');
+		$account= $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
+
+		$account->setEmailAddress("new@somewhere.com");
+		$this->sqlmap->Update("UpdateAccountViaInlineParameters", $account);
+
+		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 1);
+
+		$this->assertIdentical("new@somewhere.com", $account->getEmailAddress());
+		$this->initScript('account-init.sql');
+	}
+
+	/**
+	 * Test Execute Update With Parameter Class
+	 */
+	function testExecuteUpdateWithParameterClass()
+	{
+		$this->initScript('account-init.sql');
+		$account= $this->NewAccount6();
+
+		$this->sqlmap->Insert("InsertAccountViaParameterMap", $account);
+
+		$noRowsDeleted = $this->sqlmap->Update("DeleteAccount", null);
+
+		$this->sqlmap->Update("DeleteAccount", $account);
+
+		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 6);
+
+		$this->assertNull($account);
+		$this->assertIdentical(0, $noRowsDeleted);
+		$this->initScript('account-init.sql');
+	}
+
+	/**
+	 * Test Execute Delete
+	 */
+	function testExecuteDelete()
+	{
+		$this->initScript('account-init.sql');
+		$account= $this->NewAccount6();
+
+		$this->sqlmap->Insert("InsertAccountViaParameterMap", $account);
+
+		$account = null;
+		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 6);
+
+		$this->assertTrue($account->getId() == 6);
+
+		$rowNumber = $this->sqlmap->Delete("DeleteAccount", $account);
+		$this->assertTrue($rowNumber == 1);
+
+		$account = $this->sqlmap->QueryForObject("GetAccountViaColumnName", 6);
+
+		$this->assertNull($account);
+		$this->initScript('account-init.sql');
+	}
+
+	/**
+	 * Test Execute Delete
+	 */
+	function testDeleteWithComments()
+	{
+		$this->initScript('line-item-init.sql');
+		$rowNumber = $this->sqlmap->Delete("DeleteWithComments");
+
+		$this->assertIdentical($rowNumber, 2);
+		$this->initScript('line-item-init.sql');
+	}
+
+
+
+	#endregion
+
+	#region Row delegate
+
+	private $_index = 0;
+
+	function RowHandler($sender, $paramterObject, $list)
+	{
+		//_index++;
+		//$this->assertIdentical(_index, (($account) obj).Id);
+		//$list->Add(obj);
+	}
+
+	#endregion
+
+	#region JIRA Tests
+
+	/**
+	 * Test JIRA 30 (repeating property)
+	 */
+	function testJIRA30()
+	{
+		$account= new Account();
+		$account->setId(1);
+		$account->setFirstName("Joe");
+		$account->setLastName("Dalton");
+		$account->setEmailAddress("Joe.Dalton@somewhere.com");
+
+		$result = $this->sqlmap->QueryForObject("GetAccountWithRepeatingProperty", $account);
+
+		$this->assertAccount1($result);
+	}
+
+	/**
+	 * Test Bit column
+	 */
+	function testJIRA42()
+	{
+		$other = new Other();
+
+		$other->setInt(100);
+		$other->setBool(true);
+		$other->setLong(789456321);
+
+		$this->sqlmap->Insert("InsertBool", $other);
+	}
+
+	/**
+	 * Test for access a result map in a different namespace
+	 */
+	function testJIRA45()
+	{
+		$account= $this->sqlmap->QueryForObject("GetAccountJIRA45", 1);
+		$this->assertAccount1($account);
+	}
+
+	/**
+	 * Test : Whitespace is not maintained properly when CDATA tags are used
+	 */
+	function testJIRA110()
+	{
+		$account= $this->sqlmap->QueryForObject("Get1Account");
+		$this->assertAccount1($account);
+	}
+
+	/**
+	 * Test : Whitespace is not maintained properly when CDATA tags are used
+	 */
+	function testJIRA110Bis()
+	{
+		$list = $this->sqlmap->QueryForList("GetAccounts");
+
+		$this->assertAccount1($list[0]);
+		$this->assertIdentical(5, count($list));
+	}
+
+	/**
+	 * Test for cache stats only being calculated on CachingStatments
+	 */
+	function testJIRA113()
+	{
+	  //	$this->sqlmap->FlushCaches();
+
+		// taken from TestFlushDataCache()
+		// first query is not cached, second query is: 50% cache hit
+		/*$list = $this->sqlmap->QueryForList("GetCachedAccountsViaResultMap");
+		$firstId = HashCodeProvider.GetIdentityHashCode(list);
+		list = $this->sqlmap->QueryForList("GetCachedAccountsViaResultMap");
+		int secondId = HashCodeProvider.GetIdentityHashCode(list);
+		$this->assertIdentical(firstId, secondId);
+
+		string cacheStats = $this->sqlmap->GetDataCacheStats();
+
+		$this->assertNotNull(cacheStats);*/
+	}
+
+	#endregion
+
+	#region CustomTypeHandler tests
+
+	/**
+	 * Test CustomTypeHandler
+	 */
+	function testExecuteQueryWithCustomTypeHandler()
+	{
+		$this->sqlmap->registerTypeHandler(new HundredsBool());
+		$this->sqlmap->registerTypeHandler(new OuiNonBool());
+
+		$list = $this->sqlmap->QueryForList("GetAllAccountsViaCustomTypeHandler");
+
+		$this->assertAccount1($list[0]);
+		$this->assertIdentical(5, count($list));
+		$this->assertIdentical(1, $list[0]->getID());
+		$this->assertIdentical(2, $list[1]->getID());
+		$this->assertIdentical(3, $list[2]->getID());
+		$this->assertIdentical(4, $list[3]->getID());
+		$this->assertIdentical(5, $list[4]->getID());
+
+		$this->assertFalse($list[0]->getCartOptions());
+		$this->assertFalse($list[1]->getCartOptions());
+		$this->assertTrue($list[2]->getCartOptions());
+		$this->assertTrue($list[3]->getCartOptions());
+		$this->assertTrue($list[4]->getCartOptions());
+
+		$this->assertTrue($list[0]->getBannerOptions());
+		$this->assertTrue($list[1]->getBannerOptions());
+		$this->assertFalse($list[2]->getBannerOptions());
+		$this->assertFalse($list[3]->getBannerOptions());
+		$this->assertTrue($list[4]->getBannerOptions());
+	}
+
+	/**
+	 * Test CustomTypeHandler Oui/Non
+	 */
+	function testCustomTypeHandler()
+	{
+		$this->initScript('other-init.sql');
+		$this->initScript('account-init.sql');
+
+		$this->sqlmap->registerTypeHandler(new OuiNonBool());
+
+		$other = new Other();
+		$other->setInt(99);
+		$other->setLong(1966);
+		$other->setBool(true);
+		$other->setBool2(false);
+		$this->sqlmap->Insert("InsertCustomTypeHandler", $other);
+
+		$anOther = $this->sqlmap->QueryForObject("SelectByInt", 99);
+		$this->assertNotNull( $anOther );
+		$this->assertIdentical(99, (int)$anOther->getInt());
+		$this->assertIdentical(1966, (int)$anOther->getLong());
+		$this->assertIdentical(true, (boolean)$anOther->getBool());
+		$this->assertIdentical(false, (boolean)$anOther->getBool2());
+
+	}
+
+	/**
+	 * Test CustomTypeHandler Oui/Non
+	 */
+	function testInsertInlineCustomTypeHandlerV1()
+	{
+		$this->initScript('other-init.sql');
+		$this->initScript('account-init.sql');
+
+		$other = new Other();
+		$other->setInt(99);
+		$other->setLong(1966);
+		$other->setBool(true);
+		$other->setBool2(false);
+
+		$this->sqlmap->Insert("InsertInlineCustomTypeHandlerV1", $other);
+
+		$anOther = $this->sqlmap->QueryForObject("SelectByIntV1", 99);
+
+		$this->assertNotNull( $anOther );
+		$this->assertIdentical(99, (int)$anOther->getInt());
+		$this->assertIdentical(1966, (int)$anOther->getLong());
+		$this->assertIdentical(true, (boolean)$anOther->getBool());
+		$this->assertIdentical(false, (boolean)$anOther->getBool2());
+
+	}
+
+	/**
+	 * Test CustomTypeHandler Oui/Non
+	 */
+	function testInsertInlineCustomTypeHandlerV2()
+	{
+		$this->initScript('other-init.sql');
+		$this->initScript('account-init.sql');
+
+		$other = new Other();
+		$other->setInt(99);
+		$other->setLong(1966);
+		$other->setBool(true);
+		$other->setBool2(false);
+
+		$this->sqlmap->Insert("InsertInlineCustomTypeHandlerV2", $other);
+
+		$anOther = $this->sqlmap->QueryForObject("SelectByInt", 99);
+
+		$this->assertNotNull( $anOther );
+		$this->assertIdentical(99, (int)$anOther->getInt());
+		$this->assertIdentical(1966, (int)$anOther->getLong());
+		$this->assertIdentical(true, (boolean)$anOther->getBool());
+		$this->assertIdentical(false, (boolean)$anOther->getBool2());
+	}
+	#endregion
+	/**/
+}
+
 ?>
\ No newline at end of file
-- 
cgit v1.2.3