Module zut.db

Common operations on databases.

Functions

get_db_adapter(origin, *[, autocommit])

Create a new adapter (if origin is not already one).

get_db_adapter_from_url(url, *[, autocommit])

get_db_adapter_from_connection(connection)

Classes

DbAdapter(origin, *[, password_required, ...])

Base class for database adapters.

DbResult(db, cursor, *, rows, columns, ...)

DbDumper(dst, *[, table, ...])

Line-per-line INSERT commands (to be used when InsertSqlDumper is not available).

PostgreSqlAdapter(origin, *[, ...])

Database adapter for PostgreSQL (using psycopg (v3) driver).

PostgreSqlOldAdapter(origin, *[, ...])

Database adapter for PostgreSQL (using psycopg2 driver).

MariaDbAdapter(origin, *[, ...])

Database adapter for Microsoft SQL Server (using pyodbc driver).

SqliteAdapter(db, *[, password_required, ...])

Database adapter for SQLite 3 (using driver included in python3).

SqlServerAdapter(origin, *[, ...])

Database adapter for Microsoft SQL Server (using pyodbc driver).