Struct libsql::Transaction

pub struct Transaction { /* private fields */ }

A transaction on some connection.

Implementations

impl Transaction

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

Consume this transaction and commit.

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

Consume this transaction and rollback.

Methods from Deref<Target = Connection>

pub async fn execute(&self, sql: &str, params: impl IntoParams) -> Result<u64>

Execute sql query provided some type that implements IntoParams returning on success the number of rows that were changed.

Example

conn.execute("INSERT INTO foo (id) VALUES (?1)", [42]).await.unwrap();
conn.execute("INSERT INTO foo (id, name) VALUES (?1, ?2)", params![42, "baz"]).await.unwrap();

For more info on how to pass params check IntoParams’s docs.

pub async fn execute_batch(&self, sql: &str) -> Result<()>

Execute a batch set of statements.

pub async fn query(&self, sql: &str, params: impl IntoParams) -> Result<Rows>

Execute sql query provided some type that implements IntoParams returning on success the Rows.

Example

conn.query("SELECT foo FROM bar WHERE id = ?1", [42]).await.unwrap();
conn.query("SELECT foo FROM bar WHERE id = ?1 AND name = ?2", params![42, "baz"]).await.unwrap();

For more info on how to pass params check IntoParams’s docs and on how to extract values out of the rows check the Rows docs.

pub async fn prepare(&self, sql: &str) -> Result<Statement>

Prepares a cached statement.

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

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

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

Begin a new transaction in the given TransactionBehavior.

pub fn is_autocommit(&self) -> bool

Check weather libsql is in autocommit or not.

pub fn changes(&self) -> u64

Check the amount of changes the last query created.

pub fn last_insert_rowid(&self) -> i64

Check the last inserted row id.

pub async fn reset(&self)

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.