Hello Swift Community,
GRDB, the "toolkit for SQLite databases, with a focus on application development" has been upgraded to version 4.6.0 - release notes.
This release brings batch updates to the query interface, so that you can update multiple rows in your database without writing SQL:
// UPDATE player SET score = 0 WHERE team = 'red'
try Player
.filter(teamColumn == "red")
.updateAll(db, scoreColumn <- 0)
// UPDATE player SET score = score + bonus
try Player.updateAll(db, scoreColumn += bonusColumn)
The API is heavily inspired by SQLite.swift by @stephencelis.
Happy GRDB!