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 --- .../TableGateway/TableGatewayPgsqlTest.php | 106 ++++++++++----------- 1 file changed, 53 insertions(+), 53 deletions(-) (limited to 'tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php') diff --git a/tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php b/tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php index 4d1077f7..f34dcefc 100644 --- a/tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php +++ b/tests/simple_unit/TableGateway/TableGatewayPgsqlTest.php @@ -1,56 +1,56 @@ 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()->findAllBySql('SELECT username FROM address WHERE phone = ?', '45233')->read(); - $this->assertEqual($result['username'], 'record2'); - } - +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()->findAllBySql('SELECT username FROM address WHERE phone = ?', '45233')->read(); + $this->assertEqual($result['username'], 'record2'); + } + } ?> \ No newline at end of file -- cgit v1.2.3