Save the chat results to the database about bottle HOT 3 CLOSED

def who_is_who():
    if request.get_cookie("visited"):
        in_code = request.get_cookie("visited")
        item_user = jwt.decode(in_code, key, algorithm)

        is_id = item_user["id"]
        is_name = item_user["name"]
        is_mail = item_user["mail"]
        return is_id, is_name, is_mail
    return HTTPError(401, "Sorry.. Access denied..!")

def broadcast(data):
    for client in [*clients]:
        try:
            client.send(data)
        except WebSocketError:
            clients.remove(client)

@chat.route("/websocket")
def my_chat():
    wsock = request.environ.get("wsgi.websocket")
    clients.append(wsock)

    while True:
        data = wsock.receive()
        if data is None:
            break
        broadcast(data)
        save_msg(data)

        print("msg..!", data)

@auth.route("/login")
def user_login():
    return template("auth/login.html")


def auth_mail(email):
    cur = con.cursor()
    sql = "SELECT id, name, mail, password FROM user_table WHERE mail=?"
    res = cur.execute(sql, (email,))
    row = res.fetchone() is None
    cur.close()
    return row


@auth.post("/login")
def auth_login():
    email = request.forms.get("mail")
    pswd = request.forms.get("password")

    if auth_mail(email) is False:
        cur = con.cursor()
        sql = "SELECT id, name, mail, password FROM user_table WHERE mail=?"
        res = cur.execute(sql, (email,))
        row = res.fetchone()
        row.keys()
        cur.close()
        if bcrypt.checkpw(pswd.encode(), row["password"]):
            payload = {
                "id": row["id"],
                "name": row["name"],
                "mail": row["mail"],
            }

            visited = jwt.encode(payload, key, algorithm)
            response.set_cookie(
                "visited",
                visited,
                path="/",
                httponly=True,
            )
            return redirect("/")
        return HTTPError(
            401, "Sorry.. The password doesn't match..!"
        )
    return HTTPError(401, "Sorry.. NO user..!")