MediaWiki  master
checkUsernames.php
Go to the documentation of this file.
1 <?php
24 require_once __DIR__ . '/Maintenance.php';
25 
27 
36 class CheckUsernames extends Maintenance {
37 
38  public function __construct() {
39  parent::__construct();
40  $this->addDescription( 'Verify that database usernames are actually valid' );
41  $this->setBatchSize( 1000 );
42  }
43 
44  public function execute() {
45  $dbr = $this->getDB( DB_REPLICA );
46  $userNameUtils = MediaWikiServices::getInstance()->getUserNameUtils();
47 
48  $maxUserId = 0;
49  do {
50  $res = $dbr->select( 'user',
51  [ 'user_id', 'user_name' ],
52  [ 'user_id > ' . $maxUserId ],
53  __METHOD__,
54  [
55  'ORDER BY' => 'user_id',
56  'LIMIT' => $this->getBatchSize(),
57  ]
58  );
59 
60  foreach ( $res as $row ) {
61  if ( !$userNameUtils->isValid( $row->user_name ) ) {
62  $this->output( sprintf( "Found: %6d: '%s'\n", $row->user_id, $row->user_name ) );
63  wfDebugLog( 'checkUsernames', $row->user_name );
64  }
65  }
66  $maxUserId = $row->user_id;
67  } while ( $res->numRows() );
68  }
69 }
70 
71 $maintClass = CheckUsernames::class;
72 require_once RUN_MAINTENANCE_IF_MAIN;
MediaWiki\MediaWikiServices
MediaWikiServices is the service locator for the application scope of MediaWiki.
Definition: MediaWikiServices.php:200
Maintenance\addDescription
addDescription( $text)
Set the description text.
Definition: Maintenance.php:329
Maintenance
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
Definition: Maintenance.php:59
$res
$res
Definition: testCompression.php:57
wfDebugLog
wfDebugLog( $logGroup, $text, $dest='all', array $context=[])
Send a line to a supplementary debug log file, if configured, or main debug log if not.
Definition: GlobalFunctions.php:958
$dbr
$dbr
Definition: testCompression.php:54
CheckUsernames
Maintenance script to check that database usernames are actually valid.
Definition: checkUsernames.php:36
CheckUsernames\execute
execute()
Do the actual work.
Definition: checkUsernames.php:44
DB_REPLICA
const DB_REPLICA
Definition: defines.php:25
Maintenance\getDB
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
Definition: Maintenance.php:1375
Maintenance\getBatchSize
getBatchSize()
Returns batch size.
Definition: Maintenance.php:368
$maintClass
$maintClass
Definition: checkUsernames.php:71
Maintenance\output
output( $out, $channel=null)
Throw some output to the user.
Definition: Maintenance.php:435
CheckUsernames\__construct
__construct()
Default constructor.
Definition: checkUsernames.php:38
Maintenance\setBatchSize
setBatchSize( $s=0)
Definition: Maintenance.php:375