class Tasks in Drupal driver for SQL Server and SQL Azure 4.1.x

Specifies installation tasks for PostgreSQL databases.

Hierarchy

• class \Drupal\Core\Database\Install\Tasks
  • class \Drupal\sqlsrv\Driver\Database\sqlsrv\Install\Tasks

1 file declares its use of Tasks

Tasks.php in tests/database_statement_monitoring_test/Install/Tasks.php

File

src/Driver/Database/sqlsrv/Install/Tasks.php, line 14

Namespace

Drupal\sqlsrv\Driver\Database\sqlsrv\Install

class Tasks extends InstallTasks {

  /**
   * {@inheritdoc}
   */
  protected $pdoDriver = 'sqlsrv';

  /**
   * Constructs a \Drupal\Core\Database\Driver\pgsql\Install\Tasks object.
   */
  public function __construct() {
    $this->tasks[] = [
      'function' => 'checkEncoding',
      'arguments' => [],
    ];
    $this->tasks[] = [
      'function' => 'initializeDatabase',
      'arguments' => [],
    ];
  }

  /**
   * {@inheritdoc}
   */
  public function name() {
    return t('SQLServer');
  }

  /**
   * {@inheritdoc}
   */
  public function minimumVersion() {

    // SQL Server 2019 - 15.x - 2025-01-07.
    // SQL Server 2017 - 14.x - 2022-10-11.
    // SQL Server 2016 - 13.x - 2021-07-13.
    return '13.0';
  }

  /**
   * {@inheritdoc}
   */
  protected function connect() {
    try {

      // This doesn't actually test the connection.
      Database::setActiveConnection();

      // Now actually do a check.
      Database::getConnection();
      $this
        ->pass('Drupal can CONNECT to the database ok.');
    } catch (\Exception $e) {

      // Attempt to create the database if it is not found.
      if ($e
        ->getCode() == Connection::DATABASE_NOT_FOUND) {

        // Remove the database string from connection info.
        $connection_info = Database::getConnectionInfo();
        $database = $connection_info['default']['database'];
        unset($connection_info['default']['database']);

        // In order to change the Database::$databaseInfo array, need to remove
        // the active connection, then re-add it with the new info.
        Database::removeConnection('default');
        Database::addConnectionInfo('default', 'default', $connection_info['default']);
        try {

          // Now, attempt the connection again; if it's successful, attempt to
          // create the database.
          Database::getConnection()
            ->createDatabase($database);
          Database::closeConnection();

          // Now, restore the database config.
          Database::removeConnection('default');
          $connection_info['default']['database'] = $database;
          Database::addConnectionInfo('default', 'default', $connection_info['default']);

          // Check the database connection.
          Database::getConnection();
          $this
            ->pass('Drupal can CONNECT to the database ok.');
        } catch (DatabaseNotFoundException $e) {

          // Still no dice; probably a permission issue. Raise the error to the
          // installer.
          $this
            ->fail(t('Database %database not found. The server reports the following message when attempting to create the database: %error.', [
            '%database' => $database,
            '%error' => $e
              ->getMessage(),
          ]));
          return FALSE;
        } catch (\PDOException $e) {

          // Still no dice; probably a permission issue. Raise the error to the
          // installer.
          $this
            ->fail(t('Database %database not found. The server reports the following message when attempting to create the database: %error.', [
            '%database' => $database,
            '%error' => $e
              ->getMessage(),
          ]));
          return FALSE;
        }
      }
      else {

        // Database connection failed for some other reason than the database
        // not existing.
        $this
          ->fail(t('Failed to connect to your database server. The server reports the following message: %error.<ul><li>Is the database server running?</li><li>Does the database exist, and have you entered the correct database name?</li><li>Have you entered the correct username and password?</li><li>Have you entered the correct database hostname?</li></ul>', [
          '%error' => $e
            ->getMessage(),
        ]));
        return FALSE;
      }
    }
    return TRUE;
  }

  /**
   * Check encoding is UTF8.
   */
  protected function checkEncoding() {
    try {
      $database = Database::getConnection();

      /** @var \Drupal\sqlsrv\Driver\Database\sqlsrv\Schema $schema */
      $schema = $database
        ->schema();
      $collation = $schema
        ->getCollation();
      if (stristr($collation, '_CI_') !== FALSE) {
        $this
          ->pass(t('Database is encoded in case insensitive collation: $collation'));
      }
      else {
        $this
          ->fail(t('The %driver database is using %current collation, but must use case insensitive collation to work with Drupal. Recreate the database with this collation. See !link for more details.', [
          '%current' => $collation,
          '%driver' => $this
            ->name(),
          ':link' => '<a href="INSTALL.sqlsrv.txt">INSTALL.sqlsrv.txt</a>',
        ]));
      }
    } catch (\Exception $e) {
      $this
        ->fail(t('Drupal could not determine the encoding of the database was set to UTF-8'));
    }
  }

