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)
    }
예제 #2
0
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)}
예제 #3
0
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)}
예제 #4
0
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)
    }
예제 #5
0
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)
  }
예제 #6
0
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)
    }
예제 #7
0
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)
    }
예제 #8
0
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)}
예제 #10
0
def get_existing_webapp_user():
    query = keep_only_webapp_users(User.query)
    user = query.first()

    return {"user": get_user_helper(user)}