Changeset 38981 for trunk/ippToPsps/jython/scratchdb.py

Timestamp:

Oct 27, 2015, 4:00:17 PM (11 years ago)

Author:

eugene

Message:

add options to import FITS tables using Ohana fits_to_mysql

File:

• trunk/ippToPsps/jython/scratchdb.py (modified) (1 diff)

trunk/ippToPsps/jython/scratchdb.py

@@ -803 +803 @@
 
         return res
+
+    '''
+    Use Ohana fits_to_mysql to load FITS tables into scratch db
+    '''
+    def loadFITStoMYSQL(self, filename, tablename):
+
+        # TODO path to DVO prog hardcoded temporarily
+        cmd = "fits_to_mysql"
+        cmd += " -dbhost " + self.scratchDb.dbHost
+        cmd += " -dbname " + self.scratchDb.dbName
+        cmd += " -dbuser " + self.scratchDb.dbUser
+        cmd += " -dbpass " + self.scratchDb.dbPass
+        cmd += filename
+
+        if tablename != "none":
+            cmd += " -tablename " + tablename
+
+        (stdoutFile, stdoutName) = tempfile.mkstemp(prefix="fits_to_mysql.stdout.", dir="/tmp")
+        (stderrFile, stderrName) = tempfile.mkstemp(prefix="fits_to_mysql.stderr.", dir="/tmp")
+
+        self.logger.infoPair("Running fits_to_mysql", cmd)
+        self.logger.infoPair("Stdout to ", stdoutName)
+        self.logger.infoPair("Stderr to ", stderrName)
+        p = Popen(cmd, shell=True, stdout=stdoutFile, stderr=stderrFile)
+
+        p.wait()
+
+        if p.returncode < 0:
+            self.logger.errorPair("fits_to_mysql terminated on signal for: ", cmd)
+            os._exit(1)
+
+        if p.returncode > 0:
+            self.logger.errorPair("fits_to_mysql failed for: ", cmd)
+            os._exit(1)
+
+        os.close(loadFITStoMYSQL)
+        os.close(loadFITStoMYSQL)