Spaces:
Paused
Paused
File size: 1,807 Bytes
5111c4b |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
import asyncio
import asyncpg
import ssl
import logging
import sys
from datetime import datetime
# Configure logging to both file and console
log_filename = f"db_connection_{datetime.now().strftime('%Y%m%d_%H%M%S')}.log"
logging.basicConfig(
level=logging.DEBUG,
format='%(asctime)s - %(levelname)s - %(message)s',
handlers=[
logging.FileHandler(log_filename),
logging.StreamHandler(sys.stdout)
]
)
logger = logging.getLogger(__name__)
async def test_direct_connection():
logger.info("Starting database connection test")
ssl_context = ssl.create_default_context()
ssl_context.check_hostname = False
ssl_context.verify_mode = ssl.CERT_NONE
try:
logger.info("Creating SSL context and attempting database connection...")
conn = await asyncpg.connect(
user='postgres',
password='Lovyelias5584.',
host='juycnkjuzylnbruwaqmp.supabase.co',
port=5432,
database='postgres',
ssl=ssl_context,
timeout=60.0
)
logger.info("Successfully connected to database!")
version = await conn.fetchval('SELECT version()')
logger.info(f"Database version: {version}")
await conn.close()
logger.info("Connection closed successfully")
except Exception as e:
logger.error(f"Error connecting to database: {str(e)}", exc_info=True)
raise
finally:
logger.info("Test completed")
if __name__ == "__main__":
try:
logger.info("Starting connection test script")
asyncio.run(test_direct_connection())
except Exception as e:
logger.error("Fatal error in main", exc_info=True)
sys.exit(1) |