CubeLoop — a Pythonic, async-native agent harness core designed for high performance, readability, and production-grade persistence.
Python agent-frameworkagent-harnessagent-runtimeagentic-aiai-agentsai-frameworkanthropicharnessharness-engineeringharness-frameworklanggraphlanggraph-alternativellmmcpopenaipi-agentpi-agent-corepythonpython-agent
"""Database test fixtures (Postgres + MySQL E2E)."""
import os
import secrets
import aiomysql
import asyncpg
import pytest
import pytest_asyncio
@pytest.fixture(scope="session")
def pg_dsn() -> str:
"""Postgres DSN for tests. Override via CUBEPI_TEST_PG_DSN env."""
return os.environ.get(
"CUBELOOP_TEST_PG_DSN",
os.environ.get(
"CUBEPI_TEST_PG_DSN",
"postgresql://postgres:postgres@localhost:5432/postgres",
),
)
@pytest_asyncio.fixture(scope="session")
async def _pg_available(pg_dsn: str) -> bool:
"""Quick probe — connection refused → skip Postgres tests."""
try:
conn = await asyncpg.connect(pg_dsn, timeout=2.0)
await conn.close()
return True
except (asyncpg.PostgresError, OSError, ConnectionError):
return False
@pytest_asyncio.fixture
async def clean_db(pg_dsn: str, _pg_available: bool):
"""Create a fresh database for each test; drop after."""
if not _pg_available:
pytest.skip(
"Postgres not available for E2E tests; set CUBEPI_TEST_PG_DSN "
"to a working DSN to enable."
)
db_name = f"cubepi_test_{secrets.token_hex(6)}"
admin = await asyncpg.connect(pg_dsn)
try:
await admin.execute(f'CREATE DATABASE "{db_name}"')
finally:
await admin.close()
# DSN for the new DB
base = pg_dsn.rsplit("/", 1)[0]
test_dsn = f"{base}/{db_name}"
yield test_dsn
admin = await asyncpg.connect(pg_dsn)
try:
await admin.execute(
f"SELECT pg_terminate_backend(pid) FROM pg_stat_activity "
f"WHERE datname = '{db_name}'"
)
await admin.execute(f'DROP DATABASE IF EXISTS "{db_name}"')
finally:
await admin.close()
@pytest_asyncio.fixture
async def pg_v4_dsn(clean_db: str):
"""Fresh Postgres DB with the v4 cubepi schema fully built."""
from tests.checkpointer.test_postgres import _setup_schema as _setup_pg_schema
await _setup_pg_schema(clean_db)
yield clean_db
# ---------------------------------------------------------------------------
# MySQL fixtures
# ---------------------------------------------------------------------------
@pytest.fixture(scope="session")
def mysql_dsn() -> str:
"""MySQL DSN for tests. Override via CUBEPI_TEST_MYSQL_DSN env."""
return os.environ.get(
"CUBELOOP_TEST_MYSQL_DSN",
os.environ.get(
"CUBEPI_TEST_MYSQL_DSN",
"mysql://root:root@localhost:3306/mysql",
),
)
def _mysql_cfg(dsn: str) -> dict:
from cubeloop.checkpointer.mysql.checkpointer import _parse_dsn
return _parse_dsn(dsn)
@pytest_asyncio.fixture(scope="session")
async def _mysql_available(mysql_dsn: str) -> bool:
"""Quick probe — connection refused → skip MySQL tests."""
try:
conn = await aiomysql.connect(connect_timeout=2, **_mysql_cfg(mysql_dsn))
await conn.ensure_closed()
return True
except (aiomysql.Error, OSError, ConnectionError):
return False
@pytest_asyncio.fixture
async def clean_mysql_db(mysql_dsn: str, _mysql_available: bool):
"""Create a fresh database for each test; drop after."""
if not _mysql_available:
pytest.skip(
"MySQL not available for E2E tests; set CUBEPI_TEST_MYSQL_DSN "
"to a working DSN to enable."
)
db_name = f"cubepi_test_{secrets.token_hex(6)}"
admin_cfg = _mysql_cfg(mysql_dsn)
admin = await aiomysql.connect(autocommit=True, **admin_cfg)
try:
async with admin.cursor() as cur:
await cur.execute(f"CREATE DATABASE `{db_name}`")
finally:
await admin.ensure_closed()
base = mysql_dsn.rsplit("/", 1)[0]
test_dsn = f"{base}/{db_name}"
yield test_dsn
admin = await aiomysql.connect(autocommit=True, **admin_cfg)
try:
async with admin.cursor() as cur:
await cur.execute(f"DROP DATABASE IF EXISTS `{db_name}`")
finally:
await admin.ensure_closed()
@pytest_asyncio.fixture
async def mysql_v4_dsn(clean_mysql_db: str):
"""Fresh MySQL DB with the v4 cubepi schema fully built."""
from tests.checkpointer.test_mysql import _setup_schema as _setup_mysql_schema
await _setup_mysql_schema(clean_mysql_db)
yield clean_mysql_db