Hello,

Could someone please, explain me what's wrong with this transaction?
....
 File 
"/usr/lib/python2.4/site-packages/TurboGears-1.0-py2.4.egg/turbogears/database.py",
 line 303, in sa_rwt
    transaction.commit()
  File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line 54, in 
commit
  File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 389, in 
commit
InvalidRequestError: This transaction is inactive
---------

def save_user(data,user,anagrafica):
       transaction = session.create_transaction()
       try:
           for f in user.ruoli:
               session.delete(f)
           session.flush()
           for item in data.get('dettaglio'):
               if item.get('cod_ruolo'):
                   user.ruoli.append(UserGroup(
                          id_operatore = item.get('id_operatore'),
                          )
               )
           user.data_inizio_attivita = data.get('data_inizio_attivita')
           anagrafica.nome           = data.get('display_name')
           session.save(user)
           session.save(anagrafica)
           session.flush()
           transaction.commit()
       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