SQL Server

Integration with Microsoft SQL Server using the Microsoft SQL Server Docker Image

Installation

pip install pytest-databases[mssql]

Usage Example

import pymssql
from pytest_databases.docker.mssql import MSSQLService

pytest_plugins = ["pytest_databases.docker.mssql"]

def test(mssql_service: MSSQLService) -> None:
    conn = pymssql.connect(
        host=mssql_service.host,
        port=str(mssql_service.port),
        database=mssql_service.database,
        user=mssql_service.user,
        password=mssql_service.password,
        timeout=2,
    )
    with conn.cursor() as cursor:
        cursor.execute("select 1 as is_available")
        resp = cursor.fetchone()
        assert resp is not None and resp[0] == 1

def test(mssql_connection: pymssql.Connection) -> None:
    with mssql_connection.cursor() as cursor:
        cursor.execute("CREATE view simple_table as SELECT 1 as the_value")
        cursor.execute("select * from simple_table")
        result = cursor.fetchall()
        assert result is not None and result[0][0] == 1
        cursor.execute("drop view simple_table")

Available Fixtures

• mssql_image: The Docker image to use for SQL Server.

• mssql_service: A fixture that provides a SQL Server service.

• mssql_connection: A fixture that provides a SQL Server connection.

Service API

pytest_databases.docker.mssql.xdist_mssql_isolation_level()

Return type:

Literal['database', 'server']

pytest_databases.docker.mssql.mssql_image()

Return type:

str

class pytest_databases.docker.mssql.MSSQLService(host, port, user, password, database)

Bases: ServiceContainer

user: str

password: str

database: str

property connection_string: str

__init__(host, port, user, password, database)

pytest_databases.docker.mssql.mssql_service(docker_service, xdist_mssql_isolation_level, mssql_image)

Return type:

Generator[MSSQLService, None, None]

pytest_databases.docker.mssql.mssql_connection(mssql_service)

Return type:

Generator[Connection, None, None]