Changeset 35056 for branches/eam_branches/ipp-20121219/ippToPsps/jython/dvoobjects.py

Timestamp:

Jan 25, 2013, 4:48:08 PM (13 years ago)

Author:

eugene

Message:

add native dvo ingest option for objects

File:

• branches/eam_branches/ipp-20121219/ippToPsps/jython/dvoobjects.py (modified) (2 diffs)

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

@@ -8 +8 @@
 import logging
 import glob
+from subprocess import call, PIPE, Popen
 
 from dvo import Dvo
@@ -47 +48 @@
 
 
+    '''
+    ingest object data 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 nativeIngestRegion(self, region):
+
+        # drop cpt/cps/object table?
+        # create detections table?
+
+        # TODO path to DVO prog hardcoded temporarily
+        cmd = "dvopsps objects"
+        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 += " -cpt " + region
+
+        self.logger.infoPair("Running dvopsps", cmd)
+        p = Popen(cmd, shell=True, stdout=PIPE)
+        p.wait()
+
+        # update lists after attempted sync
+        # self.printSummary()
+
+        return True