Struct block_tools::db::use_diesel::expression::UncheckedBind

#[must_use =
  "Queries are only executed when calling `load`, `get_result`, or similar."]pub struct UncheckedBind<Query, Value> { /* fields omitted */ }

Returned by the SqlLiteral::bind() method when binding a value to a fragment of SQL.

Implementations

impl<Query, Value> UncheckedBind<Query, Value> where
    Query: Expression, 

pub fn sql(
    self,
    sql: &str
) -> SqlLiteral<<Query as Expression>::SqlType, UncheckedBind<Query, Value>>

Use literal SQL in the query builder

This function is intended for use when you need a small bit of raw SQL in your query. If you want to write the entire query using raw SQL, use sql_query instead.

Safety

This function should be used with care, as Diesel cannot validate that the value is of the right type nor can it validate that you have passed the correct number of parameters.

Examples

let query = users
    .select(name)
    .filter(
        sql("id > ")
        .bind::<Integer,_>(1)
        .sql(" AND name <> 'Ryan'")
    )
    .get_results(&connection);
let expected = vec!["Tess".to_string()];
assert_eq!(Ok(expected), query);

Trait Implementations

impl<QS, Query, Value> AppearsOnTable<QS> for UncheckedBind<Query, Value> where
    UncheckedBind<Query, Value>: Expression, 

impl<Query, Value> Clone for UncheckedBind<Query, Value> where
    Query: Clone,
    Value: Clone, 

pub fn clone(&self) -> UncheckedBind<Query, Value>

Returns a copy of the value.

pub fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl<Query, Value> Copy for UncheckedBind<Query, Value> where
    Query: Copy,
    Value: Copy, 

impl<Query, Value> Debug for UncheckedBind<Query, Value> where
    Query: Debug,
    Value: Debug, 

pub fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl<Query, Value> Expression for UncheckedBind<Query, Value> where
    Query: Expression, 

type SqlType = <Query as Expression>::SqlType

The type that this expression represents in SQL

impl<Query, Value> NonAggregate for UncheckedBind<Query, Value> where
    UncheckedBind<Query, Value>: Expression, 

impl<Q, Value> Query for UncheckedBind<Q, Value> where
    Q: Query, 

type SqlType = <Q as Query>::SqlType

The SQL type that this query represents.

impl<Query, Value, DB> QueryFragment<DB> for UncheckedBind<Query, Value> where
    DB: Backend,
    Query: QueryFragment<DB>,
    Value: QueryFragment<DB>, 

pub fn walk_ast(&self, out: AstPass<'_, DB>) -> Result<(), Error>

Walk over this QueryFragment for all passes.

pub fn to_sql(
    &self,
    out: &mut <DB as Backend>::QueryBuilder
) -> Result<(), Error>

Converts this QueryFragment to its SQL representation.

pub fn collect_binds(
    &self,
    out: &mut <DB as Backend>::BindCollector,
    metadata_lookup: &<DB as TypeMetadata>::MetadataLookup
) -> Result<(), Error>

Serializes all bind parameters in this query.

pub fn is_safe_to_cache_prepared(&self) -> Result<bool, Error>

Is this query safe to store in the prepared statement cache?

impl<Query, Value> QueryId for UncheckedBind<Query, Value> where
    Query: QueryId,
    Value: QueryId, 

type QueryId = UncheckedBind<<Query as QueryId>::QueryId, <Value as QueryId>::QueryId>

A type which uniquely represents Self in a SQL query.

pub const HAS_STATIC_QUERY_ID: bool

Can the SQL generated by Self be uniquely identified by its type?

pub fn query_id() -> Option<TypeId>

Returns the type id of Self::QueryId if Self::HAS_STATIC_QUERY_ID. Returns None otherwise.

impl<Query, Value, Conn> RunQueryDsl<Conn> for UncheckedBind<Query, Value>

pub fn execute(self, conn: &Conn) -> Result<usize, Error> where
    Self: ExecuteDsl<Conn, <Conn as Connection>::Backend>,
    Conn: Connection, 

Executes the given command, returning the number of rows affected.

pub fn load<U>(self, conn: &Conn) -> Result<Vec<U, Global>, Error> where
    Self: LoadQuery<Conn, U>, 

Executes the given query, returning a Vec with the returned rows.

pub fn get_result<U>(self, conn: &Conn) -> Result<U, Error> where
    Self: LoadQuery<Conn, U>, 

Runs the command, and returns the affected row.

pub fn get_results<U>(self, conn: &Conn) -> Result<Vec<U, Global>, Error> where
    Self: LoadQuery<Conn, U>, 

Runs the command, returning an Vec with the affected rows.

pub fn first<U>(self, conn: &Conn) -> Result<U, Error> where
    Self: LimitDsl,
    Self::Output: LoadQuery<Conn, U>, 

Attempts to load a single record.

impl<QS, Query, Value> SelectableExpression<QS> for UncheckedBind<Query, Value> where
    UncheckedBind<Query, Value>: AppearsOnTable<QS>,