/
BookstoreSortableTestBase.php
120 lines (112 loc) · 3.07 KB
/
BookstoreSortableTestBase.php
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
<?php
/**
* This file is part of the Propel package.
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*
* @license MIT License
*/
require_once dirname(__FILE__) . '/../BookstoreTestBase.php';
abstract class BookstoreSortableTestBase extends BookstoreTestBase
{
protected function populateTable11()
{
Table11Peer::doDeleteAll();
$t1 = new Table11();
$t1->setRank(1);
$t1->setTitle('row1');
$t1->save();
$t2 = new Table11();
$t2->setRank(4);
$t2->setTitle('row4');
$t2->save();
$t3 = new Table11();
$t3->setRank(2);
$t3->setTitle('row2');
$t3->save();
$t4 = new Table11();
$t4->setRank(3);
$t4->setTitle('row3');
$t4->save();
}
protected function populateTable12()
{
/* List used for tests
scope=1 scope=2 scope=null
row1 row5 row7
row2 row6 row8
row3 row9
row4 row10
*/
Table12Peer::doDeleteAll();
$t1 = new Table12();
$t1->setRank(1);
$t1->setScopeValue(1);
$t1->setTitle('row1');
$t1->save();
$t2 = new Table12();
$t2->setRank(4);
$t2->setScopeValue(1);
$t2->setTitle('row4');
$t2->save();
$t3 = new Table12();
$t3->setRank(2);
$t3->setScopeValue(1);
$t3->setTitle('row2');
$t3->save();
$t4 = new Table12();
$t4->setRank(1);
$t4->setScopeValue(2);
$t4->setTitle('row5');
$t4->save();
$t5 = new Table12();
$t5->setRank(3);
$t5->setScopeValue(1);
$t5->setTitle('row3');
$t5->save();
$t6 = new Table12();
$t6->setRank(2);
$t6->setScopeValue(2);
$t6->setTitle('row6');
$t6->save();
$t7 = new Table12();
$t7->setRank(1);
$t7->setTitle('row7');
$t7->save();
$t8 = new Table12();
$t8->setRank(2);
$t8->setTitle('row8');
$t8->save();
$t9 = new Table12();
$t9->setRank(3);
$t9->setTitle('row9');
$t9->save();
$t10 = new Table12();
$t10->setRank(4);
$t10->setTitle('row10');
$t10->save();
}
protected function getFixturesArray()
{
$c = new Criteria();
$c->addAscendingOrderByColumn(Table11Peer::RANK_COL);
$ts = Table11Peer::doSelect($c);
$ret = array();
foreach ($ts as $t) {
$ret[$t->getRank()] = $t->getTitle();
}
return $ret;
}
protected function getFixturesArrayWithScope($scope = null)
{
$c = new Criteria();
$c->add(Table12Peer::SCOPE_COL, $scope);
$c->addAscendingOrderByColumn(Table12Peer::RANK_COL);
$ts = Table12Peer::doSelect($c);
$ret = array();
foreach ($ts as $t) {
$ret[$t->getRank()] = $t->getTitle();
}
return $ret;
}
}