check.py

# import os
# import mysql.connector
# from dotenv import load_dotenv

# # Load environment variables
# load_dotenv()  # you can also do load_dotenv(dotenv_path="/full/path/to/.env")

# DB_HOST = os.getenv("DB_HOST")
# DB_PORT = os.getenv("DB_PORT")
# DB_USER = os.getenv("DB_USER")
# DB_PASSWORD = os.getenv("DB_PASSWORD")
# DB_NAME = os.getenv("DB_NAME")

# print("🔍 Loaded environment variables:")
# print(f"DB_HOST={DB_HOST}")
# print(f"DB_PORT={DB_PORT}")
# print(f"DB_USER={DB_USER}")
# print(f"DB_PASSWORD={DB_PASSWORD}")
# print(f"DB_NAME={DB_NAME}")

# try:
#     connection = mysql.connector.connect(
#         host=DB_HOST,
#         port=DB_PORT,
#         user=DB_USER,
#         password=DB_PASSWORD
#     )

#     if connection.is_connected():
#         print(f"✅ Connected to MySQL at {DB_HOST}:{DB_PORT}")

#         cursor = connection.cursor()
#         cursor.execute("SHOW DATABASES")

#         print("\n📂 Databases:")
#         for db in cursor.fetchall():
#             print(f"- {db[0]}")

# except mysql.connector.Error as err:
#     print(f"❌ Error: {err}")

# finally:
#     if 'connection' in locals() and connection.is_connected():
#         cursor.close()
#         connection.close()
#         print("\n🔌 MySQL connection closed.")


from dotenv import load_dotenv
import os

load_dotenv()  # this reads .env file
print("Database URL:", os.getenv("DATABASE_URL"))