class SqlDumpTest

  1. 8.0.x tests/sqlDumpTest.php SqlDumpTest
  2. 6.x tests/sqlDumpTest.php SqlDumpTest
  3. 7.x tests/sqlDumpTest.php SqlDumpTest
  4. master tests/sqlDumpTest.php SqlDumpTest

Tests for sql-dump commands.

@group commands @group sql @group slow

Namespace

Unish

Hierarchy

Expanded class hierarchy of SqlDumpTest

Members

Contains filters are case sensitive
Namesort descending Modifiers Type Description
CommandUnishTestCase::$coverage_data protected property Code coverage data collected during a single test.
CommandUnishTestCase::$defaultIdleTimeout private property Default idle timeout for commands.
CommandUnishTestCase::$defaultTimeout private property Default timeout for commands.
CommandUnishTestCase::$idleTimeout protected property Idle timeouts for commands.
CommandUnishTestCase::$process private property Process of last executed command.
CommandUnishTestCase::$timeout protected property Timeout for command.
CommandUnishTestCase::assertLogHasMessage function Ensure that an expected log message appears in the Drush log.
CommandUnishTestCase::drush function Invoke drush in via execute().
CommandUnishTestCase::drush_major_version function
CommandUnishTestCase::execute function Actually runs the command.
CommandUnishTestCase::EXIT_ERROR constant
CommandUnishTestCase::EXIT_SUCCESS constant
CommandUnishTestCase::getErrorOutput function Accessor for the last stderr output, trimmed.
CommandUnishTestCase::getErrorOutputAsList function Accessor for the last stderr output, rtrimmed and split on newlines.
CommandUnishTestCase::getErrorOutputRaw function Accessor for the last stderr output, non-trimmed.
CommandUnishTestCase::getOutput function Accessor for the last output, trimmed.
CommandUnishTestCase::getOutputAsList function Accessor for the last output, rtrimmed and split on newlines.
CommandUnishTestCase::getOutputFromJSON function Accessor for the last output, decoded from json.
CommandUnishTestCase::getOutputRaw function Accessor for the last output, non-trimmed.
CommandUnishTestCase::parse_backend_output function A slightly less functional copy of drush_backend_parse_output().
CommandUnishTestCase::run public function Override the run method, so we can add in our code coverage data after the test has run.
CommandUnishTestCase::UNISH_EXITCODE_USER_ABORT constant
SqlDumpTest::testSqlDump function Test that a dump file is created successfully.
UnishTestCase::$sites private static property A list of Drupal sites that have been recently installed. They key is the site name and values are details about each site.
UnishTestCase::bit_bucket function Borrowed from Drush. Checks operating system and returns supported bit bucket folder.
UnishTestCase::convert_path function Converts a Windows path (dir1\dir2\dir3) into a Unix path (dir1/dir2/dir3). Also converts a cygwin "drive emulation" path (/cygdrive/c/dir1) into a proper drive path, still with Unix slashes (c:/dir1).
UnishTestCase::db_driver function
UnishTestCase::db_url function
UnishTestCase::directory_cache function
UnishTestCase::drupalSitewideDirectory function
UnishTestCase::escapeshellarg public static function
UnishTestCase::fetchInstallDrupal function
UnishTestCase::getSites function
UnishTestCase::get_tar_executable public static function
UnishTestCase::is_windows public static function
UnishTestCase::log function Print a log message to the console.
UnishTestCase::log_level function
UnishTestCase::mkdir public function
UnishTestCase::randomString public function Helper function to generate a random string of arbitrary length.
UnishTestCase::recursive_copy public function
UnishTestCase::setUpBeforeClass public static function Assure that each class starts with an empty sandbox directory and a clean environment - http://drupal.org/node/1103568.
UnishTestCase::setUpDrupal function
UnishTestCase::setUpFreshSandBox public static function Remove any pre-existing sandbox, then create a new one.
UnishTestCase::tearDownAfterClass public static function Runs after all tests in a class are run. Remove sandbox directory.
UnishTestCase::tick function Print out a tick mark.
UnishTestCase::unish_file_aliases function Prepare the contents of an aliases file.
UnishTestCase::webroot function
UnishTestCase::writeSiteAlias function
UnishTestCase::_escapeshellarg_windows public static function
UnishTestCase::__construct function

