[][src]Trait sqlx::Executor

pub trait Executor<'c>: Send + Debug {
    type Database: Database;
    fn fetch_many<'e, 'q, E>(
        self,
        query: E
    ) -> Pin<Box<dyn Stream<Item = Result<Either<<Self::Database as Database>::Done, <Self::Database as Database>::Row>, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e,
        E: 'q + Execute<'q, Self::Database>
;
fn fetch_optional<'e, 'q, E>(
        self,
        query: E
    ) -> Pin<Box<dyn Future<Output = Result<Option<<Self::Database as Database>::Row>, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e,
        E: 'q + Execute<'q, Self::Database>
;
fn prepare_with<'e, 'q>(
        self,
        sql: &'q str,
        parameters: &'e [<Self::Database as Database>::TypeInfo]
    ) -> Pin<Box<dyn Future<Output = Result<<Self::Database as HasStatement<'q>>::Statement, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e
; fn execute<'e, 'q, E>(
        self,
        query: E
    ) -> Pin<Box<dyn Future<Output = Result<<Self::Database as Database>::Done, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e,
        E: 'q + Execute<'q, Self::Database>
, { ... }
fn execute_many<'e, 'q, E>(
        self,
        query: E
    ) -> Pin<Box<dyn Stream<Item = Result<<Self::Database as Database>::Done, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e,
        E: 'q + Execute<'q, Self::Database>
, { ... }
fn fetch<'e, 'q, E>(
        self,
        query: E
    ) -> Pin<Box<dyn Stream<Item = Result<<Self::Database as Database>::Row, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e,
        E: 'q + Execute<'q, Self::Database>
, { ... }
fn fetch_all<'e, 'q, E>(
        self,
        query: E
    ) -> Pin<Box<dyn Future<Output = Result<Vec<<Self::Database as Database>::Row>, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e,
        E: 'q + Execute<'q, Self::Database>
, { ... }
fn fetch_one<'e, 'q, E>(
        self,
        query: E
    ) -> Pin<Box<dyn Future<Output = Result<<Self::Database as Database>::Row, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e,
        E: 'q + Execute<'q, Self::Database>
, { ... }
fn prepare<'e, 'q>(
        self,
        query: &'q str
    ) -> Pin<Box<dyn Future<Output = Result<<Self::Database as HasStatement<'q>>::Statement, Error>> + 'e + Send>>
    where
        'q: 'e,
        'c: 'e
, { ... } }

A type that contains or can provide a database connection to use for executing queries against the database.

No guarantees are provided that successive queries run on the same physical database connection.

A Connection is an Executor that guarantees that successive queries are ran on the same physical database connection.

Implemented for the following:

Associated Types

Loading content...

Required methods

fn fetch_many<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Stream<Item = Result<Either<<Self::Database as Database>::Done, <Self::Database as Database>::Row>, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, Self::Database>, 

Execute multiple queries and return the generated results as a stream from each query, in a stream.

fn fetch_optional<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Future<Output = Result<Option<<Self::Database as Database>::Row>, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, Self::Database>, 

Execute the query and returns at most one row.

fn prepare_with<'e, 'q>(
    self,
    sql: &'q str,
    parameters: &'e [<Self::Database as Database>::TypeInfo]
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as HasStatement<'q>>::Statement, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e, 

Prepare the SQL query, with parameter type information, to inspect the type information about its parameters and results.

Only some database drivers (PostgreSQL, MSSQL) can take advantage of this extra information to influence parameter type inference.

Loading content...

Provided methods

fn execute<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as Database>::Done, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, Self::Database>, 

Execute the query and return the total number of rows affected.

fn execute_many<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Stream<Item = Result<<Self::Database as Database>::Done, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, Self::Database>, 

Execute multiple queries and return the rows affected from each query, in a stream.

fn fetch<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Stream<Item = Result<<Self::Database as Database>::Row, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, Self::Database>, 

Execute the query and return the generated results as a stream.

fn fetch_all<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Future<Output = Result<Vec<<Self::Database as Database>::Row>, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, Self::Database>, 

Execute the query and return all the generated results, collected into a Vec.

fn fetch_one<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as Database>::Row, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, Self::Database>, 

Execute the query and returns exactly one row.

fn prepare<'e, 'q>(
    self,
    query: &'q str
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as HasStatement<'q>>::Statement, Error>> + 'e + Send>> where
    'q: 'e,
    'c: 'e, 

Prepare the SQL query to inspect the type information of its parameters and results.

Be advised that when using the query, query_as, or query_scalar functions, the query is transparently prepared and executed.

This explicit API is provided to allow access to the statement metadata available after it prepared but before the first row is returned.

Loading content...

Implementors

impl<'c> Executor<'c> for &'c mut PoolConnection<Any>[src]

type Database = Any

impl<'c> Executor<'c> for &'c mut PoolConnection<Mssql>[src]

type Database = Mssql

impl<'c> Executor<'c> for &'c mut PoolConnection<MySql>[src]

type Database = MySql

impl<'c> Executor<'c> for &'c mut PoolConnection<Postgres>[src]

type Database = Postgres

impl<'c> Executor<'c> for &'c mut PoolConnection<Sqlite>[src]

type Database = Sqlite

impl<'c> Executor<'c> for &'c mut PgListener[src]

type Database = Postgres

impl<'c> Executor<'c> for &'c mut AnyConnection[src]

type Database = Any

impl<'c> Executor<'c> for &'c mut MssqlConnection[src]

type Database = Mssql

impl<'c> Executor<'c> for &'c mut MySqlConnection[src]

type Database = MySql

impl<'c> Executor<'c> for &'c mut PgConnection[src]

type Database = Postgres

impl<'c> Executor<'c> for &'c mut SqliteConnection[src]

type Database = Sqlite

impl<'c, 't> Executor<'t> for &'t mut Transaction<'c, Any>[src]

type Database = Any

impl<'c, 't> Executor<'t> for &'t mut Transaction<'c, Mssql>[src]

type Database = Mssql

impl<'c, 't> Executor<'t> for &'t mut Transaction<'c, MySql>[src]

type Database = MySql

impl<'c, 't> Executor<'t> for &'t mut Transaction<'c, Postgres>[src]

type Database = Postgres

impl<'c, 't> Executor<'t> for &'t mut Transaction<'c, Sqlite>[src]

type Database = Sqlite

impl<'p, '_, DB> Executor<'p> for &'_ Pool<DB> where
    DB: Database,
    &'c mut <DB as Database>::Connection: for<'c> Executor<'c>,
    <&'c mut <DB as Database>::Connection as Executor<'c>>::Database == DB, 
[src]

type Database = DB

Loading content...