MediaWiki  master
attachLatest.php
Go to the documentation of this file.
1 <?php
29 
30 require_once __DIR__ . '/Maintenance.php';
31 
38 class AttachLatest extends Maintenance {
39  public function __construct() {
40  parent::__construct();
41  $this->addOption( "fix", "Actually fix the entries, will dry run otherwise" );
42  $this->addOption( "regenerate-all",
43  "Regenerate the page_latest field for all records in table page" );
44  $this->addDescription( 'Fix page_latest entries in the page table' );
45  }
46 
47  public function execute() {
48  $this->output( "Looking for pages with page_latest set to 0...\n" );
49  $dbw = $this->getDB( DB_PRIMARY );
50  $conds = [ 'page_latest' => 0 ];
51  if ( $this->hasOption( 'regenerate-all' ) ) {
52  $conds = '';
53  }
54  $result = $dbw->newSelectQueryBuilder()
55  ->select( [ 'page_id', 'page_namespace', 'page_title' ] )
56  ->from( 'page' )
57  ->where( $conds )
58  ->caller( __METHOD__ )
59  ->fetchResultSet();
60 
61  $services = $this->getServiceContainer();
62  $dbDomain = $services->getDBLoadBalancerFactory()->getLocalDomainID();
63  $wikiPageFactory = $services->getWikiPageFactory();
64  $revisionLookup = $services->getRevisionLookup();
65 
66  $n = 0;
67  foreach ( $result as $row ) {
68  $pageId = intval( $row->page_id );
69  $title = Title::makeTitle( $row->page_namespace, $row->page_title );
70  $name = $title->getPrefixedText();
71  $latestTime = $dbw->newSelectQueryBuilder()
72  ->select( 'MAX(rev_timestamp' )
73  ->from( 'revision' )
74  ->where( [ 'rev_page' => $pageId ] )
75  ->caller( __METHOD__ )
76  ->fetchField();
77  if ( !$latestTime ) {
78  $this->output( "$dbDomain $pageId [[$name]] can't find latest rev time?!\n" );
79  continue;
80  }
81 
82  $revRecord = $revisionLookup->getRevisionByTimestamp( $title, $latestTime, RevisionLookup::READ_LATEST );
83  if ( $revRecord === null ) {
84  $this->output(
85  "$dbDomain $pageId [[$name]] latest time $latestTime, can't find revision id\n"
86  );
87  continue;
88  }
89 
90  $id = $revRecord->getId();
91  $this->output( "$dbDomain $pageId [[$name]] latest time $latestTime, rev id $id\n" );
92  if ( $this->hasOption( 'fix' ) ) {
93  $page = $wikiPageFactory->newFromTitle( $title );
94  $page->updateRevisionOn( $dbw, $revRecord );
95  $this->waitForReplication();
96  }
97  $n++;
98  }
99  $this->output( "Done! Processed $n pages.\n" );
100  if ( !$this->hasOption( 'fix' ) ) {
101  $this->output( "This was a dry run; rerun with --fix to update page_latest.\n" );
102  }
103  }
104 }
105 
106 $maintClass = AttachLatest::class;
107 require_once RUN_MAINTENANCE_IF_MAIN;
$maintClass
Maintenance script to correct wrong values in the page_latest field in the database.
execute()
Do the actual work.
__construct()
Default constructor.
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.
output( $out, $channel=null)
Throw some output to the user.
waitForReplication()
Wait for replica DBs to catch up.
hasOption( $name)
Checks to see if a particular option was set.
getServiceContainer()
Returns the main service container.
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
Service for looking up page revisions.
const DB_PRIMARY
Definition: defines.php:28