Piou-piou / ribs-framework

core/images/Images.class.php

Indentation +3 added lines, -3 removed lines

@@ -43,13 +43,13 @@
 		//-------------------------- GETTER ----------------------------------------------------------------------------//
 
 		public function getOldImage() {
-		    return $this->old_image;
+			return $this->old_image;
 		}
 		public function getCheminImage() {
-		    return $this->chemin_image;
+			return $this->chemin_image;
 		}
 		public function getErreur() {
-		    return $this->erreur;
+			return $this->erreur;
 		}
 		public function getNomImage() {
 			return $this->nom_image;

core/images/Resize.class.php

Indentation +7 added lines, -7 removed lines

@@ -21,8 +21,8 @@ 
 		{
 			// *** Class variables
 			private $image;
-		    private $width;
-		    private $height;
+			private $width;
+			private $height;
 			private $imageResized;
 
 			function __construct($fileName)
@@ -30,9 +30,9 @@ 
 				// *** Open up the file
 				$this->image = $this->openImage($fileName);
 
-			    // *** Get width and height
-			    $this->width  = imagesx($this->image);
-			    $this->height = imagesy($this->image);
+				// *** Get width and height
+				$this->width  = imagesx($this->image);
+				$this->height = imagesy($this->image);
 			}
 
 			## --------------------------------------------------------
@@ -206,8 +206,8 @@ 
 			public function saveImage($savePath, $imageQuality="100")
 			{
 				// *** Get extension
-        		$extension = strrchr($savePath, '.');
-       			$extension = strtolower($extension);
+				$extension = strrchr($savePath, '.');
+	   			$extension = strtolower($extension);
 
 				switch($extension)
 				{

core/admin/droitsacces/GestionDroitAcces.class.php

Indentation +11 added lines, -11 removed lines

@@ -1,7 +1,7 @@ 
 <?php
-    namespace core\admin\droitsacces;
+	namespace core\admin\droitsacces;
 
-    use core\App;
+	use core\App;
 
 	class GestionDroitAcces extends DroitAcces {
 		//pour les droit_acces standard
@@ -24,7 +24,7 @@ 
 
 
 
-        //-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
+		//-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
 		public function __construct($id_liste_droit_acces=null) {
 			$dbc = App::getDb();
 
@@ -64,11 +64,11 @@ 
 				$this->id_liste_droit_acces = $id_liste_droit_acces;
 			}
 		}
-        //-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
+		//-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
 
 
 
-        //-------------------------- GETTER ----------------------------------------------------------------------------//
+		//-------------------------- GETTER ----------------------------------------------------------------------------//
 		//pour les droit_acces standard
 		public function getIdListeDroitAcces() {
 			return $this->id_liste_droit_acces;
@@ -108,7 +108,7 @@ 
 			return $this->pseudo;
 		}
 		public function getNbUser(){
-		    return $this->nb_user;
+			return $this->nb_user;
 		}
 
 		/**
@@ -116,7 +116,7 @@ 
 		 * @param $id_liste_droit_acces
 		 */
 		public function getListeDroitAccesDetailDroit($id_liste_droit_acces=null){
-		    $dbc = \core\App::getDb();
+			$dbc = \core\App::getDb();
 
 			if ($id_liste_droit_acces == null) $id_liste_droit_acces = $this->id_liste_droit_acces;
 
@@ -160,7 +160,7 @@ 
 		 * @param $id_liste_droit_acces
 		 */
 		public function getListeDroitAccesDetailPage($id_liste_droit_acces=null){
-		    $dbc = \core\App::getDb();
+			$dbc = \core\App::getDb();
 
 			if ($id_liste_droit_acces == null) $id_liste_droit_acces = $this->id_liste_droit_acces;
 
@@ -179,11 +179,11 @@ 
 				$this->setListeDroitAccesDetailPage($id_page, $titre_page);
 			}
 		}
-        //-------------------------- FIN GETTER ----------------------------------------------------------------------------//
+		//-------------------------- FIN GETTER ----------------------------------------------------------------------------//
 
 
 
-        //-------------------------- SETTER ----------------------------------------------------------------------------//
+		//-------------------------- SETTER ----------------------------------------------------------------------------//
 		private function setListeDroitAcces($id_liste_droit_acces, $nom_liste, $nb_droit_acces, $nb_droit_acces_page, $nb_user){
 			$this->id_liste_droit_acces = $id_liste_droit_acces;
 			$this->nom_liste = $nom_liste;
@@ -205,4 +205,4 @@ 
 			$this->prenom = $prenom;
 		}
 		//-------------------------- FIN SETTER ----------------------------------------------------------------------------//
-    }
\ No newline at end of file
+	}
\ No newline at end of file

core/admin/droitsacces/DroitAcces.class.php

Indentation +18 added lines, -18 removed lines

@@ -1,10 +1,10 @@ 
 <?php
-    namespace core\admin\droitsacces;
+	namespace core\admin\droitsacces;
 
 	use core\App;
 
 	class DroitAcces {
-    	private $logged;
+		private $logged;
 
 		//pour la table identite
 		private $id_identite;
@@ -21,10 +21,10 @@ 
 
 
 		//-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
-        public function __construct() {
+		public function __construct() {
 			$dbc = \core\App::getDb();
 
-            if (isset($_SESSION["idlogin".CLEF_SITE])) {
+			if (isset($_SESSION["idlogin".CLEF_SITE])) {
 				$this->logged = true;
 				$this->id_identite = $_SESSION["idlogin".CLEF_SITE];
 
@@ -44,36 +44,36 @@ 
 			else {
 				$this->logged = false;
 			}
-        }
-        //-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
+		}
+		//-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
     
     
     
-        //-------------------------- GETTER ----------------------------------------------------------------------------//
+		//-------------------------- GETTER ----------------------------------------------------------------------------//
 		public function getLogged(){
-		    return $this->logged;
+			return $this->logged;
 		}
 		public function getSuperAdmin(){
-		    return $this->super_admin;
+			return $this->super_admin;
 		}
 
 		//pour la table liste_droit_acces
 		public function getIdListeDroitAcces(){
-		    return $this->id_liste_droit_acces;
+			return $this->id_liste_droit_acces;
 		}
 
 		//pour les droits sur la gestion des contenus
 		public function getModifSeo(){
-		    return $this->modif_seo;
+			return $this->modif_seo;
 		}
 		public function getModifContenu(){
-		    return $this->modif_contenu;
+			return $this->modif_contenu;
 		}
 		public function getModifNavigation(){
-		    return $this->modif_navigation;
+			return $this->modif_navigation;
 		}
 		public function getSupprimerPage(){
-		    return $this->supprimer_page;
+			return $this->supprimer_page;
 		}
 
 		//autres getter
@@ -240,11 +240,11 @@ 
 				return true;
 			}
 		}
-        //-------------------------- FIN GETTER ----------------------------------------------------------------------------//
+		//-------------------------- FIN GETTER ----------------------------------------------------------------------------//
     
     
     
-        //-------------------------- SETTER ----------------------------------------------------------------------------//
+		//-------------------------- SETTER ----------------------------------------------------------------------------//
 
-        //-------------------------- FIN SETTER ----------------------------------------------------------------------------//
-    }
\ No newline at end of file
+		//-------------------------- FIN SETTER ----------------------------------------------------------------------------//
+	}
\ No newline at end of file

core/form/FormValidator.class.php

Indentation +36 added lines, -36 removed lines

@@ -1,48 +1,48 @@
 <?php
-    namespace core\form;
+	namespace core\form;
 
-    class FormValidator {
-        private $datas = [];
-        private $errors = [];
+	class FormValidator {
+		private $datas = [];
+		private $errors = [];
 
 
-        //-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
-        public function __construct($datas) {
-            $this->datas = $datas;
-        }
-        //-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
+		//-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
+		public function __construct($datas) {
+			$this->datas = $datas;
+		}
+		//-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
 
 
-        //-------------------------- GETTER ----------------------------------------------------------------------------//
-        public function Check($name, $rule, $option=null) {
-            $validator = "validate".ucfirst($rule);
+		//-------------------------- GETTER ----------------------------------------------------------------------------//
+		public function Check($name, $rule, $option=null) {
+			$validator = "validate".ucfirst($rule);
 
-            if (!$this->$validator($name, $option)) {
-                $this->errors[$name] = "Le champ $name n'a pas été rempli correctement";
-            }
-        }
+			if (!$this->$validator($name, $option)) {
+				$this->errors[$name] = "Le champ $name n'a pas été rempli correctement";
+			}
+		}
 
-        public function getErrors() {
-            if ($this->errors) {
-                $errors = "<ul>";
-                foreach ($this->errors as $error) {
-                    $errors .= "<li>".$error."</li>";
-                }
-                $errors .= "</ul>";
+		public function getErrors() {
+			if ($this->errors) {
+				$errors = "<ul>";
+				foreach ($this->errors as $error) {
+					$errors .= "<li>".$error."</li>";
+				}
+				$errors .= "</ul>";
 
-                return $errors;
-            }
-        }
-        //-------------------------- FIN GETTER ----------------------------------------------------------------------------//
+				return $errors;
+			}
+		}
+		//-------------------------- FIN GETTER ----------------------------------------------------------------------------//
 
 
-        //-------------------------- SETTER ----------------------------------------------------------------------------//
-        public function validateRequired($name) {
-            return array_key_exists($name, $this->datas) && $this->datas[$name] != "";
-        }
+		//-------------------------- SETTER ----------------------------------------------------------------------------//
+		public function validateRequired($name) {
+			return array_key_exists($name, $this->datas) && $this->datas[$name] != "";
+		}
 
-        public function validateEmail($name) {
-            return array_key_exists($name, $this->datas) && filter_var($this->datas[$name], FILTER_VALIDATE_EMAIL);
-        }
-        //-------------------------- FIN SETTER ----------------------------------------------------------------------------//
-    }
\ No newline at end of file
+		public function validateEmail($name) {
+			return array_key_exists($name, $this->datas) && filter_var($this->datas[$name], FILTER_VALIDATE_EMAIL);
+		}
+		//-------------------------- FIN SETTER ----------------------------------------------------------------------------//
+	}
\ No newline at end of file

core/Configuration.class.php

Indentation +44 added lines, -44 removed lines

@@ -1,16 +1,16 @@ 
 <?php
-    namespace core;
+	namespace core;
 
 
-    use core\HTML\flashmessage\FlashMessage;
+	use core\HTML\flashmessage\FlashMessage;
 
 	class Configuration {
 		//pour la configuration générale du site
-        private $nom_site; //-> nom du site
-        private $mail_site; //-> pour le gérant du site contact@nomdedomaine;com
-        private $gerant_site; //->nom du gérant du site
-        private $url_site; //-> url de site
-        private $mail_administrateur; //-> mail de l'administrateur web@clicand.com
+		private $nom_site; //-> nom du site
+		private $mail_site; //-> pour le gérant du site contact@nomdedomaine;com
+		private $gerant_site; //->nom du gérant du site
+		private $url_site; //-> url de site
+		private $mail_administrateur; //-> mail de l'administrateur web@clicand.com
 		private $last_save; //-> derniere sauvegarde de la bdd
 		private $acces_admin; //-> si == 1 on a acces à l'admin
 		private $contenu_dynamique; //->savoir si es contenus sont dynamique (stockés in DB)
@@ -23,24 +23,24 @@ 
 		private $activer_connexion;
 
 
-        //-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
-        public function __construct() {
-            $dbc = \core\App::getDb();
+		//-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
+		public function __construct() {
+			$dbc = \core\App::getDb();
 
 			//pour la configuration générale du site
-            $query = $dbc->query("SELECT * FROM configuration WHERE ID_configuration=1");
-            foreach ($query as $obj) {
-                $this->nom_site = $obj->nom_site;
-                $this->mail_site = $obj->mail_site;
-                $this->gerant_site = $obj->gerant_site;
-                $this->url_site = $obj->url_site;
-                $this->mail_administrateur = $obj->mail_administrateur;
-                $this->last_save = $obj->last_save;
+			$query = $dbc->query("SELECT * FROM configuration WHERE ID_configuration=1");
+			foreach ($query as $obj) {
+				$this->nom_site = $obj->nom_site;
+				$this->mail_site = $obj->mail_site;
+				$this->gerant_site = $obj->gerant_site;
+				$this->url_site = $obj->url_site;
+				$this->mail_administrateur = $obj->mail_administrateur;
+				$this->last_save = $obj->last_save;
 				$this->acces_admin = $obj->acces_admin;
 				$this->contenu_dynamique = $obj->contenu_dynamique;
 				$this->responsive = $obj->responsive;
 				$this->cache = $obj->cache;
-            }
+			}
 
 			//pour la configuration des comptes
 			$query = $dbc->query("SELECT * FROM configuration_compte WHERE ID_configuration_compte=1");
@@ -49,31 +49,31 @@ 
 				$this->activer_inscription = $obj->activer_inscription;
 				$this->activer_connexion = $obj->activer_connexion;
 			}
-        }
-        //-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
+		}
+		//-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
 
 
 
