class CrateDBContainer(image: str = 'crate/crate:latest', port: int = 4200, username: str | None = None, password: str | None = None, dialect: str = 'crate', cmd_opts: list[tuple[str, str]] | None = None, **kwargs)

CrateDB database container.

Example

The example spins up a CrateDB database and connects to it using SQLAlchemy and the sqlalchemy-cratedb dialect, which talks to CrateDB over its HTTP interface (port 4200).

>>> from testcontainers.community.cratedb import CrateDBContainer
>>> import sqlalchemy

>>> with CrateDBContainer("crate:5.10") as cratedb:
...     engine = sqlalchemy.create_engine(cratedb.get_connection_url())
...     with engine.begin() as connection:
...         result = connection.execute(sqlalchemy.text("select name from sys.cluster"))
...         cluster_name, = result.fetchone()