OsvaldoGDelRio / pdo-database

Index.php

Spacing +3 added lines, -3 removed lines

@@ -1,7 +1,7 @@ 
 <?php
 declare(strict_types=1);
 
-require_once __DIR__ . '/vendor/autoload.php';
+require_once __DIR__.'/vendor/autoload.php';
 
 use src\Factory;
 use src\pdodatabase\resultados\ContarResultados;
@@ -15,10 +15,10 @@ 
 
 // SELECT * FROM prueba
 
-$select = $factory->crear('src\factory\SelectWhere',[
+$select = $factory->crear('src\factory\SelectWhere', [
     'tabla' => 'prueba',
     'campos' => ['*'],
-    'where' => ['id','=','42']
+    'where' => ['id', '=', '42']
 ]);
 
 $select = $select->obtener();

src/pdodatabase/elementos/WhereBetween.php

Spacing +1 added lines, -1 removed lines

@@ -20,6 +20,6 @@
 
     public function datos(): array
     {
-        return [ $this->_where[1], $this->_where[2] ];
+        return [$this->_where[1], $this->_where[2]];
     }
 }
\ No newline at end of file

src/pdodatabase/elementos/WhereOr.php

Spacing +1 added lines, -1 removed lines

@@ -20,6 +20,6 @@
 
     public function datos(): array
     {
-        return [ $this->_where[2], $this->_where[5] ];
+        return [$this->_where[2], $this->_where[5]];
     }
 }
\ No newline at end of file

src/pdodatabase/ejecutar/EjecutarConsultaConDatos.php

Spacing +3 added lines, -3 removed lines

@@ -19,10 +19,10 @@ 
     {
         $query = $this->_conexion->prepare($sentencia->sql());
 
-        $x=1;
+        $x = 1;
         foreach ($sentencia->datos() as $value)
         {
-            $query->bindValue($x,$value);
+            $query->bindValue($x, $value);
             $x++;	
         }
         
@@ -30,7 +30,7 @@ 
         {
             $query->execute();
         }
-        catch(PDOException $e)
+        catch (PDOException $e)
         {
             throw new Exception("Error en la consulta");
         }

src/pdodatabase/ejecutar/EjecutarConsultaSinDatos.php

Spacing +1 added lines, -1 removed lines

@@ -23,7 +23,7 @@
         {
             $query->execute();
         }
-        catch(PDOException $e)
+        catch (PDOException $e)
         {
             throw new Exception("Error en la consulta");
         }

test/ConsultasTest.php

Spacing +1 added lines, -1 removed lines

@@ -61,7 +61,7 @@
                 new Como(
                     new Where(
                         new ValidadorDeParametrosWhere(
-                            ['id','=',12]
+                            ['id', '=', 12]
                         )
                     )
                 )

test/FactoryTest.php

Spacing +5 added lines, -5 removed lines

@@ -26,34 +26,34 @@
     public function testFactorySelectWhereDevuelveClaseAdecuada()
     {
         $select = new SelectWhere;
-        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'],'where' => ['id','=',2]]));
+        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'], 'where' => ['id', '=', 2]]));
     }
 
     // SelectWhereAnd
     public function testFactorySelectWhereAndDevuelveClaseAdecuada()
     {
         $select = new SelectWhereAnd;
-        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'],'where' => ['id','=',2,'uno','=',9]]));
+        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'], 'where' => ['id', '=', 2, 'uno', '=', 9]]));
     }
 
     // SelectWhereOr
     public function testFactorySelectWhereOrDevuelveClaseAdecuada()
     {
         $select = new SelectWhereOr;
-        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'],'where' => ['id','=',2,'uno','=',9]]));
+        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'], 'where' => ['id', '=', 2, 'uno', '=', 9]]));
     }
 
     // SelectWhereBetween
     public function testFactorySelectWhereBetweenDevuelveClaseAdecuada()
     {
         $select = new SelectWhereBetween;
-        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'],'where' => ['id','1',2]]));
+        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'], 'where' => ['id', '1', 2]]));
     }
 
     // SelectWhereBetween
     public function testFactorySelectWhereNotBetweenDevuelveClaseAdecuada()
     {
         $select = new SelectWhereNotBetween;
-        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'],'where' => ['id','1',2]]));
+        $this->assertInstanceOf(ConsultaSelectWhere::class, $select->crear(['tabla' => 'prueba', 'campos' => ['*'], 'where' => ['id', '1', 2]]));
     }
 }
\ No newline at end of file

test/ElementosTest.php

Spacing +19 added lines, -19 removed lines

@@ -46,7 +46,7 @@ 
 
     public function testCamposSoloRetornaTexto()
     {
-        $campos = new Campos(['*','78']);
+        $campos = new Campos(['*', '78']);
         $this->assertIsString($campos->sql());
     }
 
@@ -57,9 +57,9 @@ 
         $tabla = new Tabla('prueba');
         $campos = new Campos(['a,b,c,d']);
 
-        $camposytabla = new CamposYTabla($campos,$tabla);
+        $camposytabla = new CamposYTabla($campos, $tabla);
 
-        $this->assertSame('a,b,c,d FROM prueba',$camposytabla->sql());
+        $this->assertSame('a,b,c,d FROM prueba', $camposytabla->sql());
     }
 
     //Clase ValidadorDeParametrosWhere
