Changeset 33272 for trunk/ippToPsps

Timestamp:

Feb 15, 2012, 1:05:44 PM (14 years ago)

Author:

rhenders

Message:

when attempting to add PSPS_OBJ_ID column, catch exception and continue as we may have aborted after this step on a previous ingest attempt

File:

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

trunk/ippToPsps/jython/dvo.py

@@ -403 +403 @@
            self.scratchDb.createIndex(cptTableName, "OBJ_ID")
 
+           self.logger.infoPair("Adding","PSPS objIDs")
+           # first try to add a column for PSPS_OBJ_ID. catch failure and continue
+           try:
+               sql = "ALTER TABLE " + cpmTableName + " ADD COLUMN (PSPS_OBJ_ID BIGINT)"
+               self.scratchDb.execute(sql)
+           except:
+               self.logger.infoPair("Already added PSPS_OBJ_ID column to", cpmTableName)
+               
            # shove PSPS objIDs from cpt table into measurement table
-           self.logger.infoPair("Adding","PSPS objIDs")
-           sql = "ALTER TABLE "+cpmTableName+" ADD COLUMN (PSPS_OBJ_ID BIGINT)"
-           self.scratchDb.execute(sql)
            sql = "UPDATE " + cpmTableName + " AS a, " + cptTableName + " AS b \
                   SET a.PSPS_OBJ_ID = b.EXT_ID \