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