coder
diff --git a/‎coderd/database/databasefake/databasefake.go
Lines changed: 20 additions & 0 deletions b/‎coderd/database/databasefake/databasefake.go
Lines changed: 20 additions & 0 deletions
diff --git a/‎coderd/database/querier.go
Lines changed: 1 addition & 0 deletions b/‎coderd/database/querier.go
Lines changed: 1 addition & 0 deletions
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 41 additions & 0 deletions b/‎coderd/database/queries.sql.go
Lines changed: 41 additions & 0 deletions
diff --git a/‎coderd/database/queries/workspaceresources.sql
Lines changed: 10 additions & 0 deletions b/‎coderd/database/queries/workspaceresources.sql
Lines changed: 10 additions & 0 deletions
@@ -993,6 +993,26 @@ func (q *fakeQuerier) GetWorkspaceResourceByID(_ context.Context, id uuid.UUID)
 	return database.WorkspaceResource{}, sql.ErrNoRows
 }
 
+func (q *fakeQuerier) GetWorkspaceResources(ctx context.Context) ([]database.WorkspaceResource, error) {
+	q.mutex.RLock()
+	defer q.mutex.RUnlock()
+
+	resources := make([]database.WorkspaceResource, 0)
+	for _, workspaceBuild := range q.workspaceBuilds {
+		if !workspaceBuild.AfterID.Valid {
+			rs, err := q.GetWorkspaceResourcesByJobID(ctx, workspaceBuild.JobID)
+			if err != nil {
+				return nil, err
+			}
+			resources = append(resources, rs...)
+		}
+	}
+	if len(resources) == 0 {
+		return nil, sql.ErrNoRows
+	}
+	return resources, nil
+}
+
 func (q *fakeQuerier) GetWorkspaceResourcesByJobID(_ context.Context, jobID uuid.UUID) ([]database.WorkspaceResource, error) {
 	q.mutex.RLock()
 	defer q.mutex.RUnlock()
 
@@ -19,3 +19,13 @@ INSERT INTO
 	workspace_resources (id, created_at, job_id, transition, type, name)
 VALUES
 	($1, $2, $3, $4, $5, $6) RETURNING *;
+
+-- name: GetWorkspaceResources :many
+SELECT
+	workspace_resources.*
+FROM
+	workspace_resources
+INNER JOIN workspace_builds
+	ON workspace_resources.job_id = workspace_builds.job_id
+WHERE
+  workspace_builds.after_id IS NULL;