Hi
I am looking for a solution to make two separate tables(at sql defenition
level) query-able at orm level.
There is a give database which i have no right to change existing tables
and i just add two tables to it which one of my tables have a column
holding id value of a table in give db:
class Given(Base):
__tablename__ = "given_table"
gid = Column(Integer, primary_key=True)
col_1 = ...
col_2 = ...
...
class MyTable(Base):
__tablename__ = "my_table"
id = Column(Integer, primary_key=True)
given_id = Column(Integer)
...
I've managed to fill *'given_id'* column with proper *'gid'* based on some
conditions. but with or without '*given_id'* column, i am looking for a way
to have *'Given'* model joinable and query-able by sqlalchemy. i.e:
session.query(MyTable).filter(MyTable.given.col_1 =="value")
I'm not sure how could i use hybrid property or any other way for this
situation.
Please help me.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