-        //-------------------------- GETTER ----------------------------------------------------------------------------//
+		//-------------------------- GETTER ----------------------------------------------------------------------------//
 		//pour la configuration générale du site
-        public function getNomSite(){
-            return $this->nom_site;
-        }
-        public function getMailSite(){
-            return $this->mail_site;
-        }
-        public function getGerantSite(){
-            return $this->gerant_site;
-        }
-        public function getUrlSite(){
-            return $this->url_site;
-        }
-        public function getMailAdministrateur(){
-            return $this->mail_administrateur;
-        }
-        public function getLastSave(){
-            return $this->last_save;
-        }
+		public function getNomSite(){
+			return $this->nom_site;
+		}
+		public function getMailSite(){
+			return $this->mail_site;
+		}
+		public function getGerantSite(){
+			return $this->gerant_site;
+		}
+		public function getUrlSite(){
+			return $this->url_site;
+		}
+		public function getMailAdministrateur(){
+			return $this->mail_administrateur;
+		}
+		public function getLastSave(){
+			return $this->last_save;
+		}
 		public function getAccesAdmin() {
 			return $this->acces_admin;
 		}
@@ -97,11 +97,11 @@ 
 		public function getActiverConnexion() {
 			return $this->activer_connexion;
 		}
-        //-------------------------- FIN GETTER ----------------------------------------------------------------------------//
+		//-------------------------- FIN GETTER ----------------------------------------------------------------------------//
 
 
 
-        //-------------------------- SETTER ----------------------------------------------------------------------------//
+		//-------------------------- SETTER ----------------------------------------------------------------------------//
 		/**
 		 * fonction qui permet de mettre à jour la date de la derniere save de la bdd
 		 * + supprimer la sauverde ancienne d'il y a 1 mois
@@ -125,5 +125,5 @@ 
 				unlink(ROOT."bdd_backup/".$nom_save);
 			}
 		}
-        //-------------------------- FIN SETTER ----------------------------------------------------------------------------//
-    }
\ No newline at end of file
+		//-------------------------- FIN SETTER ----------------------------------------------------------------------------//
+	}
\ No newline at end of file

core/mail/Mail.class.php

Indentation +53 added lines, -53 removed lines

@@ -1,69 +1,69 @@
 <?php
 
-    namespace core\mail;
+	namespace core\mail;
         
-    class Mail {
-        private $mail;
+	class Mail {
+		private $mail;
     
     
-        //-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
-        public function __construct($mail=null) {
-            $this->mail = $mail;
-        }
-        //-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
+		//-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
+		public function __construct($mail=null) {
+			$this->mail = $mail;
+		}
+		//-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
     
     
     
-        //-------------------------- GETTER ----------------------------------------------------------------------------//
-        //-------------------------- FIN GETTER ----------------------------------------------------------------------------//
+		//-------------------------- GETTER ----------------------------------------------------------------------------//
+		//-------------------------- FIN GETTER ----------------------------------------------------------------------------//
 
 
     
-        //-------------------------- SETTER ----------------------------------------------------------------------------//
-        /**
-         * fonction qui permet de valider si un E-mail est valide
-         * @return bool
-         */
-        public function setVerifierMail() {
-            if (filter_var($this->mail, FILTER_VALIDATE_EMAIL)) {
-                return true;
-            }
-            else {
-                return false;
-            }
-        }
+		//-------------------------- SETTER ----------------------------------------------------------------------------//
+		/**
+		 * fonction qui permet de valider si un E-mail est valide
+		 * @return bool
+		 */
+		public function setVerifierMail() {
+			if (filter_var($this->mail, FILTER_VALIDATE_EMAIL)) {
+				return true;
+			}
+			else {
+				return false;
+			}
+		}
 
-        /**
-         * fonction qui permet d'envoyer un mail
-         * @param $sujet
-         * @param $message
-         * @param null $destinataire -> si  null on envoi un mail au gerant du site
-         * @param null $destinataire -> si  null on emet le gerant du site car mail vient depuis l'admin
-         * @return bool
-         */
-        public function setEnvoyerMail($sujet, $message, $destinataire=null, $from=null) {
-            //on récupere le mail du site
-            $config = new \core\Configuration();
+		/**
+		 * fonction qui permet d'envoyer un mail
+		 * @param $sujet
+		 * @param $message
+		 * @param null $destinataire -> si  null on envoi un mail au gerant du site
+		 * @param null $destinataire -> si  null on emet le gerant du site car mail vient depuis l'admin
+		 * @return bool
+		 */
+		public function setEnvoyerMail($sujet, $message, $destinataire=null, $from=null) {
+			//on récupere le mail du site
+			$config = new \core\Configuration();
 
-            if ($from == null) $from = $config->getMailSite();
+			if ($from == null) $from = $config->getMailSite();
 
-            $headers = 'Content-type: text/html; charset=utf-8' . "\r\n";
-            $headers .= "From: ".$from;
+			$headers = 'Content-type: text/html; charset=utf-8' . "\r\n";
+			$headers .= "From: ".$from;
 
-            //si pas de destinataire on envoi le mail au gérant du site car c'est un mail envoyé par le site lui même
-            if (($destinataire == null) && ($this->mail == null)) {
-                $destinataire = $config->getMailSite();
-            }
-            else if ($destinataire == null) {
-                $destinataire = $this->mail;
-            }
+			//si pas de destinataire on envoi le mail au gérant du site car c'est un mail envoyé par le site lui même
+			if (($destinataire == null) && ($this->mail == null)) {
+				$destinataire = $config->getMailSite();
+			}
+			else if ($destinataire == null) {
+				$destinataire = $this->mail;
+			}
 
-            if (mail($destinataire, $sujet, $message, $headers)) {
-                return true;
-            }
-            else {
-                return false;
-            }
-        }
-        //-------------------------- FIN SETTER ----------------------------------------------------------------------------//
-    }
\ No newline at end of file
+			if (mail($destinataire, $sujet, $message, $headers)) {
+				return true;
+			}
+			else {
+				return false;
+			}
+		}
+		//-------------------------- FIN SETTER ----------------------------------------------------------------------------//
+	}
\ No newline at end of file

core/App.class.php

Indentation +13 added lines, -13 removed lines

@@ -1,22 +1,22 @@ 
 <?php
-    namespace core;
+	namespace core;
 
