[sqlalchemy] Re: Textual SQL

2009-02-03 Thread Pavel Skvazh
Thank you so much guys! Now I figured it out. Hope this will help someone else as well :) On Feb 2, 9:53 pm, MikeCo mconl...@gmail.com wrote: Commit behavior depends on how you configure the session's autocommit property. Follow the log messages in this little test. from sqlalchemy import

[sqlalchemy] Re: Textual SQL

2009-02-02 Thread Bob Farrell
On Mon, Feb 02, 2009 at 09:56:15AM -0800, Pavel Skvazh wrote: Session.execute('INSERT INTO SOMETHING SOMETHING / DELETE/ UPDATE') Do I have to call Session.commit() after this or it's already taken care of? In other words does the literal sql statements follow the session transaction

[sqlalchemy] Re: Textual SQL

2009-02-02 Thread MikeCo
Commit behavior depends on how you configure the session's autocommit property. Follow the log messages in this little test. from sqlalchemy import MetaData, Table, Column, String from sqlalchemy.orm import sessionmaker meta = MetaData('sqlite:///') Session = sessionmaker(bind=meta.bind) t =