Struct PostgresClient 

pub struct PostgresClient<'a> { /* private fields */ }

A virtual client for a running postgres.

Contains credentials and enough information to connect to its parent instance.

Implementations

impl<'a> PostgresClient<'a>

pub fn psql(&self, database: &str) -> Command

Runs a psql command against the database.

Creates a command that runs psql -h (host) -p (port) -U (username) -d (database) with PGPASSWORD set.

pub fn load_sql<P: AsRef<Path>>( &self, database: &str, filename: P, ) -> Result<(), Error>

Runs the given SQL commands from an input file via psql.

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

Runs the given SQL command through psql.

pub fn create_database(&self, database: &str, owner: &str) -> Result<(), Error>

Creates a new database with the given owner.

This typically requires superuser credentials, see Postgres::as_superuser.

pub fn create_user(&self, username: &str, password: &str) -> Result<(), Error>

Creates a new user on the system that is allowed to login.

This typically requires superuser credentials, see Postgres::as_superuser.

pub fn instance(&self) -> &Postgres

Returns the Postgres instance associated with this client.

pub fn url(&self, database: &str) -> Url

Returns a libpq-style connection URL.

pub fn client_url(&self) -> &Url

Returns the client URL for this client.

Trait Implementations

impl<'a> Debug for PostgresClient<'a>

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.