import time
import threading
import sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy.engine.base import Engine
engine = create_engine(
"mysql+pymysql://root:123@127.0.0.1:3306/test?charset=utf8",
max_overflow=2, # 超过连接池大小外最多创建的连接,既是5+2,注意与DButils的区别
pool_size=5, # 连接池大小
# pool_timeout=30, # 池中没有线程最多等待的时间,否则报错,一般不设置
)
conn = engine.raw_connection() # 在连接池中获取连接
cursor = conn.cursor() # 连接数据库
cursor.execute( # 执行语句
"select * from t1"
)
result = cursor.fetchall() # 获得结果
cursor.close() # 关闭数据库
conn.close() # 关闭连接池的连接
多线程,测试连接池
engine = create_engine(
"mysql+pymysql://root:123@127.0.0.1:3306/t1?charset=utf8",
max_overflow=0, # 超过连接池大小外最多创建的连接
pool_size=5, # 连接池大小
# pool_timeout=30, # 池中没有线程最多等待的时间,否则报错
)
def task(arg):
conn = engine.raw_connection()
cursor = conn.cursor()
cursor.execute(
#"select * from t1"
"select sleep(2)"
) # 休息两秒用来做测试
result = cursor.fetchall()
cursor.close()
conn.close()
for i in range(20):
t = threading.Thread(target=task, args=(i,))
t.start() # 每次会打印出5次结果,因为线程池中最大的是5