a python dbhook

a python dbhook

def dbhook():
    '''数据库的hook'''
    def _(func):
        '''_'''
        def wrapper(*a, **kw):
            '''wrapper'''
            _handler = a[0]
            db = "DB/ershou.db"
            _handler.conn = sqlite3.connect(db,check_same_thread = False)
            _handler.conn.execute('pragma foreign_keys = on')
            _handler.conn.commit()
            _handler.cur = _handler.conn.cursor()
            try:
                result = func(*a, **kw)
            finally:
                _handler.conn.close()
            return result
        return wrapper 
    return _

#调用

@dbhook()
def GET(self):
    DBshuC = self.cur.execute("SELECT post,link,name,date from caiji")
    self.conn.commit()