Viewing file:  Build.php (8.42 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Console\Commands;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\Artisan;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Log;
use RecursiveDirectoryIterator;
use RecursiveIteratorIterator;
use SplFileInfo;
use Throwable;
use ZipArchive;
class Build extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'build:app';
/**
* The console command description.
*
* @var string
*/
protected $description = 'This will refresh the database and dump';
/**
* Create a new command instance.
*
* @return void
*/
public function __construct()
{
parent::__construct();
}
/**
* Execute the console command.
*
* @return int
*/
public function handle()
{
Log::info("Building the application");
$this->warn("Build has been started");
return $this->build();
}
public function build(): int
{
Artisan::call('clear:all', ['--withlog' => true]);
Artisan::call('migrate:fresh', ['--force' => true, '--seed' => true]);
// Artisan::call('translations:import');
if($this->serverDBBackup()){
$this->compressFullProject();
}
return 0;
}
private function serverDBBackup(): bool
{
try {
$database = config('database.connections.mysql.database');
$user = config('database.connections.mysql.username');
$pass = config('database.connections.mysql.password');
$host = config('database.connections.mysql.host');
$app_name = strtolower(config('app.name'));
$app_version = "v" . str_replace('.', '_', config('app.version'));
$dirName = DIRECTORY_SEPARATOR . ".." . DIRECTORY_SEPARATOR . ".." . DIRECTORY_SEPARATOR . "Release" . DIRECTORY_SEPARATOR . $app_name . DIRECTORY_SEPARATOR . $app_version;
if (!File::isDirectory($dirName)) {
$this->warn("Directory not exist. Creating now..");
File::makeDirectory($dirName, 0777, true, true);
} else {
if (!$this->confirm($dirName . ' already exist. Do you wish to continue?')) {
return false; // function will return false
}
}
$dir = $dirName . DIRECTORY_SEPARATOR . $app_name . "_" . $app_version . ".sql";
if (File::exists($dir)) {
try {
$this->warn("Deleting previous file");
unlink($dir);
} catch (Throwable $th) {
$this->error($th->getMessage());
return false;
}
}
// echo "<h3>Backing up database to `<code>{$dir}</code>`</h3>";
// mysqldump -u [user name] –p [password] [options] [database_name] [tablename] > [dumpfilename.sql]
// --add-drop-database --databases
// mysqldump --user=root --password=bismib_fashion@_mysql --host=localhost --events --routines --triggers elaravel_v2 --result-file=db_backup_new.sql 2>&1
$string = "mysqldump --user=$user --password=$pass --host=$host --events --routines --triggers $database --result-file=$dir 2>&1";
exec($string, $output);
if (count($output) > 0) {
$this->info(print_r($output));
}
$tableViewsCounts = DB::select('SELECT count(TABLE_NAME) AS TOTALNUMBEROFTABLES FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ?', [$database]);
$tableViewsCounts = $tableViewsCounts[0]->TOTALNUMBEROFTABLES;
$viewsCounts = DB::select('SELECT count(TABLE_NAME) AS TOTALNUMBEROFVIEWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE LIKE "VIEW" AND TABLE_SCHEMA = ?', [$database]);
$viewsCounts = $viewsCounts[0]->TOTALNUMBEROFVIEWS;
$tablesCount = $tableViewsCounts - $viewsCounts;
$proceduresCounts = DB::select('SELECT count(TYPE) AS proceduresCounts FROM mysql.proc WHERE TYPE="PROCEDURE" AND db = ?', [$database]);
$proceduresCounts = $proceduresCounts[0]->proceduresCounts;
$functionsCounts = DB::select('SELECT count(TYPE) AS functionsCounts FROM mysql.proc WHERE TYPE="FUNCTION" AND db = ?', [$database]);
$functionsCounts = $functionsCounts[0]->functionsCounts;
$init_command = PHP_EOL . '-- ' . ' Database Backup Generated time = ' . (Carbon::now()->toDateTimeLocalString()) . PHP_EOL . PHP_EOL .
'-- =============Objects Counting Start================= ' . PHP_EOL . PHP_EOL .
'-- Total Tables + Views = ' . $tableViewsCounts . PHP_EOL .
'-- Total Tables = ' . $tablesCount . PHP_EOL .
'-- Total Views = ' . $viewsCounts . PHP_EOL . PHP_EOL .
'-- Total Procedures = ' . $proceduresCounts . PHP_EOL .
'-- Total Functions = ' . $functionsCounts . PHP_EOL .
'-- =============Objects Counting End================= ' . PHP_EOL .
PHP_EOL . PHP_EOL .
'SET FOREIGN_KEY_CHECKS=0; ' . PHP_EOL .
'SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";' . PHP_EOL .
'START TRANSACTION;' . PHP_EOL;
$data = file_get_contents($dir);
$append_command = PHP_EOL . 'SET FOREIGN_KEY_CHECKS=1;' . PHP_EOL . 'COMMIT;' . PHP_EOL;
// dd($data);
file_put_contents($dir, $init_command . $data . $append_command);
$this->info("Database Backup Completed at " . $dir);
return true;
} catch (Throwable $th) {
$this->error($th->getMessage());
return false;
}
}
function strcontains($str, array $arr): bool
{
foreach ($arr as $a) {
if (stripos($str, $a) !== false) return true;
}
return false;
}
private $excludeFolders = ['.git', '.idea'];
private $excludeFiles = ['build'];
private function compressFullProject(): void
{
$app_name = strtolower(config('app.name'));
$app_version = "v" . str_replace('.', '_', config('app.version'));
$dirName = DIRECTORY_SEPARATOR . ".." . DIRECTORY_SEPARATOR . ".." . DIRECTORY_SEPARATOR . "Release" . DIRECTORY_SEPARATOR . $app_name . DIRECTORY_SEPARATOR . $app_version;
$fullFilePath = $dirName . DIRECTORY_SEPARATOR . 'app_' . $app_version . '.zip';
if (File::exists($fullFilePath)) {
if (!$this->confirm('Zip already exist. Do you wish to continue?')) {
return;
}
}
// Get real path for our folder
$rootPath = realpath(base_path());
$this->info("Zipping Started");
// Initialize archive object
$zip = new ZipArchive();
$zip->open($fullFilePath, ZipArchive::CREATE | ZipArchive::OVERWRITE);
// Create recursive directory iterator
/** @var SplFileInfo[] $files */
$files = new RecursiveIteratorIterator(
new RecursiveDirectoryIterator($rootPath),
RecursiveIteratorIterator::LEAVES_ONLY
);
$count = 0;
foreach ($files as $ignored) {
$count++;
}
$bar = $this->output->createProgressBar($count);
$bar->start();
foreach ($files as $file) {
// Get real and relative path for current file
$filePath = $file->getRealPath();
$relativePath = substr($filePath, strlen($rootPath) + 1);
if(in_array($file->getFilename(), $this->excludeFiles) || $this->strcontains($file->getRealPath(), $this->excludeFolders)){
continue;
}
// Skip directories (they would be added automatically)
if (!$file->isDir()) {
if(!in_array($file->getFilename(), $this->excludeFiles) && !$this->strcontains($file->getRealPath(), $this->excludeFolders)){
// Add current file to archive
$zip->addFile($filePath, $relativePath);
}
}else{
if($relativePath !== false)
$zip->addEmptyDir($relativePath);
}
$bar->advance();
}
// Zip archive will be created only after closing object
$zip->close();
$bar->finish();
$this->newLine();
$this->info("Zip Completed");
}
}
|