core/co.anitrend.support.query.builder.core.contract/AbstractQueryBuilder

AbstractQueryBuilder

abstract class AbstractQueryBuilder : IQueryBuilder(source)

Inheritors

QueryBuilder

Constructors

constructor()

Properties

criteria

abstract var criteria: Criteria?

distinct

var distinct: Boolean

from

abstract var from: From?

groupBy

abstract val groupBy: MutableList<Projection>

orderBy

abstract var orderBy: MutableList<Order>

projections

abstract val projections: MutableList<Projection>

skip

var skip: Int

take

var take: Int

unionAll

var unionAll: Boolean

unionQueryBuilders

abstract val unionQueryBuilders: MutableList<IQueryBuilder>

Functions

asSubQuery

fun AbstractQueryBuilder.asSubQuery(): From.SubQuery

Create a sub query from the builder

fun IQueryBuilder.asSubQuery(): Projection.SubQuery

build

abstract fun build(): String

buildParameters

abstract fun buildParameters(): List<Any>

clearGroupBy

fun AbstractQueryBuilder.clearGroupBy(): AbstractQueryBuilder

clearOrderBy

fun AbstractQueryBuilder.clearOrderBy(): AbstractQueryBuilder

crossJoin

infix fun AbstractQueryBuilder.crossJoin(other: From): From.Join.Partial

infix fun AbstractQueryBuilder.crossJoin(other: String): From.Join.Partial

Creates an cross join on the receiver with other

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

distinct

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

exists

fun IQueryBuilder.exists(): Criteria

from

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

groupBy

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

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

innerJoin

infix fun AbstractQueryBuilder.innerJoin(other: From): From.Join.Partial

infix fun AbstractQueryBuilder.innerJoin(other: String): From.Join.Partial

Creates an inner join on the receiver with other

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

join

infix fun AbstractQueryBuilder.join(other: From): From.Join.Partial

infix fun AbstractQueryBuilder.join(other: String): From.Join.Partial

Creates an join on the receiver with other

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

leftJoin

infix fun AbstractQueryBuilder.leftJoin(other: From): From.Join.Partial

infix fun AbstractQueryBuilder.leftJoin(other: String): From.Join.Partial

Creates an inner join on the receiver with other

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

notExists

fun IQueryBuilder.notExists(): Criteria

orderByAsc

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

orderByAscCollate

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

Order by asc case insensitive

orderByDesc

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

orderByDescCollate

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

Order by desc case insensitive

select

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

skip

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

take

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

union

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

unionAll

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

where

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

whereAnd

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

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

whereOr

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

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