1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
<?php
Prado::using('System.Data.*');
Prado::using('System.Data.DataGateway.TTableGateway');
class BaseGatewayTest extends UnitTestCase
{
protected $gateway1;
protected $gateway2;
/**
* @return TTableGateway
*/
function getGateway()
{
if($this->gateway1===null)
{
$conn = new TDbConnection('pgsql:host=localhost;dbname=test', 'test','test');
$this->gateway1 = new TTableGateway('address', $conn);
}
return $this->gateway1;
}
/**
* @return TTableGateway
*/
function getGateway2()
{
if($this->gateway2===null)
{
$conn = new TDbConnection('pgsql:host=localhost;dbname=test', 'test','test');
$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');
}
}
?>
|
