function File::query

Overrides SqlBase::query

File

core/modules/file/src/Plugin/migrate/source/d7/File.php, line 58

Class

File

Drupal 7 file source from database.

Namespace

Code

public function query() {
    $query = $this->select('file_managed', 'f')
        ->fields('f')
        ->condition('f.uri', 'temporary://%', 'NOT LIKE')
        ->orderBy('f.timestamp');
    // Filter by scheme(s), if configured.
    if (isset($this->configuration['scheme'])) {
        $schemes = [];
        // Remove 'temporary' scheme.
        $valid_schemes = array_diff((array) $this->configuration['scheme'], [
            'temporary',
        ]);
        // Accept either a single scheme, or a list.
        foreach ((array) $valid_schemes as $scheme) {
            $schemes[] = rtrim($scheme) . '://';
        }
        $schemes = array_map([
            $this->getDatabase(),
            'escapeLike',
        ], $schemes);
        // Add conditions, uri LIKE 'public://%' OR uri LIKE 'private://%'.
        $conditions = $this->getDatabase()
            ->condition('OR');
        foreach ($schemes as $scheme) {
            $conditions->condition('f.uri', $scheme . '%', 'LIKE');
        }
        $query->condition($conditions);
    }
    return $query;
}