MediaWiki REL1_35
populatePPSortKey.php
Go to the documentation of this file.
1<?php
24require_once __DIR__ . '/Maintenance.php';
25
31 public function __construct() {
32 parent::__construct();
33 $this->addDescription( 'Populate the pp_sortkey field' );
34 $this->setBatchSize( 100 );
35 }
36
37 protected function doDBUpdates() {
38 $dbw = $this->getDB( DB_MASTER );
39
40 $lastProp = null;
41 $lastPageValue = 0;
42
43 $lastRowCount = 0;
44 $editedRowCount = 0;
45
46 $this->output( "Populating page_props.pp_sortkey...\n" );
47 while ( true ) {
48 $conditions = [ 'pp_sortkey IS NULL' ];
49 if ( $lastPageValue !== 0 ) {
50 $conditions[] = 'pp_page > ' . $dbw->addQuotes( $lastPageValue ) . ' OR ' .
51 '( pp_page = ' . $dbw->addQuotes( $lastPageValue ) .
52 ' AND pp_propname > ' . $dbw->addQuotes( $lastProp ) . ' )';
53 }
54
55 $res = $dbw->select(
56 'page_props',
57 [ 'pp_propname', 'pp_page', 'pp_sortkey', 'pp_value' ],
58 $conditions,
59 __METHOD__,
60 [
61 'ORDER BY' => [ 'pp_page', 'pp_propname' ],
62 'LIMIT' => $this->getBatchSize()
63 ]
64 );
65
66 if ( $res->numRows() === 0 ) {
67 break;
68 }
69
70 $this->beginTransaction( $dbw, __METHOD__ );
71
72 foreach ( $res as $row ) {
73 if ( !is_numeric( $row->pp_value ) ) {
74 continue;
75 }
76 $dbw->update(
77 'page_props',
78 [ 'pp_sortkey' => $row->pp_value ],
79 [
80 'pp_page' => $row->pp_page,
81 'pp_propname' => $row->pp_propname
82 ],
83 __METHOD__
84 );
85 $editedRowCount++;
86 }
87
88 if ( $editedRowCount !== $lastRowCount ) {
89 $this->output( "Updated " . $editedRowCount . " rows\n" );
90 $lastRowCount = $editedRowCount;
91 }
92
93 $this->commitTransaction( $dbw, __METHOD__ );
94
95 // We need to get the last element's page ID
96 $lastPageValue = $row->pp_page;
97 // And the propname...
98 $lastProp = $row->pp_propname;
99 }
100
101 $this->output( "Populating page_props.pp_sortkey complete.\n" );
102 $this->output( "Updated a total of $editedRowCount rows\n" );
103 return true;
104 }
105
106 protected function getUpdateKey() {
107 return 'populate pp_sortkey';
108 }
109}
110
111$maintClass = PopulatePPSortKey::class;
112require_once RUN_MAINTENANCE_IF_MAIN;
getDB()
const RUN_MAINTENANCE_IF_MAIN
Class for scripts that perform database maintenance and want to log the update in updatelog so we can...
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.
output( $out, $channel=null)
Throw some output to the user.
getBatchSize()
Returns batch size.
addDescription( $text)
Set the description text.
setBatchSize( $s=0)
Set the batch size.
Usage: populatePPSortKey.php.
__construct()
Default constructor.
doDBUpdates()
Do the actual work.
getUpdateKey()
Get the update key name to go in the update log table.
const DB_MASTER
Definition defines.php:29