Struct IsolatedTestDb 

pub struct IsolatedTestDb { /* private fields */ }

A test database that exists for the lifetime of a single test.

The database is automatically created on construction. Cleanup happens when cleanup() is called or when the database is reused in subsequent test runs (orphaned databases are cleaned up automatically).

Implementations

impl IsolatedTestDb

pub fn pool(&self) -> &PgPool

Get the connection pool for this isolated database.

pub fn db_name(&self) -> &str

Get the database name.

pub async fn execute(&self, sql: &str) -> Result<()>

Run raw SQL to set up test data or schema.

pub async fn run_sql(&self, sql: &str) -> Result<()>

Run multi-statement SQL for setup.

This handles SQL with multiple statements separated by semicolons, including PL/pgSQL functions with dollar-quoted strings.

pub async fn cleanup(self) -> Result<()>

Cleanup the test database by dropping it.

Call this at the end of your test if you want immediate cleanup. Otherwise, orphaned databases will be cleaned up on subsequent test runs.

pub async fn migrate(&self, migrations_dir: &Path) -> Result<()>

Run migrations from a directory.

Loads all .sql files from the directory, sorts them alphabetically, and executes them in order. This is intended for test setup.

Example

let base = TestDatabase::embedded().await?;
let db = base.isolated("my_test").await?;
db.migrate(Path::new("migrations")).await?;