TriggerDiffUpdateRecord<TOperationId>
Experimental Alpha
Represents a diff record for a SQLite UPDATE operation. This record contains the new value and optionally the previous value. Values are stored as JSON strings.
Extends
BaseTriggerDiffRecord<TOperationId>
Type Parameters
| Type Parameter | Default type |
|---|---|
TOperationId extends string | number | number |
Properties
| Property | Type | Description | Overrides | Inherited from |
|---|---|---|---|---|
id | string | Alpha The modified row's id column value. | - | BaseTriggerDiffRecord.id |
operation | UPDATE | Alpha The operation performed which created this record. | BaseTriggerDiffRecord.operation | - |
operation_id | TOperationId | Alpha Auto-incrementing primary key for the operation. Defaults to number as returned by database queries (wa-sqlite returns lower 32 bits). Can be string for full 64-bit precision when using { castOperationIdAsText: true } option. | - | BaseTriggerDiffRecord.operation_id |
previous_value | string | Alpha The previous value of the row in JSON string format. | - | - |
timestamp | string | Alpha Time the change operation was recorded. This is in ISO 8601 format, e.g. 2023-10-01T12:00:00.000Z. | - | BaseTriggerDiffRecord.timestamp |
value | string | Alpha The updated state of the row in JSON string format. | - | - |