python-tds

import os import pytds # --- Environment Variables (Replace with your actual values or secure fetching) --- SERVER = os.environ.get('SQL_SERVER', 'your_server.database.windows.net') DATABASE = os.environ.get('SQL_DATABASE', 'your_database') USER = os.environ.get('SQL_USER', 'your_username') PASSWORD = os.environ.get('SQL_PASSWORD', 'your_password') try: # Establish a connection using a context manager with pytds.connect(server=SERVER, database=DATABASE, user=USER, password=PASSWORD) as conn: print("Successfully connected to the database!") # Create a cursor object using a context manager with conn.cursor() as cursor: # Execute a simple query cursor.execute("SELECT 1 AS ConnectionTest") # Fetch the result result = cursor.fetchone() print(f"Query result: {result}") # Example: Fetch all results cursor.execute("SELECT 'Hello from Python-TDS' AS Message") all_results = cursor.fetchall() print(f"All results: {all_results}") except pytds.Error as e: print(f"Database error occurred: {e}") except Exception as e: print(f"An unexpected error occurred: {e}")