class SqlConnectCase

  1. 8.0.x tests/sqlConnectCreateTest.php SqlConnectCase
  2. 6.x tests/sqlConnectTest.php SqlConnectCase
  3. 7.x tests/sqlConnectCreateTest.php SqlConnectCase
  4. 5.x tests/sqlConnectTest.php SqlConnectCase
  5. master tests/sqlConnectCreateTest.php SqlConnectCase

Tests sql-connect command

Installs Drupal and checks that the given URL by sql-connect is correct.

@group commands @group sql




Expanded class hierarchy of SqlConnectCase


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
SqlConnectCase::testSqlConnect function
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 -
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


tests/sqlConnectCreateTest.php, line 13

View source
class SqlConnectCase extends CommandUnishTestCase {

  function testSqlConnect() {
    $sites = $this->setUpDrupal(1, TRUE);
    $options = array(
      'yes' => NULL,
      'root' => $this->webroot(),
      'uri' => key($sites),

    // Get the connection details with sql-connect and check its structure.
    $this->drush('sql-connect', array(), $options);
    $connectionString = $this->getOutput();

    // Not all drivers need -e option like sqlite
    $shell_options = "-e";
    $db_driver = $this->db_driver();
    if ($db_driver == 'mysql') {
      $this->assertRegExp('/^mysql --user=[^\s]+ --password=.* --database=[^\s]+ --host=[^\s]+/', $connectionString);
    elseif ($db_driver == 'sqlite') {
      $this->assertContains('sqlite3', $connectionString);
      $shell_options = '';
    elseif ($db_driver == 'pgsql') {
      $this->assertRegExp('/^psql -q --dbname=[^\s]+ --host=[^\s]+ --port=[^\s]+ --username=[^\s]+/', $connectionString);
    else {
      $this->markTestSkipped('sql-connect test does not recognize database type in ' . UNISH_DB_URL);

    // Issue a query and check the result to verify the connection.
    $this->execute($connectionString . ' ' . $shell_options . ' "SELECT uid FROM users where uid = 1;"');
    $output = $this->getOutput();
    $this->assertContains('1', $output);

    // Run 'core-status' and insure that we can bootstrap Drupal.
    $this->drush('core-status', array("Drupal bootstrap"), $options);
    $output = $this->getOutput();
    $this->assertContains('Successful', $output);

    // Test to see if 'sql-create' can erase the database.
    // The only output is a confirmation string, so we'll run
    // other commands to confirm that this worked.
    $this->drush('sql-create', array(), $options);

    // Try to execute a query.  This should give a "table not found" error.
    $this->execute($connectionString . ' ' . $shell_options . ' "SELECT uid FROM users where uid = 1;"', self::EXIT_ERROR);

    // We should still be able to run 'core-status' without getting an
    // error, although Drupal should not bootstrap any longer.
    $this->drush('core-status', array("Drupal bootstrap"), $options);
    $output = $this->getOutput();
    $this->assertNotContains('Successful', $output);