def process_send_request_notifications(payload):
"""
Sends out email notifications for unseen messages in host requests (as surfer or host)
"""
logger.info(f"Sending out email notifications for unseen messages in host requests")
with session_scope() as session:
# requests where this user is surfing
surfing_reqs = session.execute(
select(User, HostRequest, func.max(Message.id))
.where(User.is_visible)
.join(HostRequest, HostRequest.surfer_user_id == User.id)
.join(Message, Message.conversation_id == HostRequest.conversation_id)
.where(Message.id > HostRequest.surfer_last_seen_message_id)
.where(Message.id > User.last_notified_request_message_id)
.where(Message.time < now() - timedelta(minutes=5))
.where(Message.message_type == MessageType.text)
.group_by(User, HostRequest)
).all()
# where this user is hosting
hosting_reqs = session.execute(
select(User, HostRequest, func.max(Message.id))
.where(User.is_visible)
.join(HostRequest, HostRequest.host_user_id == User.id)
.join(Message, Message.conversation_id == HostRequest.conversation_id)
.where(Message.id > HostRequest.host_last_seen_message_id)
.where(Message.id > User.last_notified_request_message_id)
.where(Message.time < now() - timedelta(minutes=5))
.where(Message.message_type == MessageType.text)
.group_by(User, HostRequest)
).all()
for user, host_request, max_message_id in surfing_reqs:
user.last_notified_request_message_id = max(user.last_notified_request_message_id, max_message_id)
session.commit()
email.enqueue_email_from_template(
user.email,
"unseen_message_guest",
template_args={
"user": user,
"host_request": host_request,
"host_request_link": urls.host_request_link_guest(),
},
)
for user, host_request, max_message_id in hosting_reqs:
user.last_notified_request_message_id = max(user.last_notified_request_message_id, max_message_id)
session.commit()
email.enqueue_email_from_template(
user.email,
"unseen_message_host",
template_args={
"user": user,
"host_request": host_request,
"host_request_link": urls.host_request_link_host(),
},
)
def send_host_request_cancelled_email_to_host(host_request):
logger.info(
f"Sending host request cancelled email to host: {host_request.host=}:")
logger.info(
f"Email for {host_request.host.username=} sent to {host_request.host.email=}"
)
email.enqueue_email_from_template(
host_request.host.email,
"host_request_cancelled_host",
template_args={
"host_request": host_request,
"host_request_link": urls.host_request_link_host(),
},
)
def send_new_host_request_email(host_request):
logger.info(f"Sending host request email to {host_request.host=}:")
logger.info(f"Host request sent by {host_request.surfer}")
logger.info(
f"Email for {host_request.host.username=} sent to {host_request.host.email=}"
)
email.enqueue_email_from_template(
host_request.host.email,
"host_request",
template_args={
"host_request": host_request,
"host_request_link": urls.host_request_link_host(),
},
)
def CreateHostRequest(self, request, context):
with session_scope() as session:
if request.host_user_id == context.user_id:
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.CANT_REQUEST_SELF)
# just to check host exists and is visible
host = session.execute(
select(User).where_users_visible(context).where(
User.id == request.host_user_id)).scalar_one_or_none()
if not host:
context.abort(grpc.StatusCode.NOT_FOUND, errors.USER_NOT_FOUND)
from_date = parse_date(request.from_date)
to_date = parse_date(request.to_date)
if not from_date or not to_date:
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.INVALID_DATE)
today = today_in_timezone(host.timezone)
# request starts from the past
if from_date < today:
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.DATE_FROM_BEFORE_TODAY)
# from_date is not >= to_date
if from_date >= to_date:
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.DATE_FROM_AFTER_TO)
# No need to check today > to_date
if from_date - today > timedelta(days=365):
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.DATE_FROM_AFTER_ONE_YEAR)
if to_date - from_date > timedelta(days=365):
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.DATE_TO_AFTER_ONE_YEAR)
conversation = Conversation()
session.add(conversation)
session.flush()
session.add(
Message(
conversation_id=conversation.id,
author_id=context.user_id,
message_type=MessageType.chat_created,
))
message = Message(
conversation_id=conversation.id,
author_id=context.user_id,
text=request.text,
message_type=MessageType.text,
)
session.add(message)
session.flush()
host_request = HostRequest(
conversation_id=conversation.id,
surfer_user_id=context.user_id,
host_user_id=host.id,
from_date=from_date,
to_date=to_date,
status=HostRequestStatus.pending,
surfer_last_seen_message_id=message.id,
# TODO: tz
# timezone=host.timezone,
)
session.add(host_request)
session.commit()
send_new_host_request_email(host_request)
notify(
user_id=host_request.host_user_id,
topic="host_request",
action="create",
key=str(host_request.surfer_user_id),
avatar_key=host_request.surfer.avatar.thumbnail_url
if host_request.surfer.avatar else None,
title=
f"**{host_request.surfer.name}** sent you a hosting request",
content=request.text,
link=urls.host_request_link_host(),
)
return requests_pb2.CreateHostRequestRes(
host_request_id=host_request.conversation_id)
def SendHostRequestMessage(self, request, context):
if request.text == "":
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.INVALID_MESSAGE)
with session_scope() as session:
host_request = session.execute(
select(HostRequest).where(
HostRequest.conversation_id ==
request.host_request_id)).scalar_one_or_none()
if not host_request:
context.abort(grpc.StatusCode.NOT_FOUND,
errors.HOST_REQUEST_NOT_FOUND)
if host_request.surfer_user_id != context.user_id and host_request.host_user_id != context.user_id:
context.abort(grpc.StatusCode.NOT_FOUND,
errors.HOST_REQUEST_NOT_FOUND)
if host_request.status == HostRequestStatus.rejected or host_request.status == HostRequestStatus.cancelled:
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.HOST_REQUEST_CLOSED)
if host_request.end_time < now():
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.HOST_REQUEST_IN_PAST)
message = Message()
message.conversation_id = host_request.conversation_id
message.author_id = context.user_id
message.message_type = MessageType.text
message.text = request.text
session.add(message)
session.flush()
if host_request.surfer_user_id == context.user_id:
host_request.surfer_last_seen_message_id = message.id
notify(
user_id=host_request.host_user_id,
topic="host_request",
action="message",
key=str(host_request.surfer_user_id),
avatar_key=host_request.surfer.avatar.thumbnail_url
if host_request.surfer.avatar else None,
title=
f"**{host_request.surfer.name}** sent a message in their host request",
link=urls.host_request_link_host(),
)
else:
host_request.host_last_seen_message_id = message.id
notify(
user_id=host_request.surfer_user_id,
topic="host_request",
action="message",
key=str(host_request.host_user_id),
avatar_key=host_request.host.avatar.thumbnail_url
if host_request.host.avatar else None,
title=
f"**{host_request.host.name}** sent a message in your host request",
link=urls.host_request_link_guest(),
)
session.commit()
return empty_pb2.Empty()
def RespondHostRequest(self, request, context):
with session_scope() as session:
host_request = session.execute(
select(HostRequest).where_users_column_visible(
context,
HostRequest.surfer_user_id).where_users_column_visible(
context, HostRequest.host_user_id).where(
HostRequest.conversation_id ==
request.host_request_id)).scalar_one_or_none()
if not host_request:
context.abort(grpc.StatusCode.NOT_FOUND,
errors.HOST_REQUEST_NOT_FOUND)
if host_request.surfer_user_id != context.user_id and host_request.host_user_id != context.user_id:
context.abort(grpc.StatusCode.NOT_FOUND,
errors.HOST_REQUEST_NOT_FOUND)
if request.status == conversations_pb2.HOST_REQUEST_STATUS_PENDING:
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.INVALID_HOST_REQUEST_STATUS)
if host_request.end_time < now():
context.abort(grpc.StatusCode.INVALID_ARGUMENT,
errors.HOST_REQUEST_IN_PAST)
control_message = Message()
if request.status == conversations_pb2.HOST_REQUEST_STATUS_ACCEPTED:
# only host can accept
if context.user_id != host_request.host_user_id:
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.NOT_THE_HOST)
# can't accept a cancelled or confirmed request (only reject), or already accepted
if (host_request.status == HostRequestStatus.cancelled
or host_request.status == HostRequestStatus.confirmed
or host_request.status == HostRequestStatus.accepted):
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.INVALID_HOST_REQUEST_STATUS)
control_message.host_request_status_target = HostRequestStatus.accepted
host_request.status = HostRequestStatus.accepted
send_host_request_accepted_email_to_guest(host_request)
notify(
user_id=host_request.surfer_user_id,
topic="host_request",
action="accept",
key=str(host_request.host_user_id),
avatar_key=host_request.host.avatar.thumbnail_url
if host_request.host.avatar else None,
title=
f"**{host_request.host.name}** accepted your host request",
link=urls.host_request_link_guest(),
)
if request.status == conversations_pb2.HOST_REQUEST_STATUS_REJECTED:
# only host can reject
if context.user_id != host_request.host_user_id:
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.INVALID_HOST_REQUEST_STATUS)
# can't reject a cancelled or already rejected request
if (host_request.status == HostRequestStatus.cancelled
or host_request.status == HostRequestStatus.rejected):
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.INVALID_HOST_REQUEST_STATUS)
control_message.host_request_status_target = HostRequestStatus.rejected
host_request.status = HostRequestStatus.rejected
send_host_request_rejected_email_to_guest(host_request)
notify(
user_id=host_request.surfer_user_id,
topic="host_request",
action="reject",
key=str(host_request.host_user_id),
avatar_key=host_request.host.avatar.thumbnail_url
if host_request.host.avatar else None,
title=
f"**{host_request.host.name}** rejected your host request",
link=urls.host_request_link_guest(),
)
if request.status == conversations_pb2.HOST_REQUEST_STATUS_CONFIRMED:
# only hostee can confirm
if context.user_id != host_request.surfer_user_id:
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.INVALID_HOST_REQUEST_STATUS)
# can only confirm an accepted request
if host_request.status != HostRequestStatus.accepted:
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.INVALID_HOST_REQUEST_STATUS)
control_message.host_request_status_target = HostRequestStatus.confirmed
host_request.status = HostRequestStatus.confirmed
send_host_request_confirmed_email_to_host(host_request)
notify(
user_id=host_request.host_user_id,
topic="host_request",
action="confirm",
key=str(host_request.surfer_user_id),
avatar_key=host_request.surfer.avatar.thumbnail_url
if host_request.surfer.avatar else None,
title=
f"**{host_request.surfer.name}** confirmed their host request",
link=urls.host_request_link_host(),
)
if request.status == conversations_pb2.HOST_REQUEST_STATUS_CANCELLED:
# only hostee can cancel
if context.user_id != host_request.surfer_user_id:
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.INVALID_HOST_REQUEST_STATUS)
# can't' cancel an already cancelled or rejected request
if (host_request.status == HostRequestStatus.rejected
or host_request.status == HostRequestStatus.cancelled):
context.abort(grpc.StatusCode.PERMISSION_DENIED,
errors.INVALID_HOST_REQUEST_STATUS)
control_message.host_request_status_target = HostRequestStatus.cancelled
host_request.status = HostRequestStatus.cancelled
send_host_request_cancelled_email_to_host(host_request)
notify(
user_id=host_request.host_user_id,
topic="host_request",
action="cancel",
key=str(host_request.surfer_user_id),
avatar_key=host_request.surfer.avatar.thumbnail_url
if host_request.surfer.avatar else None,
title=
f"**{host_request.surfer.name}** cancelled their host request",
link=urls.host_request_link_host(),
)
control_message.message_type = MessageType.host_request_status_changed
control_message.conversation_id = host_request.conversation_id
control_message.author_id = context.user_id
session.add(control_message)
if request.text:
latest_message = Message()
latest_message.conversation_id = host_request.conversation_id
latest_message.text = request.text
latest_message.author_id = context.user_id
latest_message.message_type = MessageType.text
session.add(latest_message)
else:
latest_message = control_message
session.flush()
if host_request.surfer_user_id == context.user_id:
host_request.surfer_last_seen_message_id = latest_message.id
else:
host_request.host_last_seen_message_id = latest_message.id
session.commit()
return empty_pb2.Empty()