class Database

Same name in other branches
  1. 9 core/lib/Drupal/Core/Database/Database.php \Drupal\Core\Database\Database
  2. 8.9.x core/lib/Drupal/Core/Database/Database.php \Drupal\Core\Database\Database
  3. 10 core/lib/Drupal/Core/Database/Database.php \Drupal\Core\Database\Database
  4. 11.x core/lib/Drupal/Core/Database/Database.php \Drupal\Core\Database\Database

Primary front-controller for the database system.

This class is uninstantiatable and un-extendable. It acts to encapsulate all control and shepherding of database connections into a single location without the use of globals.

Hierarchy

Expanded class hierarchy of Database

Related topics

42 string references to 'Database'
ConnectionUnitTest::getInfo in modules/simpletest/tests/database_test.test
DatabaseAlterTestCase::getInfo in modules/simpletest/tests/database_test.test
DatabaseBasicSyntaxTestCase::getInfo in modules/simpletest/tests/database_test.test
DatabaseCaseSensitivityTestCase::getInfo in modules/simpletest/tests/database_test.test
DatabaseConnectionTestCase::getInfo in modules/simpletest/tests/database_test.test

... See full list

File

includes/database/database.inc, line 1428

View source
abstract class Database {
    
    /**
     * Flag to indicate a query call should simply return NULL.
     *
     * This is used for queries that have no reasonable return value anyway, such
     * as INSERT statements to a table without a serial primary key.
     */
    const RETURN_NULL = 0;
    
    /**
     * Flag to indicate a query call should return the prepared statement.
     */
    const RETURN_STATEMENT = 1;
    
    /**
     * Flag to indicate a query call should return the number of affected rows.
     */
    const RETURN_AFFECTED = 2;
    
    /**
     * Flag to indicate a query call should return the "last insert id".
     */
    const RETURN_INSERT_ID = 3;
    
    /**
     * An nested array of all active connections. It is keyed by database name
     * and target.
     *
     * @var array
     */
    protected static $connections = array();
    
    /**
     * A processed copy of the database connection information from settings.php.
     *
     * @var array
     */
    protected static $databaseInfo = NULL;
    
    /**
     * A list of key/target credentials to simply ignore.
     *
     * @var array
     */
    protected static $ignoreTargets = array();
    
    /**
     * The key of the currently active database connection.
     *
     * @var string
     */
    protected static $activeKey = 'default';
    
    /**
     * An array of active query log objects.
     *
     * Every connection has one and only one logger object for all targets and
     * logging keys.
     *
     * array(
     *   '$db_key' => DatabaseLog object.
     * );
     *
     * @var array
     */
    protected static $logs = array();
    
    /**
     * Starts logging a given logging key on the specified connection.
     *
     * @param $logging_key
     *   The logging key to log.
     * @param $key
     *   The database connection key for which we want to log.
     *
     * @return DatabaseLog
     *   The query log object. Note that the log object does support richer
     *   methods than the few exposed through the Database class, so in some
     *   cases it may be desirable to access it directly.
     *
     * @see DatabaseLog
     */
    public static final function startLog($logging_key, $key = 'default') {
        if (empty(self::$logs[$key])) {
            self::$logs[$key] = new DatabaseLog($key);
            // Every target already active for this connection key needs to have the
            // logging object associated with it.
            if (!empty(self::$connections[$key])) {
                foreach (self::$connections[$key] as $connection) {
                    $connection->setLogger(self::$logs[$key]);
                }
            }
        }
        self::$logs[$key]->start($logging_key);
        return self::$logs[$key];
    }
    
    /**
     * Retrieves the queries logged on for given logging key.
     *
     * This method also ends logging for the specified key. To get the query log
     * to date without ending the logger request the logging object by starting
     * it again (which does nothing to an open log key) and call methods on it as
     * desired.
     *
     * @param $logging_key
     *   The logging key to log.
     * @param $key
     *   The database connection key for which we want to log.
     *
     * @return array
     *   The query log for the specified logging key and connection.
     *
     * @see DatabaseLog
     */
    public static final function getLog($logging_key, $key = 'default') {
        if (empty(self::$logs[$key])) {
            return NULL;
        }
        $queries = self::$logs[$key]->get($logging_key);
        self::$logs[$key]->end($logging_key);
        return $queries;
    }
    
