Trait Queryable

pub trait Queryable
where
    Self: Sync,
{
    // Required methods
    fn execute<'a>(&'a self, q: Query<'a>) -> DBIO<'a, Option<Id>> ;
    fn query<'a>(&'a self, q: Query<'a>) -> DBIO<'a, ResultSet> ;
    fn query_raw<'a>(
        &'a self,
        sql: &'a str,
        params: &'a [ParameterizedValue<'a>],
    ) -> DBIO<'a, ResultSet> ;
    fn execute_raw<'a>(
        &'a self,
        sql: &'a str,
        params: &'a [ParameterizedValue<'a>],
    ) -> DBIO<'a, u64> ;
    fn raw_cmd<'a>(&'a self, cmd: &'a str) -> DBIO<'a, ()> ;

    // Provided methods
    fn select<'a>(&'a self, q: Select<'a>) -> DBIO<'a, ResultSet>  { ... }
    fn insert<'a>(&'a self, q: Insert<'a>) -> DBIO<'a, Option<Id>>  { ... }
    fn update<'a>(&'a self, q: Update<'a>) -> DBIO<'a, ()>  { ... }
    fn delete<'a>(&'a self, q: Delete<'a>) -> DBIO<'a, ()>  { ... }
}

Represents a connection or a transaction that can be queried.

Required Methods

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<'a>], ) -> 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<'a>], ) -> 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.

Provided Methods

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.

Implementors

impl Queryable for PooledConnection

impl Queryable for Quaint

impl Queryable for Mysql

impl Queryable for PostgreSql

impl Queryable for Sqlite

impl<'a> Queryable for Transaction<'a>