api-docs / org.ktorm.support.sqlite
Package org.ktorm.support.sqlite
SQLite dialect module for Ktorm.
Types
Name | Summary |
---|---|
data class BulkInsertExpression : SqlExpression Bulk insert expression, represents a bulk insert statement in SQLite. | |
class BulkInsertOrUpdateStatementBuilder<T : BaseTable<*>> : DSL builder for bulk insert or update statements. | |
open class BulkInsertStatementBuilder<T : BaseTable<*>> DSL builder for bulk insert statements. | |
data class InsertOrUpdateExpression : SqlExpression Insert or update expression, represents an insert statement with an | |
class InsertOrUpdateOnConflictClauseBuilder : DSL builder for insert or update on conflict clause. | |
class InsertOrUpdateStatementBuilder : DSL builder for insert or update statements. | |
open class SQLiteAssignmentsBuilder : AssignmentsBuilder Base class of SQLite DSL builders, provide basic functions used to build assignments for insert or update DSL. | |
open class SQLiteDialect : SqlDialect SqlDialect implementation for SQLite database. | |
interface SQLiteExpressionVisitor : SqlExpressionVisitor Base interface designed to visit or modify SQLite expression trees using visitor pattern. | |
open class SQLiteFormatter : SqlFormatter implementation for SQLite, formatting SQL expressions as strings with their execution arguments. |
Functions
Name | Summary |
---|---|
fun <T : BaseTable<*>> Database.bulkInsert( Bulk insert records to the table and return the effected row count. | |
fun <T : BaseTable<*>> Database.bulkInsertOrUpdate( Bulk insert records to the table, determining if there is a key conflict while inserting each of them, | |
fun <T : BaseTable<*>, C : Any> Database.bulkInsertOrUpdateReturning( Bulk insert records to the table, determining if there is a key conflict while inserting each of them, fun <T : BaseTable<*>, C1 : Any, C2 : Any> Database.bulkInsertOrUpdateReturning( fun <T : BaseTable<*>, C1 : Any, C2 : Any, C3 : Any> Database.bulkInsertOrUpdateReturning( Bulk insert records to the table, determining if there is a key conflict while inserting each of them, | |
fun <T : BaseTable<*>, C : Any> Database.bulkInsertReturning( Bulk insert records to the table and return the specific column’s values. fun <T : BaseTable<*>, C1 : Any, C2 : Any> Database.bulkInsertReturning( fun <T : BaseTable<*>, C1 : Any, C2 : Any, C3 : Any> Database.bulkInsertReturning( Bulk insert records to the table and return the specific columns’ values. | |
fun <T : Any> ColumnDeclaring<T>.ifNull( fun <T : Any> ColumnDeclaring<T>.ifNull( SQLite ifnull function, translated to | |
fun <T : Any> iif( fun <T : Any> iif( SQLite iif function, translated to | |
fun <T : BaseTable<*>> Database.insertOrUpdate( Insert a record to the table, determining if there is a key conflict while it’s being inserted, and automatically | |
fun <T : BaseTable<*>, C : Any> Database.insertOrUpdateReturning( Insert a record to the table, determining if there is a key conflict while it’s being inserted, automatically fun <T : BaseTable<*>, C1 : Any, C2 : Any> Database.insertOrUpdateReturning( fun <T : BaseTable<*>, C1 : Any, C2 : Any, C3 : Any> Database.insertOrUpdateReturning( Insert a record to the table, determining if there is a key conflict while it’s being inserted, automatically | |
fun <T : BaseTable<*>, C : Any> Database.insertReturning( Insert a record to the table and return the specific column. fun <T : BaseTable<*>, C1 : Any, C2 : Any> Database.insertReturning( fun <T : BaseTable<*>, C1 : Any, C2 : Any, C3 : Any> Database.insertReturning( Insert a record to the table and return the specific columns. | |
fun ColumnDeclaring<String>.instr( fun ColumnDeclaring<String>.instr( SQLite instr function, translated to | |
fun <T : Any> ColumnDeclaring<*>.jsonExtract( SQLite json_extract function, translated to | |
fun ColumnDeclaring<*>.jsonPatch( SQLite json_patch function, translated to | |
fun ColumnDeclaring<*>.jsonRemove( SQLite json_remove function, translated to | |
fun ColumnDeclaring<*>.jsonValid(): FunctionExpression<Boolean> SQLite json_valid function, translated to | |
fun random(): FunctionExpression<Long> SQLite random function, translated to | |
fun ColumnDeclaring<String>.replace( SQLite replace function, translated to | |
fun ColumnDeclaring<String>.toLowerCase(): FunctionExpression<String> SQLite lower function, translated to | |
fun ColumnDeclaring<String>.toUpperCase(): FunctionExpression<String> SQLite upper function, translated to |