    /**
     * Gets the connection object for the specified database key and target.
     *
     * @param $target
     *   The database target name.
     * @param $key
     *   The database connection key. Defaults to NULL which means the active key.
     *
     * @return DatabaseConnection
     *   The corresponding connection object.
     */
    public static final function getConnection($target = 'default', $key = NULL) {
        if (!isset($key)) {
            // By default, we want the active connection, set in setActiveConnection.
            $key = self::$activeKey;
        }
        // If the requested target does not exist, or if it is ignored, we fall back
        // to the default target. The target is typically either "default" or
        // "slave", indicating to use a slave SQL server if one is available. If
        // it's not available, then the default/master server is the correct server
        // to use.
        if (!empty(self::$ignoreTargets[$key][$target]) || !isset(self::$databaseInfo[$key][$target])) {
            $target = 'default';
        }
        if (!isset(self::$connections[$key][$target])) {
            // If necessary, a new connection is opened.
            self::$connections[$key][$target] = self::openConnection($key, $target);
        }
        return self::$connections[$key][$target];
    }
    
    /**
     * Determines if there is an active connection.
     *
     * Note that this method will return FALSE if no connection has been
     * established yet, even if one could be.
     *
     * @return
     *   TRUE if there is at least one database connection established, FALSE
     *   otherwise.
     */
    public static final function isActiveConnection() {
        return !empty(self::$activeKey) && !empty(self::$connections) && !empty(self::$connections[self::$activeKey]);
    }
    
    /**
     * Sets the active connection to the specified key.
     *
     * @return
     *   The previous database connection key.
     */
    public static final function setActiveConnection($key = 'default') {
        if (empty(self::$databaseInfo)) {
            self::parseConnectionInfo();
        }
        if (!empty(self::$databaseInfo[$key])) {
            $old_key = self::$activeKey;
            self::$activeKey = $key;
            return $old_key;
        }
    }
    
    /**
     * Process the configuration file for database information.
     */
    public static final function parseConnectionInfo() {
        global $databases;
        $database_info = is_array($databases) ? $databases : array();
        foreach ($database_info as $index => $info) {
            foreach ($database_info[$index] as $target => $value) {
                // If there is no "driver" property, then we assume it's an array of
                // possible connections for this target. Pick one at random. That allows
                //  us to have, for example, multiple slave servers.
                if (empty($value['driver'])) {
                    $database_info[$index][$target] = $database_info[$index][$target][mt_rand(0, count($database_info[$index][$target]) - 1)];
                }
                // Parse the prefix information.
                if (!isset($database_info[$index][$target]['prefix'])) {
                    // Default to an empty prefix.
                    $database_info[$index][$target]['prefix'] = array(
                        'default' => '',
                    );
                }
                elseif (!is_array($database_info[$index][$target]['prefix'])) {
                    // Transform the flat form into an array form.
                    $database_info[$index][$target]['prefix'] = array(
                        'default' => $database_info[$index][$target]['prefix'],
                    );
                }
            }
        }
        if (!is_array(self::$databaseInfo)) {
            self::$databaseInfo = $database_info;
        }
        else {
            foreach ($database_info as $database_key => $database_values) {
                foreach ($database_values as $target => $target_values) {
                    self::$databaseInfo[$database_key][$target] = $target_values;
                }
            }
        }
    }
    
    /**
     * Adds database connection information for a given key/target.
     *
     * This method allows the addition of new connection credentials at runtime.
     * Under normal circumstances the preferred way to specify database
     * credentials is via settings.php. However, this method allows them to be
     * added at arbitrary times, such as during unit tests, when connecting to
     * admin-defined third party databases, etc.
     *
     * If the given key/target pair already exists, this method will be ignored.
     *
     * @param $key
     *   The database key.
     * @param $target
     *   The database target name.
     * @param $info
     *   The database connection information, as it would be defined in
     *   settings.php. Note that the structure of this array will depend on the
     *   database driver it is connecting to.
     */
    public static function addConnectionInfo($key, $target, $info) {
        if (empty(self::$databaseInfo[$key][$target])) {
            self::$databaseInfo[$key][$target] = $info;
        }
    }
    
