This directory contains end-to-end tests for ArcadeDB using Python.

This project uses UV as the package manager.

# Install UV if not already installed
pip install uv

# Install dependencies
uv pip install -e .

pytest

Tests for PostgreSQL wire protocol compatibility using the Python asyncpg driver.

• #1630 - Bind message parsing with asyncpg
• #668 - asyncpg compatibility

cd e2e-python
pip install -e .

# All asyncpg tests
pytest tests/test_asyncpg.py -v

# Specific test
pytest tests/test_asyncpg.py::test_parameterized_select -v

# With logging
pytest tests/test_asyncpg.py -v --log-cli-level=DEBUG

1. Basic Connection - Verify asyncpg can connect to ArcadeDB
2. Simple Queries - SELECT queries without parameters
3. Type Creation - CREATE DOCUMENT TYPE and INSERT operations
4. Parameterized Queries (Issue #1630)
   • Single parameter SELECT
   • Multiple parameter SELECT
   • Parameterized INSERT
5. Transactions - Transaction commit and rollback support

Tests use testcontainers to automatically:

• Pull arcadedata/arcadedb:latest image
• Start container with PostgreSQL plugin enabled
• Create asyncpg_testdb database
• Wait for server readiness
• Clean up after tests