MediaWiki  master
populatePPSortKey.php
Go to the documentation of this file.
1 <?php
24 require_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;
112 require_once RUN_MAINTENANCE_IF_MAIN;
RUN_MAINTENANCE_IF_MAIN
const RUN_MAINTENANCE_IF_MAIN
Definition: Maintenance.php:38
Maintenance\addDescription
addDescription( $text)
Set the description text.
Definition: Maintenance.php:323
PopulatePPSortKey\doDBUpdates
doDBUpdates()
Do the actual work.
Definition: populatePPSortKey.php:37
$res
$res
Definition: testCompression.php:57
Maintenance\beginTransaction
beginTransaction(IDatabase $dbw, $fname)
Begin a transcation on a DB.
Definition: Maintenance.php:1380
PopulatePPSortKey\getUpdateKey
getUpdateKey()
Get the update key name to go in the update log table.
Definition: populatePPSortKey.php:106
LoggedUpdateMaintenance
Class for scripts that perform database maintenance and want to log the update in updatelog so we can...
Definition: LoggedUpdateMaintenance.php:26
DB_MASTER
const DB_MASTER
Definition: defines.php:26
$maintClass
$maintClass
Definition: populatePPSortKey.php:111
Maintenance\commitTransaction
commitTransaction(IDatabase $dbw, $fname)
Commit the transcation on a DB handle and wait for replica DBs to catch up.
Definition: Maintenance.php:1395
Maintenance\getDB
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
Definition: Maintenance.php:1350
Maintenance\getBatchSize
getBatchSize()
Returns batch size.
Definition: Maintenance.php:362
Maintenance\output
output( $out, $channel=null)
Throw some output to the user.
Definition: Maintenance.php:429
PopulatePPSortKey\__construct
__construct()
Default constructor.
Definition: populatePPSortKey.php:31
PopulatePPSortKey
Usage: populatePPSortKey.php.
Definition: populatePPSortKey.php:30
Maintenance\setBatchSize
setBatchSize( $s=0)
Set the batch size.
Definition: Maintenance.php:370