Return value

\Drupal\Core\Database\Query\SelectInterface

Overrides SqlBase::query

1 call to File::query()

FileUsed::query in core/modules/file/tests/modules/file_test_get_ids/src/Plugin/migrate/source/d7/FileUsed.php

1 method overrides File::query()

FileUsed::query in core/modules/file/tests/modules/file_test_get_ids/src/Plugin/migrate/source/d7/FileUsed.php

File

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

Class

File

Drupal 7 file source from database.

Namespace

Drupal\file\Plugin\migrate\source\d7

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;
}

---