core/co.anitrend.support.query.builder.core.projection/Projection/Column

Column

data class Column(column: String, table: String? = null) : Projection(source)

Column builder

Constructors

Column

constructor(column: String, table: String? = null)

Functions

infix fun Projection.Column.as(alias: String): Projection

asSubQuery

fun IQueryBuilder.asSubQuery(): Projection.SubQuery

average

fun Projection.Column.average(): Projection.Aggregate

between

fun Projection.Column.between(valueMin: Any, valueMax: Any): Criteria

build

open override fun build(): String

buildParameters

open override fun buildParameters(): List<Any>

count

fun Projection.Column.count(): Projection.Aggregate

endsWith

infix fun Projection.Column.endsWith(value: String): Criteria

equal

infix fun Projection.equal(value: Any): Criteria

exists

fun IQueryBuilder.exists(): Criteria

greaterThan

infix fun Projection.Column.greaterThan(value: Any): Criteria

greaterThanOrEqual

infix fun Projection.Column.greaterThanOrEqual(value: Any): Criteria

infix fun Projection.Column.in(values: Collection<Any>): Criteria

isNull

fun Projection.isNull(): Criteria

lesserThan

infix fun Projection.Column.lesserThan(value: Any): Criteria

lesserThanOrEqual

infix fun Projection.Column.lesserThanOrEqual(value: Any): Criteria

infix fun Projection.Column.like(value: String): Criteria

match

infix fun Projection.Column.match(value: Any): Criteria

max

fun Projection.Column.max(): Projection.Aggregate

min

fun Projection.Column.min(): Projection.Aggregate

notEndsWith

infix fun Projection.Column.notEndsWith(value: String): Criteria

notEqual

infix fun Projection.notEqual(value: Any): Criteria

notExists

fun IQueryBuilder.notExists(): Criteria

notIn

infix fun Projection.Column.notIn(values: Collection<Any>): Criteria

notIsNull

fun Projection.notIsNull(): Criteria

notLike

infix fun Projection.Column.notLike(value: String): Criteria

notStartsWith

infix fun Projection.Column.notStartsWith(value: String): Criteria

orderAsc

infix fun Projection.orderAsc(ignoreCase: Boolean): Order.Ascending

orderDesc

infix fun Projection.orderDesc(ignoreCase: Boolean): Order.Descending

startsWith

infix fun Projection.Column.startsWith(value: String): Criteria

sum

fun Projection.Column.sum(): Projection.Aggregate

total

fun Projection.Column.total(): Projection.Aggregate