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

Timestamp:

Mar 13, 2012, 10:04:47 AM (14 years ago)

Author:

rhenders

Message:

method to change database engine for a particular table

File:

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

trunk/ippToPsps/jython/mysql.py

@@ -19 +19 @@
     '''
     Constructor
-
     '''
     def __init__(self, logger, config, dbType, dbName=None):
@@ -184 +183 @@
         except: pass
             #self.logger.warn("Index already in place on '" + column + "' for table '" + table + "'")
+    '''
+    Changes the database engine for this table to InnoDb
+    '''
+    def changeEngineToInnoDB(self, table):
+        self.changeEngine(table, "InnoDB")
+
+    '''
+    Changes the database engine for this table
+    '''
+    def changeEngine(self, table, engine):
+
+        sql = "ALTER TABLE " + table + " ENGINE=" + engine
+        try: 
+            self.execute(sql)
+        except: 
+            self.logger.errorPair("Could not change table engine", sql)
+            return False
+
+        return True
+
     '''
     Adds an index to the supplied table and column