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
|
<?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::configure('logging', false);
ORM::set_db(null);
ORM::configure('id_column', 'id');
}
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();
}
}
|