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  $editedRowCount = 0;
43 
44  $this->output( "Populating page_props.pp_sortkey...\n" );
45  while ( true ) {
46  $conditions = [ 'pp_sortkey IS NULL' ];
47  if ( $lastPageValue !== 0 ) {
48  $conditions[] = 'pp_page > ' . $dbw->addQuotes( $lastPageValue ) . ' OR ' .
49  '( pp_page = ' . $dbw->addQuotes( $lastPageValue ) .
50  ' AND pp_propname > ' . $dbw->addQuotes( $lastProp ) . ' )';
51  }
52 
53  $res = $dbw->select(
54  'page_props',
55  [ 'pp_propname', 'pp_page', 'pp_sortkey', 'pp_value' ],
56  $conditions,
57  __METHOD__,
58  [
59  'ORDER BY' => 'pp_page, pp_propname',
60  'LIMIT' => $this->getBatchSize()
61  ]
62  );
63 
64  if ( $res->numRows() === 0 ) {
65  break;
66  }
67 
68  $this->beginTransaction( $dbw, __METHOD__ );
69 
70  foreach ( $res as $row ) {
71  if ( !is_numeric( $row->pp_value ) ) {
72  continue;
73  }
74  $dbw->update(
75  'page_props',
76  [ 'pp_sortkey' => $row->pp_value ],
77  [
78  'pp_page' => $row->pp_page,
79  'pp_propname' => $row->pp_propname
80  ],
81  __METHOD__
82  );
83  $editedRowCount++;
84  }
85 
86  $this->output( "Updated " . $editedRowCount . " rows\n" );
87  $this->commitTransaction( $dbw, __METHOD__ );
88 
89  // We need to get the last element's page ID
90  $lastPageValue = $row->pp_page;
91  // And the propname...
92  $lastProp = $row->pp_propname;
93  }
94 
95  $this->output( "Populating page_props.pp_sortkey complete.\n" );
96  return true;
97  }
98 
99  protected function getUpdateKey() {
100  return 'populate pp_sortkey';
101  }
102 }
103 
104 $maintClass = PopulatePPSortKey::class;
105 require_once RUN_MAINTENANCE_IF_MAIN;
commitTransaction(IDatabase $dbw, $fname)
Commit the transcation on a DB handle and wait for replica DBs to catch up.
const RUN_MAINTENANCE_IF_MAIN
Definition: Maintenance.php:39
setBatchSize( $s=0)
Set the batch size.
const DB_MASTER
Definition: defines.php:26
Usage: populatePPSortKey.php.
addDescription( $text)
Set the description text.
output( $out, $channel=null)
Throw some output to the user.
Class for scripts that perform database maintenance and want to log the update in updatelog so we can...
getBatchSize()
Returns batch size.
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
beginTransaction(IDatabase $dbw, $fname)
Begin a transcation on a DB.