@@ -129,7 +129,7 @@ |
||
| 129 | 129 | * |
| 130 | 130 | * @var int |
| 131 | 131 | */ |
| 132 | - public $sqlite_flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE; |
|
| 132 | + public $sqlite_flags = SQLITE3_OPEN_READWRITE|SQLITE3_OPEN_CREATE; |
|
| 133 | 133 | |
| 134 | 134 | /** |
| 135 | 135 | * An optional encryption key used when encrypting and decrypting an SQLite database. |
@@ -43,7 +43,7 @@ |
||
| 43 | 43 | * |
| 44 | 44 | * @return mixed|null |
| 45 | 45 | */ |
| 46 | - public function __get(string $name) { |
|
| 46 | + public function __get(string $name){ |
|
| 47 | 47 | |
| 48 | 48 | if(isset($this->array[$name])){ |
| 49 | 49 | return $this->array[$name]; |
@@ -161,16 +161,16 @@ |
||
| 161 | 161 | * |
| 162 | 162 | * @return void |
| 163 | 163 | */ |
| 164 | - protected function bindParams(PDOStatement &$stmt, array $values){ |
|
| 164 | + protected function bindParams(PDOStatement&$stmt, array $values){ |
|
| 165 | 165 | $param_no = 1; |
| 166 | 166 | |
| 167 | 167 | foreach($values as $v){ |
| 168 | 168 | |
| 169 | 169 | switch(gettype($v)){ |
| 170 | 170 | case 'boolean': $type = PDO::PARAM_BOOL; break; |
| 171 | - case 'integer': $type = PDO::PARAM_INT; break; |
|
| 171 | + case 'integer': $type = PDO::PARAM_INT; break; |
|
| 172 | 172 | case 'NULL' : $type = PDO::PARAM_NULL; break; |
| 173 | - default: $type = PDO::PARAM_STR; break; |
|
| 173 | + default: $type = PDO::PARAM_STR; break; |
|
| 174 | 174 | } |
| 175 | 175 | |
| 176 | 176 | $stmt->bindValue($param_no, $v, $type); |
@@ -18,21 +18,21 @@ |
||
| 18 | 18 | */ |
| 19 | 19 | trait Magic{ |
| 20 | 20 | |
| 21 | - public function __get(string $name) { |
|
| 21 | + public function __get(string $name){ |
|
| 22 | 22 | return $this->get($name); |
| 23 | 23 | } |
| 24 | 24 | |
| 25 | - public function __set(string $name, $value) { |
|
| 25 | + public function __set(string $name, $value){ |
|
| 26 | 26 | $this->set($name, $value); |
| 27 | 27 | } |
| 28 | 28 | |
| 29 | - private function get(string $name) { |
|
| 29 | + private function get(string $name){ |
|
| 30 | 30 | $method = 'magic_get_'.$name; |
| 31 | 31 | |
| 32 | 32 | return method_exists($this, $method) ? $this->$method() : null; |
| 33 | 33 | } |
| 34 | 34 | |
| 35 | - private function set(string $name, $value) { |
|
| 35 | + private function set(string $name, $value){ |
|
| 36 | 36 | $method = 'magic_set_'.$name; |
| 37 | 37 | |
| 38 | 38 | if(method_exists($this, $method)){ |
@@ -54,7 +54,7 @@ |
||
| 54 | 54 | $where = []; |
| 55 | 55 | |
| 56 | 56 | foreach($this->where as $k => $v){ |
| 57 | - $last = $this->where[$k-1] ?? false; |
|
| 57 | + $last = $this->where[$k - 1] ?? false; |
|
| 58 | 58 | |
| 59 | 59 | if(in_array($v, ['AND', 'OR', 'XOR', '(', ')'], true)){ |
| 60 | 60 | $where[] = $v; |
@@ -36,7 +36,7 @@ discard block |
||
| 36 | 36 | $sql .= ' ('.PHP_EOL."\t".implode(','.PHP_EOL."\t", $this->cols); |
| 37 | 37 | |
| 38 | 38 | if($this->primaryKey){ |
| 39 | - $sql .=','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey).')'; |
|
| 39 | + $sql .= ','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey).')'; |
|
| 40 | 40 | } |
| 41 | 41 | |
| 42 | 42 | $sql .= PHP_EOL.')'; |
@@ -68,7 +68,7 @@ discard block |
||
| 68 | 68 | 'MEDIUMTEXT', 'LONGBLOB', 'LONGTEXT', 'SERIAL', 'BOOLEAN', 'UUID']; |
| 69 | 69 | |
| 70 | 70 | $field[] = (is_int($length) || is_string($length) && count(explode(',', $length)) === 2) && !in_array($type, $nolengthtypes) |
| 71 | - ? $type.'('. $length . ')' |
|
| 71 | + ? $type.'('.$length.')' |
|
| 72 | 72 | : $type; |
| 73 | 73 | |
| 74 | 74 | if($attribute){ |
@@ -36,8 +36,8 @@ |
||
| 36 | 36 | |
| 37 | 37 | $sql = 'SELECT '; |
| 38 | 38 | $sql .= $this->distinct ? 'DISTINCT ' : ''; |
| 39 | - $sql .= !empty($this->cols) ? implode($glue , $this->cols).PHP_EOL : '* '; |
|
| 40 | - $sql .= 'FROM '.implode($glue , $this->from); |
|
| 39 | + $sql .= !empty($this->cols) ? implode($glue, $this->cols).PHP_EOL : '* '; |
|
| 40 | + $sql .= 'FROM '.implode($glue, $this->from); |
|
| 41 | 41 | $sql .= $this->_getWhere(); |
| 42 | 42 | $sql .= !empty($this->groupby) ? PHP_EOL.'GROUP BY '.implode($glue, $this->groupby) : ''; |
| 43 | 43 | $sql .= !empty($this->orderby) ? PHP_EOL.'ORDER BY '.implode($glue, $this->orderby) : ''; |
@@ -33,13 +33,13 @@ discard block |
||
| 33 | 33 | |
| 34 | 34 | $n = explode('.', $this->name); |
| 35 | 35 | |
| 36 | - $sql .= $this->quote($n[count($n)-1]); |
|
| 36 | + $sql .= $this->quote($n[count($n) - 1]); |
|
| 37 | 37 | |
| 38 | 38 | if(!empty($this->cols)){ |
| 39 | 39 | $sql .= ' ('.PHP_EOL."\t".implode(','.PHP_EOL."\t", $this->cols); |
| 40 | 40 | |
| 41 | 41 | if($this->primaryKey){ |
| 42 | - $sql .=','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey).')'; |
|
| 42 | + $sql .= ','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey).')'; |
|
| 43 | 43 | } |
| 44 | 44 | |
| 45 | 45 | $sql .= PHP_EOL.')'; |
@@ -83,7 +83,7 @@ discard block |
||
| 83 | 83 | |
| 84 | 84 | if((is_int($length) || is_string($length) && count(explode(',', $length)) === 2) |
| 85 | 85 | && in_array($type, ['BIT', 'VARBIT', 'CHAR', 'VARCHAR', 'DECIMAL', 'NUMERIC', 'TIME', 'TIMESTAMP', 'INTERVAL'])){ |
| 86 | - $field[] = $type_translation.'('. $length . ')'; |
|
| 86 | + $field[] = $type_translation.'('.$length.')'; |
|
| 87 | 87 | } |
| 88 | 88 | else{ |
| 89 | 89 | $field[] = $type_translation; |
@@ -32,7 +32,7 @@ discard block |
||
| 32 | 32 | |
| 33 | 33 | $n = explode('.', $this->name); |
| 34 | 34 | |
| 35 | - $sql .= $this->quote($n[count($n)-1]); |
|
| 35 | + $sql .= $this->quote($n[count($n) - 1]); |
|
| 36 | 36 | |
| 37 | 37 | $cols = []; |
| 38 | 38 | |
@@ -98,14 +98,14 @@ discard block |
||
| 98 | 98 | $field[] = $type_translation; |
| 99 | 99 | } |
| 100 | 100 | else if(in_array($type, ['CHAR', 'VARCHAR', 'DECIMAL', 'NUMERIC'])){ |
| 101 | - $field[] = $type.'('. $length . ')'; |
|
| 101 | + $field[] = $type.'('.$length.')'; |
|
| 102 | 102 | } |
| 103 | 103 | else{ |
| 104 | 104 | $field[] = $type; |
| 105 | 105 | } |
| 106 | 106 | |
| 107 | 107 | |
| 108 | - if($isNull === false && !in_array($type, ['DATE', 'TIME', 'TIMESTAMP'])){ |
|
| 108 | + if($isNull === false && !in_array($type, ['DATE', 'TIME', 'TIMESTAMP'])){ |
|
| 109 | 109 | $field[] = 'NOT NULL'; |
| 110 | 110 | } |
| 111 | 111 | |