class DrupalSqlBase

Same name in other branches
  1. 9 core/modules/migrate_drupal/src/Plugin/migrate/source/DrupalSqlBase.php \Drupal\migrate_drupal\Plugin\migrate\source\DrupalSqlBase
  2. 8.9.x core/modules/migrate_drupal/src/Plugin/migrate/source/DrupalSqlBase.php \Drupal\migrate_drupal\Plugin\migrate\source\DrupalSqlBase
  3. 11.x core/modules/migrate_drupal/src/Plugin/migrate/source/DrupalSqlBase.php \Drupal\migrate_drupal\Plugin\migrate\source\DrupalSqlBase

A base class for source plugins using a Drupal database as a source.

Provides general purpose helper methods that are commonly needed when writing source plugins that use a Drupal database as a source, for example:

  • Check if the given module exists in the source database.
  • Read Drupal configuration variables from the source database.

For a full list, refer to the methods of this class.

For available configuration keys, refer to the parent classes.

Hierarchy

Expanded class hierarchy of DrupalSqlBase

See also

\Drupal\migrate\Plugin\migrate\source\SqlBase

\Drupal\migrate\Plugin\migrate\source\SourcePluginBase

65 files declare their use of DrupalSqlBase
Action.php in core/modules/system/src/Plugin/migrate/source/Action.php
Block.php in core/modules/block/src/Plugin/migrate/source/Block.php
BlockCustom.php in core/modules/block_content/src/Plugin/migrate/source/d7/BlockCustom.php
BlockCustomTranslation.php in core/modules/block_content/src/Plugin/migrate/source/d7/BlockCustomTranslation.php
BlockedIps.php in core/modules/ban/src/Plugin/migrate/source/d7/BlockedIps.php

... See full list

File

core/modules/migrate_drupal/src/Plugin/migrate/source/DrupalSqlBase.php, line 30

Namespace

Drupal\migrate_drupal\Plugin\migrate\source
View source
abstract class DrupalSqlBase extends SqlBase implements DependentPluginInterface {
    use DependencyTrait;
    
    /**
     * The contents of the system table.
     *
     * @var array
     */
    protected $systemData;
    
    /**
     * If the source provider is missing.
     *
     * @var bool
     */
    protected $requirements = TRUE;
    
    /**
     * The entity type manager.
     *
     * @var \Drupal\Core\Entity\EntityTypeManagerInterface
     */
    protected $entityTypeManager;
    
    /**
     * {@inheritdoc}
     */
    public function __construct(array $configuration, $plugin_id, $plugin_definition, MigrationInterface $migration, StateInterface $state, EntityTypeManagerInterface $entity_type_manager) {
        parent::__construct($configuration, $plugin_id, $plugin_definition, $migration, $state);
        $this->entityTypeManager = $entity_type_manager;
    }
    
    /**
     * Retrieves all system data information from the source Drupal database.
     *
     * @return array
     *   List of system table information keyed by type and name.
     */
    public function getSystemData() {
        if (!isset($this->systemData)) {
            $this->systemData = [];
            try {
                $results = $this->select('system', 's')
                    ->fields('s')
                    ->execute();
                foreach ($results as $result) {
                    $this->systemData[$result['type']][$result['name']] = $result;
                }
            } catch (\Exception $e) {
                // The table might not exist for example in tests.
            }
        }
        return $this->systemData;
    }
    
    /**
     * {@inheritdoc}
     */
    public static function create(ContainerInterface $container, array $configuration, $plugin_id, $plugin_definition, ?MigrationInterface $migration = NULL) {
        return new static($configuration, $plugin_id, $plugin_definition, $migration, $container->get('state'), $container->get('entity_type.manager'));
    }
    
