Hi Pavel,
You want: s.query(Person).with_polymorphic(Man).get(51)
Cheers,
Gulli
On Tue, Apr 15, 2014 at 12:59 PM, Pavel Aborilov <abori...@gmail.com> wrote:
> Hello!
> How can I cache query like this:
> session.query(Person).get(51)
>
> where 51 is id of Man
>
> I can't access attribute age of Man without SELECT.
>
> Models:
>
> class Person(Base):
> __tablename__ = 'person'
> id = Column(Integer, primary_key=True)
> name = Column(String(100), nullable=False)
> type = Column(String(50))
> __mapper_args__ = {
> 'polymorphic_identity': 'object',
> 'polymorphic_on': type
> }
>
> class Man(Person):
> __tablename__ = 'man'
> id = Column(Integer, ForeignKey('person.id'), primary_key=True)
> age = Column(String(100), nullable=False)
> __mapper_args__ = {'polymorphic_identity': 'man'}
>
> --
> 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 post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
