Nop!
crud = single table.
Richard
On Tue, Oct 1, 2013 at 3:03 AM, at <matifa...@gmail.com> wrote:
>
> Does it work with crud as well?
>
> Thanksd
>
> On Monday, 12 October 2009 06:37:31 UTC+5, mdipierro wrote:
>>
>> Something is wrong with this:
>>
>> db.define_table('dogs',
>> ...
>> Field('vaccination_id', db.vaccinations))
>>
>> db.define_table('vaccinations'**,
>> Field('dog_id', db.dogs),
>> ...
>> )
>> there is a circular definition and seems to indicate each dog can have
>> a single vaccination.
>>
>> I would go with this:
>>
>> db.define_table(
>> 'users'
>> Field('name')
>> )
>>
>> db.define_table(
>> 'dogs',
>> Field('owner_id', db.users),
>> Field('name'),
>> )
>>
>> db.define_table(
>> 'vaccinations',
>> Field('dog_id'),
>> Field('vaccination')
>> )
>>
>> You can do things like:
>>
>> form=SQLFORM.factory(db.dogs,**db.vaccinations)
>>
>> but you have to be careful about repeated fields.
>>
>> If you describe the workflow of what you need to do perhaps we can
>> help more.
>>
>> Massimo
>>
>>
>> On Oct 11, 6:47 pm, Peter Woolf <pwo...@gmail.com> wrote:
>> > Can I create a crud form that simultaneously update multiple rows and
>> > multiple tables? I’ve been through the web2py manual a number of
>> > times, but don’t see this issue addressed. Below is an example:
>> >
>> > In db.py
>> >
>> > db.define_table(
>> > 'users'
>> > Field('name')
>> > )
>> >
>> > db.define_table(
>> > 'dogs',
>> > Field('owner_id', db.users),
>> > Field('name'),
>> > Field('vaccination_id', db.vaccinations)
>> > )
>> >
>> > db.define_table(
>> > 'vaccinations',
>> > Field('dog_id', db.dogs),
>> > Field('vaccination')
>> > )
>> >
>> > Given these three tables, I want to be create a crud form where I can
>> > update the names and vaccinations of all of the dogs of a particular
>> > owner. For example, if I have two dogs, muffy and fluffy, then I want
>> > to create a form where both the records of muffy AND fluffy are
>> > presented in ONE form to allow me to edit the tables ‘dogs” and
>> > ‘vaccinations’ with one submit button.
>> >
>> > Any thoughts on how to do this? I can easily make a crud form for a
>> > single record, but this would mean I have many submit buttons on a
>> > page or a very long series of pages to do something simpler.
>> >
>> > Any thoughts would be appreciated.
>> >
>> > Thanks,
>> > --Peter
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
