ExistsExpression class final

An EXISTS (or NOT EXISTS) expression in SQL.

This expression evaluates the select statement and reports whether that statement would return any rows.

Inheritance

• Object
• Expression<bool>
• ExistsExpression

Available extensions

• BooleanExpressionOperators

Constructors

ExistsExpression(BaseSelectStatement<BaseSelectStatement, dynamic> select, {bool not = false})

Creates an ExistsExpression from the inner select statement.

Properties

hashCode → int

The hash code for this object.

no setter, override

not → bool

Whether this should be a NOT EXISTS expression instead.

final

precedence → Precedence

The precedence of this expression. This can be used to automatically put parentheses around expressions as needed.

no setter, override

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

select → BaseSelectStatement<BaseSelectStatement, dynamic>

The inner select statement to run.

final

sqlType → SqlType<bool>

Resolves the SqlType implementation describing the type of this expression.

no setter, inherited

Methods

caseMatch<R extends Object>({required Map<Expression<bool>, Expression<R>> when, Expression<R>? orElse}) → Expression<R>

A CASE WHEN construct using the current expression as a base.

inherited

cast<T2 extends Object>([SqlType<T2>? type]) → Expression<T2>

Generates a CAST(expression AS TYPE) expression.

inherited

compileWith(StatementCompiler compiler) → void

Compiles this component with the given StatementCompiler by invoking the relevant add method on it.

override

dartCast<T2 extends Object>({SqlType<T2>? customType}) → Expression<T2>

Casts this expression to an expression of D.

inherited

equals(bool compare) → Expression<bool>

Whether this column is equal to the given value, which must have a fitting type. The compare value will be written as a variable using prepared statements, so there is no risk of an SQL-injection.

inherited

equalsExp(Expression<bool> compare) → Expression<bool>

Whether this expression is equal to the given expression.

inherited

equalsNullable(bool? compare) → Expression<bool>

Compares the value of this column to compare or null.

inherited

iif(Expression<bool> predicate, Expression<bool> ifFalse) → Expression<bool>

Evaluates to this if predicate is true, otherwise evaluates to ifFalse.

inherited

isExp(Expression<bool> other) → Expression<bool>

Generates an IS expression in SQL, comparing this expression with the other expression.

inherited

isIn(Iterable<bool> values) → Expression<bool>

An expression that is true if this resolves to any of the values in values.

inherited

isInExp(List<Expression<bool>> expressions) → Expression<bool>

An expression that evaluates to true if this expression resolves to a value that one of the expressions resolve to as well.

inherited

isInQuery(BaseSelectStatement<BaseSelectStatement, dynamic> select) → Expression<bool>

An expression checking whether this is included in any row of the provided select statement.

inherited

isNotExp(Expression<bool> other) → Expression<bool>

Generates an IS NOT expression in SQL, comparing this expression with the other expression.

inherited

isNotIn(Iterable<bool> values) → Expression<bool>

An expression that is true if this does not resolve to any of the values in values.

inherited

isNotInExp(List<Expression<bool>> expressions) → Expression<bool>

An expression that evaluates to true if this expression does not resolve to any value that the expressions resolve to.

inherited

isNotInQuery(BaseSelectStatement<BaseSelectStatement, dynamic> select) → Expression<bool>

An expression checking whether this is not included in any row of the provided select statement.

inherited

isNotNull() → Expression<bool>

Expression that is true if the inner expression resolves to a non-null value.

inherited

isNotValue(bool value) → Expression<bool>

Generates an IS NOT expression in SQL, comparing this expression with the Dart value.

inherited

isNull() → Expression<bool>

Expression that is true if the inner expression resolves to a null value.

inherited

isValue(bool value) → Expression<bool>

Generates an IS expression in SQL, comparing this expression with the Dart value.

inherited

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

not() → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Negates this boolean expression. The returned expression is true if this is false, and vice versa.

nullIf(Expression<bool> matcher) → Expression<bool>

Returns null if matcher is equal to this expression, this otherwise.

inherited

toString() → String

A string representation of this object.

inherited

variable(bool? value) → Variable<bool>

Creates a variable that is guaranteed to have the same SqlType as this.

inherited

Operators

operator &(Expression<bool> other) → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Returns an expression that is true iff both this and other are true.

operator ==(Object other) → bool

The equality operator.

override

operator |(Expression<bool> other) → Expression<bool>

Available on Expression<bool>, provided by the BooleanExpressionOperators extension

Returns an expression that is true if this or other are true.