KSql Client Implementor
Functions
Link copied to clipboard
@NewChain
Content copied to clipboard
Link copied to clipboard
abstract fun <E : Any> createDelete(entityType: KClass<E>, block: KMutableDelete<E>.() -> Unit): KExecutable<Int>
Content copied to clipboard
Link copied to clipboard
open fun <E : Any, R> createQuery(entityType: KClass<E>, block: KMutableRootQuery<E>.() -> KConfigurableRootQuery<E, R>): KConfigurableRootQuery<E, R>
Content copied to clipboard
Link copied to clipboard
abstract fun <E : Any> createUpdate(entityType: KClass<E>, block: KMutableUpdate<E>.() -> Unit): KExecutable<Int>
Content copied to clipboard
Link copied to clipboard
open fun <E : Any> deleteById(type: KClass<E>, id: Any, block: KDeleteCommandDsl.() -> Unit): KDeleteResult
Content copied to clipboard
open fun <E : Any> deleteById(type: KClass<E>, id: Any, mode: DeleteMode = DeleteMode.AUTO): KDeleteResult
Content copied to clipboard
Link copied to clipboard
open fun <E : Any> deleteByIds(type: KClass<E>, ids: Iterable<*>, block: KDeleteCommandDsl.() -> Unit): KDeleteResult
Content copied to clipboard
open fun <E : Any> deleteByIds(type: KClass<E>, ids: Iterable<*>, mode: DeleteMode = DeleteMode.AUTO): KDeleteResult
Content copied to clipboard
Link copied to clipboard
Link copied to clipboard
open fun <E : Any> executeDelete(entityType: KClass<E>, con: Connection? = null, block: KMutableDelete<E>.() -> Unit): Int
Content copied to clipboard
Link copied to clipboard
open fun <E : Any, R> executeQuery(entityType: KClass<E>, limit: Int? = null, con: Connection? = null, block: KMutableRootQuery<E>.() -> KConfigurableRootQuery<E, R>): List<R>
Content copied to clipboard
Link copied to clipboard
open fun <E : Any> executeUpdate(entityType: KClass<E>, con: Connection? = null, block: KMutableUpdate<E>.() -> Unit): Int
Content copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
open fun <E : Any, V : View<E>> findOneOrNull(viewType: KClass<V>, con: Connection? = null, block: KMutableRootQuery<E>.() -> Unit): V?
Content copied to clipboard
open fun <E : Any> findOneOrNull(fetcher: Fetcher<E>, con: Connection? = null, block: KMutableRootQuery<E>.() -> Unit): E?
Content copied to clipboard
Link copied to clipboard
Link copied to clipboard
-
If trigger type is 'BINLOG_ONLY'
- If `transaction` is true, throws exception
- If `transaction` is false, return binlog trigger
- If trigger type is 'TRANSACTION_ONLY', returns transaction trigger no matter what the `transaction` is
-
If trigger type is 'BOTH'
- If `transaction` is true, return transaction trigger
- If `transaction` is false, return binlog trigger
Link copied to clipboard
Link copied to clipboard
open fun <E : Any> insert(entity: E, associatedMode: AssociatedSaveMode = AssociatedSaveMode.APPEND, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Insert an entity object
open fun <E : Any> insert(input: Input<E>, associatedMode: AssociatedSaveMode = AssociatedSaveMode.APPEND, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Insert an input DTO
Link copied to clipboard
open fun <E : Any> insertIfAbsent(entity: E, associatedMode: AssociatedSaveMode = AssociatedSaveMode.APPEND_IF_ABSENT, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Insert an entity object if necessary, if the entity object exists in database, ignore it.
open fun <E : Any> insertIfAbsent(input: Input<E>, associatedMode: AssociatedSaveMode = AssociatedSaveMode.APPEND_IF_ABSENT, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Insert an input DTO if necessary, that means to convert the input DTO to entity object and save it. If the entity object exists in database, ignore it.
Link copied to clipboard
open fun <E : Any> merge(entity: E, associatedMode: AssociatedSaveMode = AssociatedSaveMode.MERGE, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Merge an entity object
open fun <E : Any> merge(input: Input<E>, associatedMode: AssociatedSaveMode = AssociatedSaveMode.MERGE, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Merge an input DTO
Link copied to clipboard
open fun <E : Any> save(entity: E, block: KSaveCommandDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
open fun <E : Any> save(entity: E, associatedMode: AssociatedSaveMode, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
open fun <E : Any> save(entity: E, mode: SaveMode, associatedMode: AssociatedSaveMode = AssociatedSaveMode.REPLACE, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Save an entity object
open fun <E : Any> save(input: Input<E>, block: KSaveCommandDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
open fun <E : Any> save(input: Input<E>, associatedMode: AssociatedSaveMode = AssociatedSaveMode.REPLACE, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
open fun <E : Any> save(input: Input<E>, mode: SaveMode, associatedMode: AssociatedSaveMode = AssociatedSaveMode.REPLACE, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Save an input DTO
Link copied to clipboard
open fun <E : Any> saveEntities(entities: Iterable<E>, block: KSaveCommandDsl.() -> Unit? = null): KBatchSaveResult<E>
Content copied to clipboard
Save some entity objects
Link copied to clipboard
open fun <E : Any> saveInputs(inputs: Iterable<Input<E>>, block: KSaveCommandDsl.() -> Unit? = null): KBatchSaveResult<E>
Content copied to clipboard
Save some input DTOs
Link copied to clipboard
open fun <E : Any> update(entity: E, associatedMode: AssociatedSaveMode = AssociatedSaveMode.UPDATE, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Update an entity object
open fun <E : Any> update(input: Input<E>, associatedMode: AssociatedSaveMode = AssociatedSaveMode.UPDATE, block: KSaveCommandPartialDsl.() -> Unit? = null): KSimpleSaveResult<E>
Content copied to clipboard
Update an input DTO