Changeset 37917 for trunk/ippToPsps/jython/mysql.py

Timestamp:

Feb 20, 2015, 1:19:35 PM (11 years ago)

Author:

heather

Message:

current state of ipptopsps / sas37 - ob/p2/st/df work

File:

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

trunk/ippToPsps/jython/mysql.py

@@ -258 +258 @@
             self.execute(sql)
         except: pass
-            #self.logger.warn("Index already in place on '" + column + "' for table '" + table + "'")
+            
+           # self.logger.warn("Index already in place on '" + column + "' for table '" + table + "'")
     '''
     Changes the database engine for this table to InnoDb
@@ -477 +478 @@
         self.execute("SET @i = 0")
         self.execute("UPDATE " + table + " SET " + colName + "=(@i:=@i+1)")
-        self.execute("ALTER TABLE " + table + " ADD PRIMARY KEY (" + colName + ")")
-
+        self.execute("ALTER IGNORE TABLE " + table + " ADD PRIMARY KEY (" + colName + ")")
+
+    '''                                                                                                                                             
+    Adds a column to this table which contains a row count                                                                                          
+    '''
+    def addRowCountColumnNoKey(self, table, colName):
+
+        self.execute("ALTER TABLE " + table + " ADD COLUMN " + colName + " INTEGER FIRST")
+        self.execute("SET @i = 0")
+        self.execute("UPDATE " + table + " SET " + colName + "=(@i:=@i+1)")
+