Inheritance: extends Symfony\Component\Console\Helper\Helper
 /**
  * @param string $sql
  *
  * @return array|bool
  */
 protected function _query($sql)
 {
     /** @var \PDO $connection */
     $connection = $this->dbHelper->getConnection($this->output);
     $query = $connection->prepare($sql);
     $query->execute();
     $result = $query->fetch(\PDO::FETCH_ASSOC);
     return $result;
 }
Esempio n. 2
0
 /**
  * PHP alternative to dump database without exec
  *
  * @param InputInterface $input
  * @param OutputInterface $output
  * @throws \Exception
  */
 private function createBackupWithoutExec(InputInterface $input, OutputInterface $output)
 {
     $magerun = $this->getMagerun();
     $filePath = $this->getFilePath($input);
     $stripOptions = $input->getOption('strip') ?: '@development';
     // Exec must be unavailable so use PHP alternative (match output)
     $dbHelper = new DatabaseHelper();
     $dbHelper->setHelperSet($magerun->getHelperSet());
     $dbHelper->detectDbSettings(new NullOutput());
     $magerunConfig = $magerun->getConfig();
     $stripTables = $dbHelper->resolveTables(explode(' ', $stripOptions), $dbHelper->getTableDefinitions($magerunConfig['commands']['N98\\Magento\\Command\\Database\\DumpCommand']));
     $output->writeln(array('', $magerun->getHelperSet()->get('formatter')->formatBlock('Dump MySQL Database (without exec)', 'bg=blue;fg=white', true), ''));
     $dbSettings = $dbHelper->getDbSettings();
     $username = (string) $dbSettings['username'];
     $password = (string) $dbSettings['password'];
     $dbName = (string) $dbSettings['dbname'];
     try {
         $output->writeln('<comment>No-data export for: <info>' . implode(' ', $stripTables) . '</info></comment>');
         $output->writeln('<comment>Start dumping database <info>' . $dbSettings['dbname'] . '</info> to file <info>' . $filePath . '</info>');
         // Dump Structure for tables that we are not to receive data from
         $dumpStructure = new Mysqldump(sprintf('%s;dbname=%s', $dbHelper->dsn(), $dbName), $username, $password, array('include-tables' => $stripTables, 'no-data' => true));
         $dumpStructure->start($filePath . '.structure');
         $dump = new Mysqldump(sprintf('%s;dbname=%s', $dbHelper->dsn(), $dbName), $username, $password, array('exclude-tables' => $stripTables));
         $dump->start($filePath . '.data');
         // Now merge two files
         $fhData = fopen($filePath . '.data', 'a+');
         $fhStructure = fopen($filePath . '.structure', 'r');
         if ($fhData && $fhStructure) {
             while (!feof($fhStructure)) {
                 fwrite($fhData, fgets($fhStructure, 4096));
             }
         }
         fclose($fhStructure);
         // Gzip
         rewind($fhData);
         $zfh = gzopen($filePath, 'wb');
         while (!feof($fhData)) {
             gzwrite($zfh, fgets($fhData, 4096));
         }
         gzclose($zfh);
         fclose($fhData);
     } catch (\Exception $e) {
         throw new \Exception("Unable to export database.");
     }
 }
Esempio n. 3
0
 /**
  * Create database backup in tmp directory.
  * Use magerun db:dump if available. Otherwise use php alternative if exec not available.
  *
  * @param InputInterface  $input
  * @param OutputInterface $output
  *
  * @throws \Exception
  */
 private function createBackup(InputInterface $input, OutputInterface $output)
 {
     $magerun = $this->getMagerun();
     $filePath = $this->getFilePath($input);
     try {
         /** @var \N98\Magento\Command\Database\DumpCommand $dumpCommand */
         $dumpCommand = $magerun->find("db:dump");
         $dumpInput = new ArrayInput(array('filename' => $filePath, '--strip' => '@development', '--compression' => 'gzip'));
         if ($dumpCommand->run($dumpInput, $output)) {
             throw new \Exception("magerun db:dump failed to create backup..");
         }
     } catch (\InvalidArgumentException $e) {
         // Exec must be unavailable so use PHP alternative (match output)
         $dbHelper = new DatabaseHelper();
         $dbHelper->setHelperSet($magerun->getHelperSet());
         $dbHelper->detectDbSettings(new NullOutput());
         $stripTables = $dbHelper->resolveTables(explode(' ', '@development'), $dbHelper->getTableDefinitions($magerun->getConfig()['commands']['N98\\Magento\\Command\\Database\\DumpCommand']));
         $output->writeln(array('', $magerun->getHelperSet()->get('formatter')->formatBlock('Dump MySQL Database (without exec)', 'bg=blue;fg=white', true), ''));
         $dbSettings = $dbHelper->getDbSettings();
         $username = (string) $dbSettings['username'];
         $password = (string) $dbSettings['password'];
         $dbName = (string) $dbSettings['dbname'];
         try {
             $dump = new Mysqldump(sprintf('%s;dbname=%s', $dbHelper->dsn(), $dbName), $username, $password, array('compress' => Mysqldump::GZIP, 'exclude-tables' => $stripTables));
             $output->writeln('<comment>No-data export for: <info>' . implode(' ', $stripTables) . '</info></comment>');
             $output->writeln('<comment>Start dumping database <info>' . $dbSettings['dbname'] . '</info> to file <info>' . $filePath . '</info>');
             $dump->start($filePath);
         } catch (\Exception $e) {
             throw new \Exception("Unable to export database.");
         }
         $output->writeln('<info>Finished</info>');
     }
 }