from sqlalchemy import create_engine, text
from sqlalchemy.orm import sessionmaker, relationship
engine = create_engine(
f"mysql+pymysql://root:root@localhost:3306/wbrj_accset",
max_overflow=0, # 超过连接池大小外最多创建的连接
pool_size=5, # 连接池大小
pool_timeout=30, # 池中没有线程最多等待的时间,否则报错
pool_recycle=-1 # 多久之后对线程池中的线程进行一次连接的回收(重置)
)
conn = engine.connect()
conn.execute(text("insert into databasesource(user_name) values(222)"))
conn.execute(text("insert into databasesource(user_name) values(:user_name)"), [{"user_name": 1}, {"user_name": 2}])
conn.commit()
engine = create_engine(
f"mysql+pymysql://root:root@localhost:3306/wbrj_accset",
max_overflow=0, # 超过连接池大小外最多创建的连接
pool_size=5, # 连接池大小
pool_timeout=30, # 池中没有线程最多等待的时间,否则报错
pool_recycle=-1 # 多久之后对线程池中的线程进行一次连接的回收(重置)
)
conn = engine.connect()
dd = conn.execute(text("select * from databasesource"))
# conn.execute(text("insert into databasesource(user_name) values(222)"))
# conn.execute(text("insert into databasesource(user_name) values(:user_name)"), [{"user_name": 1}, {"user_name": 2}])
conn.commit()
print(dd.fetchall())
print("打印")