This is great, I've been away from web2py for about a year now and
this feature is exactly what I was trying to do quite some time ago by
manually storing and filtering by a SiteId.
A couple of questions.
1 - Is there a way to over ride the filter if you do not want it, for
say Administration?
2 - Can you define tables that are 'global' which always over ride the
feature? In this case I'm thinking a read-only table that all sites
retrieve information from.
On May 26, 10:38 am, villas <villa...@gmail.com> wrote:
> Thanks, that sounds like a solution and I will experiment a little.
> I like thisfeaturevery much!
>
> On May 26, 4:30 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
> wrote:
>
>
>
>
>
>
>
> > You can do what you ask
>
> > db.define_table('tenant',Field('name'))
> > # somehow store a tenant.id in session.tenant_id
> > # use tenant id for all other tables but the one above
> > db._common_fields=[Field('request_tenant',default=session.tenant_id,writabl
> > e=False,readable=False)]
>
> > On May 26, 9:52 am, villas <villa...@gmail.com> wrote:
>
> > > Hi Massimo
>
> > > My thought/suggestions are:
>
> > > Almost everyone using thisfeaturewill also wish to keep data
> > > relating to the tenant, e.g. they will have a 'tenant' table with
> > > information about 'harvard.school.org'.
>
> > > The foreign key relating to the 'tenant' table under your system would
> > > therefore be using the string 'harvard.school.org' rather than an id
> > > integer. Is that a good idea?
>
> > > Many webservers will accept any sub-domain and this could lead to the
> > > field 'request_tenant' being populated with misspellings etc,
> > > e.g. 'harvd.school.org' or 'harverd.school.org',
> > > 'harvhard.school.org'. This would be difficult to relate to a
> > > 'tenant' table.
>
> > > To stop those problems, you might still consider to use the ideas in
> > > my original suggestion, i.e.
> > > * lookup the sub-domain when the request is received and allocate an
> > > id reference.
> > > * specify what to do if the sub-domain is not recognised i.e. provide
> > > a default value or raise an error (maybe 404).
> > > * to save time when it is a single tenant system, set a global
> > > constant to avoid the overhead of the multi-tenant lookup.
>
> > > Regards,
> > > David
>
> > > On May 26, 3:10 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
> > > wrote:
>
> > > > I changed 'request_precinct' to 'request_tenant' since this is more
> > > > appropriate. We are talking about buildig multi-tenant apps.
>
> > > > db._common_fields=[Field('request_tenant',default=request.env.http_host,w
> > > > ritable=False,readable=False)]
>
> > > > Notice you can also do
>
> > > > db._common_fields=[auth.signature]
>
> > > > and all tables will have created_by, modified_by, created_on,
> > > > modified_on, etc.
>
> > > > On May 26, 7:17 am, Massimo Di Pierro <massimo.dipie...@gmail.com>
> > > > wrote:
>
> > > > > yes.
>
> > > > > On May 25, 11:37 pm, mattgorecki <m...@goelephant.com> wrote:
>
> > > > > > So in this example request_precinct would equal
> > > > > > harvard.anyschool.org?
>
> > > > > > Matt
>
> > > > > > On May 25, 9:47 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
> > > > > > wrote:
>
> > > > > > > There are two more features in trunk that I could use some testing
> > > > > > > with (commonfieldsand precints)
>
> > > > > > > Imagine you have created an app "school" designed to manage one
> > > > > > > school. It has one database and many tables. You wrote it with one
> > > > > > > school in mind. Now you want to turn it into a service so that
> > > > > > > multiple schools can register and use it. You want to identify the
> > > > > > > school for example by the urlhttp://harvard.anyschool.organdeach
> > > > > > > school should ONLY see its own users, groups, records, etc. etc.
>
> > > > > > > Before today to do this you would have to rewrite all your tables
> > > > > > > and
> > > > > > > queries.
>
> > > > > > > Today you can do it without changing your code at all. You just
> > > > > > > have
> > > > > > > to add this line after db=DAL(...)
>
> > > > > > > db._common_fields=[Field('request_precinct',default=request.env.http_host,w
> > > > > > > ritable=False,readable=False)]
>
> > > > > > > Yes. That is it!
>
> > > > > > > How does it work?
>
> > > > > > > 1) db._common_fields is a list offieldsthat you want to add to all
> > > > > > > tables.
> > > > > > > 2) The field called 'request_precinct' is special. Every query
> > > > > > > involving a table having this field is automatically filtered
> > > > > > > byfield
> > > > > > > value == field default. In our example the default is
> > > > > > > request.env.http_host, i.e. the hostname in the http request which
> > > > > > > identifies the school.
> > > > > > > 3) The field is hidden (writable=False,readable=False) but has a
> > > > > > > default therefore it is automatically set for all inserts.
>
> > > > > > > There is nothing special about schools here. You can use it with
> > > > > > > any
> > > > > > > other app.
>
> > > > > > > Give it a try and let me know.
>
> > > > > > > I could use some help in writing some documentation about thenew
> > > > > > > features added today. ;-)
>
> > > > > > > Massimo
