DeleteStatement<T extends Table, D> class

A DELETE statement in sql

Inheritance
Mixed-in types
Available extensions

Constructors

DeleteStatement.new(DatabaseConnectionUser database, TableInfo<T, D> table)
This constructor should be called by DatabaseConnectionUser.delete for you.

Properties

database ↔ DatabaseConnectionUser
The database this statement should be sent to.
getter/setter pairinherited
hashCode → int
The hash code for this object.
no setterinherited
limitExpr ↔ Limit?
The LIMIT clause for this statement.
getter/setter pairinherited
orderByExpr ↔ OrderBy?
The ORDER BY clause for this statement
getter/setter pairinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
table ↔ ResultSetImplementation<T, D>
The (main) table or view that this query operates on.
getter/setter pairinherited
whereExpr ↔ Where?
The WHERE clause for this statement
getter/setter pairinherited
writeReturningClause ↔ bool
Whether a RETURNING * clause should be added to this statement.
getter/setter pairinherited

Methods

constructQuery() → GenerationContext
Constructs the query that can then be sent to the database executor.
inherited
delete(Insertable<D> entity) → Future<int>
Deletes just this entity. May not be used together with where.
deleteReturning(Insertable<D> entity) → Future<D?>
Like delete, but returns the deleted row from the database.
go() → Future<int>
Deletes all rows matched by the set where clause and the optional limit.
goAndReturn() → Future<List<D>>
Like go, but it also returns all rows affected by this delete operation.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
inherited
where(Expression<bool> filter(T tbl)) → void
Makes this statement only include rows that match the filter.
inherited
whereSamePrimaryKey(Insertable<D> d) → void

Available on SingleTableQueryMixin<T, D>, provided by the QueryTableExtensions extension

Applies a where statement so that the row with the same primary key as d will be matched.
writeInto(GenerationContext context) → void
Writes this component into the context by writing to its GenerationContext.buffer or by introducing bound variables. When writing into the buffer, no whitespace around the this component should be introduced. When a component consists of multiple composed component, it's responsible for introducing whitespace between its child components.
inherited
writeStartPart(GenerationContext ctx) → void
Subclasses must override this and write the part of the statement that comes before the where and limit expression..
override

Operators

operator ==(Object other) → bool
The equality operator.
inherited