chore: default notification channel migration to remove ruleId and ruleSource

frontend/src/container/CreateAlertChannels/defaults.ts

@@ -6,6 +6,7 @@ export const PagerInitialConfig: Partial<PagerChannel> = {
 	  {{" "}}(
 	  {{- with .CommonLabels.Remove .GroupLabels.Names }}
 		{{- range $index, $label := .SortedPairs -}}
+		  {{- if or (eq $label.Name "ruleId") (eq $label.Name "ruleSource") }}{{ continue }}{{ end -}}
 		  {{ if $index }}, {{ end }}
 		  {{- $label.Name }}="{{ $label.Value -}}"
 		{{- end }}
@@ -30,7 +31,7 @@ export const OpsgenieInitialConfig: Partial<OpsgenieChannel> = {
 	{{ range .Alerts.Firing }}
 	 - Message: {{ .Annotations.description }}
 	Labels:
-	{{ range .Labels.SortedPairs }}   - {{ .Name }} = {{ .Value }}
+	{{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}}   - {{ .Name }} = {{ .Value }}
 	{{ end }}   Annotations:
 	{{ range .Annotations.SortedPairs }}   - {{ .Name }} = {{ .Value }}
 	{{ end }}   Source: {{ .GeneratorURL }}
@@ -41,7 +42,7 @@ export const OpsgenieInitialConfig: Partial<OpsgenieChannel> = {
 	{{ range .Alerts.Resolved }}
 	 - Message: {{ .Annotations.description }}
 	Labels:
-	{{ range .Labels.SortedPairs }}   - {{ .Name }} = {{ .Value }}
+	{{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}}   - {{ .Name }} = {{ .Value }}
 	{{ end }}   Annotations:
 	{{ range .Annotations.SortedPairs }}   - {{ .Name }} = {{ .Value }}
 	{{ end }}   Source: {{ .GeneratorURL }}
@@ -400,7 +401,7 @@ export const EmailInitialConfig: Partial<EmailChannel> = {
 					  <tr>
 						<td class="content-block">
 						  <strong>Labels</strong><br />
-						  {{ range .Labels.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  {{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}}{{ .Name }} = {{ .Value }}<br />{{ end }}
 						  {{ if gt (len .Annotations) 0 }}<strong>Annotations</strong><br />{{ end }}
 						  {{ range .Annotations.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
 						  <a href="{{ .GeneratorURL }}">Source</a><br />
@@ -427,7 +428,7 @@ export const EmailInitialConfig: Partial<EmailChannel> = {
 					  <tr>
 						<td class="content-block">
 						  <strong>Labels</strong><br />
-						  {{ range .Labels.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  {{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}}{{ .Name }} = {{ .Value }}<br />{{ end }}
 						  {{ if gt (len .Annotations) 0 }}<strong>Annotations</strong><br />{{ end }}
 						  {{ range .Annotations.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
 						  <a href="{{ .GeneratorURL }}">Source</a><br />

frontend/src/container/CreateAlertChannels/index.tsx

@@ -73,7 +73,7 @@ function CreateAlertChannels({
      *RelatedTraces:* {{ if gt (len .Annotations.related_traces) 0 -}} View in <{{ .Annotations.related_traces }}|traces explorer> {{- end}}
 
      *Details:*
-       {{ range .Labels.SortedPairs }} • *{{ .Name }}:* {{ .Value }}
+       {{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}} • *{{ .Name }}:* {{ .Value }}
        {{ end }}
      {{ end }}`,
 		title: `[{{ .Status | toUpper }}{{ if eq .Status "firing" }}:{{ .Alerts.Firing | len }}{{ end }}] {{ .CommonLabels.alertname }} for {{ .CommonLabels.job }}
@@ -81,6 +81,7 @@ function CreateAlertChannels({
        {{" "}}(
        {{- with .CommonLabels.Remove .GroupLabels.Names }}
          {{- range $index, $label := .SortedPairs -}}
+           {{- if or (eq $label.Name "ruleId") (eq $label.Name "ruleSource") }}{{ continue }}{{ end -}}
            {{ if $index }}, {{ end }}
            {{- $label.Name }}="{{ $label.Value -}}"
          {{- end }}

pkg/signoz/provider.go

@@ -195,6 +195,7 @@ func NewSQLMigrationProviderFactories(
 		sqlmigration.NewDeprecateAPIKeyFactory(sqlstore, sqlschema),
 		sqlmigration.NewServiceAccountAuthzactory(sqlstore),
 		sqlmigration.NewDropUserDeletedAtFactory(sqlstore, sqlschema),
+		sqlmigration.NewChannelTemplatesMigratorFactory(sqlstore),
 	)
 }
 

pkg/sqlmigration/077_update_default_channel_templates.go

@@ -0,0 +1,220 @@
+package sqlmigration
+
+import (
+	"context"
+	_ "embed"
+	"encoding/json"
+	"time"
+
+	"github.com/SigNoz/signoz/pkg/factory"
+	"github.com/SigNoz/signoz/pkg/sqlstore"
+	"github.com/SigNoz/signoz/pkg/types/alertmanagertypes"
+	"github.com/prometheus/alertmanager/config"
+	"github.com/uptrace/bun"
+	"github.com/uptrace/bun/migrate"
+)
+
+//go:embed templates/old_slack_text.tmpl
+var oldSlackTextTemplate string
+
+//go:embed templates/new_slack_text.tmpl
+var newSlackTextTemplate string
+
+//go:embed templates/old_slack_title.tmpl
+var oldSlackTitleTemplate string
+
+//go:embed templates/new_slack_title.tmpl
+var newSlackTitleTemplate string
+
+//go:embed templates/old_pagerduty_description.tmpl
+var oldPagerdutyDescriptionTemplate string
+
+//go:embed templates/new_pagerduty_description.tmpl
+var newPagerdutyDescriptionTemplate string
+
+//go:embed templates/old_opsgenie_description.tmpl
+var oldOpsgenieDescriptionTemplate string
+
+//go:embed templates/new_opsgenie_description.tmpl
+var newOpsgenieDescriptionTemplate string
+
+//go:embed templates/old_email_html.tmpl
+var oldEmailHTMLTemplate string
+
+//go:embed templates/new_email_html.tmpl
+var newEmailHTMLTemplate string
+
+type migrateDefaultChannelTemplates struct {
+	sqlstore sqlstore.SQLStore
+}
+
+func NewChannelTemplatesMigratorFactory(sqlstore sqlstore.SQLStore) factory.ProviderFactory[SQLMigration, Config] {
+	return factory.NewProviderFactory(
+		factory.MustNewName("update_channel_templates"),
+		func(ctx context.Context, ps factory.ProviderSettings, c Config) (SQLMigration, error) {
+			return &migrateDefaultChannelTemplates{sqlstore: sqlstore}, nil
+		},
+	)
+}
+
+func (m *migrateDefaultChannelTemplates) Register(migrations *migrate.Migrations) error {
+	return migrations.Register(m.Up, m.Down)
+}
+
+func (m *migrateDefaultChannelTemplates) Down(context.Context, *bun.DB) error { return nil }
+
+// patchReceiver walks the receiver's *Configs slices and performs exact-match
+// substitution on template fields. Returns true if any field was modified.
+func patchReceiver(receiver *config.Receiver) bool {
+	changed := false
+
+	for _, cfg := range receiver.SlackConfigs {
+		if cfg == nil {
+			continue
+		}
+		if cfg.Title == oldSlackTitleTemplate {
+			cfg.Title = newSlackTitleTemplate
+			changed = true
+		}
+		if cfg.Text == oldSlackTextTemplate {
+			cfg.Text = newSlackTextTemplate
+			changed = true
+		}
+	}
+
+	for _, cfg := range receiver.MSTeamsV2Configs {
+		if cfg == nil {
+			continue
+		}
+		if cfg.Title == oldSlackTitleTemplate {
+			cfg.Title = newSlackTitleTemplate
+			changed = true
+		}
+		if cfg.Text == oldSlackTextTemplate {
+			cfg.Text = newSlackTextTemplate
+			changed = true
+		}
+	}
+
+	for _, cfg := range receiver.PagerdutyConfigs {
+		if cfg == nil {
+			continue
+		}
+		if cfg.Description == oldPagerdutyDescriptionTemplate {
+			cfg.Description = newPagerdutyDescriptionTemplate
+			changed = true
+		}
+	}
+
+	for _, cfg := range receiver.OpsGenieConfigs {
+		if cfg == nil {
+			continue
+		}
+		if cfg.Description == oldOpsgenieDescriptionTemplate {
+			cfg.Description = newOpsgenieDescriptionTemplate
+			changed = true
+		}
+	}
+
+	for _, cfg := range receiver.EmailConfigs {
+		if cfg == nil {
+			continue
+		}
+		if cfg.HTML == oldEmailHTMLTemplate {
+			cfg.HTML = newEmailHTMLTemplate
+			changed = true
+		}
+	}
+
+	return changed
+}
+
+func (m *migrateDefaultChannelTemplates) Up(ctx context.Context, db *bun.DB) error {
+	tx, err := db.BeginTx(ctx, nil)
+	if err != nil {
+		return err
+	}
+
+	defer func() {
+		_ = tx.Rollback()
+	}()
+
+	// Rewrite notification_channel rows that match the old default template
+	var channels []*alertmanagertypes.Channel
+	if err := tx.NewSelect().Model(&channels).Scan(ctx); err != nil {
+		return err
+	}
+
+	for _, channel := range channels {
+		receiver, err := alertmanagertypes.NewReceiver(channel.Data)
+		if err != nil {
+			// Skip channels we cannot parse; leave them untouched
+			// migration is not responsible for invalid configs
+			continue
+		}
+
+		if !patchReceiver(&receiver) {
+			continue
+		}
+
+		data, err := json.Marshal(receiver)
+		if err != nil {
+			return err
+		}
+
+		channel.Data = string(data)
+		channel.UpdatedAt = time.Now()
+
+		if _, err := tx.NewUpdate().Model(channel).WherePK().Exec(ctx); err != nil {
+			return err
+		}
+	}
+
+	// Update the embedded receivers in alertmanager_config
+	var storeableConfigs []*alertmanagertypes.StoreableConfig
+	if err := tx.NewSelect().Model(&storeableConfigs).Scan(ctx); err != nil {
+		return err
+	}
+
+	for _, sc := range storeableConfigs {
+		cfg, err := alertmanagertypes.NewConfigFromStoreableConfig(sc)
+		if err != nil {
+			// Skip configs we cannot parse; leave them untouched
+			// migration is not responsible for invalid configs
+			continue
+		}
+
+		alertmanagerConfig := cfg.AlertmanagerConfig()
+		changed := false
+		for i := range alertmanagerConfig.Receivers {
+			if patchReceiver(&alertmanagerConfig.Receivers[i]) {
+				changed = true
+			}
+		}
+
+		if !changed {
+			continue
+		}
+
+		// UpdateReceiver for each config updates the hash and updated_at
+		for i := range alertmanagerConfig.Receivers {
+			if err := cfg.UpdateReceiver(alertmanagerConfig.Receivers[i]); err != nil {
+				return err
+			}
+		}
+
+		sc = cfg.StoreableConfig()
+		if _, err := tx.
+			NewInsert().
+			Model(sc).
+			On("CONFLICT (org_id) DO UPDATE").
+			Set("config = ?", sc.Config).
+			Set("hash = ?", sc.Hash).
+			Set("updated_at = ?", sc.UpdatedAt).
+			Exec(ctx); err != nil {
+			return err
+		}
+	}
+
+	return tx.Commit()
+}

pkg/sqlmigration/templates/new_email_html.tmpl

@@ -0,0 +1,392 @@
+<!--
+	Credits: https://github.com/mailgun/transactional-email-templates
+	-->
+  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+  <html xmlns="http://www.w3.org/1999/xhtml">
+	<head>
+	  <meta name="viewport" content="width=device-width" />
+	  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+	  <title>{{ template "__subject" . }}</title>
+	  <style>
+  
+		/* -------------------------------------
+			  GLOBAL
+			  A very basic CSS reset
+			  ------------------------------------- */
+		* {
+		  margin: 0;
+		  font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
+		  box-sizing: border-box;
+		  font-size: 14px;
+		}
+		
+		img {
+		  max-width: 100%;
+		}
+		
+		body {
+		  -webkit-font-smoothing: antialiased;
+		  -webkit-text-size-adjust: none;
+		  width: 100% !important;
+		  height: 100%;
+		  line-height: 1.6em;
+		  /* 1.6em * 14px = 22.4px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 22px;*/
+		}
+		
+		/* Let's make sure all tables have defaults */
+		table td {
+		  vertical-align: top;
+		}
+		
+		/* -------------------------------------
+			  BODY & CONTAINER
+			  ------------------------------------- */
+		body {
+		  background-color: #f6f6f6;
+		}
+		
+		.body-wrap {
+		  background-color: #f6f6f6;
+		  width: 100%;
+		}
+		
+		.container {
+		  display: block !important;
+		  max-width: 600px !important;
+		  margin: 0 auto !important;
+		  /* makes it centered */
+		  clear: both !important;
+		}
+		
+		.content {
+		  max-width: 600px;
+		  margin: 0 auto;
+		  display: block;
+		  padding: 20px;
+		}
+		
+		/* -------------------------------------
+			  HEADER, FOOTER, MAIN
+			  ------------------------------------- */
+		.main {
+		  background-color: #fff;
+		  border: 1px solid #e9e9e9;
+		  border-radius: 3px;
+		}
+		
+		.content-wrap {
+		  padding: 30px;
+		}
+		
+		.content-block {
+		  padding: 0 0 20px;
+		}
+		
+		.header {
+		  width: 100%;
+		  margin-bottom: 20px;
+		}
+		
+		.footer {
+		  width: 100%;
+		  clear: both;
+		  color: #999;
+		  padding: 20px;
+		}
+		
+		.footer p,
+		.footer a,
+		.footer td {
+		  color: #999;
+		  font-size: 12px;
+		}
+		
+		/* -------------------------------------
+			  TYPOGRAPHY
+			  ------------------------------------- */
+		h1,
+		h2,
+		h3 {
+		  font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif;
+		  color: #000;
+		  margin: 40px 0 0;
+		  line-height: 1.2em;
+		  font-weight: 400;
+		}
+		
+		h1 {
+		  font-size: 32px;
+		  font-weight: 500;
+		  /* 1.2em * 32px = 38.4px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 38px;*/
+		}
+		
+		h2 {
+		  font-size: 24px;
+		  /* 1.2em * 24px = 28.8px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 29px;*/
+		}
+		
+		h3 {
+		  font-size: 18px;
+		  /* 1.2em * 18px = 21.6px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 22px;*/
+		}
+		
+		h4 {
+		  font-size: 14px;
+		  font-weight: 600;
+		}
+		
+		p,
+		ul,
+		ol {
+		  margin-bottom: 10px;
+		  font-weight: normal;
+		}
+		
+		p li,
+		ul li,
+		ol li {
+		  margin-left: 5px;
+		  list-style-position: inside;
+		}
+		
+		/* -------------------------------------
+			  LINKS & BUTTONS
+			  ------------------------------------- */
+		a {
+		  color: #348eda;
+		  text-decoration: underline;
+		}
+		
+		.btn-primary {
+		  text-decoration: none;
+		  color: #FFF;
+		  background-color: #348eda;
+		  border: solid #348eda;
+		  border-width: 10px 20px;
+		  line-height: 2em;
+		  /* 2em * 14px = 28px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 28px;*/
+		  font-weight: bold;
+		  text-align: center;
+		  cursor: pointer;
+		  display: inline-block;
+		  border-radius: 5px;
+		  text-transform: capitalize;
+		}
+		
+		/* -------------------------------------
+			  OTHER STYLES THAT MIGHT BE USEFUL
+			  ------------------------------------- */
+		.last {
+		  margin-bottom: 0;
+		}
+		
+		.first {
+		  margin-top: 0;
+		}
+		
+		.aligncenter {
+		  text-align: center;
+		}
+		
+		.alignright {
+		  text-align: right;
+		}
+		
+		.alignleft {
+		  text-align: left;
+		}
+		
+		.clear {
+		  clear: both;
+		}
+		
+		/* -------------------------------------
+			  ALERTS
+			  Change the class depending on warning email, good email or bad email
+			  ------------------------------------- */
+		.alert {
+		  font-size: 16px;
+		  color: #fff;
+		  font-weight: 500;
+		  padding: 20px;
+		  text-align: center;
+		  border-radius: 3px 3px 0 0;
+		}
+		
+		.alert a {
+		  color: #fff;
+		  text-decoration: none;
+		  font-weight: 500;
+		  font-size: 16px;
+		}
+		
+		.alert.alert-warning {
+		  background-color: #E6522C;
+		}
+		
+		.alert.alert-bad {
+		  background-color: #D0021B;
+		}
+		
+		.alert.alert-good {
+		  background-color: #68B90F;
+		}
+		
+		/* -------------------------------------
+			  INVOICE
+			  Styles for the billing table
+			  ------------------------------------- */
+		.invoice {
+		  margin: 40px auto;
+		  text-align: left;
+		  width: 80%;
+		}
+		
+		.invoice td {
+		  padding: 5px 0;
+		}
+		
+		.invoice .invoice-items {
+		  width: 100%;
+		}
+		
+		.invoice .invoice-items td {
+		  border-top: #eee 1px solid;
+		}
+		
+		.invoice .invoice-items .total td {
+		  border-top: 2px solid #333;
+		  border-bottom: 2px solid #333;
+		  font-weight: 700;
+		}
+		
+		/* -------------------------------------
+			  RESPONSIVE AND MOBILE FRIENDLY STYLES
+			  ------------------------------------- */
+		@media only screen and (max-width: 640px) {
+		  body {
+			padding: 0 !important;
+		  }
+		
+		  h1,
+		  h2,
+		  h3,
+		  h4 {
+			font-weight: 800 !important;
+			margin: 20px 0 5px !important;
+		  }
+		
+		  h1 {
+			font-size: 22px !important;
+		  }
+		
+		  h2 {
+			font-size: 18px !important;
+		  }
+		
+		  h3 {
+			font-size: 16px !important;
+		  }
+		
+		  .container {
+			padding: 0 !important;
+			width: 100% !important;
+		  }
+		
+		  .content {
+			padding: 0 !important;
+		  }
+		
+		  .content-wrap {
+			padding: 10px !important;
+		  }
+		
+		  .invoice {
+			width: 100% !important;
+		  }
+		}
+		
+		</style>
+	</head>
+	<body itemscope itemtype="http://schema.org/EmailMessage">
+	  <table class="body-wrap">
+		<tr>
+		  <td></td>
+		  <td class="container" width="600">
+			<div class="content">
+			  <table class="main" width="100%" cellpadding="0" cellspacing="0">
+				<tr>
+				  {{ if gt (len .Alerts.Firing) 0 }}
+				  <td class="alert alert-warning">
+					{{ else }}
+				  <td class="alert alert-good">
+					{{ end }}
+					{{ .Alerts | len }} alert{{ if gt (len .Alerts) 1 }}s{{ end }} for {{ range .GroupLabels.SortedPairs }}
+					{{ .Name }}={{ .Value }} 
+					{{ end }}
+				  </td>
+				</tr>
+				<tr>
+				  <td class="content-wrap">
+					<table width="100%" cellpadding="0" cellspacing="0">
+					  {{ if gt (len .Alerts.Firing) 0 }}
+					  <tr>
+						<td class="content-block">
+						  <strong>[{{ .Alerts.Firing | len }}] Firing</strong>
+						</td>
+					  </tr>
+					  {{ end }}
+					  {{ range .Alerts.Firing }}
+					  <tr>
+						<td class="content-block">
+						  <strong>Labels</strong><br />
+						  {{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  {{ if gt (len .Annotations) 0 }}<strong>Annotations</strong><br />{{ end }}
+						  {{ range .Annotations.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  <a href="{{ .GeneratorURL }}">Source</a><br />
+						</td>
+					  </tr>
+					  {{ end }}
+					  {{ if gt (len .Alerts.Resolved) 0 }}
+					  {{ if gt (len .Alerts.Firing) 0 }}
+					  <tr>
+						<td class="content-block">
+						  <br />
+						  <hr />
+						  <br />
+						</td>
+					  </tr>
+					  {{ end }}
+					  <tr>
+						<td class="content-block">
+						  <strong>[{{ .Alerts.Resolved | len }}] Resolved</strong>
+						</td>
+					  </tr>
+					  {{ end }}
+					  {{ range .Alerts.Resolved }}
+					  <tr>
+						<td class="content-block">
+						  <strong>Labels</strong><br />
+						  {{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  {{ if gt (len .Annotations) 0 }}<strong>Annotations</strong><br />{{ end }}
+						  {{ range .Annotations.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  <a href="{{ .GeneratorURL }}">Source</a><br />
+						</td>
+					  </tr>
+					  {{ end }}
+					</table>
+				  </td>
+				</tr>
+			  </table>
+			</div>
+		  </td>
+		  <td></td>
+		</tr>
+	  </table>
+	</body>
+  </html>

pkg/sqlmigration/templates/new_opsgenie_description.tmpl

@@ -0,0 +1,22 @@
+{{ if gt (len .Alerts.Firing) 0 -}}
+	Alerts Firing:
+	{{ range .Alerts.Firing }}
+	 - Message: {{ .Annotations.description }}
+	Labels:
+	{{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}}   - {{ .Name }} = {{ .Value }}
+	{{ end }}   Annotations:
+	{{ range .Annotations.SortedPairs }}   - {{ .Name }} = {{ .Value }}
+	{{ end }}   Source: {{ .GeneratorURL }}
+	{{ end }}
+	{{- end }}
+	{{ if gt (len .Alerts.Resolved) 0 -}}
+	Alerts Resolved:
+	{{ range .Alerts.Resolved }}
+	 - Message: {{ .Annotations.description }}
+	Labels:
+	{{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}}   - {{ .Name }} = {{ .Value }}
+	{{ end }}   Annotations:
+	{{ range .Annotations.SortedPairs }}   - {{ .Name }} = {{ .Value }}
+	{{ end }}   Source: {{ .GeneratorURL }}
+	{{ end }}
+	{{- end }}

pkg/sqlmigration/templates/new_pagerduty_description.tmpl

@@ -0,0 +1,12 @@
+[{{ .Status | toUpper }}{{ if eq .Status "firing" }}:{{ .Alerts.Firing | len }}{{ end }}] {{ .CommonLabels.alertname }} for {{ .CommonLabels.job }}
+	{{- if gt (len .CommonLabels) (len .GroupLabels) -}}
+	  {{" "}}(
+	  {{- with .CommonLabels.Remove .GroupLabels.Names }}
+		{{- range $index, $label := .SortedPairs -}}
+		  {{- if or (eq $label.Name "ruleId") (eq $label.Name "ruleSource") }}{{ continue }}{{ end -}}
+		  {{ if $index }}, {{ end }}
+		  {{- $label.Name }}="{{ $label.Value -}}"
+		{{- end }}
+	  {{- end -}}
+	  )
+	{{- end }}

pkg/sqlmigration/templates/new_slack_text.tmpl

@@ -0,0 +1,12 @@
+{{ range .Alerts -}}
+     *Alert:* {{ .Labels.alertname }}{{ if .Labels.severity }} - {{ .Labels.severity }}{{ end }}
+
+     *Summary:* {{ .Annotations.summary }}
+     *Description:* {{ .Annotations.description }}
+     *RelatedLogs:* {{ if gt (len .Annotations.related_logs) 0 -}} View in <{{ .Annotations.related_logs }}|logs explorer> {{- end}}
+     *RelatedTraces:* {{ if gt (len .Annotations.related_traces) 0 -}} View in <{{ .Annotations.related_traces }}|traces explorer> {{- end}}
+
+     *Details:*
+       {{ range .Labels.SortedPairs }}{{- if or (eq .Name "ruleId") (eq .Name "ruleSource") }}{{ continue }}{{ end -}} • *{{ .Name }}:* {{ .Value }}
+       {{ end }}
+     {{ end }}

pkg/sqlmigration/templates/new_slack_title.tmpl

@@ -0,0 +1,12 @@
+[{{ .Status | toUpper }}{{ if eq .Status "firing" }}:{{ .Alerts.Firing | len }}{{ end }}] {{ .CommonLabels.alertname }} for {{ .CommonLabels.job }}
+     {{- if gt (len .CommonLabels) (len .GroupLabels) -}}
+       {{" "}}(
+       {{- with .CommonLabels.Remove .GroupLabels.Names }}
+         {{- range $index, $label := .SortedPairs -}}
+           {{- if or (eq $label.Name "ruleId") (eq $label.Name "ruleSource") }}{{ continue }}{{ end -}}
+           {{ if $index }}, {{ end }}
+           {{- $label.Name }}="{{ $label.Value -}}"
+         {{- end }}
+       {{- end -}}
+       )
+     {{- end }}

pkg/sqlmigration/templates/old_email_html.tmpl

@@ -0,0 +1,392 @@
+<!--
+	Credits: https://github.com/mailgun/transactional-email-templates
+	-->
+  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+  <html xmlns="http://www.w3.org/1999/xhtml">
+	<head>
+	  <meta name="viewport" content="width=device-width" />
+	  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
+	  <title>{{ template "__subject" . }}</title>
+	  <style>
+  
+		/* -------------------------------------
+			  GLOBAL
+			  A very basic CSS reset
+			  ------------------------------------- */
+		* {
+		  margin: 0;
+		  font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
+		  box-sizing: border-box;
+		  font-size: 14px;
+		}
+		
+		img {
+		  max-width: 100%;
+		}
+		
+		body {
+		  -webkit-font-smoothing: antialiased;
+		  -webkit-text-size-adjust: none;
+		  width: 100% !important;
+		  height: 100%;
+		  line-height: 1.6em;
+		  /* 1.6em * 14px = 22.4px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 22px;*/
+		}
+		
+		/* Let's make sure all tables have defaults */
+		table td {
+		  vertical-align: top;
+		}
+		
+		/* -------------------------------------
+			  BODY & CONTAINER
+			  ------------------------------------- */
+		body {
+		  background-color: #f6f6f6;
+		}
+		
+		.body-wrap {
+		  background-color: #f6f6f6;
+		  width: 100%;
+		}
+		
+		.container {
+		  display: block !important;
+		  max-width: 600px !important;
+		  margin: 0 auto !important;
+		  /* makes it centered */
+		  clear: both !important;
+		}
+		
+		.content {
+		  max-width: 600px;
+		  margin: 0 auto;
+		  display: block;
+		  padding: 20px;
+		}
+		
+		/* -------------------------------------
+			  HEADER, FOOTER, MAIN
+			  ------------------------------------- */
+		.main {
+		  background-color: #fff;
+		  border: 1px solid #e9e9e9;
+		  border-radius: 3px;
+		}
+		
+		.content-wrap {
+		  padding: 30px;
+		}
+		
+		.content-block {
+		  padding: 0 0 20px;
+		}
+		
+		.header {
+		  width: 100%;
+		  margin-bottom: 20px;
+		}
+		
+		.footer {
+		  width: 100%;
+		  clear: both;
+		  color: #999;
+		  padding: 20px;
+		}
+		
+		.footer p,
+		.footer a,
+		.footer td {
+		  color: #999;
+		  font-size: 12px;
+		}
+		
+		/* -------------------------------------
+			  TYPOGRAPHY
+			  ------------------------------------- */
+		h1,
+		h2,
+		h3 {
+		  font-family: "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif;
+		  color: #000;
+		  margin: 40px 0 0;
+		  line-height: 1.2em;
+		  font-weight: 400;
+		}
+		
+		h1 {
+		  font-size: 32px;
+		  font-weight: 500;
+		  /* 1.2em * 32px = 38.4px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 38px;*/
+		}
+		
+		h2 {
+		  font-size: 24px;
+		  /* 1.2em * 24px = 28.8px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 29px;*/
+		}
+		
+		h3 {
+		  font-size: 18px;
+		  /* 1.2em * 18px = 21.6px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 22px;*/
+		}
+		
+		h4 {
+		  font-size: 14px;
+		  font-weight: 600;
+		}
+		
+		p,
+		ul,
+		ol {
+		  margin-bottom: 10px;
+		  font-weight: normal;
+		}
+		
+		p li,
+		ul li,
+		ol li {
+		  margin-left: 5px;
+		  list-style-position: inside;
+		}
+		
+		/* -------------------------------------
+			  LINKS & BUTTONS
+			  ------------------------------------- */
+		a {
+		  color: #348eda;
+		  text-decoration: underline;
+		}
+		
+		.btn-primary {
+		  text-decoration: none;
+		  color: #FFF;
+		  background-color: #348eda;
+		  border: solid #348eda;
+		  border-width: 10px 20px;
+		  line-height: 2em;
+		  /* 2em * 14px = 28px, use px to get airier line-height also in Thunderbird, and Yahoo!, Outlook.com, AOL webmail clients */
+		  /*line-height: 28px;*/
+		  font-weight: bold;
+		  text-align: center;
+		  cursor: pointer;
+		  display: inline-block;
+		  border-radius: 5px;
+		  text-transform: capitalize;
+		}
+		
+		/* -------------------------------------
+			  OTHER STYLES THAT MIGHT BE USEFUL
+			  ------------------------------------- */
+		.last {
+		  margin-bottom: 0;
+		}
+		
+		.first {
+		  margin-top: 0;
+		}
+		
+		.aligncenter {
+		  text-align: center;
+		}
+		
+		.alignright {
+		  text-align: right;
+		}
+		
+		.alignleft {
+		  text-align: left;
+		}
+		
+		.clear {
+		  clear: both;
+		}
+		
+		/* -------------------------------------
+			  ALERTS
+			  Change the class depending on warning email, good email or bad email
+			  ------------------------------------- */
+		.alert {
+		  font-size: 16px;
+		  color: #fff;
+		  font-weight: 500;
+		  padding: 20px;
+		  text-align: center;
+		  border-radius: 3px 3px 0 0;
+		}
+		
+		.alert a {
+		  color: #fff;
+		  text-decoration: none;
+		  font-weight: 500;
+		  font-size: 16px;
+		}
+		
+		.alert.alert-warning {
+		  background-color: #E6522C;
+		}
+		
+		.alert.alert-bad {
+		  background-color: #D0021B;
+		}
+		
+		.alert.alert-good {
+		  background-color: #68B90F;
+		}
+		
+		/* -------------------------------------
+			  INVOICE
+			  Styles for the billing table
+			  ------------------------------------- */
+		.invoice {
+		  margin: 40px auto;
+		  text-align: left;
+		  width: 80%;
+		}
+		
+		.invoice td {
+		  padding: 5px 0;
+		}
+		
+		.invoice .invoice-items {
+		  width: 100%;
+		}
+		
+		.invoice .invoice-items td {
+		  border-top: #eee 1px solid;
+		}
+		
+		.invoice .invoice-items .total td {
+		  border-top: 2px solid #333;
+		  border-bottom: 2px solid #333;
+		  font-weight: 700;
+		}
+		
+		/* -------------------------------------
+			  RESPONSIVE AND MOBILE FRIENDLY STYLES
+			  ------------------------------------- */
+		@media only screen and (max-width: 640px) {
+		  body {
+			padding: 0 !important;
+		  }
+		
+		  h1,
+		  h2,
+		  h3,
+		  h4 {
+			font-weight: 800 !important;
+			margin: 20px 0 5px !important;
+		  }
+		
+		  h1 {
+			font-size: 22px !important;
+		  }
+		
+		  h2 {
+			font-size: 18px !important;
+		  }
+		
+		  h3 {
+			font-size: 16px !important;
+		  }
+		
+		  .container {
+			padding: 0 !important;
+			width: 100% !important;
+		  }
+		
+		  .content {
+			padding: 0 !important;
+		  }
+		
+		  .content-wrap {
+			padding: 10px !important;
+		  }
+		
+		  .invoice {
+			width: 100% !important;
+		  }
+		}
+		
+		</style>
+	</head>
+	<body itemscope itemtype="http://schema.org/EmailMessage">
+	  <table class="body-wrap">
+		<tr>
+		  <td></td>
+		  <td class="container" width="600">
+			<div class="content">
+			  <table class="main" width="100%" cellpadding="0" cellspacing="0">
+				<tr>
+				  {{ if gt (len .Alerts.Firing) 0 }}
+				  <td class="alert alert-warning">
+					{{ else }}
+				  <td class="alert alert-good">
+					{{ end }}
+					{{ .Alerts | len }} alert{{ if gt (len .Alerts) 1 }}s{{ end }} for {{ range .GroupLabels.SortedPairs }}
+					{{ .Name }}={{ .Value }} 
+					{{ end }}
+				  </td>
+				</tr>
+				<tr>
+				  <td class="content-wrap">
+					<table width="100%" cellpadding="0" cellspacing="0">
+					  {{ if gt (len .Alerts.Firing) 0 }}
+					  <tr>
+						<td class="content-block">
+						  <strong>[{{ .Alerts.Firing | len }}] Firing</strong>
+						</td>
+					  </tr>
+					  {{ end }}
+					  {{ range .Alerts.Firing }}
+					  <tr>
+						<td class="content-block">
+						  <strong>Labels</strong><br />
+						  {{ range .Labels.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  {{ if gt (len .Annotations) 0 }}<strong>Annotations</strong><br />{{ end }}
+						  {{ range .Annotations.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  <a href="{{ .GeneratorURL }}">Source</a><br />
+						</td>
+					  </tr>
+					  {{ end }}
+					  {{ if gt (len .Alerts.Resolved) 0 }}
+					  {{ if gt (len .Alerts.Firing) 0 }}
+					  <tr>
+						<td class="content-block">
+						  <br />
+						  <hr />
+						  <br />
+						</td>
+					  </tr>
+					  {{ end }}
+					  <tr>
+						<td class="content-block">
+						  <strong>[{{ .Alerts.Resolved | len }}] Resolved</strong>
+						</td>
+					  </tr>
+					  {{ end }}
+					  {{ range .Alerts.Resolved }}
+					  <tr>
+						<td class="content-block">
+						  <strong>Labels</strong><br />
+						  {{ range .Labels.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  {{ if gt (len .Annotations) 0 }}<strong>Annotations</strong><br />{{ end }}
+						  {{ range .Annotations.SortedPairs }}{{ .Name }} = {{ .Value }}<br />{{ end }}
+						  <a href="{{ .GeneratorURL }}">Source</a><br />
+						</td>
+					  </tr>
+					  {{ end }}
+					</table>
+				  </td>
+				</tr>
+			  </table>
+			</div>
+		  </td>
+		  <td></td>
+		</tr>
+	  </table>
+	</body>
+  </html>

pkg/sqlmigration/templates/old_opsgenie_description.tmpl

@@ -0,0 +1,22 @@
+{{ if gt (len .Alerts.Firing) 0 -}}
+	Alerts Firing:
+	{{ range .Alerts.Firing }}
+	 - Message: {{ .Annotations.description }}
+	Labels:
+	{{ range .Labels.SortedPairs }}   - {{ .Name }} = {{ .Value }}
+	{{ end }}   Annotations:
+	{{ range .Annotations.SortedPairs }}   - {{ .Name }} = {{ .Value }}
+	{{ end }}   Source: {{ .GeneratorURL }}
+	{{ end }}
+	{{- end }}
+	{{ if gt (len .Alerts.Resolved) 0 -}}
+	Alerts Resolved:
+	{{ range .Alerts.Resolved }}
+	 - Message: {{ .Annotations.description }}
+	Labels:
+	{{ range .Labels.SortedPairs }}   - {{ .Name }} = {{ .Value }}
+	{{ end }}   Annotations:
+	{{ range .Annotations.SortedPairs }}   - {{ .Name }} = {{ .Value }}
+	{{ end }}   Source: {{ .GeneratorURL }}
+	{{ end }}
+	{{- end }}

pkg/sqlmigration/templates/old_pagerduty_description.tmpl

@@ -0,0 +1,11 @@
+[{{ .Status | toUpper }}{{ if eq .Status "firing" }}:{{ .Alerts.Firing | len }}{{ end }}] {{ .CommonLabels.alertname }} for {{ .CommonLabels.job }}
+	{{- if gt (len .CommonLabels) (len .GroupLabels) -}}
+	  {{" "}}(
+	  {{- with .CommonLabels.Remove .GroupLabels.Names }}
+		{{- range $index, $label := .SortedPairs -}}
+		  {{ if $index }}, {{ end }}
+		  {{- $label.Name }}="{{ $label.Value -}}"
+		{{- end }}
+	  {{- end -}}
+	  )
+	{{- end }}

pkg/sqlmigration/templates/old_slack_text.tmpl

@@ -0,0 +1,12 @@
+{{ range .Alerts -}}
+     *Alert:* {{ .Labels.alertname }}{{ if .Labels.severity }} - {{ .Labels.severity }}{{ end }}
+
+     *Summary:* {{ .Annotations.summary }}
+     *Description:* {{ .Annotations.description }}
+     *RelatedLogs:* {{ if gt (len .Annotations.related_logs) 0 -}} View in <{{ .Annotations.related_logs }}|logs explorer> {{- end}}
+     *RelatedTraces:* {{ if gt (len .Annotations.related_traces) 0 -}} View in <{{ .Annotations.related_traces }}|traces explorer> {{- end}}
+
+     *Details:*
+       {{ range .Labels.SortedPairs }} • *{{ .Name }}:* {{ .Value }}
+       {{ end }}
+     {{ end }}

pkg/sqlmigration/templates/old_slack_title.tmpl

@@ -0,0 +1,11 @@
+[{{ .Status | toUpper }}{{ if eq .Status "firing" }}:{{ .Alerts.Firing | len }}{{ end }}] {{ .CommonLabels.alertname }} for {{ .CommonLabels.job }}
+     {{- if gt (len .CommonLabels) (len .GroupLabels) -}}
+       {{" "}}(
+       {{- with .CommonLabels.Remove .GroupLabels.Names }}
+         {{- range $index, $label := .SortedPairs -}}
+           {{ if $index }}, {{ end }}
+           {{- $label.Name }}="{{ $label.Value -}}"
+         {{- end }}
+       {{- end -}}
+       )
+     {{- end }}