[web2py] how to implement database tables with one level of indirection?

2011-07-02 Thread Luis Goncalves
Hello! How do I make a database table where the fields are defined by another table? For example, suppose some users of my system are event organizers, and they can define what fields would belong in a person's profile. Then, attendees of that event have to fill out a profile with those specif

Re: [web2py] how to implement database tables with one level of indirection?

2011-07-04 Thread Richard Vézina
I think you need inheritance : http://web2py.com/book/default/chapter/06#Table-Inheritance Richard On Sun, Jul 3, 2011 at 1:15 AM, Luis Goncalves wrote: > Hello! > > How do I make a database table where the fields are defined by another > table? > > For example, suppose some users of my system

Re: [web2py] how to implement database tables with one level of indirection?

2011-07-04 Thread Luis Goncalves
Hello Richard! I looked at this, but wasn't sure how it could help -- what I need is a way for a (non-technical) admin to create profile forms with arbitrary fields (through a friendly web interface), and then users to be able to view and edit their (run-time reconfigurable) profiles. At any r

Re: [web2py] how to implement database tables with one level of indirection?

2011-07-04 Thread Richard Vézina
Maybe you could find some inspiration from this project for Django : http://code.google.com/p/django-dynamic-formset/ You need to install Django to test it... What you seems to do is adding an arbitrary number of input for a given field... Following good database design pratice you will normali

Re: [web2py] how to implement database tables with one level of indirection?

2011-07-04 Thread Luis Goncalves
Thanks for the links!! Django dynamic formsets seems powerful! When I first started off, I investigated using django, but found it very difficult. Web2py is so much easier to use (especially with the clear manual, and "one click" install with working apps ('Welcome'))!!! Maybe I'll end up contr

Re: [web2py] how to implement database tables with one level of indirection?

2011-07-04 Thread Richard Vézina
It surely a missing feature... Richard On Mon, Jul 4, 2011 at 8:30 PM, Luis Goncalves wrote: > Thanks for the links!! > > Django dynamic formsets seems powerful! When I first started off, I > investigated using django, but found it very difficult. Web2py is so much > easier to use (especially

Re: [web2py] how to implement database tables with one level of indirection?

2011-07-04 Thread Bruno Rocha
The web2py app wizard has a Dynamic model creator, may be you can take a look in to the wizard code. And fork as a plugin. On Mon, Jul 4, 2011 at 9:38 PM, Richard Vézina wrote: > It surely a missing feature... > > Richard > > > On Mon, Jul 4, 2011 at 8:30 PM, Luis Goncalves wrote: > >> Thanks for

Re: [web2py] how to implement database tables with one level of indirection?

2011-07-05 Thread Richard Vézina
I thougth about it too, but I didn't find the thread... ;-) Richard On Mon, Jul 4, 2011 at 9:19 PM, Bruno Rocha wrote: > The web2py app wizard has a Dynamic model creator, may be you can take a > look in to the wizard code. And fork as a plugin. > > > On Mon, Jul 4, 2011 at 9:38 PM, Richard Vé

Re: [web2py] how to implement database tables with one level of indirection?

2011-07-05 Thread Anthony
That type of method will work, but it will result in a new database table being created for each event/custom profile. There are various alternatives for implementing user defined fields -- here are some Stackoverflow links: http://stackoverflow.com/questions/5106335/how-to-design-a-database-fo