extras.mssql — Microsoft SQL Database Service

A YellowService for running MSSQL DB. Runs the official Microsoft SQL docker image, with integration with sqlalchemy.

Note

Requires the mssql extra. For more information, see our installation guide. Requires a valid mssql driver to be installed.

class extras.mssql.MSSQLService(docker_client: DockerClient, image: str = 'mcr.microsoft.com/mssql/server:latest', *, admin_password: str = 'Swordfish1!', product: str = 'Developer', accept_eula: str | None = None, container_create_kwargs: dict[str, Any] | None = None, **kwargs)[source]

A service that runs a Microsoft SQL database. Inherits from SingleContainerService and SQLService.

Parameters:

  • docker_client – The docker client to used to pull and create the Postgresql container.

  • image – The image name to create a container of.

  • admin_password – The password for the admin (sa) user.

  • product – The name of the MSSQL product to create.

  • accept_eula – Whether to accept the product EULA. If None, will only accept the EULA if the product is "Developer". See the image page for more information.

  • container_create_kwargs – Additional keyword arguments passed to docker.models.containers.ContainerCollection.create().

  • **kwargs – Additional keyword arguments passed to SQLService. Note that if no local driver specified (or is specified explicitly as pyodbc), and the local options are not specified, the local options will be automatically set to target an available local pyodbc driver, and to trust the server certificate.