Index: /trunk/ippToPsps/jython/mysql.py
===================================================================
--- /trunk/ippToPsps/jython/mysql.py	(revision 33356)
+++ /trunk/ippToPsps/jython/mysql.py	(revision 33357)
@@ -21,5 +21,5 @@
 
     '''
-    def __init__(self, logger, config, dbType):
+    def __init__(self, logger, config, dbType, dbName=None):
 
         # set up logging
@@ -29,5 +29,6 @@
 
         # open config and grab database parameters
-        self.dbName = config.getDbName(dbType)
+        if not dbName: self.dbName = config.getDbName(dbType)
+        else: self.dbName = dbName
         self.dbHost = config.getDbHost(dbType)
         self.dbUser = config.getDbUser(dbType)
@@ -42,8 +43,10 @@
         except:
             self.logger.error("Unable to connect to " + self.url)
-            self.everythingOK = False
+            self.everythingOK = False # TODO need this?
+            self.connected = False
             return
 
         self.everythingOK = True
+        self.connected = True
 
     '''
@@ -52,4 +55,5 @@
     def disconnect(self):
         self.con.close()
+        self.connected = False
 
     '''
@@ -85,4 +89,23 @@
         sql = "KILL %d" % connectionID
         self.execute(sql)
+
+    '''
+    Checks whether there are any other connections to this database
+    '''
+    def anyOtherConnections(self):
+
+        sql = "SELECT COUNT(*) \
+               FROM INFORMATION_SCHEMA.PROCESSLIST \
+               WHERE DB='" + self.dbName + "'"
+        try:
+            rs = self.executeQuery(sql)
+            rs.first()
+            if rs.getInt(1) > 1: return True
+            else: return False
+        except:
+            self.logger.errorPair("Could not check for connection", sql)
+            pass
+
+        return True
 
     '''
