From cd98ba161a38d35c9d58a23e4788fa4c75ad6afd Mon Sep 17 00:00:00 2001 From: Sam Reed Date: Fri, 14 Jan 2011 21:08:08 +0000 Subject: [PATCH] Start of bug 24650 Fix API to work with categorylinks changes Addition of a type field for filtering (default is "all" ie no filter) Adding of type to props, to allow it to be outputted --- includes/api/ApiQueryCategoryMembers.php | 38 +++++++++++++++++++++--- 1 file changed, 34 insertions(+), 4 deletions(-) diff --git a/includes/api/ApiQueryCategoryMembers.php b/includes/api/ApiQueryCategoryMembers.php index 9e4220eff7..2c89c61044 100644 --- a/includes/api/ApiQueryCategoryMembers.php +++ b/includes/api/ApiQueryCategoryMembers.php @@ -78,6 +78,7 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { $fld_title = isset( $prop['title'] ); $fld_sortkey = isset( $prop['sortkey'] ); $fld_timestamp = isset( $prop['timestamp'] ); + $fld_type = isset( $prop['type'] ); if ( is_null( $resultPageSet ) ) { $this->addFields( array( 'cl_from', 'cl_sortkey', 'page_namespace', 'page_title' ) ); @@ -88,8 +89,10 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { } $this->addFieldsIf( 'cl_timestamp', $fld_timestamp || $params['sort'] == 'timestamp' ); + $this->addFieldsIf( 'cl_type', $fld_type ); $this->addTables( array( 'page', 'categorylinks' ) ); // must be in this order for 'USE INDEX' - // Not needed after bug 10280 is applied to servers + + // Not needed after bug 10280 is applied to servers if ( $params['sort'] == 'timestamp' ) { $this->addOption( 'USE INDEX', 'cl_timestamp' ); } else { @@ -99,6 +102,9 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { $this->addWhere( 'cl_from=page_id' ); $this->setContinuation( $params['continue'], $params['dir'] ); $this->addWhereFld( 'cl_to', $categoryTitle->getDBkey() ); + + $this->addWhereFld( 'cl_type', $params['type'] ); + // Scanning large datasets for rare categories sucks, and I already told // how to have efficient subcategory access :-) ~~~~ (oh well, domas) global $wgMiserMode; @@ -108,11 +114,21 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { } else { $this->addWhereFld( 'page_namespace', $params['namespace'] ); } + + $dir = $params['dir'] == 'asc' ? 'newer' : 'older'; + if ( $params['sort'] == 'timestamp' ) { - $this->addWhereRange( 'cl_timestamp', ( $params['dir'] == 'asc' ? 'newer' : 'older' ), $params['start'], $params['end'] ); + $this->addWhereRange( 'cl_timestamp', + $dir, + $params['start'], + $params['end'] ); } else { - $this->addWhereRange( 'cl_sortkey', ( $params['dir'] == 'asc' ? 'newer' : 'older' ), $params['startsortkey'], $params['endsortkey'] ); - $this->addWhereRange( 'cl_from', ( $params['dir'] == 'asc' ? 'newer' : 'older' ), null, null ); + $this->addWhereRange( 'cl_sortkey', + $dir, + $params['startsortkey'], + $params['endsortkey'] ); + + $this->addWhereRange( 'cl_from', $dir, null, null ); } $limit = $params['limit']; @@ -153,6 +169,9 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { if ( $fld_sortkey ) { $vals['sortkey'] = $row->cl_sortkey; } + if ( $fld_type ) { + $vals['type'] = $row->cl_type; + } if ( $fld_timestamp ) { $vals['timestamp'] = wfTimestamp( TS_ISO_8601, $row->cl_timestamp ); } @@ -231,6 +250,7 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { 'ids', 'title', 'sortkey', + 'type', 'timestamp', ) ), @@ -238,6 +258,15 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { ApiBase::PARAM_ISMULTI => true, ApiBase::PARAM_TYPE => 'namespace', ), + 'type' => array( + ApiBase::PARAM_ISMULTI => true, + ApiBase::PARAM_DFLT => 'page|subcat|file', + ApiBase::PARAM_TYPE => array( + 'page', + 'subcat', + 'file' + ) + ), 'continue' => null, 'limit' => array( ApiBase::PARAM_TYPE => 'limit', @@ -285,6 +314,7 @@ class ApiQueryCategoryMembers extends ApiQueryGeneratorBase { ' timestamp - Adds the timestamp of when the page was included', ), 'namespace' => 'Only include pages in these namespaces', + 'type' => 'What type of category members to include', 'sort' => 'Property to sort by', 'dir' => 'In which direction to sort', 'start' => "Timestamp to start listing from. Can only be used with {$p}sort=timestamp", -- 2.20.1