Beispiel #1
0
 /**
  * Execute command
  *
  * @param  InputInterface  $input  Input instance
  * @param  OutputInterface $output Output instance
  *
  * @return int|null|void
  */
 public function execute(InputInterface $input, OutputInterface $output)
 {
     $database = $input->getArgument('db');
     $dumpFile = $input->getArgument('file');
     if (!is_file($dumpFile) || !is_readable($dumpFile)) {
         $output->writeln('<p-error>File is not readable</p-error>');
         return 1;
     }
     $dumpFileType = PhpUtility::getMimeType($dumpFile);
     $output->writeln('<h2>Restoring dump "' . $dumpFile . '" into database "' . $database . '"</h2>');
     if (DatabaseConnection::databaseExists($database)) {
         // Dropping
         $output->writeln('<p>Dropping database</p>');
         $query = 'DROP DATABASE IF EXISTS ' . DatabaseConnection::sanitizeSqlDatabase($database);
         DatabaseConnection::exec($query);
     }
     // Creating
     $output->writeln('<p>Creating database</p>');
     $query = 'CREATE DATABASE ' . DatabaseConnection::sanitizeSqlDatabase($database);
     DatabaseConnection::exec($query);
     // Inserting
     putenv('USER='******'MYSQL_PWD=' . DatabaseConnection::getDbPassword());
     $commandMysql = new CommandBuilder('mysql', '--user=%s %s --one-database', array(DatabaseConnection::getDbUsername(), $database));
     // Set server connection details
     if ($input->getOption('host')) {
         $commandMysql->addArgumentTemplate('-h %s', $input->getOption('host'));
     }
     if ($input->getOption('port')) {
         $commandMysql->addArgumentTemplate('-P %s', $input->getOption('port'));
     }
     $commandFile = new CommandBuilder();
     $commandFile->addArgument($dumpFile);
     $commandFile->addPipeCommand($commandMysql);
     switch ($dumpFileType) {
         case 'application/x-bzip2':
             $output->writeln('<p>Using BZIP2 decompression</p>');
             $commandFile->setCommand('bzcat');
             break;
         case 'application/gzip':
         case 'application/x-gzip':
             $output->writeln('<p>Using GZIP decompression</p>');
             $commandFile->setCommand('gzcat');
             break;
         case 'application/x-lzma':
         case 'application/x-xz':
             $output->writeln('<p>Using LZMA decompression</p>');
             $commandFile->setCommand('xzcat');
             break;
         default:
             $output->writeln('<p>Using plaintext (no decompression)</p>');
             $commandFile->setCommand('cat');
             break;
     }
     $output->writeln('<p>Reading dump</p>');
     $commandFile->executeInteractive();
     $output->writeln('<h2>Database "' . $database . '" restored</h2>');
     return 0;
 }
Beispiel #2
0
 /**
  * Execute command
  *
  * @param  InputInterface  $input  Input instance
  * @param  OutputInterface $output Output instance
  *
  * @return int|null|void
  */
 public function execute(InputInterface $input, OutputInterface $output)
 {
     $database = $input->getArgument('db');
     $dumpFile = $input->getArgument('file');
     $filter = $input->getOption('filter');
     if (!DatabaseConnection::databaseExists($database)) {
         $output->writeln('<p-error>Database "' . $database . '" does not exists</p-error>');
         return 1;
     }
     $output->writeln('<h2>Dumping database "' . $database . '" into file "' . $dumpFile . '"</h2>');
     $fileExt = pathinfo($dumpFile, PATHINFO_EXTENSION);
     // Inserting
     putenv('USER='******'MYSQL_PWD=' . DatabaseConnection::getDbPassword());
     $commandCompressor = null;
     switch ($fileExt) {
         case 'bz':
         case 'bz2':
         case 'bzip2':
             $output->writeln('<p>Using BZIP2 compression</p>');
             $commandCompressor = new CommandBuilder('bzip2');
             break;
         case 'gz':
         case 'gzip':
             $output->writeln('<p>Using GZIP compression</p>');
             $commandCompressor = new CommandBuilder('gzip');
             break;
         case 'lzma':
         case 'lz':
         case 'xz':
             $output->writeln('<p>Using LZMA compression</p>');
             $commandCompressor = new CommandBuilder('xz');
             $commandCompressor->addArgument('--compress')->addArgument('--stdout');
             break;
     }
     $command = new CommandBuilder('mysqldump', '--user=%s %s --single-transaction', array(DatabaseConnection::getDbUsername(), $database));
     // Set server connection details
     if ($input->getOption('host')) {
         $command->addArgumentTemplate('-h %s', $input->getOption('host'));
     }
     if ($input->getOption('port')) {
         $command->addArgumentTemplate('-P %s', $input->getOption('port'));
     }
     if (!empty($filter)) {
         $command = $this->addFilterArguments($command, $database, $filter);
     }
     if (!empty($commandCompressor)) {
         $command->addPipeCommand($commandCompressor);
         $commandCompressor->setOutputRedirectToFile($dumpFile);
     } else {
         $output->writeln('<p>Using no compression</p>');
         $command->setOutputRedirectToFile($dumpFile);
     }
     $command->executeInteractive();
     $output->writeln('<h2>Database "' . $database . '" stored to "' . $dumpFile . '"</h2>');
 }
Beispiel #3
0
 /**
  * Execute command
  *
  * @param  InputInterface  $input  Input instance
  * @param  OutputInterface $output Output instance
  *
  * @return int|null|void
  */
 public function execute(InputInterface $input, OutputInterface $output)
 {
     $database = $input->getArgument('db');
     $output->writeln('<h2>Clearing database "' . $database . '"</h2>');
     if (DatabaseConnection::databaseExists($database)) {
         $output->writeln('<p>Dropping database</p>');
         $query = 'DROP DATABASE ' . DatabaseConnection::sanitizeSqlDatabase($database);
         DatabaseConnection::exec($query);
     }
     $output->writeln('<p>Creating database</p>');
     $query = 'CREATE DATABASE ' . DatabaseConnection::sanitizeSqlDatabase($database);
     DatabaseConnection::exec($query);
     $output->writeln('<h2>Database "' . $database . '" recreated</h2>');
     return 0;
 }