Rodney Haynie wrote:
>
> I am having problems getting my data to save when the changes are made
> through stored procedures.
> I created a sample block of code below to show exactly how I am
> implementing this.
>
> <code>
> conn = DBSession.connection()
> statement = sql.text("""CALL insert_test(321, 1);""")
> results = conn.execute(statement).fetchall()
> # The result set will have the new primary key value.
> if results == []:
> return None
>
> newID = results[0][0]
> transaction.commit()
> return newID
> </code>
what is "transaction" here ? it seems to be ephemeral.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
