@@ -22,33 +22,33 @@ discard block |
||
| 22 | 22 | $this->qb = new QueryBuilder(); |
| 23 | 23 | } |
| 24 | 24 | |
| 25 | - public function buildQueryStrSingleFromArr($row = []){ |
|
| 25 | + public function buildQueryStrSingleFromArr($row = []) { |
|
| 26 | 26 | $ar = []; |
| 27 | 27 | $query = "UPDATE ".$this->table." SET "; |
| 28 | - foreach($row as $key => $val){ |
|
| 28 | + foreach ($row as $key => $val) { |
|
| 29 | 29 | $ar[':'.$key] = $val; |
| 30 | - if($key == 'id') continue; |
|
| 31 | - $query.= $this->qb->quote($key)." =:".$key.","; |
|
| 30 | + if ($key == 'id') continue; |
|
| 31 | + $query .= $this->qb->quote($key)." =:".$key.","; |
|
| 32 | 32 | } |
| 33 | 33 | $query = rtrim($query, ","); |
| 34 | 34 | |
| 35 | 35 | return ['ar' => $ar, 'query' => $query]; |
| 36 | 36 | } |
| 37 | - public function createQuery($row){ |
|
| 37 | + public function createQuery($row) { |
|
| 38 | 38 | $ar = []; |
| 39 | - if(isset($row) && isset($row->id) && $row->id > 0 ){ |
|
| 39 | + if (isset($row) && isset($row->id) && $row->id > 0) { |
|
| 40 | 40 | $mixedData = $this->buildQueryStrSingleFromArr($row); |
| 41 | - $query= $mixedData['query']." WHERE ".$this->qb->quote('id')."=:id"; |
|
| 41 | + $query = $mixedData['query']." WHERE ".$this->qb->quote('id')."=:id"; |
|
| 42 | 42 | |
| 43 | 43 | return ['query' => $query, 'data' => $mixedData['ar']]; |
| 44 | 44 | } |
| 45 | 45 | |
| 46 | 46 | $queryVal = ''; |
| 47 | 47 | $query = "INSERT INTO ".$this->table." ("; |
| 48 | - foreach($row as $key => $val){ |
|
| 49 | - $query.= $this->qb->quote($key).", "; |
|
| 48 | + foreach ($row as $key => $val) { |
|
| 49 | + $query .= $this->qb->quote($key).", "; |
|
| 50 | 50 | $ar[$key] = $val; |
| 51 | - $queryVal.= ":".$key.", "; |
|
| 51 | + $queryVal .= ":".$key.", "; |
|
| 52 | 52 | } |
| 53 | 53 | |
| 54 | 54 | $query = rtrim($query, ", ").") VALUES (".$queryVal.rtrim($query, ", ").") "; |
@@ -73,10 +73,10 @@ discard block |
||
| 73 | 73 | |
| 74 | 74 | list($query, $data) = $this->createQuery($row); |
| 75 | 75 | |
| 76 | - try{ |
|
| 76 | + try { |
|
| 77 | 77 | $stmt = Connection::get()->prepare($this->qb->queryPrefix($query)); |
| 78 | 78 | $stmt->execute($data); |
| 79 | - } catch(Exception $e){ |
|
| 79 | + } catch (Exception $e) { |
|
| 80 | 80 | throw new Exception($e->getMessage()); |
| 81 | 81 | } |
| 82 | 82 | |
@@ -73,12 +73,12 @@ discard block |
||
| 73 | 73 | protected $offset; |
| 74 | 74 | protected $results; |
| 75 | 75 | |
| 76 | - private function getFields(array $args, bool $quote = true){ |
|
| 76 | + private function getFields(array $args, bool $quote = true) { |
|
| 77 | 77 | return (new QueryBuilder())->getFields($args, $quote); |
| 78 | 78 | } |
| 79 | 79 | |
| 80 | - private function validateArgsCount($noOfArgs){ |
|
| 81 | - if($noOfArgs<2 || $noOfArgs >3){ |
|
| 80 | + private function validateArgsCount($noOfArgs) { |
|
| 81 | + if ($noOfArgs < 2 || $noOfArgs > 3) { |
|
| 82 | 82 | throw new Exception('Where parameter contains invalid number of parameters', 1); |
| 83 | 83 | } |
| 84 | 84 | } |
@@ -138,7 +138,7 @@ discard block |
||
| 138 | 138 | $noOfArgs = func_num_args(); |
| 139 | 139 | $this->validateArgsCount($noOfArgs); |
| 140 | 140 | |
| 141 | - if($noOfArgs===2){ |
|
| 141 | + if ($noOfArgs === 2) { |
|
| 142 | 142 | $this->where = array_merge($this->where, [[$args[0], '=', $args[1]]]); |
| 143 | 143 | return $this; |
| 144 | 144 | } |
@@ -223,7 +223,7 @@ discard block |
||
| 223 | 223 | */ |
| 224 | 224 | protected function buildQuery() |
| 225 | 225 | { |
| 226 | - $query = (new QueryBuilder())->buildQuery([ |
|
| 226 | + $query = (new QueryBuilder())->buildQuery([ |
|
| 227 | 227 | 'table' => $this->table, |
| 228 | 228 | 'fields' => $this->fields, |
| 229 | 229 | 'join' => $this->join, |
@@ -334,7 +334,7 @@ discard block |
||
| 334 | 334 | $this->where('id', $id); |
| 335 | 335 | $row = $this->first(); |
| 336 | 336 | |
| 337 | - if($row == null ){ |
|
| 337 | + if ($row == null) { |
|
| 338 | 338 | throw new Exception("The record does not exists!"); |
| 339 | 339 | } |
| 340 | 340 | |
@@ -373,7 +373,7 @@ discard block |
||
| 373 | 373 | */ |
| 374 | 374 | public function update($row) |
| 375 | 375 | { |
| 376 | - $result = (new UpdateQueryBuilder())->update( |
|
| 376 | + $result = (new UpdateQueryBuilder())->update( |
|
| 377 | 377 | $row, |
| 378 | 378 | $this->table, |
| 379 | 379 | $this->where, |
@@ -401,9 +401,9 @@ discard block |
||
| 401 | 401 | $qb = new QueryBuilder(); |
| 402 | 402 | $query = "TRUNCATE ".$this->table; |
| 403 | 403 | |
| 404 | - try{ |
|
| 404 | + try { |
|
| 405 | 405 | Connection::get()->query($qb->queryPrefix($query)); |
| 406 | - } catch(Exception $e){ |
|
| 406 | + } catch (Exception $e) { |
|
| 407 | 407 | throw new Exception($e->getMessage()); |
| 408 | 408 | } |
| 409 | 409 | |
@@ -419,7 +419,7 @@ discard block |
||
| 419 | 419 | */ |
| 420 | 420 | public function delete() |
| 421 | 421 | { |
| 422 | - $result = (new DeleteQueryBuilder())->delete( |
|
| 422 | + $result = (new DeleteQueryBuilder())->delete( |
|
| 423 | 423 | $this->table, |
| 424 | 424 | $this->where, |
| 425 | 425 | $this->whereRaw, |