Template body

mtojek · mtojek · commit 39d80eb7f3e3 · 2024-09-03T14:55:28.000+02:00
diff --git a/coderd/database/migrations/000249_email_reports.down.sql b/coderd/database/migrations/000249_email_reports.down.sql
@@ -0,0 +1 @@
+DELETE FROM notification_templates WHERE id = 'b02ddd82-4733-4d02-a2d7-c36f3598997d';
diff --git a/coderd/database/migrations/000249_email_reports.up.sql b/coderd/database/migrations/000249_email_reports.up.sql
@@ -0,0 +1,22 @@
+INSERT INTO notification_templates (id, name, title_template, body_template, "group", actions)
+VALUES ('bc0d9b9c-6dca-40a7-a209-fb2681e3341a', 'Report: Workspace Builds Failed For Template', E'Workspace builds failed for template "{{.Labels.template_display_name}}"',
+        E'Hi {{.UserName}},
+
+Template {{.Labels.template_display_name}} has failed to build {{.Labels.failed_builds})/{{.Labels.total_builds}} times over the last {{.Labels.report_frequency}} and may be unstable.
+
+**Report:**
+
+{{range $index, $version := .Labels.template_versions}}
+  {{add $index 1}}. "{{$version.TemplateDisplayName}}" failed {{$version.FailedCount}} time{{if gt $version.FailedCount 1}}s{{end}}:
+  {{range $i, $build := $version.FailedBuilds}}
+    * [{{$build.WorkspaceOwnerUsername}} / {{$build.WorkspaceName}} / #{{$build.BuildNumber}}]({{base_url}}/@{{$build.WorkspaceOwnerUsername}}/{{$build.WorkspaceName}}/builds/{{$build.BuildNumber}})
+  {{end}}
+{{end}}
+
+We recommend reviewing these issues to ensure future builds are successful.',
+        'Template Events', '[
+        {
+            "label": "View workspaces",
+            "url": "{{ base_url }}/workspaces?filter=template%3A{{.Labels.template_name}}"
+        }
+    ]'::jsonb);

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+DELETE FROM notification_templates WHERE id = 'b02ddd82-4733-4d02-a2d7-c36f3598997d';`