Changeset 33746

Timestamp:

Apr 10, 2012, 1:38:39 PM (14 years ago)

Author:

rhenders

Message:

added unique key on Object table to protect against duplicates from DVO

File:

• trunk/ippToPsps/jython/objectbatch.py (modified) (2 diffs)

trunk/ippToPsps/jython/objectbatch.py

@@ -78 +78 @@
     def alterPspsTables(self):
 
-        self.logger.debug("Altering PSPS tables")
+        self.scratchDb.makeColumnUnique("Object", "objID")
+
         return True
 
@@ -157 +158 @@
 
         self.logger.infoPair("Inserting objects from", "cpt")
-        sql = "INSERT INTO Object (\
+        sql = "INSERT IGNORE INTO Object (\
                objID \
                ,ippObjID \