Method UpdateTransactionMetadata

database/metadata.go:43–56

UpdateTransactionMetadata updates the metadata for a specific transaction in the database. It merges the provided metadata with existing metadata for each matching transaction. The update applies to both the transaction with the provided ID and any transactions where this ID is set as the parent_tra

(ctx context.Context, id string, metadata map[string]interface{})

// Returns:
// - error: An error if the update operation fails.
func (d *Datasource) UpdateTransactionMetadata(ctx context.Context, id string, metadata map[string]interface{}) error {
	metadataJSON, err := json.Marshal(metadata)
	if err != nil {
		return err
	}

	// Use jsonb_set or similar postgres function to merge the metadata rather than replacing it
	_, err = d.Conn.ExecContext(ctx, `
		UPDATE ledgerforge.transactions
		SET meta_data = meta_data || $1::jsonb
		WHERE transaction_id = $2 OR parent_transaction = $2
	`, metadataJSON, id)
	return err
}

// UpdateBalanceMetadata updates the metadata for a specific balance in the database.
// It marshals the metadata map to JSON before storing it.