FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
php-sql-query-builder/tests/Manipulation/SelectTest.php at master · roelfsche/php-sql-query-builder · GitHub
roelfsche
/
php-sql-query-builder
Public
forked from
nilportugues/php-sql-query-builder
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
php-sql-query-builder
/
tests
/
Manipulation
/
SelectTest.php
Copy path
More file actions
More file actions
Latest commit
History
History
History
101 lines (94 loc) · 2.83 KB
Breadcrumbs
php-sql-query-builder
/
tests
/
Manipulation
/
SelectTest.php
Copy path
File metadata and controls
101 lines (94 loc) · 2.83 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
<?php
/**
* Author: Nil Portugués Calderó <contact@nilportugues.com>
* Date: 6/3/14
* Time: 1:36 AM.
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
namespace
NilPortugues
\
Tests
\
Sql
\
QueryBuilder
\
Manipulation
;
use
NilPortugues
\
Sql
\
QueryBuilder
\
Manipulation
\
Select
;
use
NilPortugues
\
Sql
\
QueryBuilder
\
Syntax
\
OrderBy
;
/**
* Class SelectTest.
*/
class
SelectTest
extends
\PHPUnit_Framework_TestCase
{
/**
* @var Select
*/
private
$
query
;
/**
*
*/
protected
function
setUp
()
{
$
this
->
query
=
new
Select
();
}
/**
* @test
*/
public
function
itShouldGetPartName
()
{
$
this
->
assertSame
(
'
SELECT
'
,
$
this
->
query
->
partName
());
}
/**
* @test
*/
public
function
itShouldSetParentOrderByAlso
()
{
$
columns
= [
'
id
'
,
'
phase_id
'
,
'
league_id
'
,
'
date
'
,
];
$
parentTable
=
'
events
'
;
$
this
->
query
->
setTable
(
$
parentTable
);
$
this
->
query
->
setColumns
(
$
columns
);
$
sorts
= [
[
'
field
'
=>
'
league_id
'
,
'
direction
'
=>
1
,
],
[
'
field
'
=>
'
start_date
'
,
'
direction
'
=>
0
,
'
table
'
=>
'
phases
'
,
'
joinBy
'
=>
'
phase_id
'
,
'
joinWith
'
=>
'
id
'
,
],
[
'
field
'
=>
'
date
'
,
'
direction
'
=>
1
,
],
];
if
(
is_array
(
$
sorts
)) {
foreach
(
$
sorts
as
$
sort
) {
$
order
= (
int
)
$
sort
[
'
direction
'
] >
0
? OrderBy::
ASC
: OrderBy::
DESC
;
if
(
count
(
$
sort
) ==
5
) {
$
this
->
query
->
leftJoin
(
$
sort
[
'
table
'
],
$
sort
[
'
joinBy
'
],
$
sort
[
'
joinWith
'
]
)->
orderBy
(
$
sort
[
'
field
'
],
$
order
);
}
else
{
$
this
->
query
->
orderBy
(
$
sort
[
'
field
'
],
$
order
);
}
}
}
$
returnedOrders
=
$
this
->
query
->
getAllOrderBy
();
foreach
(
$
returnedOrders
as
$
id
=>
$
orderByObject
) {
$
column
=
$
orderByObject
->
getColumn
();
$
table
=
$
column
->
getTable
();
$
expectedColumn
=
$
sorts
[
$
id
][
'
field
'
];
$
expectedTable
=
array_key_exists
(
'
table
'
,
$
sorts
[
$
id
]) ?
$
sorts
[
$
id
][
'
table
'
] :
$
parentTable
;
$
expectedDirection
= (
int
)
$
sorts
[
$
id
][
'
direction
'
] >
0
? OrderBy::
ASC
: OrderBy::
DESC
;
$
this
->
assertSame
(
$
expectedColumn
,
$
column
->
getName
());
$
this
->
assertSame
(
$
expectedTable
,
$
table
->
getName
());
$
this
->
assertSame
(
$
expectedDirection
,
$
orderByObject
->
getDirection
());
}
$
this
->
assertCount
(
count
(
$
sorts
),
$
returnedOrders
);
}
}
Back
|
FazBrowse Home
|
New Git URL