Module postgres 

A throwaway Postgres for the lifetime of one command.

Replaces the sqlx-cli shell-out: the database is created and migrated in-process through sqlx, using the same migrations/ directory the server embeds via server::db::MIGRATOR. One set of migrations, one migrator, no second implementation that can drift.

initdb and pg_ctl remain external programs because they are external programs; there is no library form of them.

Structs

Postgres

A running cluster that stops itself when dropped.

Constants

DURABILITY_OFF 🔒

Durability is off on purpose. This cluster is initdb’d moments earlier and dies with the container, so there is nothing for it to protect — every fsync is pure cost, paid on cloud block storage, and 275 of the tests create and migrate a database of their own. Measured worth ~2m30s of a test run.

PORT_RANGE 🔒

Ports tried in order. No allocator to lean on, and pg_ctl -w exits non-zero when the server fails to come up, so a busy port is self-correcting.

TIMEOUTS 🔒

Bounds on how long the server will let a client misbehave.

Statics

MIGRATOR 🔒

The project’s migrations, embedded at compile time from the same directory server::db::MIGRATOR reads. Embedding needs no database, which is what lets this binary be built before the server it goes on to test.

Functions

create_and_migrate 🔒

run 🔒

start

initdb, start, create the database, migrate it.

start_on_free_port 🔒