I think what you try to do is a kind of bulk insert or bulk update...
I write my own bulk update function with a SQLTABLE table displaying the
rows that will be update and a SQLFORM.factory form for handling the
submission... Then you just manually process records base on the id of the
rows you have selected...
In that particular case of use of I had to find a way to make sure no
records change of state between the time the form is displayed to the end
user and the time he finally submit the form... I calculate a md5_hash for
every rows then pass it to the form as a hidden field then check for every
row if there were still the same hash before actually update the row...
It works for me this way cause I had really simple update to make to all
the records (just one field was updated will the same value for every
record).
You may search the mailing-list Massimo had propose something ressembling
to this (I can't find it back) :
rows = db(...).select(db...)
form = SQLFORM.factory(*[Field(f+'_%s'%r.id, default=r[f]) for r in rows
for f in r])
if form.process().accepted:
for key,value in form.vars.items():
db(db[request.args(0)].id==key[3:]).update(reviewed_by = 1)
db.commit()
There is no easy way to do what you want to do I think... At least there is
noting as easy as form = crud.create_bulk(...) or crud.update_bulk(...)
Richard
On Fri, Dec 23, 2011 at 2:00 AM, lyn2py <[email protected]> wrote:
> It is simple to edit or update if it only involves one table
> (SQLFORM).
>
> However I have combined tables into a form using SQLFORM.factory and
> also SQLFORM.factory + append fields
>
> How should I go about updating a form with combined tables (+ append
> fields)?
>
> I have read
>
> http://web2py.com/books/default/chapter/29/7#SQLFORM-and-insert/update/delete
> but it doesn't cover how to use SQLFORM.factory with record edits.
>
> Thanks!
