Login

lock tables decorator

Author:
seandong
Posted:
September 4, 2008
Language:
Python
Version:
1.0
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

  1. New Snippet! by Antoliny0919 4 days, 18 hours ago
  2. Add Toggle Switch Widget to Django Forms by OgliariNatan 2 months, 3 weeks ago
  3. get_object_or_none by azwdevops 6 months, 2 weeks ago
  4. Mask sensitive data from logger by agusmakmun 8 months, 1 week ago
  5. Template tag - list punctuation for a list of items by shapiromatron 1 year, 10 months ago

Comments

svetlyak (on September 4, 2008):

I think, that it would be better and shoter, to use try…finally block, like that:

        try:
            return func(*args,**kws)
        finally:
            #unlock tables
            cursor.execute("UNLOCK TABLES")
            cursor.close()

#

Please login first before commenting.