coder
diff --git a/‎coderd/database/databasefake/databasefake.go
Lines changed: 16 additions & 0 deletions b/‎coderd/database/databasefake/databasefake.go
Lines changed: 16 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: 38 additions & 0 deletions b/‎coderd/database/queries.sql.go
Lines changed: 38 additions & 0 deletions
diff --git a/‎coderd/database/queries/workspaces.sql
Lines changed: 3 additions & 0 deletions b/‎coderd/database/queries/workspaces.sql
Lines changed: 3 additions & 0 deletions
@@ -1010,6 +1010,22 @@ func (q *fakeQuerier) GetWorkspaceResourcesByJobID(_ context.Context, jobID uuid
 	return resources, nil
 }
 
+func (q *fakeQuerier) GetWorkspaces(_ context.Context, deleted bool) ([]database.Workspace, error) {
+	q.mutex.RLock()
+	defer q.mutex.RUnlock()
+
+	workspaces := make([]database.Workspace, 0)
+	for _, workspace := range q.workspaces {
+		if workspace.Deleted == deleted {
+			workspaces = append(workspaces, workspace)
+		}
+	}
+	if len(workspaces) == 0 {
+		return nil, sql.ErrNoRows
+	}
+	return workspaces, nil
+}
+
 func (q *fakeQuerier) GetProvisionerJobsByIDs(_ context.Context, ids []uuid.UUID) ([]database.ProvisionerJob, error) {
 	q.mutex.RLock()
 	defer q.mutex.RUnlock()
 
@@ -1,3 +1,6 @@
+-- name: GetWorkspaces :many
+SELECT * FROM workspaces WHERE deleted = $1;
+
 -- name: GetWorkspaceByID :one
 SELECT
 	*
Original file line number	Diff line number	Diff line change
`@@ -1,3 +1,6 @@`
	`1`	`+-- name: GetWorkspaces :many`
	`2`	`+SELECT * FROM workspaces WHERE deleted = $1;`
	`3`	`+`
`1`	`4`	`-- name: GetWorkspaceByID :one`
`2`	`5`	`SELECT`
`3`	`6`	`*`