yiisoft /
db
| Total Complexity | 102 |
| Total Lines | 583 |
| Duplicated Lines | 0 % |
| Changes | 0 | ||
Complex classes like DQLQueryBuilder often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use DQLQueryBuilder, and based on these observations, apply Extract Interface, too.
| 1 | <?php |
||
| 42 | abstract class DQLQueryBuilder implements DQLQueryBuilderInterface |
||
| 43 | { |
||
| 44 | protected string $separator = ' '; |
||
| 45 | |||
| 46 | /** |
||
| 47 | * @var array map of condition aliases to condition classes. For example: |
||
| 48 | * |
||
| 49 | * ```php |
||
| 50 | * return [ |
||
| 51 | * 'LIKE' => \Yiisoft\Db\Condition\LikeCondition::class, |
||
| 52 | * ]; |
||
| 53 | * ``` |
||
| 54 | * |
||
| 55 | * This property is used by {@see createConditionFromArray} method. |
||
| 56 | * See default condition classes list in {@see defaultConditionClasses()} method. |
||
| 57 | * |
||
| 58 | * In case you want to add custom conditions support, use the {@see setConditionClasses()} method. |
||
| 59 | * |
||
| 60 | * @see setConditonClasses() |
||
| 61 | * @see defaultConditionClasses() |
||
| 62 | */ |
||
| 63 | protected array $conditionClasses = []; |
||
| 64 | |||
| 65 | /** |
||
| 66 | * @psalm-var array<string, class-string<ExpressionBuilderInterface>> maps expression class to expression builder |
||
| 67 | * class. |
||
| 68 | * |
||
| 69 | * For example: |
||
| 70 | * |
||
| 71 | * ```php |
||
| 72 | * [ |
||
| 73 | * Expression::class => ExpressionBuilder::class |
||
| 74 | * ] |
||
| 75 | * ``` |
||
| 76 | * This property is mainly used by {@see buildExpression()} to build SQL expressions form expression objects. |
||
| 77 | * See default values in {@see defaultExpressionBuilders()} method. |
||
| 78 | * |
||
| 79 | * {@see setExpressionBuilders()} |
||
| 80 | * {@see defaultExpressionBuilders()} |
||
| 81 | */ |
||
| 82 | protected array $expressionBuilders = []; |
||
| 83 | |||
| 84 | public function __construct( |
||
| 85 | private QueryBuilderInterface $queryBuilder, |
||
| 86 | private QuoterInterface $quoter, |
||
| 87 | private SchemaInterface $schema |
||
| 88 | ) { |
||
| 89 | $this->expressionBuilders = $this->defaultExpressionBuilders(); |
||
| 90 | $this->conditionClasses = $this->defaultConditionClasses(); |
||
| 91 | } |
||
| 92 | |||
| 93 | public function build(QueryInterface $query, array $params = []): array |
||
| 94 | { |
||
| 95 | $query = $query->prepare($this->queryBuilder); |
||
| 96 | $params = empty($params) ? $query->getParams() : array_merge($params, $query->getParams()); |
||
| 97 | $clauses = [ |
||
| 98 | $this->buildSelect($query->getSelect(), $params, $query->getDistinct(), $query->getSelectOption()), |
||
| 99 | $this->buildFrom($query->getFrom(), $params), |
||
| 100 | $this->buildJoin($query->getJoin(), $params), |
||
| 101 | $this->buildWhere($query->getWhere(), $params), |
||
| 102 | $this->buildGroupBy($query->getGroupBy(), $params), |
||
| 103 | $this->buildHaving($query->getHaving(), $params), |
||
| 104 | ]; |
||
| 105 | $sql = implode($this->separator, array_filter($clauses)); |
||
| 106 | $sql = $this->buildOrderByAndLimit($sql, $query->getOrderBy(), $query->getLimit(), $query->getOffset()); |
||
| 107 | |||
| 108 | if (!empty($query->getOrderBy())) { |
||
| 109 | /** @psalm-var array<string, ExpressionInterface|string> */ |
||
| 110 | foreach ($query->getOrderBy() as $expression) { |
||
| 111 | if ($expression instanceof ExpressionInterface) { |
||
| 112 | $this->buildExpression($expression, $params); |
||
| 113 | } |
||
| 114 | } |
||
| 115 | } |
||
| 116 | |||
| 117 | if (!empty($query->getGroupBy())) { |
||
| 118 | /** @psalm-var array<string, ExpressionInterface|string> */ |
||
| 119 | foreach ($query->getGroupBy() as $expression) { |
||
| 120 | if ($expression instanceof ExpressionInterface) { |
||
| 121 | $this->buildExpression($expression, $params); |
||
| 122 | } |
||
| 123 | } |
||
| 124 | } |
||
| 125 | |||
| 126 | $union = $this->buildUnion($query->getUnion(), $params); |
||
| 127 | |||
| 128 | if ($union !== '') { |
||
| 129 | $sql = "($sql)$this->separator$union"; |
||
| 130 | } |
||
| 131 | |||
| 132 | $with = $this->buildWithQueries($query->getWithQueries(), $params); |
||
| 133 | |||
| 134 | if ($with !== '') { |
||
| 135 | $sql = "$with$this->separator$sql"; |
||
| 136 | } |
||
| 137 | |||
| 138 | return [$sql, $params]; |
||
| 139 | } |
||
| 140 | |||
| 141 | public function buildColumns(array|string $columns): string |
||
| 167 | } |
||
| 168 | |||
| 169 | public function buildCondition(array|string|ExpressionInterface|null $condition, array &$params = []): string |
||
| 170 | { |
||
| 171 | if (is_array($condition)) { |
||
| 172 | if (empty($condition)) { |
||
| 173 | return ''; |
||
| 174 | } |
||
| 175 | |||
| 176 | $condition = $this->createConditionFromArray($condition); |
||
| 177 | } |
||
| 178 | |||
| 179 | if ($condition instanceof ExpressionInterface) { |
||
| 180 | return $this->buildExpression($condition, $params); |
||
| 181 | } |
||
| 182 | |||
| 183 | return $condition ?? ''; |
||
| 184 | } |
||
| 185 | |||
| 186 | /** |
||
| 187 | * @throws InvalidArgumentException |
||
| 188 | * |
||
| 189 | * @psalm-suppress UndefinedInterfaceMethod |
||
| 190 | * @psalm-suppress MixedMethodCall |
||
| 191 | */ |
||
| 192 | public function buildExpression(ExpressionInterface $expression, array &$params = []): string |
||
| 193 | { |
||
| 194 | $builder = $this->queryBuilder->getExpressionBuilder($expression); |
||
| 195 | return (string) $builder->build($expression, $params); |
||
| 196 | } |
||
| 197 | |||
| 198 | public function buildFrom(?array $tables, array &$params): string |
||
| 199 | { |
||
| 200 | if (empty($tables)) { |
||
| 201 | return ''; |
||
| 202 | } |
||
| 203 | |||
| 204 | /** @psalm-var string[] */ |
||
| 205 | $tables = $this->quoteTableNames($tables, $params); |
||
| 206 | |||
| 207 | return 'FROM ' . implode(', ', $tables); |
||
| 208 | } |
||
| 209 | |||
| 210 | public function buildGroupBy(array $columns, array &$params = []): string |
||
| 211 | { |
||
| 212 | if (empty($columns)) { |
||
| 213 | return ''; |
||
| 214 | } |
||
| 215 | |||
| 216 | /** @psalm-var array<string, Expression|string> $columns */ |
||
| 217 | foreach ($columns as $i => $column) { |
||
| 218 | if ($column instanceof Expression) { |
||
| 219 | $columns[$i] = $this->buildExpression($column); |
||
| 220 | $params = array_merge($params, $column->getParams()); |
||
| 221 | } elseif (!str_contains($column, '(')) { |
||
| 222 | $columns[$i] = $this->quoter->quoteColumnName($column); |
||
| 223 | } |
||
| 224 | } |
||
| 225 | |||
| 226 | return 'GROUP BY ' . implode(', ', $columns); |
||
| 227 | } |
||
| 228 | |||
| 229 | public function buildHaving(array|ExpressionInterface|string|null $condition, array &$params = []): string |
||
| 230 | { |
||
| 231 | $having = $this->buildCondition($condition, $params); |
||
| 232 | |||
| 233 | return ($having === '') ? '' : ('HAVING ' . $having); |
||
| 234 | } |
||
| 235 | |||
| 236 | public function buildJoin(array $joins, array &$params): string |
||
| 237 | { |
||
| 238 | if (empty($joins)) { |
||
| 239 | return ''; |
||
| 240 | } |
||
| 241 | |||
| 242 | /** |
||
| 243 | * @psalm-var array< |
||
| 244 | * array-key, |
||
| 245 | * array{ |
||
| 246 | * 0?:string, |
||
| 247 | * 1?:array<array-key, Query|string>|string, |
||
| 248 | * 2?:array|ExpressionInterface|string|null |
||
| 249 | * }|null |
||
| 250 | * > $joins |
||
| 251 | */ |
||
| 252 | foreach ($joins as $i => $join) { |
||
| 253 | if (!is_array($join) || !isset($join[0], $join[1])) { |
||
| 254 | throw new Exception( |
||
| 255 | 'A join clause must be specified as an array of join type, join table, and optionally join ' |
||
| 256 | . 'condition.' |
||
| 257 | ); |
||
| 258 | } |
||
| 259 | |||
| 260 | /* 0:join type, 1:join table, 2:on-condition (optional) */ |
||
| 261 | [$joinType, $table] = $join; |
||
| 262 | |||
| 263 | $tables = $this->quoteTableNames((array) $table, $params); |
||
| 264 | |||
| 265 | /** @var string $table */ |
||
| 266 | $table = reset($tables); |
||
| 267 | $joins[$i] = "$joinType $table"; |
||
| 268 | |||
| 269 | if (isset($join[2])) { |
||
| 270 | $condition = $this->buildCondition($join[2], $params); |
||
| 271 | if ($condition !== '') { |
||
| 272 | $joins[$i] .= ' ON ' . $condition; |
||
| 273 | } |
||
| 274 | } |
||
| 275 | } |
||
| 276 | |||
| 277 | /** @psalm-var array<string> $joins */ |
||
| 278 | return implode($this->separator, $joins); |
||
| 279 | } |
||
| 280 | |||
| 281 | public function buildLimit(Expression|int|null $limit, Expression|int|null $offset): string |
||
| 282 | { |
||
| 283 | $sql = ''; |
||
| 284 | |||
| 285 | if ($this->hasLimit($limit)) { |
||
| 286 | $sql = 'LIMIT ' . (string) $limit; |
||
| 287 | } |
||
| 288 | |||
| 289 | if ($this->hasOffset($offset)) { |
||
| 290 | $sql .= ' OFFSET ' . (string) $offset; |
||
| 291 | } |
||
| 292 | |||
| 293 | return ltrim($sql); |
||
| 294 | } |
||
| 295 | |||
| 296 | public function buildOrderBy(array $columns, array &$params = []): string |
||
| 297 | { |
||
| 298 | if (empty($columns)) { |
||
| 299 | return ''; |
||
| 300 | } |
||
| 301 | |||
| 302 | $orders = []; |
||
| 303 | |||
| 304 | /** @psalm-var array<string, Expression|int|string> $columns */ |
||
| 305 | foreach ($columns as $name => $direction) { |
||
| 306 | if ($direction instanceof Expression) { |
||
| 307 | $orders[] = $this->buildExpression($direction); |
||
| 308 | $params = array_merge($params, $direction->getParams()); |
||
| 309 | } else { |
||
| 310 | $orders[] = $this->quoter->quoteColumnName($name) . ($direction === SORT_DESC ? ' DESC' : ''); |
||
| 311 | } |
||
| 312 | } |
||
| 313 | |||
| 314 | return 'ORDER BY ' . implode(', ', $orders); |
||
| 315 | } |
||
| 316 | |||
| 317 | public function buildOrderByAndLimit( |
||
| 318 | string $sql, |
||
| 319 | array $orderBy, |
||
| 320 | Expression|int|null $limit, |
||
| 321 | Expression|int|null $offset, |
||
| 322 | array &$params = [] |
||
| 323 | ): string { |
||
| 324 | $orderBy = $this->buildOrderBy($orderBy, $params); |
||
| 325 | if ($orderBy !== '') { |
||
| 326 | $sql .= $this->separator . $orderBy; |
||
| 327 | } |
||
| 328 | $limit = $this->buildLimit($limit, $offset); |
||
| 329 | if ($limit !== '') { |
||
| 330 | $sql .= $this->separator . $limit; |
||
| 331 | } |
||
| 332 | |||
| 333 | return $sql; |
||
| 334 | } |
||
| 335 | |||
| 336 | public function buildSelect( |
||
| 337 | array $columns, |
||
| 338 | array &$params, |
||
| 339 | ?bool $distinct = false, |
||
| 340 | ?string $selectOption = null |
||
| 341 | ): string { |
||
| 342 | $select = $distinct ? 'SELECT DISTINCT' : 'SELECT'; |
||
| 343 | |||
| 344 | if ($selectOption !== null) { |
||
| 345 | $select .= ' ' . $selectOption; |
||
| 346 | } |
||
| 347 | |||
| 348 | if (empty($columns)) { |
||
| 349 | return $select . ' *'; |
||
| 350 | } |
||
| 351 | |||
| 352 | /** @psalm-var array<array-key, ExpressionInterface|Query|string> $columns */ |
||
| 353 | foreach ($columns as $i => $column) { |
||
| 354 | if ($column instanceof ExpressionInterface) { |
||
| 355 | if (is_int($i)) { |
||
| 356 | $columns[$i] = $this->buildExpression($column, $params); |
||
| 357 | } else { |
||
| 358 | $columns[$i] = $this->buildExpression($column, $params) . ' AS ' |
||
| 359 | . $this->quoter->quoteColumnName($i); |
||
| 360 | } |
||
| 361 | } elseif ($column instanceof QueryInterface) { |
||
| 362 | [$sql, $params] = $this->build($column, $params); |
||
| 363 | $columns[$i] = "($sql) AS " . $this->quoter->quoteColumnName((string) $i); |
||
| 364 | } elseif (is_string($i) && $i !== $column) { |
||
| 365 | if (!str_contains($column, '(')) { |
||
| 366 | $column = $this->quoter->quoteColumnName($column); |
||
| 367 | } |
||
| 368 | $columns[$i] = "$column AS " . $this->quoter->quoteColumnName($i); |
||
| 369 | } elseif (!str_contains($column, '(')) { |
||
| 370 | if (preg_match('/^(.*?)(?i:\s+as\s+|\s+)([\w\-_.]+)$/', $column, $matches)) { |
||
| 371 | $columns[$i] = $this->quoter->quoteColumnName($matches[1]) |
||
| 372 | . ' AS ' . $this->quoter->quoteColumnName($matches[2]); |
||
| 373 | } else { |
||
| 374 | $columns[$i] = $this->quoter->quoteColumnName($column); |
||
| 375 | } |
||
| 376 | } |
||
| 377 | } |
||
| 378 | |||
| 379 | return $select . ' ' . implode(', ', $columns); |
||
| 380 | } |
||
| 381 | |||
| 382 | public function buildUnion(array $unions, array &$params): string |
||
| 383 | { |
||
| 384 | if (empty($unions)) { |
||
| 385 | return ''; |
||
| 386 | } |
||
| 387 | |||
| 388 | $result = ''; |
||
| 389 | |||
| 390 | /** @psalm-var array<array{query:Query|string, all:bool}> $unions */ |
||
| 391 | foreach ($unions as $i => $union) { |
||
| 392 | $query = $union['query']; |
||
| 393 | if ($query instanceof QueryInterface) { |
||
| 394 | [$unions[$i]['query'], $params] = $this->build($query, $params); |
||
| 395 | } |
||
| 396 | |||
| 397 | $result .= 'UNION ' . ($union['all'] ? 'ALL ' : '') . '( ' . $unions[$i]['query'] . ' ) '; |
||
| 398 | } |
||
| 399 | |||
| 400 | return trim($result); |
||
| 401 | } |
||
| 402 | |||
| 403 | public function buildWhere( |
||
| 404 | array|string|ConditionInterface|ExpressionInterface|null $condition, |
||
| 405 | array &$params = [] |
||
| 406 | ): string { |
||
| 407 | $where = $this->buildCondition($condition, $params); |
||
| 408 | return ($where === '') ? '' : ('WHERE ' . $where); |
||
| 409 | } |
||
| 410 | |||
| 411 | public function buildWithQueries(array $withs, array &$params): string |
||
| 412 | { |
||
| 413 | if (empty($withs)) { |
||
| 414 | return ''; |
||
| 415 | } |
||
| 416 | |||
| 417 | $recursive = false; |
||
| 418 | $result = []; |
||
| 419 | |||
| 420 | /** @psalm-var array<array-key, array{query:string|Query, alias:string, recursive:bool}> $withs */ |
||
| 421 | foreach ($withs as $with) { |
||
| 422 | if ($with['recursive']) { |
||
| 423 | $recursive = true; |
||
| 424 | } |
||
| 425 | |||
| 426 | $query = $with['query']; |
||
| 427 | if ($query instanceof QueryInterface) { |
||
| 428 | [$with['query'], $params] = $this->build($query, $params); |
||
| 429 | } |
||
| 430 | |||
| 431 | $result[] = $with['alias'] . ' AS (' . $with['query'] . ')'; |
||
| 432 | } |
||
| 433 | |||
| 434 | return 'WITH ' . ($recursive ? 'RECURSIVE ' : '') . implode(', ', $result); |
||
| 435 | } |
||
| 436 | |||
| 437 | public function createConditionFromArray(array $condition): ConditionInterface |
||
| 438 | { |
||
| 439 | /** operator format: operator, operand 1, operand 2, ... */ |
||
| 440 | if (isset($condition[0])) { |
||
| 441 | $operator = strtoupper((string) array_shift($condition)); |
||
| 442 | |||
| 443 | /** @var string $className */ |
||
| 444 | $className = $this->conditionClasses[$operator] ?? SimpleCondition::class; |
||
| 445 | |||
| 446 | /** @var ConditionInterface $className */ |
||
| 447 | return $className::fromArrayDefinition($operator, $condition); |
||
| 448 | } |
||
| 449 | |||
| 450 | /** hash format: 'column1' => 'value1', 'column2' => 'value2', ... */ |
||
| 451 | return new HashCondition($condition); |
||
| 452 | } |
||
| 453 | |||
| 454 | public function getExpressionBuilder(ExpressionInterface $expression): object |
||
| 455 | { |
||
| 456 | $className = get_class($expression); |
||
| 457 | |||
| 458 | if (!isset($this->expressionBuilders[$className])) { |
||
| 459 | throw new InvalidArgumentException( |
||
| 460 | 'Expression of class ' . $className . ' can not be built in ' . static::class |
||
| 461 | ); |
||
| 462 | } |
||
| 463 | |||
| 464 | return new $this->expressionBuilders[$className]($this->queryBuilder); |
||
| 465 | } |
||
| 466 | |||
| 467 | public function selectExists(string $rawSql): string |
||
| 468 | { |
||
| 469 | return 'SELECT EXISTS(' . $rawSql . ')'; |
||
| 470 | } |
||
| 471 | |||
| 472 | public function setConditionClasses(array $classes): void |
||
| 473 | { |
||
| 474 | $this->conditionClasses = array_merge($this->conditionClasses, $classes); |
||
| 475 | } |
||
| 476 | |||
| 477 | public function setExpressionBuilders(array $builders): void |
||
| 478 | { |
||
| 479 | $this->expressionBuilders = array_merge($this->expressionBuilders, $builders); |
||
| 480 | } |
||
| 481 | |||
| 482 | /** |
||
| 483 | * @param string the separator between different fragments of a SQL statement. |
||
| 484 | * |
||
| 485 | * Defaults to an empty space. This is mainly used by {@see build()} when generating a SQL statement. |
||
| 486 | */ |
||
| 487 | public function setSeparator(string $separator): void |
||
| 488 | { |
||
| 489 | $this->separator = $separator; |
||
| 490 | } |
||
| 491 | |||
| 492 | /** |
||
| 493 | * Contains array of default condition classes. Extend this method, if you want to change default condition classes |
||
| 494 | * for the query builder. |
||
| 495 | * |
||
| 496 | * @return array |
||
| 497 | * |
||
| 498 | * See {@see conditionClasses} docs for details. |
||
| 499 | */ |
||
| 500 | protected function defaultConditionClasses(): array |
||
| 501 | { |
||
| 502 | return [ |
||
| 503 | 'NOT' => Conditions\NotCondition::class, |
||
| 504 | 'AND' => Conditions\AndCondition::class, |
||
| 505 | 'OR' => Conditions\OrCondition::class, |
||
| 506 | 'BETWEEN' => Conditions\BetweenCondition::class, |
||
| 507 | 'NOT BETWEEN' => Conditions\BetweenCondition::class, |
||
| 508 | 'IN' => Conditions\InCondition::class, |
||
| 509 | 'NOT IN' => Conditions\InCondition::class, |
||
| 510 | 'LIKE' => Conditions\LikeCondition::class, |
||
| 511 | 'NOT LIKE' => Conditions\LikeCondition::class, |
||
| 512 | 'OR LIKE' => Conditions\LikeCondition::class, |
||
| 513 | 'OR NOT LIKE' => Conditions\LikeCondition::class, |
||
| 514 | 'EXISTS' => Conditions\ExistsCondition::class, |
||
| 515 | 'NOT EXISTS' => Conditions\ExistsCondition::class, |
||
| 516 | ]; |
||
| 517 | } |
||
| 518 | |||
| 519 | /** |
||
| 520 | * Contains array of default expression builders. Extend this method and override it, if you want to change default |
||
| 521 | * expression builders for this query builder. |
||
| 522 | * |
||
| 523 | * @return array |
||
| 524 | * |
||
| 525 | * See {@see expressionBuilders} docs for details. |
||
| 526 | * |
||
| 527 | * @psalm-return array<string, class-string<ExpressionBuilderInterface>> |
||
| 528 | */ |
||
| 529 | protected function defaultExpressionBuilders(): array |
||
| 530 | { |
||
| 531 | return [ |
||
| 532 | Query::class => QueryExpressionBuilder::class, |
||
| 533 | Param::class => ParamBuilder::class, |
||
| 534 | Expression::class => ExpressionBuilder::class, |
||
| 535 | Conditions\ConjunctionCondition::class => Conditions\Builder\ConjunctionConditionBuilder::class, |
||
| 536 | Conditions\NotCondition::class => Conditions\Builder\NotConditionBuilder::class, |
||
| 537 | Conditions\AndCondition::class => Conditions\Builder\ConjunctionConditionBuilder::class, |
||
| 538 | Conditions\OrCondition::class => Conditions\Builder\ConjunctionConditionBuilder::class, |
||
| 539 | Conditions\BetweenCondition::class => Conditions\Builder\BetweenConditionBuilder::class, |
||
| 540 | Conditions\InCondition::class => Conditions\Builder\InConditionBuilder::class, |
||
| 541 | Conditions\LikeCondition::class => Conditions\Builder\LikeConditionBuilder::class, |
||
| 542 | Conditions\ExistsCondition::class => Conditions\Builder\ExistsConditionBuilder::class, |
||
| 543 | Conditions\SimpleCondition::class => Conditions\Builder\SimpleConditionBuilder::class, |
||
| 544 | Conditions\HashCondition::class => Conditions\Builder\HashConditionBuilder::class, |
||
| 545 | Conditions\BetweenColumnsCondition::class => Conditions\Builder\BetweenColumnsConditionBuilder::class, |
||
| 546 | ]; |
||
| 547 | } |
||
| 548 | |||
| 549 | /** |
||
| 550 | * Extracts table alias if there is one or returns false. |
||
| 551 | * |
||
| 552 | * @param string $table |
||
| 553 | * |
||
| 554 | * @return array|bool |
||
| 555 | * |
||
| 556 | * @psalm-return string[]|bool |
||
| 557 | */ |
||
| 558 | protected function extractAlias(string $table): array|bool |
||
| 559 | { |
||
| 560 | if (preg_match('/^(.*?)(?i:\s+as|)\s+([^ ]+)$/', $table, $matches)) { |
||
| 561 | return $matches; |
||
| 562 | } |
||
| 563 | |||
| 564 | return false; |
||
| 565 | } |
||
| 566 | |||
| 567 | /** |
||
| 568 | * Checks to see if the given limit is effective. |
||
| 569 | * |
||
| 570 | * @param mixed $limit the given limit. |
||
| 571 | * |
||
| 572 | * @return bool whether the limit is effective. |
||
| 573 | */ |
||
| 574 | protected function hasLimit(mixed $limit): bool |
||
| 575 | { |
||
| 576 | return ($limit instanceof ExpressionInterface) || ctype_digit((string) $limit); |
||
| 577 | } |
||
| 578 | |||
| 579 | /** |
||
| 580 | * Checks to see if the given offset is effective. |
||
| 581 | * |
||
| 582 | * @param mixed $offset the given offset. |
||
| 583 | * |
||
| 584 | * @return bool whether the offset is effective. |
||
| 585 | */ |
||
| 586 | protected function hasOffset(mixed $offset): bool |
||
| 589 | } |
||
| 590 | |||
| 591 | /** |
||
| 592 | * Quotes table names passed. |
||
| 593 | * |
||
| 594 | * @param array $tables |
||
| 595 | * @param array $params |
||
| 596 | * |
||
| 597 | * @throws Exception|InvalidConfigException|NotSupportedException |
||
| 598 | * |
||
| 599 | * @return array |
||
| 600 | */ |
||
| 601 | private function quoteTableNames(array $tables, array &$params): array |
||
| 625 | } |
||
| 626 | } |
||
| 627 |
Loading history...