Changeset 33780

Timestamp:

Apr 13, 2012, 2:10:56 PM (14 years ago)

Author:

rhenders

Message:

new method to check if a table exists; new method to drop a list of tables

File:

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

trunk/ippToPsps/jython/mysql.py

@@ -90 +90 @@
 
     '''
+    Checks whether this table exists
+    '''
+    def tableExists(self, tableName):
+
+        sql = "SELECT COUNT(*) \
+               FROM information_schema.tables \
+               WHERE table_schema = '" + self.dbName + "' \
+               AND table_name = '" + tableName + "'"
+
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            if rs.getInt(1) > 0: return True
+            else: return False
+        except:
+            self.logger.errorPair("Could not check if table exists", sql)
+            pass
+
+        return False
+
+    '''
     Checks whether there are any other connections to this database
     '''
@@ -157 +178 @@
         try: self.execute(sql)
         except: return
+
+    '''
+    Drops a list of tables
+    '''
+    def dropTables(self, tables):
+        for table in tables: self.dropTable(table)
 
     '''