def __userOwnersConditionQuery(self, owner_ids): cond_group = SearchGroup("or") map( lambda owner_id: cond_group.addGroup("users.owner_id=%s" % owner_id ), owner_ids) return "connection_log.user_id in (select user_id from users where %s)" % cond_group.getConditionalClause( )
def __userOwnersConditionQuery(self,owner_ids): """ Change to exists subquery, if performance is low. also possible to filter user_ids in case of user_id conditions to boost speed """ cond_group=SearchGroup("or") map(lambda owner_id:cond_group.addGroup("users.owner_id=%s"%owner_id),owner_ids) return "connection_log.user_id in (select user_id from users where %s)"%cond_group.getConditionalClause()