    /**
     * Gets information on the specified database connection.
     *
     * @param $connection
     *   The connection key for which we want information.
     */
    public static final function getConnectionInfo($key = 'default') {
        if (empty(self::$databaseInfo)) {
            self::parseConnectionInfo();
        }
        if (!empty(self::$databaseInfo[$key])) {
            return self::$databaseInfo[$key];
        }
    }
    
    /**
     * Rename a connection and its corresponding connection information.
     *
     * @param $old_key
     *   The old connection key.
     * @param $new_key
     *   The new connection key.
     * @return
     *   TRUE in case of success, FALSE otherwise.
     */
    public static final function renameConnection($old_key, $new_key) {
        if (empty(self::$databaseInfo)) {
            self::parseConnectionInfo();
        }
        if (!empty(self::$databaseInfo[$old_key]) && empty(self::$databaseInfo[$new_key])) {
            // Migrate the database connection information.
            self::$databaseInfo[$new_key] = self::$databaseInfo[$old_key];
            unset(self::$databaseInfo[$old_key]);
            // Migrate over the DatabaseConnection object if it exists.
            if (isset(self::$connections[$old_key])) {
                self::$connections[$new_key] = self::$connections[$old_key];
                unset(self::$connections[$old_key]);
            }
            return TRUE;
        }
        else {
            return FALSE;
        }
    }
    
    /**
     * Remove a connection and its corresponding connection information.
     *
     * @param $key
     *   The connection key.
     * @param $close
     *   Whether to close the connection.
     * @return
     *   TRUE in case of success, FALSE otherwise.
     */
    public static final function removeConnection($key, $close = TRUE) {
        if (isset(self::$databaseInfo[$key])) {
            if ($close) {
                self::closeConnection(NULL, $key);
            }
            unset(self::$databaseInfo[$key]);
            return TRUE;
        }
        else {
            return FALSE;
        }
    }
    
    /**
     * Opens a connection to the server specified by the given key and target.
     *
     * @param $key
     *   The database connection key, as specified in settings.php. The default is
     *   "default".
     * @param $target
     *   The database target to open.
     *
     * @throws DatabaseConnectionNotDefinedException
     * @throws DatabaseDriverNotSpecifiedException
     */
    protected static final function openConnection($key, $target) {
        if (empty(self::$databaseInfo)) {
            self::parseConnectionInfo();
        }
        // If the requested database does not exist then it is an unrecoverable
        // error.
        if (!isset(self::$databaseInfo[$key])) {
            throw new DatabaseConnectionNotDefinedException('The specified database connection is not defined: ' . $key);
        }
        if (!($driver = self::$databaseInfo[$key][$target]['driver'])) {
            throw new DatabaseDriverNotSpecifiedException('Driver not specified for this database connection: ' . $key);
        }
        // We cannot rely on the registry yet, because the registry requires an
        // open database connection.
        $driver_class = 'DatabaseConnection_' . $driver;
        require_once DRUPAL_ROOT . '/includes/database/' . $driver . '/database.inc';
        $new_connection = new $driver_class(self::$databaseInfo[$key][$target]);
        $new_connection->setTarget($target);
        $new_connection->setKey($key);
        // If we have any active logging objects for this connection key, we need
        // to associate them with the connection we just opened.
        if (!empty(self::$logs[$key])) {
            $new_connection->setLogger(self::$logs[$key]);
        }
        return $new_connection;
    }
    
