function Node::query

Overrides SqlBase::query

File

core/modules/node/src/Plugin/migrate/source/d6/Node.php, line 106

Class

Node

Drupal 6 node source from database.

Namespace

Code

public function query() {
    $query = $this->select('node_revisions', 'nr');
    $query->innerJoin('node', 'n', static::JOIN);
    $this->handleTranslations($query);
    $query->fields('n', [
        'nid',
        'type',
        'language',
        'status',
        'created',
        'changed',
        'comment',
        'promote',
        'moderate',
        'sticky',
        'tnid',
        'translate',
    ])
        ->fields('nr', [
        'title',
        'body',
        'teaser',
        'log',
        'timestamp',
        'format',
        'vid',
    ]);
    $query->addField('n', 'uid', 'node_uid');
    $query->addField('nr', 'uid', 'revision_uid');
    // If the content_translation module is enabled, get the source langcode
    // to fill the content_translation_source field.
    if ($this->moduleHandler
        ->moduleExists('content_translation')) {
        $query->leftJoin('node', 'nt', '[n].[tnid] = [nt].[nid]');
        $query->addField('nt', 'language', 'source_langcode');
    }
    if (isset($this->configuration['node_type'])) {
        $query->condition('n.type', (array) $this->configuration['node_type'], 'IN');
    }
    return $query;
}