Struct libsql::transaction::Transaction

pub struct Transaction { /* private fields */ }

Implementations

impl Transaction

pub fn drop_behavior(&self) -> DropBehavior

pub fn set_drop_behavior(&mut self, drop_behavior: DropBehavior)

pub fn commit(self) -> Result<()>

Commit the transaction.

pub fn rollback(self) -> Result<()>

Rollback the transaction.

Methods from Deref<Target = Connection>

pub fn handle(&self) -> *mut sqlite3

Get a raw handle to the underlying libSQL connection

pub fn disconnect(&self)

Disconnect from the database.

pub fn prepare<S: Into<String>>(&self, sql: S) -> Result<Statement>

Prepare the SQL statement.

pub fn query<S, P>(&self, sql: S, params: P) -> Result<Option<Rows>>where S: Into<String>, P: TryInto<Params>, P::Error: Into<Box<dyn Error + Send + Sync>>,

Convenience method to run a prepared statement query.

Example

conn.query("SELECT * FROM users WHERE name = ?1;", vec![libsql::Value::from(1)])

pub fn execute_batch<S>(&self, sql: S) -> Result<()>where S: Into<String>,

Convenience method to run multiple SQL statements (that cannot take any parameters).

Example

conn.execute_batch(
    "BEGIN;
    CREATE TABLE foo(x INTEGER);
    CREATE TABLE bar(y TEXT);
    COMMIT;",
)

Failure

Will return Err if sql cannot be converted to a C-compatible string or if the underlying SQLite call fails.

pub fn execute<S, P>(&self, sql: S, params: P) -> Result<u64>where S: Into<String>, P: TryInto<Params>, P::Error: Into<Box<dyn Error + Send + Sync>>,

Execute the SQL statement synchronously.

If you execute a SQL query statement (e.g. SELECT statement) that returns the number of rows changed.

This method blocks the thread until the SQL statement is executed.

pub fn execute_async<S, P>(&self, sql: S, params: P) -> RowsFuture where S: Into<String>, P: Into<Params>,

Execute the SQL statement synchronously.

This method never blocks the thread until, but instead returns a RowsFuture object immediately that can be used to deferredly execute the statement.

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

Begin a new transaction in DEFERRED mode, which is the default.

pub fn transaction_with_behavior( &self, tx_behavior: TransactionBehavior ) -> Result<Transaction>

Begin a new transaction in the given mode.

pub fn is_autocommit(&self) -> bool

pub fn changes(&self) -> u64

pub fn last_insert_rowid(&self) -> i64

Trait Implementations

impl Deref for Transaction

type Target = Connection

The resulting type after dereferencing.

fn deref(&self) -> &Connection

Dereferences the value.

impl Drop for Transaction

fn drop(&mut self)

Executes the destructor for this type.