@@ -8,6 +8,11 @@ discard block |
||
8 | 8 | use PhpBoot\DB\Context; |
9 | 9 | |
10 | 10 | class ExecResult{ |
11 | + |
|
12 | + /** |
|
13 | + * @param \PDO $pdo |
|
14 | + * @param \PDOStatement $st |
|
15 | + */ |
|
11 | 16 | public function __construct($success, $pdo, $st){ |
12 | 17 | $this->pdo = $pdo; |
13 | 18 | $this->st = $st; |
@@ -41,6 +46,10 @@ discard block |
||
41 | 46 | |
42 | 47 | class SelectImpl |
43 | 48 | { |
49 | + /** |
|
50 | + * @param Context $context |
|
51 | + * @param string $columns |
|
52 | + */ |
|
44 | 53 | static public function select($context, $columns){ |
45 | 54 | $context->appendSql("SELECT $columns"); |
46 | 55 | } |
@@ -48,6 +57,10 @@ discard block |
||
48 | 57 | |
49 | 58 | class FromImpl |
50 | 59 | { |
60 | + /** |
|
61 | + * @param Context $context |
|
62 | + * @param string $tables |
|
63 | + */ |
|
51 | 64 | static public function from($context, $tables,$as=null){ |
52 | 65 | if($tables instanceof BasicRule){ |
53 | 66 | $context->appendSql("FROM (".$tables->context->sql.')'); |
@@ -63,6 +76,10 @@ discard block |
||
63 | 76 | |
64 | 77 | class DeleteImpl |
65 | 78 | { |
79 | + /** |
|
80 | + * @param Context $context |
|
81 | + * @param string $from |
|
82 | + */ |
|
66 | 83 | static public function deleteFrom($context, $from) |
67 | 84 | { |
68 | 85 | $context->appendSql("DELETE FROM ".DB::wrap($from)); |
@@ -71,6 +88,11 @@ discard block |
||
71 | 88 | |
72 | 89 | class JoinImpl |
73 | 90 | { |
91 | + /** |
|
92 | + * @param Context $context |
|
93 | + * @param null|string $type |
|
94 | + * @param string $table |
|
95 | + */ |
|
74 | 96 | static public function join($context, $type, $table) { |
75 | 97 | $table = DB::wrap($table); |
76 | 98 | if($type){ |
@@ -83,6 +105,10 @@ discard block |
||
83 | 105 | |
84 | 106 | class JoinOnImpl |
85 | 107 | { |
108 | + /** |
|
109 | + * @param Context $context |
|
110 | + * @param string $condition |
|
111 | + */ |
|
86 | 112 | static public function on($context, $condition) { |
87 | 113 | $context->appendSql("ON $condition"); |
88 | 114 | } |
@@ -90,6 +116,9 @@ discard block |
||
90 | 116 | |
91 | 117 | class ForUpdateImpl |
92 | 118 | { |
119 | + /** |
|
120 | + * @param Context $context |
|
121 | + */ |
|
93 | 122 | static public function forUpdate($context){ |
94 | 123 | $context->appendSql("FOR UPDATE"); |
95 | 124 | } |
@@ -97,6 +126,10 @@ discard block |
||
97 | 126 | |
98 | 127 | class ForUpdateOfImpl |
99 | 128 | { |
129 | + /** |
|
130 | + * @param Context $context |
|
131 | + * @param string $column |
|
132 | + */ |
|
100 | 133 | static public function of($context, $column){ |
101 | 134 | $column = DB::wrap($column); |
102 | 135 | $context->appendSql("OF $column"); |
@@ -105,6 +138,10 @@ discard block |
||
105 | 138 | |
106 | 139 | class InsertImpl |
107 | 140 | { |
141 | + /** |
|
142 | + * @param Context $context |
|
143 | + * @param string $table |
|
144 | + */ |
|
108 | 145 | static public function insertInto($context, $table) { |
109 | 146 | $table = DB::wrap($table); |
110 | 147 | $context->appendSql("INSERT INTO $table"); |
@@ -112,6 +149,10 @@ discard block |
||
112 | 149 | } |
113 | 150 | class ReplaceImpl |
114 | 151 | { |
152 | + /** |
|
153 | + * @param Context $context |
|
154 | + * @param string $table |
|
155 | + */ |
|
115 | 156 | static public function replaceInto($context, $table) { |
116 | 157 | $table = DB::wrap($table); |
117 | 158 | $context->appendSql("REPLACE INTO $table"); |
@@ -119,6 +160,9 @@ discard block |
||
119 | 160 | } |
120 | 161 | class ValuesImpl |
121 | 162 | { |
163 | + /** |
|
164 | + * @param Context $context |
|
165 | + */ |
|
122 | 166 | static public function values($context, $values){ |
123 | 167 | $params = []; |
124 | 168 | $stubs = []; |
@@ -148,6 +192,10 @@ discard block |
||
148 | 192 | |
149 | 193 | class UpdateImpl |
150 | 194 | { |
195 | + /** |
|
196 | + * @param Context $context |
|
197 | + * @param string $table |
|
198 | + */ |
|
151 | 199 | static public function update($context, $table){ |
152 | 200 | $table = DB::wrap($table); |
153 | 201 | $context->appendSql("UPDATE $table"); |
@@ -164,6 +212,9 @@ discard block |
||
164 | 212 | } |
165 | 213 | } |
166 | 214 | |
215 | + /** |
|
216 | + * @param string $expr |
|
217 | + */ |
|
167 | 218 | public function setExpr(Context $context, $expr, $args){ |
168 | 219 | if($this->first){ |
169 | 220 | $this->first = false; |
@@ -226,6 +277,11 @@ discard block |
||
226 | 277 | } |
227 | 278 | return $this; |
228 | 279 | } |
280 | + |
|
281 | + /** |
|
282 | + * @param string $column |
|
283 | + * @param string $order |
|
284 | + */ |
|
229 | 285 | public function orderBy(Context $context, $column, $order=null){ |
230 | 286 | if(is_string($column)){ |
231 | 287 | if($order === null){ |
@@ -243,12 +299,20 @@ discard block |
||
243 | 299 | |
244 | 300 | class LimitImpl |
245 | 301 | { |
302 | + /** |
|
303 | + * @param integer $size |
|
304 | + */ |
|
246 | 305 | static public function limit(Context $context, $size){ |
247 | 306 | $intSize = intval($size); |
248 | 307 | strval($intSize) == $size or \PhpBoot\abort( |
249 | 308 | new \InvalidArgumentException("invalid params for limit($size)")); |
250 | 309 | $context->appendSql("LIMIT $size"); |
251 | 310 | } |
311 | + |
|
312 | + /** |
|
313 | + * @param integer $start |
|
314 | + * @param integer $size |
|
315 | + */ |
|
252 | 316 | static public function limitWithOffset(Context $context, $start, $size){ |
253 | 317 | $intStart = intval($start); |
254 | 318 | $intSize = intval($size); |
@@ -260,6 +324,9 @@ discard block |
||
260 | 324 | |
261 | 325 | class WhereImpl{ |
262 | 326 | |
327 | + /** |
|
328 | + * @param string $str |
|
329 | + */ |
|
263 | 330 | static private function findQ($str,$offset = 0,$no=0){ |
264 | 331 | $found = strpos($str, '?', $offset); |
265 | 332 | if($no == 0 || $found === false){ |
@@ -307,6 +374,7 @@ discard block |
||
307 | 374 | * LIKE 'id'=>['LIKE' => '1%'] |
308 | 375 | * IN 'id'=>['IN' => [1,2,3]] |
309 | 376 | * NOT IN 'id'=>['NOT IN' => [1,2,3]] |
377 | + * @param string $prefix |
|
310 | 378 | * @return void |
311 | 379 | */ |
312 | 380 | static public function conditionArgs(Context $context, $prefix, $args=[]){ |
@@ -374,6 +442,10 @@ discard block |
||
374 | 442 | |
375 | 443 | self::condition($context, $prefix, implode(' AND ', $exprs), $params); |
376 | 444 | } |
445 | + |
|
446 | + /** |
|
447 | + * @param string $expr |
|
448 | + */ |
|
377 | 449 | static public function condition(Context $context, $prefix, $expr, $args){ |
378 | 450 | if(!empty($expr)){ |
379 | 451 | if($args){ |
@@ -436,6 +508,10 @@ discard block |
||
436 | 508 | } |
437 | 509 | |
438 | 510 | class GroupByImpl{ |
511 | + |
|
512 | + /** |
|
513 | + * @param string $column |
|
514 | + */ |
|
439 | 515 | static public function groupBy(Context $context, $column){ |
440 | 516 | $column = DB::wrap($column); |
441 | 517 | $context->appendSql("GROUP BY $column"); |
@@ -458,7 +534,6 @@ discard block |
||
458 | 534 | /** |
459 | 535 | * |
460 | 536 | * @param Context $context |
461 | - * @param string|false $asDict return as dict or array |
|
462 | 537 | * @return false|array |
463 | 538 | */ |
464 | 539 | static public function get($context, $dictAs=false){ |
@@ -517,6 +592,9 @@ discard block |
||
517 | 592 | } |
518 | 593 | class OnDuplicateKeyUpdateImpl |
519 | 594 | { |
595 | + /** |
|
596 | + * @param Context $context |
|
597 | + */ |
|
520 | 598 | public function set($context, $column, $value){ |
521 | 599 | if(is_string($column)){ |
522 | 600 | $this->setExpr($context, $column, $value); |
@@ -525,6 +603,9 @@ discard block |
||
525 | 603 | } |
526 | 604 | } |
527 | 605 | |
606 | + /** |
|
607 | + * @param string $expr |
|
608 | + */ |
|
528 | 609 | public function setExpr($context, $expr, $args){ |
529 | 610 | $prefix = ''; |
530 | 611 | if($this->first){ |
@@ -52,7 +52,7 @@ discard block |
||
52 | 52 | if($tables instanceof BasicRule){ |
53 | 53 | $context->appendSql("FROM (".$tables->context->sql.')'); |
54 | 54 | $context->params = array_merge($context->params,$tables->context->params); |
55 | - }else { |
|
55 | + } else { |
|
56 | 56 | $context->appendSql("FROM ".DB::wrap($tables)); |
57 | 57 | } |
58 | 58 | if($as){ |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | $table = DB::wrap($table); |
76 | 76 | if($type){ |
77 | 77 | $context->appendSql("$type JOIN $table"); |
78 | - }else{ |
|
78 | + } else{ |
|
79 | 79 | $context->appendSql("JOIN $table"); |
80 | 80 | } |
81 | 81 | } |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | foreach ($values as $v){ |
126 | 126 | if(is_a($v, Raw::class)){//直接拼接sql,不需要转义 |
127 | 127 | $stubs[]=$v->get(); |
128 | - }else{ |
|
128 | + } else{ |
|
129 | 129 | $stubs[]='?'; |
130 | 130 | $params[] = $v; |
131 | 131 | } |
@@ -136,7 +136,7 @@ discard block |
||
136 | 136 | //VALUES(val0, val1, val2) |
137 | 137 | $context->appendSql("VALUES($stubs)"); |
138 | 138 | |
139 | - }else{ |
|
139 | + } else{ |
|
140 | 140 | //(col0, col1, col2) VALUES(val0, val1, val2) |
141 | 141 | $columns = implode(',', array_map(function($k){return DB::wrap($k);}, array_keys($values))); |
142 | 142 | $context->appendSql("($columns) VALUES($stubs)",false); |
@@ -159,7 +159,7 @@ discard block |
||
159 | 159 | public function set(Context $context, $expr, $args){ |
160 | 160 | if(is_string($expr)){ |
161 | 161 | return $this->setExpr($context, $expr, $args); |
162 | - }else{ |
|
162 | + } else{ |
|
163 | 163 | return $this->setArgs($context, $expr); |
164 | 164 | } |
165 | 165 | } |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | if($this->first){ |
169 | 169 | $this->first = false; |
170 | 170 | $prefix = 'SET '; |
171 | - }else{ |
|
171 | + } else{ |
|
172 | 172 | $prefix = ','; |
173 | 173 | } |
174 | 174 | |
@@ -183,7 +183,7 @@ discard block |
||
183 | 183 | $k = DB::wrap($k); |
184 | 184 | if(is_a($v, Raw::class)){//直接拼接sql,不需要转义 |
185 | 185 | $set[]= "$k=".$v->get(); |
186 | - }else{ |
|
186 | + } else{ |
|
187 | 187 | $set[]= "$k=?"; |
188 | 188 | $params[]=$v; |
189 | 189 | } |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | $this->first = false; |
193 | 193 | $context->appendSql('SET '.implode(',', $set)); |
194 | 194 | $context->appendParams($params); |
195 | - }else{ |
|
195 | + } else{ |
|
196 | 196 | $context->appendSql(','.implode(',', $set),false); |
197 | 197 | $context->appendParams($params); |
198 | 198 | } |
@@ -209,7 +209,7 @@ discard block |
||
209 | 209 | foreach ($orders as $k=>$v){ |
210 | 210 | if(is_integer($k)){ |
211 | 211 | $params[] = DB::wrap($v); |
212 | - }else{ |
|
212 | + } else{ |
|
213 | 213 | $k = DB::wrap($k); |
214 | 214 | |
215 | 215 | $v = strtoupper($v); |
@@ -221,7 +221,7 @@ discard block |
||
221 | 221 | if($this->first){ |
222 | 222 | $this->first = false; |
223 | 223 | $context->appendSql('ORDER BY '.implode(',', $params)); |
224 | - }else{ |
|
224 | + } else{ |
|
225 | 225 | $context->appendSql(','.implode(',', $params),false); |
226 | 226 | } |
227 | 227 | return $this; |
@@ -230,7 +230,7 @@ discard block |
||
230 | 230 | if(is_string($column)){ |
231 | 231 | if($order === null){ |
232 | 232 | $column = [$column]; |
233 | - }else{ |
|
233 | + } else{ |
|
234 | 234 | $column = [$column=>$order]; |
235 | 235 | } |
236 | 236 | } |
@@ -270,7 +270,7 @@ discard block |
||
270 | 270 | static public function having(Context $context, $expr, $args){ |
271 | 271 | if(is_string($expr)){ |
272 | 272 | self::condition($context, 'HAVING', $expr, $args); |
273 | - }else{ |
|
273 | + } else{ |
|
274 | 274 | self::conditionArgs($context, 'HAVING', $expr); |
275 | 275 | } |
276 | 276 | //TODO 支持 OR 、 闭包 |
@@ -282,7 +282,7 @@ discard block |
||
282 | 282 | } |
283 | 283 | if (is_string($expr)){ |
284 | 284 | self::condition($context, 'WHERE', $expr, $args); |
285 | - }else{ |
|
285 | + } else{ |
|
286 | 286 | self::conditionArgs($context, 'WHERE', $expr); |
287 | 287 | } |
288 | 288 | //TODO 支持 OR 、 闭包 |
@@ -331,41 +331,41 @@ discard block |
||
331 | 331 | foreach ($var as $i){ |
332 | 332 | if(is_a($i, Raw::class)){ |
333 | 333 | $stubs[]=strval($i); |
334 | - }else{ |
|
334 | + } else{ |
|
335 | 335 | $stubs[]='?'; |
336 | 336 | $params[] = $i; |
337 | 337 | } |
338 | 338 | } |
339 | 339 | $stubs = implode(',', $stubs); |
340 | 340 | $exprs[] = "$k $op ($stubs)"; |
341 | - }else if($op == 'BETWEEN'){ |
|
341 | + } else if($op == 'BETWEEN'){ |
|
342 | 342 | $cond = "$k BETWEEN"; |
343 | 343 | if(is_a($var[0], Raw::class)){ |
344 | 344 | $cond = "$cond ".strval($var[0]); |
345 | - }else{ |
|
345 | + } else{ |
|
346 | 346 | $cond = "$cond ?"; |
347 | 347 | $params[] = $var[0]; |
348 | 348 | } |
349 | 349 | if(is_a($var[1], Raw::class)){ |
350 | 350 | $cond = "$cond AND ".strval($var[1]); |
351 | - }else{ |
|
351 | + } else{ |
|
352 | 352 | $cond = "$cond AND ?"; |
353 | 353 | $params[] = $var[1]; |
354 | 354 | } |
355 | 355 | $exprs[] = $cond; |
356 | - }else{ |
|
356 | + } else{ |
|
357 | 357 | if(is_a($var, Raw::class)){ |
358 | 358 | $exprs[] = "$k $op ".strval($var); |
359 | - }else{ |
|
359 | + } else{ |
|
360 | 360 | $exprs[] = "$k $op ?"; |
361 | 361 | $params[] = $var; |
362 | 362 | } |
363 | 363 | } |
364 | - }else{ |
|
364 | + } else{ |
|
365 | 365 | if(is_a($v, Raw::class)){ |
366 | 366 | $exprs[] = "$k = ".strval($v); |
367 | 367 | |
368 | - }else{ |
|
368 | + } else{ |
|
369 | 369 | $exprs[] = "$k = ?"; |
370 | 370 | $params[] = $v; |
371 | 371 | } |
@@ -402,18 +402,18 @@ discard block |
||
402 | 402 | foreach ($arg as $i){ |
403 | 403 | if(is_a($i, Raw::class)){ |
404 | 404 | $stubs[] = strval($i); |
405 | - }else{ |
|
405 | + } else{ |
|
406 | 406 | $stubs[] = '?'; |
407 | 407 | $newArgs[] = $i; |
408 | 408 | } |
409 | 409 | } |
410 | 410 | $stubs = implode(',', $stubs); |
411 | - }else{ |
|
411 | + } else{ |
|
412 | 412 | $stubs = strval($arg); |
413 | 413 | } |
414 | 414 | $toReplace[] = [$pos, $stubs]; |
415 | 415 | |
416 | - }else{ |
|
416 | + } else{ |
|
417 | 417 | $newArgs[]=$arg; |
418 | 418 | } |
419 | 419 | } |
@@ -474,7 +474,7 @@ discard block |
||
474 | 474 | return $context->handleResult($dict); |
475 | 475 | } |
476 | 476 | return $context->handleResult($res); |
477 | - }else{ |
|
477 | + } else{ |
|
478 | 478 | return false; |
479 | 479 | } |
480 | 480 | } |
@@ -498,7 +498,7 @@ discard block |
||
498 | 498 | if(!preg_match('/\bfrom\b/i', $context->sql, $found, PREG_OFFSET_CAPTURE) || |
499 | 499 | count($found)==0){ |
500 | 500 | $columnEnd = strlen($context->sql); |
501 | - }else{ |
|
501 | + } else{ |
|
502 | 502 | list($chars, $columnEnd) = $found[0]; |
503 | 503 | } |
504 | 504 | $sql = substr($context->sql, 0, $columnBegin); |
@@ -509,7 +509,7 @@ discard block |
||
509 | 509 | if($st->execute($context->params)){ |
510 | 510 | $res = $st->fetchAll(\PDO::FETCH_ASSOC); |
511 | 511 | return $res[0]['count']; |
512 | - }else{ |
|
512 | + } else{ |
|
513 | 513 | return false; |
514 | 514 | } |
515 | 515 | |
@@ -520,7 +520,7 @@ discard block |
||
520 | 520 | public function set($context, $column, $value){ |
521 | 521 | if(is_string($column)){ |
522 | 522 | $this->setExpr($context, $column, $value); |
523 | - }else{ |
|
523 | + } else{ |
|
524 | 524 | $this->setArgs($context, $column); |
525 | 525 | } |
526 | 526 | } |
@@ -530,7 +530,7 @@ discard block |
||
530 | 530 | if($this->first){ |
531 | 531 | $this->first = false; |
532 | 532 | $prefix = 'ON DUPLICATE KEY UPDATE '; |
533 | - }else{ |
|
533 | + } else{ |
|
534 | 534 | $prefix = ','; |
535 | 535 | } |
536 | 536 | |
@@ -545,7 +545,7 @@ discard block |
||
545 | 545 | $k = DB::wrap($k); |
546 | 546 | if(is_a($v, Raw::class)){//直接拼接sql,不需要转义 |
547 | 547 | $set[]= "$k=".$v->get(); |
548 | - }else{ |
|
548 | + } else{ |
|
549 | 549 | $set[]= "$k=?"; |
550 | 550 | $params[]=$v; |
551 | 551 | } |
@@ -554,7 +554,7 @@ discard block |
||
554 | 554 | $this->first = false; |
555 | 555 | $context->appendSql('ON DUPLICATE KEY UPDATE '.implode(',', $set)); |
556 | 556 | $context->appendParams($params); |
557 | - }else{ |
|
557 | + } else{ |
|
558 | 558 | $context->appendSql(','.implode(',', $set),false); |
559 | 559 | $context->appendParams($params); |
560 | 560 | } |
@@ -41,6 +41,9 @@ discard block |
||
41 | 41 | |
42 | 42 | class OnDuplicateKeyUpdateRule extends ExecRule |
43 | 43 | { |
44 | + /** |
|
45 | + * @param \PhpBoot\DB\Context $context |
|
46 | + */ |
|
44 | 47 | public function __construct($context) |
45 | 48 | { |
46 | 49 | parent::__construct($context); |
@@ -91,8 +94,6 @@ discard block |
||
91 | 94 | * ->onDuplicateKeyUpdate('a=a+1') |
92 | 95 | * => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1" |
93 | 96 | * |
94 | - * @param string $column |
|
95 | - * @param mixed $value |
|
96 | 97 | * @return \PhpBoot\DB\rules\basic\ExecRule |
97 | 98 | */ |
98 | 99 | public function onDuplicateKeyUpdate($expr, $_=null) { |
@@ -111,6 +111,9 @@ discard block |
||
111 | 111 | |
112 | 112 | class OrderByRule extends LimitRule |
113 | 113 | { |
114 | + /** |
|
115 | + * @param \PhpBoot\DB\Context $context |
|
116 | + */ |
|
114 | 117 | public function __construct($context){ |
115 | 118 | parent::__construct($context); |
116 | 119 | $this->order = new OrderByImpl(); |
@@ -211,7 +214,7 @@ discard block |
||
211 | 214 | * "WHERE a=1 AND b IN(1,2) AND c BETWEEN 1 AND 2 AND d<>1" |
212 | 215 | * @param string|array $conditions |
213 | 216 | * //TODO where(callable $query) |
214 | - * @param mixed $_ |
|
217 | + * @param string $_ |
|
215 | 218 | * @return \PhpBoot\DB\rules\select\GroupByRule |
216 | 219 | */ |
217 | 220 | public function where($conditions=null, $_=null) { |
@@ -49,7 +49,6 @@ |
||
49 | 49 | |
50 | 50 | /** |
51 | 51 | * where 语法见 @see WhereRule |
52 | - * @param array|string $expr |
|
53 | 52 | * @param mixed|null $_ |
54 | 53 | * @return \PhpBoot\DB\rules\basic\OrderByRule |
55 | 54 | */ |