KQLite/com.kqlite.constraint/ConstraintBuilder

ConstraintBuilder

Provides a Kotlin DSL for defining table-level constraints within a KQLiteTable definition.

This interface is the receiver for the KQLiteTable.constraints lambda in a table definition, allowing you to declaratively specify constraints like PRIMARY KEY, UNIQUE, CHECK, and FOREIGN KEY.

Following constraints can be created:

Example

object MyTable : KQLiteTable("my_table") {
    val id = longColumn("id")
    val email = textColumn("email").notNull()
    val score = integerColumn("score")

    override val constraints: (ConstraintBuilder.() -> Unit)? = {
        // Define a named primary key
        primaryKey(id)

        // Define a unique constraint without name on the email column
        unique(email).onConflict(Action.REPLACE)

        // Define a check constraint by name that can be deleted later
        constraint("score_validation").check { score GTE 0 }
    }
}