function drush_sql_db_exists

6.x drush_sql_db_exists($db_spec)
5.x drush_sql_db_exists($db_spec)

Does specified database exist on target server

Return value


2 calls to drush_sql_db_exists()
drush_core_pre_site_install in commands/core/
Perform setup tasks for installation.
drush_sql_empty_db in commands/sql/
Drop all tables (if DB exists) or CREATE target database.


commands/sql/, line 1513
Drush sql commands


function drush_sql_db_exists($db_spec) {
  if ($db_spec['driver'] == 'sqlite') {
    return file_exists($db_spec['database']);

  $connect_yes_db = _drush_sql_connect($db_spec);
  $database = $db_spec['database'];
  $connect_no_db = _drush_sql_connect($db_spec);
  // We need the output back so we can't use drush_sql_query().
  switch ($db_spec['driver']) {
    case 'mysql':
      $sql = "SELECT 1;";
      // Suppress ugly output. Redirect STDERR and STDOUT. We just need exit code.
      $bit_bucket = drush_bit_bucket();
      return drush_shell_exec("$connect_yes_db -e \"$sql\" 2> $bit_bucket > $bit_bucket");
    case 'pgsql':
      $sql = "SELECT 1 AS result FROM pg_database WHERE datname='$database'";
      drush_shell_exec("$connect_no_db -t -c \"$sql\"");
      $output = drush_shell_exec_output();
      return (bool) $output[0];
    case 'sqlsrv':
      // TODO: untested, but the gist is here.
      $sql = "if db_id('$database') IS NOT NULL print 1";
      drush_shell_exec("$connect_no_db -Q \"$sql\"");
      $output = drush_shell_exec_output();
      return $output[0] == 1;