Struct r2d2_sqlite::SqliteConnectionManager

pub struct SqliteConnectionManager { /* fields omitted */ }

An r2d2::ManageConnection for rusqlite::Connections.

Implementations

impl SqliteConnectionManager

pub fn file<P: AsRef<Path>>(path: P) -> Self

Creates a new SqliteConnectionManager from file.

See rusqlite::Connection::open

pub fn memory() -> Self

Creates a new SqliteConnectionManager from memory.

pub fn with_flags(self, flags: OpenFlags) -> Self

Converts SqliteConnectionManager into one that sets OpenFlags upon connection creation.

See rustqlite::OpenFlags for a list of available flags.

pub fn with_init<F>(self, init: F) -> Self where
    F: Fn(&mut Connection) -> Result<(), Error> + Send + Sync + 'static, 

Converts SqliteConnectionManager into one that calls an initialization function upon connection creation. Could be used to set PRAGMAs, for example.

Example

Make a SqliteConnectionManager that sets the foreign_keys pragma to true for every connection.

let manager = SqliteConnectionManager::file("app.db")
    .with_init(|c| c.execute_batch("PRAGMA foreign_keys=1;"));

Trait Implementations

impl Debug for SqliteConnectionManager

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

Formats the value using the given formatter.

impl ManageConnection for SqliteConnectionManager

type Connection = Connection

The connection type this manager deals with.

type Error = Error

The error type returned by Connections.

fn connect(&self) -> Result<Connection, Error>

Attempts to create a new connection.

fn is_valid(&self, conn: &mut Connection) -> Result<(), Error>

Determines if the connection is still connected to the database.

fn has_broken(&self, _: &mut Connection) -> bool

Quickly determines if the connection is no longer usable.