Struct Connection 

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

A SQL connection wrapping a Citadel database.

Supports explicit transactions via BEGIN / COMMIT / ROLLBACK. Without BEGIN, each statement runs in auto-commit mode.

Caches parsed SQL statements in an LRU cache keyed by SQL string. Cache entries are invalidated when the schema changes (DDL operations).

Implementations

impl<'a> Connection<'a>

pub fn open(db: &'a Database) -> Result<Self>

Open a SQL connection to a database.

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

Execute a SQL statement. Returns the result.

pub fn execute_params( &mut self, sql: &str, params: &[Value], ) -> Result<ExecutionResult>

Execute a SQL statement with positional parameters ($1, $2, …).

pub fn query(&mut self, sql: &str) -> Result<QueryResult>

Execute a SQL query and return the result set.

pub fn query_params( &mut self, sql: &str, params: &[Value], ) -> Result<QueryResult>

Execute a SQL query with positional parameters ($1, $2, …).

pub fn tables(&self) -> Vec<&str>

List all table names.

pub fn in_transaction(&self) -> bool

Returns true if an explicit transaction is active (BEGIN was issued).

pub fn table_schema(&self, name: &str) -> Option<&TableSchema>

Get the schema for a named table.

pub fn refresh_schema(&mut self) -> Result<()>

Reload schemas from the database.