test-db-builder-python 1.0.1

Target Audience

TDBP is designed for:

• Software developers writing database integration tests

• QA engineers automating database tests

• Database developers testing stored procedures and functions

• Anyone needing to create temporary test database objects and data

Quick Start

We recommend to make the object factory a fixture in your integration test and purge the database before each test. This ensures test isolation.

The object factory needs a database connection. In case of the Exasol dialect, the pytest-exasol-backend (https://github.com/exasol/pytest-backend) makes creating an Exasol backend and getting a connection very convenient.

@pytest.fixture
def factory(connection):
    factory = ExasolObjectFactory(connection)
    factory.purge_user_objects()  # Clean slate for each test
    return factory

With that done, the test preparation gets very compact.

def test_insert_customers(factory):
    # Prepare the test database
    schema = factory.create_schema("SALES")
    table = schema.create_table("CUSTOMERS",
        ID="DECIMAL(12,0)", NAME="VARCHAR(255)")
    table.insert(1, "Alice").insert(2, "Bob")

    # Execute your test
    # ...

    # Assert the results
    # ...

Information for Users

• 📖 User Guide: Detailed instructions on using TDBP including examples and best practices