def has_granted_vaccination_request(requester_id, requestee_id):
query = session.query(VaccinationStatusRequest).filter(
VaccinationStatusRequest.requester_id == requester_id,
VaccinationStatusRequest.requestee_id == requestee_id,
)
status = query.first()
return status is not None and status.has_granted
def get_vaccination_dates(country_id, vaccine_id, age_from, age_to):
# print("\n\n\n", country_id, "\n",vaccine_id, "\n", age_from, "\n", age_to)
query = (session.query(Vaccination).join(User).filter(
User.country_id == country_id if country_id is not None else True,
Vaccination.vaccine_id == vaccine_id
if vaccine_id is not None else True,
User.age >= age_from if age_from is not None else True,
User.age <= age_to if age_to is not None else True,
))
vaccinations = query.all()
vaccination_dates = [x.date for x in vaccinations]
return vaccination_dates
def get_all_country_list():
return session.query(Country).all()
def get_friend_request(request_id):
query = session.query(FriendRequest).filter(FriendRequest.id == request_id)
return query.first()
def get_friend_request_between(user_id, friend_id):
query = session.query(FriendRequest).filter(
FriendRequest.requester_id == user_id,
FriendRequest.requestee_id == friend_id)
return query.first()
def get_country_by_name(name):
query = session.query(Country).filter(Country.name.like("%" + name + "%"))
return query.first()
def get_user_by_name(name):
query = session.query(User).filter(User.name.like("%" + name + "%"))
return query.first()
def get_user_google_mobile_access_token(user_id):
query = session.query(User).filter(User.id == user_id)
user = query.one()
return user.google_mobile_access_token
def get_country_name(country_id):
if country_id is None:
return None
query = session.query(Country).filter(Country.id == country_id)
country = query.first()
return country.name
def get_user(user_id):
query = session.query(User).filter(User.id == user_id)
user = query.one_or_none()
return user
def get_friend_ids(user_id):
query = session.query(
Friendship.user_id2).filter(Friendship.user_id1 == user_id)
friends = query.all()
friend_ids = [x[0] for x in friends]
return friend_ids
def get_admin_from_user_safe(user_id):
query = session.query(Admin).filter(Admin.user_id == user_id)
return query.first()
def is_facebook_friend(user_id1, user_id2):
query = session.query(Friendship).filter(Friendship.user_id1 == user_id1,
Friendship.user_id2 == user_id2)
friendship = query.first()
return friendship is not None and friendship.is_facebook
def is_friend(user_id1, user_id2):
query = session.query(Friendship).filter(Friendship.user_id1 == user_id1,
Friendship.user_id2 == user_id2)
return query.first() is not None
def get_user_from_google_id(google_id):
query = session.query(User).filter(User.google_id == google_id)
user = query.one_or_none()
return user
def get_user_vaccinations(user_id):
query = session.query(Vaccination).filter(Vaccination.user_id == user_id)
vaccinations = query.all()
return vaccinations
def get_all_vaccines_list():
return session.query(Vaccine).all()
def get_vaccination(vaccination_id):
query = session.query(Vaccination).filter(Vaccination.id == vaccination_id)
return query.one()
def add_user_google_mobile_access_token(user_id, token):
query = session.query(User).filter(User.id == user_id)
user = query.one()
user.google_mobile_access_token = token
session.commit()
def get_vaccine(vaccine_id):
query = session.query(Vaccine).filter(Vaccine.id == vaccine_id)
return query.one_or_none()
def get_user_from_email(email):
query = session.query(User).filter(User.email == email)
user = query.one_or_none()
return user
def get_vaccination_link(vaccination_link_id):
query = session.query(VaccinationLink).filter(
VaccinationLink.id == vaccination_link_id)
return query.one_or_none()
def remove_user(user_id):
session.query(User).filter(User.id == user_id).delete()
def get_vaccination_link_from_link(link):
query = session.query(VaccinationLink).filter(VaccinationLink.link == link)
return query.first()
def get_friendship(user_id, friend_id):
query = session.query(Friendship).filter(Friendship.user_id1 == user_id,
Friendship.user_id2 == friend_id)
return query.first()
def get_vaccination_ids_from_link_id(link_id):
query = session.query(LinkVaccinationPair.vaccination_id).filter(
LinkVaccinationPair.link_id == link_id)
vaccination_ids = [x[0] for x in query.all()]
return vaccination_ids
def delete_friend_request(request_id):
session.query(FriendRequest).filter(
FriendRequest.id == request_id).delete()
session.commit()
def get_active_friend_requests_to_user(user_id):
query = session.query(FriendRequest).filter(
FriendRequest.requestee_id == user_id)
return query.all()
