CruzerSoftwares / Dolphin

src/Dolphin/Parsers/WhereQueryParser.php

Indentation +1 added lines, -1 removed lines

@@ -32,7 +32,7 @@
     {
         $ar = [];
         if(!count($whereQuery)){
-          return $ar;
+            return $ar;
         }
 
         foreach ($whereQuery as $where) {

Spacing +2 added lines, -2 removed lines

@@ -13,7 +13,7 @@ 
 class WhereQueryParser
 {
 
-    protected function prepareArrayForWhere($bindKey, $bindVal = null){
+    protected function prepareArrayForWhere($bindKey, $bindVal = null) {
         $ar = $conditionAr = [];
         // expecting a string like 'status = :status'
         if ($this->checkWherePrepareUsed($bindKey)) {
@@ -31,7 +31,7 @@ 
     public function parseWhereQuery($whereQuery = [])
     {
         $ar = [];
-        if(!count($whereQuery)){
+        if (!count($whereQuery)) {
           return $ar;
         }
 

src/Dolphin/Utils/Utils.php

Spacing +3 added lines, -3 removed lines

@@ -28,7 +28,7 @@ 
     public function turnObject($destination, $sourceObject)
     {
         $destination = new $destination();
-        if(!is_object($sourceObject)){
+        if (!is_object($sourceObject)) {
             return $destination;
         }
 
@@ -44,7 +44,7 @@ 
             if ($destinationReflection->hasProperty($name)) {
                 $propDest = $destinationReflection->getProperty($name);
                 $propDest->setAccessible(true);
-                $propDest->setValue($destination,$value);
+                $propDest->setValue($destination, $value);
             } else {
                 $destination->$name = $value;
             }
@@ -66,7 +66,7 @@ 
     public function turnObjects($destination, $data)
     {
         $destination = new $destination();
-        if((!is_null($data)) && count($data)){
+        if ((!is_null($data)) && count($data)) {
             $destination->data = json_decode(json_encode($data, true));
         }
 

src/Dolphin/Builders/UpdateQueryBuilder.php

Indentation +8 added lines, -8 removed lines

@@ -26,14 +26,14 @@
      * @since v0.0.8
      */
     public function update(
-      $row,
-      $table,
-      $where,
-      $whereRaw,
-      $whereIn,
-      $whereNotIn,
-      $whereNull,
-      $whereNotNull
+        $row,
+        $table,
+        $where,
+        $whereRaw,
+        $whereIn,
+        $whereNotIn,
+        $whereNull,
+        $whereNotNull
     ): bool
     {
         $wqb   = new WhereQueryBuilder();

Spacing +5 added lines, -5 removed lines

@@ -40,14 +40,14 @@ 
         $query = "UPDATE ".$table." SET ";
         $ar    = [];
 
-        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(
                                 $where,
                                 $whereRaw,
@@ -56,10 +56,10 @@ 
                                 $whereNull,
                                 $whereNotNull
                             );
-            $query.= " ".join(" ", $whereQuery);
+            $query .= " ".join(" ", $whereQuery);
             $stmt = Connection::get()->prepare($this->queryPrefix($query));
             $stmt->execute($ar);
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
 

src/Dolphin/Builders/InsertQueryBuilder.php

Indentation +1 added lines, -1 removed lines

@@ -65,7 +65,7 @@
     }
 
     private function checkMultipleInsert($rows = []){
-      return is_array($rows) && isset($rows[0]) && is_array($rows[0]);
+        return is_array($rows) && isset($rows[0]) && is_array($rows[0]);
     }
     /**
      * It inserts the new rows

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 = [];
         $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 = [];
         $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 = []){
+    private function checkMultipleInsert($rows = []) {
       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());
         }
     }

src/Dolphin/Builders/DeleteQueryBuilder.php

Indentation +7 added lines, -7 removed lines

@@ -26,13 +26,13 @@
      * @since v0.0.8
      */
     public function delete(
-      $table,
-      $where,
-      $whereRaw,
-      $whereIn,
-      $whereNotIn,
-      $whereNull,
-      $whereNotNull
+        $table,
+        $where,
+        $whereRaw,
+        $whereIn,
+        $whereNotIn,
+        $whereNull,
+        $whereNotNull
     ): bool
     {
         $wqb = new WhereQueryBuilder();

src/Dolphin/Builders/PrepareQueryBuilder.php

Indentation +30 added lines, -30 removed lines

@@ -19,7 +19,7 @@ 
 class PrepareQueryBuilder extends QueryBuilder
 {
     private function checkCountable($results = null ): bool{
-       return (is_array($results) || is_object($results)) && count($results);
+        return (is_array($results) || is_object($results)) && count($results);
     }
 
     /**
@@ -31,33 +31,33 @@ 
      * @author RN Kushwaha <rn.kushwaha022@gmail.com>
      * @since v0.0.5
      */
-     public function prepare($where, $className, $query, $fetchRows = 'all')
-     {
-         $wqp  = new WhereQueryParser();
-         $util = new Utils();
-         $rows = null;
-
-         try {
-             $ar = $wqp->parseWhereQuery($where);
-             $stmt = Connection::get()->prepare($this->queryPrefix($query));
-             $stmt->execute($ar);
-
-             if ($fetchRows == 'first') {
-                 $results = $stmt->fetch(\PDO::FETCH_ASSOC);
-             } else{
-                 $results = $stmt->fetchAll(\PDO::FETCH_ASSOC);
-             }
-
-             if($this->checkCountable($results) ){
-               // now turn this stdClass object to the object type of calling model
-               $rows = $util->turnObjects($className, $results);
-             }
-
-             return $rows;
-         } catch (\PDOException $ex) {
-             throw new \PDOException($ex->getMessage(), 1);
-         } catch (Exception $e) {
-             throw new Exception($e->getMessage(), 1);
-         }
-     }
+        public function prepare($where, $className, $query, $fetchRows = 'all')
+        {
+            $wqp  = new WhereQueryParser();
+            $util = new Utils();
+            $rows = null;
+
+            try {
+                $ar = $wqp->parseWhereQuery($where);
+                $stmt = Connection::get()->prepare($this->queryPrefix($query));
+                $stmt->execute($ar);
+
+                if ($fetchRows == 'first') {
+                    $results = $stmt->fetch(\PDO::FETCH_ASSOC);
+                } else{
+                    $results = $stmt->fetchAll(\PDO::FETCH_ASSOC);
+                }
+
+                if($this->checkCountable($results) ){
+                // now turn this stdClass object to the object type of calling model
+                $rows = $util->turnObjects($className, $results);
+                }
+
+                return $rows;
+            } catch (\PDOException $ex) {
+                throw new \PDOException($ex->getMessage(), 1);
+            } catch (Exception $e) {
+                throw new Exception($e->getMessage(), 1);
+            }
+        }
 }

Spacing +3 added lines, -3 removed lines

@@ -18,7 +18,7 @@ 
  */
 class PrepareQueryBuilder extends QueryBuilder
 {
-    private function checkCountable($results = null ): bool{
+    private function checkCountable($results = null): bool{
        return (is_array($results) || is_object($results)) && count($results);
     }
 
@@ -44,11 +44,11 @@ 
 
              if ($fetchRows == 'first') {
                  $results = $stmt->fetch(\PDO::FETCH_ASSOC);
-             } else{
+             } else {
                  $results = $stmt->fetchAll(\PDO::FETCH_ASSOC);
              }
 
-             if($this->checkCountable($results) ){
+             if ($this->checkCountable($results)) {
                // now turn this stdClass object to the object type of calling model
                $rows = $util->turnObjects($className, $results);
              }

src/Dolphin/Save.php

Indentation +9 added lines, -9 removed lines

@@ -23,16 +23,16 @@
     }
 
     public function buildQueryStrSingleFromArr($row = []){
-      $ar = [];
-      $query = "UPDATE ".$this->table." SET ";
-      foreach($row as $key => $val){
-          $ar[':'.$key] = $val;
-          if($key == 'id') continue;
-          $query.= $this->qb->quote($key)." =:".$key.",";
-      }
-      $query = rtrim($query, ",");
+        $ar = [];
+        $query = "UPDATE ".$this->table." SET ";
+        foreach($row as $key => $val){
+            $ar[':'.$key] = $val;
+            if($key == 'id') continue;
+            $query.= $this->qb->quote($key)." =:".$key.",";
+        }
+        $query = rtrim($query, ",");
 
-      return ['ar' => $ar, 'query' => $query];
+        return ['ar' => $ar, 'query' => $query];
     }
     public function createQuery($row){
         $ar = [];

Spacing +12 added lines, -12 removed lines

@@ -22,33 +22,33 @@ 
         $this->qb = new QueryBuilder();
     }
 
-    public function buildQueryStrSingleFromArr($row = []){
+    public function buildQueryStrSingleFromArr($row = []) {
       $ar = [];
       $query = "UPDATE ".$this->table." SET ";
-      foreach($row as $key => $val){
+      foreach ($row as $key => $val) {
           $ar[':'.$key] = $val;
-          if($key == 'id') continue;
-          $query.= $this->qb->quote($key)." =:".$key.",";
+          if ($key == 'id') continue;
+          $query .= $this->qb->quote($key)." =:".$key.",";
       }
       $query = rtrim($query, ",");
 
       return ['ar' => $ar, 'query' => $query];
     }
-    public function createQuery($row){
+    public function createQuery($row) {
         $ar = [];
-        if(isset($row) && isset($row->id) && $row->id > 0 ){
+        if (isset($row) && isset($row->id) && $row->id > 0) {
             $mixedData = $this->buildQueryStrSingleFromArr($row);
-            $query= $mixedData['query']." WHERE ".$this->qb->quote('id')."=:id";
+            $query = $mixedData['query']." WHERE ".$this->qb->quote('id')."=:id";
 
             return ['query' => $query, 'data' => $mixedData['ar']];
         }
 
         $queryVal = '';
         $query = "INSERT INTO ".$this->table." (";
-        foreach($row as $key => $val){
-            $query.= $this->qb->quote($key).", ";
+        foreach ($row as $key => $val) {
+            $query .= $this->qb->quote($key).", ";
             $ar[$key] = $val;
-            $queryVal.= ":".$key.", ";
+            $queryVal .= ":".$key.", ";
         }
 
         $query = rtrim($query, ", ").") VALUES (".$queryVal.rtrim($query, ", ").") ";
@@ -73,10 +73,10 @@ 
 
         list($query, $data) = $this->createQuery($row);
 
-        try{
+        try {
             $stmt = Connection::get()->prepare($this->qb->queryPrefix($query));
             $stmt->execute($data);
-        } catch(Exception $e){
+        } catch (Exception $e) {
             throw new Exception($e->getMessage());
         }
 

src/Dolphin/Dolphin.php

Indentation +15 added lines, -15 removed lines

@@ -374,14 +374,14 @@ 
     public function update($row)
     {
         $result =  (new UpdateQueryBuilder())->update(
-          $row,
-          $this->table,
-          $this->where,
-          $this->whereRaw,
-          $this->whereIn,
-          $this->whereNotIn,
-          $this->whereNull,
-          $this->whereNotNull
+            $row,
+            $this->table,
+            $this->where,
+            $this->whereRaw,
+            $this->whereIn,
+            $this->whereNotIn,
+            $this->whereNull,
+            $this->whereNotNull
         );
 
         $this->reset();
@@ -420,13 +420,13 @@ 
     public function delete()
     {
         $result =  (new DeleteQueryBuilder())->delete(
-          $this->table,
-          $this->where,
-          $this->whereRaw,
-          $this->whereIn,
-          $this->whereNotIn,
-          $this->whereNull,
-          $this->whereNotNull
+            $this->table,
+            $this->where,
+            $this->whereRaw,
+            $this->whereIn,
+            $this->whereNotIn,
+            $this->whereNull,
+            $this->whereNotNull
         );
 
         $this->reset();

Spacing +10 added lines, -10 removed lines

@@ -73,12 +73,12 @@ 
     protected $offset;
     protected $results;
 
-    private function getFields(array $args, bool $quote = true){
+    private function getFields(array $args, bool $quote = true) {
         return (new QueryBuilder())->getFields($args, $quote);
     }
 
-    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);
         }
     }
@@ -138,7 +138,7 @@ 
         $noOfArgs = func_num_args();
         $this->validateArgsCount($noOfArgs);
 
-        if($noOfArgs===2){
+        if ($noOfArgs === 2) {
             $this->where = array_merge($this->where, [[$args[0], '=', $args[1]]]);
             return $this;
         }
@@ -223,7 +223,7 @@ 
      */
     protected function buildQuery()
     {
-        $query  = (new QueryBuilder())->buildQuery([
+        $query = (new QueryBuilder())->buildQuery([
             'table' => $this->table,
             'fields' => $this->fields,
             'join' => $this->join,
@@ -334,7 +334,7 @@ 
         $this->where('id', $id);
         $row = $this->first();
 
-        if($row == null ){
+        if ($row == null) {
             throw new Exception("The record does not exists!");
         }
 
@@ -373,7 +373,7 @@ 
      */
     public function update($row)
     {
-        $result =  (new UpdateQueryBuilder())->update(
+        $result = (new UpdateQueryBuilder())->update(
           $row,
           $this->table,
           $this->where,
@@ -401,9 +401,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());
         }
 
@@ -419,7 +419,7 @@ 
      */
     public function delete()
     {
-        $result =  (new DeleteQueryBuilder())->delete(
+        $result = (new DeleteQueryBuilder())->delete(
           $this->table,
           $this->where,
           $this->whereRaw,