CruzerSoftwares / Dolphin

src/Dolphin/Dolphin.php

Spacing +12 added lines, -12 removed lines

@@ -73,7 +73,7 @@ 
     protected $offset;
     protected $results;
 
-    private function getFields(array $args, bool $quote = true){
+    private function getFields(array $args, bool $quote = true) {
         $fldAr = array();
         $qb = new QueryBuilder();
 
@@ -86,8 +86,8 @@ 
         return $fldAr;
     }
 
-    private function validateArgsCount($noOfArgs){
-        if($noOfArgs<2 || $noOfArgs >3){
+    private function validateArgsCount($noOfArgs) {
+        if ($noOfArgs < 2 || $noOfArgs > 3) {
             throw new Exception('Where parameter contains invalid number of parameters', 1);
         }
     }
@@ -148,7 +148,7 @@ 
 
         $this->validateArgsCount($noOfArgs);
 
-        if($noOfArgs===2){
+        if ($noOfArgs === 2) {
             $this->where = array_merge($this->where, [[$args[0], '=', $args[1]]]);
             return $this;
         }
@@ -294,11 +294,11 @@ 
 
             if ($fetchRows == 'first') {
                 $this->results = $stmt->fetch(\PDO::FETCH_OBJ);
-            } else{
+            } else {
                 $this->results = $stmt->fetchAll(\PDO::FETCH_ASSOC);
             }
 
-            if(count($this->results) ){
+            if (count($this->results)) {
               // now turn this stdClass object to the object type of calling model
               $rows = $util->turnObjects($this->className, $this->results);
             }
@@ -384,7 +384,7 @@ 
 
         $row = $this->first();
 
-        if($row == null ){
+        if ($row == null) {
             throw new Exception("The record does not exists!");
         }
 
@@ -412,9 +412,9 @@ 
         $qb = new QueryBuilder();
         $query = "TRUNCATE ".$this->table;
 
-        try{
+        try {
             Connection::get()->query($qb->queryPrefix($query));
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
 
@@ -462,7 +462,7 @@ 
         $wqb = new WhereQueryBuilder();
         $query = "DELETE FROM ".$this->table;
 
-        try{
+        try {
             $whereQuery = $wqb->buildAllWhereQuery(
                                     $this->where,
                                     $this->whereRaw,
@@ -471,10 +471,10 @@ 
                                     $this->whereNull,
                                     $this->whereNotNull
                                 );
-            $query.= " ".join(" ", $whereQuery);
+            $query .= " ".join(" ", $whereQuery);
             Connection::get()->query($qb->queryPrefix($query));
             $this->reset();
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
 

src/Dolphin/Builders/UpdateQueryBuilder.php

Spacing +5 added lines, -5 removed lines

@@ -32,14 +32,14 @@ 
         $query = "UPDATE ".$table." SET ";
         $ar    = array();
 
-        foreach($row as $key => $val){
+        foreach ($row as $key => $val) {
             $ar[':'.$key] = $val;
-            $query.= $this->quote($key)." =:".$key.",";
+            $query .= $this->quote($key)." =:".$key.",";
         }
 
         $query = rtrim($query, ",");
 
-        try{
+        try {
             $whereQuery = $wqb->buildAllWhereQuery(
                                 $this->where,
                                 $this->whereRaw,
@@ -48,11 +48,11 @@ 
                                 $this->whereNull,
                                 $this->whereNotNull
                             );
-            $query.= " ".join(" ", $whereQuery);
+            $query .= " ".join(" ", $whereQuery);
             $stmt = Connection::get()->prepare($this->queryPrefix($query));
             $stmt->execute($ar);
             $this->reset();
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
     }

src/Dolphin/Builders/InsertQueryBuilder.php

Spacing +22 added lines, -22 removed lines

@@ -16,55 +16,55 @@ 
  */
 class InsertQueryBuilder extends QueryBuilder
 {
-    private function buildInsert($table, $obj){
+    private function buildInsert($table, $obj) {
         $qb = new QueryBuilder();
         $query = "INSERT INTO ".$table." (";
-        foreach($obj as $key => $val){
-            $query.= $qb->quote($key).", ";
+        foreach ($obj as $key => $val) {
+            $query .= $qb->quote($key).", ";
         }
 
         $query = rtrim($query, ", ");
-        $query.= ") VALUES ";
+        $query .= ") VALUES ";
 
         return $query;
     }
 
-    private function buildInsertPlaceholder($rows){
+    private function buildInsertPlaceholder($rows) {
         $ar = array();
         $query = "(";
 
-        foreach($rows as $key => $val){
+        foreach ($rows as $key => $val) {
             $ar[$key] = $val;
-            $query.= ":".$key.", ";
+            $query .= ":".$key.", ";
         }
 
         $query = rtrim($query, ", ");
-        $query.=") ";
+        $query .= ") ";
 
         return ['query' => $query, 'array' => $ar];
     }
 
-    private function buildInsertPlaceholders($rows){
+    private function buildInsertPlaceholders($rows) {
         $bindAr = array();
         $query = "";
 
-        foreach($rows as $i => $row){
-            $query.="(";
-            foreach($row as $key => $val){
-                $param = ":" . $key . $i;
-                $query.= $param.", ";
+        foreach ($rows as $i => $row) {
+            $query .= "(";
+            foreach ($row as $key => $val) {
+                $param = ":".$key.$i;
+                $query .= $param.", ";
                 $bindAr[$param] = $val;
             }
 
             $query = rtrim($query, ", ");
-            $query.="), ";
+            $query .= "), ";
         }
 
         $query = rtrim($query, ", ");
         return ['query' => $query, 'array' => $bindAr];
     }
 
-    private function checkMultipleInsert($rows = array()){
+    private function checkMultipleInsert($rows = array()) {
       return is_array($rows) && isset($rows[0]) && is_array($rows[0]);
     }
     /**
@@ -83,21 +83,21 @@ 
         $dataToBuild = $rows;
         $methodToCall = 'buildInsertPlaceholder';
 
-        if($this->checkMultipleInsert($rows)){
+        if ($this->checkMultipleInsert($rows)) {
             $dataToBuild = $rows[0];
             $methodToCall = 'buildInsertPlaceholders';
         }
 
         $query   = $this->buildInsert($table, $dataToBuild);
         $dataRet = $this->$methodToCall($rows);
-        $query.= $dataRet['query'];
+        $query .= $dataRet['query'];
         $bindAr = $dataRet['array'];
 
-        try{
+        try {
             $stmt = $db->prepare($this->queryPrefix($query));
 
-            if($this->checkMultipleInsert($rows)){
-                foreach($bindAr as $param => $val){
+            if ($this->checkMultipleInsert($rows)) {
+                foreach ($bindAr as $param => $val) {
                     $stmt->bindValue($param, $val);
                 }
 
@@ -107,7 +107,7 @@ 
 
             $stmt->execute($bindAr);
             return $db->lastInsertId();
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
     }