Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

1.5 KB
Raw Blame
package azure

import (
	"fmt"

	"github.com/pkg/errors"

	"github.com/bytebase/bytebase/action/common"
	v1pb "github.com/bytebase/bytebase/backend/generated-go/v1"
)

func LoggingReleaseChecks(resp *v1pb.CheckReleaseResponse) error {
	if resp == nil || len(resp.Results) == 0 {
		fmt.Println("No check results found.")
		return nil
	}

	hasError := false
	hasWarning := false
	for _, result := range resp.Results {
		var advices []string
		for _, advice := range result.Advices {
			if advice.Status == v1pb.Advice_WARNING || advice.Status == v1pb.Advice_ERROR {
				advices = append(advices, advice.Content)
			}
		}

		if len(advices) > 0 {
			fmt.Printf("%s with %s has %d advices\n", result.File, result.Target, len(advices))
			for _, advice := range result.Advices {
				switch advice.Status {
				case v1pb.Advice_WARNING:
					hasWarning = true
				case v1pb.Advice_ERROR:
					hasError = true
				default:
					// Handle other advice statuses (SUCCESS, UNSPECIFIED) - no action needed
				}

				position := fmt.Sprintf("line %d", common.ConvertLineToActionLine(int(advice.GetStartPosition().GetLine())))
				fmt.Printf("* (%s) Code %d - %s (%s): %s\n", advice.Status.String(), advice.Code, advice.Title, position, advice.Content)
			}
		}
	}

	if hasError {
		// Azure Pipelines log command.
		fmt.Println("##vso[task.logissue type=error;]SQL review failed with errors")
	} else if hasWarning {
		fmt.Println("##vso[task.logissue type=warning;]SQL review has warnings")
	}

	if hasError {
		return errors.Errorf("SQL review failed with errors")
	}
	return nil
}