GeneratedColumnQualification
The kind of a generated column.
enum GeneratedColumnQualification
Related SQLite documentation: https://sqlite.org/gencol.html#virtual_versus_stored_columns
The kind of a generated column.
enum GeneratedColumnQualification
Related SQLite documentation: https://sqlite.org/gencol.html#virtual_versus_stored_columns
import GRDB
A toolkit for SQLite databases, with a focus on application development
final class ColumnDefinition
Describes a database column.
case virtual
A VIRTUAL
generated column.
case stored
A STORED
generated column.
@discardableResult func generatedAs(_ expression: some SQLExpressible, _ qualification: GeneratedColumnQualification = .virtual) -> Self
Defines the column as a generated column.
@discardableResult func generatedAs(sql: String, _ qualification: GeneratedColumnQualification = .virtual) -> Self
Defines the column as a generated column.
@discardableResult func check(_ condition: (Column) -> any SQLExpressible) -> Self
Adds a check constraint.
@discardableResult func check(sql: String) -> Self
Adds a check constraint.
@discardableResult func collate(_ collation: DatabaseCollation) -> Self
Defines the default collation.
@discardableResult func collate(_ collation: Database.CollationName) -> Self
Defines the default collation.
@discardableResult func defaults(sql: String) -> Self
Defines the default value.
@discardableResult func defaults(to value: some DatabaseValueConvertible) -> Self
Defines the default value.
@discardableResult func indexed() -> Self
Adds an index.
@discardableResult func notNull(onConflict conflictResolution: Database.ConflictResolution? = nil) -> Self
Adds a not null constraint.
@discardableResult func primaryKey(onConflict conflictResolution: Database.ConflictResolution? = nil, autoincrement: Bool = false) -> Self
Adds a primary key constraint.
@discardableResult func references(_ table: String, column: String? = nil, onDelete deleteAction: Database.ForeignKeyAction? = nil, onUpdate updateAction: Database.ForeignKeyAction? = nil, deferred isDeferred: Bool = false) -> Self
Adds a foreign key constraint.
@discardableResult func unique(onConflict conflictResolution: Database.ConflictResolution? = nil) -> Self
Adds a unique constraint.
protocol Equatable
A type that can be compared for value equality.
protocol Hashable : Equatable
A type that can be hashed into a Hasher
to produce an integer hash value.
protocol Sendable
static func != (lhs: Self, rhs: Self) -> Bool
Returns a Boolean value indicating whether two values are not equal.