Dear All,
After I read SQLAlchemy's FAQ I think below code may works,
import sqlalchemy.pool as pool
import sqlite3 as sqlite3
conn_proxy = pool.manage(sqlite3)
# then connect normally
connection = conn_proxy.connect(...)
however I also get below snippets:
engine = create_engine(...)
conn = engine.connect()
conn.connection.<do DBAPI things>
cursor = conn.connection.cursor(<DBAPI specific arguments..>)
then my question is how to get pool from engine? I means can I do something like this?
conn_proxy = engine.pool.manage(sqlite3)
or
conn_pool = engine.pool
and is there a way can commit every connection in a connection pool?
Thanks!
Rgs,
KC