database-jvm-jooq/dev.limebeck.libs.db.jooq

Package-level declarations

Types

interface JooqDatabaseService : DatabaseService<DSLContext> , AutoCloseable

class JooqDatabaseServiceImpl(configuration: DbConfiguration, dataSourceProvider: DataSourceProvider = PostgresDataSourceProvider, val alwaysRollback: Boolean = false, meterRegistry: MeterRegistry? = null) : JooqDatabaseService

TableDefinition

abstract class TableDefinition(val tableName: String)

TableDefinitionField

class TableDefinitionField<T>(tableDefinition: TableDefinition, val name: String, valueClass: Class<T>)

TableDefinitionFieldDelegate

class TableDefinitionFieldDelegate<T>(val name: String?, val clazz: Class<T>)

Properties

isNotNull

val <T> TableDefinitionField<T>.isNotNull: Condition

isNull

val <T> TableDefinitionField<T>.isNull: Condition

Functions

and

infix fun Condition.and(condition: Condition): @NotNull Condition

infix fun <T> TableDefinitionField<T>.eq(value: T): @NotNull Condition

infix fun <T> TableDefinitionField<T>.eq(field: TableDefinitionField<T>): @NotNull Condition

infix fun <T> Field<T>.eq(field: Field<T>): Condition

executeAndCheck

fun Query.executeAndCheck(affectedRows: Int = 1)

Checks that execution affects expected number of rows.

infix fun <T> Field<T>.ge(value: T): Condition

infix fun <T> Field<T>.ge(field: Field<T>): Condition

get

operator fun <T> Record.get(field: TableDefinitionField<T>): T

infix fun <T> Field<T>.gt(field: Field<T>): Condition

insertValues

@JvmName(name = "insertDefValues")

fun <R : Record> InsertSetStep<R>.insertValues(vararg columnValues: Pair<TableDefinitionField<*>, *>): InsertOnDuplicateStep<R>

fun <R : Record> InsertSetStep<R>.insertValues(vararg columnValues: Pair<Field<*>, *>): InsertOnDuplicateStep<R>

Inserts values

infix fun <T> Field<T>.le(value: T): Condition

infix fun <T> Field<T>.le(field: Field<T>): Condition

infix fun <T> Field<T>.lt(field: Field<T>): Condition

infix fun <T> TableDefinitionField<T>.ne(value: T): @NotNull Condition

infix fun <T> Field<T>.ne(field: Field<T>): Condition

infix fun Condition.or(condition: Condition): @NotNull Condition

runTransactionAndGetContext

inline fun <R> JooqDatabaseService.runTransactionAndGetContext(crossinline block: (ctx: DSLContext) -> R): R

selectPaginated

fun <AfterWhereStep : Select<Record>, T> DSLContext.selectPaginated(mapper: RecordMapper<Record, T>, pagination: Pagination? = null, selection: SelectSelectStep<Record> = select(), orderByStep: AfterWhereStep.() -> SelectLimitStep<Record>? = null, whereStep: SelectSelectStep<Record>.() -> AfterWhereStep? = null): PaginatedResult<T>

selectPaginatedWithGroup

fun <AfterWhereStep : Select<Record>, T> DSLContext.selectPaginatedWithGroup(mapper: RecordMapper<Record, T>, pagination: Pagination? = null, countOn: List<TableDefinitionField<*>>, groupStep: AfterWhereStep.() -> SelectHavingStep<Record>? = null, selectionStep: DSLContext.() -> SelectSelectStep<Record> = { select() }, orderByStep: AfterWhereStep.() -> SelectLimitStep<Record>? = null, whereStep: SelectSelectStep<Record>.() -> AfterWhereStep? = null): PaginatedResult<T>

set

infix fun <T> TableDefinitionField<T>.set(value: T): Pair<Field<T>, T>

Set operator for insert and update query.

@JvmName(name = "setDefs")

fun <R : Record> UpdateSetFirstStep<R>.set(vararg columnValues: Pair<TableDefinitionField<*>, *>): UpdateSetMoreStep<R>

fun <R : Record> UpdateSetFirstStep<R>.set(vararg columnValues: Pair<Field<*>, *>): UpdateSetMoreStep<R>

toTimestamp

fun Instant.toTimestamp(): Timestamp