Tivnet\WPDB\Command\DumpCommand

Complexity

Total Complexity

12

Size/Duplication

Total Lines	128
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	7

Test Coverage

Coverage

0%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	configure()	0	9	1
C	execute()	0	102	11

<?php
namespace Tivnet\WPDB\Command;

use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Input\InputOption;
use Tivnet\Console\Style;
use Tivnet\WPDB\I;

/**
 * Class DumpCommand
 * @package Tivnet\WPDB\Command
 */
class DumpCommand extends Command {

	/**
	 * Configuration
	 *
	 * @return void
	 */
	protected function configure() {
		$this->setName( 'dump' )
		     ->setDescription( 'Dump database to a file' )
		     ->setDefinition( array(
			     new InputOption( 'env', 'e', InputOption::VALUE_OPTIONAL, 'Specify the environment' ),
		     ) )
		     ->setHelp( /** @lang text */
			     'The <info>dump</info> runs `mysqladmin` to dump the entire database to a file in the `data` folder' );
	}

	/**
	 * Executes the command
	 *
	 * @param InputInterface  $input
	 * @param OutputInterface $output
	 *
	 * @return null|int
	 */
	protected function execute( InputInterface $input, OutputInterface $output ) {
		$io = new Style( $input, $output );
		$io->title( $this->getDescription() );

		$env = $input->getOption( 'env' ) ?: I::$cfg->get( 'env' );

		$dump_folder = implode( '/', array(
			I::$cfg->get( 'dir_dump' ),
			$env,
		) );

		$io->section( 'Creating the dump folder' );

		if ( ! @mkdir( $dump_folder, null, true ) && ! is_dir( $dump_folder ) ) {
			$io->error( 'Cannot create folder: ' . $dump_folder );

			return 1;
		}

		$io->section( 'Dumping the database' );

		$file_dump = $dump_folder . '/' . I::$cfg->get( 'dump_prefix' ) . '.' . I::$cfg->get( 'dump_ext' );

		$file_dump_escaped = escapeshellarg( $file_dump );

		$cmd = implode( ' ', array(
			'mysqldump',
			I::$cfg->get( 'mysql_authorization' ),
			$output->isDebug() ? '--verbose' : '',
			'--hex-blob --no-create-db --extended-insert=FALSE --add-drop-table --quick',
			I::$cfg->get( 'dump_ignore' ),
			'--result-file',
			$file_dump_escaped,
			I::$cfg->get( 'DB_NAME' )
		) );

		if ( $output->isDebug() ) {
			$io->note( $cmd );
		}

		system( $cmd );

		if ( ! is_file( $file_dump ) ) {
			$io->error( 'The dump file cannot be found: ' . $file_dump );

			return 1;
		}

		if ( $io->getVerbosity() >= Style::MIN_VERBOSITY ) {
			$io->section( 'The dump file:' );
			system( I::$cfg->get( 'cmd_ls' ) . ' ' . $file_dump_escaped );
			system( I::$cfg->get( 'cmd_tail' ) . ' ' . $file_dump_escaped );
		}

		$file_dump_xz = escapeshellarg( $file_dump . '.' . I::$cfg->get( 'ext_xz' ) );

		$xz_option_quiet = ( $io->getVerbosity() < Style::MIN_VERBOSITY ? 'q' : '' );

		$xz_options_compress = '-f' . $xz_option_quiet;
		$xz_options_verify   = '-t' . $xz_option_quiet;

		$io->section( 'Compressing' );
		system( implode( ' ', array(
			I::$cfg->get( 'cmd_xz' ),
			$xz_options_compress,
			$file_dump_escaped
		) ) );

		$io->section( 'Verifying' );
		$cmd_return = 0;
		system( implode( ' ', array(
			I::$cfg->get( 'cmd_xz' ),
			$xz_options_verify,
			$file_dump_xz
		) ), $cmd_return );
		if ( 0 !== (int) $cmd_return ) {
			$io->error( "Verify failed. The return code is $cmd_return" );

			return 1;
		}

		if ( ! $output->isQuiet() ) {
			$io->section( 'Done.' );
			system( implode( ' ', array(
				I::$cfg->get( 'cmd_ls' ),
				$file_dump_xz
			) ) );
		}

		/*
		 * Without `ls
				$output->writeln( implode( ' ', array(
					filesize( $file_dump ),
					date( 'Y-m-d H:i', filemtime( $file_dump ) ),
					$file_dump,
				) ) );
		*/

		$io->success( 'Done.' );

		return null;
	}
}