Login

lock tables decorator

Author:
seandong
Posted:
September 4, 2008
Language:
Python
Version:
1.0
Tags:
mysql lock tables
Score:
5 (after 5 ratings)

sometimes,you need to lock one or more table to ensure the integrity of data.may be it's help to you.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
def require_lock(*tables):
    def _lock(func):
        def _do_lock(*args,**kws):
            #lock tables
            cursor = connection.cursor()
            cursor.execute("LOCK TABLES %s WRITE" %' '.join(tables))
            try:
                result = func(*args,**kws)
            except Exception,e:
                raise Exception(e)
            else:
                return result
            finally:
                #unlock tables
                cursor.execute("UNLOCK TABLES")
                if cursor:cursor.close()

        return _do_lock
    return _lock

'''
    example:

    @require_lock(table_A,table_B)
    fuc(args):
        pass
'''

More like this

Comments

svetlyak (on September 4, 2008):
<p>I think, that it would be better and shoter, to use try…finally block, like that:</p> <pre> try: return func(*args,**kws) finally: #unlock tables cursor.execute("UNLOCK TABLES") cursor.close() </pre>

#

Please login first before commenting.