def get_existing_webapp_validated_user_with_has_filled_cultural_survey(): query = keep_only_webapp_users(User.query) query = query.filter_by(needsToFillCulturalSurvey=False, hasSeenTutorials=True).filter(~User.tokens.any()) query = query.join(Deposit) user = query.first() return {"user": get_beneficiary_helper(user)}
def get_webapp_user_with_not_validated_password() -> dict: query = keep_only_webapp_users(User.query) query = query.join(Token).filter(Token.type == TokenType.RESET_PASSWORD, Token.isUsed.is_(False)) user = query.first() return {"user": get_beneficiary_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_beneficiary_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, hasSeenTutorials=True) user = query.first() return {"user": get_beneficiary_helper(user)}
def get_webapp_user_with_not_validated_password(): query = keep_only_webapp_users(User.query) query = query.filter(User.resetPasswordToken != None) user = query.first() return {"user": get_beneficiary_helper(user)}
def get_existing_webapp_user_can_book_thing_offer(): query = keep_only_webapp_users(User.query) query = query.filter(User.email.contains("93.has-confirmed-activation")) user = query.first() return {"user": get_beneficiary_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_beneficiary_helper(user)}
def get_existing_webapp_user_reach_physical_limit(): query = keep_only_webapp_users(User.query) query = query.filter(User.email.contains("93.has-booked-some")) user = query.first() return {"user": get_beneficiary_helper(user)}
def get_existing_webapp_user_can_book_event_offer(): query = keep_only_webapp_users(User.query) query = query.filter(User.email.contains("93.has-booked-some")) user = query.first() return {"user": get_beneficiary_helper(user)}
def get_existing_webapp_not_validated_user(): query = keep_only_webapp_users(User.query) query = query.join(Token).filter(Token.type == TokenType.RESET_PASSWORD) user = query.first() return {"user": get_beneficiary_helper(user)}
def get_existing_webapp_user(): query = keep_only_webapp_users(User.query) user = query.first() return {"user": get_beneficiary_helper(user)}
def get_existing_webapp_validated_user(): query = keep_only_webapp_users(User.query) query = query.filter(User.resetPasswordToken == None) user = query.first() return {"user": get_beneficiary_helper(user)}