summaryrefslogtreecommitdiff
path: root/tests/unit/SQLMap/SelectKeyTest.php
diff options
context:
space:
mode:
Diffstat (limited to 'tests/unit/SQLMap/SelectKeyTest.php')
-rw-r--r--tests/unit/SQLMap/SelectKeyTest.php120
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