Struct sqlite::Connection

pub struct Connection { /* private fields */ }

A connection.

Implementations

impl Connection

pub fn open<T: AsRef<Path>>(path: T) -> Result<Connection>

Open a read-write connection to a new or existing database.

pub fn open_with_flags<T: AsRef<Path>>( path: T, flags: OpenFlags, ) -> Result<Connection>

Open a connection with specific flags.

pub fn open_thread_safe<T: AsRef<Path>>(path: T) -> Result<ConnectionThreadSafe>

Open a thread-safe read-write connection to a new or existing database.

pub fn open_thread_safe_with_flags<T: AsRef<Path>>( path: T, flags: OpenFlags, ) -> Result<ConnectionThreadSafe>

Open a thread-safe connection with specific flags.

pub fn execute<T: AsRef<str>>(&self, statement: T) -> Result<()>

Execute a statement without processing the resulting rows if any.

pub fn iterate<T: AsRef<str>, F>(&self, statement: T, callback: F) -> Result<()>

where F: FnMut(&[(&str, Option<&str>)]) -> bool,

Execute a statement and process the resulting rows as plain text.

The callback is triggered for each row. If the callback returns false, no more rows will be processed. For large queries and non-string data types, prepared statement are highly preferable; see prepare.

pub fn prepare<T: AsRef<str>>(&self, statement: T) -> Result<Statement<'_>>

Create a prepared statement.

pub fn set_busy_handler<F>(&mut self, callback: F) -> Result<()>

where F: FnMut(usize) -> bool + Send + 'static,

Set a callback for handling busy events.

The callback is triggered when the database cannot perform an operation due to processing of some other request. If the callback returns true, the operation will be repeated.

pub fn set_busy_timeout(&mut self, milliseconds: usize) -> Result<()>

Set an implicit callback for handling busy events that tries to repeat rejected operations until a timeout expires.

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

Remove the callback handling busy events.

pub fn change_count(&self) -> usize

Return the number of rows inserted, updated, or deleted by the most recent INSERT, UPDATE, or DELETE statement.

pub fn total_change_count(&self) -> usize

Return the total number of rows inserted, updated, and deleted by all INSERT, UPDATE, and DELETE statements since the connection was opened.

Trait Implementations

impl Drop for Connection

fn drop(&mut self)

Executes the destructor for this type.