From 903ae8a581fac1e6917fc3e31d2ad8fb91df80c3 Mon Sep 17 00:00:00 2001 From: ctrlaltca <> Date: Thu, 12 Jul 2012 11:21:01 +0000 Subject: standardize the use of unix eol; use svn properties to enforce native eol --- tests/unit/SQLMap/SelectKeyTest.php | 238 ++++++++++++++++++------------------ 1 file changed, 119 insertions(+), 119 deletions(-) (limited to 'tests/unit/SQLMap/SelectKeyTest.php') 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 @@ -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'); - } -} - +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 -- cgit v1.2.3