Changeset 38999 for trunk/ippToPsps/jython/stackbatch.py

Timestamp:

Oct 29, 2015, 10:50:19 AM (11 years ago)

Author:

eugene

Message:

generate the table_index columns; update diff and forcedwarp to use fits_to_mysql

File:

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

trunk/ippToPsps/jython/stackbatch.py

@@ -1423 +1423 @@
             
             ## output table names need to have "filter" prepended.  
-            ## add this as an option
-            self.scratchDb.loadFITStoMYSQL(fileName, "-tableprefix " + filter)
-            ## XXX table = stilts.tpipe(table, cmd='addcol table_index $0')
+            fitsOptions  = "-tableprefix " + filter
+
+            # this pair of options is equivalent to the stilts "addcol table_index $0" call
+            fitsOptions += " -sequence-column table_index"
+            fitsOptions += " -sequence-column-start 1"
+
+            ## *** actually write the FITS data to mysql
+            self.scratchDb.loadFITStoMYSQL(fileName, fitsOptions)
 
             # get the list of tables in this file: