summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/StatementTest.php
diff options
context:
space:
mode:
Diffstat (limited to 'tests/simple_unit/SqlMap/StatementTest.php')
-rw-r--r--tests/simple_unit/SqlMap/StatementTest.php2268
1 files changed, 1134 insertions, 1134 deletions
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
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-26 00:16:42 +0000