    /**
     * {@inheritdoc}
     */
    public function checkRequirements() {
        parent::checkRequirements();
        if ($this->pluginDefinition['requirements_met'] === TRUE) {
            if ($source_module = $this->getSourceModule()) {
                if ($this->moduleExists($source_module)) {
                    if (isset($this->pluginDefinition['minimum_version'])) {
                        $minimum_version = (int) $this->pluginDefinition['minimum_version'];
                        $installed_version = (int) $this->getModuleSchemaVersion($source_module);
                        if ($minimum_version > $installed_version) {
                            throw new RequirementsException('Required minimum version ' . $this->pluginDefinition['minimum_version'], [
                                'minimum_version' => $this->pluginDefinition['minimum_version'],
                            ]);
                        }
                    }
                }
                else {
                    throw new RequirementsException('The module ' . $source_module . ' is not enabled in the source site.', [
                        'source_module' => $source_module,
                    ]);
                }
            }
        }
    }
    
    /**
     * Retrieves a module schema_version from the source Drupal database.
     *
     * @param string $module
     *   Name of module.
     *
     * @return mixed
     *   The current module schema version on the origin system table or FALSE if
     *   not found.
     */
    protected function getModuleSchemaVersion($module) {
        $system_data = $this->getSystemData();
        return $system_data['module'][$module]['schema_version'] ?? FALSE;
    }
    
    /**
     * Checks if a given module is enabled in the source Drupal database.
     *
     * @param string $module
     *   Name of module to check.
     *
     * @return bool
     *   TRUE if module is enabled on the origin system, FALSE if not.
     */
    protected function moduleExists($module) {
        $system_data = $this->getSystemData();
        return !empty($system_data['module'][$module]['status']);
    }
    
    /**
     * Reads a variable from a source Drupal database.
     *
     * @param $name
     *   Name of the variable.
     * @param $default
     *   The default value.
     *
     * @return mixed
     */
    protected function variableGet($name, $default) {
        try {
            $result = $this->select('variable', 'v')
                ->fields('v', [
                'value',
            ])
                ->condition('name', $name)
                ->execute()
                ->fetchField();
        } catch (\Exception $e) {
            $result = FALSE;
        }
        return $result !== FALSE ? unserialize($result) : $default;
    }
    
    /**
     * {@inheritdoc}
     */
    public function calculateDependencies() {
        // Generic handling for Drupal source plugin constants.
        if (isset($this->configuration['constants']['entity_type'])) {
            $this->addDependency('module', $this->entityTypeManager
                ->getDefinition($this->configuration['constants']['entity_type'])
                ->getProvider());
        }
        if (isset($this->configuration['constants']['module'])) {
            $this->addDependency('module', $this->configuration['constants']['module']);
        }
        return $this->dependencies;
    }

}

Members

