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

Timestamp:

Apr 12, 2012, 8:13:14 AM (14 years ago)

Author:

rhenders

Message:

usng Bill's new skycell table within gpc1

File:

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

trunk/ippToPsps/jython/gpc1db.py

@@ -73 +73 @@
 
             stage = "staticsky"
-            sql = "SELECT DISTINCT stack_id, ra, decl FROM staticskyInput \
+            sql = "SELECT DISTINCT stack_id, radeg, decdeg FROM staticskyInput \
                    JOIN addRun ON(staticskyInput.sky_id = addRun.stage_id) \
                    JOIN minidvodbRun USING(minidvodb_name) \
                    JOIN minidvodbProcessed USING(minidvodb_id) \
-                   JOIN  stackRun USING(stack_id) JOIN skycells.skycell USING(skycell_id) \
+                   JOIN  stackRun USING(stack_id) JOIN skycell USING(skycell_id) \
                    WHERE minidvodbRun.minidvodb_group = '" + dvoDb + "' \
                    AND minidvodbRun.state = 'merged' \
@@ -83 +83 @@
                    AND addRun.stage = '" + stage + "' \
                    AND addRun.state = 'full' \
-                   AND decl BETWEEN " + str(minDec) + " AND " + str(maxDec) + " \
-                   AND ra BETWEEN " + str(minRA) + " AND " + str(maxRA) 
+                   AND decdeg BETWEEN " + str(minDec) + " AND " + str(maxDec) + " \
+                   AND radeg BETWEEN " + str(minRA) + " AND " + str(maxRA) 
 
         try: