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
|
<?php
Prado::using('System.Data.DataGateway.TSqlCriteria');
/**
* @package System.Data.DataGateway
*/
class TSqlCriteriaTest extends PHPUnit_Framework_TestCase {
public function setUp() {
}
public function tearDown() {
}
public function testConstruct() {
throw new PHPUnit_Framework_IncompleteTestError();
}
public function testConditionWithOrderByColumnNames() {
$criteria = new TSqlCriteria();
$criteria->Condition = "SELECT * FROM table_references ORDER BY field1 ASC, field2 DESC";
self::assertEquals("SELECT * FROM table_references", $criteria->Condition);
self::assertEquals(true, isset($criteria->OrdersBy['field1']));
self::assertEquals('ASC', $criteria->OrdersBy['field1']);
self::assertEquals(true, isset($criteria->OrdersBy['field2']));
self::assertEquals('DESC', $criteria->OrdersBy['field2']);
}
public function testConditionWithOrderByExpression() {
$criteria = new TSqlCriteria();
$criteria->Condition = "SELECT * FROM table_references ORDER BY RAND()";
self::assertEquals("SELECT * FROM table_references", $criteria->Condition);
self::assertEquals(true, isset($criteria->OrdersBy['RAND()']));
self::assertEquals('asc', $criteria->OrdersBy['RAND()']);
}
public function testConditionWithOrderByAndLimit() {
$criteria = new TSqlCriteria();
$criteria->Condition = "SELECT * FROM table_references ORDER BY field1 ASC, field2 DESC LIMIT 2";
self::assertEquals("SELECT * FROM table_references", $criteria->Condition);
self::assertEquals(2, $criteria->Limit);
}
public function testConditionWithOrderByAndLimitAndOffset() {
$criteria = new TSqlCriteria();
$criteria->Condition = "SELECT * FROM table_references ORDER BY field1 ASC, field2 DESC LIMIT 3, 2";
self::assertEquals("SELECT * FROM table_references", $criteria->Condition);
self::assertEquals(2, $criteria->Limit);
self::assertEquals(3, $criteria->Offset);
}
public function testConditionWithOrderByAndLimitAndOffsetVariant() {
$criteria = new TSqlCriteria();
$criteria->Condition = "SELECT * FROM table_references ORDER BY field1 ASC, field2 DESC LIMIT 2 OFFSET 3";
self::assertEquals("SELECT * FROM table_references", $criteria->Condition);
self::assertEquals(2, $criteria->Limit);
self::assertEquals(3, $criteria->Offset);
}
public function testConditionWithLimit() {
$criteria = new TSqlCriteria();
$criteria->Condition = "SELECT * FROM table_references LIMIT 2";
self::assertEquals("SELECT * FROM table_references", $criteria->Condition);
self::assertEquals(2, $criteria->Limit);
}
public function testConditionWithLimitAndOffset() {
$criteria = new TSqlCriteria();
$criteria->Condition = "SELECT * FROM table_references LIMIT 3, 2";
self::assertEquals("SELECT * FROM table_references", $criteria->Condition);
self::assertEquals(2, $criteria->Limit);
self::assertEquals(3, $criteria->Offset);
}
public function testConditionWithLimitAndOffsetVariant() {
$criteria = new TSqlCriteria();
$criteria->Condition = "SELECT * FROM table_references LIMIT 2 OFFSET 3";
self::assertEquals("SELECT * FROM table_references", $criteria->Condition);
self::assertEquals(2, $criteria->Limit);
self::assertEquals(3, $criteria->Offset);
}
public function testParameters() {
throw new PHPUnit_Framework_IncompleteTestError();
}
public function testIsNamedParameters() {
throw new PHPUnit_Framework_IncompleteTestError();
}
public function testOrdersBy() {
throw new PHPUnit_Framework_IncompleteTestError();
}
public function testLimit() {
throw new PHPUnit_Framework_IncompleteTestError();
}
public function testOffset() {
throw new PHPUnit_Framework_IncompleteTestError();
}
public function testToString() {
throw new PHPUnit_Framework_IncompleteTestError();
}
}
?>
|
