Hi
I need to generate update/delete/insert SQL for a proprietary system that
has an oracle database.
(The system will pass the SQL onto the oracle database but for lengthy
reasons, it needs to go through the proprietary system)
I'm using SQLAlchemy to query the oracle database directly, i then
http://docs.sqlalchemy.org/en/rel_0_8/core/tutorial.html
I think you can reproduce some stuff like this:
http://docs.sqlalchemy.org/en/rel_0_8/core/tutorial.html#insert-expressions
At least this is the way that I generate my SQL string output. I
suspect that you can also use delete, select and
Ahhh
That would be better than my option A), but not as good as option B)
I read that document earlier tonight too.
On Wednesday, May 15, 2013 10:58:54 PM UTC+10, Mauricio de Abreu Antunes
wrote:
http://docs.sqlalchemy.org/en/rel_0_8/core/tutorial.html
I think you can reproduce some stuff
the ORM is designed to work in a highly interactive way, especially if
autogenerated values are in use (like from sequences, etc.) so it would be very
difficult to get it to produce standalone SQL scripts. Option A is likely
simpler, though with option B I'd probably grab the SQL echo output
Is there an easy way to make it begin a transaction, execute the sql and then
rollback?
On 16/05/2013, at 1:10 AM, Michael Bayer mike...@zzzcomputing.com wrote:
the ORM is designed to work in a highly interactive way, especially if
autogenerated values are in use (like from sequences, etc.)
the ORM ? just session.flush() and session.rollback()
On May 15, 2013, at 9:14 PM, Jarrod Chesney jarrod.ches...@gmail.com wrote:
Is there an easy way to make it begin a transaction, execute the sql and then
rollback?
On 16/05/2013, at 1:10 AM, Michael Bayer mike...@zzzcomputing.com