May 10, 2022 · May 10, 2022
diff --git a/cmd/templater/main.go b/cmd/templater/main.go
diff --git a/coderd/coderd.go b/coderd/coderd.go
 })
 r.Get("/gitsshkey", api.gitSSHKey)
 r.Put("/gitsshkey", api.regenerateGitSSHKey)
 r.Get("/workspaces", api.workspacesByOwner)
 })
 })
 })
diff --git a/coderd/database/databasefake/databasefake.go b/coderd/database/databasefake/databasefake.go
 return workspaces, nil
 }

 func (q *fakeQuerier) GetWorkspacesByOrganizationIDs(_ context.Context, req database.GetWorkspacesByOrganizationIDsParams) ([]database.Workspace, error) {
 q.mutex.RLock()
 defer q.mutex.RUnlock()

 workspaces := make([]database.Workspace, 0)
 for _, workspace := range q.workspaces {
 for _, id := range req.Ids {
 if workspace.ID != id {
 continue
 }
 if workspace.Deleted != req.Deleted {
 continue
 }
 workspaces = append(workspaces, workspace)
 }
 }
 if len(workspaces) == 0 {
 return nil, sql.ErrNoRows
 }
 return workspaces, nil
 }

 func (q *fakeQuerier) GetWorkspacesByOwnerID(_ context.Context, req database.GetWorkspacesByOwnerIDParams) ([]database.Workspace, error) {
 q.mutex.RLock()
 defer q.mutex.RUnlock()
diff --git a/coderd/database/querier.go b/coderd/database/querier.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/workspaces.sql b/coderd/database/queries/workspaces.sql
 -- name: GetWorkspacesByOrganizationID :many
 SELECT * FROM workspaces WHERE organization_id = $1 AND deleted = $2;

 -- name: GetWorkspacesByOrganizationIDs :many
 SELECT * FROM workspaces WHERE organization_id = ANY(@ids :: uuid [ ]) AND deleted = @deleted;

 -- name: GetWorkspacesByTemplateID :many
 SELECT
 *
Original file line number	Diff line number	Diff line change
Expand Up		@@ -258,6 +258,7 @@ func New(options *Options) (http.Handler, func()) {
		})
		r.Get("/gitsshkey", api.gitSSHKey)
		r.Put("/gitsshkey", api.regenerateGitSSHKey)
		r.Get("/workspaces", api.workspacesByOwner)
		})
		})
		})
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -478,6 +478,28 @@ func (q *fakeQuerier) GetWorkspacesByOrganizationID(_ context.Context, req datab
		return workspaces, nil
		}

		func (q *fakeQuerier) GetWorkspacesByOrganizationIDs(_ context.Context, req database.GetWorkspacesByOrganizationIDsParams) ([]database.Workspace, error) {
		q.mutex.RLock()
		defer q.mutex.RUnlock()

		workspaces := make([]database.Workspace, 0)
		for _, workspace := range q.workspaces {
		for _, id := range req.Ids {
		if workspace.ID != id {
		continue
		}
		if workspace.Deleted != req.Deleted {
		continue
		}
		workspaces = append(workspaces, workspace)
		}
		}
		if len(workspaces) == 0 {
		return nil, sql.ErrNoRows
		}
		return workspaces, nil
		}

		func (q *fakeQuerier) GetWorkspacesByOwnerID(_ context.Context, req database.GetWorkspacesByOwnerIDParams) ([]database.Workspace, error) {
		q.mutex.RLock()
		defer q.mutex.RUnlock()
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -11,6 +11,9 @@ LIMIT
		-- name: GetWorkspacesByOrganizationID :many
		SELECT * FROM workspaces WHERE organization_id = $1 AND deleted = $2;

		-- name: GetWorkspacesByOrganizationIDs :many
		SELECT * FROM workspaces WHERE organization_id = ANY(@ids :: uuid [ ]) AND deleted = @deleted;

		-- name: GetWorkspacesByTemplateID :many
		SELECT
		*
Expand Down