Removed simpletest and moved all tests in the unit tree

Tests are executed now, but a lot of them need fixing.

1 files changed, 0 insertions, 1133 deletions

diff --git a/tests/simple_unit/SqlMap/StatementTest.php b/tests/simple_unit/SqlMap/StatementTest.php
deleted file mode 100644
index 3f9f4506..00000000
--- a/tests/simple_unit/SqlMap/StatementTest.php
+++ /dev/null
@@ -1,1133 +0,0 @@
-<?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
-	/**/
-}