I think we need Massimo opinion on this... Richard
On Thu, Nov 17, 2011 at 12:16 PM, ~redShadow~ <[email protected]>wrote: > On Wed, 2011-11-16 at 15:36 -0500, Richard Vézina wrote: > > Man! > > > > > > I think you got a nice solution for this exact problem... > > > > > > I had tried with jQuery in the pass to manage this by duplicating the > > field that I want to bunch insert for... It was working but was > > breaking the workflow of form validation if I remember... Web2py has > > change a lot since then and I don't know if Massimo has not resolved > > this issue (confirmation needed!!). > > > > > > But I think what you suggest is pretty neath approach and easy to > > implement... > > > > > > Web2py guru?? > > > > > > I suspect that you want to make insertion in multiple table... > > Yep, but I also want to have some control over this.. since whether to > insert/update a record is determined by other form fields, the number of > tables is variable and possibly there are clashing field names, ... > > > You may be interrested by this : > > > > > > > http://web2py.com/book/default/chapter/07?search=SQLFORM.factory#One-form-for-multiple-tables > > Tried that, but «This only works when the tables don't have field names > in common.». > > > Anyways, I managed to find a way that seems to work, in order to merge > SQLFORMs for multiple tables, adding a "namespace" in front of field > name, and then stripping it before doing inserts. > > See relevant parts from the controller source code here: > http://pastebin.com/V1xwcjAg > > This of course could be extended to build a tree from ``form.vars``, > instead of just a ``dict``-of-``dict``s (maybe by exploding > ``my[var][name]``-style subscripted vars), etc.. > -- > Samuele ~redShadow~ Santi > ---------------------------------------------------------------- > redshadow[at]hackzine.org - redshadowhack[at]gmail.com > > Blog: http://hackzine.org > > GPG Key signature: > 050D 3E9F 6E0B 44CE C008 D1FC 166C 3C7E EB26 4933 > ---------------------------------------------------------------- > /me recommends: > Squadra Informatica - http://www.squadrainformatica.com > ---------------------------------------------------------------- > - Proud ThinkPad T-Series owner > - Registered Linux-User: #440008 > * GENTOO User since 1199142000 (2008-01-01) > * former DEBIAN SID user > ---------------------------------------------------------------- > "Software is like sex: it's better when it's free!" > -- Linus Torvalds > >
