On Sun, 24 Jan 2010 09:27:26 -0500, Michael Bayer
<[email protected]> wrote:
> On Jan 24, 2010, at 7:22 AM, Faheem Mitha wrote:
>
>> I'm belatedly following up to this earlier posting.
>>
>> The problem there was that I wasn't setting autocommit=True in
>> text(). However, I was wondering what I can do if I want to directly
>> write
>>
>> conn.execute("somestuff")
>> conn.close()
>>
>> and have it autocommitted, rather than using text(). The execute()
>> function doesn't appear to have an 'autocommit' option. What can I do
>> to have a autocommit happen in this case?
> we dont have a per-connection autocommit option, yet. but I have
> ideas on how to introduce that. but for now if you don't send the
> option along in the statement, you'd have to do it explicitly,
> ie. trans = conn.begin(); conn.execute(); trans.commit().
Thanks for the quick reply. I see. Thanks for the clarification. I can
do multiple executes before the final commit, yes?
Regards, Faheem.
>>
>> Regards, Faheem.
>>
>> On Wed, 7 Oct 2009 17:37:51 -0400 (EDT), Faheem Mitha
>> <[email protected]> wrote:
>>
>>>
>>> Hi,
>>>
>>> When running this function with postgresql 8.4 and sqla 0.5.5,
>>>
>>> def test(dbstring):
>>> from sqlalchemy import create_engine
>>> db = create_engine(dbstring)
>>> conn = db.connect()
>>> from sqlalchemy.sql import text
>>> gq = text("""
>>> SET search_path TO public;
>>> DROP SCHEMA IF EXISTS foo CASCADE;
>>> CREATE SCHEMA foo;
>>> """)
>>> conn.execute(gq)
>>> conn.close()
>>>
>>> the schema foo is not created. However, removing the
>>>
>>> SET search_path TO public;
>>>
>>> line makes it work. This is not the case when issuing these commands
>>> directly via psql. Any idea what might be going on here?
>>>
>>> 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
>>> -~----------~----~----~----~------~----~------~--~---
>>>
>>>
>>
>> --
>> 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.
>>
>
--
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.
