App\Console\Commands\BackupApplication::handle()

Complexity

Conditions	3
Paths	2

Size

Total Lines	53
Code Lines	34

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function handle()
    {
        $backupType = $this->argument('type');
        $backupDir = config('filesystems.disks.backup.root');
        $backupTmp = config('filesystems.disks.backup.root').DIRECTORY_SEPARATOR.'tmp';
        $localDir  = config('filesystems.disks.local.root');
        $publicDir = config('filesystems.disks.public.root');
        $backupBase = $backupType.'_backup-'.Carbon::now()->toDateString().'_'.Carbon::now()->hour.Carbon::now()->minute;
                
        //  Determine if the backup file already exists
        $i = 0;
        do
        {
            if($i)
            {
                $backupName = $backupBase.'('.$i.')';
            }
            else
            {
                $backupName = $backupBase;
            }
            $i++;
        } while(Storage::disk('backup')->exists($backupName.'.zip'));
        
        //  Write a file that shows the system version    
        $version = new \PragmaRX\Version\Package\Version();
        Storage::disk('backup')->put('tmp/version.txt', $version->compact());
        
        //  Create a dump file of the MySQL database
        $process = new Process(sprintf(

sprintf('mysqldump -u%s -p%s %s > %s', config('database.connections.mysql.username'), config('database.connections.mysql.password'), config('database.connections.mysql.database'), $backupTmp . App\Console\Commands\DIRECTORY_SEPARATOR . 'db_dump.sql') of type string is incompatible with the type array expected by parameter $command of Symfony\Component\Process\Process::__construct().

            'mysqldump -u%s -p%s %s > %s',
            config('database.connections.mysql.username'),
            config('database.connections.mysql.password'),
            config('database.connections.mysql.database'),
            $backupTmp.DIRECTORY_SEPARATOR.'db_dump.sql'
        ));
        $process->mustRun();
        
        //  Create a zip archive of the tmp folder
        $zip = Zip::create($backupDir.DIRECTORY_SEPARATOR.$backupName.'.zip');        
        $zip->add($backupTmp.DIRECTORY_SEPARATOR.'version.txt');
        $zip->add($backupTmp.DIRECTORY_SEPARATOR.'db_dump.sql');
        $zip->add(base_path('.env'));
        $zip->add($localDir);
        $zip->add($publicDir);
        $zip->add(storage_path('logs'));
        $zip->close();
        
        //  Clean up the tmp folder
        Storage::disk('backup')->deleteDirectory('tmp');
        
        Log::notice('Backup file created successfully');
        $this->line('Backup Successful');
    }