Struct RawQuery 

pub struct RawQuery<'a, C> { /* private fields */ }

Implementations

impl<'a, C> RawQuery<'a, C>

where C: Connection,

pub fn bind<T>(self, value: T) -> Self

where T: 'a + Encode<'a, Any> + Type<Any> + Send + Sync,

Binds a value to the SQL query.

Type Parameters

• T - The type of the value to bind.

Example

let user: User = db.raw("SELECT * FROM users WHERE id = ?")
    .bind(1)
    .fetch_one()
    .await?;

pub async fn fetch_all<T>(self) -> Result<Vec<T>, Error>

where T: for<'r> FromRow<'r, AnyRow> + Send + Unpin,

Executes the query and returns all matching rows.

Type Parameters

• T - The type to map the rows to.

Example

let users: Vec<User> = db.raw("SELECT * FROM users")
    .fetch_all()
    .await?;

pub async fn fetch_one<T>(self) -> Result<T, Error>

where T: for<'r> FromRow<'r, AnyRow> + Send + Unpin,

Executes the query and returns exactly one row.

Type Parameters

• T - The type to map the row to.

Example

let user: User = db.raw("SELECT * FROM users WHERE id = 1")
    .fetch_one()
    .await?;

pub async fn fetch_optional<T>(self) -> Result<Option<T>, Error>

where T: for<'r> FromRow<'r, AnyRow> + Send + Unpin,

Executes the query and returns an optional row.

Type Parameters

• T - The type to map the row to.

Example

let user: Option<User> = db.raw("SELECT * FROM users WHERE id = 1")
    .fetch_optional()
    .await?;

pub async fn execute(self) -> Result<u64, Error>

Executes the query and returns the number of affected rows.

Useful for UPDATE, DELETE or INSERT queries.

Example

let affected = db.raw("DELETE FROM users WHERE id = 1")
    .execute()
    .await?;