TableDefinition

Defines the auto-incremented primary key.

try db.create(table: "player") { t in
    t.autoIncrementedPrimaryKey("id")
}

The auto-incremented primary key is an integer primary key that automatically generates unused values when you do not explicitly provide one, and prevents the reuse of ids over the lifetime of the database.

It is the preferred way to define a numeric primary key.

The fact that an auto-incremented primary key prevents the reuse of ids is an excellent guard against data races that could happen when your application processes ids in an asynchronous way. The auto-incremented primary key provides the guarantee that a given id can’t reference a row that is different from the one it used to be at the beginning of the asynchronous process, even if this row gets deleted and a new one is inserted in between.

See https://www.sqlite.org/lang_createtable.html#primkeyconst and https://www.sqlite.org/lang_createtable.html#rowid

Appends a table column.

try db.create(table: "player") { t in
    t.column("name", .text)
}

See https://www.sqlite.org/lang_createtable.html#tablecoldef

Defines the table primary key.

try db.create(table: "citizenship") { t in
    t.column("citizenID", .integer)
    t.column("countryCode", .text)
    t.primaryKey(["citizenID", "countryCode"])
}

See https://www.sqlite.org/lang_createtable.html#primkeyconst and https://www.sqlite.org/lang_createtable.html#rowid

Adds a unique key.

try db.create(table: "place") { t in
    t.column("latitude", .double)
    t.column("longitude", .double)
    t.uniqueKey(["latitude", "longitude"])
}

See https://www.sqlite.org/lang_createtable.html#uniqueconst

Adds a foreign key.

try db.create(table: "passport") { t in
    t.column("issueDate", .date)
    t.column("citizenID", .integer)
    t.column("countryCode", .text)
    t.foreignKey(["citizenID", "countryCode"], references: "citizenship", onDelete: .cascade)
}

See https://www.sqlite.org/foreignkeys.html

Adds a CHECK constraint.

try db.create(table: "player") { t in
    t.column("personalPhone", .text)
    t.column("workPhone", .text)
    let personalPhone = Column("personalPhone")
    let workPhone = Column("workPhone")
    t.check(personalPhone != nil || workPhone != nil)
}

See https://www.sqlite.org/lang_createtable.html#ckconst

Adds a CHECK constraint.

try db.create(table: "player") { t in
    t.column("personalPhone", .text)
    t.column("workPhone", .text)
    t.check(sql: "personalPhone IS NOT NULL OR workPhone IS NOT NULL")
}

See https://www.sqlite.org/lang_createtable.html#ckconst