NuBOXDevCom / Database-Backup

src/System.php

Indentation +209 added lines, -209 removed lines

@@ -4,10 +4,10 @@ 
 
 use const DIRECTORY_SEPARATOR;
 use function {
-    dirname, getenv
+	dirname, getenv
 };
 use Dotenv\{
-    Dotenv, Validator
+	Dotenv, Validator
 };
 use Exception;
 use Ifsnop\Mysqldump\Mysqldump;
@@ -25,228 +25,228 @@ 
  */
 class System
 {
-    /**
-     * @var Dotenv
-     */
-    protected $env;
-    /**
-     * @var array
-     */
-    protected $errors = [];
-    /**
-     * @var bool
-     */
-    protected $isCli = false;
-    /**
-     * @var array
-     */
-    protected $files = [];
-    /**
-     * @var Lang
-     */
-    protected $l10n;
+	/**
+	 * @var Dotenv
+	 */
+	protected $env;
+	/**
+	 * @var array
+	 */
+	protected $errors = [];
+	/**
+	 * @var bool
+	 */
+	protected $isCli = false;
+	/**
+	 * @var array
+	 */
+	protected $files = [];
+	/**
+	 * @var Lang
+	 */
+	protected $l10n;
 
-    /**
-     * @var self|null
-     */
-    private static $_instance;
+	/**
+	 * @var self|null
+	 */
+	private static $_instance;
 
-    /**
-     * @return self|null
-     */
-    public static function getInstance(): ?self
-    {
+	/**
+	 * @return self|null
+	 */
+	public static function getInstance(): ?self
+	{
 
-        if (self::$_instance === null) {
-            self::$_instance = new self;
-        }
-        return self::$_instance;
-    }
+		if (self::$_instance === null) {
+			self::$_instance = new self;
+		}
+		return self::$_instance;
+	}
 
-    /**
-     * System constructor.
-     */
-    private function __construct()
-    {
-        $this->isCli = PHP_SAPI === 'cli';
-        try {
-            $this->loadConfigurationEnvironment();
-        } catch (\JBZoo\Lang\Exception $e) {
-            throw new RuntimeException($e);
-        } catch (\JBZoo\Path\Exception $e) {
-            throw new RuntimeException($e);
-        }
-        FileManager::getInstance();
-    }
+	/**
+	 * System constructor.
+	 */
+	private function __construct()
+	{
+		$this->isCli = PHP_SAPI === 'cli';
+		try {
+			$this->loadConfigurationEnvironment();
+		} catch (\JBZoo\Lang\Exception $e) {
+			throw new RuntimeException($e);
+		} catch (\JBZoo\Path\Exception $e) {
+			throw new RuntimeException($e);
+		}
+		FileManager::getInstance();
+	}
 
-    /**
-     * Start System initialization
-     * @return void
-     * @throws RuntimeException
-     * @throws \JBZoo\Lang\Exception
-     * @throws \JBZoo\Path\Exception
-     */
-    public function loadConfigurationEnvironment(): void
-    {
-        if (!file_exists(dirname(__DIR__) . DIRECTORY_SEPARATOR . '.env')) {
-            throw new RuntimeException('Please configure this script with .env file');
-        }
-        $this->env = Dotenv::create(dirname(__DIR__));
-        $this->env->overload();
-        $this->checkRequirements();
-        $this->l10n = new Lang(env('LANGUAGE', 'en'));
-        $this->l10n->load(dirname(__DIR__) . DIRECTORY_SEPARATOR . 'i18n', null, 'yml');
-        if (!$this->isCli && !(bool)getenv('ALLOW_EXECUTE_IN_WEB_BROWSER')) {
-            die($this->l10n->translate('unauthorized_browser'));
-        }
-        if ((PHP_MAJOR_VERSION . PHP_MINOR_VERSION) < 72) {
-            die($this->l10n->translate('unsupported_php_version'));
-        }
-    }
+	/**
+	 * Start System initialization
+	 * @return void
+	 * @throws RuntimeException
+	 * @throws \JBZoo\Lang\Exception
+	 * @throws \JBZoo\Path\Exception
+	 */
+	public function loadConfigurationEnvironment(): void
+	{
+		if (!file_exists(dirname(__DIR__) . DIRECTORY_SEPARATOR . '.env')) {
+			throw new RuntimeException('Please configure this script with .env file');
+		}
+		$this->env = Dotenv::create(dirname(__DIR__));
+		$this->env->overload();
+		$this->checkRequirements();
+		$this->l10n = new Lang(env('LANGUAGE', 'en'));
+		$this->l10n->load(dirname(__DIR__) . DIRECTORY_SEPARATOR . 'i18n', null, 'yml');
+		if (!$this->isCli && !(bool)getenv('ALLOW_EXECUTE_IN_WEB_BROWSER')) {
+			die($this->l10n->translate('unauthorized_browser'));
+		}
+		if ((PHP_MAJOR_VERSION . PHP_MINOR_VERSION) < 72) {
+			die($this->l10n->translate('unsupported_php_version'));
+		}
+	}
 
-    /**
-     * @return Validator
-     */
-    private function checkRequirements(): Validator
-    {
-        return $this->env->required([
-            'DB_HOST',
-            'DB_USER',
-            'DB_PASSWORD',
-            'MAIL_FROM',
-            'MAIL_FROM_NAME',
-            'MAIL_TO',
-            'MAIL_TO_NAME',
-            'MAIL_SEND_ON_ERROR',
-            'MAIL_SEND_ON_SUCCESS',
-            'MAIL_SMTP_HOST',
-            'MAIL_SMTP_PORT',
-            'FILES_DAYS_HISTORY',
-            'FILES_PATH_TO_SAVE_BACKUP',
-            'LANGUAGE',
-            'ALLOW_EXECUTE_IN_WEB_BROWSER'
-        ])->notEmpty();
-    }
+	/**
+	 * @return Validator
+	 */
+	private function checkRequirements(): Validator
+	{
+		return $this->env->required([
+			'DB_HOST',
+			'DB_USER',
+			'DB_PASSWORD',
+			'MAIL_FROM',
+			'MAIL_FROM_NAME',
+			'MAIL_TO',
+			'MAIL_TO_NAME',
+			'MAIL_SEND_ON_ERROR',
+			'MAIL_SEND_ON_SUCCESS',
+			'MAIL_SMTP_HOST',
+			'MAIL_SMTP_PORT',
+			'FILES_DAYS_HISTORY',
+			'FILES_PATH_TO_SAVE_BACKUP',
+			'LANGUAGE',
+			'ALLOW_EXECUTE_IN_WEB_BROWSER'
+		])->notEmpty();
+	}
 
-    /**
-     * @return array|string
-     */
-    private function getExcludedDatabases()
-    {
-        if (empty(trim(getenv('DB_EXCLUDE_DATABASES')))) {
-            return [];
-        }
-        return $this->parseAndSanitize(getenv('DB_EXCLUDE_DATABASES'));
-    }
+	/**
+	 * @return array|string
+	 */
+	private function getExcludedDatabases()
+	{
+		if (empty(trim(getenv('DB_EXCLUDE_DATABASES')))) {
+			return [];
+		}
+		return $this->parseAndSanitize(getenv('DB_EXCLUDE_DATABASES'));
+	}
 
-    /**
-     * @return array
-     */
-    private function getDatabases(): array
-    {
-        $pdo = new PDO('mysql:host=' . getenv('DB_HOST') . ';charset=UTF8', getenv('DB_USER'), getenv('DB_PASSWORD'), [
-            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
-            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
-        ]);
-        return $pdo->query('SHOW DATABASES')->fetchAll();
-    }
+	/**
+	 * @return array
+	 */
+	private function getDatabases(): array
+	{
+		$pdo = new PDO('mysql:host=' . getenv('DB_HOST') . ';charset=UTF8', getenv('DB_USER'), getenv('DB_PASSWORD'), [
+			PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
+			PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
+		]);
+		return $pdo->query('SHOW DATABASES')->fetchAll();
+	}
 
-    /**
-     * Process to backup databases
-     */
-    public function processBackup(): void
-    {
-        foreach ($this->getDatabases() as $database) {
-            if (!\in_array($database->Database, $this->getExcludedDatabases(), true)) {
-                $file_format = $database->Database . '-' . date($this->l10n->translate('date_format')) . '.sql';
-                try {
-                    $dumper = new Mysqldump('mysql:host=' . env('DB_HOST',
-                            'localhost') . ';dbname=' . $database->Database . ';charset=UTF8',
-                        env('DB_USER', 'root'), env('DB_PASSWORD', ''));
-                    $dumper->start(env('FILES_PATH_TO_SAVE_BACKUP', './Backups') . DIRECTORY_SEPARATOR . $file_format);
-                    $this->files[] = env('FILES_PATH_TO_SAVE_BACKUP', './Backups') . DIRECTORY_SEPARATOR . $file_format;
-                } catch (Exception $e) {
-                    $this->errors[] = [
-                        'dbname' => $database->Database,
-                        'error_message' => $e->getMessage(),
-                        'error_code' => $e->getCode()
-                    ];
-                }
-            }
-        }
-        $this->sendMail();
-    }
+	/**
+	 * Process to backup databases
+	 */
+	public function processBackup(): void
+	{
+		foreach ($this->getDatabases() as $database) {
+			if (!\in_array($database->Database, $this->getExcludedDatabases(), true)) {
+				$file_format = $database->Database . '-' . date($this->l10n->translate('date_format')) . '.sql';
+				try {
+					$dumper = new Mysqldump('mysql:host=' . env('DB_HOST',
+							'localhost') . ';dbname=' . $database->Database . ';charset=UTF8',
+						env('DB_USER', 'root'), env('DB_PASSWORD', ''));
+					$dumper->start(env('FILES_PATH_TO_SAVE_BACKUP', './Backups') . DIRECTORY_SEPARATOR . $file_format);
+					$this->files[] = env('FILES_PATH_TO_SAVE_BACKUP', './Backups') . DIRECTORY_SEPARATOR . $file_format;
+				} catch (Exception $e) {
+					$this->errors[] = [
+						'dbname' => $database->Database,
+						'error_message' => $e->getMessage(),
+						'error_code' => $e->getCode()
+					];
+				}
+			}
+		}
+		$this->sendMail();
+	}
 
-    /**
-     * @param string $data
-     * @return array|string
-     */
-    private function parseAndSanitize(string $data)
-    {
-        $results = explode(',', $data);
-        if (\count($results) > 1) {
-            foreach ($results as $k => $v) {
-                $results[$k] = trim($v);
-                if (empty($v)) {
-                    unset($results[$k]);
-                }
-            }
-            return $results;
-        }
-        return trim($results[0]);
-    }
+	/**
+	 * @param string $data
+	 * @return array|string
+	 */
+	private function parseAndSanitize(string $data)
+	{
+		$results = explode(',', $data);
+		if (\count($results) > 1) {
+			foreach ($results as $k => $v) {
+				$results[$k] = trim($v);
+				if (empty($v)) {
+					unset($results[$k]);
+				}
+			}
+			return $results;
+		}
+		return trim($results[0]);
+	}
 
-    /**
-     * Send a mail if error or success backup database
-     */
-    private function sendMail(): void
-    {
-        $smtpTransport = new Swift_SmtpTransport(env('MAIL_SMTP_HOST', 'localhost'), env('MAIL_SMTP_PORT', 25));
-        $smtpTransport->setUsername(env('MAIL_SMTP_USER', ''))->setPassword(env('MAIL_SMTP_PASSWORD', ''));
-        $mailer = new Swift_Mailer($smtpTransport);
-        if (empty($this->errors)) {
-            if ((bool)env('MAIL_SEND_ON_SUCCESS', false)) {
-                $body = "<strong>{$this->l10n->translate('mail_db_backup_successfull')}</strong>";
-                if ((bool)env('MAIL_SEND_WITH_BACKUP_FILE', false)) {
-                    $body .= "<br><br>{$this->l10n->translate('mail_db_backup_file')}";
-                }
-                $message = (new Swift_Message($this->l10n->translate('mail_subject_on_success')))->setFrom(env('MAIL_FROM',
-                    'system@my.website'),
-                    env('MAIL_FROM_NAME', 'Website Mailer for Database Backup'))
-                    ->setTo(env('MAIL_TO'),
-                        env('MAIL_TO_NAME', 'Webmaster of my website'))
-                    ->setBody($body)
-                    ->setCharset('utf-8')
-                    ->setContentType('text/html');
-                if ((bool)getenv('MAIL_SEND_WITH_BACKUP_FILE')) {
-                    foreach ($this->files as $file) {
-                        $attachment = Swift_Attachment::fromPath($file)->setContentType('application/sql');
-                        $message->attach($attachment);
-                    }
-                }
-                $mailer->send($message);
-            }
-        } elseif ((bool)env('MAIL_SEND_ON_ERROR', false)) {
-            $body = "<strong>{$this->l10n->translate('mail_db_backup_failed')}}:</strong><br><br><ul>";
-            foreach ($this->errors as $error) {
-                $body .= "<li>
+	/**
+	 * Send a mail if error or success backup database
+	 */
+	private function sendMail(): void
+	{
+		$smtpTransport = new Swift_SmtpTransport(env('MAIL_SMTP_HOST', 'localhost'), env('MAIL_SMTP_PORT', 25));
+		$smtpTransport->setUsername(env('MAIL_SMTP_USER', ''))->setPassword(env('MAIL_SMTP_PASSWORD', ''));
+		$mailer = new Swift_Mailer($smtpTransport);
+		if (empty($this->errors)) {
+			if ((bool)env('MAIL_SEND_ON_SUCCESS', false)) {
+				$body = "<strong>{$this->l10n->translate('mail_db_backup_successfull')}</strong>";
+				if ((bool)env('MAIL_SEND_WITH_BACKUP_FILE', false)) {
+					$body .= "<br><br>{$this->l10n->translate('mail_db_backup_file')}";
+				}
+				$message = (new Swift_Message($this->l10n->translate('mail_subject_on_success')))->setFrom(env('MAIL_FROM',
+					'system@my.website'),
+					env('MAIL_FROM_NAME', 'Website Mailer for Database Backup'))
+					->setTo(env('MAIL_TO'),
+						env('MAIL_TO_NAME', 'Webmaster of my website'))
+					->setBody($body)
+					->setCharset('utf-8')
+					->setContentType('text/html');
+				if ((bool)getenv('MAIL_SEND_WITH_BACKUP_FILE')) {
+					foreach ($this->files as $file) {
+						$attachment = Swift_Attachment::fromPath($file)->setContentType('application/sql');
+						$message->attach($attachment);
+					}
+				}
+				$mailer->send($message);
+			}
+		} elseif ((bool)env('MAIL_SEND_ON_ERROR', false)) {
+			$body = "<strong>{$this->l10n->translate('mail_db_backup_failed')}}:</strong><br><br><ul>";
+			foreach ($this->errors as $error) {
+				$body .= "<li>
                         <ul>
                             <li>{$this->l10n->translate('database')}: {$error['dbname']}</li>
                             <li>{$this->l10n->translate('error_code')}: {$error['error_code']}</li>
                             <li>{$this->l10n->translate('error_message')}: {$error['error_message']}</li>
                         </ul>
                        </li>";
-            }
-            $body .= '</ul>';
-            $message = (new Swift_Message($this->l10n->translate('mail_subject_on_error')))->setFrom(env('MAIL_FROM',
-                'system@my.website'),
-                env('MAIL_FROM_NAME', 'Website Mailer for Database Backup'))
-                ->setTo(env('MAIL_TO'),
-                    env('MAIL_TO_NAME', 'Webmaster of my website'))
-                ->setBody($body)
-                ->setCharset('utf-8')
-                ->setContentType('text/html');
-            $mailer->send($message);
-        }
-    }
+			}
+			$body .= '</ul>';
+			$message = (new Swift_Message($this->l10n->translate('mail_subject_on_error')))->setFrom(env('MAIL_FROM',
+				'system@my.website'),
+				env('MAIL_FROM_NAME', 'Website Mailer for Database Backup'))
+				->setTo(env('MAIL_TO'),
+					env('MAIL_TO_NAME', 'Webmaster of my website'))
+				->setBody($body)
+				->setCharset('utf-8')
+				->setContentType('text/html');
+			$mailer->send($message);
+		}
+	}
 }

