Changeset 38981 for trunk/ippToPsps/jython/batch.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/batch.py (modified) (1 diff)

trunk/ippToPsps/jython/batch.py

@@ -446 +446 @@
         self.logger.warn("alterPspsTables not implemented")
 
+
+    '''
+    Imports IPP tables from FITS file
+
+    Accepts a regular expression filter so not all tables need to be imported
+    '''
+    def importIppTablesOhana(self):
+        
+        self.logger.infoPair("Importing IPP tables", "using fits_to_mysql")
+
+        ## use stilts to get a list of the tables from the header
+        try:
+            tables = stilts.treads(self.fits.getPath())
+        except:
+            self.logger.errorPair("STILTS could not import from", self.fits.getPath())
+            return False
+
+        loadFITStoMYSQL(self.fits.getPath(), "none")
+
+        ## may need to do this with direct sql:
+        # table = stilts.tpipe(table, cmd='addcol table_index $0')
+
+        self.tablesLoaded = []
+
+        count = 0
+        for table in tables:
+
+            # example of listing all columns in a table:
+            ## print "-----table: " + table.name
+            ## columns = table.columns()
+            ## for column in columns:
+            ##     print column
+            ## 
+            ## print "-----"
+
+            self.logger.debugPair("Read IPP table", table.name)
+
+            self.tablesLoaded.append(table.name)
+            count ++
+
+        self.logger.infoPair("Done. Imported", "%d tables" % count)
+        self.indexIppTables()
+
+        return True
+
     '''
     Imports IPP tables from FITS file