Changeset 37156 for branches/eam_branches/ipp-20140717/ippToPsps/jython/mysql.py

Timestamp:

Jul 31, 2014, 10:59:37 AM (12 years ago)

Author:

eugene

Message:

adding stack mags to dvopsps detection output; adding option to reset the dvoDetections table; adding makeEquals to sqlUtilities; intelligently(?) select photcode ranges for dvopsps; massive re-work of stackbatch.py

File:

• branches/eam_branches/ipp-20140717/ippToPsps/jython/mysql.py (modified) (3 diffs)

branches/eam_branches/ipp-20140717/ippToPsps/jython/mysql.py

@@ -83 +83 @@
     '''
     def lockTable(self, table):
+        print "Locking table: " + table
         self.execute("LOCK TABLES " + table + " WRITE")
 
@@ -89 +90 @@
     '''
     def unlockTables(self):
+        print "Unlocking tables"
         self.execute("UNLOCK TABLES")
 
@@ -280 +282 @@
         except: pass
             #self.logger.warn("Index already in place on '" + column + "' for table '" + table + "'")
+
+    def addPrimaryKeyWithIgnore(self, table, column)
+        # note that in mysql versions later than 5.1, this fails
+        # unless the following is called first: 
+        # "set session old_alter_table=1"
+
+        # follow the command with 
+        # "set session old_alter_table=0"
+
+        # OF COURSE, this fails for mysql version <= 5.1...
+        if self.scratchDb.version > 5.1:
+            self.scratchDb.execute("set session old_alter_table=1")
+
+        # I should probably do this before the whole table is built, right?
+        sql = "ALTER IGNORE TABLE " + table + " ADD PRIMARY KEY (" + column + ")"
+        self.scratchDb.execute(sql)
+        
+        if self.scratchDb.version > 5.1:
+            self.scratchDb.execute("set session old_alter_table=0")
 
     '''