@@ -73,13 +73,13 @@ 
     public function testValidadorDeParametrosWhereLaColumnaSoloPuedeSerString()
     {
         $this->expectException(Exception::class);
-        new ValidadorDeParametrosWhere([1,'1','2']);
+        new ValidadorDeParametrosWhere([1, '1', '2']);
     }
 
     public function testValidadorDeParametrosWhereNingunCampoPuedeEstarVacio()
     {
         $this->expectException(Exception::class);
-        new ValidadorDeParametrosWhere(['','1','2']);
+        new ValidadorDeParametrosWhere(['', '1', '2']);
     }
 
     //Clase ValidadorDeParametrosWhereBetween
@@ -93,19 +93,19 @@ 
     public function testValidadorDeParametrosWhereBetweenNoPuedeTenerValoresIguales()
     {
         $this->expectException(Exception::class);
-        new ValidadorDeParametrosWhereBetween(['id','1','1']);
+        new ValidadorDeParametrosWhereBetween(['id', '1', '1']);
     }
 
     public function testValidadorDeParametrosWhereBetweenLaColumnaSoloPuedeSerString()
     {
         $this->expectException(Exception::class);
-        new ValidadorDeParametrosWhereBetween([1,'1','2']);
+        new ValidadorDeParametrosWhereBetween([1, '1', '2']);
     }
 
     public function testValidadorDeParametrosWhereBetweenNingunCampoPuedeEstarVacio()
     {
         $this->expectException(Exception::class);
-        new ValidadorDeParametrosWhereBetween(['','1','2']);
+        new ValidadorDeParametrosWhereBetween(['', '1', '2']);
     }
 
     //Clase Where
@@ -114,7 +114,7 @@ 
     {
         $where = new Where(
             new ValidadorDeParametrosWhere(
-                ['id','=','21']
+                ['id', '=', '21']
             )
             );
 
@@ -125,7 +125,7 @@ 
     {
         $where = new Where(
             new ValidadorDeParametrosWhere(
-                ['id','=','21']
+                ['id', '=', '21']
             )
             );
 
@@ -143,13 +143,13 @@ 
     public function testValidadorDeParametrosWhereAndOthersLaColumnaSoloPuedeSerString()
     {
         $this->expectException(Exception::class);
-        new ValidadorDeParametrosWhereAndOthers([1,'=','2','1','=','2']);
+        new ValidadorDeParametrosWhereAndOthers([1, '=', '2', '1', '=', '2']);
     }
 
     public function testValidadorDeParametrosWhereAndOthersNingunCampoPuedeEstarVacio()
     {
         $this->expectException(Exception::class);
-        new ValidadorDeParametrosWhereAndOthers(['','1','2','','','']);
+        new ValidadorDeParametrosWhereAndOthers(['', '1', '2', '', '', '']);
     }
 
     //Clase Where And
@@ -158,7 +158,7 @@ 
     {
         $where = new WhereAnd(
             new ValidadorDeParametrosWhereAndOthers(
-                ['id','=','21','uno','=','1']
+                ['id', '=', '21', 'uno', '=', '1']
             )
             );
 
@@ -171,7 +171,7 @@ 
     {
         $where = new WhereOr(
             new ValidadorDeParametrosWhereAndOthers(
-                ['id','=','21','uno','=','1']
+                ['id', '=', '21', 'uno', '=', '1']
             )
             );
 
@@ -184,7 +184,7 @@ 
     {
         $where = new WhereBetween(
             new ValidadorDeParametrosWhereBetween(
-                ['id','1','21']
+                ['id', '1', '21']
             )
             );
 
@@ -197,7 +197,7 @@ 
     {
         $where = new WhereNotBetween(
             new ValidadorDeParametrosWhereBetween(
-                ['id','1','21']
+                ['id', '1', '21']
             )
             );
 
@@ -210,7 +210,7 @@ 
     {
         $where = new WhereNotBetween(
             new ValidadorDeParametrosWhereBetween(
-                ['id','1','21']
+                ['id', '1', '21']
             )
             );
         
@@ -227,7 +227,7 @@ 
     {
         $where = new WhereNotBetween(
             new ValidadorDeParametrosWhereBetween(
-                ['id','1','21']
+                ['id', '1', '21']
             )
             );
         
@@ -239,7 +239,7 @@ 
             new CamposYTabla(
                 new Campos(['*']),
                 new Tabla('prueba')
-            ),$como
+            ), $como
         );
 
         $this->assertSame('SELECT * FROM prueba WHERE NOT BETWEEN id ? AND ?', $sentencia->sql());

src/pdodatabase/elementos/ValidadorDeParametrosWhereAndOthers.php

Spacing +4 added lines, -4 removed lines

@@ -46,7 +46,7 @@ 
     {
         foreach ($array as $value)
         {
-            if(empty($value))
+            if (empty($value))
             {
                 throw new Exception("Error Processing Request");
             }
@@ -55,7 +55,7 @@ 
 
     private function columnasSonString($array): void
     {
-        if(!is_string($array[0]) || !is_string($array[3]))
+        if (!is_string($array[0]) || !is_string($array[3]))
         {
             throw new Exception("Error Processing Request");
         }
@@ -63,7 +63,7 @@ 
 
     private function numeroDeElementosValido($array): void
     {
-        if(count($array) !== 6)
+        if (count($array) !== 6)
         {
             throw new Exception("Error Processing Request");
         }
@@ -71,7 +71,7 @@ 
 
     private function operadorValido($array): void
     {
-        if(!in_array($array[1], $this->_operadoresValidos) || !in_array($array[4], $this->_operadoresValidos))
+        if (!in_array($array[1], $this->_operadoresValidos) || !in_array($array[4], $this->_operadoresValidos))
         {
             throw new Exception("Error Processing Request");
         }