On Dec 13, 2006, at 3:29 PM, Sanjay wrote:
> > This is a conceptual novice question on automatic transaction handling > and flush (sqlalchemy). > > As a controller method automatically runs in a transaction, I was > thinking that any flushed data should be rolled back if an exception > occurs in between. The code below and inline comments elaborate my > point. > > @expose() > def create_company(company_name, ceo_name) > company = Company(name=company_name) > session.flush() # so that company.id is generated > employee = Employee(name=ceo_name) > company.employees.append(employee) > ### if I raise an exception here, the company data is not rolled > back # > ### But should not it get rolled back, if the automatic > transaction > is around? > session.flush() # so that employee.id is generated > company.ceo_id = employee.id > > As I intrepreted SQLAlchemy docs, multiple flush() can be done in > between a transaction. Am I missing some concepts? You should also clear the session so the pending object is not flushed by run_with_transaction. Alberto --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
