dbms

Communication with databases.

The current release includes classes for PostgreSQL and Microsoft SQL Server.

Databases

PostgreSQL([host, port, username, password, ...])

A class for basic communication with PostgreSQL databases.

MSSQL([host, port, username, password, ...])

A class for basic communication with Microsoft SQL Server databases.

Database tools/utilities

make_database_address(host, port, username)

Generates a string representing a database address.

get_default_database_address(db_cls)

Retrieves the database address of a database class given its default parameters.

add_sql_query_condition(sql_query[, ...])

Adds a condition to a given SQL query statement.

mssql_to_postgresql(mssql, postgres[, ...])

Copies tables of a database from a Microsoft SQL server to a PostgreSQL server.

import_data(db_instance, data, schema_name, ...)

Imports data into the project database.

read_data(db_instance, schema_name, table_name)

Reads data from the project database.