src/FileManager.php

Indentation +63 added lines, -63 removed lines

@@ -8,72 +8,72 @@
  */
 class FileManager
 {
-    /**
-     * @var array
-     */
-    private $params;
-    /**
-     * @var array
-     */
-    private $files = [];
-    /**
-     * @var self
-     */
-    private static $_instance;
+	/**
+	 * @var array
+	 */
+	private $params;
+	/**
+	 * @var array
+	 */
+	private $files = [];
+	/**
+	 * @var self
+	 */
+	private static $_instance;
 
-    /**
-     * @return FileManager|null
-     */
-    public static function getInstance(): ?self
-    {
+	/**
+	 * @return FileManager|null
+	 */
+	public static function getInstance(): ?self
+	{
 
-        if (self::$_instance === null) {
-            self::$_instance = new self;
-        }
-        return self::$_instance;
-    }
+		if (self::$_instance === null) {
+			self::$_instance = new self;
+		}
+		return self::$_instance;
+	}
 
-    /**
-     * FileManager constructor.
-     */
-    public function __construct()
-    {
-        System::getInstance();
-        $this->params = [
-            'files_path' => env('FILES_PATH_TO_SAVE_BACKUP', './Backups'),
-            'days_interval' => env('FILES_DAYS_HISTORY', 3)
-        ];
-        $this->_getFiles();
-        env('FILES_DAYS_HISTORY', 3) > 0 ?: $this->removeOldFilesByIntervalDays();
-    }
+	/**
+	 * FileManager constructor.
+	 */
+	public function __construct()
+	{
+		System::getInstance();
+		$this->params = [
+			'files_path' => env('FILES_PATH_TO_SAVE_BACKUP', './Backups'),
+			'days_interval' => env('FILES_DAYS_HISTORY', 3)
+		];
+		$this->_getFiles();
+		env('FILES_DAYS_HISTORY', 3) > 0 ?: $this->removeOldFilesByIntervalDays();
+	}
 
-    /**
-     * @return void
-     */
-    private function _getFiles(): void
-    {
-        $files = scandir($this->params['files_path'], SCANDIR_SORT_ASCENDING);
-        $this->files = array_filter($files, function ($k) {
-            $return = [];
-            if ($k !== '..' && $k !== '.') {
-                $return[] = $k;
-            }
-            return $return;
-        });
-    }
+	/**
+	 * @return void
+	 */
+	private function _getFiles(): void
+	{
+		$files = scandir($this->params['files_path'], SCANDIR_SORT_ASCENDING);
+		$this->files = array_filter($files, function ($k) {
+			$return = [];
+			if ($k !== '..' && $k !== '.') {
+				$return[] = $k;
+			}
+			return $return;
+		});
+	}
 
-    /**
-     * @return void
-     */
-    private function removeOldFilesByIntervalDays(): void
-    {
-        $time_before = time() - $this->params['days_interval'] * 86400;
-        foreach ($this->files as $file) {
-            $f = explode('-', $file);
-            $f = str_replace('.sql', '', $f);
-            if ($f[1] < $time_before) {
-                @unlink($this->params['files_path'] . '/' . $file);
-            }
-        }
-    }
+	/**
+	 * @return void
+	 */
+	private function removeOldFilesByIntervalDays(): void
+	{
+		$time_before = time() - $this->params['days_interval'] * 86400;
+		foreach ($this->files as $file) {
+			$f = explode('-', $file);
+			$f = str_replace('.sql', '', $f);
+			if ($f[1] < $time_before) {
+				@unlink($this->params['files_path'] . '/' . $file);
+			}
+		}
+	}
 }

