ace.database.connection

class ace.database.connection.ConnectionManager

Bases: object

__init__()

make_connection() → pyodbc.Connection | None

fetchone()

fetchall()

execute(sql_query, *params)

close()

Close the cursor and connection.

Idempotent and tolerant of partially-closed state:

• Calling close() more than once is safe.

• If the cursor was already closed elsewhere (e.g. a centralize helper or a with conn.cursor() as cur: block in a script), we still close the underlying connection so the SQL Server handle is released.

set_context()

class ace.database.connection.SqlServerConnection

Bases: ConnectionManager

make_connection()

__init__()

close()

Close the cursor and connection.

Idempotent and tolerant of partially-closed state:

• Calling close() more than once is safe.

• If the cursor was already closed elsewhere (e.g. a centralize helper or a with conn.cursor() as cur: block in a script), we still close the underlying connection so the SQL Server handle is released.

execute(sql_query, *params)

fetchall()

fetchone()

set_context()

class ace.database.connection.SqlServerConnectionADIntegrated

Bases: ConnectionManager

make_connection()

Creates a SQL Server connection using Active Directory Integrated authentication. This method uses Windows/Azure AD authentication instead of SQL Server authentication. Use tcp: prefix to force TCP/IP protocol (not Named Pipes)

__init__()

close()

Close the cursor and connection.

Idempotent and tolerant of partially-closed state:

• Calling close() more than once is safe.

• If the cursor was already closed elsewhere (e.g. a centralize helper or a with conn.cursor() as cur: block in a script), we still close the underlying connection so the SQL Server handle is released.

execute(sql_query, *params)

fetchall()

fetchone()

set_context()

ace.database.connection.get_connection_class()

Factory function to get the appropriate connection class based on DBMS_TYPE and DATABASE_AUTH_METHOD.

ace.database.connection.ace_connection

alias of SqlServerConnection