May 14, 2025 · Apr 25, 2025 · Apr 25, 2025 · Apr 25, 2025 · Apr 25, 2025 · Apr 25, 2025
diff --git a/coderd/database/dbauthz/dbauthz.go b/coderd/database/dbauthz/dbauthz.go
 return q.db.GetTemplateParameterInsights(ctx, arg)
 }

 func (q *querier) GetTemplatePresetsByID(ctx context.Context, id uuid.UUID) (database.TemplateVersionPreset, error) {
 if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceTemplate.All()); err != nil {
 return database.TemplateVersionPreset{}, err
 }
 return q.db.GetTemplatePresetsByID(ctx, id)
 }

 func (q *querier) GetTemplatePresetsWithPrebuilds(ctx context.Context, templateID uuid.NullUUID) ([]database.GetTemplatePresetsWithPrebuildsRow, error) {
 // GetTemplatePresetsWithPrebuilds retrieves template versions with configured presets and prebuilds.
 // Presets and prebuilds are part of the template, so if you can access templates - you can access them as well.
diff --git a/coderd/database/dbmem/dbmem.go b/coderd/database/dbmem/dbmem.go
 return rows, nil
 }

 func (q *FakeQuerier) GetTemplatePresetsByID(ctx context.Context, id uuid.UUID) (database.TemplateVersionPreset, error) {
 return database.TemplateVersionPreset{}, ErrUnimplemented
 }

 func (*FakeQuerier) GetTemplatePresetsWithPrebuilds(_ context.Context, _ uuid.NullUUID) ([]database.GetTemplatePresetsWithPrebuildsRow, error) {
 return nil, ErrUnimplemented
 }
diff --git a/coderd/database/dbmetrics/querymetrics.go b/coderd/database/dbmetrics/querymetrics.go
diff --git a/coderd/database/dbmock/dbmock.go b/coderd/database/dbmock/dbmock.go
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/prebuilds.sql b/coderd/database/queries/prebuilds.sql
 WHERE tvp.desired_instances IS NOT NULL -- Consider only presets that have a prebuild configuration.
 AND (t.id = sqlc.narg('template_id')::uuid OR sqlc.narg('template_id') IS NULL);

 -- name: GetTemplatePresetsByID :one
 SELECT *
 FROM template_version_presets
 WHERE id = $1;

 -- name: GetRunningPrebuiltWorkspaces :many
 SELECT
 p.id,
diff --git a/enterprise/coderd/prebuilds/reconcile.go b/enterprise/coderd/prebuilds/reconcile.go
 return xerrors.Errorf("no preset used in prebuild for workspace %q", workspaceID.String())
 }

 prebuildPreset, err := c.store.GetTemplatePresetsByID(ctx, prebuild.TemplateVersionPresetID.UUID)
 prebuildPreset, err := c.store.GetPresetByID(ctx, prebuild.TemplateVersionPresetID.UUID)
 if err != nil {
 return xerrors.Errorf("fetch template preset for template version ID %q: %w", prebuild.TemplateVersionID.String(), err)
 }
Original file line number	Diff line number	Diff line change
Expand Up		@@ -2524,13 +2524,6 @@ func (q *querier) GetTemplateParameterInsights(ctx context.Context, arg database
		return q.db.GetTemplateParameterInsights(ctx, arg)
		}

		func (q *querier) GetTemplatePresetsByID(ctx context.Context, id uuid.UUID) (database.TemplateVersionPreset, error) {
		if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceTemplate.All()); err != nil {
		return database.TemplateVersionPreset{}, err
		}
		return q.db.GetTemplatePresetsByID(ctx, id)
		}

		func (q *querier) GetTemplatePresetsWithPrebuilds(ctx context.Context, templateID uuid.NullUUID) ([]database.GetTemplatePresetsWithPrebuildsRow, error) {
		// GetTemplatePresetsWithPrebuilds retrieves template versions with configured presets and prebuilds.
		// Presets and prebuilds are part of the template, so if you can access templates - you can access them as well.
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -6072,10 +6072,6 @@ func (q *FakeQuerier) GetTemplateParameterInsights(ctx context.Context, arg data
		return rows, nil
		}

		func (q *FakeQuerier) GetTemplatePresetsByID(ctx context.Context, id uuid.UUID) (database.TemplateVersionPreset, error) {
		return database.TemplateVersionPreset{}, ErrUnimplemented
		}

		func (*FakeQuerier) GetTemplatePresetsWithPrebuilds(_ context.Context, _ uuid.NullUUID) ([]database.GetTemplatePresetsWithPrebuildsRow, error) {
		return nil, ErrUnimplemented
		}
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -42,11 +42,6 @@ FROM templates t
		WHERE tvp.desired_instances IS NOT NULL -- Consider only presets that have a prebuild configuration.
		AND (t.id = sqlc.narg('template_id')::uuid OR sqlc.narg('template_id') IS NULL);

		-- name: GetTemplatePresetsByID :one
		SELECT *
		FROM template_version_presets
		WHERE id = $1;

		-- name: GetRunningPrebuiltWorkspaces :many
		SELECT
		p.id,
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -672,7 +672,7 @@ func (c *StoreReconciler) trackResourceReplacement(ctx context.Context, workspac
		return xerrors.Errorf("no preset used in prebuild for workspace %q", workspaceID.String())
		}

		prebuildPreset, err := c.store.GetTemplatePresetsByID(ctx, prebuild.TemplateVersionPresetID.UUID)
		prebuildPreset, err := c.store.GetPresetByID(ctx, prebuild.TemplateVersionPresetID.UUID)
		if err != nil {
		return xerrors.Errorf("fetch template preset for template version ID %q: %w", prebuild.TemplateVersionID.String(), err)
		}
Expand Down