[web2py] Re: request_tenant oddity
Currently, even appadmin is tenant dependent. On Aug 30, 6:03 am, Cliff cjk...@gmail.com wrote: Is request_tenant supposed to work this way? In my model I have a tenants table, which I define before I add the request_tenant field. In that table I have one tenant. In my auth_user table I have one user. His request_tenant field is set to the id of the one tenant in the tenant table. Okay so far. I log in as that one user and open the appadmin database page. The appadmin will show me records that belong to the tenant. If I create a record with a bogus request_tenant id, I can't see it in the appadmin database index pages. If I log out and use appadmin I can see all the rows on the index pages BUT the signature fields and the request_tenant field are invisible. Are request_tenant and appadmin supposed to interact this way? It seems like appadmin should be able to see all records in a table, regardless of the request_tenant setting. Thanks, Cliff Kachinske
[web2py] Re: request_tenant oddity
Massimo, Thanks for the quick response. This is actually a good thing as it will force me to get my Postgresql chops together now rather than later. Cliff Kachinske On Aug 30, 8:20 am, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Currently, even appadmin is tenant dependent. On Aug 30, 6:03 am, Cliff cjk...@gmail.com wrote: Is request_tenant supposed to work this way? In my model I have a tenants table, which I define before I add the request_tenant field. In that table I have one tenant. In my auth_user table I have one user. His request_tenant field is set to the id of the one tenant in the tenant table. Okay so far. I log in as that one user and open the appadmin database page. The appadmin will show me records that belong to the tenant. If I create a record with a bogus request_tenant id, I can't see it in the appadmin database index pages. If I log out and use appadmin I can see all the rows on the index pages BUT the signature fields and the request_tenant field are invisible. Are request_tenant and appadmin supposed to interact this way? It seems like appadmin should be able to see all records in a table, regardless of the request_tenant setting. Thanks, Cliff Kachinske
[web2py] Re: request_tenant oddity
I think you can disable this although I have not tried. In your model: if request.controller=='appadmin': db._request_tenant=None If this does what you want, please let me know. On Aug 30, 7:20 am, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Currently, even appadmin is tenant dependent. On Aug 30, 6:03 am, Cliff cjk...@gmail.com wrote: Is request_tenant supposed to work this way? In my model I have a tenants table, which I define before I add the request_tenant field. In that table I have one tenant. In my auth_user table I have one user. His request_tenant field is set to the id of the one tenant in the tenant table. Okay so far. I log in as that one user and open the appadmin database page. The appadmin will show me records that belong to the tenant. If I create a record with a bogus request_tenant id, I can't see it in the appadmin database index pages. If I log out and use appadmin I can see all the rows on the index pages BUT the signature fields and the request_tenant field are invisible. Are request_tenant and appadmin supposed to interact this way? It seems like appadmin should be able to see all records in a table, regardless of the request_tenant setting. Thanks, Cliff Kachinske
[web2py] Re: request_tenant oddity
It allows me to see all the rows in the table, irrespective of request_tenant, but it does not show me the signature columns or the request_tenant column. It acts this way whether I am logged in as a user or not. Using 1.98.2, by the way. This is not a high priority, though. I asked the original question to find out if I have a bug in my code. Since it appears not, I'm content to work around the problem. On Aug 30, 12:07 pm, Massimo Di Pierro massimo.dipie...@gmail.com wrote: I think you can disable this although I have not tried. In your model: if request.controller=='appadmin': db._request_tenant=None If this does what you want, please let me know. On Aug 30, 7:20 am, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Currently, even appadmin is tenant dependent. On Aug 30, 6:03 am, Cliff cjk...@gmail.com wrote: Is request_tenant supposed to work this way? In my model I have a tenants table, which I define before I add the request_tenant field. In that table I have one tenant. In my auth_user table I have one user. His request_tenant field is set to the id of the one tenant in the tenant table. Okay so far. I log in as that one user and open the appadmin database page. The appadmin will show me records that belong to the tenant. If I create a record with a bogus request_tenant id, I can't see it in the appadmin database index pages. If I log out and use appadmin I can see all the rows on the index pages BUT the signature fields and the request_tenant field are invisible. Are request_tenant and appadmin supposed to interact this way? It seems like appadmin should be able to see all records in a table, regardless of the request_tenant setting. Thanks, Cliff Kachinske
