X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2FpurgeList.php;h=fb66db0036c676d4317d04802c14808466e8de24;hb=34030158811f858efa57e09f0ac1ae66bc85fac2;hp=4b3c3821903a8602c7db9f5241965af1aaf2a95c;hpb=a1a296ac845aa37bfb34f0ca0085de67f9b2e8c4;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/purgeList.php b/maintenance/purgeList.php index 4b3c382190..fb66db0036 100644 --- a/maintenance/purgeList.php +++ b/maintenance/purgeList.php @@ -32,22 +32,27 @@ class PurgeList extends Maintenance { public function __construct() { parent::__construct(); $this->mDescription = "Send purge requests for listed pages to squid"; - $this->addOption( 'purge', 'Whether to update page_touched.' , false, false ); + $this->addOption( 'purge', 'Whether to update page_touched.', false, false ); $this->addOption( 'namespace', 'Namespace number', false, true ); + $this->addOption( 'all', 'Purge all pages', false, false ); + $this->addOption( 'delay', 'Number of seconds to delay between each purge', false, true ); + $this->addOption( 'verbose', 'Show more output', false, false, 'v' ); $this->setBatchSize( 100 ); } public function execute() { - if( $this->hasOption( 'namespace' ) ) { - $this->purgeNamespace(); + if ( $this->hasOption( 'all' ) ) { + $this->purgeNamespace( false ); + } elseif ( $this->hasOption( 'namespace' ) ) { + $this->purgeNamespace( intval( $this->getOption( 'namespace') ) ); } else { - $this->purgeList(); + $this->doPurge(); } $this->output( "Done!\n" ); } /** Purge URL coming from stdin */ - private function purgeList() { + private function doPurge() { $stdin = $this->getStdin(); $urls = array(); @@ -58,7 +63,7 @@ class PurgeList extends Maintenance { } elseif ( $page !== '' ) { $title = Title::newFromText( $page ); if ( $title ) { - $url = $title->getInternalUrl(); + $url = $title->getInternalURL(); $this->output( "$url\n" ); $urls[] = $url; if ( $this->getOption( 'purge' ) ) { @@ -69,56 +74,41 @@ class PurgeList extends Maintenance { } } } + $this->output( "Purging " . count( $urls ). " urls\n" ); $this->sendPurgeRequest( $urls ); } - /** Purge a namespace given by --namespace */ - private function purgeNamespace() { + /** Purge a namespace or all pages */ + private function purgeNamespace( $namespace = false ) { $dbr = wfGetDB( DB_SLAVE ); - $ns = $dbr->addQuotes( $this->getOption( 'namespace') ); - - $result = $dbr->select( - array( 'page' ), - array( 'page_namespace', 'page_title' ), - array( "page_namespace = $ns" ), - __METHOD__, - array( 'ORDER BY' => 'page_id' ) - ); - - $start = 0; - $end = $dbr->numRows( $result ); - $this->output( "Will purge $end pages from namespace $ns\n" ); - - # Do remaining chunk - $end += $this->mBatchSize - 1; - $blockStart = $start; - $blockEnd = $start + $this->mBatchSize - 1; - - while( $blockEnd <= $end ) { - # Select pages we will purge: - $result = $dbr->select( - array( 'page' ), - array( 'page_namespace', 'page_title' ), - array( "page_namespace = $ns" ), + $startId = 0; + if ( $namespace === false ) { + $conds = array(); + } else { + $conds = array( 'page_namespace' => $namespace ); + } + while ( true ) { + $res = $dbr->select( 'page', + array( 'page_id', 'page_namespace', 'page_title' ), + $conds + array( 'page_id > ' . $dbr->addQuotes( $startId ) ), __METHOD__, - array( # conditions - 'ORDER BY' => 'page_id', - 'LIMIT' => $this->mBatchSize, - 'OFFSET' => $blockStart, + array( + 'LIMIT' => $this->mBatchSize, + 'ORDER BY' => 'page_id' + ) ); - # Initialize/reset URLs to be purged + if ( !$res->numRows() ) { + break; + } $urls = array(); - foreach( $result as $row ) { + foreach ( $res as $row ) { $title = Title::makeTitle( $row->page_namespace, $row->page_title ); - $url = $title->getInternalUrl(); + $url = $title->getInternalURL(); $urls[] = $url; + $startId = $row->page_id; } - $this->sendPurgeRequest( $urls ); - - $blockStart += $this->mBatchSize; - $blockEnd += $this->mBatchSize; } } @@ -127,9 +117,23 @@ class PurgeList extends Maintenance { * @param $urls array List of URLS to purge from squids */ private function sendPurgeRequest( $urls ) { - $this->output( "Purging " . count( $urls ). " urls\n" ); - $u = new SquidUpdate( $urls ); - $u->doUpdate(); + if ( $this->hasOption( 'delay' ) ) { + $delay = floatval( $this->getOption( 'delay' ) ); + foreach ( $urls as $url ) { + if ( $this->hasOption( 'verbose' ) ) { + $this->output( $url . "\n" ); + } + $u = new SquidUpdate( array( $url ) ); + $u->doUpdate(); + usleep( $delay * 1e6 ); + } + } else { + if ( $this->hasOption( 'verbose' ) ) { + $this->output( implode( "\n", $urls ) . "\n" ); + } + $u = new SquidUpdate( $urls ); + $u->doUpdate(); + } } }