Struct DatabaseConn 

pub struct DatabaseConn {
    pub conn: Connection,
}

Core database connection wrapper

DatabaseConn provides a thin wrapper around SQLite connections, handling both file-based and in-memory databases with consistent configuration and error handling.

Fields

conn: Connection

Implementations

impl DatabaseConn

pub fn open(path: Option<&str>) -> Result<Self>

Open a database at the specified path

If the path is None, an in-memory database is created. The database is configured with optimal settings for monocle’s use case.

pub fn new(path: &Option<String>) -> Result<Self>

Create a new database connection (backward-compatible signature)

This method accepts &Option<String> for compatibility with existing code. Prefer using open() with Option<&str> for new code.

pub fn open_path(path: &str) -> Result<Self>

Open a database at the specified path (convenience method)

pub fn open_in_memory() -> Result<Self>

Create an in-memory database

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

Execute a SQL statement

pub fn execute_with_params<P: Params>( &self, sql: &str, params: P, ) -> Result<usize>

Execute a SQL statement with parameters

pub fn transaction(&self) -> Result<Transaction<'_>>

Begin an unchecked transaction

This is useful for batch operations where we want to commit multiple statements atomically.

pub fn table_exists(&self, table_name: &str) -> Result<bool>

Check if a table exists in the database

pub fn table_count(&self, table_name: &str) -> Result<u64>

Get the row count for a table