'Get all user tuples that are in the users_who_share_rooms due to the
given room_id.
Returns:
[(user_id, other_user_id)]: where one of the two will match the given
user_id.'

def get_users_in_share_dir_with_room_id(self, user_id, room_id):

    sql = '\n                                                SELECT    user_id,    other_user_id    FROM    users_who_share_rooms\n                                                WHERE    room_id    =    ?    AND    (user_id    =    ?    OR    other_user_id    =    ?)\n                                '
    return self._execute('get_users_in_share_dir_with_room_id', None, sql, room_id, user_id, user_id)