-    class App {
-    	private static $database;
+	class App {
+		private static $database;
 		private static $erreur;
     
     
-        //-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
-        public function __construct() {
+		//-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------//
+		public function __construct() {
             
-        }
-        //-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
+		}
+		//-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------//
     
     
     
-        //-------------------------- GETTER ----------------------------------------------------------------------------//
+		//-------------------------- GETTER ----------------------------------------------------------------------------//
 		public static function getErreur(){
-		    return self::$erreur;
+			return self::$erreur;
 		}
 
 		/**
@@ -54,10 +54,10 @@ 
 				return "<li>$err_egalite</li>";
 			}
 		}
-        //-------------------------- FIN GETTER ----------------------------------------------------------------------------//
+		//-------------------------- FIN GETTER ----------------------------------------------------------------------------//
     
     
     
-        //-------------------------- SETTER ----------------------------------------------------------------------------//
-        //-------------------------- FIN SETTER ----------------------------------------------------------------------------//
-    }
\ No newline at end of file
+		//-------------------------- SETTER ----------------------------------------------------------------------------//
+		//-------------------------- FIN SETTER ----------------------------------------------------------------------------//
+	}
\ No newline at end of file

core/save/Mysqldump.class.php

Indentation +1427 added lines, -1427 removed lines

@@ -1,17 +1,17 @@ 
 <?php
 /**
- * Mysqldump File Doc Comment
- *
- * PHP version 5
- *
- * @category Library
- * @package  Ifsnop\Mysqldump
- * @author   Michael J. Calkins <clouddueling@github.com>
- * @author   Diego Torres <ifsnop@github.com>
- * @license  http://www.gnu.org/copyleft/gpl.html GNU General Public License
- * @link     https://github.com/ifsnop/mysqldump-php
- *
- */
+	 * Mysqldump File Doc Comment
+	 *
+	 * PHP version 5
+	 *
+	 * @category Library
+	 * @package  Ifsnop\Mysqldump
+	 * @author   Michael J. Calkins <clouddueling@github.com>
+	 * @author   Diego Torres <ifsnop@github.com>
+	 * @license  http://www.gnu.org/copyleft/gpl.html GNU General Public License
+	 * @link     https://github.com/ifsnop/mysqldump-php
+	 *
+	 */
 
 namespace core\save;
 
@@ -33,696 +33,696 @@ 
 class Mysqldump
 {
 
-    // Same as mysqldump
-    const MAXLINESIZE = 1000000;
-
-    // Available compression methods as constants
-    const GZIP = 'Gzip';
-    const BZIP2 = 'Bzip2';
-    const NONE = 'None';
-
-    // Available connection strings
-    const UTF8 = 'utf8';
-    const UTF8MB4 = 'utf8mb4';
-
-    // This can be set both on constructor or manually
-    public $host;
-    public $port;
-    public $user;
-    public $pass;
-    public $db;
-    public $fileName;
-
-    // Internal stuff
-    private $tables = array();
-    private $views = array();
-    private $triggers = array();
-    private $dbHandler;
-    private $dbType;
-    private $compressManager;
-    private $typeAdapter;
-    private $dumpSettings = array();
-    private $pdoSettings = array();
-    private $version;
-    private $tableColumnTypes = array();
-
-    /**
-     * Constructor of Mysqldump. Note that in the case of an SQLite database
-     * connection, the filename must be in the $db parameter.
-     *
-     * @param string $db         Database name
-     * @param string $user       SQL account username
-     * @param string $pass       SQL account password
-     * @param string $host       SQL server to connect to
-     * @param string $type       SQL database type
-     * @param array  $dumpSettings SQL database settings
-     * @param array  $pdoSettings  PDO configured attributes
-     */
-    public function __construct(
-        $db = '',
-        $user = '',
-        $pass = '',
-        $host = 'localhost',
-        $type = 'mysql',
-        $dumpSettings = array(),
-        $pdoSettings = array()
-    ) {
-        $dumpSettingsDefault = array(
-            'include-tables' => array(),
-            'exclude-tables' => array(),
-            'compress' => Mysqldump::NONE,
-            'no-data' => false,
-            'add-drop-table' => false,
-            'single-transaction' => true,
-            'lock-tables' => true,
-            'add-locks' => true,
-            'extended-insert' => true,
-            'disable-keys' => true,
-            'where' => '',
-            'no-create-info' => false,
-            'skip-triggers' => false,
-            'add-drop-trigger' => true,
-            'hex-blob' => true,
-            'databases' => false,
-            'add-drop-database' => false,
-            'skip-tz-utz' => false,
-            'no-autocommit' => true,
-            'default-character-set' => Mysqldump::UTF8,
-            'skip-comments' => false,
-            'skip-dump-date' => false,
-            /* deprecated */
-            'disable-foreign-keys-check' => true
-        );
-
-        $pdoSettingsDefault = array(
-            PDO::ATTR_PERSISTENT => true,
-            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
-            PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => false
-        );
-
-        $this->db = $db;
-        $this->user = $user;
-        $this->pass = $pass;
-
-        $colonPos = strpos($host, ':');
-        if (false !== $colonPos) {
-            $this->port = substr($host, $colonPos + 1);
-            $this->host = substr($host, 0, $colonPos);
-        } else {
-            $this->port = null;
-            $this->host = $host;
-        }
-
-        $this->dbType = strtolower($type);
-        $this->pdoSettings = self::array_replace_recursive($pdoSettingsDefault, $pdoSettings);
-        $this->dumpSettings = self::array_replace_recursive($dumpSettingsDefault, $dumpSettings);
-
-        if (!isset($this->pdoSettings[PDO::MYSQL_ATTR_INIT_COMMAND])) {
-            $this->pdoSettings[PDO::MYSQL_ATTR_INIT_COMMAND] = "SET NAMES " . $this->dumpSettings['default-character-set'];
-        }
-
-        $diff = array_diff(array_keys($this->dumpSettings), array_keys($dumpSettingsDefault));
-        if (count($diff)>0) {
-            throw new Exception("Unexpected value in dumpSettings: (" . implode(",", $diff) . ")");
-        }
-
-        // Create a new compressManager to manage compressed output
-        $this->compressManager = CompressManagerFactory::create($this->dumpSettings['compress']);
-    }
-
-    /**
-     * Custom array_replace_recursive to be used if PHP < 5.3
-     * Replaces elements from passed arrays into the first array recursively
-     *
-     * @param array $array1 The array in which elements are replaced
-     * @param array $array2 The array from which elements will be extracted
-     *
-     * @return array Returns an array, or NULL if an error occurs.
-     */
-    public static function array_replace_recursive($array1, $array2)
-    {
-        if (function_exists('array_replace_recursive')) {
-            return array_replace_recursive($array1, $array2);
-        }
-
-        foreach ($array2 as $key => $value) {
-            if (is_array($value)) {
-                $array1[$key] = self::array_replace_recursive($array1[$key], $value);
-            } else {
-                $array1[$key] = $value;
-            }
-        }
-        return $array1;
-    }
-
-    /**
-     * Connect with PDO
-     *
-     * @return null
-     */
-    private function connect()
-    {
-        // Connecting with PDO
-        try {
-            switch ($this->dbType) {
-                case 'sqlite':
-                    $this->dbHandler = @new PDO("sqlite:" . $this->db, null, null, $this->pdoSettings);
-                    break;
-                case 'mysql':
-                case 'pgsql':
-                case 'dblib':
-                    $dsn =  $this->dbType .
-                        ":host=" . $this->host .
-                         (isset($this->port) ? ";port=" . $this->port : "") .
-                        ";dbname=" . $this->db;
-                    $this->dbHandler = @new PDO(
-                        $dsn,
-                        $this->user,
-                        $this->pass,
-                        $this->pdoSettings
-                    );
-                    // Fix for always-unicode output
-                    $this->dbHandler->exec("SET NAMES " . $this->dumpSettings['default-character-set']);
-                    // Store server version
-                    $this->version = $this->dbHandler->getAttribute(PDO::ATTR_SERVER_VERSION);
-                    break;
-                default:
-                    throw new Exception("Unsupported database type (" . $this->dbType . ")");
-            }
-        } catch (PDOException $e) {
-            throw new Exception(
-                "Connection to " . $this->dbType . " failed with message: " .
-                $e->getMessage()
-            );
-        }
-
-        $this->dbHandler->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_NATURAL);
-        $this->typeAdapter = TypeAdapterFactory::create($this->dbType, $this->dbHandler);
-    }
-
-    /**
-     * Main call
-     *
-     * @param string $filename  Name of file to write sql dump to
-     * @return null
-     */
-    public function start($filename = '')
-    {
-        // Output file can be redefined here
-        if (!empty($filename)) {
-            $this->fileName = $filename;
-        }
-        // We must set a name to continue
-        if (empty($this->fileName)) {
-            throw new Exception("Output file name is not set");
-        }
-
-        // Connect to database
-        $this->connect();
-
-        // Create output file
-        $this->compressManager->open($this->fileName);
-
-        // Write some basic info to output file
-        $this->compressManager->write($this->getDumpFileHeader());
-
-        // Store server settings and use sanner defaults to dump
-        $this->compressManager->write(
-            $this->typeAdapter->backup_parameters($this->dumpSettings)
-        );
-
-        if ($this->dumpSettings['databases']) {
-            $this->compressManager->write(
-                $this->typeAdapter->getDatabaseHeader($this->db)
-            );
-            if ($this->dumpSettings['add-drop-database']) {
-                $this->compressManager->write(
-                    $this->typeAdapter->add_drop_database($this->db)
-                );
-            }
-        }
-
-        // Get table, view and trigger structures from database
-        $this->getDatabaseStructure();
-
-        if ($this->dumpSettings['databases']) {
-            $this->compressManager->write(
-                $this->typeAdapter->databases($this->db)
-            );
-        }
-
-        // If there still are some tables/views in include-tables array,
-        // that means that some tables or views weren't found.
-        // Give proper error and exit.
-        if (0 < count($this->dumpSettings['include-tables'])) {
-            $name = implode(",", $this->dumpSettings['include-tables']);
-            throw new Exception("Table or View (" . $name . ") not found in database");
-        }
-
-        $this->exportTables();
-        $this->exportViews();
-        $this->exportTriggers();
-
-        // Restore saved parameters
-        $this->compressManager->write(
-            $this->typeAdapter->restore_parameters($this->dumpSettings)
-        );
-        // Write some stats to output file
-        $this->compressManager->write($this->getDumpFileFooter());
-        // Close output file
-        $this->compressManager->close();
-    }
-
-    /**
-     * Returns header for dump file
-     *
-     * @return string
-     */
-    private function getDumpFileHeader()
-    {
-        $header = '';
-        if (!$this->dumpSettings['skip-comments']) {
-            // Some info about software, source and time
-            $header = "-- mysqldump-php https://github.com/ifsnop/mysqldump-php" . PHP_EOL .
-                    "--" . PHP_EOL .
-                    "-- Host: {$this->host}\tDatabase: {$this->db}" . PHP_EOL .
-                    "-- ------------------------------------------------------" . PHP_EOL;
-
-            if (!empty($this->version)) {
-                $header .= "-- Server version \t" . $this->version . PHP_EOL;
-            }
-
-            $header .= "-- Date: " . date('r') . PHP_EOL . PHP_EOL;
-        }
-        return $header;
-    }
-
-    /**
-     * Returns footer for dump file
-     *
-     * @return string
-     */
-    private function getDumpFileFooter()
-    {
-        $footer = '';
-        if (!$this->dumpSettings['skip-comments']) {
-            $footer .= '-- Dump completed';
-            if (!$this->dumpSettings['skip-dump-date']) {
-                $footer .= ' on: ' . date('r');
-            }
-            $footer .= PHP_EOL;
-        }
-
-        return $footer;
-    }
-
-    /**
-     * Reads table and views names from database.
-     * Fills $this->tables array so they will be dumped later.
-     *
-     * @return null
-     */
-    private function getDatabaseStructure()
-    {
-        // Listing all tables from database
-        if (empty($this->dumpSettings['include-tables'])) {
-            // include all tables for now, blacklisting happens later
-            foreach ($this->dbHandler->query($this->typeAdapter->show_tables($this->db)) as $row) {
-                array_push($this->tables, current($row));
-            }
-        } else {
-            // include only the tables mentioned in include-tables
-            foreach ($this->dbHandler->query($this->typeAdapter->show_tables($this->db)) as $row) {
-                if (in_array(current($row), $this->dumpSettings['include-tables'], true)) {
-                    array_push($this->tables, current($row));
-                    $elem = array_search(
-                        current($row),
-                        $this->dumpSettings['include-tables']
-                    );
-                    unset($this->dumpSettings['include-tables'][$elem]);
-                }
-            }
-        }
-
-        // Listing all views from database
-        if (empty($this->dumpSettings['include-tables'])) {
-            // include all views for now, blacklisting happens later
-            foreach ($this->dbHandler->query($this->typeAdapter->show_views($this->db)) as $row) {
-                array_push($this->views, current($row));
-            }
-        } else {
-            // include only the tables mentioned in include-tables
-            foreach ($this->dbHandler->query($this->typeAdapter->show_views($this->db)) as $row) {
-                if (in_array(current($row), $this->dumpSettings['include-tables'], true)) {
-                    array_push($this->views, current($row));
-                    $elem = array_search(
-                        current($row),
-                        $this->dumpSettings['include-tables']
-                    );
-                    unset($this->dumpSettings['include-tables'][$elem]);
-                }
-            }
-        }
-
-        // Listing all triggers from database
-        if (false === $this->dumpSettings['skip-triggers']) {
-            foreach ($this->dbHandler->query($this->typeAdapter->show_triggers($this->db)) as $row) {
-                array_push($this->triggers, $row['Trigger']);
-            }
-        }
-    }
-
-    /**
-     * Exports all the tables selected from database
-     *
-     * @return null
-     */
-    private function exportTables()
-    {
-        // Exporting tables one by one
-        foreach ($this->tables as $table) {
-            if (in_array($table, $this->dumpSettings['exclude-tables'], true)) {
-                continue;
-            }
-            $this->getTableStructure($table);
-            if (false === $this->dumpSettings['no-data']) {
-                $this->listValues($table);
-            }
-        }
-    }
-
-    /**
-     * Exports all the views found in database
-     *
-     * @return null
-     */
-    private function exportViews()
-    {
-        if (false === $this->dumpSettings['no-create-info']) {
-            // Exporting views one by one
-            foreach ($this->views as $view) {
-                if (in_array($view, $this->dumpSettings['exclude-tables'], true)) {
-                    continue;
-                }
-                $this->getViewStructure($view);
-            }
-        }
-    }
-
-    /**
-     * Exports all the triggers found in database
-     *
-     * @return null
-     */
-    private function exportTriggers()
-    {
-        // Exporting triggers one by one
-        foreach ($this->triggers as $trigger) {
-            $this->getTriggerStructure($trigger);
-        }
-    }
-
-
-    private function getTableStructure($tableName)
-    {
-        if (!$this->dumpSettings['no-create-info']) {
-            $ret = '';
-            if (!$this->dumpSettings['skip-comments']) {
-                $ret = "--" . PHP_EOL .
-                    "-- Table structure for table `$tableName`" . PHP_EOL .
-                    "--" . PHP_EOL . PHP_EOL;
-            }
-            $stmt = $this->typeAdapter->show_create_table($tableName);
-            foreach ($this->dbHandler->query($stmt) as $r) {
-                $this->compressManager->write($ret);
-                if ($this->dumpSettings['add-drop-table']) {
-                    $this->compressManager->write(
-                        $this->typeAdapter->drop_table($tableName)
-                    );
-                }
-                $this->compressManager->write(
-                    $this->typeAdapter->create_table($r, $this->dumpSettings)
-                );
-                break;
-            }
-        }
-
-        $columnTypes = array();
-        $columns = $this->dbHandler->query(
-            $this->typeAdapter->show_columns($tableName)
-        );
-        $columns->setFetchMode(PDO::FETCH_ASSOC);
-
-        foreach($columns as $key => $col) {
-            $types = $this->typeAdapter->parseColumnType($col);
-            $columnTypes[$col['Field']] = array(
-                'is_numeric'=> $types['is_numeric'],
-                'is_blob' => $types['is_blob'],
-                'type' => $types['type']
-            );
-        }
-        $this->tableColumnTypes[$tableName] = $columnTypes;
-        return;
-    }
-
-
-    private function getViewStructure($viewName)
-    {
-        $ret = '';
-        if (!$this->dumpSettings['skip-comments']) {
-            $ret = "--" . PHP_EOL .
-                "-- Table structure for view `${viewName}`" . PHP_EOL .
-                "--" . PHP_EOL . PHP_EOL;
-        }
-        $this->compressManager->write($ret);
-        $stmt = $this->typeAdapter->show_create_view($viewName);
-        foreach ($this->dbHandler->query($stmt) as $r) {
-            if ($this->dumpSettings['add-drop-table']) {
-                $this->compressManager->write(
-                    $this->typeAdapter->drop_view($viewName)
-                );
-            }
-            $this->compressManager->write(
-                $this->typeAdapter->create_view($r)
-            );
-            break;
-        }
-    }
-
-    /**
-     * Trigger structure extractor
-     *
-     * @param string $triggerName  Name of trigger to export
-     * @return null
-     */
-    private function getTriggerStructure($triggerName)
-    {
-        $stmt = $this->typeAdapter->show_create_trigger($triggerName);
-        foreach ($this->dbHandler->query($stmt) as $r) {
-            if ($this->dumpSettings['add-drop-trigger']) {
-                $this->compressManager->write(
-                    $this->typeAdapter->add_drop_trigger($triggerName)
-                );
-            }
-            $this->compressManager->write(
-                $this->typeAdapter->create_trigger($r)
-            );
-            return;
-        }
-
-    }
-
-
-    /**
-     * Escape values with quotes when needed
-     *
-     * @param string $tableName Name of table which contains rows
-     * @param array $row Associative array of column names and values to be quoted
-     *
-     * @return string
-     */
-    private function escape($tableName, $row)
-    {
-        $ret = array();
-        $columnTypes = $this->tableColumnTypes[$tableName];
-        foreach ($row as $colName => $colValue) {
-            if (is_null($colValue)) {
-                $ret[] = "NULL";
-            } elseif ($this->dumpSettings['hex-blob'] && $columnTypes[$colName]['is_blob']) {
-                if ($columnTypes[$colName]['type'] == 'bit' || !empty($colValue)) {
-                    $ret[] = "0x${colValue}";
-                } else {
-                    $ret[] = "''";
-                }
-            } elseif ($columnTypes[$colName]['is_numeric']) {
-                $ret[] = $colValue;
-            } else {
-                $ret[] = $this->dbHandler->quote($colValue);
-            }
-        }
-        return $ret;
-    }
-
-    /**
-     * Table rows extractor
-     *
-     * @param string $tableName  Name of table to export
-     *
-     * @return null
-     */
-    private function listValues($tableName)
-    {
-        $this->prepareListValues($tableName);
-
-        $onlyOnce = true;
-        $lineSize = 0;
-
-        $colStmt = $this->getColumnStmt($tableName);
-        $stmt = "SELECT $colStmt FROM `$tableName`";
-
-        if ($this->dumpSettings['where']) {
-            $stmt .= " WHERE {$this->dumpSettings['where']}";
-        }
-        $resultSet = $this->dbHandler->query($stmt);
-        $resultSet->setFetchMode(PDO::FETCH_ASSOC);
-
-        foreach ($resultSet as $row) {
-            $vals = $this->escape($tableName, $row);
-            if ($onlyOnce || !$this->dumpSettings['extended-insert']) {
-                $lineSize += $this->compressManager->write(
-                    "INSERT INTO `$tableName` VALUES (" . implode(",", $vals) . ")"
-                );
-                $onlyOnce = false;
-            } else {
-                $lineSize += $this->compressManager->write(",(" . implode(",", $vals) . ")");
-            }
-            if (($lineSize > self::MAXLINESIZE) ||
-                    !$this->dumpSettings['extended-insert']) {
-                $onlyOnce = true;
-                $lineSize = $this->compressManager->write(";" . PHP_EOL);
-            }
-        }
-        $resultSet->closeCursor();
-
-        if (!$onlyOnce) {
-            $this->compressManager->write(";" . PHP_EOL);
-        }
-
-        $this->endListValues($tableName);
-    }
-
-    /**
-     * Table rows extractor, append information prior to dump
-     *
-     * @param string $tableName  Name of table to export
-     *
-     * @return null
-     */
-    function prepareListValues($tableName)
-    {
-        if (!$this->dumpSettings['skip-comments']) {
-            $this->compressManager->write(
-                "--" . PHP_EOL .
-                "-- Dumping data for table `$tableName`" .  PHP_EOL .
-                "--" . PHP_EOL . PHP_EOL
-            );
-        }
-
-        if ($this->dumpSettings['single-transaction']) {
-            $this->dbHandler->exec($this->typeAdapter->setup_transaction());
-            $this->dbHandler->exec($this->typeAdapter->start_transaction());
-        }
-
-        if ($this->dumpSettings['lock-tables']) {
-            $this->typeAdapter->lock_table($tableName);
-        }
-
-        if ($this->dumpSettings['add-locks']) {
-            $this->compressManager->write(
-                $this->typeAdapter->start_add_lock_table($tableName)
-            );
-        }
-
-        if ($this->dumpSettings['disable-keys']) {
-            $this->compressManager->write(
-                $this->typeAdapter->start_add_disable_keys($tableName)
-            );
-        }
-
-        // Disable autocommit for faster reload
-        if ($this->dumpSettings['no-autocommit']) {
-            $this->compressManager->write(
-                $this->typeAdapter->start_disable_autocommit()
-            );
-        }
-
-        return;
-    }
-
-    /**
-     * Table rows extractor, close locks and commits after dump
-     *
-     * @param string $tableName  Name of table to export
-     *
-     * @return null
-     */
-    function endListValues($tableName)
-    {
-        if ($this->dumpSettings['disable-keys']) {
-            $this->compressManager->write(
-                $this->typeAdapter->end_add_disable_keys($tableName)
-            );
-        }
-
-        if ($this->dumpSettings['add-locks']) {
-            $this->compressManager->write(
-                $this->typeAdapter->end_add_lock_table($tableName)
-            );
-        }
-
-        if ($this->dumpSettings['single-transaction']) {
-            $this->dbHandler->exec($this->typeAdapter->commit_transaction());
-        }
-
-        if ($this->dumpSettings['lock-tables']) {
-            $this->typeAdapter->unlock_table($tableName);
-        }
-
-        // Commit to enable autocommit
-        if ($this->dumpSettings['no-autocommit']) {
-            $this->compressManager->write(
-                $this->typeAdapter->end_disable_autocommit()
-            );
-        }
-
-        $this->compressManager->write(PHP_EOL);
-
-        return;
-    }
-
-    /**
-     * Build SQL List of all columns on current table
-     *
-     * @param string $tableName  Name of table to get columns
-     *
-     * @return string SQL sentence with columns
-     */
-    function getColumnStmt($tableName)
-    {
-        $colStmt = array();
-        foreach($this->tableColumnTypes[$tableName] as $colName => $colType) {
-            if ($colType['type'] == 'bit' && $this->dumpSettings['hex-blob']) {
-                $colStmt[] = "LPAD(HEX(`${colName}`),2,'0') AS `${colName}`";
-            } else if ($colType['is_blob'] && $this->dumpSettings['hex-blob']) {
-                $colStmt[] = "HEX(`${colName}`) AS `${colName}`";
-            } else {
-                $colStmt[] = "`${colName}`";
-            }
-        }
-        $colStmt = implode($colStmt, ",");
-
-        return $colStmt;
-    }
+	// Same as mysqldump
+	const MAXLINESIZE = 1000000;
+
+	// Available compression methods as constants
+	const GZIP = 'Gzip';
+	const BZIP2 = 'Bzip2';
+	const NONE = 'None';
+
+	// Available connection strings
+	const UTF8 = 'utf8';
+	const UTF8MB4 = 'utf8mb4';
+
+	// This can be set both on constructor or manually
+	public $host;
+	public $port;
+	public $user;
+	public $pass;
+	public $db;
+	public $fileName;
+
+	// Internal stuff
+	private $tables = array();
+	private $views = array();
+	private $triggers = array();
+	private $dbHandler;
+	private $dbType;
+	private $compressManager;
+	private $typeAdapter;
+	private $dumpSettings = array();
+	private $pdoSettings = array();
+	private $version;
+	private $tableColumnTypes = array();
+
+	/**
+	 * Constructor of Mysqldump. Note that in the case of an SQLite database
+	 * connection, the filename must be in the $db parameter.
+	 *
+	 * @param string $db         Database name
+	 * @param string $user       SQL account username
+	 * @param string $pass       SQL account password
+	 * @param string $host       SQL server to connect to
+	 * @param string $type       SQL database type
+	 * @param array  $dumpSettings SQL database settings
+	 * @param array  $pdoSettings  PDO configured attributes
+	 */
+	public function __construct(
+		$db = '',
+		$user = '',
+		$pass = '',
+		$host = 'localhost',
+		$type = 'mysql',
+		$dumpSettings = array(),
+		$pdoSettings = array()
+	) {
+		$dumpSettingsDefault = array(
+			'include-tables' => array(),
+			'exclude-tables' => array(),
+			'compress' => Mysqldump::NONE,
+			'no-data' => false,
+			'add-drop-table' => false,
+			'single-transaction' => true,
+			'lock-tables' => true,
+			'add-locks' => true,
+			'extended-insert' => true,
+			'disable-keys' => true,
+			'where' => '',
+			'no-create-info' => false,
+			'skip-triggers' => false,
+			'add-drop-trigger' => true,
+			'hex-blob' => true,
+			'databases' => false,
+			'add-drop-database' => false,
+			'skip-tz-utz' => false,
+			'no-autocommit' => true,
+			'default-character-set' => Mysqldump::UTF8,
+			'skip-comments' => false,
+			'skip-dump-date' => false,
+			/* deprecated */
+			'disable-foreign-keys-check' => true
+		);
+
+		$pdoSettingsDefault = array(
+			PDO::ATTR_PERSISTENT => true,
+			PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
+			PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => false
+		);
+
+		$this->db = $db;
+		$this->user = $user;
+		$this->pass = $pass;
+
+		$colonPos = strpos($host, ':');
+		if (false !== $colonPos) {
+			$this->port = substr($host, $colonPos + 1);
+			$this->host = substr($host, 0, $colonPos);
+		} else {
+			$this->port = null;
+			$this->host = $host;
+		}
+
+		$this->dbType = strtolower($type);
+		$this->pdoSettings = self::array_replace_recursive($pdoSettingsDefault, $pdoSettings);
+		$this->dumpSettings = self::array_replace_recursive($dumpSettingsDefault, $dumpSettings);
+
+		if (!isset($this->pdoSettings[PDO::MYSQL_ATTR_INIT_COMMAND])) {
+			$this->pdoSettings[PDO::MYSQL_ATTR_INIT_COMMAND] = "SET NAMES " . $this->dumpSettings['default-character-set'];
+		}
+
+		$diff = array_diff(array_keys($this->dumpSettings), array_keys($dumpSettingsDefault));
+		if (count($diff)>0) {
+			throw new Exception("Unexpected value in dumpSettings: (" . implode(",", $diff) . ")");
+		}
+
+		// Create a new compressManager to manage compressed output
+		$this->compressManager = CompressManagerFactory::create($this->dumpSettings['compress']);
+	}
+
+	/**
+	 * Custom array_replace_recursive to be used if PHP < 5.3
+	 * Replaces elements from passed arrays into the first array recursively
+	 *
+	 * @param array $array1 The array in which elements are replaced
+	 * @param array $array2 The array from which elements will be extracted
+	 *
+	 * @return array Returns an array, or NULL if an error occurs.
+	 */
+	public static function array_replace_recursive($array1, $array2)
+	{
+		if (function_exists('array_replace_recursive')) {
+			return array_replace_recursive($array1, $array2);
+		}
+
+		foreach ($array2 as $key => $value) {
+			if (is_array($value)) {
+				$array1[$key] = self::array_replace_recursive($array1[$key], $value);
+			} else {
+				$array1[$key] = $value;
+			}
+		}
+		return $array1;
+	}
+
+	/**
+	 * Connect with PDO
+	 *
+	 * @return null
+	 */
+	private function connect()
+	{
+		// Connecting with PDO
+		try {
+			switch ($this->dbType) {
+				case 'sqlite':
+					$this->dbHandler = @new PDO("sqlite:" . $this->db, null, null, $this->pdoSettings);
+					break;
+				case 'mysql':
+				case 'pgsql':
+				case 'dblib':
+					$dsn =  $this->dbType .
+						":host=" . $this->host .
+						 (isset($this->port) ? ";port=" . $this->port : "") .
+						";dbname=" . $this->db;
+					$this->dbHandler = @new PDO(
+						$dsn,
+						$this->user,
+						$this->pass,
+						$this->pdoSettings
+					);
+					// Fix for always-unicode output
+					$this->dbHandler->exec("SET NAMES " . $this->dumpSettings['default-character-set']);
+					// Store server version
+					$this->version = $this->dbHandler->getAttribute(PDO::ATTR_SERVER_VERSION);
+					break;
+				default:
+					throw new Exception("Unsupported database type (" . $this->dbType . ")");
+			}
+		} catch (PDOException $e) {
+			throw new Exception(
+				"Connection to " . $this->dbType . " failed with message: " .
+				$e->getMessage()
+			);
+		}
+
+		$this->dbHandler->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_NATURAL);
+		$this->typeAdapter = TypeAdapterFactory::create($this->dbType, $this->dbHandler);
+	}
+
+	/**
+	 * Main call
+	 *
+	 * @param string $filename  Name of file to write sql dump to
+	 * @return null
+	 */
+	public function start($filename = '')
+	{
+		// Output file can be redefined here
+		if (!empty($filename)) {
+			$this->fileName = $filename;
+		}
+		// We must set a name to continue
+		if (empty($this->fileName)) {
+			throw new Exception("Output file name is not set");
+		}
+
+		// Connect to database
+		$this->connect();
+
+		// Create output file
+		$this->compressManager->open($this->fileName);
+
+		// Write some basic info to output file
+		$this->compressManager->write($this->getDumpFileHeader());
+
+		// Store server settings and use sanner defaults to dump
+		$this->compressManager->write(
+			$this->typeAdapter->backup_parameters($this->dumpSettings)
+		);
+
+		if ($this->dumpSettings['databases']) {
+			$this->compressManager->write(
+				$this->typeAdapter->getDatabaseHeader($this->db)
+			);
+			if ($this->dumpSettings['add-drop-database']) {
+				$this->compressManager->write(
+					$this->typeAdapter->add_drop_database($this->db)
+				);
+			}
+		}
+
+		// Get table, view and trigger structures from database
+		$this->getDatabaseStructure();
+
+		if ($this->dumpSettings['databases']) {
+			$this->compressManager->write(
+				$this->typeAdapter->databases($this->db)
+			);
+		}
+
+		// If there still are some tables/views in include-tables array,
+		// that means that some tables or views weren't found.
+		// Give proper error and exit.
+		if (0 < count($this->dumpSettings['include-tables'])) {
+			$name = implode(",", $this->dumpSettings['include-tables']);
+			throw new Exception("Table or View (" . $name . ") not found in database");
+		}
+
+		$this->exportTables();
+		$this->exportViews();
+		$this->exportTriggers();
+
+		// Restore saved parameters
+		$this->compressManager->write(
+			$this->typeAdapter->restore_parameters($this->dumpSettings)
+		);
+		// Write some stats to output file
+		$this->compressManager->write($this->getDumpFileFooter());
+		// Close output file
+		$this->compressManager->close();
+	}
+
+	/**
+	 * Returns header for dump file
+	 *
+	 * @return string
+	 */
+	private function getDumpFileHeader()
+	{
+		$header = '';
+		if (!$this->dumpSettings['skip-comments']) {
+			// Some info about software, source and time
+			$header = "-- mysqldump-php https://github.com/ifsnop/mysqldump-php" . PHP_EOL .
+					"--" . PHP_EOL .
+					"-- Host: {$this->host}\tDatabase: {$this->db}" . PHP_EOL .
+					"-- ------------------------------------------------------" . PHP_EOL;
+
+			if (!empty($this->version)) {
+				$header .= "-- Server version \t" . $this->version . PHP_EOL;
+			}
+
+			$header .= "-- Date: " . date('r') . PHP_EOL . PHP_EOL;
+		}
+		return $header;
+	}
+
+	/**
+	 * Returns footer for dump file
+	 *
+	 * @return string
+	 */
+	private function getDumpFileFooter()
+	{
+		$footer = '';
+		if (!$this->dumpSettings['skip-comments']) {
+			$footer .= '-- Dump completed';
+			if (!$this->dumpSettings['skip-dump-date']) {
+				$footer .= ' on: ' . date('r');
+			}
+			$footer .= PHP_EOL;
+		}
+
+		return $footer;
+	}
+
+	/**
+	 * Reads table and views names from database.
+	 * Fills $this->tables array so they will be dumped later.
+	 *
+	 * @return null
+	 */
+	private function getDatabaseStructure()
+	{
+		// Listing all tables from database
+		if (empty($this->dumpSettings['include-tables'])) {
+			// include all tables for now, blacklisting happens later
+			foreach ($this->dbHandler->query($this->typeAdapter->show_tables($this->db)) as $row) {
+				array_push($this->tables, current($row));
+			}
+		} else {
+			// include only the tables mentioned in include-tables
+			foreach ($this->dbHandler->query($this->typeAdapter->show_tables($this->db)) as $row) {
+				if (in_array(current($row), $this->dumpSettings['include-tables'], true)) {
+					array_push($this->tables, current($row));
+					$elem = array_search(
+						current($row),
+						$this->dumpSettings['include-tables']
+					);
+					unset($this->dumpSettings['include-tables'][$elem]);
+				}
+			}
+		}
+
+		// Listing all views from database
+		if (empty($this->dumpSettings['include-tables'])) {
+			// include all views for now, blacklisting happens later
+			foreach ($this->dbHandler->query($this->typeAdapter->show_views($this->db)) as $row) {
+				array_push($this->views, current($row));
+			}
+		} else {
+			// include only the tables mentioned in include-tables
+			foreach ($this->dbHandler->query($this->typeAdapter->show_views($this->db)) as $row) {
+				if (in_array(current($row), $this->dumpSettings['include-tables'], true)) {
+					array_push($this->views, current($row));
+					$elem = array_search(
+						current($row),
+						$this->dumpSettings['include-tables']
+					);
+					unset($this->dumpSettings['include-tables'][$elem]);
+				}
+			}
+		}
+
+		// Listing all triggers from database
+		if (false === $this->dumpSettings['skip-triggers']) {
+			foreach ($this->dbHandler->query($this->typeAdapter->show_triggers($this->db)) as $row) {
+				array_push($this->triggers, $row['Trigger']);
+			}
+		}
+	}
+
+	/**
+	 * Exports all the tables selected from database
+	 *
+	 * @return null
+	 */
+	private function exportTables()
+	{
+		// Exporting tables one by one
+		foreach ($this->tables as $table) {
+			if (in_array($table, $this->dumpSettings['exclude-tables'], true)) {
+				continue;
+			}
+			$this->getTableStructure($table);
+			if (false === $this->dumpSettings['no-data']) {
+				$this->listValues($table);
+			}
+		}
+	}
+
+	/**
+	 * Exports all the views found in database
+	 *
+	 * @return null
+	 */
+	private function exportViews()
+	{
+		if (false === $this->dumpSettings['no-create-info']) {
+			// Exporting views one by one
+			foreach ($this->views as $view) {
+				if (in_array($view, $this->dumpSettings['exclude-tables'], true)) {
+					continue;
+				}
+				$this->getViewStructure($view);
+			}
+		}
+	}
+
+	/**
+	 * Exports all the triggers found in database
+	 *
+	 * @return null
+	 */
+	private function exportTriggers()
+	{
+		// Exporting triggers one by one
+		foreach ($this->triggers as $trigger) {
+			$this->getTriggerStructure($trigger);
+		}
+	}
+
+
+	private function getTableStructure($tableName)
+	{
+		if (!$this->dumpSettings['no-create-info']) {
+			$ret = '';
+			if (!$this->dumpSettings['skip-comments']) {
+				$ret = "--" . PHP_EOL .
+					"-- Table structure for table `$tableName`" . PHP_EOL .
+					"--" . PHP_EOL . PHP_EOL;
+			}
+			$stmt = $this->typeAdapter->show_create_table($tableName);
+			foreach ($this->dbHandler->query($stmt) as $r) {
+				$this->compressManager->write($ret);
+				if ($this->dumpSettings['add-drop-table']) {
+					$this->compressManager->write(
+						$this->typeAdapter->drop_table($tableName)
+					);
+				}
+				$this->compressManager->write(
+					$this->typeAdapter->create_table($r, $this->dumpSettings)
+				);
+				break;
+			}
+		}
+
+		$columnTypes = array();
+		$columns = $this->dbHandler->query(
+			$this->typeAdapter->show_columns($tableName)
+		);
+		$columns->setFetchMode(PDO::FETCH_ASSOC);
+
+		foreach($columns as $key => $col) {
+			$types = $this->typeAdapter->parseColumnType($col);
+			$columnTypes[$col['Field']] = array(
+				'is_numeric'=> $types['is_numeric'],
+				'is_blob' => $types['is_blob'],
+				'type' => $types['type']
+			);
+		}
+		$this->tableColumnTypes[$tableName] = $columnTypes;
+		return;
+	}
+
+
+	private function getViewStructure($viewName)
+	{
+		$ret = '';
+		if (!$this->dumpSettings['skip-comments']) {
+			$ret = "--" . PHP_EOL .
+				"-- Table structure for view `${viewName}`" . PHP_EOL .
+				"--" . PHP_EOL . PHP_EOL;
+		}
+		$this->compressManager->write($ret);
+		$stmt = $this->typeAdapter->show_create_view($viewName);
+		foreach ($this->dbHandler->query($stmt) as $r) {
+			if ($this->dumpSettings['add-drop-table']) {
+				$this->compressManager->write(
+					$this->typeAdapter->drop_view($viewName)
+				);
+			}
+			$this->compressManager->write(
+				$this->typeAdapter->create_view($r)
+			);
+			break;
+		}
+	}
+
+	/**
+	 * Trigger structure extractor
+	 *
+	 * @param string $triggerName  Name of trigger to export
+	 * @return null
+	 */
+	private function getTriggerStructure($triggerName)
+	{
+		$stmt = $this->typeAdapter->show_create_trigger($triggerName);
+		foreach ($this->dbHandler->query($stmt) as $r) {
+			if ($this->dumpSettings['add-drop-trigger']) {
+				$this->compressManager->write(
+					$this->typeAdapter->add_drop_trigger($triggerName)
+				);
+			}
+			$this->compressManager->write(
+				$this->typeAdapter->create_trigger($r)
+			);
+			return;
+		}
+
+	}
+
+
+	/**
+	 * Escape values with quotes when needed
+	 *
+	 * @param string $tableName Name of table which contains rows
+	 * @param array $row Associative array of column names and values to be quoted
+	 *
+	 * @return string
+	 */
+	private function escape($tableName, $row)
+	{
+		$ret = array();
+		$columnTypes = $this->tableColumnTypes[$tableName];
+		foreach ($row as $colName => $colValue) {
+			if (is_null($colValue)) {
+				$ret[] = "NULL";
+			} elseif ($this->dumpSettings['hex-blob'] && $columnTypes[$colName]['is_blob']) {
+				if ($columnTypes[$colName]['type'] == 'bit' || !empty($colValue)) {
+					$ret[] = "0x${colValue}";
+				} else {
+					$ret[] = "''";
+				}
+			} elseif ($columnTypes[$colName]['is_numeric']) {
+				$ret[] = $colValue;
+			} else {
+				$ret[] = $this->dbHandler->quote($colValue);
+			}
+		}
+		return $ret;
+	}
+
+	/**
+	 * Table rows extractor
+	 *
+	 * @param string $tableName  Name of table to export
+	 *
+	 * @return null
+	 */
+	private function listValues($tableName)
+	{
+		$this->prepareListValues($tableName);
+
+		$onlyOnce = true;
+		$lineSize = 0;
+
+		$colStmt = $this->getColumnStmt($tableName);
+		$stmt = "SELECT $colStmt FROM `$tableName`";
+
+		if ($this->dumpSettings['where']) {
+			$stmt .= " WHERE {$this->dumpSettings['where']}";
+		}
+		$resultSet = $this->dbHandler->query($stmt);
+		$resultSet->setFetchMode(PDO::FETCH_ASSOC);
+
+		foreach ($resultSet as $row) {
+			$vals = $this->escape($tableName, $row);
+			if ($onlyOnce || !$this->dumpSettings['extended-insert']) {
+				$lineSize += $this->compressManager->write(
+					"INSERT INTO `$tableName` VALUES (" . implode(",", $vals) . ")"
+				);
+				$onlyOnce = false;
+			} else {
+				$lineSize += $this->compressManager->write(",(" . implode(",", $vals) . ")");
+			}
+			if (($lineSize > self::MAXLINESIZE) ||
+					!$this->dumpSettings['extended-insert']) {
+				$onlyOnce = true;
+				$lineSize = $this->compressManager->write(";" . PHP_EOL);
+			}
+		}
+		$resultSet->closeCursor();
+
+		if (!$onlyOnce) {
+			$this->compressManager->write(";" . PHP_EOL);
+		}
+
+		$this->endListValues($tableName);
+	}
+
+	/**
+	 * Table rows extractor, append information prior to dump
+	 *
+	 * @param string $tableName  Name of table to export
+	 *
+	 * @return null
+	 */
+	function prepareListValues($tableName)
+	{
+		if (!$this->dumpSettings['skip-comments']) {
+			$this->compressManager->write(
+				"--" . PHP_EOL .
+				"-- Dumping data for table `$tableName`" .  PHP_EOL .
+				"--" . PHP_EOL . PHP_EOL
+			);
+		}
+
+		if ($this->dumpSettings['single-transaction']) {
+			$this->dbHandler->exec($this->typeAdapter->setup_transaction());
+			$this->dbHandler->exec($this->typeAdapter->start_transaction());
+		}
+
+		if ($this->dumpSettings['lock-tables']) {
+			$this->typeAdapter->lock_table($tableName);
+		}
+
+		if ($this->dumpSettings['add-locks']) {
+			$this->compressManager->write(
+				$this->typeAdapter->start_add_lock_table($tableName)
+			);
+		}
+
+		if ($this->dumpSettings['disable-keys']) {
+			$this->compressManager->write(
+				$this->typeAdapter->start_add_disable_keys($tableName)
+			);
+		}
+
+		// Disable autocommit for faster reload
+		if ($this->dumpSettings['no-autocommit']) {
+			$this->compressManager->write(
+				$this->typeAdapter->start_disable_autocommit()
+			);
+		}
+
+		return;
+	}
+
+	/**
+	 * Table rows extractor, close locks and commits after dump
+	 *
+	 * @param string $tableName  Name of table to export
+	 *
+	 * @return null
+	 */
+	function endListValues($tableName)
+	{
+		if ($this->dumpSettings['disable-keys']) {
+			$this->compressManager->write(
+				$this->typeAdapter->end_add_disable_keys($tableName)
+			);
+		}
+
+		if ($this->dumpSettings['add-locks']) {
+			$this->compressManager->write(
+				$this->typeAdapter->end_add_lock_table($tableName)
+			);
+		}
+
+		if ($this->dumpSettings['single-transaction']) {
+			$this->dbHandler->exec($this->typeAdapter->commit_transaction());
+		}
+
+		if ($this->dumpSettings['lock-tables']) {
+			$this->typeAdapter->unlock_table($tableName);
+		}
+
+		// Commit to enable autocommit
+		if ($this->dumpSettings['no-autocommit']) {
+			$this->compressManager->write(
+				$this->typeAdapter->end_disable_autocommit()
+			);
+		}
+
+		$this->compressManager->write(PHP_EOL);
+
+		return;
+	}
+
+	/**
+	 * Build SQL List of all columns on current table
+	 *
+	 * @param string $tableName  Name of table to get columns
+	 *
+	 * @return string SQL sentence with columns
+	 */
+	function getColumnStmt($tableName)
+	{
+		$colStmt = array();
+		foreach($this->tableColumnTypes[$tableName] as $colName => $colType) {
+			if ($colType['type'] == 'bit' && $this->dumpSettings['hex-blob']) {
+				$colStmt[] = "LPAD(HEX(`${colName}`),2,'0') AS `${colName}`";
+			} else if ($colType['is_blob'] && $this->dumpSettings['hex-blob']) {
+				$colStmt[] = "HEX(`${colName}`) AS `${colName}`";
+			} else {
+				$colStmt[] = "`${colName}`";
+			}
+		}
+		$colStmt = implode($colStmt, ",");
+
+		return $colStmt;
+	}
 }
 
 /**
@@ -731,137 +731,137 @@ 
  */
 abstract class CompressMethod
 {
-    public static $enums = array(
-        "None",
-        "Gzip",
-        "Bzip2"
-    );
-
-    /**
-     * @param string $c
-     * @return boolean
-     */
-    public static function isValid($c)
-    {
-        return in_array($c, self::$enums);
-    }
+	public static $enums = array(
+		"None",
+		"Gzip",
+		"Bzip2"
+	);
+
+	/**
+	 * @param string $c
+	 * @return boolean
+	 */
+	public static function isValid($c)
+	{
+		return in_array($c, self::$enums);
+	}
 }
 
 abstract class CompressManagerFactory
 {
-    /**
-     * @param string $c
-     * @return CompressBzip2|CompressGzip|CompressNone
-     */
-    public static function create($c)
-    {
-        $c = ucfirst(strtolower($c));
-        if (! CompressMethod::isValid($c)) {
-            throw new Exception("Compression method ($c) is not defined yet");
-        }
-
-        $method =  __NAMESPACE__ . "\\" . "Compress" . $c;
-
-        return new $method;
-    }
+	/**
+	 * @param string $c
+	 * @return CompressBzip2|CompressGzip|CompressNone
+	 */
+	public static function create($c)
+	{
+		$c = ucfirst(strtolower($c));
+		if (! CompressMethod::isValid($c)) {
+			throw new Exception("Compression method ($c) is not defined yet");
+		}
+
+		$method =  __NAMESPACE__ . "\\" . "Compress" . $c;
+
+		return new $method;
+	}
 }
 
 class CompressBzip2 extends CompressManagerFactory
 {
-    private $fileHandler = null;
-
-    public function __construct()
-    {
-        if (! function_exists("bzopen")) {
-            throw new Exception("Compression is enabled, but bzip2 lib is not installed or configured properly");
-        }
-    }
-
-    public function open($filename)
-    {
-        $this->fileHandler = bzopen($filename, "w");
-        if (false === $this->fileHandler) {
-            throw new Exception("Output file is not writable");
-        }
-
-        return true;
-    }
-
-    public function write($str)
-    {
-        if (false === ($bytesWritten = bzwrite($this->fileHandler, $str))) {
-            throw new Exception("Writting to file failed! Probably, there is no more free space left?");
-        }
-        return $bytesWritten;
-    }
-
-    public function close()
-    {
-        return bzclose($this->fileHandler);
-    }
+	private $fileHandler = null;
+
+	public function __construct()
+	{
+		if (! function_exists("bzopen")) {
+			throw new Exception("Compression is enabled, but bzip2 lib is not installed or configured properly");
+		}
+	}
+
+	public function open($filename)
+	{
+		$this->fileHandler = bzopen($filename, "w");
+		if (false === $this->fileHandler) {
+			throw new Exception("Output file is not writable");
+		}
+
+		return true;
+	}
+
+	public function write($str)
+	{
+		if (false === ($bytesWritten = bzwrite($this->fileHandler, $str))) {
+			throw new Exception("Writting to file failed! Probably, there is no more free space left?");
+		}
+		return $bytesWritten;
+	}
+
+	public function close()
+	{
+		return bzclose($this->fileHandler);
+	}
 }
 
 class CompressGzip extends CompressManagerFactory
 {
-    private $fileHandler = null;
-
-    public function __construct()
-    {
-        if (! function_exists("gzopen")) {
-            throw new Exception("Compression is enabled, but gzip lib is not installed or configured properly");
-        }
-    }
-
-    public function open($filename)
-    {
-        $this->fileHandler = gzopen($filename, "wb");
-        if (false === $this->fileHandler) {
-            throw new Exception("Output file is not writable");
-        }
-
-        return true;
-    }
-
-    public function write($str)
-    {
-        if (false === ($bytesWritten = gzwrite($this->fileHandler, $str))) {
-            throw new Exception("Writting to file failed! Probably, there is no more free space left?");
-        }
-        return $bytesWritten;
-    }
-
-    public function close()
-    {
-        return gzclose($this->fileHandler);
-    }
+	private $fileHandler = null;
+
+	public function __construct()
+	{
+		if (! function_exists("gzopen")) {
+			throw new Exception("Compression is enabled, but gzip lib is not installed or configured properly");
+		}
+	}
+
+	public function open($filename)
+	{
+		$this->fileHandler = gzopen($filename, "wb");
+		if (false === $this->fileHandler) {
+			throw new Exception("Output file is not writable");
+		}
+
+		return true;
+	}
+
+	public function write($str)
+	{
+		if (false === ($bytesWritten = gzwrite($this->fileHandler, $str))) {
+			throw new Exception("Writting to file failed! Probably, there is no more free space left?");
+		}
+		return $bytesWritten;
+	}
+
+	public function close()
+	{
+		return gzclose($this->fileHandler);
+	}
 }
 
 class CompressNone extends CompressManagerFactory
 {
-    private $fileHandler = null;
-
-    public function open($filename)
-    {
-        $this->fileHandler = fopen($filename, "wb");
-        if (false === $this->fileHandler) {
-            throw new Exception("Output file is not writable");
-        }
-
-        return true;
-    }
-
-    public function write($str)
-    {
-        if (false === ($bytesWritten = fwrite($this->fileHandler, $str))) {
-            throw new Exception("Writting to file failed! Probably, there is no more free space left?");
-        }
-        return $bytesWritten;
-    }
-
-    public function close()
-    {
-        return fclose($this->fileHandler);
-    }
+	private $fileHandler = null;
+
+	public function open($filename)
+	{
+		$this->fileHandler = fopen($filename, "wb");
+		if (false === $this->fileHandler) {
+			throw new Exception("Output file is not writable");
+		}
+
+		return true;
+	}
+
+	public function write($str)
+	{
+		if (false === ($bytesWritten = fwrite($this->fileHandler, $str))) {
+			throw new Exception("Writting to file failed! Probably, there is no more free space left?");
+		}
+		return $bytesWritten;
+	}
+
+	public function close()
+	{
+		return fclose($this->fileHandler);
+	}
 }
 
 /**
@@ -870,19 +870,19 @@ 
  */
 abstract class TypeAdapter
 {
-    public static $enums = array(
-        "Sqlite",
-        "Mysql"
-    );
-
-    /**
-     * @param string $c
-     * @return boolean
-     */
-    public static function isValid($c)
-    {
-        return in_array($c, self::$enums);
-    }
+	public static $enums = array(
+		"Sqlite",
+		"Mysql"
+	);
+
+	/**
+	 * @param string $c
+	 * @return boolean
+	 */
+	public static function isValid($c)
+	{
+		return in_array($c, self::$enums);
+	}
 }
 
 /**
@@ -891,186 +891,186 @@ 
  */
 abstract class TypeAdapterFactory
 {
-    /**
-     * @param string $c Type of database factory to create (Mysql, Sqlite,...)
-     * @param PDO $dbHandler
-     */
-    public static function create($c, $dbHandler = null)
-    {
-        $c = ucfirst(strtolower($c));
-        if (! TypeAdapter::isValid($c)) {
-            throw new Exception("Database type support for ($c) not yet available");
-        }
-        $method =  __NAMESPACE__ . "\\" . "TypeAdapter" . $c;
-        return new $method($dbHandler);
-    }
-
-
-    public function databases()
-    {
-        return "";
-    }
-
-    public function show_create_table($tableName)
-    {
-        return "SELECT tbl_name as 'Table', sql as 'Create Table' " .
-            "FROM sqlite_master " .
-            "WHERE type='table' AND tbl_name='$tableName'";
-    }
-
-
-    public function create_table($row, $dumpSettings)
-    {
-        return "";
-    }
-
-    public function show_create_view($viewName)
-    {
-        return "SELECT tbl_name as 'View', sql as 'Create View' " .
-            "FROM sqlite_master " .
-            "WHERE type='view' AND tbl_name='$viewName'";
-    }
-
-
-    public function create_view($row)
-    {
-        return "";
-    }
-
-
-    public function show_create_trigger($triggerName)
-    {
-        return "";
-    }
-
-
-    public function create_trigger($triggerName)
-    {
-        return "";
-    }
-
-    public function show_tables()
-    {
-        return "SELECT tbl_name FROM sqlite_master WHERE type='table'";
-    }
-
-    public function show_views()
-    {
-        return "SELECT tbl_name FROM sqlite_master WHERE type='view'";
-    }
-
-    public function show_triggers()
-    {
-        return "SELECT name FROM sqlite_master WHERE type='trigger'";
-    }
-
-    public function show_columns()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "pragma table_info(${args[0]})";
-    }
-
-    public function setup_transaction()
-    {
-        return "";
-    }
-
-    public function start_transaction()
-    {
-        return "BEGIN EXCLUSIVE";
-    }
-
-    public function commit_transaction()
-    {
-        return "COMMIT";
-    }
-
-    public function lock_table()
-    {
-        return "";
-    }
-
-    public function unlock_table()
-    {
-        return "";
-    }
-
-    public function start_add_lock_table()
-    {
-        return PHP_EOL;
-    }
-
-    public function end_add_lock_table()
-    {
-        return PHP_EOL;
-    }
-
-    public function start_add_disable_keys()
-    {
-        return PHP_EOL;
-    }
-
-    public function end_add_disable_keys()
-    {
-        return PHP_EOL;
-    }
-
-    public function start_disable_foreign_keys_check()
-    {
-        return PHP_EOL;
-    }
-
-    public function end_disable_foreign_keys_check()
-    {
-        return PHP_EOL;
-    }
-
-    public function add_drop_database()
-    {
-        return PHP_EOL;
-    }
-
-    public function add_drop_trigger()
-    {
-        return PHP_EOL;
-    }
-
-    public function drop_table()
-    {
-        return PHP_EOL;
-    }
-
-    public function drop_view()
-    {
-        return PHP_EOL;
-    }
-
-    /**
-     * Decode column metadata and fill info structure.
-     * type, is_numeric and is_blob will always be available.
-     *
-     * @param array $colType Array returned from "SHOW COLUMNS FROM tableName"
-     * @return array
-     */
-    public function parseColumnType($colType)
-    {
-        return array();
-    }
-
-    public function backup_parameters()
-    {
-        return PHP_EOL;
-    }
-
-    public function restore_parameters()
-    {
-        return PHP_EOL;
-    }
+	/**
+	 * @param string $c Type of database factory to create (Mysql, Sqlite,...)
+	 * @param PDO $dbHandler
+	 */
+	public static function create($c, $dbHandler = null)
+	{
+		$c = ucfirst(strtolower($c));
+		if (! TypeAdapter::isValid($c)) {
+			throw new Exception("Database type support for ($c) not yet available");
+		}
+		$method =  __NAMESPACE__ . "\\" . "TypeAdapter" . $c;
+		return new $method($dbHandler);
+	}
+
+
+	public function databases()
+	{
+		return "";
+	}
+
+	public function show_create_table($tableName)
+	{
+		return "SELECT tbl_name as 'Table', sql as 'Create Table' " .
+			"FROM sqlite_master " .
+			"WHERE type='table' AND tbl_name='$tableName'";
+	}
+
+
+	public function create_table($row, $dumpSettings)
+	{
+		return "";
+	}
+
+	public function show_create_view($viewName)
+	{
+		return "SELECT tbl_name as 'View', sql as 'Create View' " .
+			"FROM sqlite_master " .
+			"WHERE type='view' AND tbl_name='$viewName'";
+	}
+
+
+	public function create_view($row)
+	{
+		return "";
+	}
+
+
+	public function show_create_trigger($triggerName)
+	{
+		return "";
+	}
+
+
+	public function create_trigger($triggerName)
+	{
+		return "";
+	}
+
+	public function show_tables()
+	{
+		return "SELECT tbl_name FROM sqlite_master WHERE type='table'";
+	}
+
+	public function show_views()
+	{
+		return "SELECT tbl_name FROM sqlite_master WHERE type='view'";
+	}
+
+	public function show_triggers()
+	{
+		return "SELECT name FROM sqlite_master WHERE type='trigger'";
+	}
+
+	public function show_columns()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "pragma table_info(${args[0]})";
+	}
+
+	public function setup_transaction()
+	{
+		return "";
+	}
+
+	public function start_transaction()
+	{
+		return "BEGIN EXCLUSIVE";
+	}
+
+	public function commit_transaction()
+	{
+		return "COMMIT";
+	}
+
+	public function lock_table()
+	{
+		return "";
+	}
+
+	public function unlock_table()
+	{
+		return "";
+	}
+
+	public function start_add_lock_table()
+	{
+		return PHP_EOL;
+	}
+
+	public function end_add_lock_table()
+	{
+		return PHP_EOL;
+	}
+
+	public function start_add_disable_keys()
+	{
+		return PHP_EOL;
+	}
+
+	public function end_add_disable_keys()
+	{
+		return PHP_EOL;
+	}
+
+	public function start_disable_foreign_keys_check()
+	{
+		return PHP_EOL;
+	}
+
+	public function end_disable_foreign_keys_check()
+	{
+		return PHP_EOL;
+	}
+
+	public function add_drop_database()
+	{
+		return PHP_EOL;
+	}
+
+	public function add_drop_trigger()
+	{
+		return PHP_EOL;
+	}
+
+	public function drop_table()
+	{
+		return PHP_EOL;
+	}
+
+	public function drop_view()
+	{
+		return PHP_EOL;
+	}
+
+	/**
+	 * Decode column metadata and fill info structure.
+	 * type, is_numeric and is_blob will always be available.
+	 *
+	 * @param array $colType Array returned from "SHOW COLUMNS FROM tableName"
+	 * @return array
+	 */
+	public function parseColumnType($colType)
+	{
+		return array();
+	}
+
+	public function backup_parameters()
+	{
+		return PHP_EOL;
+	}
+
+	public function restore_parameters()
+	{
+		return PHP_EOL;
+	}
 }
 
 class TypeAdapterPgsql extends TypeAdapterFactory
