Oct 30, 2025 · Oct 30, 2025 · Oct 30, 2025 · Oct 30, 2025 · Oct 30, 2025 · Oct 30, 2025
diff --git a/coderd/apidoc/docs.go b/coderd/apidoc/docs.go
diff --git a/coderd/apidoc/swagger.json b/coderd/apidoc/swagger.json
diff --git a/coderd/database/dbauthz/dbauthz.go b/coderd/database/dbauthz/dbauthz.go
 return q.db.UpdatePresetPrebuildStatus(ctx, arg)
 }

 func (q *querier) UpdatePresetsLastInvalidatedAt(ctx context.Context, arg database.UpdatePresetsLastInvalidatedAtParams) ([]string, error) {
 // Fetch template to check authorization
 template, err := q.db.GetTemplateByID(ctx, arg.TemplateID)
 if err != nil {
 return nil, err
 }

 if err := q.authorizeContext(ctx, policy.ActionUpdate, template); err != nil {
 return nil, err
 }

 return q.db.UpdatePresetsLastInvalidatedAt(ctx, arg)
 }

 func (q *querier) UpdateProvisionerDaemonLastSeenAt(ctx context.Context, arg database.UpdateProvisionerDaemonLastSeenAtParams) error {
 if err := q.authorizeContext(ctx, policy.ActionUpdate, rbac.ResourceProvisionerDaemon); err != nil {
 return err
diff --git a/coderd/database/dbauthz/dbauthz_test.go b/coderd/database/dbauthz/dbauthz_test.go
 dbm.EXPECT().UpsertTemplateUsageStats(gomock.Any()).Return(nil).AnyTimes()
 check.Asserts(rbac.ResourceSystem, policy.ActionUpdate)
 }))
 s.Run("UpdatePresetsLastInvalidatedAt", s.Mocked(func(dbm *dbmock.MockStore, faker *gofakeit.Faker, check *expects) {
 t1 := testutil.Fake(s.T(), faker, database.Template{})
 arg := database.UpdatePresetsLastInvalidatedAtParams{LastInvalidatedAt: sql.NullTime{Valid: true, Time: dbtime.Now()}, TemplateID: t1.ID}
 dbm.EXPECT().GetTemplateByID(gomock.Any(), t1.ID).Return(t1, nil).AnyTimes()
 dbm.EXPECT().UpdatePresetsLastInvalidatedAt(gomock.Any(), arg).Return([]string{}, nil).AnyTimes()
 check.Args(arg).Asserts(t1, policy.ActionUpdate)
 }))
 }

 func (s *MethodTestSuite) TestUser() {
diff --git a/coderd/database/dbfake/dbfake.go b/coderd/database/dbfake/dbfake.go
 IsDefault:           false,
 Description:         preset.Description,
 Icon:                preset.Icon,
 LastInvalidatedAt:   preset.LastInvalidatedAt,
 })
 t.logger.Debug(context.Background(), "added preset",
 slog.F("preset_id", prst.ID),
diff --git a/coderd/database/dbgen/dbgen.go b/coderd/database/dbgen/dbgen.go
 IsDefault:           seed.IsDefault,
 Description:         seed.Description,
 Icon:                seed.Icon,
 LastInvalidatedAt:   seed.LastInvalidatedAt,
 })
 require.NoError(t, err, "insert preset")
 return preset
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/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000394_template_version_presets_last_invalidated_at.down.sql b/coderd/database/migrations/000394_template_version_presets_last_invalidated_at.down.sql
 ALTER TABLE template_version_presets DROP COLUMN last_invalidated_at;
diff --git a/coderd/database/migrations/000394_template_version_presets_last_invalidated_at.up.sql b/coderd/database/migrations/000394_template_version_presets_last_invalidated_at.up.sql
 ALTER TABLE template_version_presets ADD COLUMN last_invalidated_at TIMESTAMPTZ;
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/querier.go b/coderd/database/querier.go
Original file line number	Diff line number	Diff line change
Expand Up		@@ -4968,6 +4968,20 @@ func (q *querier) UpdatePresetPrebuildStatus(ctx context.Context, arg database.U
		return q.db.UpdatePresetPrebuildStatus(ctx, arg)
		}

		func (q *querier) UpdatePresetsLastInvalidatedAt(ctx context.Context, arg database.UpdatePresetsLastInvalidatedAtParams) ([]string, error) {
		// Fetch template to check authorization
		template, err := q.db.GetTemplateByID(ctx, arg.TemplateID)
		if err != nil {
		return nil, err
		}

		if err := q.authorizeContext(ctx, policy.ActionUpdate, template); err != nil {
		return nil, err
		}

		return q.db.UpdatePresetsLastInvalidatedAt(ctx, arg)
		}

		func (q *querier) UpdateProvisionerDaemonLastSeenAt(ctx context.Context, arg database.UpdateProvisionerDaemonLastSeenAtParams) error {
		if err := q.authorizeContext(ctx, policy.ActionUpdate, rbac.ResourceProvisionerDaemon); err != nil {
		return err
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -1315,6 +1315,13 @@ func (s *MethodTestSuite) TestTemplate() {
		dbm.EXPECT().UpsertTemplateUsageStats(gomock.Any()).Return(nil).AnyTimes()
		check.Asserts(rbac.ResourceSystem, policy.ActionUpdate)
		}))
		s.Run("UpdatePresetsLastInvalidatedAt", s.Mocked(func(dbm dbmock.MockStore, faker gofakeit.Faker, check *expects) {
		t1 := testutil.Fake(s.T(), faker, database.Template{})
		arg := database.UpdatePresetsLastInvalidatedAtParams{LastInvalidatedAt: sql.NullTime{Valid: true, Time: dbtime.Now()}, TemplateID: t1.ID}
		dbm.EXPECT().GetTemplateByID(gomock.Any(), t1.ID).Return(t1, nil).AnyTimes()
		dbm.EXPECT().UpdatePresetsLastInvalidatedAt(gomock.Any(), arg).Return([]string{}, nil).AnyTimes()
		check.Args(arg).Asserts(t1, policy.ActionUpdate)
		}))
		}

		func (s *MethodTestSuite) TestUser() {
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -606,6 +606,7 @@ func (t TemplateVersionBuilder) Do() TemplateVersionResponse {
		IsDefault: false,
		Description: preset.Description,
		Icon: preset.Icon,
		LastInvalidatedAt: preset.LastInvalidatedAt,
		})
		t.logger.Debug(context.Background(), "added preset",
		slog.F("preset_id", prst.ID),
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -1430,6 +1430,7 @@ func Preset(t testing.TB, db database.Store, seed database.InsertPresetParams) d
		IsDefault: seed.IsDefault,
		Description: seed.Description,
		Icon: seed.Icon,
		LastInvalidatedAt: seed.LastInvalidatedAt,
		})
		require.NoError(t, err, "insert preset")
		return preset
Expand Down
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		ALTER TABLE template_version_presets DROP COLUMN last_invalidated_at;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		ALTER TABLE template_version_presets ADD COLUMN last_invalidated_at TIMESTAMPTZ;