[Sqlalchemy-tickets] Issue #3397: association proxy any() on o2m->non object scalar (zzzeek/sqlalch
Brought to you by:
zzzeek
|
From: Mike B. <iss...@bi...> - 2015-04-28 23:17:59
|
New issue 3397: association proxy any() on o2m->non object scalar https://bitbucket.org/zzzeek/sqlalchemy/issue/3397/association-proxy-any-on-o2m-non-object Mike Bayer: ``` #!python from sqlalchemy import * from sqlalchemy.orm import * from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.ext.associationproxy import association_proxy Base = declarative_base() class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) _all_emails = relationship('UserEmail') all_emails = association_proxy('_all_emails', 'email') class UserEmail(Base): __tablename__ = 'user_emails' id = Column(Integer, primary_key=True) user_id = Column(Integer, ForeignKey('users.id')) email = Column(String, nullable=False, index=True) s = Session() print s.query(User).filter(User.all_emails.any(UserEmail.email.like('foo'))) #print s.query(User).filter(User._all_emails.any(UserEmail.email == 'foo')) ``` ``` #! File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/ext/associationproxy.py", line 233, in _value_is_scalar mapper.get_property(self.value_attr).uselist File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/util/langhelpers.py", line 843, in __getattr__ return self._fallback_getattr(key) File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/util/langhelpers.py", line 821, in _fallback_getattr raise AttributeError(key) AttributeError: uselist ``` |