SystemCore/com.system32.systemCore.database.table/Table/select

select

fun select(builder: QueryBuilder.() -> Unit): List<Map<String, Any?>>

Select data from the table.

Parameters

builder

A lambda function to build the 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)
.addData(TableData.INT, "age")

usersTable.select {
   columns("username, email")
   where("age 18") //Or where("username = 'john_doe'")
}