@@ -21,7 +21,7 @@ |
||
| 21 | 21 | |
| 22 | 22 | public function __toString(): string |
| 23 | 23 | { |
| 24 | - return 'ORDER BY ' . $this->deck; |
|
| 24 | + return 'ORDER BY '.$this->deck; |
|
| 25 | 25 | } |
| 26 | 26 | |
| 27 | 27 | |
@@ -53,7 +53,7 @@ |
||
| 53 | 53 | public function column(string $table, string $column): array |
| 54 | 54 | { |
| 55 | 55 | if (!$this->hasColumn($table, $column)) { |
| 56 | - throw new \InvalidArgumentException('CANNOT FIND COLUMN ' . $column . ' IN TABLE ' . $table); |
|
| 56 | + throw new \InvalidArgumentException('CANNOT FIND COLUMN '.$column.' IN TABLE '.$table); |
|
| 57 | 57 | } |
| 58 | 58 | |
| 59 | 59 | if (!isset($this->tables[$table]['columns'][$column]['schema'])) { |
@@ -21,8 +21,8 @@ discard block |
||
| 21 | 21 | |
| 22 | 22 | public static function cache(string $database): ?SchemaInterface |
| 23 | 23 | { |
| 24 | - $cache_file = __DIR__ . '/cache/' . $database . '.php'; |
|
| 25 | - if(!file_exists($cache_file)){ |
|
| 24 | + $cache_file = __DIR__.'/cache/'.$database.'.php'; |
|
| 25 | + if (!file_exists($cache_file)) { |
|
| 26 | 26 | return null; |
| 27 | 27 | } |
| 28 | 28 | |
@@ -36,18 +36,18 @@ discard block |
||
| 36 | 36 | $pdo->beginTransaction(); |
| 37 | 37 | |
| 38 | 38 | // switch to the INFORMATION_SCHEMA database |
| 39 | - if(false === $pdo->query(sprintf('USE %s;', $schema_database))){ |
|
| 39 | + if (false === $pdo->query(sprintf('USE %s;', $schema_database))) { |
|
| 40 | 40 | throw new CruditesException('SWICTH_TO_INFORMATION_SCHEMA'); |
| 41 | 41 | } |
| 42 | 42 | |
| 43 | 43 | // get the schema information |
| 44 | 44 | $res = $pdo->query(self::informationSchemaQuery($database)); |
| 45 | - if(false === $res){ |
|
| 45 | + if (false === $res) { |
|
| 46 | 46 | throw new CruditesException('LOAD_INFORMATION_SCHEMA'); |
| 47 | 47 | } |
| 48 | 48 | |
| 49 | 49 | // switch back to the original database |
| 50 | - if(false === $pdo->query(sprintf('USE %s;', $database))){ |
|
| 50 | + if (false === $pdo->query(sprintf('USE %s;', $database))) { |
|
| 51 | 51 | throw new CruditesException('SWICTH_BACK_TO_USER_DATABASE'); |
| 52 | 52 | } |
| 53 | 53 | |
@@ -60,11 +60,11 @@ discard block |
||
| 60 | 60 | } |
| 61 | 61 | |
| 62 | 62 | $res = $res->fetchAll(\PDO::FETCH_ASSOC); |
| 63 | - if($res === false){ |
|
| 63 | + if ($res === false) { |
|
| 64 | 64 | throw new CruditesException('SCHEMA_LOAD_FETCHALL'); |
| 65 | 65 | } |
| 66 | 66 | |
| 67 | - if(empty($res)){ |
|
| 67 | + if (empty($res)) { |
|
| 68 | 68 | throw new CruditesException('SCHEMA_LOAD_FETCHED_EMPTY_RESULTS'); |
| 69 | 69 | } |
| 70 | 70 | |
@@ -16,7 +16,7 @@ |
||
| 16 | 16 | $alterations = ['field1' => 'value1', 'field2' => 'value2']; |
| 17 | 17 | $setClause = new Set($alterations); |
| 18 | 18 | $this->assertEquals('SET `field1` = :set_field1,`field2` = :set_field2', (string)$setClause); |
| 19 | - $this->assertEquals(['set_field1' => 'value1','set_field2' => 'value2'], $setClause->bindings()); |
|
| 19 | + $this->assertEquals(['set_field1' => 'value1', 'set_field2' => 'value2'], $setClause->bindings()); |
|
| 20 | 20 | |
| 21 | 21 | } |
| 22 | 22 | |
@@ -20,7 +20,7 @@ |
||
| 20 | 20 | |
| 21 | 21 | public function __toString(): string |
| 22 | 22 | { |
| 23 | - return 'SET ' . rtrim($this->alterations, ','); |
|
| 23 | + return 'SET '.rtrim($this->alterations, ','); |
|
| 24 | 24 | } |
| 25 | 25 | |
| 26 | 26 | public function name(): string |
@@ -11,12 +11,12 @@ |
||
| 11 | 11 | * @return string : the string surrounded by the tick character |
| 12 | 12 | * |
| 13 | 13 | */ |
| 14 | - public static function identifier($reference, $tick='`'): string |
|
| 14 | + public static function identifier($reference, $tick = '`'): string |
|
| 15 | 15 | { |
| 16 | 16 | if (is_array($reference)) { |
| 17 | 17 | $identifier = $reference[0]; |
| 18 | 18 | if (isset($reference[1])) { |
| 19 | - $identifier = $identifier.$tick . '.' . $tick.$reference[1]; |
|
| 19 | + $identifier = $identifier.$tick.'.'.$tick.$reference[1]; |
|
| 20 | 20 | } |
| 21 | 21 | $reference = $identifier; |
| 22 | 22 | } |
@@ -74,7 +74,7 @@ |
||
| 74 | 74 | $expected_bind_label = 'andValue_expression_bind_label'; |
| 75 | 75 | |
| 76 | 76 | $where->andValue($expression, '>', 3, $expected_bind_label); |
| 77 | - $this->assertEquals('WHERE ' . $expression . ' > :' . $expected_bind_label, (string)$where); |
|
| 77 | + $this->assertEquals('WHERE '.$expression.' > :'.$expected_bind_label, (string)$where); |
|
| 78 | 78 | $this->assertEquals([$expected_bind_label => 3], $where->bindings()); |
| 79 | 79 | |
| 80 | 80 | |
@@ -26,7 +26,7 @@ discard block |
||
| 26 | 26 | return ''; |
| 27 | 27 | } |
| 28 | 28 | |
| 29 | - return 'WHERE ' . implode(' AND ', $this->and); |
|
| 29 | + return 'WHERE '.implode(' AND ', $this->and); |
|
| 30 | 30 | } |
| 31 | 31 | |
| 32 | 32 | public function name(): string |
@@ -60,7 +60,7 @@ discard block |
||
| 60 | 60 | { |
| 61 | 61 | foreach ($assoc_data as $field => $value) { |
| 62 | 62 | $column = $table_name === null ? [$field] : [$table_name, $field]; |
| 63 | - $predicate = (new Predicate($column, $operator))->withValue($value, __FUNCTION__ .'_'.implode('_', $column)); |
|
| 63 | + $predicate = (new Predicate($column, $operator))->withValue($value, __FUNCTION__.'_'.implode('_', $column)); |
|
| 64 | 64 | |
| 65 | 65 | $this->and($predicate, $predicate->bindings()); |
| 66 | 66 | } |
@@ -63,7 +63,7 @@ discard block |
||
| 63 | 63 | public function withValue($value, string $bind_label = null): self |
| 64 | 64 | { |
| 65 | 65 | $this->bindings[$this->bindLabel($bind_label)] = $value; |
| 66 | - $this->right = ':' . $this->bindLabel($bind_label); |
|
| 66 | + $this->right = ':'.$this->bindLabel($bind_label); |
|
| 67 | 67 | return $this; |
| 68 | 68 | } |
| 69 | 69 | |
@@ -79,7 +79,7 @@ discard block |
||
| 79 | 79 | } |
| 80 | 80 | |
| 81 | 81 | $this->operator = 'IN'; |
| 82 | - $this->right = '(:' . implode(',:', array_keys($this->bindings)) . ')'; |
|
| 82 | + $this->right = '(:'.implode(',:', array_keys($this->bindings)).')'; |
|
| 83 | 83 | |
| 84 | 84 | return $this; |
| 85 | 85 | } |