Changeset 27557 for trunk/tools/errors.pl

Timestamp:

Apr 1, 2010, 1:31:32 PM (16 years ago)

Author:

Paul Price

Message:

Adding camera stage. Fixing chip log files.

File:

• trunk/tools/errors.pl (modified) (1 diff)

trunk/tools/errors.pl

@@ -60 +60 @@
     $table = "magicNodeResult";
 } elsif ($stage eq "chip") {
-    $sql = "SELECT chip_id, class_id, hostname, path_base FROM chipRun JOIN chipProcessedImfile USING(chip_id) WHERE fault != 0";
+    $sql = "SELECT chip_id, class_id, hostname, CONCAT(path_base, '.', class_id) FROM chipRun JOIN chipProcessedImfile USING(chip_id) WHERE fault != 0";
     $table = "chipProcessedImfile";
+} elsif ($stage eq "camera") {
+    $sql = "SELECT cam_id, 'cam', hostname, path_base FROM camRun JOIN camProcessedExp USING(cam_id) WHERE fault != 0";
+    $table = "camProcessedExp";
 } else {
     die "Unsupported stage: $stage\n";