Struct ConfigAndPool 

pub struct ConfigAndPool {
    pub pool: MiddlewarePool,
    pub db_type: DatabaseType,
    pub translate_placeholders: bool,
}

Configuration plus connection pool for a database backend.

Construct with the backend-specific new_* helpers on ConfigAndPool (e.g., new_sqlite, new_postgres), then borrow connections as needed:

use sql_middleware::prelude::*;

let cap = ConfigAndPool::new_sqlite("file::memory:?cache=shared".into()).await?;
let mut conn = cap.get_connection().await?;
let rows = conn.query("SELECT 1").select().await?;
assert_eq!(rows.results.len(), 1);

Fields

pool: MiddlewarePool

The connection pool

db_type: DatabaseType

The database type

translate_placeholders: bool

Whether placeholder translation is enabled by default for this pool

Implementations

impl ConfigAndPool

pub async fn get_connection( &self, ) -> Result<MiddlewarePoolConnection, SqlMiddlewareDbError>

Get a pooled connection and attach pool-level defaults to it.

Errors

Bubbles up pool checkout errors for the active backend.

Examples

use sql_middleware::prelude::*;

let cap = ConfigAndPool::new_sqlite("file::memory:?cache=shared".into()).await?;
let mut conn = cap.get_connection().await?;
conn.execute_batch("CREATE TABLE t (id INTEGER)").await?;

impl ConfigAndPool

pub fn postgres_builder(pg_config: PgConfig) -> PostgresOptionsBuilder

pub async fn new_postgres( opts: PostgresOptions, ) -> Result<Self, SqlMiddlewareDbError>

Asynchronous initializer for ConfigAndPool with Postgres.

Errors

Returns SqlMiddlewareDbError::ConfigError if required config fields are missing or SqlMiddlewareDbError::ConnectionError if pool creation fails.

impl ConfigAndPool

pub fn sqlite_builder(db_path: String) -> SqliteOptionsBuilder

pub async fn new_sqlite( opts: SqliteOptions, ) -> Result<Self, SqlMiddlewareDbError>

Asynchronous initializer for ConfigAndPool with Sqlite using a bb8-backed pool.

Errors

Returns SqlMiddlewareDbError::ConnectionError if pool creation or connection test fails.

Trait Implementations

impl Clone for ConfigAndPool

fn clone(&self) -> ConfigAndPool

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for ConfigAndPool

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

Formats the value using the given formatter.