Re: [web2py] Re: Identifyng Relationship

2016-07-11 Thread Carlos Cesar Caballero Díaz
Thanks Anthony, I will try with the database (mysql) and see what happen... Greetings. El 08/07/16 a las 10:47, Anthony escribió: On Friday, July 8, 2016 at 8:39:01 AM UTC-4, Carlos Cesar Caballero wrote: Thanks Anthony for your time and answers, I will use another tool for this proje

Re: [web2py] Re: Identifyng Relationship

2016-07-08 Thread Anthony
On Friday, July 8, 2016 at 8:39:01 AM UTC-4, Carlos Cesar Caballero wrote: > > Thanks Anthony for your time and answers, I will use another tool for this > project then, the DB already exist with the "Identifying Relationship" > structure and I can't change it. > That's an important detail that

Re: [web2py] Re: Identifyng Relationship

2016-07-08 Thread Carlos Cesar Caballero Díaz
Thanks Anthony for your time and answers, I will use another tool for this project then, the DB already exist with the "Identifying Relationship" structure and I can't change it. Greetings. El 06/07/16 a las 12:21, Anthony escribió: On Wednesday, July 6, 2016 at 8:39:57 AM UTC-4, Carlos Cesar

Re: [web2py] Re: Identifyng Relationship

2016-07-06 Thread Anthony
On Wednesday, July 6, 2016 at 8:39:57 AM UTC-4, Carlos Cesar Caballero wrote: > > Hi Anthony, that's exactly what I need, because (among other things) when > the parent key is part of the child primary key I can do something like > child.parent_id, and it works the same with a relationship of de

Re: [web2py] Re: Identifyng Relationship

2016-07-06 Thread Carlos Cesar Caballero Díaz
Hi Anthony, that's exactly what I need, because (among other things) when the parent key is part of the child primary key I can do something like child.parent_id, and it works the same with a relationship of depth n, for example in the relation author-book-page-sentence-word, I can ask what aut

Re: [web2py] Re: Identifyng Relationship

2016-07-05 Thread Anthony
On Tuesday, July 5, 2016 at 2:10:19 PM UTC-4, Carlos Cesar Caballero wrote: > > Hi Antony, tough day with me no? > > You not need a join to get the id of any of the related tables, but if you > need only the top-table data, you only need one join, not n (you can look > the diagrams) > Not sure I

Re: [web2py] Re: Identifyng Relationship

2016-07-05 Thread Carlos Cesar Caballero Díaz
Thanks Massimo, I really like your new functionality (in fact I just write to your original post), although my question is more about working with Identifyng Relationship and the DAL to avoid multiple joins and increase performance. Greetings. El 05/07/16 a las 14:36, Massimo Di Pierro escrib

Re: [web2py] Re: Identifyng Relationship

2016-07-05 Thread Massimo Di Pierro
You can do it with this https://groups.google.com/forum/#!topic/web2py/_xQUWYXZG54 but I leave it as an exercise how to do it. I will post an example later. On Tuesday, 5 July 2016 13:10:19 UTC-5, Carlos Cesar Caballero wrote: > > Hi Antony, tough day with me no? > > You not need a join to get th

Re: [web2py] Re: Identifyng Relationship

2016-07-05 Thread Carlos Cesar Caballero Díaz
Hi Antony, tough day with me no? You not need a join to get the id of any of the related tables, but if you need only the top-table data, you only need one join, not n (you can look the diagrams) Greetings. El 05/07/16 a las 11:33, Anthony escribió: On Tuesday, July 5, 2016 at 11:23:36 AM U

Re: [web2py] Re: Identifyng Relationship

2016-07-05 Thread Anthony
On Tuesday, July 5, 2016 at 11:23:36 AM UTC-4, Carlos Cesar Caballero wrote: > > Hi Marlysson, thanks for your answer, yes maybe I must be more concise. > > In a clasic identifyng relationship, lets say a relation author-book-page > (author has books and books has pages) In this case, the book pri

Re: [web2py] Re: Identifyng Relationship

2016-07-05 Thread Carlos Cesar Caballero Díaz
Hi Marlysson, thanks for your answer, yes maybe I must be more concise. In a clasic identifyng relationship, lets say a relation author-book-page (author has books and books has pages) In this case, the book primary key includes the author id, and the page primary key includes the book primary

[web2py] Re: Identifyng Relationship

2016-07-05 Thread Marlysson Silva
I don't understood your doubt. Are you talking about foreign key? There are models ( in examples in tutorials ) that use the keyword reserved "reference" to indicate relationship between tables. Em segunda-feira, 4 de julho de 2016 15:33:04 UTC-3, Carlos Cesar Caballero escreveu: > > Hi, all web