Title Sort descending Modifiers Object type Summary Overriden Title Overrides
DependencyTrait::$dependencies protected property The object's dependencies.
DependencyTrait::addDependencies protected function Adds multiple dependencies.
DependencyTrait::addDependency protected function Adds a dependency.
DrupalSqlBase::$entityTypeManager protected property The entity type manager.
DrupalSqlBase::$requirements protected property If the source provider is missing.
DrupalSqlBase::$systemData protected property The contents of the system table.
DrupalSqlBase::calculateDependencies public function Calculates dependencies for the configured plugin. Overrides DependentPluginInterface::calculateDependencies
DrupalSqlBase::checkRequirements public function Checks if requirements for this plugin are OK. Overrides SqlBase::checkRequirements 4
DrupalSqlBase::create public static function Creates an instance of the plugin. Overrides SqlBase::create 2
DrupalSqlBase::getModuleSchemaVersion protected function Retrieves a module schema_version from the source Drupal database.
DrupalSqlBase::getSystemData public function Retrieves all system data information from the source Drupal database.
DrupalSqlBase::moduleExists protected function Checks if a given module is enabled in the source Drupal database.
DrupalSqlBase::variableGet protected function Reads a variable from a source Drupal database.
DrupalSqlBase::__construct public function Overrides SqlBase::__construct 5
MigrateSourceInterface::fields public function Returns available fields on the source. 87
MigrateSourceInterface::getIds public function Defines the source fields uniquely identifying a source row. 87
MigrateSourceInterface::NOT_COUNTABLE constant Indicates that the source is not countable.
PluginInspectionInterface::getPluginDefinition public function Gets the definition of the plugin implementation. 6
PluginInspectionInterface::getPluginId public function Gets the plugin_id of the plugin instance. 2
SourcePluginBase::$cache protected property The backend cache.
SourcePluginBase::$cacheCounts protected property Whether this instance should cache the source count. 1
SourcePluginBase::$cacheKey protected property Key to use for caching counts.
SourcePluginBase::$currentRow protected property The current row from the query.
SourcePluginBase::$currentSourceIds protected property The primary key of the current row.
SourcePluginBase::$highWaterProperty protected property Information on the property used as the high-water mark.
SourcePluginBase::$highWaterStorage protected property The key-value storage for the high-water value.
SourcePluginBase::$idMap protected property The migration ID map.
SourcePluginBase::$iterator protected property The iterator to iterate over the source rows.
SourcePluginBase::$mapRowAdded protected property Flags whether source plugin will read the map row and add to data row.
SourcePluginBase::$migration protected property The entity migration object.
SourcePluginBase::$moduleHandler protected property The module handler service. 2
SourcePluginBase::$originalHighWater protected property The high water mark at the beginning of the import operation.
SourcePluginBase::$skipCount protected property Whether this instance should not attempt to count the source. 1
SourcePluginBase::$trackChanges protected property Flags whether to track changes to incoming data. 1
SourcePluginBase::aboveHighWater protected function Check if the incoming data is newer than what we've previously imported.
SourcePluginBase::count public function Gets the source count. 2
SourcePluginBase::current public function
SourcePluginBase::getCache protected function Gets the cache object.
SourcePluginBase::getCurrentIds public function Gets the currentSourceIds data member.
SourcePluginBase::getHighWater protected function The current value of the high water mark.
SourcePluginBase::getHighWaterField protected function Get the name of the field used as the high watermark.
SourcePluginBase::getHighWaterProperty protected function Get information on the property used as the high watermark.
SourcePluginBase::getHighWaterStorage protected function Get the high water storage object.
SourcePluginBase::getIterator protected function Returns the iterator that will yield the row arrays to be processed.
SourcePluginBase::getModuleHandler protected function Gets the module handler.
SourcePluginBase::getSourceModule public function Gets the source module providing the source data. Overrides MigrateSourceInterface::getSourceModule
SourcePluginBase::key public function Gets the iterator key.
SourcePluginBase::next public function
SourcePluginBase::postRollback public function Performs post-rollback tasks. Overrides RollbackAwareInterface::postRollback
SourcePluginBase::prepareRow public function Adds additional data to the row. Overrides MigrateSourceInterface::prepareRow 49
SourcePluginBase::preRollback public function Performs pre-rollback tasks. Overrides RollbackAwareInterface::preRollback
SourcePluginBase::rowChanged protected function Checks if the incoming row has changed since our last import.
SourcePluginBase::saveHighWater protected function Save the new high water mark.
SourcePluginBase::valid public function Checks whether the iterator is currently valid.
SqlBase::$batch protected property The count of the number of batches run.
SqlBase::$batchSize protected property Number of records to fetch from the database during each batch.
SqlBase::$database protected property The database object. 1
SqlBase::$query protected property The query string. 81
SqlBase::$state protected property State service for retrieving database info.
SqlBase::doCount protected function Gets the source count using countQuery(). Overrides SourcePluginBase::doCount 6
SqlBase::fetchNextBatch protected function Prepares query for the next set of data from the source database.
SqlBase::fetchNextRow protected function Position the iterator to the following row. Overrides SourcePluginBase::fetchNextRow
SqlBase::getDatabase public function Gets the database connection object. 2
SqlBase::initializeIterator protected function Initializes the iterator with the source data. Overrides SourcePluginBase::initializeIterator 18
SqlBase::mapJoinable protected function Checks if we can join against the map table. 1
SqlBase::prepareQuery protected function Adds tags and metadata to the query.
SqlBase::query abstract public function 81
SqlBase::rewind public function Rewinds the iterator. Overrides SourcePluginBase::rewind
SqlBase::select protected function Wrapper for database select.
SqlBase::setUpDatabase protected function Gets a connection to the referenced database.
SqlBase::__sleep public function
SqlBase::__toString public function Prints the query string when the object is used as a string. Overrides MigrateSourceInterface::__toString

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