On Fri, 9 Oct 2009 22:34:11 -0400, Michael Bayer
<[email protected]> wrote:
>
> On Oct 9, 2009, at 7:35 PM, Faheem Mitha wrote:
>
>> Can you explain why removing the "SET search_path TO public;" string
>> makes a commit happen? You also say "that string you have will not
>> trip off SQLA's "autocommit" feature." How does this autocommit
>> feature work, and are there certain strings that will trigger an
>> autocommit?
>
> for textual statements, autocommit is applied when this regexp matches:
>
> AUTOCOMMIT_REGEXP = re.compile(r'\s*(?:UPDATE|INSERT|CREATE|DELETE|
> DROP|ALTER)',
> re.I | re.UNICODE)
Thanks Michael,
That's very helpful. I didn't realise that sqlalchemy did this kind of
magic.
Regards, Faheem.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
