MediaWiki  master
nukePage.php
Go to the documentation of this file.
1 <?php
26 require_once __DIR__ . '/Maintenance.php';
27 
29 
35 class NukePage extends Maintenance {
36  public function __construct() {
37  parent::__construct();
38  $this->addDescription( 'Remove a page record from the database' );
39  $this->addOption( 'delete', "Actually delete the page" );
40  $this->addArg( 'title', 'Title to delete' );
41  }
42 
43  public function execute() {
44  $name = $this->getArg( 0 );
45  $delete = $this->hasOption( 'delete' );
46 
47  $dbw = $this->getDB( DB_PRIMARY );
48  $this->beginTransaction( $dbw, __METHOD__ );
49 
50  # Get page ID
51  $this->output( "Searching for \"$name\"..." );
52  $title = Title::newFromText( $name );
53  if ( $title ) {
54  $id = $title->getArticleID();
55  $real = $title->getPrefixedText();
56  $isGoodArticle = $title->isContentPage();
57  $this->output( "found \"$real\" with ID $id.\n" );
58 
59  # Get corresponding revisions
60  $this->output( "Searching for revisions..." );
61 
62  $revs = $dbw->newSelectQueryBuilder()
63  ->select( 'rev_id' )
64  ->from( 'revision' )
65  ->where( [ 'rev_page' => $id ] )
66  ->caller( __METHOD__ )->fetchFieldValues();
67  $count = count( $revs );
68  $this->output( "found $count.\n" );
69 
70  # Delete the page record and associated recent changes entries
71  if ( $delete ) {
72  $this->output( "Deleting page record..." );
73  $dbw->delete( 'page', [ 'page_id' => $id ], __METHOD__ );
74  $this->output( "done.\n" );
75  $this->output( "Cleaning up recent changes..." );
76  $dbw->delete( 'recentchanges', [ 'rc_cur_id' => $id ], __METHOD__ );
77  $this->output( "done.\n" );
78  }
79 
80  $this->commitTransaction( $dbw, __METHOD__ );
81 
82  # Delete revisions as appropriate
83  if ( $delete && $count ) {
84  $this->output( "Deleting revisions..." );
85  $this->deleteRevisions( $revs );
86  $this->output( "done.\n" );
87  $this->purgeRedundantText( true );
88  }
89 
90  # Update stats as appropriate
91  if ( $delete ) {
92  $this->output( "Updating site stats..." );
93  // if it was good, decrement that too
94  $ga = $isGoodArticle ? -1 : 0;
95  $stats = SiteStatsUpdate::factory( [
96  'edits' => -$count,
97  'articles' => $ga,
98  'pages' => -1
99  ] );
100  $stats->doUpdate();
101  $this->output( "done.\n" );
102  }
103  } else {
104  $this->output( "not found in database.\n" );
105  $this->commitTransaction( $dbw, __METHOD__ );
106  }
107  }
108 
109  public function deleteRevisions( $ids ) {
110  $dbw = $this->getDB( DB_PRIMARY );
111  $this->beginTransaction( $dbw, __METHOD__ );
112 
113  $dbw->delete( 'revision', [ 'rev_id' => $ids ], __METHOD__ );
114 
115  $this->commitTransaction( $dbw, __METHOD__ );
116  }
117 }
118 
119 $maintClass = NukePage::class;
120 require_once RUN_MAINTENANCE_IF_MAIN;
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
Definition: Maintenance.php:66
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
addArg( $arg, $description, $required=true, $multi=false)
Add some args that are needed.
beginTransaction(IDatabase $dbw, $fname)
Begin a transaction on a DB.
commitTransaction(IDatabase $dbw, $fname)
Commit the transaction on a DB handle and wait for replica DBs to catch up.
output( $out, $channel=null)
Throw some output to the user.
hasOption( $name)
Checks to see if a particular option was set.
purgeRedundantText( $delete=true)
Support function for cleaning up redundant text records.
getArg( $argId=0, $default=null)
Get an argument.
addDescription( $text)
Set the description text.
addOption( $name, $description, $required=false, $withArg=false, $shortName=false, $multiOccurrence=false)
Add a parameter to the script.
Represents a title within MediaWiki.
Definition: Title.php:76
Maintenance script that erases a page record from the database.
Definition: nukePage.php:35
deleteRevisions( $ids)
Definition: nukePage.php:109
__construct()
Default constructor.
Definition: nukePage.php:36
execute()
Do the actual work.
Definition: nukePage.php:43
static factory(array $deltas)
$maintClass
Definition: nukePage.php:119
const DB_PRIMARY
Definition: defines.php:28