Changeset 42197 for branches/eam_branches/ipp-20220316/ippTools/share

Timestamp:

May 10, 2022, 5:16:45 PM (4 years ago)

Author:

eugene

Message:

first cut at fpcamtool code (it builds at least)

Location:

branches/eam_branches/ipp-20220316/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• fpcamtool_find_cam_and_chip_id.sql (modified) (3 diffs)
• fpcamtool_find_cam_id.sql (added)
• fpcamtool_find_processedexp.sql (added)
• fpcamtool_pendingexp.sql (added)
• fpcamtool_queue_cam_id.sql (added)
• fpcamtool_revertprocessedexp.sql (added)
• fpcamtool_revertupdatedexp.sql (added)

branches/eam_branches/ipp-20220316/ippTools/share/Makefile.am

@@ -543 +543 @@
         remotetool_listcomponent.sql \
         remotetool_doneprep.sql \
-        remotetool_updatepoll.sql
+        remotetool_updatepoll.sql \
+        fpcamtool_addprocessedexp.sql \
+        fpcamtool_find_cam_and_chip_id.sql \
+        fpcamtool_find_cam_id.sql \
+        fpcamtool_find_processedexp.sql \
+        fpcamtool_pendingexp.sql \
+        fpcamtool_queue_cam_id.sql \
+        fpcamtool_revertprocessedexp.sql \
+        fpcamtool_revertupdatedexp.sql
+

branches/eam_branches/ipp-20220316/ippTools/share/fpcamtool_find_cam_and_chip_id.sql

@@ -4 +4 @@
 (
  SELECT
-     chipRun.chip_id,
-     rawExp.ra,
-     rawExp.decl
+     exp_id,
+     chip_id,
  FROM chipRun
  JOIN rawExp
@@ -12 +11 @@
  WHERE
       chipRun.state = 'full'
- -- AND exp_id = 162
- -- AND chip_id = 140
+ -- WHERE HOOK for chip:
+  AND %s
 ) AS myChip
 JOIN
 (
 SELECT
+    exp_id,
+    camRun.chip_id as cam_chip_id,
     camRun.cam_id,
-    rawExp.ra,
-    rawExp.decl
+    camRun.state,
+    camRun.workdir,
+    camRun.workdir_state,
+    camRun.label,
+    camRun.data_group,
+    camRun.dist_group,
+    camRun.reduction,
+    camRun.dvodb,
+    camRun.software_ver,
+    camRun.note
 FROM camRun
 JOIN chipRun
@@ -28 +37 @@
 WHERE
      camRun.state = 'full'
--- AND exp_id = 162
--- AND cam_id = 234
+-- WHERE HOOK for cam:
+  AND %s
 ) AS myCam
 USING(exp_id)
-
-