def chat_submit(request):
context = {}
if "login_user" in request.session:
context["login_user"] = request.session["login_user"]
context["username"] = request.session["login_user"].split("@")[0]
else:
return redirect("/")
if request.POST:
message = Message()
message.email = context["login_user"]
message.content = request.POST["content"]
message.sender = True
message.created_at = timestamp()
messageRepo = MessageRepo()
messageRepo.save(message)
return redirect("/account/viewerdash/chat/")
def fetch_messages(self, email):
query = "SELECT content, sender, created_at FROM messages WHERE user_email = %s ORDER BY created_at"
try:
with connection.cursor() as cursor:
cursor.execute(query, [email])
rows = cursor.fetchall()
if rows is None:
return None
else:
messages = list()
for row in rows:
message = Message()
message.email = email
message.content = row[0]
message.sender = row[1]
message.created_at = row[2]
messages.append(message)
return messages
except Exception as e:
traceback.print_exc()
return None
