brunobmorais / php-database

example/ExampleDao.php

Spacing +1 added lines, -1 removed lines

@@ -14,7 +14,7 @@
 

     public function findName(): array {

         $this->selectBuilder()

-            ->where("NOME=?",["Joao"])

+            ->where("NOME=?", ["Joao"])

             ->orderBy("NOME")

             ->executeQuery()

             ->fetchArrayAssoc();

src/DatalayerTrait.php

Braces +3 added lines, -2 removed lines

@@ -161,8 +161,9 @@
      */
     protected function setTableName(string $tableName, string $tableAlias = ""): self
     {
-        if (!empty($tableAlias))
-            $this->tableAlias = $tableAlias;
+        if (!empty($tableAlias)) {

+                    $this->tableAlias = $tableAlias;

+        }

         $this->tableName = $tableName;
         return $this;
     }

Spacing +3 added lines, -3 removed lines

@@ -75,7 +75,7 @@ 
     {
         try {
             if (strpos($_SERVER['SERVER_NAME'], mb_strtolower(CONFIG_DATA_LAYER["homologation"])) && !strpos($this->getDatabase(), ucfirst(CONFIG_DATA_LAYER["homologation"]))) {
-                $database = $this->getDatabase().ucfirst(CONFIG_DATA_LAYER["homologation"] ?? "");
+                $database = $this->getDatabase() . ucfirst(CONFIG_DATA_LAYER["homologation"] ?? "");
                 $this->setDatabase($database);
             }
 
@@ -125,13 +125,13 @@ 
     protected function setDatabase(string $database): self
     {
         if (strpos($_SERVER['SERVER_NAME'], mb_strtolower(CONFIG_DATA_LAYER["homologation"])) && !strpos($database, ucfirst(CONFIG_DATA_LAYER["homologation"]))) {
-            $database = $database.ucfirst(CONFIG_DATA_LAYER["homologation"] ?? "");
+            $database = $database . ucfirst(CONFIG_DATA_LAYER["homologation"] ?? "");
             $this->database = $database;
         } else {
             $this->database = $database;
         }
 
-        if (!empty($this->instance)){
+        if (!empty($this->instance)) {
             $this->executeSQL("USE {$this->getDatabase()}");
         }
 

rector.php

Spacing +1 added lines, -1 removed lines

@@ -6,7 +6,7 @@
 use Rector\Config\RectorConfig;
 use Rector\Set\ValueObject\LevelSetList;
 
-return static function (RectorConfig $rectorConfig): void {
+return static function(RectorConfig $rectorConfig): void {
     $rectorConfig->paths([
         __DIR__ . '/example',
         __DIR__ . '/src',

src/Crud.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,7 @@
     public function select(string $fields = '*', string $add = '', ?array $values = null, bool $returnModel = false, bool $debug = false)

     {

         try {

-            if (strlen($add) > 0) {

+            if (strlen($add)>0) {

                 $add = ' ' . $add;

             }

 

Braces +3 added lines, -2 removed lines

@@ -37,8 +37,9 @@
 

             $sql = "SELECT {$fields} FROM {$this->getTableName()}";

 

-            if (!empty($this->getTableAlias()))

-                $sql .= " AS {$this->getTableAlias()}";

+            if (!empty($this->getTableAlias())) {

+                            $sql .= " AS {$this->getTableAlias()}";

+            }

 

             $sql .= $add;

 

src/CrudBuilder.php

Spacing +16 added lines, -16 removed lines

@@ -228,7 +228,7 @@ 
     protected function orderBy(string $parameter, ?string $order = null): self

     {

         try {

-            $query = "ORDER BY {$parameter} ".($order ?? 'ASC');

+            $query = "ORDER BY {$parameter} " . ($order ?? 'ASC');

             $this->add($query, "orderBy");

             return $this;

         } catch (\PDOException $e) {

@@ -249,7 +249,7 @@ 
     protected function addOrderBy(string $parameter, ?string $order = null): self

     {

         try {

-            $query = ", {$parameter} ".($order ?? 'ASC')." ";

+            $query = ", {$parameter} " . ($order ?? 'ASC') . " ";

             $this->add($query, "addOrderBy");

             return $this;

         } catch (\PDOException $e) {

@@ -268,7 +268,7 @@ 
     protected function limit(string $texto): self

     {

         $query = "LIMIT {$texto}";

-        $this->add($query,"limit");

+        $this->add($query, "limit");

         return $this;

     }

 

@@ -281,7 +281,7 @@ 
     {

         try {

             $query = "OFFSET {$texto}";

-            $this->add($query,"offset");

+            $this->add($query, "offset");

             return $this;

         } catch (\PDOException $e) {

             throw new DatabaseException(

@@ -301,7 +301,7 @@ 
     {

         try {

             $query = "GROUP BY {$texto}";

-            $this->add($query,"groupBy");

+            $this->add($query, "groupBy");

             return $this;

         } catch (\PDOException $e) {

             throw new DatabaseException(

@@ -321,7 +321,7 @@ 
     {

         try {

             $query = "HAVING {$texto}";

-            $this->add($query,"having");

+            $this->add($query, "having");

             return $this;

         } catch (\PDOException $e) {

             throw new DatabaseException(

@@ -341,7 +341,7 @@ 
     {

         try {

             $query = "AND {$texto}";

-            $this->add($query,"andHaving");

+            $this->add($query, "andHaving");

             return $this;

         } catch (\PDOException $e) {

             throw new DatabaseException(

@@ -361,7 +361,7 @@ 
     {

         try {

             $query = "OR {$codition}";

-            $this->add($query,"orHaving");

+            $this->add($query, "orHaving");

             return $this;

         } catch (\PDOException $e) {

             throw new DatabaseException(

@@ -383,7 +383,7 @@ 
     {

         try {

             $query = "INNER JOIN {$table} AS {$alias} ON $codition";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             throw new DatabaseException(

@@ -405,7 +405,7 @@ 
     {

         try {

             $query = "LEFT JOIN {$table} AS {$alias} ON {$codition}";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             throw new DatabaseException(

@@ -427,7 +427,7 @@ 
     {

         try {

             $query = "RIGHT JOIN {$table} AS {$alias} ON $codition";

-            $this->add($query,"join");

+            $this->add($query, "join");

             return $this;

         } catch (\PDOException $e) {

             throw new DatabaseException(

@@ -445,13 +445,13 @@ 
     protected function executeQuery(): self

     {

         try {

-            foreach ($this->sqlPartsSelect as $key => $part){

+            foreach ($this->sqlPartsSelect as $key => $part) {

                 if (is_array($part)) {

-                    foreach ($part as $item){

-                        $this->setQuery($this->getQuery().$item);

+                    foreach ($part as $item) {

+                        $this->setQuery($this->getQuery() . $item);

                     }

                 } else {

-                    $this->setQuery($this->getQuery().$part);

+                    $this->setQuery($this->getQuery() . $part);

                 }

 

             }

@@ -496,7 +496,7 @@ 
      */

     private function add(string $query, string $type, array $params = []): void

     {

-        $query = $query." ";

+        $query = $query . " ";

         try {

             if (is_array($this->sqlPartsSelect[$type])) {

                 $this->sqlPartsSelect[$type][] = $query;

Braces +6 added lines, -4 removed lines

@@ -48,8 +48,9 @@ 
     {

         try {

             $query = "SELECT {$fields} FROM {$this->getTableName()}";

-            if (!empty($this->getTableAlias()))

-                $query .= " AS {$this->getTableAlias()}";

+            if (!empty($this->getTableAlias())) {

+                            $query .= " AS {$this->getTableAlias()}";

+            }

             $this->add($query, "main", $paramns);

             return $this;

         } catch (\PDOException $e) {

@@ -504,8 +505,9 @@ 
                 $this->sqlPartsSelect[$type] = $query;

             }

 

-            if (!empty($params))

-                $this->setParams($params);

+            if (!empty($params)) {

+                            $this->setParams($params);

+            }

         } catch (\PDOException $e) {

             throw new DatabaseException(

                 "Add query part failed - TABLE: [{$this->getTableName()}] MESSAGE: [{$e->getMessage()}]",

src/DatabaseException.php

Spacing +3 added lines, -3 removed lines

@@ -19,13 +19,13 @@ 
 
     public function __construct(
         string $message,
-        int|string $code = 0,  // ✅ Aceita int ou string
+        int | string $code = 0, // ✅ Aceita int ou string
         ?Throwable $previous = null,
         ?string $query = null,
         ?array $parameters = null
     ) {
         // ✅ Converte string para int de forma segura
-        $intCode = is_string($code) ? (int)$code : $code;
+        $intCode = is_string($code) ? (int) $code : $code;
         if ($intCode === 0 && is_string($code) && !empty($code)) {
             // Se a conversão resultou em 0 mas o código original não era vazio,
             // usa um código padrão
@@ -61,7 +61,7 @@ 
     /**
      * Get original PDO error code (may be string)
      */
-    public function getOriginalCode(): int|string
+    public function getOriginalCode(): int | string
     {
         $previous = $this->getPrevious();
         return $previous ? $previous->getCode() : $this->getCode();