kotlin-common-exposed/com.huanshankeji.exposed

Package-level declarations

Types

BuildWhere

typealias BuildWhere = SqlExpressionBuilder.() -> Op<Boolean>

HelperInsertStatement

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

TableAwareBuildWhere

typealias TableAwareBuildWhere<T> = T.() -> Op<Boolean>

TableAwareWithSqlExpressionBuilderBuildWhere

typealias TableAwareWithSqlExpressionBuilderBuildWhere<T> = T.(ISqlExpressionBuilder) -> Op<Boolean>

Where

typealias ~~Where~~ = BuildWhere

WhereOp

typealias WhereOp = Op<Boolean>

Properties

asterisk

val asterisk: LiteralOp<String>

Functions

defaultColumnsForInsertSelect

fun Table.defaultColumnsForInsertSelect(): List<Column<*>>

deleteAllStatement

fun Table.deleteAllStatement(): DeleteStatement

deleteIgnoreWhereStatement

fun <T : Table> T.deleteIgnoreWhereStatement(limit: Int? = null, offset: Long? = null, op: TableAwareWithSqlExpressionBuilderBuildWhere<T>): DeleteStatement

Adapted from org.jetbrains.exposed.sql.deleteWhere.

deleteWhereStatement

fun <T : Table> T.deleteWhereStatement(limit: Int? = null, offset: Long? = null, op: TableAwareWithSqlExpressionBuilderBuildWhere<T>): DeleteStatement

fun Table.~~deleteWhereStatement~~(isIgnore: Boolean = false, limit: Int? = null, offset: Long? = null, op: BuildWhere): DeleteStatement

Adapted from org.jetbrains.exposed.sql.deleteWhere.

fun Table.deleteWhereStatement(op: WhereOp, isIgnore: Boolean = false, limit: Int? = null, offset: Long? = null): DeleteStatement

emptySlice

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.

insertIgnoreStatement

fun <T : Table> T.insertIgnoreStatement(body: T.(InsertStatement<Number>) -> Unit): HelperInsertStatement<Number>

Adapted from org.jetbrains.exposed.sql.insertIgnore.

insertSelectStatement

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

Adapted from org.jetbrains.exposed.sql.insert.

insertStatement

fun <T : Table> T.insertStatement(body: T.(InsertStatement<Number>) -> Unit): HelperInsertStatement<Number>

Adapted from org.jetbrains.exposed.sql.insert.

replaceStatement

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

Adapted from org.jetbrains.exposed.sql.replace.

selectAllStatement

fun FieldSet.selectAllStatement(): Query

You can also just use selectAll.

selectEmpty

fun ColumnSet.selectEmpty(): Query

selectStatement

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 org.jetbrains.exposed.sql.select.

selectStatementTableAware

fun <T : FieldSet> T.~~selectStatementTableAware~~(where: TableAwareBuildWhere<T>): Query

updateStatement

fun <T : Table> T.updateStatement(where: BuildWhere? = null, limit: Int? = null, body: T.(UpdateStatement) -> Unit): UpdateStatement

Adapted from org.jetbrains.exposed.sql.update.

updateStatementTableAware

fun <T : Table> T.updateStatementTableAware(where: TableAwareBuildWhere<T>? = null, limit: Int? = null, body: T.(UpdateStatement) -> Unit): UpdateStatement

updateStatementWithWhereOp

fun <T : Table> T.updateStatementWithWhereOp(where: WhereOp? = null, limit: Int? = null, body: T.(UpdateStatement) -> Unit): UpdateStatement