Struct NotIn

#[non_exhaustive]
pub struct NotIn<T, U> {
    pub left: T,
    pub values: U,
}

Available on crate feature i-implement-a-third-party-backend-and-opt-into-breaking-changes only.

Query dsl node that represents a left NOT IN (values) expression

Third party backend can customize the QueryFragment implementation of this query dsl node via SqlDialect::ArrayComparison. A customized implementation is expected to provide the same semantics as an ANSI SQL NOT IN expression.0

The postgres backend provided a specialized implementation by using left != ALL(values) as optimized variant instead if this is possible. For cases where this is not possible like for example if values is a vector of arrays we generate a ordinary NOT IN expression instead

Fields (Non-exhaustive)

Non-exhaustive structs could have additional fields added in future. Therefore, non-exhaustive structs cannot be constructed in external crates using the traditional Struct { .. } syntax; cannot be matched against without a wildcard ..; and struct update syntax will not work.

left: T

The expression on the left side of the NOT IN keyword

values: U

The values clause of the NOT IN expression

Trait Implementations

impl<T: Clone, U: Clone> Clone for NotIn<T, U>

fn clone(&self) -> NotIn<T, U>

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<T: Debug, U: Debug> Debug for NotIn<T, U>

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

Formats the value using the given formatter.

impl<T, U> Expression for NotIn<T, U>

where T: Expression, U: InExpression<SqlType = T::SqlType>, T::SqlType: SqlType, IsSqlTypeNullable<T::SqlType>: MaybeNullableType<Bool>,

type SqlType = <<<T as Expression>::SqlType as SqlType>::IsNull as MaybeNullableType<Bool>>::Out

The type that this expression represents in SQL

impl<T, U, DB> QueryFragment<DB> for NotIn<T, U>

where DB: Backend, Self: QueryFragment<DB, DB::ArrayComparison>,

fn walk_ast<'b>(&'b self, pass: AstPass<'_, 'b, DB>) -> QueryResult<()>

Walk over this QueryFragment for all passes.

fn to_sql(&self, out: &mut DB::QueryBuilder, backend: &DB) -> QueryResult<()>

Converts this QueryFragment to its SQL representation.

fn collect_binds<'b>( &'b self, out: &mut DB::BindCollector<'b>, metadata_lookup: &mut DB::MetadataLookup, backend: &'b DB, ) -> QueryResult<()>

Serializes all bind parameters in this query.

fn is_safe_to_cache_prepared(&self, backend: &DB) -> QueryResult<bool>

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

fn is_noop(&self, backend: &DB) -> QueryResult<bool>

Does walking this AST have any effect?

impl<T, U, DB> QueryFragment<DB, AnsiSqlArrayComparison> for NotIn<T, U>

where DB: Backend + SqlDialect<ArrayComparison = AnsiSqlArrayComparison>, T: QueryFragment<DB>, U: QueryFragment<DB> + InExpression,

fn walk_ast<'b>(&'b self, out: AstPass<'_, 'b, DB>) -> QueryResult<()>

Walk over this QueryFragment for all passes.

fn to_sql(&self, out: &mut DB::QueryBuilder, backend: &DB) -> QueryResult<()>

Converts this QueryFragment to its SQL representation.

fn collect_binds<'b>( &'b self, out: &mut DB::BindCollector<'b>, metadata_lookup: &mut DB::MetadataLookup, backend: &'b DB, ) -> QueryResult<()>

Serializes all bind parameters in this query.

fn is_safe_to_cache_prepared(&self, backend: &DB) -> QueryResult<bool>

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

fn is_noop(&self, backend: &DB) -> QueryResult<bool>

Does walking this AST have any effect?

impl<T: QueryId, U: QueryId> QueryId for NotIn<T, U>

const HAS_STATIC_QUERY_ID: bool

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

type QueryId = NotIn<<T as QueryId>::QueryId, <U as QueryId>::QueryId>

A type which uniquely represents Self in a SQL query.

fn query_id() -> Option<TypeId>

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

impl<T, U, __GroupByClause> ValidGrouping<__GroupByClause> for NotIn<T, U>

where T: ValidGrouping<__GroupByClause>, U: ValidGrouping<__GroupByClause>, T::IsAggregate: MixedAggregates<U::IsAggregate>,

type IsAggregate = <<T as ValidGrouping<__GroupByClause>>::IsAggregate as MixedAggregates<<U as ValidGrouping<__GroupByClause>>::IsAggregate>>::Output

Is this expression aggregate?

impl<T, U, QS> AppearsOnTable<QS> for NotIn<T, U>

where NotIn<T, U>: Expression, T: AppearsOnTable<QS>, U: AppearsOnTable<QS>,

impl<T: Copy, U: Copy> Copy for NotIn<T, U>

impl<T, U, QS> SelectableExpression<QS> for NotIn<T, U>

where NotIn<T, U>: AppearsOnTable<QS>, T: SelectableExpression<QS>, U: SelectableExpression<QS>,