Changeset 32457 for trunk/ippToPsps

Timestamp:

Sep 29, 2011, 3:18:01 PM (15 years ago)

Author:

rhenders

Message:

added a method to lock a table and a method to unlock all tables

File:

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

trunk/ippToPsps/jython/mysql.py

@@ -47 +47 @@
         self.everythingOK = True
 
-
     '''
     Disconnect from database
@@ -61 +60 @@
         self.logger.debug("MySql destructor")
         self.disconnect()
+    
+    '''
+    Locks a table. This is wait if the locks is already held by another session
+    '''
+    def lockTable(self, table):
+        self.execute("LOCK TABLES " + table + " WRITE")
+
+    '''
+    Unlocks all tables locked by this session.
+    '''
+    def unlockTables(self):
+        self.execute("UNLOCK TABLES")
 
     '''