Struct TestPgBuilder 

pub struct TestPgBuilder<S>
where
    S: MigrationSource<'static> + Send + Sync + 'static,
{ /* private fields */ }

Builder for creating a TestPg instance with custom configuration.

Implementations

impl<S> TestPgBuilder<S>

where S: MigrationSource<'static> + Send + Sync + 'static,

pub fn new(database_url: String, migrations: S) -> Self

Create a new TestPgBuilder with the given database URL and migrations.

pub fn with_extensions(self, extensions: Vec<String>) -> Self

Add a list of PostgreSQL extensions to be installed before running migrations.

Example

use sqlx_db_tester::TestPgBuilder;
use std::path::Path;

let tdb = TestPgBuilder::new(
    "postgres://postgres:postgres@localhost:5432".to_string(),
    Path::new("./fixtures/migrations")
)
.with_extensions(vec!["uuid-ossp".to_string(), "postgis".to_string()])
.build();

pub fn with_seeds<P: AsRef<Path>>(self, seeds_path: P) -> Self

Add a path to a directory containing seed SQL files.

Seed files should be named with the pattern <timestamp>_<description>.sql (e.g., 20240101120000_initial_data.sql). They will be executed in timestamp order after migrations are complete.

Example

use sqlx_db_tester::TestPgBuilder;
use std::path::Path;

let tdb = TestPgBuilder::new(
    "postgres://postgres:postgres@localhost:5432".to_string(),
    Path::new("./fixtures/migrations")
)
.with_seeds(Path::new("./fixtures/seeds"))
.build();

pub fn build(self) -> TestPg

Build and initialize the test database with the configured settings.