Jose Soares ha scritto:
> Michael Bayer ha scritto:
>   
>> not sure about that, i thought maybe the multiple flush()es are
>> breaking something but I just added a test case and it doesnt
>> reproduce.  make sure youre on the most recent versions since that was
>> broken a few versions back...
>>
>>   
>>     
> This error happens some times, not every time.
> my versione is SQLAlchemy-0.3.0
>
> jo
>
>
>   
Hi Mike,
I upgraded to 0.3.4
but this function works only without create_transaction()...

    def add_user(self,data):
        #transaction = session.create_transaction()
        try:
            anagrafica = Anagrafica(
                nome         = data.get('display_name'),
                email        = data.get('email'),
                )
            session.save(anagrafica)
            session.flush()
            user = User(
                id_anagrafica        = anagrafica.id, #ultimo record 
inserito in anagrafica
                data_inizio_attivita = data.get('data_inizio_attivita'),
                data_fine_attivita   = data.get('data_fine_attivita'),
                )
            for item in data.get('dettaglio'):
                if item.get('cod_ruolo'):
                    user.ruoli.append(UserGroup(
                               id_operatore = item.get('id_operatore'),
                               group_id     = item.get('cod_ruolo'),
                               id_asl       = item.get('id_asl'),
                               )
                    )
            session.save(user)
            session.flush()
            #transaction.commit()
            return "inserito il record %d!"%user.id
        except:
            #transaction.rollback()


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
-~----------~----~----~----~------~----~------~--~---

Reply via email to