  /**
   * Make SQLServer Drupal friendly.
   */
  public function initializeDatabase() {

    // We create some functions using global names instead of prefixing them
    // like we do with table names. This is so that we don't double up if more
    // than one instance of Drupal is running on a single database. We therefore
    // avoid trying to create them again in that case.
    try {

      /** @var \Drupal\sqlsrv\Driver\Database\sqlsrv\Connection $connection */
      $connection = Database::getConnection();
      Utils::DeployCustomFunctions($connection);
      $this
        ->pass(t('SQLServer has initialized itself.'));
    } catch (\Exception $e) {
      $this
        ->fail(t('Drupal could not be correctly setup with the existing database. Revise any errors.'));
    }
  }

  /**
   * {@inheritdoc}
   */
  public function getFormOptions(array $database) {
    $form = parent::getFormOptions($database);
    if (empty($form['advanced_options']['port']['#default_value'])) {
      $form['advanced_options']['port']['#default_value'] = '1433';
    }
    $form['advanced_options']['schema'] = [
      '#type' => 'textfield',
      '#title' => t('Schema'),
      '#default_value' => empty($database['schema']) ? 'dbo' : $database['schema'],
      '#size' => 10,
      '#required' => FALSE,
    ];
    $form['advanced_options']['cache_schema'] = [
      '#type' => 'checkbox',
      '#title' => t('Cache Schema Definitions'),
      '#description' => t('Allow the table schema to be cached. This will significantly speed up the site, but the schema must be stable.'),
      '#return_value' => 'true',
    ];
    $form['advanced_options']['autoload'] = [
      '#type' => 'textfield',
      '#title' => t('Driver Path'),
      '#description' => t('File path - will be automatically filled in when written to the settings file.'),
      '#default_value' => '',
    ];

    // Make username not required.
    $form['username']['#required'] = FALSE;

    // Add a description for about leaving username blank.
    $form['username']['#description'] = t('Leave username (and password) blank to use Windows authentication.');
    return $form;
  }

}

Members

Name	Modifiers	Type	Description	Overrides
Tasks::$pdoDriver	protected	property	The name of the PDO driver this database type requires. Overrides Tasks::$pdoDriver
Tasks::$results	protected	property	Results from tasks.
Tasks::$tasks	protected	property	Structure that describes each task to run.
Tasks::checkEncoding	protected	function	Check encoding is UTF8.
Tasks::checkEngineVersion	protected	function	Check the engine version.	1
Tasks::connect	protected	function	Check if we can connect to the database. Overrides Tasks::connect
Tasks::engineVersionRequirementsCheck	final public	function	Checks engine version requirements for the status report.
Tasks::fail	protected	function	Assert test as failed.
Tasks::getConnection	protected	function	Returns the database connection.
Tasks::getFormOptions	public	function	Return driver specific configuration options. Overrides Tasks::getFormOptions
Tasks::hasPdoDriver	protected	function	Ensure the PDO driver is supported by the version of PHP in use.
Tasks::initializeDatabase	public	function	Make SQLServer Drupal friendly.
Tasks::installable	public	function	Check whether Drupal is installable on the database.
Tasks::isConnectionActive	protected	function	Determines if there is an active connection.
Tasks::minimumVersion	public	function	Return the minimum required version of the engine. Overrides Tasks::minimumVersion
Tasks::name	public	function	Return the human-readable name of the driver. Overrides Tasks::name
Tasks::pass	protected	function	Assert test as a pass.
Tasks::runTasks	public	function	Run database tasks and tests to see if Drupal can run on the database.
Tasks::runTestQuery	protected	function	Run SQL tests to ensure the database can execute commands with the current user.
Tasks::t	protected	function	Translates a string to the current language or to a given language.
Tasks::validateDatabaseSettings	public	function	Validates driver specific configuration settings.
Tasks::__construct	public	function	Constructs a \Drupal\Core\Database\Driver\pgsql\Install\Tasks object.