import MySQLdb
import logging
import os

def get_max_phase(app_id):
    try:
        #db_password = os.getenv("DB_PASSWORD")
        #if not db_password:
        #    raise EnvironmentError("DB_PASSWORD environment variable not set.")
        
        conn = MySQLdb.connect(
            host="localhost",
            user="openai_user",
            passwd="IOyg76H2l%252BewRX2xhsDJAo7qnfVDHtx9RB%253D%",
            #passwd=db_password,
            db="openai_prompts",
            charset="utf8mb4"
        )
        cursor = conn.cursor()
        cursor.execute("SELECT max_phase FROM app_settings WHERE app_id = %s", (app_id,))
        result = cursor.fetchone()
        return result[0] if result else 12  # Default fallback
    except Exception as e:
        logging.error(f"DB error when retrieving max_phase: {e}")
        return 12  # Safe fallback if DB query failes
