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/TableGatewayPgsqlTest.php | |
| parent | 6178a99df0c722581bc61e35559ac5f8af1cc6e8 (diff) | |
Refactor and add TTableGateway, System.Data.Common, System.Data.DataGateway
Diffstat (limited to 'tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php')
| -rw-r--r-- | tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php b/tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php new file mode 100644 index 00000000..973e8d21 --- /dev/null +++ b/tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php @@ -0,0 +1,56 @@ +<?php +require_once(dirname(__FILE__).'/BaseGatewayTest.php');
+
+class TableGatewayPgsqlTest extends BaseGatewayTest
+{
+
+ function test_update()
+ {
+ $this->add_record1();
+ $address = array('username' => 'tester 1', 'field5_text'=>null);
+ $result = $this->getGateway()->update($address, 'username = ?', 'Username');
+ $this->assertTrue($result);
+
+ $test = $this->getGateway()->find('username = ?', 'tester 1');
+ unset($test['id']);
+ $expect = $this->get_record1();
+ $expect['username'] = 'tester 1';
+ $expect['field5_text'] = null;
+ unset($expect['field7_timestamp']); unset($test['field7_timestamp']);
+ $this->assertEqual($expect, $test);
+
+ $this->assertTrue($this->getGateway()->deleteAll('username = ?', 'tester 1'));
+ }
+
+ function test_update_named()
+ {
+ $this->add_record1();
+ $address = array('username' => 'tester 1', 'field5_text'=>null);
+ $result = $this->getGateway()->update($address, 'username = :name', array(':name'=>'Username'));
+ $this->assertTrue($result);
+
+ $test = $this->getGateway()->find('username = :name', array(':name'=>'tester 1'));
+ unset($test['id']);
+ $expect = $this->get_record1();
+ $expect['username'] = 'tester 1';
+ $expect['field5_text'] = null;
+ unset($expect['field7_timestamp']); unset($test['field7_timestamp']);
+ $this->assertEqual($expect, $test);
+
+ $this->assertTrue($this->getGateway()->deleteAll('username = :name', array(':name'=>'tester 1')));
+ }
+
+ function test_find_all()
+ {
+ $this->add_record1();
+ $this->add_record2();
+
+ $results = $this->getGateway()->findAll('true')->readAll();
+ $this->assertEqual(count($results), 2);
+
+ $result = $this->getGateway()->findBySql('SELECT username FROM address WHERE phone = ?', '45233')->read();
+ $this->assertEqual($result['username'], 'record2');
+ }
+
+} +?>
\ No newline at end of file |