GetFailedWorkspaceBuildsByTemplateID

mtojek · mtojek · commit 0cdf3eaf5df5 · 2024-09-16T14:21:08.000+02:00
diff --git a/coderd/database/dbmem/dbmem.go b/coderd/database/dbmem/dbmem.go
@@ -2592,6 +2592,12 @@ func (q *FakeQuerier) GetFailedWorkspaceBuildsByTemplateID(ctx context.Context,
 		})
 	}
 
+	sort.Slice(workspaceBuildStats, func(i, j int) bool {
+		if workspaceBuildStats[i].TemplateVersionName != workspaceBuildStats[j].TemplateVersionName {
+			return workspaceBuildStats[i].TemplateVersionName < workspaceBuildStats[j].TemplateVersionName
+		}
+		return workspaceBuildStats[i].WorkspaceBuildNumber > workspaceBuildStats[j].WorkspaceBuildNumber
+	})
 	return workspaceBuildStats, nil
 }
 
diff --git a/coderd/database/queries/workspacebuilds.sql b/coderd/database/queries/workspacebuilds.sql
@@ -239,4 +239,6 @@ WHERE
 	w.template_id = $1
 	AND wb.created_at >= @since
 	AND pj.completed_at IS NOT NULL
-	AND pj.job_status = 'failed';
+	AND pj.job_status = 'failed'
+ORDER BY
+	tv.name ASC, wb.build_number DESC;

Original file line number	Diff line number	Diff line change
`@@ -2592,6 +2592,12 @@ func (q *FakeQuerier) GetFailedWorkspaceBuildsByTemplateID(ctx context.Context,`
`2592`	`2592`	`})`
`2593`	`2593`	`}`
`2594`	`2594`
	`2595`	`+ sort.Slice(workspaceBuildStats, func(i, j int) bool {`
	`2596`	`+ if workspaceBuildStats[i].TemplateVersionName != workspaceBuildStats[j].TemplateVersionName {`
	`2597`	`+ return workspaceBuildStats[i].TemplateVersionName < workspaceBuildStats[j].TemplateVersionName`
	`2598`	`+ }`
	`2599`	`+ return workspaceBuildStats[i].WorkspaceBuildNumber > workspaceBuildStats[j].WorkspaceBuildNumber`
	`2600`	`+ })`
`2595`	`2601`	`return workspaceBuildStats, nil`
`2596`	`2602`	`}`
`2597`	`2603`