coder
diff --git a/‎coderd/database/dbauthz/dbauthz.go
+3-3 b/‎coderd/database/dbauthz/dbauthz.go
+3-3
diff --git a/‎coderd/database/dbfake/dbfake.go
+38-3 b/‎coderd/database/dbfake/dbfake.go
+38-3
diff --git a/‎coderd/database/dbmetrics/dbmetrics.go
+3-3 b/‎coderd/database/dbmetrics/dbmetrics.go
+3-3
diff --git a/‎coderd/database/dbmock/dbmock.go
+4-3 b/‎coderd/database/dbmock/dbmock.go
+4-3
diff --git a/‎coderd/database/querier.go
+1-1 b/‎coderd/database/querier.go
+1-1
diff --git a/‎coderd/database/queries.sql.go
+25-4 b/‎coderd/database/queries.sql.go
+25-4
diff --git a/‎coderd/database/queries/templateversions.sql
+5-2 b/‎coderd/database/queries/templateversions.sql
+5-2
@@ -2242,13 +2242,13 @@ func (q *querier) InsertWorkspaceResourceMetadata(ctx context.Context, arg datab
 	return q.db.InsertWorkspaceResourceMetadata(ctx, arg)
 }
 
-func (q *querier) PruneUnusedTemplateVersions(ctx context.Context, arg database.PruneUnusedTemplateVersionsParams) error {
+func (q *querier) PruneUnusedTemplateVersions(ctx context.Context, arg database.PruneUnusedTemplateVersionsParams) ([]uuid.UUID, error) {
 	tpl, err := q.db.GetTemplateByID(ctx, arg.TemplateID)
 	if err != nil {
-		return err
+		return nil, err
 	}
 	if err := q.authorizeContext(ctx, rbac.ActionUpdate, tpl); err != nil {
-		return err
+		return nil, err
 	}
 	return q.db.PruneUnusedTemplateVersions(ctx, arg)
 }
 
@@ -5175,13 +5175,48 @@ func (q *FakeQuerier) InsertWorkspaceResourceMetadata(_ context.Context, arg dat
 	return metadata, nil
 }
 
-func (q *FakeQuerier) PruneUnusedTemplateVersions(ctx context.Context, arg database.PruneUnusedTemplateVersionsParams) error {
+func (q *FakeQuerier) PruneUnusedTemplateVersions(ctx context.Context, arg database.PruneUnusedTemplateVersionsParams) ([]uuid.UUID, error) {
 	err := validateDatabaseType(arg)
 	if err != nil {
-		return err
+		return nil, err
+	}
+	q.mutex.Lock()
+	defer q.mutex.Unlock()
+	type latestBuild struct {
+		Number  int32
+		Version uuid.UUID
+	}
+	latest := make(map[uuid.UUID]latestBuild)
+
+	for _, b := range q.workspaceBuilds {
+		v, ok := latest[b.WorkspaceID]
+		if ok || b.BuildNumber < v.Number {
+			// Not the latest
+			continue
+		}
+		latest[b.WorkspaceID] = latestBuild{
+			Number:  b.BuildNumber,
+			Version: b.TemplateVersionID,
+		}
+	}
+	usedVersions := make(map[uuid.UUID]bool)
+	for _, l := range latest {
+		usedVersions[l.Version] = true
+	}
+
+	var deleted []uuid.UUID
+	for i, v := range q.templateVersions {
+		if v.Deleted {
+			continue
+		}
+		if _, ok := usedVersions[v.ID]; !ok {
+			v.Deleted = true
+			q.templateVersions[i] = v
+			deleted = append(deleted, v.ID)
+		}
 	}
 
-	panic("not implemented")
+	return deleted, nil
 }
 
 func (q *FakeQuerier) RegisterWorkspaceProxy(_ context.Context, arg database.RegisterWorkspaceProxyParams) (database.WorkspaceProxy, error) {
 
@@ -139,7 +139,7 @@ ORDER BY created_at DESC
 LIMIT 1;
 
 
--- name: PruneUnusedTemplateVersions :exec
+-- name: PruneUnusedTemplateVersions :many
 -- Pruning templates is a soft delete action, so is technically reversible.
 -- Soft deleting prevents the version from being used and discovered
 -- by listing.
@@ -165,5 +165,8 @@ WHERE
 			workspace_builds
 		ORDER BY build_number DESC
 	)
+    -- Ignore already deleted versions.
+	AND template_versions.deleted = false
 	-- Scope a prune to a single template.
-	AND template_id = @template_id :: uuid;
+	AND template_id = @template_id :: uuid
+RETURNING id;
Original file line number	Diff line number	Diff line change
`@@ -2242,13 +2242,13 @@ func (q *querier) InsertWorkspaceResourceMetadata(ctx context.Context, arg datab`
`2242`	`2242`	`return q.db.InsertWorkspaceResourceMetadata(ctx, arg)`
`2243`	`2243`	`}`
`2244`	`2244`
`2245`		`-func (q *querier) PruneUnusedTemplateVersions(ctx context.Context, arg database.PruneUnusedTemplateVersionsParams) error {`
	`2245`	`+func (q *querier) PruneUnusedTemplateVersions(ctx context.Context, arg database.PruneUnusedTemplateVersionsParams) ([]uuid.UUID, error) {`
`2246`	`2246`	`tpl, err := q.db.GetTemplateByID(ctx, arg.TemplateID)`
`2247`	`2247`	`if err != nil {`
`2248`		`- return err`
	`2248`	`+ return nil, err`
`2249`	`2249`	`}`
`2250`	`2250`	`if err := q.authorizeContext(ctx, rbac.ActionUpdate, tpl); err != nil {`
`2251`		`- return err`
	`2251`	`+ return nil, err`
`2252`	`2252`	`}`
`2253`	`2253`	`return q.db.PruneUnusedTemplateVersions(ctx, arg)`
`2254`	`2254`	`}`