Package-level declarations

Types

Link copied to clipboard
class HelperInsertStatement<Key : Any>(table: Table, isIgnore: Boolean = false) : InsertStatement<Key>

Properties

Functions

Link copied to clipboard
fun Table.defaultColumnsForInsertSelect(): List<Column<*>>
Link copied to clipboard
fun Table.deleteAllStatement(): DeleteStatement
Link copied to clipboard
fun <T : Table> T.deleteIgnoreWhereStatement(limit: Int? = null, offset: Long? = null, where: TableAwareWithSqlExpressionBuilderBuildWhere<T>): DeleteStatement

Adapted from org.jetbrains.exposed.v1.jdbc.deleteWhere.

Link copied to clipboard
fun <T : Table> T.deleteWhereStatement(limit: Int? = null, offset: Long? = null, where: TableAwareWithSqlExpressionBuilderBuildWhere<T>): DeleteStatement

Adapted from org.jetbrains.exposed.v1.jdbc.deleteWhere.

fun Table.deleteWhereStatement(where: WhereOp, isIgnore: Boolean = false, limit: Int? = null, offset: Long? = null): DeleteStatement
Link copied to clipboard
fun ColumnSet.emptySlice(): FieldSet

To simplify the SQL in some expression queries. For example Dual.slice(exists(Table.emptySlice().select(op))).selectAll() generates a SQL with no columns which is simpler.

Link copied to clipboard
fun <T : Table> T.insertIgnoreStatement(body: T.(InsertStatement<Number>) -> Unit): InsertStatement<Number>

Adapted from org.jetbrains.exposed.v1.jdbc.insertIgnore.

Link copied to clipboard
fun <T : Table> T.insertSelectStatement(selectQuery: AbstractQuery<*>, columns: List<Column<*>> = defaultColumnsForInsertSelect(), isIgnore: Boolean = false): InsertSelectStatement

Adapted from org.jetbrains.exposed.v1.jdbc.insert.

Link copied to clipboard
fun <T : Table> T.insertStatement(body: T.(InsertStatement<Number>) -> Unit): InsertStatement<Number>

Adapted from org.jetbrains.exposed.v1.jdbc.insert.

Link copied to clipboard
fun <T : Table> T.replaceStatement(body: T.(UpdateBuilder<*>) -> Unit): ReplaceStatement<Long>

Adapted from org.jetbrains.exposed.v1.jdbc.replace.

Link copied to clipboard
fun FieldSet.selectAllStatement(): Query

You can also just use selectAll.

Link copied to clipboard
fun ColumnSet.selectStatement(columns: List<Expression<*>>): Query
fun ColumnSet.selectStatement(column: Expression<*>, vararg columns: Expression<*>): Query

You can also just use select.

fun FieldSet.selectStatement(where: BuildWhere): Query
fun FieldSet.selectStatement(where: WhereOp): Query

Adapted from Query.

Link copied to clipboard
fun <T : FieldSet> T.selectStatementTableAware(where: TableAwareBuildWhere<T>): Query
Link copied to clipboard
fun <T : Table> T.updateStatement(where: BuildWhere? = null, limit: Int? = null, body: T.(UpdateStatement) -> Unit): UpdateStatement

Adapted from org.jetbrains.exposed.v1.jdbc.update.

Link copied to clipboard
fun <T : Table> T.updateStatementTableAware(where: T.() -> Op<Boolean>? = null, limit: Int? = null, body: T.(UpdateStatement) -> Unit): UpdateStatement
Link copied to clipboard
fun <T : Table> T.updateStatementWithWhereOp(where: WhereOp? = null, limit: Int? = null, body: T.(UpdateStatement) -> Unit): UpdateStatement