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 escribió:
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 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 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 primary key includes the author id, and
the page primary key includes the book primary key (author
and book ids).
One of the advantages of the identifyng relationship model is
that I can known what book belongs page without need a join,
that can be useful when we have a deep relation tree.
Can you show an example of the table definitions that would allow
you to get the related data without a join?
Anthony
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py
<http://github.com/web2py/web2py> (Source code)
- https://code.google.com/p/web2py/issues/list
<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 [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
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 [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
Este mensaje le ha llegado mediante el servicio de correo electronico que
ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema
Nacional de Salud. La persona que envia este correo asume el compromiso de usar
el servicio a tales fines y cumplir con las regulaciones establecidas
Infomed: http://www.sld.cu/
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
