Changeset 33181

Timestamp:

Jan 31, 2012, 9:51:10 AM (14 years ago)

Author:

rhenders

Message:

added method to OPTIMIZE a table; added method to get Db friendly table name

File:

• trunk/ippToPsps/jython/mysql.py (modified) (1 diff)

trunk/ippToPsps/jython/mysql.py

@@ -106 +106 @@
         sql = "UPDATE " + table + " SET " + column + " = " + value
         self.execute(sql)
+
+    '''
+    OPTIMIZEs a table
+    '''
+    def optimizeTable(self, table):
+
+        sql = "OPTIMIZE TABLE " + table
+        try: self.execute(sql)
+        except: return
+
+    '''
+    Creates a MySQL-friendly table name from the provided string
+    '''
+    def getDbFriendlyTableName(self, origName):
+
+        name = origName
+        name = name.replace('.', '_')
+        name = name.replace('/', '_')
+
+        return name
 
     '''