Struct WalletDb

pub struct WalletDb {
    pub conn: Mutex<Connection>,
    inverse_cache: Mutex<Vec<String>>,
}

Structure representing base wallet database operations.

Fields

conn: Mutex<Connection>

Connection to the SQLite database.

inverse_cache: Mutex<Vec<String>>

Inverse queries cache, in case we want to rollback executed queries, stored as raw SQL strings.

Implementations

impl WalletDb

pub fn new( path: Option<PathBuf>, password: Option<&str>, ) -> WalletDbResult<WalletPtr>

Create a new wallet database handler. If path is None, create it in memory.

pub fn exec_batch_sql(&self, query: &str) -> WalletDbResult<()>

This function executes a given SQL query that contains multiple SQL statements, that don’t contain any parameters.

pub fn exec_sql(&self, query: &str, params: &[&dyn ToSql]) -> WalletDbResult<()>

This function executes a given SQL query, but isn’t able to return anything. Therefore it’s best to use it for initializing a table or similar things.

pub fn create_prepared_statement( &self, query: &str, params: &[&dyn ToSql], ) -> WalletDbResult<String>

Generate a new statement for provided query and bind the provided params, returning the raw SQL query as a string.

fn generate_select_query( &self, table: &str, col_names: &[&str], params: &[(&str, &dyn ToSql)], ) -> String

Generate a SELECT query for provided table from selected column names and provided WHERE clauses. Named parameters are supported in the WHERE clauses, assuming they follow the normal formatting “:{column_name}”.

pub fn query_single( &self, table: &str, col_names: &[&str], params: &[(&str, &dyn ToSql)], ) -> WalletDbResult<Vec<Value>>

Query provided table from selected column names and provided WHERE clauses, for a single row.

pub fn query_multiple( &self, table: &str, col_names: &[&str], params: &[(&str, &dyn ToSql)], ) -> WalletDbResult<Vec<Vec<Value>>>

Query provided table from selected column names and provided WHERE clauses, for multiple rows.

pub fn query_custom( &self, query: &str, params: &[&dyn ToSql], ) -> WalletDbResult<Vec<Vec<Value>>>

Query provided table using provided query for multiple rows.

pub fn cache_inverse(&self, query: String) -> WalletDbResult<()>

Auxiliary function to store provided inverse query into our cache.

pub fn grab_inverse_cache_block(&self) -> WalletDbResult<String>

Auxiliary function to retrieve cached inverse queries into a single SQL execution block. The final query will contain the queries in reverse order, and cache is cleared afterwards.

pub fn clear_inverse_cache(&self) -> WalletDbResult<()>

Auxiliary function to clear inverse queries cache.