Changeset 38108

Timestamp:

Apr 10, 2015, 4:05:42 PM (11 years ago)

Author:

watersc1

Message:

Tool changes for remote diffssrc/remotetool.c

Location:

tags/ipp-pv3-20140717/ippTools/share

Files:

• Makefile.am (modified) (2 diffs, 1 prop)
• remotetool_definebyquery_diff.sql (modified) (1 diff, 1 prop)

tags/ipp-pv3-20140717/ippTools/share/Makefile.am

@@ -485 +485 @@
         releasetool_definerelstack_with_skycal.sql \
         releasetool_listrelstack.sql \
+        releasetool_setrelstackcalibratedfromskycal.sql \
         releasetool_summary.sql \
         releasetool_definerelgroup_select_lap.sql \
@@ -509 +510 @@
         remotetool_definebyquery_stack.sql \
         remotetool_definebyquery_staticsky.sql \
+        remotetool_definebyquery_diff.sql \
         remotetool_dropcomponent.sql \
         remotetool_listcomponent.sql \

tags/ipp-pv3-20140717/ippTools/share/remotetool_definebyquery_diff.sql

@@ +1 @@
+SELECT stage_id FROM
+
+( SELECT diff_id AS stage_id
+    FROM diffRun
+WHERE
+diffRun.state = 'new'
+-- where hook %s
+GROUP BY diff_id
+) AS W
+
+LEFT JOIN
+
+(SELECT remote_id,remoteRun.stage,remoteRun.label,remoteComponent.stage_id,remoteRun.state
+   FROM remoteRun
+   JOIN remoteComponent USING(remote_id)
+WHERE
+remoteRun.stage = 'staticsky' AND remoteComponent.state != 'retry'
+-- where hook %s
+) AS R
+USING(stage_id)
+WHERE R.remote_id IS NULL