.patch()

Applies JSON Patch changes to all records, or a specific record, in the database.

Method Syntax
db.patch(thing, data)

Note

This function patches the current document / record data with the specified JSON Patch data.

Arguments

Example usage

# Update all records in a table
await db.patch('person', [
	{ "op": 'replace', "path": '/created_at', "value": datetime.datetime.utcnow() },
])

# Update a record with a specific ID
await db.patch(RecordID('person', 'tobie'), [
	{ "op": 'replace', "path": '/settings/active', "value": false },
	{ "op": 'add', "path": '/tags', "value": ['developer', 'engineer'] },
	{ "op": 'remove', "path": '/temp' },
])

Translated query

This function will run the following query in the database.

UPDATE $thing PATCH $data;