Rodney Haynie wrote:
>
>
> Michael Bayer wrote:
>> 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.
>>
>> I failed to say this is a TG2 app. There is the transaction module I
>> import at the top of the controller file.
>>
>
> import transaction
>
> I was trying different things, and I believe I don't need the code
> "transaction.commit()". But I was grasping at straws.
> Is there any way I can tell that the automatic transaction sees changes?
ive no idea what that is. I think in this case you're looking for:
tranaction = conn.begin()
....
transaction.commit()
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
