->patch()
Applies JSON Patch changes to all records, or a specific record, in the database.
Method Syntax
$db->patch($thing, $data, $diff)
This function patches the current document / record data with the specified JSON Patch data.
Arguments
| Arguments | Type | Description |
|---|
thing required | string, RecordId or StringRecordId
| The table name or the specific RecordId to patch. |
data optional | associative array | The JSON Patch data with which to patch the records. |
diff optional | boolean | Whether to return the diff of the patched record. |
Example usage
$people = $db->patch('person', [
[ "op" => 'replace', "path" => '/created_at', "value" => new Date() ],
]);
$person = $db->patch(new 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;
