Changeset 35016 for branches/eam_branches/ipp-20121219/ippToPsps/jython/scratchdb.py

Timestamp:

Jan 22, 2013, 9:43:22 AM (13 years ago)

Author:

eugene

Message:

add dvopsps-based method to ingest detections; do not use foreign key constraint if using dvopsps

File:

• branches/eam_branches/ipp-20121219/ippToPsps/jython/scratchdb.py (modified) (1 diff)

branches/eam_branches/ipp-20121219/ippToPsps/jython/scratchdb.py

@@ -485 +485 @@
        self.createIndex(self.dvoDetectionTable, "fileID")
 
-       # now add a delete cascading foreign key constraint on fileID
-       sql = "ALTER TABLE dvoDetectionFull \
+       # XXX : this should be based on choice of useStilts (which is set in dvo.py and must be moved)
+       if (False):
+           # now add a delete cascading foreign key constraint on fileID
+           sql = "ALTER TABLE dvoDetectionFull \
               ADD CONSTRAINT fk_fileID \
               FOREIGN KEY (fileID) \
               REFERENCES dvoDone(id) \
               ON DELETE CASCADE"
-       try: self.execute(sql)
-       except: 
-           self.logger.errorPair("Unable to create foreign key on", self.dvoDoneTable)
-           return False
+           try: self.execute(sql)
+           except: 
+               self.logger.errorPair("Unable to create foreign key on", self.dvoDoneTable)
+               return False
 
        return True