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_event_offer_with_active_mediation_already_booked_but_cancellable_and_user_hnmm_93( ): offer_with_stock_id_tuples = (Offer.query.filter( Offer.mediations.any(Mediation.isActive)).join(Stock).filter( Stock.beginningDatetime != None).add_columns(Stock.id).all()) user = get_existing_webapp_hnmm_user() bookings = get_cancellable_bookings_for_user(user) offer = find_offer_compatible_with_bookings(offer_with_stock_id_tuples, bookings) for mediation in offer.mediations: if mediation.isActive: return { "mediation": get_mediation_helper(mediation), "offer": get_offer_helper(offer), "user": get_beneficiary_helper(user), } return None
def get_existing_digital_offer_with_active_mediation_already_booked_and_user_hnmm_93( ): offer_with_stock_id_tuples = (Offer.query.outerjoin(Product).filter( Offer.mediations.any( Mediation.isActive)).filter(Product.url != None).join( Stock, (Offer.id == Stock.offerId)).add_columns(Stock.id).all()) user = get_existing_webapp_hnmm_user() bookings = get_cancellable_bookings_for_user(user) offer = find_offer_compatible_with_bookings(offer_with_stock_id_tuples, bookings) for mediation in offer.mediations: if mediation.isActive: return { "mediation": get_mediation_helper(mediation), "offer": get_offer_helper(offer), "user": get_beneficiary_helper(user), } return None
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)}