Changeset 35016 for branches/eam_branches/ipp-20121219/ippToPsps/jython/dvo.py

Timestamp:

Jan 22, 2013, 9:43:22 AM (13 years ago)

Author:

eugene

Message:

add dvopsps-based method to ingest detections; do not use foreign key constraint if using dvopsps

File:

• branches/eam_branches/ipp-20121219/ippToPsps/jython/dvo.py (modified) (1 diff)

branches/eam_branches/ipp-20121219/ippToPsps/jython/dvo.py

@@ -562 +562 @@
       return tableName
 
+
+    '''
+    ingest skyregion into MySQL database using the native DVO program dvopsps
+    Populates dvoDetections and dvoDone with FITS tables from DVO for the defined sky area, this
+    includes purging detections outside sky area
+    '''
+    def nativeIngestDetections(self, raCenter, decCenter, boxSize):
+
+        # self.scratchDb.resetAllDvoTables()
+
+        # make sure we have an up-to-date Images table
+        self.loadImages()
+
+        # XXX blow away existing dvoDetection table?
+
+        # dvopsps -D catdir CATDIR -region .... -dbhost xx -dbname xx -dbuser xx -dbpass xx
+        halfSize = boxSize / 2.0
+        # -region raCenter-halfSize raCenter+halfSize decCenter-halfSize decCenter+halfSize
+
+        # TODO path to DVO prog hardcoded temporarily
+        cmd = "dvopsps detections"
+        cmd += " -dbhost " + self.scratchDb.dbHost
+        cmd += " -dbname " + self.scratchDb.dbName
+        cmd += " -dbuser " + self.scratchDb.dbUser
+        cmd += " -dbpass " + self.scratchDb.dbPass
+        cmd += " -D CATDIR " + self.config.dvoLocation
+        cmd += " -region "
+        cmd += " " + str(raCenter-halfSize)
+        cmd += " " + str(raCenter+halfSize)
+        cmd += " " + str(decCenter-halfSize)
+        cmd += " " + str(decCenter+halfSize)
+
+        self.logger.infoPair("Running dvopsps", cmd)
+        p = Popen(cmd, shell=True, stdout=PIPE)
+        p.wait()
+
+
+        # update lists after attempted sync
+        # self.printSummary()
+
+        return True