Struct Sqlite

pub struct Sqlite { /* private fields */ }

A connector interface for the SQLite database

Implementations

impl Sqlite

pub fn new(file_path: &str) -> Result<Sqlite>

pub fn attach_database(&mut self, db_name: &str) -> Result<()>

Trait Implementations

impl Queryable for Sqlite

fn execute<'a>(&'a self, q: Query<'a>) -> DBIO<'a, Option<Id>>

Executes the given query and returns the ID of the last inserted row.

fn query<'a>(&'a self, q: Query<'a>) -> DBIO<'a, ResultSet>

Executes the given query and returns the result set.

fn query_raw<'a>( &'a self, sql: &'a str, params: &'a [ParameterizedValue<'_>], ) -> DBIO<'a, ResultSet>

Executes a query given as SQL, interpolating the given parameters and returning a set of results.

fn execute_raw<'a>( &'a self, sql: &'a str, params: &'a [ParameterizedValue<'_>], ) -> DBIO<'a, u64>

Executes a query given as SQL, interpolating the given parameters and returning the number of affected rows.

fn raw_cmd<'a>(&'a self, cmd: &'a str) -> DBIO<'a, ()>

Runs a command in the database, for queries that can’t be run using prepared statements.

fn select<'a>(&'a self, q: Select<'a>) -> DBIO<'a, ResultSet>

fn insert<'a>(&'a self, q: Insert<'a>) -> DBIO<'a, Option<Id>>

For inserting data. Returns the ID of the last inserted row.

fn update<'a>(&'a self, q: Update<'a>) -> DBIO<'a, ()>

For updating data.

fn delete<'a>(&'a self, q: Delete<'a>) -> DBIO<'a, ()>

For deleting data.

impl TransactionCapable for Sqlite

fn start_transaction(&self) -> DBIO<'_, Transaction<'_>>

Starts a new transaction

impl TryFrom<&str> for Sqlite

type Error = Error

The type returned in the event of a conversion error.

fn try_from(path: &str) -> Result<Self>

Performs the conversion.