diff options
author | Fabio Bas <ctrlaltca@gmail.com> | 2016-03-29 09:24:08 +0200 |
---|---|---|
committer | Fabio Bas <ctrlaltca@gmail.com> | 2016-03-29 09:24:08 +0200 |
commit | 70e305a918fcf193009831d4e89aa8c386df3dc4 (patch) | |
tree | 8cc49f253f29636ddd623aa2c2b98835300604f0 /tests/unit/Data/TableGateway/BaseGateway.php | |
parent | 55df8dac44f54a305e8bd7e50ef63f76725d2333 (diff) |
Ported / fixed most old tests
Diffstat (limited to 'tests/unit/Data/TableGateway/BaseGateway.php')
-rw-r--r-- | tests/unit/Data/TableGateway/BaseGateway.php | 96 |
1 files changed, 96 insertions, 0 deletions
diff --git a/tests/unit/Data/TableGateway/BaseGateway.php b/tests/unit/Data/TableGateway/BaseGateway.php new file mode 100644 index 00000000..3ab23b19 --- /dev/null +++ b/tests/unit/Data/TableGateway/BaseGateway.php @@ -0,0 +1,96 @@ +<?php +Prado::using('System.Data.*'); +Prado::using('System.Data.DataGateway.TTableGateway'); + +/** + * @package System.Data.TableGateway + */ +class BaseGateway extends PHPUnit_Framework_TestCase +{ + protected $gateway1; + protected $gateway2; + + /** + * @return TTableGateway + */ + function getGateway() + { + if($this->gateway1===null) + { + $conn = new TDbConnection('mysql:host=localhost;dbname=prado_unitest', 'prado_unitest','prado_unitest'); + $this->gateway1 = new TTableGateway('address', $conn); + } + return $this->gateway1; + } + + /** + * @return TTableGateway + */ + function getGateway2() + { + if($this->gateway2===null) + { + $conn = new TDbConnection('mysql:host=localhost;dbname=prado_unitest', 'prado_unitest','prado_unitest'); + $this->gateway2 = new TTableGateway('department_sections', $conn); + } + return $this->gateway2; + } + + function setup() + { + $this->delete_all(); + } + + function add_record1() + { + $result = $this->getGateway()->insert($this->get_record1()); + $this->assertTrue(intval($result) > 0); + } + function add_record2() + { + $result = $this->getGateway()->insert($this->get_record2()); + $this->assertTrue(intval($result) > 0); + } + function get_record1() + { + return array( + 'username' => 'Username', + 'phone' => 121987, + 'field1_boolean' => true, + 'field2_date' => '2007-12-25', + 'field3_double' => 121.1, + 'field4_integer' => 3, + 'field5_text' => 'asdasd', + 'field6_time' => '12:40:00', + 'field7_timestamp' => 'NOW', + 'field8_money' => '121.12', + 'field9_numeric' => 98.2232, + 'int_fk1'=>1, + 'int_fk2'=>1, + ); + } + + + function get_record2() + { + return array( + 'username' => 'record2', + 'phone' => 45233, + 'field1_boolean' => false, + 'field2_date' => '2004-10-05', + 'field3_double' => 1221.1, + 'field4_integer' => 2, + 'field5_text' => 'hello world', + 'field6_time' => '22:40:00', + 'field7_timestamp' => 'NOW', + 'field8_money' => '1121.12', + 'field9_numeric' => 8.2213, + 'int_fk1'=>1, + 'int_fk2'=>1, + ); + } + function delete_all() + { + $this->getGateway()->deleteAll('1=1'); + } +}
\ No newline at end of file |