Merge maintenance-work branch:
[lhc/web/wiklou.git] / maintenance / nukeNS.php
index 4f9fe92..bd4eae0 100644 (file)
  * based on nukePage by Rob Church
  */
 
-require_once( 'commandLine.inc' );
-require_once( 'nukePage.inc' );
+require_once( "Maintenance.php" );
 
-$ns = NS_MEDIAWIKI;
-$delete = false;
+class NukeNS extends Maintenance {
+       public function __construct() {
+               parent::__construct();
+               $this->mDescription = "Remove pages with only 1 revision from any namespace";
+               $this->addParam( 'delete', "Actually delete the page" );
+               $this->addParam( 'ns', 'Namespace to delete from, default NS_MEDIAWIKI', false, true );
+       }
 
-if (isset($options['ns'])) 
-{
-  $ns = $options['ns'];
-}
+       public function execute() {
+               $ns = $this->getOption( 'ns', NS_MEDIAWIKI );
+               $delete = $this->getOption( 'delete', false );
+               $dbw = wfGetDB( DB_MASTER );
+               $dbw->begin();
 
-if (isset( $options['delete'] ) and $options['delete']) 
-{
-  $delete = true;
-}
+               $tbl_pag = $dbw->tableName( 'page' );
+               $tbl_rev = $dbw->tableName( 'revision' );
+               $res = $dbw->query( "SELECT page_title FROM $tbl_pag WHERE page_namespace = $ns" );
 
+               $n_deleted = 0;
 
-NukeNS( $ns, $delete);
+               while( $row = $dbw->fetchObject( $res ) ) {
+                       //echo "$ns_name:".$row->page_title, "\n";
+                       $title = Title::newFromText($row->page_title, $ns);
+                       $id   = $title->getArticleID();
 
-function NukeNS($ns_no, $delete) {
+                       // Get corresponding revisions
+                       $res2 = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_page = $id" );
+                       $revs = array();
 
-  $dbw = wfGetDB( DB_MASTER );
-  $dbw->begin();
-  
-  $tbl_pag = $dbw->tableName( 'page' );
-  $tbl_rev = $dbw->tableName( 'revision' );
-  $res = $dbw->query( "SELECT page_title FROM $tbl_pag WHERE page_namespace = $ns_no" );
+                       while( $row2 = $dbw->fetchObject( $res2 ) ) {
+                               $revs[] = $row2->rev_id;
+                       }
+                       $count = count( $revs );
 
-  $n_deleted = 0;
-  
-  while( $row = $dbw->fetchObject( $res ) ) {
-    //echo "$ns_name:".$row->page_title, "\n";
-    $title = Title::newFromText($row->page_title, $ns_no);
-    $id   = $title->getArticleID();
+                       //skip anything that looks modified (i.e. multiple revs)
+                       if (($count == 1)) {
+                               #echo $title->getPrefixedText(), "\t", $count, "\n";
+                               $this->output( "delete: ", $title->getPrefixedText(), "\n" );
 
-    // Get corresponding revisions
-    $res2 = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_page = $id" );
-    $revs = array();
-    
-    while( $row2 = $dbw->fetchObject( $res2 ) ) {
-      $revs[] = $row2->rev_id;
-    }
-    $count = count( $revs );
+                               //as much as I hate to cut & paste this, it's a little different, and
+                               //I already have the id & revs
+                               if( $delete ) {
+                                       $dbw->query( "DELETE FROM $tbl_pag WHERE page_id = $id" );
+                                       $dbw->commit();
+                                       // Delete revisions as appropriate
+                                       $child = $this->spawnChild( 'NukePage', 'NukePage.php' );
+                                       $child->deleteRevisions( $revs );
+                                       $this->purgeRedundantText( true );
+                                       $n_deleted ++;
+                               }
+                       } else {
+                         $this->output( "skip: ", $title->getPrefixedText(), "\n" );
+                       }
+               }
+               $dbw->commit();
 
-    //skip anything that looks modified (i.e. multiple revs)
-    if (($count == 1)) {
-      #echo $title->getPrefixedText(), "\t", $count, "\n";
-      echo "delete: ", $title->getPrefixedText(), "\n";
-      
-      //as much as I hate to cut & paste this, it's a little different, and
-      //I already have the id & revs
-      
-      if( $delete ) {
-       $dbw->query( "DELETE FROM $tbl_pag WHERE page_id = $id" );
-       $dbw->commit();
-       // Delete revisions as appropriate
-       DeleteRevisions( $revs );
-       PurgeRedundantText( true );
-       $n_deleted ++;
-      }
-    } else {
-      echo "skip: ", $title->getPrefixedText(), "\n";
-    }
-    
-    
-  }
-  $dbw->commit();
-  
-  if ($n_deleted > 0) {
-    #update statistics - better to decrement existing count, or just count
-    #the page table?
-    $pages = $dbw->selectField('site_stats', 'ss_total_pages');
-    $pages -= $n_deleted;
-    $dbw->update( 'site_stats', 
-                 array('ss_total_pages' => $pages ), 
-                 array( 'ss_row_id' => 1),
-                 __METHOD__ );
-    
-  }
-  
-  if (!$delete) {
-    echo( "To update the database, run the script with the --delete option.\n" );
-  }
-  
+               if ($n_deleted > 0) {
+               #update statistics - better to decrement existing count, or just count
+               #the page table?
+               $pages = $dbw->selectField('site_stats', 'ss_total_pages');
+               $pages -= $n_deleted;
+               $dbw->update( 'site_stats', 
+                         array('ss_total_pages' => $pages ), 
+                         array( 'ss_row_id' => 1),
+                         __METHOD__ );
+               }
+       
+               if (!$delete) {
+                       $this->output( "To update the database, run the script with the --delete option.\n" );
+               }
+       }
 }
 
-
+$maintClass = "NukeNS";
+require_once( DO_MAINTENANCE );