AllColumnsExcluding selects all columns in a database table, but the ones you specify.
struct AllColumnsExcludingFor example:
struct Player: TableRecord {
static var databaseSelection: [any SQLSelectable] {
[.allColumns(excluding: ["generatedColumn"])]
}
}
// SELECT id, name, score FROM player
Player.fetchAll(db)import GRDBA toolkit for SQLite databases, with a focus on application development
struct AllColumnsAllColumns is the * in SELECT *.
struct SQLSelectionAn SQL result column.
protocol CopyableA type whose values can be implicitly or explicitly copied.
protocol Escapableprotocol SQLSelectableA type that can be used as SQL result columns.
protocol Sendableinit(_ excludedColumns: some Collection<String>) var sqlSelection: SQLSelection { get }static func allColumns(excluding excludedColumns: some Collection<any ColumnExpression>) -> Self All columns of the requested table, excluding the provided columns.
static func allColumns(excluding excludedColumns: some Collection<String>) -> Self All columns of the requested table, excluding the provided columns.