Struct PostgresResource 

pub struct PostgresResource {
    pub database: String,
    pub host: String,
    pub port: u16,
    pub user: String,
    pub password: String,
    /* private fields */
}

PostgreSQL resource manager

Fields

database: String

Name of the isolated database

host: String

Host

port: u16

Port

user: String

User

password: String

Password

Implementations

impl PostgresResource

pub async fn connect_existing(admin_url: &str, database: &str) -> Result<Self>

Connect to an existing PostgreSQL database (for inspection, does not drop on cleanup)

pub async fn new(admin_url: &str, database: &str) -> Result<Self>

Create a new PostgreSQL resource with an isolated database

pub fn connection_string(&self) -> String

Get the connection string for the isolated database

pub fn pool(&self) -> &PgPool

Get the connection pool

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

Execute a SQL statement

pub async fn count(&self, query: &str) -> Result<i64>

Execute a count query and return the result

pub async fn query<T>(&self, query: &str) -> Result<Vec<T>>

where T: for<'r> FromRow<'r, PgRow> + Send + Unpin,

Execute a query and return typed results

pub async fn list_tables(&self) -> Result<Vec<String>>

List all tables in the database

pub async fn get_sample_data( &self, table: &str, limit: usize, ) -> Result<Vec<Vec<String>>>

Get sample data from a table (first N rows)

pub async fn get_column_names(&self, table: &str) -> Result<Vec<String>>

Get column names for a table

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

Clean up the database (can be called explicitly if needed)

Trait Implementations

impl Drop for PostgresResource

fn drop(&mut self)

Executes the destructor for this type.

fn pin_drop(self: Pin<&mut Self>)

🔬This is a nightly-only experimental API. (pin_ergonomics)

Execute the destructor for this type, but different to Drop::drop, it requires self to be pinned.