import mysql.connector
from database.koneksi import ambil_koneksi

conn = ambil_koneksi()
if conn:
    cursor = conn.cursor()
    cursor.execute("SHOW TABLES")
    tables = cursor.fetchall()
    print("TABLES:")
    for table in tables:
        print(f"- {table[0]}")
        cursor.execute(f"DESCRIBE {table[0]}")
        columns = cursor.fetchall()
        for col in columns:
            print(f"  * {col[0]} ({col[1]})")
    cursor.close()
    conn.close()
else:
    print("Failed to connect.")