Hi. Couple of questions...
1. Does SQLA support "deep filtering", i.e. something like this:
query(Invoice).filter(Invoice.Customer.Country.name=='France')
This does not work as it is, but is there something along this lines (except
of going with query.filter(.query.filter(.query.filter(query.get()))))?
2.Can I use hybrid properties for filtering? I tried to do that, but that's
what I got:
class Person(Base):
first_name = Column(String(50))
last_name = Column(String(50))
def __init__(self, first, last):
self.first_name = first
self.last_name = last
@hybrid_property
def full_name(self):
print(self.first_name, self.last_name)
return self.first_name + " " + self.last_name
p = Person('John', 'Doe')
s.commit()
res = s.query(Person).filter(Person.full_name=='John Doe').all()
output:
Person.first_name Person.last_name
[]
Apparently, Person.full_name receives a class as an argument instead of an
instance. Is there other way?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
