Changeset 18149

Timestamp:

Jun 16, 2008, 12:32:44 PM (18 years ago)

Author:

Paul Price

Message:

Updating to use fakeRun table as part of the chain.

File:

• trunk/ippScripts/scripts/ipp_serial_mops.pl (modified) (1 diff)

trunk/ippScripts/scripts/ipp_serial_mops.pl

@@ -69 +69 @@
     die "Unable to connect to database: $DBI::errstr";
 
-my $sql = "select exp_id, diff_id, skycell_id, warp_id, diffSkyfile.path_base as diff_path_base, warpSkyfile.path_base as warp_path_base from diffSkyfile join diffRun using(diff_id) join diffInputSkyfile using(diff_id,tess_id,skycell_id) join warpRun using(warp_id,tess_id) join warpSkyfile using(warp_id,skycell_id,tess_id) join camRun using(cam_id) join chipRun using(chip_id) join rawExp using(exp_id) where diffSkyfile.fault = 0 and rawExp.camera = \'$camera\';";
+my $sql = "SELECT exp_id, diff_id, skycell_id, warp_id, diffSkyfile.path_base AS diff_path_base, warpSkyfile.path_base AS warp_path_base FROM diffSkyfile JOIN diffRun using(diff_id) JOIN diffInputSkyfile USING(diff_id,tess_id,skycell_id) JOIN warpRun USING(warp_id,tess_id) JOIN warpSkyfile USING(warp_id,skycell_id,tess_id) JOIN fakeRun using(fake_id) JOIN camRun USING(cam_id) JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE diffSkyfile.fault = 0 AND rawExp.camera = \'$camera\';";
 
 my $rows = $db->selectall_arrayref( $sql, { Slice => {} } ) or die "Unable to execute SQL: $DBI::errstr";