diff options
| author | wei <> | 2007-04-12 08:05:03 +0000 |
|---|---|---|
| committer | wei <> | 2007-04-12 08:05:03 +0000 |
| commit | dc3bf922d9715bfd1b2105be04a9aabc84a1d7d4 (patch) | |
| tree | ff97362f718b6ebb482128527402efe03fe1ac43 /tests/simple_unit/TableGateway/TestFindByPk.php | |
| parent | 6178a99df0c722581bc61e35559ac5f8af1cc6e8 (diff) | |
Refactor and add TTableGateway, System.Data.Common, System.Data.DataGateway
Diffstat (limited to 'tests/simple_unit/TableGateway/TestFindByPk.php')
| -rw-r--r-- | tests/simple_unit/TableGateway/TestFindByPk.php | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/tests/simple_unit/TableGateway/TestFindByPk.php b/tests/simple_unit/TableGateway/TestFindByPk.php new file mode 100644 index 00000000..b9a25edf --- /dev/null +++ b/tests/simple_unit/TableGateway/TestFindByPk.php @@ -0,0 +1,48 @@ +<?php +
+require_once(dirname(__FILE__).'/BaseGatewayTest.php');
+
+class TestFindByPk extends BaseGatewayTest
+{
+ function test_one_key()
+ {
+ $this->add_record1();
+ $id = $this->getGateway()->getLastInsertId();
+ $result = $this->getGateway()->findByPk($id);
+
+ $record1 = $this->get_record1();
+
+ //clean and ignore some fields
+ unset($result['id']);
+ unset($result['field7_timestamp']);
+ unset($record1['field7_timestamp']);
+ $result['phone'] = intval($result['phone']);
+ $result['field9_numeric'] = floatval($result['field9_numeric']);
+
+ $this->assertEqual($record1, $result);
+ }
+
+ function test_composite_key()
+ {
+ $gateway = $this->getGateway2();
+
+ $result = $gateway->findByPk(1,1);
+ $expect = array("department_id" => 1, "section_id" => 1, "order" => 0);
+ $this->assertEqual($expect, $result);
+ }
+
+ function test_find_all_keys()
+ {
+ $gateway = $this->getGateway2();
+
+ $result = $gateway->findAllByPks(array(1,1), array(3,13))->readAll();
+
+ $expect = array(
+ array("department_id" => 1, "section_id" => 1, "order" => 0),
+ array("department_id" => 3, "section_id" => 13, "order" => 0));
+
+ $this->assertEqual($expect, $result);
+
+ }
+} +?>
\ No newline at end of file |