    /**
     * Closes a connection to the server specified by the given key and target.
     *
     * @param $target
     *   The database target name.  Defaults to NULL meaning that all target
     *   connections will be closed.
     * @param $key
     *   The database connection key. Defaults to NULL which means the active key.
     */
    public static function closeConnection($target = NULL, $key = NULL) {
        // Gets the active connection by default.
        if (!isset($key)) {
            $key = self::$activeKey;
        }
        // To close a connection, it needs to be set to NULL and removed from the
        // static variable. In all cases, closeConnection() might be called for a
        // connection that was not opened yet, in which case the key is not defined
        // yet and we just ensure that the connection key is undefined.
        if (isset($target)) {
            if (isset(self::$connections[$key][$target])) {
                self::$connections[$key][$target]->destroy();
                self::$connections[$key][$target] = NULL;
            }
            unset(self::$connections[$key][$target]);
        }
        else {
            if (isset(self::$connections[$key])) {
                foreach (self::$connections[$key] as $target => $connection) {
                    self::$connections[$key][$target]->destroy();
                    self::$connections[$key][$target] = NULL;
                }
            }
            unset(self::$connections[$key]);
        }
    }
    
    /**
     * Instructs the system to temporarily ignore a given key/target.
     *
     * At times we need to temporarily disable slave queries. To do so, call this
     * method with the database key and the target to disable. That database key
     * will then always fall back to 'default' for that key, even if it's defined.
     *
     * @param $key
     *   The database connection key.
     * @param $target
     *   The target of the specified key to ignore.
     */
    public static function ignoreTarget($key, $target) {
        self::$ignoreTargets[$key][$target] = TRUE;
    }
    
    /**
     * Load a file for the database that might hold a class.
     *
     * @param $driver
     *   The name of the driver.
     * @param array $files
     *   The name of the files the driver specific class can be.
     */
    public static function loadDriverFile($driver, array $files = array()) {
        static $base_path;
        if (empty($base_path)) {
            $base_path = dirname(realpath(__FILE__));
        }
        $driver_base_path = "{$base_path}/{$driver}";
        foreach ($files as $file) {
            // Load the base file first so that classes extending base classes will
            // have the base class loaded.
            foreach (array(
                "{$base_path}/{$file}",
                "{$driver_base_path}/{$file}",
            ) as $filename) {
                // The OS caches file_exists() and PHP caches require_once(), so
                // we'll let both of those take care of performance here.
                if (file_exists($filename)) {
                    require_once $filename;
                }
            }
        }
    }

}

Members

Title Sort descending Modifiers Object type Summary
Database::$activeKey protected static property The key of the currently active database connection.
Database::$connections protected static property An nested array of all active connections. It is keyed by database name
and target.
Database::$databaseInfo protected static property A processed copy of the database connection information from settings.php.
Database::$ignoreTargets protected static property A list of key/target credentials to simply ignore.
Database::$logs protected static property An array of active query log objects.
Database::addConnectionInfo public static function Adds database connection information for a given key/target.
Database::closeConnection public static function Closes a connection to the server specified by the given key and target.
Database::getConnection final public static function Gets the connection object for the specified database key and target.
Database::getConnectionInfo final public static function Gets information on the specified database connection.
Database::getLog final public static function Retrieves the queries logged on for given logging key.
Database::ignoreTarget public static function Instructs the system to temporarily ignore a given key/target.
Database::isActiveConnection final public static function Determines if there is an active connection.
Database::loadDriverFile public static function Load a file for the database that might hold a class.
Database::openConnection final protected static function Opens a connection to the server specified by the given key and target.
Database::parseConnectionInfo final public static function Process the configuration file for database information.
Database::removeConnection final public static function Remove a connection and its corresponding connection information.
Database::renameConnection final public static function Rename a connection and its corresponding connection information.
Database::RETURN_AFFECTED constant Flag to indicate a query call should return the number of affected rows.
Database::RETURN_INSERT_ID constant Flag to indicate a query call should return the "last insert id".
Database::RETURN_NULL constant Flag to indicate a query call should simply return NULL.
Database::RETURN_STATEMENT constant Flag to indicate a query call should return the prepared statement.
Database::setActiveConnection final public static function Sets the active connection to the specified key.
Database::startLog final public static function Starts logging a given logging key on the specified connection.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.