Changeset 34933 for trunk/ippTools/share

Timestamp:

Jan 15, 2013, 5:12:54 PM (14 years ago)

Author:

bills

Message:

implement releasetool -definerelexp
start implementation of releasetool -listrelexp

Location:

trunk/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• releasetool_definerelexp.sql (added)
• releasetool_listrelexp.sql (modified) (1 diff)

trunk/ippTools/share/Makefile.am

@@ -464 +464 @@
         releasetool_listsurvey.sql \
         releasetool_listrelease.sql \
-        releasetool_listrelexp.sql
+        releasetool_listrelexp.sql \
+        releasetool_definerelexp.sql
 

trunk/ippTools/share/releasetool_listrelexp.sql

@@ -1 @@
-SELECT * 
+SELECT
+    relexp_id,
+    releaseName,
+    relExp.state,
+    rel_id,
+    survey.surveyName,
+    exp_name,
+    relExp.flags,
+    relExp.zpt_obs,
+    relExp.zpt_stdev,
+    relExp.path_base,
+    relExp.registered,
+    relExp.time_stamp,
+    exp_id,
+    chip_id,
+    chipRun.state as chip_state,
+    cam_id,
+    camRun.state as cam_state,
+    camProcessedExp.path_base as cam_path_base,
+    warp_id,
+    warpRun.state as warp_state,
+    rawExp.filter,
+    rawExp.dateobs,
+    TRUNCATE(DEGREES(rawExp.ra), 4) AS radeg,
+    TRUNCATE(DEGREES(rawExp.decl), 4) AS decdeg,
+    rawExp.object,
+    rawExp.comment
 FROM relExp 
-JOIN release USING(rel_id) 
-JOIN survey using(surveyID)
+JOIN ippRelease USING(rel_id) 
+JOIN survey USING(surveyID)
+JOIN rawExp using(exp_id)
+JOIN chipRun using(chip_id, exp_id)
+JOIN camRun using(cam_id, chip_id)
+JOIN camProcessedExp using(cam_id)
+JOIN fakeRun using(cam_id)
+JOIN warpRun using(fake_id)