@@ -1088,421 +1088,421 @@ 
 class TypeAdapterMysql extends TypeAdapterFactory
 {
 
-    private $dbHandler = null;
-
-    // Numerical Mysql types
-    public $mysqlTypes = array(
-        'numerical' => array(
-            'bit',
-            'tinyint',
-            'smallint',
-            'mediumint',
-            'int',
-            'integer',
-            'bigint',
-            'real',
-            'double',
-            'float',
-            'decimal',
-            'numeric'
-        ),
-        'blob' => array(
-            'tinyblob',
-            'blob',
-            'mediumblob',
-            'longblob',
-            'binary',
-            'varbinary',
-            'bit'
-        )
-    );
-
-    public function __construct ($dbHandler)
-    {
-        $this->dbHandler = $dbHandler;
-    }
-
-    public function databases()
-    {
-        if (func_num_args() != 1) {
-            throw new Exception("Unexpected parameter passed to " . __METHOD__);
-        }
-
-        $args = func_get_args();
-        $databaseName = $args[0];
-
-        $resultSet = $this->dbHandler->query("SHOW VARIABLES LIKE 'character_set_database';");
-        $characterSet = $resultSet->fetchColumn(1);
-        $resultSet->closeCursor();
-
-        $resultSet = $this->dbHandler->query("SHOW VARIABLES LIKE 'collation_database';");
-        $collationDb = $resultSet->fetchColumn(1);
-        $resultSet->closeCursor();
-        $ret = "";
-
-        $ret .= "CREATE DATABASE /*!32312 IF NOT EXISTS*/ `${databaseName}`".
-            " /*!40100 DEFAULT CHARACTER SET ${characterSet} " .
-            " COLLATE ${collationDb} */;" . PHP_EOL . PHP_EOL .
-            "USE `${databaseName}`;" . PHP_EOL . PHP_EOL;
-
-        return $ret;
-    }
-
-    public function show_create_table($tableName)
-    {
-        return "SHOW CREATE TABLE `$tableName`";
-    }
-
-    public function show_create_view($viewName)
-    {
-        return "SHOW CREATE VIEW `$viewName`";
-    }
-
-    public function show_create_trigger($triggerName)
-    {
-        return "SHOW CREATE TRIGGER `$triggerName`";
-    }
-
-    public function create_table($row, $dumpSettings)
-    {
-        if (!isset($row['Create Table'])) {
-            throw new Exception("Error getting table code, unknown output");
-        }
-
-        $ret = "/*!40101 SET @saved_cs_client     = @@character_set_client */;" . PHP_EOL .
-            "/*!40101 SET character_set_client = " . $dumpSettings['default-character-set'] . " */;" . PHP_EOL .
-            $row['Create Table'] . ";" . PHP_EOL .
-            "/*!40101 SET character_set_client = @saved_cs_client */;" . PHP_EOL .
-            PHP_EOL;
-        return $ret;
-    }
-
-    public function create_view($row)
-    {
-        $ret = "";
-        if (!isset($row['Create View'])) {
-                throw new Exception("Error getting view structure, unknown output");
-        }
-
-        $triggerStmt = $row['Create View'];
-        $triggerStmtReplaced1 = str_replace(
-            "CREATE ALGORITHM",
-            "/*!50001 CREATE ALGORITHM",
-            $triggerStmt
-        );
-        $triggerStmtReplaced2 = str_replace(
-            " DEFINER=",
-            " */" . PHP_EOL . "/*!50013 DEFINER=",
-            $triggerStmtReplaced1
-        );
-        $triggerStmtReplaced3 = str_replace(
-            " VIEW ",
-            " */" . PHP_EOL . "/*!50001 VIEW ",
-            $triggerStmtReplaced2
-        );
-        if (false === $triggerStmtReplaced1 ||
-            false === $triggerStmtReplaced2 ||
-            false === $triggerStmtReplaced3) {
-            $triggerStmtReplaced = $triggerStmt;
-        } else {
-            $triggerStmtReplaced = $triggerStmtReplaced3 . " */;";
-        }
-
-        $ret .= $triggerStmtReplaced . PHP_EOL . PHP_EOL;
-        return $ret;
-    }
-
-    public function create_trigger($row)
-    {
-        $ret = "";
-        if (!isset($row['SQL Original Statement'])) {
-            throw new Exception("Error getting trigger code, unknown output");
-        }
-
-        $triggerStmt = $row['SQL Original Statement'];
-        $triggerStmtReplaced = str_replace(
-            "CREATE DEFINER",
-            "/*!50003 CREATE*/ /*!50017 DEFINER",
-            $triggerStmt
-        );
-        $triggerStmtReplaced = str_replace(
-            " TRIGGER",
-            "*/ /*!50003 TRIGGER",
-            $triggerStmtReplaced
-        );
-        if ( false === $triggerStmtReplaced ) {
-            $triggerStmtReplaced = $triggerStmt;
-        }
-
-        $ret .= "DELIMITER ;;" . PHP_EOL .
-            $triggerStmtReplaced . "*/;;" . PHP_EOL .
-            "DELIMITER ;" . PHP_EOL . PHP_EOL;
-        return $ret;
-    }
-
-    public function show_tables()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "SELECT TABLE_NAME AS tbl_name " .
-            "FROM INFORMATION_SCHEMA.TABLES " .
-            "WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='${args[0]}'";
-    }
-
-    public function show_views()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "SELECT TABLE_NAME AS tbl_name " .
-            "FROM INFORMATION_SCHEMA.TABLES " .
-            "WHERE TABLE_TYPE='VIEW' AND TABLE_SCHEMA='${args[0]}'";
-    }
-
-    public function show_triggers()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "SHOW TRIGGERS FROM `${args[0]}`;";
-    }
-
-
-    public function show_columns()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "SHOW COLUMNS FROM `${args[0]}`;";
-    }
-
-    public function setup_transaction()
-    {
-        return "SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ";
-    }
-
-    public function start_transaction()
-    {
-        return "START TRANSACTION";
-    }
-
-    public function commit_transaction()
-    {
-        return "COMMIT";
-    }
-
-    public function lock_table()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-        //$tableName = $args[0];
-        //return "LOCK TABLES `$tableName` READ LOCAL";
-        return $this->dbHandler->exec("LOCK TABLES `${args[0]}` READ LOCAL");
-
-    }
-
-    public function unlock_table()
-    {
-        return $this->dbHandler->exec("UNLOCK TABLES");
-    }
-
-    public function start_add_lock_table()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "LOCK TABLES `${args[0]}` WRITE;" . PHP_EOL;
-    }
-
-    public function end_add_lock_table()
-    {
-        return "UNLOCK TABLES;" . PHP_EOL;
-    }
-
-    public function start_add_disable_keys()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-        $args = func_get_args();
-        return "/*!40000 ALTER TABLE `${args[0]}` DISABLE KEYS */;" .
-            PHP_EOL;
-    }
-
-    public function end_add_disable_keys()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-        $args = func_get_args();
-        return "/*!40000 ALTER TABLE `${args[0]}` ENABLE KEYS */;" .
-            PHP_EOL;
-    }
-
-    public function start_disable_autocommit()
-    {
-        return "SET autocommit=0;" . PHP_EOL;
-    }
-
-    public function end_disable_autocommit()
-    {
-        return "COMMIT;" . PHP_EOL;
-    }
-
-    public function add_drop_database()
-    {
-        if (func_num_args() != 1) {
-             return "";
-        }
-
-        $args = func_get_args();
-
-        return "/*!40000 DROP DATABASE IF EXISTS `${args[0]}`*/;" .
-            PHP_EOL . PHP_EOL;
-    }
-
-    public function add_drop_trigger()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "DROP TRIGGER IF EXISTS `${args[0]}`;" . PHP_EOL;
-    }
-
-    public function drop_table()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "DROP TABLE IF EXISTS `${args[0]}`;" . PHP_EOL;
-    }
-
-    public function drop_view()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "DROP TABLE IF EXISTS `${args[0]}`;" . PHP_EOL .
-                "/*!50001 DROP VIEW IF EXISTS `${args[0]}`*/;" . PHP_EOL;
-    }
-
-    public function getDatabaseHeader()
-    {
-        if (func_num_args() != 1) {
-            return "";
-        }
-
-        $args = func_get_args();
-
-        return "--" . PHP_EOL .
-            "-- Current Database: `${args[0]}`" . PHP_EOL .
-            "--" . PHP_EOL . PHP_EOL;
-    }
-
-    /**
-     * Decode column metadata and fill info structure.
-     * type, is_numeric and is_blob will always be available.
-     *
-     * @param array $colType Array returned from "SHOW COLUMNS FROM tableName"
-     * @return array
-     */
-    public function parseColumnType($colType)
-    {
-        $colInfo = array();
-        $colParts = explode(" ", $colType['Type']);
-
-        if($fparen = strpos($colParts[0], "("))
-        {
-            $colInfo['type'] = substr($colParts[0], 0, $fparen);
-            $colInfo['length']  = str_replace(")", "", substr($colParts[0], $fparen+1));
-            $colInfo['attributes'] = isset($colParts[1]) ? $colParts[1] : NULL;
-        }
-        else
-        {
-            $colInfo['type'] = $colParts[0];
-        }
-        $colInfo['is_numeric'] = in_array($colInfo['type'], $this->mysqlTypes['numerical']);
-        $colInfo['is_blob'] = in_array($colInfo['type'], $this->mysqlTypes['blob']);
-
-        return $colInfo;
-    }
-
-    public function backup_parameters()
-    {
-        if (func_num_args() != 1) {
-            throw new Exception("Unexpected parameter passed to " . __METHOD__);
-        }
-
-        $args = func_get_args();
-        $dumpSettings = $args[0];
-        $ret = "/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;" . PHP_EOL .
-            "/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;" . PHP_EOL .
-            "/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;" . PHP_EOL .
-            "/*!40101 SET NAMES " . $dumpSettings['default-character-set'] . " */;" . PHP_EOL;
-
-        if (false === $dumpSettings['skip-tz-utz']) {
-            $ret .= "/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;" . PHP_EOL .
-                "/*!40103 SET TIME_ZONE='+00:00' */;" . PHP_EOL;
-        }
-
-        $ret .= "/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;" . PHP_EOL .
-            "/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;" . PHP_EOL .
-            "/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;" . PHP_EOL .
-            "/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;" . PHP_EOL .PHP_EOL;
-
-        return $ret;
-    }
-
-    public function restore_parameters()
-    {
-        if (func_num_args() != 1) {
-            throw new Exception("Unexpected parameter passed to " . __METHOD__);
-        }
-
-        $args = func_get_args();
-        $dumpSettings = $args[0];
-        $ret = "";
-
-        if (false === $dumpSettings['skip-tz-utz']) {
-            $ret .= "/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;" . PHP_EOL;
-        }
-
-        $ret .= "/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;" . PHP_EOL .
-            "/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;" . PHP_EOL .
-            "/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;" . PHP_EOL .
-            "/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;" . PHP_EOL .
-            "/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;" . PHP_EOL .
-            "/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;" . PHP_EOL .
-            "/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;" . PHP_EOL . PHP_EOL;
-
-        return $ret;
-    }
+	private $dbHandler = null;
+
+	// Numerical Mysql types
+	public $mysqlTypes = array(
+		'numerical' => array(
+			'bit',
+			'tinyint',
+			'smallint',
+			'mediumint',
+			'int',
+			'integer',
+			'bigint',
+			'real',
+			'double',
+			'float',
+			'decimal',
+			'numeric'
+		),
+		'blob' => array(
+			'tinyblob',
+			'blob',
+			'mediumblob',
+			'longblob',
+			'binary',
+			'varbinary',
+			'bit'
+		)
+	);
+
+	public function __construct ($dbHandler)
+	{
+		$this->dbHandler = $dbHandler;
+	}
+
+	public function databases()
+	{
+		if (func_num_args() != 1) {
+			throw new Exception("Unexpected parameter passed to " . __METHOD__);
+		}
+
+		$args = func_get_args();
+		$databaseName = $args[0];
+
+		$resultSet = $this->dbHandler->query("SHOW VARIABLES LIKE 'character_set_database';");
+		$characterSet = $resultSet->fetchColumn(1);
+		$resultSet->closeCursor();
+
+		$resultSet = $this->dbHandler->query("SHOW VARIABLES LIKE 'collation_database';");
+		$collationDb = $resultSet->fetchColumn(1);
+		$resultSet->closeCursor();
+		$ret = "";
+
+		$ret .= "CREATE DATABASE /*!32312 IF NOT EXISTS*/ `${databaseName}`".
+			" /*!40100 DEFAULT CHARACTER SET ${characterSet} " .
+			" COLLATE ${collationDb} */;" . PHP_EOL . PHP_EOL .
+			"USE `${databaseName}`;" . PHP_EOL . PHP_EOL;
+
+		return $ret;
+	}
+
+	public function show_create_table($tableName)
+	{
+		return "SHOW CREATE TABLE `$tableName`";
+	}
+
+	public function show_create_view($viewName)
+	{
+		return "SHOW CREATE VIEW `$viewName`";
+	}
+
+	public function show_create_trigger($triggerName)
+	{
+		return "SHOW CREATE TRIGGER `$triggerName`";
+	}
+
+	public function create_table($row, $dumpSettings)
+	{
+		if (!isset($row['Create Table'])) {
+			throw new Exception("Error getting table code, unknown output");
+		}
+
+		$ret = "/*!40101 SET @saved_cs_client     = @@character_set_client */;" . PHP_EOL .
+			"/*!40101 SET character_set_client = " . $dumpSettings['default-character-set'] . " */;" . PHP_EOL .
+			$row['Create Table'] . ";" . PHP_EOL .
+			"/*!40101 SET character_set_client = @saved_cs_client */;" . PHP_EOL .
+			PHP_EOL;
+		return $ret;
+	}
+
+	public function create_view($row)
+	{
+		$ret = "";
+		if (!isset($row['Create View'])) {
+				throw new Exception("Error getting view structure, unknown output");
+		}
+
+		$triggerStmt = $row['Create View'];
+		$triggerStmtReplaced1 = str_replace(
+			"CREATE ALGORITHM",
+			"/*!50001 CREATE ALGORITHM",
+			$triggerStmt
+		);
+		$triggerStmtReplaced2 = str_replace(
+			" DEFINER=",
+			" */" . PHP_EOL . "/*!50013 DEFINER=",
+			$triggerStmtReplaced1
+		);
+		$triggerStmtReplaced3 = str_replace(
+			" VIEW ",
+			" */" . PHP_EOL . "/*!50001 VIEW ",
+			$triggerStmtReplaced2
+		);
+		if (false === $triggerStmtReplaced1 ||
+			false === $triggerStmtReplaced2 ||
+			false === $triggerStmtReplaced3) {
+			$triggerStmtReplaced = $triggerStmt;
+		} else {
+			$triggerStmtReplaced = $triggerStmtReplaced3 . " */;";
+		}
+
+		$ret .= $triggerStmtReplaced . PHP_EOL . PHP_EOL;
+		return $ret;
+	}
+
+	public function create_trigger($row)
+	{
+		$ret = "";
+		if (!isset($row['SQL Original Statement'])) {
+			throw new Exception("Error getting trigger code, unknown output");
+		}
+
+		$triggerStmt = $row['SQL Original Statement'];
+		$triggerStmtReplaced = str_replace(
+			"CREATE DEFINER",
+			"/*!50003 CREATE*/ /*!50017 DEFINER",
+			$triggerStmt
+		);
+		$triggerStmtReplaced = str_replace(
+			" TRIGGER",
+			"*/ /*!50003 TRIGGER",
+			$triggerStmtReplaced
+		);
+		if ( false === $triggerStmtReplaced ) {
+			$triggerStmtReplaced = $triggerStmt;
+		}
+
+		$ret .= "DELIMITER ;;" . PHP_EOL .
+			$triggerStmtReplaced . "*/;;" . PHP_EOL .
+			"DELIMITER ;" . PHP_EOL . PHP_EOL;
+		return $ret;
+	}
+
+	public function show_tables()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "SELECT TABLE_NAME AS tbl_name " .
+			"FROM INFORMATION_SCHEMA.TABLES " .
+			"WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='${args[0]}'";
+	}
+
+	public function show_views()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "SELECT TABLE_NAME AS tbl_name " .
+			"FROM INFORMATION_SCHEMA.TABLES " .
+			"WHERE TABLE_TYPE='VIEW' AND TABLE_SCHEMA='${args[0]}'";
+	}
+
+	public function show_triggers()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "SHOW TRIGGERS FROM `${args[0]}`;";
+	}
+
+
+	public function show_columns()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "SHOW COLUMNS FROM `${args[0]}`;";
+	}
+
+	public function setup_transaction()
+	{
+		return "SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ";
+	}
+
+	public function start_transaction()
+	{
+		return "START TRANSACTION";
+	}
+
+	public function commit_transaction()
+	{
+		return "COMMIT";
+	}
+
+	public function lock_table()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+		//$tableName = $args[0];
+		//return "LOCK TABLES `$tableName` READ LOCAL";
+		return $this->dbHandler->exec("LOCK TABLES `${args[0]}` READ LOCAL");
+
+	}
+
+	public function unlock_table()
+	{
+		return $this->dbHandler->exec("UNLOCK TABLES");
+	}
+
+	public function start_add_lock_table()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "LOCK TABLES `${args[0]}` WRITE;" . PHP_EOL;
+	}
+
+	public function end_add_lock_table()
+	{
+		return "UNLOCK TABLES;" . PHP_EOL;
+	}
+
+	public function start_add_disable_keys()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+		$args = func_get_args();
+		return "/*!40000 ALTER TABLE `${args[0]}` DISABLE KEYS */;" .
+			PHP_EOL;
+	}
+
+	public function end_add_disable_keys()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+		$args = func_get_args();
+		return "/*!40000 ALTER TABLE `${args[0]}` ENABLE KEYS */;" .
+			PHP_EOL;
+	}
+
+	public function start_disable_autocommit()
+	{
+		return "SET autocommit=0;" . PHP_EOL;
+	}
+
+	public function end_disable_autocommit()
+	{
+		return "COMMIT;" . PHP_EOL;
+	}
+
+	public function add_drop_database()
+	{
+		if (func_num_args() != 1) {
+			 return "";
+		}
+
+		$args = func_get_args();
+
+		return "/*!40000 DROP DATABASE IF EXISTS `${args[0]}`*/;" .
+			PHP_EOL . PHP_EOL;
+	}
+
+	public function add_drop_trigger()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "DROP TRIGGER IF EXISTS `${args[0]}`;" . PHP_EOL;
+	}
+
+	public function drop_table()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "DROP TABLE IF EXISTS `${args[0]}`;" . PHP_EOL;
+	}
+
+	public function drop_view()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "DROP TABLE IF EXISTS `${args[0]}`;" . PHP_EOL .
+				"/*!50001 DROP VIEW IF EXISTS `${args[0]}`*/;" . PHP_EOL;
+	}
+
+	public function getDatabaseHeader()
+	{
+		if (func_num_args() != 1) {
+			return "";
+		}
+
+		$args = func_get_args();
+
+		return "--" . PHP_EOL .
+			"-- Current Database: `${args[0]}`" . PHP_EOL .
+			"--" . PHP_EOL . PHP_EOL;
+	}
+
+	/**
+	 * Decode column metadata and fill info structure.
+	 * type, is_numeric and is_blob will always be available.
+	 *
+	 * @param array $colType Array returned from "SHOW COLUMNS FROM tableName"
+	 * @return array
+	 */
+	public function parseColumnType($colType)
+	{
+		$colInfo = array();
+		$colParts = explode(" ", $colType['Type']);
+
+		if($fparen = strpos($colParts[0], "("))
+		{
+			$colInfo['type'] = substr($colParts[0], 0, $fparen);
+			$colInfo['length']  = str_replace(")", "", substr($colParts[0], $fparen+1));
+			$colInfo['attributes'] = isset($colParts[1]) ? $colParts[1] : NULL;
+		}
+		else
+		{
+			$colInfo['type'] = $colParts[0];
+		}
+		$colInfo['is_numeric'] = in_array($colInfo['type'], $this->mysqlTypes['numerical']);
+		$colInfo['is_blob'] = in_array($colInfo['type'], $this->mysqlTypes['blob']);
+
+		return $colInfo;
+	}
+
+	public function backup_parameters()
+	{
+		if (func_num_args() != 1) {
+			throw new Exception("Unexpected parameter passed to " . __METHOD__);
+		}
+
+		$args = func_get_args();
+		$dumpSettings = $args[0];
+		$ret = "/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;" . PHP_EOL .
+			"/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;" . PHP_EOL .
+			"/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;" . PHP_EOL .
+			"/*!40101 SET NAMES " . $dumpSettings['default-character-set'] . " */;" . PHP_EOL;
+
+		if (false === $dumpSettings['skip-tz-utz']) {
+			$ret .= "/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;" . PHP_EOL .
+				"/*!40103 SET TIME_ZONE='+00:00' */;" . PHP_EOL;
+		}
+
+		$ret .= "/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;" . PHP_EOL .
+			"/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;" . PHP_EOL .
+			"/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;" . PHP_EOL .
+			"/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;" . PHP_EOL .PHP_EOL;
+
+		return $ret;
+	}
+
+	public function restore_parameters()
+	{
+		if (func_num_args() != 1) {
+			throw new Exception("Unexpected parameter passed to " . __METHOD__);
+		}
+
+		$args = func_get_args();
+		$dumpSettings = $args[0];
+		$ret = "";
+
+		if (false === $dumpSettings['skip-tz-utz']) {
+			$ret .= "/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;" . PHP_EOL;
+		}
+
+		$ret .= "/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;" . PHP_EOL .
+			"/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;" . PHP_EOL .
+			"/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;" . PHP_EOL .
+			"/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;" . PHP_EOL .
+			"/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;" . PHP_EOL .
+			"/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;" . PHP_EOL .
+			"/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;" . PHP_EOL . PHP_EOL;
+
+		return $ret;
+	}
 }