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_PRIMARY );
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  // @phan-suppress-next-line PhanPossiblyUndeclaredVariable rows contains at least one item
97  $lastPageValue = $row->pp_page;
98  // And the propname...
99  // @phan-suppress-next-line PhanPossiblyUndeclaredVariable rows contains at least one item
100  $lastProp = $row->pp_propname;
101  }
102 
103  $this->output( "Populating page_props.pp_sortkey complete.\n" );
104  $this->output( "Updated a total of $editedRowCount rows\n" );
105  return true;
106  }
107 
108  protected function getUpdateKey() {
109  return 'populate pp_sortkey';
110  }
111 }
112 
113 $maintClass = PopulatePPSortKey::class;
114 require_once RUN_MAINTENANCE_IF_MAIN;
Class for scripts that perform database maintenance and want to log the update in updatelog so we can...
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
beginTransaction(IDatabase $dbw, $fname)
Begin a transaction on a DB.
commitTransaction(IDatabase $dbw, $fname)
Commit the transaction 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)
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_PRIMARY
Definition: defines.php:28