add_secrets.py

#!/usr/bin/env python3
"""
Add database credentials as secrets to Hugging Face Space
"""

from huggingface_hub import HfApi
import os

# Initialize HF API
api = HfApi()

# Database credentials from Supabase
secrets = {
    "DB_HOST": "fwwnrulrrlgtfzbfusno.supabase.co",
    "DB_NAME": "postgres", 
    "DB_USER": "postgres",
    "DB_PASSWORD": "SentimentDB2024!@#",
    "DB_PORT": "5432"
}

# Add secrets to the Space
try:
    api.add_space_secret(
        repo_id="wintersoldier91/Antisentiment",
        key="DB_HOST",
        value=secrets["DB_HOST"]
    )
    print("✅ Added DB_HOST secret")
    
    api.add_space_secret(
        repo_id="wintersoldier91/Antisentiment", 
        key="DB_NAME",
        value=secrets["DB_NAME"]
    )
    print("✅ Added DB_NAME secret")
    
    api.add_space_secret(
        repo_id="wintersoldier91/Antisentiment",
        key="DB_USER", 
        value=secrets["DB_USER"]
    )
    print("✅ Added DB_USER secret")
    
    api.add_space_secret(
        repo_id="wintersoldier91/Antisentiment",
        key="DB_PASSWORD",
        value=secrets["DB_PASSWORD"]
    )
    print("✅ Added DB_PASSWORD secret")
    
    api.add_space_secret(
        repo_id="wintersoldier91/Antisentiment",
        key="DB_PORT",
        value=secrets["DB_PORT"]
    )
    print("✅ Added DB_PORT secret")
    
    print("\n🎉 All database secrets added successfully!")
    print("Your Hugging Face Space now has access to the Supabase database.")
    
except Exception as e:
    print(f"❌ Error adding secrets: {e}")
    print("Please check your token permissions and try again.")