pyodbc

import pyodbc import os # NOTE: This example requires an ODBC driver and DSN to be configured on your system. # For Windows, common drivers like 'SQL Server' might be available. # For Linux/macOS, you might need to install unixODBC and specific database drivers. # Example DSN-less connection string (replace with your actual details): DB_DRIVER = os.environ.get('PYODBC_DRIVER', '{ODBC Driver 17 for SQL Server}') DB_SERVER = os.environ.get('PYODBC_SERVER', 'your_server.database.windows.net') DB_DATABASE = os.environ.get('PYODBC_DATABASE', 'your_database_name') DB_UID = os.environ.get('PYODBC_UID', 'your_username') DB_PWD = os.environ.get('PYODBC_PWD', 'your_password') connection_string = ( f"DRIVER={DB_DRIVER};" f"SERVER={DB_SERVER};" f"DATABASE={DB_DATABASE};" f"UID={DB_UID};" f"PWD={DB_PWD};" ) try: cnxn = pyodbc.connect(connection_string) cursor = cnxn.cursor() # Example: Create a table (if it doesn't exist) try: cursor.execute("CREATE TABLE #TestTable (id INT, name VARCHAR(50))") print("Table #TestTable created.") except pyodbc.ProgrammingError as e: if 'There is already an object named' in str(e): # For SQL Server temp table print("Table #TestTable already exists, skipping creation.") else: raise # Example: Insert data cursor.execute("INSERT INTO #TestTable (id, name) VALUES (?, ?)", 1, 'Alice') cursor.execute("INSERT INTO #TestTable (id, name) VALUES (?, ?)", 2, 'Bob') cnxn.commit() # Commit changes if autocommit is not enabled print("Data inserted.") # Example: Select data cursor.execute("SELECT id, name FROM #TestTable") rows = cursor.fetchall() print("\nFetched Data:") for row in rows: print(f"ID: {row.id}, Name: {row.name}") except pyodbc.Error as ex: sqlstate = ex.args[0] print(f"Database Error (SQLSTATE: {sqlstate}): {ex}") finally: if 'cnxn' in locals() and cnxn: cnxn.close() print("\nConnection closed.")