Changeset 30368 for trunk/tools/heather/expbot.pl

Timestamp:

Jan 25, 2011, 2:43:40 PM (15 years ago)

Author:

heather

Message:

fixed

File:

• trunk/tools/heather/expbot.pl (modified) (2 diffs)

trunk/tools/heather/expbot.pl

@@ -141 +141 @@
 print `date`;
 
-my $dist1q = "select exp_name, comment, rawExp.state, count(stage_id) from rawExp left join chipRun using (exp_id) left join camRun using (chip_id) left join distRun on cam_id = stage_id and stage = 'camera' where dateobs like '$date%' and exp_type = 'OBJECT' group by exp_name;";
+my $dist1q = "select exp_name, comment, rawExp.state, count(stage_id) from rawExp left join chipRun using (exp_id) left join distRun on chip_id = stage_id and stage = 'chip' where dateobs like '$date%' and exp_type = 'OBJECT' group by exp_name;";
 my $dist1 = $db->selectall_arrayref($dist1q) || 
     die "Unable to execute SQL: $DBI::errstr\n";
@@ -173 +173 @@
 
 print `date`;
-my $dist3q =  "select exp_name, comment, rawExp.state, count(stage_id) from rawExp left join chipRun using (exp_id) left join camRun using (chip_id) left join distRun on cam_id = stage_id and stage = 'camera' where dateobs like '$date%' and exp_type = 'OBJECT' group by exp_name;";
+my $dist3q =  "select exp_name, comment, rawExp.state, count(stage_id) from rawExp left join chipRun using (exp_id) left join camRun using (chip_id) left join fakeRun using (cam_id) left join warpRun using (fake_id) left join distRun on warp_id = stage_id and stage = 'warp' where dateobs like '$date%' and exp_type = 'OBJECT' group by exp_name;";
 my $dist3 = $db->selectall_arrayref($dist3q) || 
     die "Unable to execute SQL: $DBI::errstr\n";