.patch()
Applies JSON Patch changes to all records, or a specific record, in the database.
Method Syntaxasync db.patch<T,U>(thing, data)
NoteThis function patches the current document / record data with the specified JSON Patch data.
Arguments | Description | ||
---|---|---|---|
thing required | The table name or the specific | ||
data optional | The JSON Patch data with which to patch the records. |
// Update all records in a table const people = await db.patch('person', [ { op: 'replace', path: '/created_at', value: new Date() }, ]); // Update a record with a specific ID const person = await db.patch(new RecordId('person', 'tobie'), [ { op: 'replace', path: '/settings/active', value: false }, { op: 'add', path: '/tags', value: ['developer', 'engineer'] }, { op: 'remove', path: '/temp' }, ]);
This function will run the following query in the database.
UPDATE $thing PATCH $data;