Spacing +1 added lines, -1 removed lines

@@ -53,7 +53,7 @@
     private function _getFiles(): void
     {
         $files = scandir($this->params['files_path'], SCANDIR_SORT_ASCENDING);
-        $this->files = array_filter($files, function ($k) {
+        $this->files = array_filter($files, function($k) {
             $return = [];
             if ($k !== '..' && $k !== '.') {
                 $return[] = $k;

src/helpers.php

Indentation +44 added lines, -44 removed lines

@@ -1,48 +1,48 @@
 <?php
 if (!function_exists('env')) {
-    /**
-     * Gets the value of an environment variable.
-     *
-     * @param  string $key
-     * @param  mixed $default
-     * @return mixed
-     */
-    function env(string $key, $default = null)
-    {
-        $value = getenv($key);
-        if ($value === false) {
-            return value($default);
-        }
-        switch (strtolower($value)) {
-            case 'true':
-            case '(true)':
-                return true;
-            case 'false':
-            case '(false)':
-                return false;
-            case 'empty':
-            case '(empty)':
-                return '';
-            case 'null':
-            case '(null)':
-                return null;
-        }
-        if (($valueLength = strlen($value)) > 1 && strpos($value, '"') === 0 && $value[$valueLength - 1] === '"') {
-            return substr($value, 1, -1);
-        }
-        return $value;
-    }
+	/**
+	 * Gets the value of an environment variable.
+	 *
+	 * @param  string $key
+	 * @param  mixed $default
+	 * @return mixed
+	 */
+	function env(string $key, $default = null)
+	{
+		$value = getenv($key);
+		if ($value === false) {
+			return value($default);
+		}
+		switch (strtolower($value)) {
+			case 'true':
+			case '(true)':
+				return true;
+			case 'false':
+			case '(false)':
+				return false;
+			case 'empty':
+			case '(empty)':
+				return '';
+			case 'null':
+			case '(null)':
+				return null;
+		}
+		if (($valueLength = strlen($value)) > 1 && strpos($value, '"') === 0 && $value[$valueLength - 1] === '"') {
+			return substr($value, 1, -1);
+		}
+		return $value;
+	}
 
-    if (!function_exists('value')) {
-        /**
-         * Return the default value of the given value.
-         *
-         * @param  mixed $value
-         * @return mixed
-         */
-        function value($value)
-        {
-            return $value instanceof Closure ? $value() : $value;
-        }
-    }
+	if (!function_exists('value')) {
+		/**
+		 * Return the default value of the given value.
+		 *
+		 * @param  mixed $value
+		 * @return mixed
+		 */
+		function value($value)
+		{
+			return $value instanceof Closure ? $value() : $value;
+		}
+	}
 }
\ No newline at end of file