FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
database/SqlserverCompiler.php at 5.x · cakephp/database · GitHub
cakephp
/
database
Public
Notifications
You must be signed in to change notification settings
Fork
13
Star
98
Code
Actions
Security and quality
0
Insights
Additional navigation options
Code
Actions
Security and quality
Insights
Expand file tree
Breadcrumbs
database
/
SqlserverCompiler.php
Copy path
More file actions
More file actions
Latest commit
History
History
History
165 lines (150 loc) · 5.38 KB
Breadcrumbs
database
/
SqlserverCompiler.php
Copy path
File metadata and controls
165 lines (150 loc) · 5.38 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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
<?php
declare
(strict_types=
1
);
/**
* CakePHP(tm) : Rapid Development Framework (https://cakephp.org)
* Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
*
* Licensed under The MIT License
* For full copyright and license information, please see the LICENSE.txt
* Redistributions of files must retain the above copyright notice.
*
* @copyright Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
* @link https://cakephp.org CakePHP(tm) Project
* @since 3.0.0
* @license https://opensource.org/licenses/mit-license.php MIT License
*/
namespace
Cake
\
Database
;
use
Cake
\
Database
\
Exception
\
DatabaseException
;
use
Cake
\
Database
\
Expression
\
FunctionExpression
;
/**
* Responsible for compiling a Query object into its SQL representation
* for SQL Server
*
* @internal
*/
class
SqlserverCompiler
extends
QueryCompiler
{
/**
* {@inheritDoc}
*
* @var array<string, string>
*/
protected
array
$
_templates
= [
'
delete
'
=>
'
DELETE
'
,
'
where
'
=>
'
WHERE %s
'
,
'
group
'
=>
'
GROUP BY %s
'
,
'
order
'
=>
'
%s
'
,
'
offset
'
=>
'
OFFSET %s ROWS
'
,
'
epilog
'
=>
'
%s
'
,
'
comment
'
=>
'
/* %s */
'
,
];
/**
* {@inheritDoc}
*
* @var array<string>
*/
protected
array
$
_selectParts
= [
'
comment
'
,
'
with
'
,
'
select
'
,
'
from
'
,
'
join
'
,
'
where
'
,
'
group
'
,
'
having
'
,
'
window
'
,
'
order
'
,
'
offset
'
,
'
limit
'
,
'
union
'
,
'
except
'
,
'
epilog
'
,
'
intersect
'
,
];
/**
* Helper function used to build the string representation of a `WITH` clause,
* it constructs the CTE definitions list without generating the `RECURSIVE`
* keyword that is neither required nor valid.
*
* @param array<\Cake\Database\Expression\CommonTableExpression> $parts List of CTEs to be transformed to string
* @param \Cake\Database\Query $query The query that is being compiled
* @param \Cake\Database\ValueBinder $binder Value binder used to generate parameter placeholder
* @return string
*/
protected
function
_buildWithPart
(
array
$
parts
,
Query
$
query
,
ValueBinder
$
binder
):
string
{
$
expressions
= [];
foreach
(
$
parts
as
$
cte
) {
$
expressions
[] =
$
cte
->
sql
(
$
binder
);
}
return
sprintf
(
'
WITH %s
'
,
implode
(
'
,
'
,
$
expressions
));
}
/**
* Generates the INSERT part of a SQL query
*
* To better handle concurrency and low transaction isolation levels,
* we also include an OUTPUT clause so we can ensure we get the inserted
* row's data back.
*
* @param array $parts The parts to build
* @param \Cake\Database\Query $query The query that is being compiled
* @param \Cake\Database\ValueBinder $binder Value binder used to generate parameter placeholder
* @return string
*/
protected
function
_buildInsertPart
(
array
$
parts
,
Query
$
query
,
ValueBinder
$
binder
):
string
{
if
(!
isset
(
$
parts
[
0
])) {
throw
new
DatabaseException
(
'
Could not compile insert query. No table was specified.
'
.
'
Use `into()` to define a table.
'
,
);
}
$
table
=
$
parts
[
0
];
$
columns
=
$
this
->
_stringifyExpressions
(
$
parts
[
1
],
$
binder
);
$
modifiers
=
$
this
->
_buildModifierPart
(
$
query
->
clause
(
'
modifier
'
),
$
query
,
$
binder
);
return
sprintf
(
'
INSERT%s INTO %s (%s) OUTPUT INSERTED.*
'
,
$
modifiers
,
$
table
,
implode
(
'
,
'
,
$
columns
),
);
}
/**
* Generates the LIMIT part of a SQL query
*
* @param int $limit the limit clause
* @param \Cake\Database\Query $query The query that is being compiled
* @return string
*/
protected
function
_buildLimitPart
(
int
$
limit
,
Query
$
query
):
string
{
if
(
$
query
->
clause
(
'
offset
'
) ===
null
) {
return
''
;
}
return
sprintf
(
'
FETCH FIRST %d ROWS ONLY
'
,
$
limit
);
}
/**
* Helper function used to build the string representation of a HAVING clause,
* it constructs the field list taking care of aliasing and
* converting expression objects to string.
*
* @param array $parts list of fields to be transformed to string
* @param \Cake\Database\Query $query The query that is being compiled
* @param \Cake\Database\ValueBinder $binder Value binder used to generate parameter placeholder
* @return string
*/
protected
function
_buildHavingPart
(
array
$
parts
,
Query
$
query
,
ValueBinder
$
binder
):
string
{
$
selectParts
=
$
query
->
clause
(
'
select
'
);
foreach
(
$
selectParts
as
$
selectKey
=>
$
selectPart
) {
if
(!
$
selectPart
instanceof
FunctionExpression) {
continue
;
}
foreach
(
$
parts
as
$
k
=>
$
p
) {
if
(!
is_string
(
$
p
)) {
continue
;
}
preg_match_all
(
'
/\b
'
.
trim
(
$
selectKey
,
'
[]
'
) .
'
\b/i
'
,
$
p
,
$
matches
,
);
if
(
empty
(
$
matches
[
0
])) {
continue
;
}
$
parts
[
$
k
] =
preg_replace
(
[
'
/\[|\]/
'
,
'
/\b
'
.
trim
(
$
selectKey
,
'
[]
'
) .
'
\b/i
'
],
[
''
,
$
selectPart
->
sql
(
$
binder
)],
$
p
,
);
}
}
return
sprintf
(
'
HAVING %s
'
,
implode
(
'
,
'
,
$
parts
));
}
}
Back
|
FazBrowse Home
|
New Git URL