Method DeleteMatchingRule

database/reconciliation.go:535–560

DeleteMatchingRule deletes a specific matching rule from the database. Parameters: - ctx: Context for managing the request and tracing. - id: The ID of the matching rule to be deleted. Returns: - An error wrapped in an APIError if the operation fails, or nil if the deletion is successful.

(ctx context.Context, id string)

// Returns:
// - An error wrapped in an APIError if the operation fails, or nil if the deletion is successful.
func (d Datasource) DeleteMatchingRule(ctx context.Context, id string) error {
	ctx, span := otel.Tracer("reconciliation.database").Start(ctx, "Deleting matching rule")
	defer span.End()

	// Execute the SQL delete statement
	result, err := d.Conn.ExecContext(ctx, `
		DELETE FROM ledgerforge.matching_rules
		WHERE rule_id = $1
	`, id)
	if err != nil {
		return apierror.NewAPIError(apierror.ErrInternalServer, "Failed to delete matching rule", err)
	}

	// Check how many rows were affected
	rowsAffected, err := result.RowsAffected()
	if err != nil {
		return apierror.NewAPIError(apierror.ErrInternalServer, "Failed to get rows affected", err)
	}

	// If no rows were affected, return a NotFound error
	if rowsAffected == 0 {
		return apierror.NewAPIError(apierror.ErrNotFound, fmt.Sprintf("Matching rule with ID '%s' not found", id), nil)
	}

	return nil
}

// GetMatchingRule retrieves a specific matching rule from the database by its rule ID.
// Parameters: