import streamlit as st
import psycopg2

# Recupera le credenziali dal file secrets di Hugging Face Spaces
user = st.secrets["SUPABASE_USER"]
password = st.secrets["SUPABASE_PASSWORD"]
host = st.secrets["SUPABASE_HOST"]
port = st.secrets["SUPABASE_PORT"]
dbname = st.secrets["SUPABASE_DBNAME"]

# Funzione per connettersi al database
def get_connection():
    return psycopg2.connect(
        user=user,
        password=password,
        host=host,
        port=port,
        dbname=dbname
    )

# Funzione per verificare l'email e la password
def verify_user(email, password):
    conn = get_connection()
    cur = conn.cursor()
    query = "SELECT * FROM users WHERE email = %s AND password = %s"
    cur.execute(query, (email, password))
    user = cur.fetchone()
    cur.close()
    conn.close()
    return user

# Funzione di login
def login_page():
    st.markdown("<h1 style='text-align: center;'>Accedi a RacoGPT</h1>", unsafe_allow_html=True)
    email = st.text_input("Email", placeholder="Inserisci la tua email", key="login_email_unique")
    password = st.text_input("Password", type="password", placeholder="Inserisci la tua password", key="login_password_unique")

    if st.button("Accedi", key="login_button_unique"):
        user = verify_user(email, password)
        if user:
            st.session_state["is_logged_in"] = True
            st.rerun()  # Reindirizza alla chat
        else:
            st.error("Email o password non corretti.")