File

tests/sqlDumpTest.php, line 12

View source
class SqlDumpTest extends CommandUnishTestCase {

  /**
   * Test that a dump file is created successfully.
   */
  function testSqlDump() {
    if ($this->db_driver() == 'sqlite') {
      $this->markTestSkipped('SQL Dump does not apply to SQLite.');
      return;
    }

    $this->setUpDrupal(1, TRUE);
    $root = $this->webroot();
    $uri = 'dev';
    $full_dump_file_path = UNISH_SANDBOX . DIRECTORY_SEPARATOR . 'full_db.sql';

    $options = array(
      'result-file' => $full_dump_file_path,
      
      // Last 5 entries are for D8+
      'skip-tables-list' => 'hist*,cache*,router,config*,watchdog,key_valu*',
      'yes' => NULL,
    );
    $site_selection_options = array(
      'root' => $root,
      'uri' => $uri,
    );
    // First, do a test without any aliases, and dump the whole database
    $this->drush('sql-dump', array(), array_merge($options, $site_selection_options));
    $this->assertFileExists($full_dump_file_path);
    $full_dump_file = file_get_contents($full_dump_file_path);
    // Test that we have sane contents.
    $this->assertContains('batch', $full_dump_file);
    // Test skip-files-list and wildcard expansion.
    $this->assertNotContains('history', $full_dump_file);
    // Next, set up an alias file and run a couple of simulated
    // tests to see if options are propagated correctly.
    // Control: insure options are not set when not specified
    unset($options['skip-tables-list']);
    unlink($full_dump_file_path);
    $this->drush('sql-dump', array(), array_merge($options, $site_selection_options));
    $this->assertFileExists($full_dump_file_path);
    $full_dump_file = file_get_contents($full_dump_file_path);
    // Test that we have sane contents.
    $this->assertContains('batch', $full_dump_file);
    // Test skip-files-list and wildcard expansion.
    $this->assertContains('history', $full_dump_file);

    $aliasPath = UNISH_SANDBOX . '/aliases';
    mkdir($aliasPath);
    $aliasFile = $aliasPath . '/bar.aliases.drushrc.php';
    $aliasContents = <<<EOD
  <?php
  // Written by Unish. This file is safe to delete.
  \$aliases['test'] = array(
    'root' => '$root',
    'uri' => '$uri',
    'site' => 'stage',
    'command-specific' => array(
      'sql-dump' => array(
        'skip-tables-list' => 'hist*,cache*,router,config*,watchdog,key_valu*',
      ),
    ),
  );
EOD;
    file_put_contents($aliasFile, $aliasContents);
    $options['alias-path'] = $aliasPath;
    unlink($full_dump_file_path);
    // Now run again with an alias, and test to see if the option is there
    $this->drush('sql-dump', array(), array_merge($options), '@test');
    $this->assertFileExists($full_dump_file_path);
    $full_dump_file = file_get_contents($full_dump_file_path);
    // Test that we have sane contents.
    $this->assertContains('batch', $full_dump_file);
    // Test skip-files-list and wildcard expansion.
    $this->assertNotContains('history', $full_dump_file);
    // Repeat control test:  options not recovered in absence of an alias.
    unlink($full_dump_file_path);
    $this->drush('sql-dump', array(), array_merge($options, $site_selection_options));
    $this->assertFileExists($full_dump_file_path);
    $full_dump_file = file_get_contents($full_dump_file_path);
    // Test that we have sane contents.
    $this->assertContains('batch', $full_dump_file);
    // Test skip-files-list and wildcard expansion.
    $this->assertContains('history', $full_dump_file);
    // Now run yet with @self, and test to see that Drush can recover the option
    // --skip-tables-list, defined in @test.
    unlink($full_dump_file_path);
    $this->drush('sql-dump', array(), array_merge($options, $site_selection_options), '@self');
    $this->assertFileExists($full_dump_file_path);
    $full_dump_file = file_get_contents($full_dump_file_path);
    // Test that we have sane contents.
    $this->assertContains('batch', $full_dump_file);
    // Test skip-files-list and wildcard expansion.
    $this->assertNotContains('history', $full_dump_file);
  }
}