diff options
Diffstat (limited to 'tests/unit/SQLMap/SelectKeyTest.php')
| -rw-r--r-- | tests/unit/SQLMap/SelectKeyTest.php | 238 | 
1 files changed, 119 insertions, 119 deletions
| diff --git a/tests/unit/SQLMap/SelectKeyTest.php b/tests/unit/SQLMap/SelectKeyTest.php index 6ed48165..34ffbbb7 100644 --- a/tests/unit/SQLMap/SelectKeyTest.php +++ b/tests/unit/SQLMap/SelectKeyTest.php @@ -1,120 +1,120 @@ -<?php
 -
 -require_once(dirname(__FILE__).'/BaseTest.php');
 -
 -/**
 - * @package System.DataAccess.SQLMap
 - */
 -class SelectKeyTest extends BaseTest
 -{
 -	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;
 -	}
 -
 -	/**
 -	 * Test Insert with post GeneratedKey
 -	 */
 -	function testInsertPostKey()
 -	{
 -		$this->initScript('line-item-init.sql');
 -
 -		$item = new LineItem();
 -
 -		$item->setId(10);
 -		$item->setCode("blah");
 -		$item->setOrder(new Order());
 -		$item->getOrder()->setId(9);
 -		$item->setPrice(44.00);
 -		$item->setQuantity(1);
 -
 -		$key = $this->sqlmap->Insert("InsertLineItemPostKey", $item);
 -
 -		$this->assertEquals(99, $key);
 -		$this->assertEquals(99, $item->getId());
 -
 -		$param["Order_ID"] = 9;
 -		$param["LineItem_ID"] =10;
 -		$testItem = $this->sqlmap->QueryForObject("GetSpecificLineItem", $param);
 -
 -		$this->assertNotNull($testItem);
 -		$this->assertEquals(10, $testItem->getId());
 -
 -		$this->initScript('line-item-init.sql');
 -	}
 -
 -	/**
 -	 * Test Insert pre GeneratedKey
 -	 */
 -	function testInsertPreKey()
 -	{
 -		$this->initScript('line-item-init.sql');
 -		
 -		$item = new LineItem();
 -
 -		$item->setId(10);
 -		$item->setCode("blah");
 -		$item->setOrder(new Order());
 -		$item->getOrder()->setId(9);
 -		$item->setPrice(44.00);
 -		$item->setQuantity(1);
 -
 -		$key = $this->sqlmap->Insert("InsertLineItemPreKey", $item);
 -
 -		$this->assertEquals(99, $key);
 -		$this->assertEquals(99, $item->getId());
 -
 -		$param["Order_ID"] = 9;
 -		$param["LineItem_ID"] = 99;
 -
 -		$testItem = $this->sqlmap->QueryForObject("GetSpecificLineItem", $param);
 -
 -		$this->assertNotNull($testItem);
 -		$this->assertEquals(99, $testItem->getId());
 -
 -		$this->initScript('line-item-init.sql');
 -	}
 -
 -	/**
 -	 * Test Test Insert No Key
 -	 */
 -	function testInsertNoKey()
 -	{
 -		$this->initScript('line-item-init.sql');
 -
 -		$item = new LineItem();
 -
 -		$item->setId(100);
 -		$item->setCode("blah");
 -		$item->setOrder(new Order());
 -		$item->getOrder()->setId(9);
 -		$item->setPrice(44.00);
 -		$item->setQuantity(1);
 -
 -
 -		$key = $this->sqlmap->Insert("InsertLineItemNoKey", $item);
 -
 -		$this->assertNull($key);
 -		$this->assertEquals(100, $item->getId());
 -
 -		$param["Order_ID"] = 9;
 -		$param["LineItem_ID"] = 100;
 -
 -		$testItem = $this->sqlmap->QueryForObject("GetSpecificLineItem", $param);
 -
 -		$this->assertNotNull($testItem);
 -		$this->assertEquals(100, $testItem->getId());
 -
 -		$this->initScript('line-item-init.sql');
 -	}
 -}
 -
 +<?php + +require_once(dirname(__FILE__).'/BaseTest.php'); + +/** + * @package System.DataAccess.SQLMap + */ +class SelectKeyTest extends BaseTest +{ +	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; +	} + +	/** +	 * Test Insert with post GeneratedKey +	 */ +	function testInsertPostKey() +	{ +		$this->initScript('line-item-init.sql'); + +		$item = new LineItem(); + +		$item->setId(10); +		$item->setCode("blah"); +		$item->setOrder(new Order()); +		$item->getOrder()->setId(9); +		$item->setPrice(44.00); +		$item->setQuantity(1); + +		$key = $this->sqlmap->Insert("InsertLineItemPostKey", $item); + +		$this->assertEquals(99, $key); +		$this->assertEquals(99, $item->getId()); + +		$param["Order_ID"] = 9; +		$param["LineItem_ID"] =10; +		$testItem = $this->sqlmap->QueryForObject("GetSpecificLineItem", $param); + +		$this->assertNotNull($testItem); +		$this->assertEquals(10, $testItem->getId()); + +		$this->initScript('line-item-init.sql'); +	} + +	/** +	 * Test Insert pre GeneratedKey +	 */ +	function testInsertPreKey() +	{ +		$this->initScript('line-item-init.sql'); +		 +		$item = new LineItem(); + +		$item->setId(10); +		$item->setCode("blah"); +		$item->setOrder(new Order()); +		$item->getOrder()->setId(9); +		$item->setPrice(44.00); +		$item->setQuantity(1); + +		$key = $this->sqlmap->Insert("InsertLineItemPreKey", $item); + +		$this->assertEquals(99, $key); +		$this->assertEquals(99, $item->getId()); + +		$param["Order_ID"] = 9; +		$param["LineItem_ID"] = 99; + +		$testItem = $this->sqlmap->QueryForObject("GetSpecificLineItem", $param); + +		$this->assertNotNull($testItem); +		$this->assertEquals(99, $testItem->getId()); + +		$this->initScript('line-item-init.sql'); +	} + +	/** +	 * Test Test Insert No Key +	 */ +	function testInsertNoKey() +	{ +		$this->initScript('line-item-init.sql'); + +		$item = new LineItem(); + +		$item->setId(100); +		$item->setCode("blah"); +		$item->setOrder(new Order()); +		$item->getOrder()->setId(9); +		$item->setPrice(44.00); +		$item->setQuantity(1); + + +		$key = $this->sqlmap->Insert("InsertLineItemNoKey", $item); + +		$this->assertNull($key); +		$this->assertEquals(100, $item->getId()); + +		$param["Order_ID"] = 9; +		$param["LineItem_ID"] = 100; + +		$testItem = $this->sqlmap->QueryForObject("GetSpecificLineItem", $param); + +		$this->assertNotNull($testItem); +		$this->assertEquals(100, $testItem->getId()); + +		$this->initScript('line-item-init.sql'); +	} +} +  ?>
\ No newline at end of file | 
