views:

14

answers:

0

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