diff options
Diffstat (limited to 'tests/unit/Data/TableGateway/TestFindByPk.php')
-rw-r--r-- | tests/unit/Data/TableGateway/TestFindByPk.php | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/tests/unit/Data/TableGateway/TestFindByPk.php b/tests/unit/Data/TableGateway/TestFindByPk.php new file mode 100644 index 00000000..f23fafa7 --- /dev/null +++ b/tests/unit/Data/TableGateway/TestFindByPk.php @@ -0,0 +1,50 @@ +<?php + +require_once(dirname(__FILE__).'/BaseGatewayTest.php'); + +/** + * @package System.Data.TableGateway + */ +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 |