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
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
<?php
class ConfigTest extends PHPUnit_Framework_TestCase {
public function setUp() {
// Enable logging
ORM::configure('logging', true);
// Set up the dummy database connection
$db = new MockPDO('sqlite::memory:');
ORM::set_db($db);
ORM::configure('id_column', 'primary_key');
}
public function tearDown() {
ORM::reset_config();
ORM::reset_db();
}
protected function setUpIdColumnOverrides() {
ORM::configure('id_column_overrides', array(
'widget' => 'widget_id',
'widget_handle' => 'widget_handle_id',
));
}
protected function tearDownIdColumnOverrides() {
ORM::configure('id_column_overrides', array());
}
public function testSettingIdColumn() {
ORM::for_table('widget')->find_one(5);
$expected = "SELECT * FROM `widget` WHERE `primary_key` = '5' LIMIT 1";
$this->assertEquals($expected, ORM::get_last_query());
}
public function testSettingIdColumnOverridesOne() {
$this->setUpIdColumnOverrides();
ORM::for_table('widget')->find_one(5);
$expected = "SELECT * FROM `widget` WHERE `widget_id` = '5' LIMIT 1";
$this->assertEquals($expected, ORM::get_last_query());
$this->tearDownIdColumnOverrides();
}
public function testSettingIdColumnOverridesTwo() {
$this->setUpIdColumnOverrides();
ORM::for_table('widget_handle')->find_one(5);
$expected = "SELECT * FROM `widget_handle` WHERE `widget_handle_id` = '5' LIMIT 1";
$this->assertEquals($expected, ORM::get_last_query());
$this->tearDownIdColumnOverrides();
}
public function testSettingIdColumnOverridesThree() {
$this->setUpIdColumnOverrides();
ORM::for_table('widget_nozzle')->find_one(5);
$expected = "SELECT * FROM `widget_nozzle` WHERE `primary_key` = '5' LIMIT 1";
$this->assertEquals($expected, ORM::get_last_query());
$this->tearDownIdColumnOverrides();
}
public function testInstanceIdColumnOne() {
$this->setUpIdColumnOverrides();
ORM::for_table('widget')->use_id_column('new_id')->find_one(5);
$expected = "SELECT * FROM `widget` WHERE `new_id` = '5' LIMIT 1";
$this->assertEquals($expected, ORM::get_last_query());
$this->tearDownIdColumnOverrides();
}
public function testInstanceIdColumnTwo() {
$this->setUpIdColumnOverrides();
ORM::for_table('widget_handle')->use_id_column('new_id')->find_one(5);
$expected = "SELECT * FROM `widget_handle` WHERE `new_id` = '5' LIMIT 1";
$this->assertEquals($expected, ORM::get_last_query());
$this->tearDownIdColumnOverrides();
}
public function testInstanceIdColumnThree() {
$this->setUpIdColumnOverrides();
ORM::for_table('widget_nozzle')->use_id_column('new_id')->find_one(5);
$expected = "SELECT * FROM `widget_nozzle` WHERE `new_id` = '5' LIMIT 1";
$this->assertEquals($expected, ORM::get_last_query());
$this->tearDownIdColumnOverrides();
}
public function testGetConfig() {
$this->assertTrue(ORM::get_config('logging'));
ORM::configure('logging', false);
$this->assertFalse(ORM::get_config('logging'));
ORM::configure('logging', true);
}
public function testGetConfigArray() {
$expected = array(
'connection_string' => 'sqlite::memory:',
'id_column' => 'primary_key',
'id_column_overrides' => array(),
'error_mode' => PDO::ERRMODE_EXCEPTION,
'username' => null,
'password' => null,
'driver_options' => null,
'identifier_quote_character' => '`',
'logging' => true,
'logger' => null,
'caching' => false,
'caching_auto_clear' => false,
'return_result_sets' => false,
'limit_clause_style' => 'limit',
);
$this->assertEquals($expected, ORM::get_config());
}
}
|