Changeset 20728

Timestamp:

Nov 13, 2008, 2:21:48 PM (17 years ago)

Author:

Paul Price

Message:

Fixing SQL and file extensions.

File:

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

trunk/tools/warp_inputs.pl

@@ -12 +12 @@
 use Getopt::Long qw( GetOptions :config auto_help auto_version gnu_getopt );
 
-use constant IMAGE => '.fits';  # Image extension
-use constant MASK => '.mask.fits'; # Mask extension
-use constant WEIGHT => '.wt.fits'; # Weight extension
+use constant IMAGE => '.ch.fits';  # Image extension
+use constant MASK => '.ch.mk.fits'; # Mask extension
+use constant WEIGHT => '.ch.wt.fits'; # Weight extension
 use constant ASTROM => '.smf';  # Astrometry extension
 
@@ -60 +60 @@
     " JOIN fakeRun USING(fake_id)" .
     " JOIN camRun USING(cam_id)" .
+    " JOIN camProcessedExp USING(cam_id)" .
     " JOIN chipProcessedImfile USING(chip_id, class_id)" .
     " WHERE warp_id = $warp_id" .
-    " AND skycell_id = $skycell_id";
+    " AND skycell_id = \'$skycell_id\'";