Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-16 Thread Richard Vézina
You are welcome! Richard On Mon, Sep 15, 2014 at 3:45 PM, Jan Beilicke wrote: > I chose approach B and it works fine. Thanks for mentioning drop downs. > > Kind regards, > > Jan > > Am Donnerstag, 11. September 2014 17:24:40 UTC+2 schrieb Richard: >> >> B will help you filter your drop down of

Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-15 Thread Jan Beilicke
I chose approach B and it works fine. Thanks for mentioning drop downs. Kind regards, Jan Am Donnerstag, 11. September 2014 17:24:40 UTC+2 schrieb Richard: > > B will help you filter your drop down of component package if you can only > have in a package the same supertype component. > > Diffic

Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-11 Thread Richard Vézina
B will help you filter your drop down of component package if you can only have in a package the same supertype component. Difficults to say without concrete example. Richard On Thu, Sep 11, 2014 at 9:58 AM, Jan Beilicke wrote: > These are just sample names. In reality they are separate busine

Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-11 Thread Jan Beilicke
These are just sample names. In reality they are separate business/use case entities sharing only the same supertype, they are not enumerated. Am Donnerstag, 11. September 2014 15:42:47 UTC+2 schrieb Richard: > > Why component_a, _b, _c... You will end up create new table all the time... > > Rich

Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-11 Thread Richard Vézina
Why component_a, _b, _c... You will end up create new table all the time... Richard On Thu, Sep 11, 2014 at 7:04 AM, Jan Beilicke wrote: > Hi everyone, > > I'm working on a web2py project which requires a complex relationship > model. I want to use a model that works well with web2py's DAL and

[web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-11 Thread Jan Beilicke
Hi everyone, I'm working on a web2py project which requires a complex relationship model. I want to use a model that works well with web2py's DAL and I would be glad if somebody could point me into the right direction. I created a small sample ER diagram to illustrate my problem, only the impo

Re: [web2py] Web2py database design

2012-12-03 Thread Vinicius Assef
Try http://code.google.com/p/wwwsqldesigner/ On Mon, Dec 3, 2012 at 7:17 AM, David wrote: > Hi guys, > > I'm new to web2py, and got a question here. I want to design a database with > sqlite for my app, but I prefer to design it on a visualiable tool e.g. GEA, > which is recommended in web2py ad

[web2py] Web2py database design

2012-12-03 Thread David
Hi guys, I'm new to web2py, and got a question here. I want to design a database with sqlite for my app, but I prefer to design it on a visualiable tool e.g. GEA, which is recommended in web2py admin panel. But after some trials, I can't get the generated script work in web2py, especially for

[web2py] Database design

2012-04-17 Thread Chris Rowson
I'm a new adopter of web2py and I'm trying to learn the framework by building a simple property site. I have two types of properties, new or old. New properties have a few core attributes, let's say name, price, location, bedrooms Old properties have the same core attributes with a few more adde

Re: [web2py] Database design challenge

2011-02-04 Thread w2padawan
I think the solution is use the third table "article_author" with both, author_id and article_id having an autocomplete widget. Then, add a button there to [create author if not exist][1]. I think all this can be performed in a [single form][2] kind regards. [1] http://www.web2pyslices.com/main/

[web2py] Database design challenge

2011-02-04 Thread Johann Spies
I would like to invite web2py users who enjoy such challenges to think with me about solving the following problem: Take two tables: db.define_table('article', Field("author_id", 'list:reference outeur'), Field("title")) db.define_table('author',