Y0lk / sqldumper

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

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 {