public function File::query

Return value

\Drupal\Core\Database\Query\SelectInterface

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