This is the first time I'm seeing the construct "_filter_fields". I can guess at what it does, but could you explain, please? I couldn't find it in the doc.
Also, for clarification, do readable and writable only apply to forms (seems so)? If a field is writable=False, it seems like it can still be written explicitly by a db.table.insert. Yes? On Oct 16, 9:57 am, mdipierro <[email protected]> wrote: > It often happens that you have two tables (for example 'client' and > 'address' which are linked together by a reference and you want to > create a single form that allows to insert info about one client and > its default address. Here is how: > > model: > > db.define_table('client', > Field('name')) > db.define_table('address', > Field('client',db.client,writable=False,readable=False), > Field('street'),Field('city')) > > controller: > > def register(): > form=SQLFORM.factory(db.client,db.address) > if form.accepts(request.vars): > id = db.client.insert(**db.client._filter_fields(form.vars)) > form.vars.client=id > id = db.address.insert(**db.address._filter_fields(form.vars)) > response.flash='Thanks for filling the form' > return dict(form=form) > > Notice the SQLFORM.factory (it makes ONE form using public fields from > both tables and inherits their validators too). > On form accepts this does two inserts (some data in one table and some > data in the other). > > Massimo
