I'm deploying a web2py app in GAE (web2py version 2.2.1) that has a number 
of tables with fields that reference other tables in the same model.  I 
have a few pages that use the SQLFORM.grid to display the data from those 
tables.  When running the app locally using sqlite as the backend 
everything works as it should and cascading deletes take place.  When 
running under GAE cascading deletes don't work (I believe that's a GAE 
'feature').  However I've tried setting my own 'ondelete' event in the 
SQLFORM.grid to manually delete dependent rows and while that event fires 
properly (I can see the logs) the dependent rows are never deleted. I have 
also tried setting 'ondelete=NO ACTION' in the model and issue a 
db.commit() at the end of the ondelete event.

What could be going on here? I would think the event trigger for ondelete 
should do the job but something must stop it from working.  Should I stay 
away from SQLFORM.grid and try a different route to get around this GAE 
limitation?

Thanks in advance,
Julian

-- 



Reply via email to