maintenance/showJobs.php

   1 <?php
   2 /**
   3  * Based on runJobs.php
   4  *
   5  * Report number of jobs currently waiting in master database.
   6  *
   7  * This program is free software; you can redistribute it and/or modify
   8  * it under the terms of the GNU General Public License as published by
   9  * the Free Software Foundation; either version 2 of the License, or
  10  * (at your option) any later version.
  11  *
  12  * This program is distributed in the hope that it will be useful,
  13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15  * GNU General Public License for more details.
  16  *
  17  * You should have received a copy of the GNU General Public License along
  18  * with this program; if not, write to the Free Software Foundation, Inc.,
  19  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  20  * http://www.gnu.org/copyleft/gpl.html
  21  *
  22  * @ingroup Maintenance
  23  * @author Tim Starling
  24  * @author Antoine Musso
  25  */
  26
  27 require_once( dirname( __FILE__ ) . '/Maintenance.php' );
  28
  29 class ShowJobs extends Maintenance {
  30         public function __construct() {
  31                 parent::__construct();
  32                 $this->mDescription = "Show number of jobs waiting in master database";
  33                 $this->addOption( 'group', 'Show number of jobs per job type' );
  34         }
  35         public function execute() {
  36                 $dbw = wfGetDB( DB_MASTER );
  37                 if ( $this->hasOption( 'group' ) ) {
  38                         $res = $dbw->select(
  39                                 'job',
  40                                 array( 'job_cmd', 'count(*) as count' ),
  41                                 array(),
  42                                 __METHOD__,
  43                                 array( 'GROUP BY' => 'job_cmd' )
  44                         );
  45                         foreach ( $res as $row ) {
  46                                 $this->output( $row->job_cmd . ': ' . $row->count . "\n" );
  47                         }
  48                 } else {
  49                         $this->output( $dbw->selectField( 'job', 'count(*)', '', __METHOD__ ) . "\n" );
  50                 }
  51         }
  52 }
  53
  54 $maintClass = "ShowJobs";
  55 require_once( RUN_MAINTENANCE_IF_MAIN );