Hi everyone, 

here again to look for some advice and wise suggestions. 

I am facing a situation that I thought I have already covered, but during 
the testing phase (with real data) was not the case. So I have the 
relationship between entities that you can see in the diagram below. I have 
started using the next hierarchy:

Base ->Page->(Tag and Product)-> (TravelPass and Travel) -> (Event, 
Privatebooking)

In each one of this extends I have used the 'polymorphic_on' to work with a 
Joined Inheritance format. So reading more carefully the docs I realized 
that this is not possible and in deed I had problems when querying the 
TravelPass entity getting the results of
the Travel entity. So right now I am looking for alternatives to implement 
this but I am a bit lost. I think the single table format will not solve 
it. I am thinking about using regular relationships for making it works, 
but so far no great
ideas come to my mind. I would like to ask for your advice in this topic. 
Thanks in advance. 


[image: Screenshot 2019-08-22 at 15.16.39.png] <about:invalid#zClosurez>

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/6f4e8932-0497-4289-a544-7d6e277e9085%40googlegroups.com.

Reply via email to