On Feb 17, 2014, at 7:31 PM, Michael Bayer <[email protected]> wrote:
>
> O
> from sqlalchemy import event, create_engine
>
> eng = create_engine("postgresql+psycopg2://scott:tiger@localhost/test",
> echo=True)
>
> @event.listens_for(eng, "first_connect", insert=True)
> @event.listens_for(eng, "connect", insert=True)
> def setup_autocommit(dbapi_conn, rec):
> dbapi_conn.autocommit = True
>
> conn = eng.connect()
> print conn.execute("select 1").fetchall()
oh and also if you are on 0.8 (not 0.7), you can just send AUTOCOMMIT to
create_engine:
eng = create_engine("postgresql+psycopg2://scott:tiger@localhost/test",
echo=True,
isolation_level='AUTOCOMMIT'
)
much easier
signature.asc
Description: Message signed with OpenPGP using GPGMail
