Thanks Michael.
This is like trudging through knee high mud to find a needle.
oh boy. On I go.
Thanks,
Garyc
--- On Tue, 4/27/10, Michael Bayer <mike...@zzzcomputing.com> wrote:
> From: Michael Bayer <mike...@zzzcomputing.com>
> Subject: Re: [sqlalchemy] setting the transaction isolation_level?
> To: sqlalchemy@googlegroups.com
> Date: Tuesday, April 27, 2010, 3:30 PM
> gary clark wrote:
> > Hello,
> >
> > I'm using SQLAlchemy with sqlite 3.6.23. I would like
> to know how you set
> > the transaction isolation_level=immediate.
> >
> > I think this will help with the deadlocks I was
> having. Just dont know how
> > to implement this.
>
> I've added ticket 1784 to document this.
>
> We support directly "PRAGMA read_uncommitted=%d", via the
> possible values
> "READ UNCOMMITTED" or "SERIALIZABLE":
>
> create_engine('sqlite://', isolation_level='READ
> UNCOMMITTED')
>
> I don't understand what the Pysqlite docs are referring to
> when they come
> up with three values, “DEFERRED”, “IMMEDIATE” or
> “EXCLUSIVE” - SQLite's
> official documentation only describes two values for
> "PRAGMA
> read_uncommitted". However to set pysqlite
> specific values, use a
> PoolListener.
>
> http://www.sqlalchemy.org/docs/reference/sqlalchemy/interfaces.html?highlight=poollistener#sqlalchemy.interfaces.PoolListener
>
>
>
>
>
>
> >
> > Thanks,
> > Garyc
> >
> >
> > --
> > You received this message because you are subscribed
> to the Google Groups
> > "sqlalchemy" group.
> > To post to this group, send email to sqlalch...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > sqlalchemy+unsubscr...@googlegroups.com.
> > For more options, visit this group at
> > http://groups.google.com/group/sqlalchemy?hl=en.
> >
> >
>
> --
> You received this message because you are subscribed to the
> Google Groups "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
