ace.database

ace.database.connection

class ace.database.connection.ConnectionManager

Bases: object

__init__()

make_connection() → pyodbc.Connection | None

fetchone()

fetchall()

execute(sql_query, *params)

close()

set_context()

class ace.database.connection.SqlServerConnection

Bases: ConnectionManager

make_connection()

__init__()

close()

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()

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

ace.database.query_builder

class ace.database.query_builder.Condition(column: str, value: str | int | None, operator: str = '=')

Bases: object

__init__(column: str, value: str | int | None, operator: str = '=')

class ace.database.query_builder.BaseQueryBuilder(table_name: str, columns: list | str = '*')

Bases: ABC

abstractmethod build_query(*args, **kwargs)

__init__(table_name: str, columns: list | str = '*')

class ace.database.query_builder.SelectQueryBuilder(table_name: str, columns: list | str = '*')

Bases: BaseQueryBuilder

build_query(order_by: str = None, limit: int = None, offset: int = None, conditions: list[Condition] = None)

__init__(table_name: str, columns: list | str = '*')

ace.database.utils

class ace.database.utils.DatabaseUtils

Bases: object

A utility class for database operations.

static get_database_connection()

Returns a database connection object.

class ace.database.utils.CodeUtils

Bases: object

A utility class for code-related operations.

static fetchone(table, columns: list[str], conditions: list[Condition], sql_query=None)

static fetchall(query, params=None)

Module contents