delete

fun delete(builder: QueryBuilder.() -> Unit)

Deletes data from the table based on the given condition.

Parameters

builder

A lambda function to build the WHERE clause of the delete query.

Example usage:

val usersTable = database.addTable("users")
.addData(TableData.STRING, "username", TableFlag.PRIMARY_KEY, TableFlag.NON_NULL)
.addData(TableData.STRING, "email", TableFlag.NON_NULL)

usersTable.delete {
where("username = 'john_doe'")
}