From a3388622287e218beddfa14a47ed677d4307b36b Mon Sep 17 00:00:00 2001 From: Fabio Bas Date: Fri, 25 Mar 2016 17:55:51 +0100 Subject: Removed simpletest and moved all tests in the unit tree Tests are executed now, but a lot of them need fixing. --- tests/simple_unit/SqlMap/ResultMapTest.php | 271 ----------------------------- 1 file changed, 271 deletions(-) delete mode 100644 tests/simple_unit/SqlMap/ResultMapTest.php (limited to 'tests/simple_unit/SqlMap/ResultMapTest.php') diff --git a/tests/simple_unit/SqlMap/ResultMapTest.php b/tests/simple_unit/SqlMap/ResultMapTest.php deleted file mode 100644 index b14cee31..00000000 --- a/tests/simple_unit/SqlMap/ResultMapTest.php +++ /dev/null @@ -1,271 +0,0 @@ -initSqlMap(); - new Order; - new LineItemCollection; - new Account; - } - - function resetDatabase() - { - $this->initScript('account-init.sql'); - $this->initScript('order-init.sql'); - $this->initScript('line-item-init.sql'); -// $this->initScript('enumeration-init.sql'); - } - - function testColumnsByName() - { - $order = $this->sqlmap->QueryForObject('GetOrderLiteByColumnName', 1); - $this->assertOrder1($order); - } - - function testColumnsByIndex() - { - $order = $this->sqlmap->QueryForObject("GetOrderLiteByColumnIndex", 1); - $this->assertOrder1($order); - } - - function testExtendedResultMap() - { - $order = $this->sqlmap->queryForObject("GetOrderWithLineItemsNoLazyLoad", 1); - $this->assertOrder1($order); - $this->assertTrue($order->getLineItemsList() instanceof TList); - $this->assertIdentical(2, $order->getLineItemsList()->getCount()); - } - - - function testLazyLoad() - { - $order = $this->sqlmap->QueryForObject("GetOrderWithLineItems", 1); - $this->assertOrder1($order); - $this->assertNotNull($order->getLineItemsList()); - $this->assertFalse($order->getLineItemsList() instanceof TList); - $this->assertIdentical(2, $order->getLineItemsList()->getCount()); - - // After a call to a method from a proxy object, - // the proxy object is replaced by the real object. - $this->assertTrue($order->getLineItemsList() instanceof TList); - $this->assertIdentical(2, $order->getLineItemsList()->getCount()); - } - - function testLazyWithTypedCollectionMapping() - { - $order = $this->sqlmap->queryForObject("GetOrderWithLineItemCollection", 1); - $this->assertOrder1($order); - $this->assertNotNull($order->getLineItems()); - $this->assertFalse($order->getLineItemsList() instanceof LineItemCollection); - - $this->assertIdentical(2, $order->getLineItems()->getCount()); - - // After a call to a method from a proxy object, - // the proxy object is replaced by the real object. - $this->assertTrue($order->getLineItems() instanceof LineItemCollection); - foreach($order->getLineItems() as $item) - { - $this->assertNotNull($item); - $this->assertTrue($item instanceof LineItem); - } - } - - function testNullValueReplacementOnString() - { - $account = $this->sqlmap->queryForObject("GetAccountViaColumnName", 5); - $this->assertIdentical("no_email@provided.com", $account->getEmailAddress()); - } - - function testTypeSpecified() - { - $order = $this->sqlmap->queryForObject("GetOrderWithTypes", 1); - $this->assertOrder1($order); - } - - function testComplexObjectMapping() - { - $order = $this->sqlmap->queryForObject("GetOrderWithAccount", 1); - $this->assertOrder1($order); - $this->assertAccount1($order->getAccount()); - } - - function testCollectionMappingAndExtends() - { - $order = $this->sqlmap->queryForObject("GetOrderWithLineItemsCollection", 1); - $this->assertOrder1($order); - - // Check strongly typed collection - $this->assertNotNull($order->getLineItems()); - $this->assertIdentical(2, $order->getLineItems()->getCount()); - } - - function testListMapping() - { - $order = $this->sqlmap->queryForObject("GetOrderWithLineItems", 1); - $this->assertOrder1($order); - - // Check TList collection - $this->assertNotNull($order->getLineItemsList()); - $this->assertIdentical(2, $order->getLineItemsList()->getCount()); - } - - function testArrayMapping() - { - $order = $this->sqlmap->queryForObject("GetOrderWithLineItemArray", 1); - $this->assertOrder1($order); - $this->assertNotNull($order->getLineItemsArray()); - $this->assertTrue(is_array($order->getLineItemsArray())); - $this->assertIdentical(2, count($order->getLineItemsArray())); - } - - function testTypedCollectionMapping() - { - $order = $this->sqlmap->queryForObject("GetOrderWithLineItemCollectionNoLazy", 1); - $this->assertOrder1($order); - $this->assertNotNull($order->getLineItems()); - $this->assertTrue($order->getLineItems() instanceof LineItemCollection); - $this->assertIdentical(2, $order->getLineItems()->getCount()); - foreach($order->getLineItems() as $item) - { - $this->assertNotNull($item); - $this->assertTrue($item instanceof LineItem); - } - } - - function testHashArrayMapping() - { - $order = $this->sqlmap->queryForObject("GetOrderAsHastable", 1); - $this->assertOrder1AsHashArray($order); - } - - function testNestedObjects() - { - $order = $this->sqlmap->queryForObject("GetOrderJoinedFavourite", 1); - - $this->assertOrder1($order); - $this->assertNotNull($order->getFavouriteLineItem()); - $this->assertIdentical(2, (int)$order->getFavouriteLineItem()->getID()); - $this->assertIdentical("ESM-23", $order->getFavouriteLineItem()->getCode()); - - } - - - function testNestedObjects2() - { - $order = $this->sqlmap->queryForObject("GetOrderJoinedFavourite2", 1); - $this->assertOrder1($order); - - $this->assertNotNull($order->getFavouriteLineItem()); - $this->assertIdentical(2, (int)$order->getFavouriteLineItem()->getID()); - $this->assertIdentical("ESM-23", $order->getFavouriteLineItem()->getCode()); - } - - function testImplicitResultMaps() - { - $order = $this->sqlmap->queryForObject("GetOrderJoinedFavourite3", 1); - - // *** force date to timestamp since data type can't be - // *** explicity known without mapping - $order->setDate(new TDateTime($order->getDate())); - - $this->assertOrder1($order); - - $this->assertNotNull($order->getFavouriteLineItem()); - $this->assertIdentical(2, $order->getFavouriteLineItem()->getID()); - $this->assertIdentical("ESM-23", $order->getFavouriteLineItem()->getCode()); - } - - function testCompositeKeyMapping() - { - $this->resetDatabase(); - - $order1 = $this->sqlmap->queryForObject("GetOrderWithFavouriteLineItem", 1); - $order2 = $this->sqlmap->queryForObject("GetOrderWithFavouriteLineItem", 2); - - $this->assertNotNull($order1); - $this->assertNotNull($order1->getFavouriteLineItem()); - $this->assertIdentical(2, $order1->getFavouriteLineItem()->getID()); - - $this->assertNotNull($order2); - $this->assertNotNull($order2->getFavouriteLineItem()); - $this->assertIdentical(1, $order2->getFavouriteLineItem()->getID()); - } - - - function testSimpleTypeMapping() - { - $this->resetDatabase(); - - $list = $this->sqlmap->QueryForList("GetAllCreditCardNumbersFromOrders", null); - - $this->assertIdentical(5, count($list)); - $this->assertIdentical("555555555555", $list[0]); - } - - function testDecimalTypeMapping() - { - $this->resetDatabase(); - - $param["LineItem_ID"] = 1; - $param["Order_ID"] = 10; - $price = $this->sqlmap->queryForObject("GetLineItemPrice", $param); - $this->assertIdentical(gettype($price), 'double'); - $this->assertIdentical(45.43, $price); - } - -//todo -/* - function testNullValueReplacementOnEnum() - { - $enum['Id'] = 99; - $enum['Day'] = 'Days.Thu'; - $enum['Color'] = 'Colors.Blue'; - $enum['Month'] = 'Months.All'; - - $this->sqlmap->insert("InsertEnumViaParameterMap", $enum); - - $enumClass = $this->sqlmap->queryForObject("GetEnumerationNullValue", 99); - - $this->assertIdentical($enumClass['Day'], 'Days.Thu'); - $this->asserEquals($enumClass['Color'], 'Colors.Blue'); - $this->assertIdentical($enumClass['Month'], 'Months.All'); - } - - - function testByteArrayMapping() - { - } - - function testNullValueReplacementOnDecimal() - { - } - - function testNullValueReplacementOnDateTime() - { - } -*/ - -//future work - -/* - //requires dynamic SQL - function testDynamiqueCompositeKeyMapping() - { - $order1 = $this->sqlmap->queryForObject("GetOrderWithDynFavouriteLineItem", 1); - - $this->assertNotNull($order1); - $this->assertNotNull($order1->getFavouriteLineItem()); - var_dump($order1); - $this->assertIdentical(2, $order1->getFavouriteLineItem()->getID()); - } -*/ - -} -- cgit v1.2.3