Y0lk / sqldumper

src/Table.php

Indentation +9 added lines, -9 removed lines

@@ -2,15 +2,15 @@
 namespace Y0lk\SQLDumper;
 
 class Table {
-	protected $name;
+    protected $name;
 
-	public function __construct($name) 
-	{
-		$this->name = $name;
-	}
+    public function __construct($name) 
+    {
+        $this->name = $name;
+    }
 
-	public function getName() 
-	{
-		return $this->name;
-	}
+    public function getName() 
+    {
+        return $this->name;
+    }
 }
\ No newline at end of file

src/TableDumper.php

Indentation +139 added lines, -139 removed lines

@@ -4,144 +4,144 @@
 use PDO;
 
 class TableDumper {
-	protected $db;
-
-	protected $table;
-
-	protected $withStructure = true;
-	protected $withData = true;
-
-	protected $withDrop = true;
-
-	public function __construct(Table $table)
-	{
-		$this->table = $table;
-	}
-
-	public function withStructure($withStructure = true)
-	{
-		$this->withStructure = $withStructure;
-		return $this;
-	}
-
-	public function withData($withData = true)
-	{
-		$this->withData = $withData;
-		return $this;
-	}
-
-	public function withDrop($withDrop = true)
-	{
-		$this->withDrop = $withDrop;
-		return $this;
-	}
-
-	public function where($where_string)
-	{
-		$this->where = $where_string;
-		return $this;
-	}
-
-	protected function getTable()
-	{
-		return $this->table;
-	}
-
-	protected function dumpCreateStatement(PDO $db, $stream) 
-	{
-		$stmt = $db->query('SHOW CREATE TABLE `'.$this->table->getName().'`');
-
-		fwrite($stream, $stmt->fetchColumn(1).";\r\n");
-
-		$stmt->closeCursor();
-	}
-
-	protected function dumpDropStatement(PDO $db, $stream)
-	{
-		fwrite($stream, 'DROP TABLE IF EXISTS `'.$this->table->getName(). "`;\r\n");
-	}
-
-	protected function dumpInsertStatement(PDO $db, $stream)
-	{
-		//Get data from table
-		$select = 'SELECT * FROM '.$this->table->getName();
-
-		if(!empty($this->where)) {
-			$select .= ' WHERE '.$this->where;
-		}
-
-		//Add limit
-		$limit = 1000;
-		$select .= ' LIMIT :limit OFFSET :offset';
-
-		$stmt = $db->prepare($select);
-		$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
-
-		$i = 0;
-		$j = 0;
-
-		//Dump an INSERT of all rows with paging 
-		do {	
-			$stmt->bindValue(':offset', $i*$limit, PDO::PARAM_INT);
-			$stmt->execute();
-
-			while(($row = $stmt->fetch(PDO::FETCH_ASSOC)) !== false) {
-				//Write start of INSERT statement
-				if($j === 0) {
-					//Gets keys from array indexes of first row
-				    $fields = implode(',', array_keys($row));
+    protected $db;
+
+    protected $table;
+
+    protected $withStructure = true;
+    protected $withData = true;
+
+    protected $withDrop = true;
+
+    public function __construct(Table $table)
+    {
+        $this->table = $table;
+    }
+
+    public function withStructure($withStructure = true)
+    {
+        $this->withStructure = $withStructure;
+        return $this;
+    }
+
+    public function withData($withData = true)
+    {
+        $this->withData = $withData;
+        return $this;
+    }
+
+    public function withDrop($withDrop = true)
+    {
+        $this->withDrop = $withDrop;
+        return $this;
+    }
+
+    public function where($where_string)
+    {
+        $this->where = $where_string;
+        return $this;
+    }
+
+    protected function getTable()
+    {
+        return $this->table;
+    }
+
+    protected function dumpCreateStatement(PDO $db, $stream) 
+    {
+        $stmt = $db->query('SHOW CREATE TABLE `'.$this->table->getName().'`');
+
+        fwrite($stream, $stmt->fetchColumn(1).";\r\n");
+
+        $stmt->closeCursor();
+    }
+
+    protected function dumpDropStatement(PDO $db, $stream)
+    {
+        fwrite($stream, 'DROP TABLE IF EXISTS `'.$this->table->getName(). "`;\r\n");
+    }
+
+    protected function dumpInsertStatement(PDO $db, $stream)
+    {
+        //Get data from table
+        $select = 'SELECT * FROM '.$this->table->getName();
+
+        if(!empty($this->where)) {
+            $select .= ' WHERE '.$this->where;
+        }
+
+        //Add limit
+        $limit = 1000;
+        $select .= ' LIMIT :limit OFFSET :offset';
+
+        $stmt = $db->prepare($select);
+        $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
+
+        $i = 0;
+        $j = 0;
+
+        //Dump an INSERT of all rows with paging 
+        do {	
+            $stmt->bindValue(':offset', $i*$limit, PDO::PARAM_INT);
+            $stmt->execute();
+
+            while(($row = $stmt->fetch(PDO::FETCH_ASSOC)) !== false) {
+                //Write start of INSERT statement
+                if($j === 0) {
+                    //Gets keys from array indexes of first row
+                    $fields = implode(',', array_keys($row));
 				    
-				    fwrite($stream, 'INSERT INTO `'.$this->table->getName().'` ('.$fields.') VALUES ');
-				}
-
-			    //Write values of this row
-			    $valuesDump = '';
-
-		    	if($j > 0) {
-		    		$valuesDump .= ", \r\n";
-		    	}
-
-		        $listValues = array_values($row);
-
-		        //Quote values or replace with NULL if null
-		        foreach($listValues as $key => $value) {
-		            $quotedValue = str_replace("'", "\'", str_replace('"', '\"', $value));
-		            $listValues[$key] = (!isset($value) ? 'NULL' : "'" . $quotedValue."'") ;
-		        }
-
-		        //Add values from this row to valuesDump
-		        $valuesDump .= '('.implode(',', $listValues).')';
-
-		        fwrite($stream, $valuesDump);
-			    $j++;
-			}
-
-			$stmt->closeCursor();
-			$i++;
-
-		} while($j === $i*$limit);
-
-		//If there was at least one row, write end of INSERT statement
-		if($j > 0) {
-		    fwrite($stream, ";\r\n");
-		}
-	}
-
-	public function dump(PDO $db, $stream)
-	{
-		//Drop table statement
-		if($this->withDrop) {
-			$this->dumpDropStatement($db, $stream);
-		}
-
-		//Create table statement
-		if($this->withStructure) {
-			$this->dumpCreateStatement($db, $stream);
-		}
-
-		//Data
-		if($this->withData) {
-			$this->dumpInsertStatement($db, $stream);
-		}
-	}
+                    fwrite($stream, 'INSERT INTO `'.$this->table->getName().'` ('.$fields.') VALUES ');
+                }
+
+                //Write values of this row
+                $valuesDump = '';
+
+                if($j > 0) {
+                    $valuesDump .= ", \r\n";
+                }
+
+                $listValues = array_values($row);
+
+                //Quote values or replace with NULL if null
+                foreach($listValues as $key => $value) {
+                    $quotedValue = str_replace("'", "\'", str_replace('"', '\"', $value));
+                    $listValues[$key] = (!isset($value) ? 'NULL' : "'" . $quotedValue."'") ;
+                }
+
+                //Add values from this row to valuesDump
+                $valuesDump .= '('.implode(',', $listValues).')';
+
+                fwrite($stream, $valuesDump);
+                $j++;
+            }
+
+            $stmt->closeCursor();
+            $i++;
+
+        } while($j === $i*$limit);
+
+        //If there was at least one row, write end of INSERT statement
+        if($j > 0) {
+            fwrite($stream, ";\r\n");
+        }
+    }
+
+    public function dump(PDO $db, $stream)
+    {
+        //Drop table statement
+        if($this->withDrop) {
+            $this->dumpDropStatement($db, $stream);
+        }
+
+        //Create table statement
+        if($this->withStructure) {
+            $this->dumpCreateStatement($db, $stream);
+        }
+
+        //Data
+        if($this->withData) {
+            $this->dumpInsertStatement($db, $stream);
+        }
+    }
 }
\ No newline at end of file

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 {

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