On Sun, 24 Jan 2010 09:27:26 -0500, Michael Bayer <mike...@zzzcomputing.com> 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 >> <fah...@email.unc.edu> 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 sqlalchemy@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.