def get_existing_webapp_user_with_bookings(): query = keep_only_webapp_users(User.query) query = query.filter(User.email.contains('93.has-booked-some')) user = query.first() return { "user": get_user_helper(user) }
def get_existing_webapp_hnmm_user(return_as_dict=False): query = keep_only_webapp_users(User.query) query = query.filter(User.email.contains('93.has-no-more-money')) user = query.first() if return_as_dict == False: return user return {"user": get_user_helper(user)}
def get_existing_webapp_validated_user_with_has_filled_cultural_survey(): query = keep_only_webapp_users(User.query) query = query.filter_by(needsToFillCulturalSurvey=False, resetPasswordToken=None) user = query.first() return {"user": get_user_helper(user)}
def get_existing_webapp_user_can_book_multidates(): query = keep_only_webapp_users(User.query) query = query.filter(User.email.contains('97.has-confirmed-activation')) user = query.first() return { "user": get_user_helper(user) }
def get_existing_webapp_user_has_no_more_money(): query = keep_only_webapp_users(User.query) query = query.filter(User.email.contains('has-no-more-money')) user = query.first() return { "user": get_user_helper(user) }
def get_existing_webapp_user_with_bookings(): query = keep_only_webapp_users(User.query) query = query.join(Booking) user = query.first() return { "user": get_user_helper(user) }
def get_existing_webapp_user_with_at_least_one_recommendation(): query = Recommendation.query.join(User) query = keep_only_webapp_users(query) query = query.reset_joinpoint().join(Offer) recommendation = query.first() return { "user": get_user_helper(recommendation.user), "recommendation": get_recommendation_helper(recommendation) }
def get_existing_webapp_user_with_no_date_read(): query = keep_only_webapp_users(User.query) query = query.filter_by( needsToFillCulturalSurvey=False, resetPasswordToken=None ) query = query.filter( ~User.recommendations.any( Recommendation.dateRead != None ) ) user = query.first() return { "user": get_user_helper(user), }
def get_existing_webapp_not_validated_user(): query = keep_only_webapp_users(User.query) query = query.filter(User.resetPasswordToken != None) user = query.first() return {"user": get_user_helper(user)}
def get_existing_webapp_user(): query = keep_only_webapp_users(User.query) user = query.first() return {"user": get_user_helper(user)}