Prints details about the current running job

NOTE: The following code is executed when 'drush trpjob-curr' or 'drush tripal-current-job' is called

File

tripal_core/tripal_core.drush.inc, line 220

Contains function relating to drush-integration of this module.

Code

function drush_tripal_core_tripal_jobs_current() {
  $sql = "SELECT * FROM {tripal_jobs} TJ " .
    "WHERE TJ.end_time IS NULL and NOT TJ.start_time IS NULL ";
  $jobs = db_query($sql);
  while ($job = db_fetch_object($jobs)) {
    $job_pid = $job->pid;
    $output = "Name: " . $job->job_name . "\n"
      . "Submitted: " . date(DATE_RFC822, $job->submit_date) . "\n"
      . "Started: " . date(DATE_RFC822, $job->start_time) . "\n"
      . "Module: " . $job->modulename . "\n"
      . "Callback: " . $job->callback . "\n"
      . "Process ID: " . $job->pid . "\n"
      . "Progress: " . $job->progress . "%\n";
    drush_print($output);
  }
  if (!$job_pid) {
    drush_print('There are currently no running jobs.');
  }
  //log to the command line with an OK status
  drush_log('Running tripal-current-job', 'ok');
}