ajaxwatch.js: coding style tweaks

[lhc/web/wiklou.git] / maintenance / showJobs.php

diff --git a/maintenance/showJobs.php b/maintenance/showJobs.php
index beff294..1e66377 100644 (file)
--- a/maintenance/showJobs.php
+++ b/maintenance/showJobs.php
@@ -24,16 +24,30 @@
  * @author Ashar Voultoiz
  */
  
-require_once( dirname(__FILE__) . '/Maintenance.php' );
+require_once( dirname( __FILE__ ) . '/Maintenance.php' );
 
 class ShowJobs extends Maintenance {
        public function __construct() {
                parent::__construct();
                $this->mDescription = "Show number of jobs waiting in master database";
+               $this->addOption( 'group', 'Show number of jobs per job type' );
        }
        public function execute() {
                $dbw = wfGetDB( DB_MASTER );
-               $this->output( $dbw->selectField( 'job', 'count(*)', '', __METHOD__ ) . "\n" );
+               if ( $this->hasOption( 'group' ) ) {
+                       $res = $dbw->select(
+                               'job',
+                               array( 'job_cmd', 'count(*) as count' ),
+                               array(),
+                               __METHOD__,
+                               array( 'GROUP BY' => 'job_cmd' )
+                       );
+                       foreach ( $res as $row ) {
+                               $this->output( $row->job_cmd . ': ' . $row->count . "\n" );
+                       }
+               } else {
+                       $this->output( $dbw->selectField( 'job', 'count(*)', '', __METHOD__ ) . "\n" );
+               }
        }
 }