Function buildCommentMessage

action/github/github.go:102–177

(resp *v1pb.CheckReleaseResponse)

}

func buildCommentMessage(resp *v1pb.CheckReleaseResponse) string {
	var errorCount, warningCount int
	for _, result := range resp.Results {
		for _, advice := range result.Advices {
			switch advice.Status {
			case v1pb.Advice_WARNING:
				warningCount++
			case v1pb.Advice_ERROR:
				errorCount++
			case v1pb.Advice_ADVICE_LEVEL_UNSPECIFIED, v1pb.Advice_SUCCESS:
				// No action needed
			default:
				// Ignore unknown advice statuses
			}
		}
	}

	var sb strings.Builder
	_, _ = sb.WriteString(commentHeader + "\n")
	_, _ = sb.WriteString("## SQL Review Summary\n\n")
	_, _ = fmt.Fprintf(&sb, "* Total Affected Rows: **%d**\n", resp.AffectedRows)
	_, _ = fmt.Fprintf(&sb, "* Overall Risk Level: **%s**\n", formatRiskLevel(resp.RiskLevel))
	_, _ = fmt.Fprintf(&sb, "* Advices Statistics: **%d Error(s), %d Warning(s)**\n", errorCount, warningCount)
	_, _ = sb.WriteString("### Detailed Results\n")
	_, _ = sb.WriteString(`
<table>
  <thead>
    <tr>
      <th>File</th>
      <th>Target</th>
      <th>Affected Rows</th>
      <th>Risk Level</th>
      <th>Advices</th>
    </tr>
  </thead>
  <tbody>`)
	for _, result := range resp.Results {
		if sb.Len() > maxCommentLength-1000 {
			break
		}
		var errorCount, warningCount int
		for _, advice := range result.Advices {
			switch advice.Status {
			case v1pb.Advice_WARNING:
				warningCount++
			case v1pb.Advice_ERROR:
				errorCount++
			case v1pb.Advice_ADVICE_LEVEL_UNSPECIFIED, v1pb.Advice_SUCCESS:
				// No action needed
			default:
				// Ignore unknown advice statuses
			}
		}
		counts := []string{}
		if errorCount > 0 {
			counts = append(counts, fmt.Sprintf("%d Error(s)", errorCount))
		}
		if warningCount > 0 {