Re: [web2py] Re: Auth_user ondelete
It worked out, thanks! Thread closed. 2011/6/9 Anthony > On Thursday, June 9, 2011 6:59:34 PM UTC-4, Thiago wrote: >> >> I have this auth_user table, and another table called activities. This >> activities have 2 fields that are foreing keys to user (created by and >> modified by). If I delete any user that created or modified one activity, >> the activity is deleted. >> >> Do I have to put NO ACTION in all fields that is foreign key to user? I >> don't see how NO ACTION in the ondelete of activity solves my problem... >> >> Sorry I'm very confused. I just got one system made by some other people >> (with no documentation =( ) and I am trying to understand to maintain it... >> > > I think you would specify ondelete='NO ACTION' in the reference fields in > the 'activities' table. > >
Re: [web2py] Re: Auth_user ondelete
I have this auth_user table, and another table called activities. This activities have 2 fields that are foreing keys to user (created by and modified by). If I delete any user that created or modified one activity, the activity is deleted. Do I have to put NO ACTION in all fields that is foreign key to user? I don't see how NO ACTION in the ondelete of activity solves my problem... Sorry I'm very confused. I just got one system made by some other people (with no documentation =( ) and I am trying to understand to maintain it... 2011/6/9 Anthony > On Thursday, June 9, 2011 2:14:59 PM UTC-4, Thiago wrote: >> >> I'm new to web2py, but familiar to similar frameworks. I have a system >> that uses web2py builtin auth_user table. The problem is that I wanna use >> ondelete='NO ACTION' in my app (it is CASCADE by default), and I don't >> know how to put it in the model file. Anyone can help? >> > > Are you saying you want to specify ondelete='NO ACTION' for one of the > fields in the builtin auth_user table? It's only relevant for upload and > reference fields, and I don't think the auth_user table includes any such > fields. > > Anthony >
[web2py] Auth_user ondelete
Hi, I'm new to web2py, but familiar to similar frameworks. I have a system that uses web2py builtin auth_user table. The problem is that I wanna use ondelete='NO ACTION' in my app (it is CASCADE by default), and I don't know how to put it in the model file. Anyone can help? Att. Thiago