Hello everyone.
I am trying to get classes whose foreign key is "whatever" but I
always get all the entries in the database, instead of the ones that
match the criterion.
Let's say I have a couple of classes using declarative base in a
relationship N:1. I have that modeled like:
class OtherClass(declarativeBase):
__tablename__ = "other_classes"
_id = Column("id", Integer, primary_key=True)
id = sqlalchemy.orm.synonym('_id', descriptor=property(getId, setId))
class WhateverClass(declarativeBase):
__tablename__ = "whatever_classes"
_id = Column("id", Integer, primary_key=True)
_total = Column("total", Integer)
_otherClassId = Column("other_class_id", Integer,
ForeignKey("other_classes.id"))
_otherClass = relationship("Post", uselist=False)
id = sqlalchemy.orm.synonym('_id', descriptor=property(getId, setId))
total = sqlalchemy.orm.synonym('_total',
descriptor=property(getTotal, setTotal))
otherClassId = sqlalchemy.orm.synonym('_otherClassId',
descriptor=property(getOtherClassId, setOtherClassId))
otherClass = sqlalchemy.orm.synonym('_otherClass',
descriptor=property(getOtherClass setOtherClass))
If I try to do:
from myClasses import WhateverClass
session.query(WhateverClass.WhateverClass).filter(otherClassId <= 5).all()
I get a list with all the instances of WhateverClass that are stored
in the database, not only the ones who are linked to the OtherClass
with id <= 5
But if I do session.query(WhateverClass.WhateverClass).filter(total <=
100).all() I properly get instances of WhateverClass with a "total"
<=100.
Do I have to use a joined query or something like that?
Thank you in advance!
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
