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()
