Jonathan Ellis wrote:
>yes, you should, and your commented-out code looks fine
>
>
thank you, Jonathan.
>On 1/20/07, jose <[EMAIL PROTECTED]> wrote:
>
>
>>Hi all,
>>
>>I have a question about transactions....
>>I need to insert data into two tables (anag and user), sice I need to
>>insert the generated primary key of anag into user.
>>I have to flush anag to have the id to insert into user table.
>>What happens if there's an interruption in the middle of this, for
>>example, immediately after to flush anag?
>>Should I use create_transaction() to avoid a such thing?
>>
>>#transaction = session.create_transaction()
>>#try:
>> anag = Anag(
>> name = data.get('display_name')
>> )
>> session.save(anag)
>> session.flush()
>>
>> user = User(
>> anag_id = anag.id
>> )
>> session.save(user)
>> session.flush()
>>
>> #transaction.commit()
>>#except:
>> #transaction.rollback()
>>
>>jo
>>
>>
>>
>>
jo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
