diff options
author | ctrlaltca <> | 2013-01-02 14:42:24 +0000 |
---|---|---|
committer | ctrlaltca <> | 2013-01-02 14:42:24 +0000 |
commit | edf2251aca60a970e822079d23933e5b70b26571 (patch) | |
tree | 366b6688efbb03f20f47268bea57859cea673c70 /tests/unit/SQLMap/SelectKeyTest.php | |
parent | 8e5f2510bd577e15095e46afc7d0ba6808549bf8 (diff) |
backported all related changes up to 3229 to branch/3.2
Diffstat (limited to 'tests/unit/SQLMap/SelectKeyTest.php')
-rw-r--r-- | tests/unit/SQLMap/SelectKeyTest.php | 120 |
1 files changed, 0 insertions, 120 deletions
diff --git a/tests/unit/SQLMap/SelectKeyTest.php b/tests/unit/SQLMap/SelectKeyTest.php deleted file mode 100644 index 34ffbbb7..00000000 --- a/tests/unit/SQLMap/SelectKeyTest.php +++ /dev/null @@ -1,120 +0,0 @@ -<?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 |