Y0lk / sqldumper

src/TableDumperCollection.php

Spacing +7 added lines, -7 removed lines

@@ -8,7 +8,7 @@ 
     public function append($value)
     {
         //Make sure we're adding a TableDumper object
-        if(!($value instanceof TableDumper)) {
+        if (!($value instanceof TableDumper)) {
             throw new \Exception("TableDumperCollection only accepts TableDumper objects", 1);
         }
 
@@ -18,16 +18,16 @@ 
 
     public function addTable($table)
     {  
-        if($table instanceof Table) {
+        if ($table instanceof Table) {
             $tableName = $table->getName();
-        } elseif(is_string($table)) {
+        } elseif (is_string($table)) {
             $tableName = $table;
         } else {
             throw new \Exception("Invalid value supplied for argument 'table'", 1);
         }
 
         //First check if a dumper already exists for this table
-        if(!$this->offsetExists($tableName)) {
+        if (!$this->offsetExists($tableName)) {
             //Create new one
             $table = new Table($tableName);
             $this->offsetSet($tableName, new TableDumper($table));
@@ -39,20 +39,20 @@ 
     public function addListTables($listTables)
     {
         //If arg is a TableDumperCollection, merge into this one
-        if($listTables instanceof TableDumperCollection) {
+        if ($listTables instanceof TableDumperCollection) {
             foreach ($listTables as $table) {
                 $this->append($table);
             }
 
             return $listTables;
         } 
-        elseif(is_array($listTables)) {
+        elseif (is_array($listTables)) {
             //Create TableDumperCollection 
             $listDumpers = new TableDumperCollection;
 
             foreach ($listTables as $table) {
                 //If table is already a Dumper, simply append to this
-                if($table instanceof TableDumper) {
+                if ($table instanceof TableDumper) {
                     $listDumpers[] = $table;
                     $this->append($table);
                 } else {

Braces +2 added lines, -4 removed lines

@@ -45,8 +45,7 @@ 
             }
 
             return $listTables;
-        } 
-        elseif(is_array($listTables)) {
+        } elseif(is_array($listTables)) {
             //Create TableDumperCollection 
             $listDumpers = new TableDumperCollection;
 
@@ -61,8 +60,7 @@ 
             }
 
             return $listDumpers;
-        }
-        else {
+        } else {
             throw new \Exception("Invalid value supplied for argument 'listTables'", 1);
             return NULL;
         }

src/TableDumper.php

Spacing +12 added lines, -12 removed lines

@@ -58,7 +58,7 @@ 
 
     protected function dumpDropStatement(PDO $db, $stream)
     {
-        fwrite($stream, 'DROP TABLE IF EXISTS `'.$this->table->getName(). "`;\r\n");
+        fwrite($stream, 'DROP TABLE IF EXISTS `'.$this->table->getName()."`;\r\n");
     }
 
     protected function dumpInsertStatement(PDO $db, $stream)
@@ -66,7 +66,7 @@ 
         //Get data from table
         $select = 'SELECT * FROM '.$this->table->getName();
 
-        if(!empty($this->where)) {
+        if (!empty($this->where)) {
             $select .= ' WHERE '.$this->where;
         }
 
@@ -85,9 +85,9 @@ 
             $stmt->bindValue(':offset', $i*$limit, PDO::PARAM_INT);
             $stmt->execute();
 
-            while(($row = $stmt->fetch(PDO::FETCH_ASSOC)) !== false) {
+            while (($row = $stmt->fetch(PDO::FETCH_ASSOC)) !== false) {
                 //Write start of INSERT statement
-                if($j === 0) {
+                if ($j === 0) {
                     //Gets keys from array indexes of first row
                     $fields = implode(',', array_keys($row));
                     
@@ -97,16 +97,16 @@ 
                 //Write values of this row
                 $valuesDump = '';
 
-                if($j > 0) {
+                if ($j > 0) {
                     $valuesDump .= ", \r\n";
                 }
 
                 $listValues = array_values($row);
 
                 //Quote values or replace with NULL if null
-                foreach($listValues as $key => $value) {
+                foreach ($listValues as $key => $value) {
                     $quotedValue = str_replace("'", "\'", str_replace('"', '\"', $value));
-                    $listValues[$key] = (!isset($value) ? 'NULL' : "'" . $quotedValue."'") ;
+                    $listValues[$key] = (!isset($value) ? 'NULL' : "'".$quotedValue."'");
                 }
 
                 //Add values from this row to valuesDump
@@ -119,10 +119,10 @@ 
             $stmt->closeCursor();
             $i++;
 
-        } while($j === $i*$limit);
+        } while ($j === $i*$limit);
 
         //If there was at least one row, write end of INSERT statement
-        if($j > 0) {
+        if ($j > 0) {
             fwrite($stream, ";\r\n");
         }
     }
@@ -130,17 +130,17 @@ 
     public function dump(PDO $db, $stream)
     {
         //Drop table statement
-        if($this->withDrop) {
+        if ($this->withDrop) {
             $this->dumpDropStatement($db, $stream);
         }
 
         //Create table statement
-        if($this->withStructure) {
+        if ($this->withStructure) {
             $this->dumpCreateStatement($db, $stream);
         }
 
         //Data
-        if($this->withData) {
+        if ($this->withData) {
             $this->dumpInsertStatement($db, $stream);
         }
     }