MediaWiki  master
showSiteStats.php
Go to the documentation of this file.
1 <?php
2 
32 require_once __DIR__ . '/Maintenance.php';
33 
39 class ShowSiteStats extends Maintenance {
40  public function __construct() {
41  parent::__construct();
42  $this->addDescription( 'Show the cached statistics' );
43  }
44 
45  public function execute() {
46  $fields = [
47  'ss_total_edits' => 'Total edits',
48  'ss_good_articles' => 'Number of articles',
49  'ss_total_pages' => 'Total pages',
50  'ss_users' => 'Number of users',
51  'ss_active_users' => 'Active users',
52  'ss_images' => 'Number of images',
53  ];
54 
55  // Get cached stats from a replica DB
56  $dbr = $this->getDB( DB_REPLICA );
57  $stats = $dbr->newSelectQueryBuilder()
58  ->select( '*' )
59  ->from( 'site_stats' )
60  ->caller( __METHOD__ )->fetchRow();
61 
62  // Get maximum size for each column
63  $max_length_value = $max_length_desc = 0;
64  foreach ( $fields as $field => $desc ) {
65  $max_length_value = max( $max_length_value, strlen( $stats->$field ) );
66  $max_length_desc = max( $max_length_desc, strlen( $desc ) );
67  }
68 
69  // Show them
70  foreach ( $fields as $field => $desc ) {
71  $this->output( sprintf(
72  "%-{$max_length_desc}s: %{$max_length_value}d\n",
73  $desc,
74  $stats->$field
75  ) );
76  }
77  }
78 }
79 
80 $maintClass = ShowSiteStats::class;
81 require_once RUN_MAINTENANCE_IF_MAIN;
Abstract maintenance class for quickly writing and churning out maintenance scripts with minimal effo...
Definition: Maintenance.php:66
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
output( $out, $channel=null)
Throw some output to the user.
addDescription( $text)
Set the description text.
Maintenance script to show the cached statistics.
__construct()
Default constructor.
execute()
Do the actual work.
const DB_REPLICA
Definition: defines.php:26
$maintClass