Hello all!
Ok, maybe people asks this a lot, but I wonder if it's possible to
perform a query using an object as a filter - and I searched for it,
didn't found anything close to my idea.
Simple dumb example code:
*class User(Base):**
**
** user_id = Column(Integer, Sequence(...), primary_key=True)**
** username = Column(Unicode)**
**
**
**class Subscription(Base):**
**
** subscription_id = Column(Integer, Sequence(...), primary_key=True)**
** name = Column(unicode)**
** owner_id = Column(Integer, ForeignKey('user.user_id'),
nullable=False)**
**
** @hybrid_property**
** def owner(self):**
if not object_session(self):
return None
** return object_session(self).query(User).filter(self.owner_id
== User.user_id)**.first()
**
** @owner.setter**
** def owner(self, owner):**
** self.owner_id = owner.user_id if isinstance(owner, User) else
owner**
** if object_session(self):**
** object_session(self).commit()**
**
** # @owner.expression** # ???**
**
**
**# ok, so far *almost* good**
**
**new_user = User()**
**new_user.username = u'the user'**
**
**session.add(new_user)**
**session.commit()**
**
**subscription = Subscription()**
**subscription.name = u'the subscription'**
**subscription.owner_id = new_user.user_id**
**
**session.add(subscription)**
**session.commit()**
**
**# then, it is normal to query for "subscriptions" owned by new_user
like this**
**
**print session.query(Subscription).filter(Subscription.owner_id ==
new_user.user_id).all()**
**
**# but, i would like to do _this_ instead**
**
**print session.query(Subscription).filter(Subscription.owner ==
new_user).all()*
I've tried it in so many ways that I feel dizzy. The only way I think
would be using @owner.expression to "return User", but that didn't the
trick, it only appends "WHERE false" to the query, hehehe.
Any light on my way? :)
Best regards,
Richard.
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
