public function GdprDumpGdprSqlMysql::dumpCmd in General Data Protection Regulation 7

Build bash for dumping a database.

Return value

string One or more mysqldump/pg_dump/sqlite3/etc statements that are ready for executing. If multiple statements are needed, enclose in parenthesis.

1 call to GdprDumpGdprSqlMysql::dumpCmd()

GdprDumpGdprSqlMysql::dump in modules/gdpr_dump/inc/GdprDumpGdprSqlMysql.inc

Execute a SQL dump and return the path to the resulting dump file.

File

modules/gdpr_dump/inc/GdprDumpGdprSqlMysql.inc, line 96

Class

GdprDumpGdprSqlMysql

Class GdprDumpGdprSqlMysql.

Code

public function dumpCmd($tableSelection) {

  // @todo: Dep.inj.

  /** @var array $gdprOptions */
  $gdprOptions = variable_get('gdpr_dump_table_map', []);
  $emptyTables = array_keys(variable_get('gdpr_dump_empty_tables', []));
  $sensitiveDataTables = \array_keys($gdprOptions);
  $multipleCommands = FALSE;
  $skipTables = $tableSelection['skip'];
  $structureTables = $tableSelection['structure'];
  $structureTables = \array_merge($emptyTables, $structureTables);
  $tables = $tableSelection['tables'];
  $ignores = [];
  $skipTables = \array_merge($structureTables, $skipTables);

  // Skip tables with sensitive data.
  $skipTables = \array_merge($sensitiveDataTables, $skipTables);
  $dataOnly = drush_get_option('data-only');

  // The ordered-dump option is only supported by MySQL for now.
  // @todo add documention once a hook for drush_get_option_help() is available.
  // @see drush_get_option_help() in drush.inc
  $orderedDump = drush_get_option('ordered-dump');
  $exec = 'mysqldump ';

  // Mysqldump wants 'databasename' instead of
  // 'database=databasename' for no good reason.
  $onlyDbName = \str_replace('--database=', ' ', $this
    ->creds());
  $exec .= $onlyDbName;

  // We had --skip-add-locks here for a while to help people with
  // insufficient permissions, but removed it because it slows down the
  // import a lot.  See http://drupal.org/node/1283978
  $extra = ' --no-autocommit --single-transaction --opt -Q';
  if (NULL !== $dataOnly) {
    $extra .= ' --no-create-info';
  }
  if (NULL !== $orderedDump) {
    $extra .= ' --skip-extended-insert --order-by-primary';
  }
  if ($option = drush_get_option('extra', $this->query_extra)) {
    $extra .= " {$option}";
  }
  $exec .= $extra;
  if (!empty($tables)) {
    $exec .= ' ' . \implode(' ', $tables);
  }
  else {

    // Append the ignore-table options.
    foreach (array_unique($skipTables) as $table) {
      $ignores[] = '--ignore-table=' . $this->db_spec['database'] . '.' . $table;
      $multipleCommands = TRUE;
    }
    $exec .= ' ' . \implode(' ', $ignores);

    // Run mysqldump again and append output
    // if we need some structure only tables.
    if (!empty($structureTables)) {
      $exec .= ' && mysqldump ' . $onlyDbName . " --no-data {$extra} " . \implode(' ', $structureTables);
      $multipleCommands = TRUE;
    }
  }
  return $multipleCommands ? "({$exec})" : $exec;
}