KQLite/com.kqlite.migration/KQLiteSchema

KQLiteSchema

interface KQLiteSchema

Functions

alterTable

abstract fun alterTable(table: KQLiteTable): AlterTable

Initiates an ALTER TABLE operation on a specified table.

createIndex

abstract fun createIndex(table: KQLiteTable)

Creates all defined indexes for a given table.

createTable

abstract fun createTable(table: KQLiteTable)

Creates a new table in the database based on the provided table definition. This function generates and executes a CREATE TABLE SQL statement. It also automatically creates any indexes defined on the table.

createTableAs

abstract fun createTableAs(table: KQLiteTable, selectStatement: () -> SelectStatement<*>)

Creates a new table and populates it with the result set of a SELECT statement. This is equivalent to the SQL CREATE TABLE ... AS SELECT ... statement. The columns of the new table have the same names and declared types as the columns of the result set from the selectStatement.

createView

abstract fun createView(viewTable: KQLiteTable, selectStatement: () -> SelectStatement<*>)

Creates a new view in the database.

dropIndex

abstract fun dropIndex(indexName: String)

Drops an existing index from the database.

dropTable

abstract fun dropTable(tableName: String)

Drops an existing table from the database.

dropView

abstract fun dropView(viewName: String)

Drops an existing view from the database.