MediaWiki REL1_30
nukePage.php
Go to the documentation of this file.
1<?php
26require_once __DIR__ . '/Maintenance.php';
27
33class NukePage extends Maintenance {
34 public function __construct() {
35 parent::__construct();
36 $this->addDescription( 'Remove a page record from the database' );
37 $this->addOption( 'delete', "Actually delete the page" );
38 $this->addArg( 'title', 'Title to delete' );
39 }
40
41 public function execute() {
42 $name = $this->getArg();
43 $delete = $this->hasOption( 'delete' );
44
45 $dbw = $this->getDB( DB_MASTER );
46 $this->beginTransaction( $dbw, __METHOD__ );
47
48 $tbl_pag = $dbw->tableName( 'page' );
49 $tbl_rec = $dbw->tableName( 'recentchanges' );
50 $tbl_rev = $dbw->tableName( 'revision' );
51
52 # Get page ID
53 $this->output( "Searching for \"$name\"..." );
54 $title = Title::newFromText( $name );
55 if ( $title ) {
56 $id = $title->getArticleID();
57 $real = $title->getPrefixedText();
58 $isGoodArticle = $title->isContentPage();
59 $this->output( "found \"$real\" with ID $id.\n" );
60
61 # Get corresponding revisions
62 $this->output( "Searching for revisions..." );
63 $res = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_page = $id" );
64 $revs = [];
65 foreach ( $res as $row ) {
66 $revs[] = $row->rev_id;
67 }
68 $count = count( $revs );
69 $this->output( "found $count.\n" );
70
71 # Delete the page record and associated recent changes entries
72 if ( $delete ) {
73 $this->output( "Deleting page record..." );
74 $dbw->query( "DELETE FROM $tbl_pag WHERE page_id = $id" );
75 $this->output( "done.\n" );
76 $this->output( "Cleaning up recent changes..." );
77 $dbw->query( "DELETE FROM $tbl_rec WHERE rc_cur_id = $id" );
78 $this->output( "done.\n" );
79 }
80
81 $this->commitTransaction( $dbw, __METHOD__ );
82
83 # Delete revisions as appropriate
84 if ( $delete && $count ) {
85 $this->output( "Deleting revisions..." );
86 $this->deleteRevisions( $revs );
87 $this->output( "done.\n" );
88 $this->purgeRedundantText( true );
89 }
90
91 # Update stats as appropriate
92 if ( $delete ) {
93 $this->output( "Updating site stats..." );
94 $ga = $isGoodArticle ? -1 : 0; // if it was good, decrement that too
95 $stats = new SiteStatsUpdate( 0, -$count, $ga, -1 );
96 $stats->doUpdate();
97 $this->output( "done.\n" );
98 }
99 } else {
100 $this->output( "not found in database.\n" );
101 $this->commitTransaction( $dbw, __METHOD__ );
102 }
103 }
104
105 public function deleteRevisions( $ids ) {
106 $dbw = $this->getDB( DB_MASTER );
107 $this->beginTransaction( $dbw, __METHOD__ );
108
109 $tbl_rev = $dbw->tableName( 'revision' );
110
111 $set = implode( ', ', $ids );
112 $dbw->query( "DELETE FROM $tbl_rev WHERE rev_id IN ( $set )" );
113
114 $this->commitTransaction( $dbw, __METHOD__ );
115 }
116}
117
118$maintClass = "NukePage";
119require_once RUN_MAINTENANCE_IF_MAIN;
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
addArg( $arg, $description, $required=true)
Add some args that are needed.
beginTransaction(IDatabase $dbw, $fname)
Begin a transcation on a DB.
commitTransaction(IDatabase $dbw, $fname)
Commit the transcation on a DB handle and wait for replica DBs to catch up.
getDB( $db, $groups=[], $wiki=false)
Returns a database to be used by current maintenance script.
hasOption( $name)
Checks to see if a particular param exists.
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.
Maintenance script that erases a page record from the database.
Definition nukePage.php:33
deleteRevisions( $ids)
Definition nukePage.php:105
__construct()
Default constructor.
Definition nukePage.php:34
execute()
Do the actual work.
Definition nukePage.php:41
Class for handling updates to the site_stats table.
$res
Definition database.txt:21
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at etc Handles the details of getting and saving to the user table of the and dealing with sessions and cookies OutputPage Encapsulates the entire HTML page that will be sent in response to any server request It is used by calling its functions to add in any and then calling output() to send it all. It could be easily changed to send incrementally if that becomes useful
require_once RUN_MAINTENANCE_IF_MAIN
$maintClass
Definition nukePage.php:118
const DB_MASTER
Definition defines.php:26