python连接池框架_python3.0 django mysql连接池说明

使用python的django框架连接数据库，操作数据库代码：

import logging

from django.db import connection

LOG = logging.getLogger("boss")

def dictfetchall(cursor):

"Return all rows from a cursor as a dict"

desc = cursor.description

if desc == None:

return []

columns = [col[0] for col in desc]

# for row in cursor.fetchall():

# rows.append(row)

return [

dict(zip(columns, row))

for row in cursor.fetchall()

]

def dictfetone(cursor):

desc = cursor.description

if desc == None:

return None

columns = [col[0] for col in desc]

row = cursor.fetchone()

if row == None:

return None

return dict(zip(columns,row))

def fetchall(sql,params=[]):

cursor =connection.cursor()

cursor.execute(sql,params)

ret = dictfetchall(cursor)

return ret

def fetchone(sql,params=[]):

cursor =connection.cursor()

cursor.execute(sql,params)

ret = dictfetone(cursor)

cursor.close()

return ret

def executeDb(sql,params=[]):

cursor =connection.cursor()

ret = cursor.execute(sql,params)

cursor.close()

return ret在代码中看到 cursor执行完之后，执行close。想到diango的mysql连接是不是没有做连接池？带着这个疑问上网查看，发现果然有这方面的文档。后来看官网时发现：

django最新版本已经包含了连接池，通过修改配置控制，官方文档：https://docs.djangoproject.com/en/1.9/ref/databases/

证明最好还是看官方文档。