[sqlalchemy] Issue with transactions and proxied db_api queries

2011-12-12 Thread Noon Silk
light here? Am I doing something fundamentally wrong? Or have I missed a better way to do what I need? -- Noon Silk Fancy a quantum lunch? http://groups.google.com/group/quantum-lunch?hl=en Every morning when I wake up, I experience an exquisite joy — the joy of being this signature. -- You

Re: [sqlalchemy] Issue with transactions and proxied db_api queries

2011-12-12 Thread Noon Silk
On Tue, Dec 13, 2011 at 9:19 AM, Michael Bayer mike...@zzzcomputing.com wrote: On Dec 12, 2011, at 5:08 PM, Noon Silk wrote: Hello, Firstly I'd like to explain what I'm trying to do, and that is: Use SQLAlchemy alongside regular cursor style queries. More specifically, I want to use

Re: [sqlalchemy] Issue with transactions and proxied db_api queries

2011-12-12 Thread Noon Silk
On Tue, Dec 13, 2011 at 3:44 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Dec 12, 2011, at 7:10 PM, Noon Silk wrote: On Tue, Dec 13, 2011 at 9:19 AM, Michael Bayer mike...@zzzcomputing.com wrote: On Dec 12, 2011, at 5:08 PM, Noon Silk wrote: Hello, Firstly I'd like to explain what

[sqlalchemy] Is it possible to have a transaction commit to the db and then rollback? (SA 0.7, Python 2.7, Postgres)

2011-12-08 Thread Noon Silk
I can't figure out how. I have the following setup: ... engine = create_engine(...) session = scoped_session(sessionmaker(..., bind=engine)) ... session.add(object) session.commit() What I need is to add this object *to the database*, and then select it in some non-sql-alchemy code, and then

Re: [sqlalchemy] Is it possible to have a transaction commit to the db and then rollback? (SA 0.7, Python 2.7, Postgres)

2011-12-08 Thread Noon Silk
Please disregard this; I've solved it. On Fri, Dec 9, 2011 at 11:18 AM, Noon Silk noonsli...@gmail.com wrote: I can't figure out how. I have the following setup: ... engine = create_engine(...) session = scoped_session(sessionmaker(..., bind=engine)) ... session.add(object