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