Hi Everyone!!  Long time lurker & first time posting...

I am working on a simple application that I intend to deploy in GAE.  I 
have a few tables with fields that reference other tables which by default 
enables the ondelete=CASCADE behavior.  This works fine when I run the app 
locally using sqlite as the database.
I believe GAE doesn't support cascading deletes natively. 
I presume web2py doesn't support cascading deletes when running under GAE 
because I don't see that happening.  When I delete a row (rendered through 
SQLFORM.grid) only that row is deleted an all dependent tables remain 
untouched.

The problem I have is that I can't find a way for me to implement the 
cascading behavior manually.  I added a 'ondelete=mydelete' event for the 
SQLFORM.grid where I do the manual delete of the dependent tables and 
commit in the database, but that doesn't seem to work either.  I searched 
through this forum but didn't find any suggestions either.  Any suggestions 
as to what could I do to solve this??  Do I have to stay away from 
SQLFORM.grid to avoid this problem?

Many Thanks!!
Julian

I am using web2py Version 2.2.1 (2012-10-21 16:57:04) stable on OS X 
Mountain Lion and GoogleAppEngineLauncher version 1.7.3 (1.7.3.333)

-- 



Reply via email to