rkrx /
php-mysql-query-builder
| Conditions | 10 |
| Paths | 9 |
| Total Lines | 30 |
| Code Lines | 15 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 1 | ||
| Bugs | 0 | Features | 0 |
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 22 | public function quote($value): string { |
||
| 23 | if(is_null($value)) { |
||
| 24 | return 'NULL'; |
||
| 25 | } |
||
| 26 | |||
| 27 | if(is_bool($value)) { |
||
| 28 | return $value ? '1' : '0'; |
||
| 29 | } |
||
| 30 | |||
| 31 | if(is_array($value)) { |
||
| 32 | return implode(', ', array_map([$this, __FUNCTION__], $value)); |
||
| 33 | } |
||
| 34 | |||
| 35 | if($value instanceof DBExpr) { |
||
| 36 | return $value->getExpression(); |
||
| 37 | } |
||
| 38 | |||
| 39 | if($value instanceof Select) { |
||
| 40 | return sprintf('(%s)', (string) $value); |
||
| 41 | } |
||
| 42 | |||
| 43 | if(is_int($value) || is_float($value)) { |
||
| 44 | return (string) $value; |
||
| 45 | } |
||
| 46 | |||
| 47 | if($value instanceof DateTimeInterface) { |
||
| 48 | $value = (new DateTimeImmutable($value->format('c')))->setTimezone($this->timeZone)->format('Y-m-d H:i:s'); |
||
| 49 | } |
||
| 50 | |||
| 51 | return $this->pdo->quote($value); |
||
| 52 | } |
||
| 80 |
