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

trunk/ippToPsps/jython/dvo.py

@@ -581 +581 @@
 
           count = count + 1
+
+      self.logger.debugPair("Finished importing", tableName)
+
+      return tableName
+
+    '''
+    Imports the Photcode file
+    '''
+    def importPhotcodesOhana(self, path, tableName):
+
+      self.logger.infoPair("Importing file", "%s (%s)" % (path, self.getFileSizeStr(self.getDiskSize(path))))
+      self.logger.debugPair("Writing to database table", tableName)
+
+      ## XXX may need to do this in mysql after table is read
+      # convert the 1-char field TYPE to an int for querying ease (probably more sophisticated ways to do this...)
+      # table = stilts.tpipe(table, cmd='addcol -after TYPE TYPE_AS_INT "TYPE + 0"')
+
+      loadFITStoMYSQL (path, tableName)
 
       self.logger.debugPair("Finished importing", tableName)