testDB / config.py
jaannawaz
Initial Supabase Gradio interface with secure configuration
1623af6
"""
Configuration file for Supabase connection
This file helps set up environment variables for both local development and Hugging Face deployment
"""
import os
# For Hugging Face deployment, set these as secrets in your Space settings
SUPABASE_CONFIG = {
'host': 'db.bnjblzcqaumctpehgoid.supabase.co',
'port': '5432',
'database': 'postgres',
'user': 'postgres',
# Password should be set as environment variable: DB_PASSWORD
}
HUGGINGFACE_CONFIG = {
'token': os.getenv('HF_TOKEN', 'your_hf_token_here')
}
def get_db_connection_string(password: str) -> str:
"""Generate database connection string"""
return f"postgresql://{SUPABASE_CONFIG['user']}:{password}@{SUPABASE_CONFIG['host']}:{SUPABASE_CONFIG['port']}/{SUPABASE_CONFIG['database']}"
def setup_environment_variables(db_password: str):
"""Setup environment variables for local development"""
os.environ['DB_HOST'] = SUPABASE_CONFIG['host']
os.environ['DB_PORT'] = SUPABASE_CONFIG['port']
os.environ['DB_NAME'] = SUPABASE_CONFIG['database']
os.environ['DB_USER'] = SUPABASE_CONFIG['user']
os.environ['DB_PASSWORD'] = db_password
os.environ['HF_TOKEN'] = os.getenv('HF_TOKEN', 'your_hf_token_here')
print("✅ Environment variables set successfully!")
print(f"Database URL: {get_db_connection_string('[HIDDEN]')}")