Static Methodgrdb 7.1.0GRDB

updateAll(_:onConflict:_:)

Updates all records, and returns the number of updated records.

TableRecord.swift:655
@discardableResult static func updateAll(_ db: Database, onConflict conflictResolution: Database.ConflictResolution? = nil, _ assignments: [ColumnAssignment]) throws -> Int

Parameters

db

A database connection.

conflictResolution

A policy for conflict resolution, defaulting to the record’s persistenceConflictPolicy.

assignments

An array of column assignments.

Returns

The number of updated records.

Throws

A DatabaseError whenever an SQLite error occurs.

For example:

struct Player: TableRecord { }

try dbQueue.write { db in
    // UPDATE player SET score = 0
    try Player.updateAll(db, [Column("score").set(to: 0)])
}