sqlite数据库代码封装

from flask import g

db_url=r'E:\db'


#将tuple按照数据库中字段转换为字典表
def make_dicts(cursor,row):
    return dict((cursor.descrition[i][0],value) for i,value in enumerate(row))


#建立连接
def create_db():
    db=getattr(g,'_database',None)
    if db is None:
        db=g._database=sqlite3.connect(db_url)
        db.row_factory=make_dicts
        return db

#执行不返回结果的sql
def execute_sql(sql,params=()):
    c=create_db().cursor()
    c.execute(sql,(params))
    c.connection.commit()

#执行返回结果的sql
def query_sql(sql,params=(),one=False):
    c=create_db().cursor()
    result=c.execute(sql,params)
    c.close()
    if one:
        return result[0]
    else:
        return result


#关闭数据库
@app.teardown_appcontext
def close_db(exception):
    db=getattr(g,'_database',None)
    if db is not None:
        db.close()