Changeset 38090 for trunk/ippToPsps/jython/gpc1db.py

Timestamp:

Apr 6, 2015, 4:38:40 PM (11 years ago)

Author:

heather

Message:

shcema20 first

File:

• trunk/ippToPsps/jython/gpc1db.py (modified) (3 diffs)

trunk/ippToPsps/jython/gpc1db.py

@@ -113 +113 @@
 
             stage = "diff"
-            sql = "SELECT DISTINCT stage_extra1, radeg,decdeg \
+            sql = "SELECT stage_id, avg(radeg),avg(decdeg) \
                    FROM addRun \
                    JOIN addProcessedExp using (add_id) \
@@ -140 +140 @@
                    AND radeg BETWEEN " + str(minRA) + " AND " + str(maxRA) + " \
                    AND dateobs >= '" + tstart + "'\
-                   AND dateobs <= '" + tend  + "'"
-
+                   AND dateobs <= '" + tend  + "'\
+                   GROUP BY stage_id"                   
 
         elif batchType == "FW":
             
             stage = "fullforce"
-            sql = "SELECT DISTINCT add_id, radeg, decdeg FROM fullForceInput \
+            sql = "SELECT stage_id, avg(radeg), avg(decdeg) FROM fullForceInput \
                    JOIN addRun ON(fullForceInput.ff_id = addRun.stage_id AND fullForceInput.warp_id = addRun.stage_extra1) \
                    JOIN minidvodbRun USING(minidvodb_name) \
@@ -167 +167 @@
                    AND radeg BETWEEN " + str(minRA) + " AND " + str(maxRA) + " \
                    AND mjd_obs >= (to_days('" + tstart + "')-678941) \
-                   AND mjd_obs <= (to_days('" + tend + "') - 678941) "
+                   AND mjd_obs <= (to_days('" + tend + "') - 678941) \
+                   GROUP BY stage_id"
 
         try: