OsvaldoGDelRio / pdo-database

src/pdodatabase/elementos/WhereAnd.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

test/ElementosTest.php

Spacing +20 added lines, -20 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,19 +143,19 @@ 
     public function testValidadorDeParametrosWhereAndOthersNoPuedeTenerValoresIguales()
     {
         $this->expectException(Exception::class);
-        new ValidadorDeParametrosWhereAndOthers(['id','=','1','id','=','1']);
+        new ValidadorDeParametrosWhereAndOthers(['id', '=', '1', 'id', '=', '1']);
     }
 
     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
@@ -164,7 +164,7 @@ 
     {
         $where = new WhereAnd(
             new ValidadorDeParametrosWhereAndOthers(
-                ['id','=','21','uno','=','1']
+                ['id', '=', '21', 'uno', '=', '1']
             )
             );
 
@@ -177,7 +177,7 @@ 
     {
         $where = new WhereOr(
             new ValidadorDeParametrosWhereAndOthers(
-                ['id','=','21','uno','=','1']
+                ['id', '=', '21', 'uno', '=', '1']
             )
             );
 
@@ -190,7 +190,7 @@ 
     {
         $where = new WhereBetween(
             new ValidadorDeParametrosWhereBetween(
-                ['id','1','21']
+                ['id', '1', '21']
             )
             );
 
@@ -203,7 +203,7 @@ 
     {
         $where = new WhereNotBetween(
             new ValidadorDeParametrosWhereBetween(
-                ['id','1','21']
+                ['id', '1', '21']
             )
             );
 
@@ -216,7 +216,7 @@ 
     {
         $where = new WhereNotBetween(
             new ValidadorDeParametrosWhereBetween(
-                ['id','1','21']
+                ['id', '1', '21']
             )
             );
         
@@ -233,7 +233,7 @@ 
     {
         $where = new WhereNotBetween(
             new ValidadorDeParametrosWhereBetween(
-                ['id','1','21']
+                ['id', '1', '21']
             )
             );
         
@@ -245,7 +245,7 @@ 
             new CamposYTabla(
                 new Campos(['*']),
                 new Tabla('prueba')
-            ),$como
+            ), $como
         );
 
         $this->assertSame('SELECT * FROM prueba WHERE NOT BETWEEN id ? AND ?', $sentencia->sql());

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");
         }

Braces +1 added lines, -2 removed lines

@@ -29,8 +29,7 @@
         try
         {
             $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");
         }

Braces +1 added lines, -2 removed lines

@@ -29,8 +29,7 @@
         try
         {
             $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