core/co.anitrend.support.query.builder.dsl

Package-level declarations

Functions

fun AbstractQueryBuilder.clearGroupBy(): AbstractQueryBuilder

fun AbstractQueryBuilder.clearOrderBy(): AbstractQueryBuilder

inline fun AbstractQueryBuilder.crossJoin(other: From.Table, block: From.Join.Partial.() -> From.Join): From.Join

inline fun AbstractQueryBuilder.crossJoin(other: String, block: From.Join.Partial.() -> From.Join): From.Join

infix fun AbstractQueryBuilder.distinct(distinct: Boolean): AbstractQueryBuilder

infix fun AbstractQueryBuilder.from(subQuery: IQueryBuilder): AbstractQueryBuilder

infix fun AbstractQueryBuilder.from(from: From): AbstractQueryBuilder

infix inline fun AbstractQueryBuilder.from(block: AbstractQueryBuilder.() -> From): AbstractQueryBuilder

infix fun AbstractQueryBuilder.from(table: String): AbstractQueryBuilder

infix fun AbstractQueryBuilder.groupBy(column: Projection): AbstractQueryBuilder

infix fun AbstractQueryBuilder.groupBy(projections: List<Projection>): AbstractQueryBuilder

inline fun AbstractQueryBuilder.innerJoin(other: From.Table, block: From.Join.Partial.() -> From.Join): From.Join

inline fun AbstractQueryBuilder.innerJoin(other: String, block: From.Join.Partial.() -> From.Join): From.Join

inline fun AbstractQueryBuilder.join(other: From.Table, block: From.Join.Partial.() -> From.Join): From.Join

inline fun AbstractQueryBuilder.join(other: String, block: From.Join.Partial.() -> From.Join): From.Join

inline fun AbstractQueryBuilder.leftJoin(other: From.Table, block: From.Join.Partial.() -> From.Join): From.Join

inline fun AbstractQueryBuilder.leftJoin(other: String, block: From.Join.Partial.() -> From.Join): From.Join

infix fun AbstractQueryBuilder.orderByAsc(column: Projection): AbstractQueryBuilder

orderByAscCollate

infix fun AbstractQueryBuilder.orderByAscCollate(column: Projection): AbstractQueryBuilder

Order by asc case insensitive

infix fun AbstractQueryBuilder.orderByDesc(column: Projection): AbstractQueryBuilder

orderByDescCollate

infix fun AbstractQueryBuilder.orderByDescCollate(column: Projection): AbstractQueryBuilder

Order by desc case insensitive

infix fun AbstractQueryBuilder.select(column: Projection): AbstractQueryBuilder

infix fun AbstractQueryBuilder.select(column: String): AbstractQueryBuilder

fun AbstractQueryBuilder.select(projections: List<Projection>): AbstractQueryBuilder

fun AbstractQueryBuilder.select(vararg columns: String): AbstractQueryBuilder

infix fun AbstractQueryBuilder.skip(skip: Int): AbstractQueryBuilder

infix fun AbstractQueryBuilder.take(take: Int): AbstractQueryBuilder

infix fun AbstractQueryBuilder.union(query: AbstractQueryBuilder): AbstractQueryBuilder

infix fun AbstractQueryBuilder.unionAll(query: AbstractQueryBuilder): AbstractQueryBuilder

infix inline fun AbstractQueryBuilder.where(block: AbstractQueryBuilder.() -> Criteria): AbstractQueryBuilder

infix inline fun AbstractQueryBuilder.whereAnd(block: AbstractQueryBuilder.() -> Criteria): AbstractQueryBuilder

Applied AND operator with a when statement, this is useful when chaining multiple WHERE clauses

infix inline fun AbstractQueryBuilder.whereOr(block: AbstractQueryBuilder.() -> Criteria): AbstractQueryBuilder

Applied OR operator with a when statement, this is useful when chaining multiple WHERE clauses