mRepo = RepoGroup::singleton()->getLocalRepo(); } /** * Override parent method to make sure the repo's DB is used * which may not necessarily be the same as the local DB. * * TODO: allow querying non-local repos. * @return DatabaseBase */ protected function getDB() { return $this->mRepo->getSlaveDB(); } public function execute() { $this->run(); } public function getCacheMode( $params ) { return 'public'; } /** * @param ApiPageSet $resultPageSet * @return void */ public function executeGenerator( $resultPageSet ) { if ( $resultPageSet->isResolvingRedirects() ) { $this->dieUsage( 'Use "gaifilterredir=nonredirects" option instead of "redirects" ' . 'when using allimages as a generator', 'params' ); } $this->run( $resultPageSet ); } /** * @param ApiPageSet $resultPageSet * @return void */ private function run( $resultPageSet = null ) { $repo = $this->mRepo; if ( !$repo instanceof LocalRepo ) { $this->dieUsage( 'Local file repository does not support querying all images', 'unsupportedrepo' ); } $prefix = $this->getModulePrefix(); $db = $this->getDB(); $params = $this->extractRequestParams(); // Table and return fields $this->addTables( 'image' ); $prop = array_flip( $params['prop'] ); $this->addFields( LocalFile::selectFields() ); $ascendingOrder = true; if ( $params['dir'] == 'descending' || $params['dir'] == 'older' ) { $ascendingOrder = false; } if ( $params['sort'] == 'name' ) { // Check mutually exclusive params $disallowed = array( 'start', 'end', 'user' ); foreach ( $disallowed as $pname ) { if ( isset( $params[$pname] ) ) { $this->dieUsage( "Parameter '{$prefix}{$pname}' can only be used with {$prefix}sort=timestamp", 'badparams' ); } } if ( $params['filterbots'] != 'all' ) { $this->dieUsage( "Parameter '{$prefix}filterbots' can only be used with {$prefix}sort=timestamp", 'badparams' ); } // Pagination if ( !is_null( $params['continue'] ) ) { $cont = explode( '|', $params['continue'] ); $this->dieContinueUsageIf( count( $cont ) != 1 ); $op = ( $ascendingOrder ? '>' : '<' ); $continueFrom = $db->addQuotes( $cont[0] ); $this->addWhere( "img_name $op= $continueFrom" ); } // Image filters $from = ( $params['from'] === null ? null : $this->titlePartToKey( $params['from'], NS_FILE ) ); $to = ( $params['to'] === null ? null : $this->titlePartToKey( $params['to'], NS_FILE ) ); $this->addWhereRange( 'img_name', ( $ascendingOrder ? 'newer' : 'older' ), $from, $to ); if ( isset( $params['prefix'] ) ) { $this->addWhere( 'img_name' . $db->buildLike( $this->titlePartToKey( $params['prefix'], NS_FILE ), $db->anyString() ) ); } } else { // Check mutually exclusive params $disallowed = array( 'from', 'to', 'prefix' ); foreach ( $disallowed as $pname ) { if ( isset( $params[$pname] ) ) { $this->dieUsage( "Parameter '{$prefix}{$pname}' can only be used with {$prefix}sort=name", 'badparams' ); } } if ( !is_null( $params['user'] ) && $params['filterbots'] != 'all' ) { // Since filterbots checks if each user has the bot right, it // doesn't make sense to use it with user $this->dieUsage( "Parameters '{$prefix}user' and '{$prefix}filterbots' cannot be used together", 'badparams' ); } // Pagination $this->addTimestampWhereRange( 'img_timestamp', $ascendingOrder ? 'newer' : 'older', $params['start'], $params['end'] ); // Include in ORDER BY for uniqueness $this->addWhereRange( 'img_name', $ascendingOrder ? 'newer' : 'older', null, null ); if ( !is_null( $params['continue'] ) ) { $cont = explode( '|', $params['continue'] ); $this->dieContinueUsageIf( count( $cont ) != 2 ); $op = ( $ascendingOrder ? '>' : '<' ); $continueTimestamp = $db->addQuotes( $db->timestamp( $cont[0] ) ); $continueName = $db->addQuotes( $cont[1] ); $this->addWhere( "img_timestamp $op $continueTimestamp OR " . "(img_timestamp = $continueTimestamp AND " . "img_name $op= $continueName)" ); } // Image filters if ( !is_null( $params['user'] ) ) { $this->addWhereFld( 'img_user_text', $params['user'] ); } if ( $params['filterbots'] != 'all' ) { $this->addTables( 'user_groups' ); $this->addJoinConds( array( 'user_groups' => array( 'LEFT JOIN', array( 'ug_group' => User::getGroupsWithPermission( 'bot' ), 'ug_user = img_user' ) ) ) ); $groupCond = ( $params['filterbots'] == 'nobots' ? 'NULL' : 'NOT NULL' ); $this->addWhere( "ug_group IS $groupCond" ); } } // Filters not depending on sort if ( isset( $params['minsize'] ) ) { $this->addWhere( 'img_size>=' . intval( $params['minsize'] ) ); } if ( isset( $params['maxsize'] ) ) { $this->addWhere( 'img_size<=' . intval( $params['maxsize'] ) ); } $sha1 = false; if ( isset( $params['sha1'] ) ) { $sha1 = strtolower( $params['sha1'] ); if ( !$this->validateSha1Hash( $sha1 ) ) { $this->dieUsage( 'The SHA1 hash provided is not valid', 'invalidsha1hash' ); } $sha1 = wfBaseConvert( $sha1, 16, 36, 31 ); } elseif ( isset( $params['sha1base36'] ) ) { $sha1 = strtolower( $params['sha1base36'] ); if ( !$this->validateSha1Base36Hash( $sha1 ) ) { $this->dieUsage( 'The SHA1Base36 hash provided is not valid', 'invalidsha1base36hash' ); } } if ( $sha1 ) { $this->addWhereFld( 'img_sha1', $sha1 ); } if ( !is_null( $params['mime'] ) ) { if ( $this->getConfig()->get( 'MiserMode' ) ) { $this->dieUsage( 'MIME search disabled in Miser Mode', 'mimesearchdisabled' ); } list( $major, $minor ) = File::splitMime( $params['mime'] ); $this->addWhereFld( 'img_major_mime', $major ); $this->addWhereFld( 'img_minor_mime', $minor ); } $limit = $params['limit']; $this->addOption( 'LIMIT', $limit + 1 ); $sortFlag = ''; if ( !$ascendingOrder ) { $sortFlag = ' DESC'; } if ( $params['sort'] == 'timestamp' ) { $this->addOption( 'ORDER BY', 'img_timestamp' . $sortFlag ); if ( !is_null( $params['user'] ) ) { $this->addOption( 'USE INDEX', array( 'image' => 'img_usertext_timestamp' ) ); } else { $this->addOption( 'USE INDEX', array( 'image' => 'img_timestamp' ) ); } } else { $this->addOption( 'ORDER BY', 'img_name' . $sortFlag ); } $res = $this->select( __METHOD__ ); $titles = array(); $count = 0; $result = $this->getResult(); foreach ( $res as $row ) { if ( ++$count > $limit ) { // We've reached the one extra which shows that there are // additional pages to be had. Stop here... if ( $params['sort'] == 'name' ) { $this->setContinueEnumParameter( 'continue', $row->img_name ); } else { $this->setContinueEnumParameter( 'continue', "$row->img_timestamp|$row->img_name" ); } break; } if ( is_null( $resultPageSet ) ) { $file = $repo->newFileFromRow( $row ); $info = array_merge( array( 'name' => $row->img_name ), ApiQueryImageInfo::getInfo( $file, $prop, $result ) ); self::addTitleInfo( $info, $file->getTitle() ); $fit = $result->addValue( array( 'query', $this->getModuleName() ), null, $info ); if ( !$fit ) { if ( $params['sort'] == 'name' ) { $this->setContinueEnumParameter( 'continue', $row->img_name ); } else { $this->setContinueEnumParameter( 'continue', "$row->img_timestamp|$row->img_name" ); } break; } } else { $titles[] = Title::makeTitle( NS_FILE, $row->img_name ); } } if ( is_null( $resultPageSet ) ) { $result->setIndexedTagName_internal( array( 'query', $this->getModuleName() ), 'img' ); } else { $resultPageSet->populateFromTitles( $titles ); } } public function getAllowedParams() { return array( 'sort' => array( ApiBase::PARAM_DFLT => 'name', ApiBase::PARAM_TYPE => array( 'name', 'timestamp' ) ), 'dir' => array( ApiBase::PARAM_DFLT => 'ascending', ApiBase::PARAM_TYPE => array( // sort=name 'ascending', 'descending', // sort=timestamp 'newer', 'older' ) ), 'from' => null, 'to' => null, 'continue' => null, 'start' => array( ApiBase::PARAM_TYPE => 'timestamp' ), 'end' => array( ApiBase::PARAM_TYPE => 'timestamp' ), 'prop' => array( ApiBase::PARAM_TYPE => ApiQueryImageInfo::getPropertyNames( $this->propertyFilter ), ApiBase::PARAM_DFLT => 'timestamp|url', ApiBase::PARAM_ISMULTI => true ), 'prefix' => null, 'minsize' => array( ApiBase::PARAM_TYPE => 'integer', ), 'maxsize' => array( ApiBase::PARAM_TYPE => 'integer', ), 'sha1' => null, 'sha1base36' => null, 'user' => array( ApiBase::PARAM_TYPE => 'user' ), 'filterbots' => array( ApiBase::PARAM_DFLT => 'all', ApiBase::PARAM_TYPE => array( 'all', 'bots', 'nobots' ) ), 'mime' => null, 'limit' => array( ApiBase::PARAM_DFLT => 10, ApiBase::PARAM_TYPE => 'limit', ApiBase::PARAM_MIN => 1, ApiBase::PARAM_MAX => ApiBase::LIMIT_BIG1, ApiBase::PARAM_MAX2 => ApiBase::LIMIT_BIG2 ), ); } public function getParamDescription() { $p = $this->getModulePrefix(); return array( 'sort' => 'Property to sort by', 'dir' => 'The direction in which to list', 'from' => "The image title to start enumerating from. Can only be used with {$p}sort=name", 'to' => "The image title to stop enumerating at. Can only be used with {$p}sort=name", 'continue' => 'When more results are available, use this to continue', 'start' => "The timestamp to start enumerating from. Can only be used with {$p}sort=timestamp", 'end' => "The timestamp to end enumerating. Can only be used with {$p}sort=timestamp", 'prop' => ApiQueryImageInfo::getPropertyDescriptions( $this->propertyFilter ), 'prefix' => "Search for all image titles that begin with this " . "value. Can only be used with {$p}sort=name", 'minsize' => 'Limit to images with at least this many bytes', 'maxsize' => 'Limit to images with at most this many bytes', 'sha1' => "SHA1 hash of image. Overrides {$p}sha1base36", 'sha1base36' => 'SHA1 hash of image in base 36 (used in MediaWiki)', 'user' => "Only return files uploaded by this user. Can only be used " . "with {$p}sort=timestamp. Cannot be used together with {$p}filterbots", 'filterbots' => "How to filter files uploaded by bots. Can only be " . "used with {$p}sort=timestamp. Cannot be used together with {$p}user", 'mime' => 'What MIME type to search for. e.g. image/jpeg. Disabled in Miser Mode', 'limit' => 'How many images in total to return', ); } private $propertyFilter = array( 'archivename', 'thumbmime', 'uploadwarning' ); public function getDescription() { return 'Enumerate all images sequentially.'; } public function getExamples() { return array( 'api.php?action=query&list=allimages&aifrom=B' => array( 'Simple Use', 'Show a list of files starting at the letter "B"', ), 'api.php?action=query&list=allimages&aiprop=user|timestamp|url&' . 'aisort=timestamp&aidir=older' => array( 'Simple Use', 'Show a list of recently uploaded files similar to Special:NewFiles', ), 'api.php?action=query&generator=allimages&gailimit=4&' . 'gaifrom=T&prop=imageinfo' => array( 'Using as Generator', 'Show info about 4 files starting at the letter "T"', ), ); } public function getHelpUrls() { return 'https://www.mediawiki.org/wiki/API:Allimages'; } }