Changeset 27154

Timestamp:

Mar 3, 2010, 12:07:36 PM (16 years ago)

Author:

Paul Price

Message:

Adding hostname and stacks.

File:

• trunk/tools/errors.pl (modified) (2 diffs)

trunk/tools/errors.pl

@@ -47 +47 @@
 my $sql;                        # Query to run
 if ($stage eq "diff") {
-    $sql = "SELECT diff_id, skycell_id, path_base FROM diffRun JOIN diffSkyfile USING(diff_id) WHERE fault != 0";
+    $sql = "SELECT diff_id, skycell_id, hostname, path_base FROM diffRun JOIN diffSkyfile USING(diff_id) WHERE fault != 0";
+} elsif ($stage eq "stack") {
+    $sql = "SELECT stack_id, 'stack', hostname, path_base FROM stackRun JOIN stackSumSkyfile USING(stack_id) WHERE fault != 0";
 } else {
     die "Unsupported stage: $stage\n";
@@ -73 +75 @@
     my $id1 = $$row[0];
     my $id2 = $$row[1];
-    my $path = $$row[2];
+    my $hostname = $$row[2];
+    my $path = $$row[3];
 
-    my $name = "$id1.$id2";
+    my $name = "$id1.$id2($hostname)";
 
     unless (defined $path) {