Struct RawSql 

pub struct RawSql(/* private fields */);

One or more raw SQL statements, separated by semicolons (;).

See raw_sql() for details.

Implementations

impl RawSql

pub async fn execute<'e, E, DB>(self, executor: E) -> Result<DB::QueryResult>

where DB: Database, E: Executor<'e, Database = DB>,

Execute the SQL string and return the total number of rows affected.

pub fn execute_many<'e, E, DB>( self, executor: E, ) -> BoxStream<'e, Result<DB::QueryResult>>

where DB: Database, E: Executor<'e, Database = DB>,

Execute the SQL string. Returns a stream which gives the number of rows affected for each statement in the string.

pub fn fetch<'e, E, DB>( self, executor: E, ) -> BoxStream<'e, Result<DB::Row, Error>>

where DB: Database, E: Executor<'e, Database = DB>,

Execute the SQL string and return the generated results as a stream.

If the string contains multiple statements, their results will be concatenated together.

pub fn fetch_many<'e, E, DB>( self, executor: E, ) -> BoxStream<'e, Result<Either<DB::QueryResult, DB::Row>, Error>>

where DB: Database, E: Executor<'e, Database = DB>,

Execute the SQL string and return the generated results as a stream.

For each query in the stream, any generated rows are returned first, then the QueryResult with the number of rows affected.

pub fn fetch_all<'e, E, DB>( self, executor: E, ) -> BoxFuture<'e, Result<Vec<DB::Row>>>

where DB: Database, E: Executor<'e, Database = DB>,

Execute the SQL string and return all the resulting rows collected into a Vec.

Note: beware result set size.

This will attempt to collect the full result set of the query into memory.

To avoid exhausting available memory, ensure the result set has a known upper bound, e.g. using LIMIT.

pub fn fetch_one<'e, E, DB>(self, executor: E) -> BoxFuture<'e, Result<DB::Row>>

where DB: Database, E: Executor<'e, Database = DB>,

Execute the SQL string, returning the first row or Error::RowNotFound otherwise.

Note: for best performance, ensure the query returns at most one row.

Depending on the driver implementation, if your query can return more than one row, it may lead to wasted CPU time and bandwidth on the database server.

Even when the driver implementation takes this into account, ensuring the query returns at most one row can result in a more optimal query plan.

If your query has a WHERE clause filtering a unique column by a single value, you’re good.

Otherwise, you might want to add LIMIT 1 to your query.

pub async fn fetch_optional<'e, E, DB>( self, executor: E, ) -> Result<Option<DB::Row>>

where DB: Database, E: Executor<'e, Database = DB>,

Execute the SQL string, returning the first row or None otherwise.

Note: for best performance, ensure the query returns at most one row.

Depending on the driver implementation, if your query can return more than one row, it may lead to wasted CPU time and bandwidth on the database server.

Even when the driver implementation takes this into account, ensuring the query returns at most one row can result in a more optimal query plan.

If your query has a WHERE clause filtering a unique column by a single value, you’re good.

Otherwise, you might want to add LIMIT 1 to your query.

Trait Implementations

impl<DB: Database> Execute<'_, DB> for RawSql

fn sql(self) -> SqlStr

Gets the SQL that will be executed.

fn statement(&self) -> Option<&<DB as Database>::Statement>

Gets the previously cached statement, if available.

fn take_arguments( &mut self, ) -> Result<Option<<DB as Database>::Arguments>, BoxDynError>

Returns the arguments to be bound against the query string.

fn persistent(&self) -> bool

Returns true if the statement should be cached.