added new route for template enterprise meta

coder · Kira-Pilot · May 5, 2023 · May 1, 2023 · May 1, 2023 · May 3, 2023
commit c049e9e4eee9ed2785e401ea55433987ba326835
diff --git a/.vscode/settings.json b/.vscode/settings.json
@@ -34,6 +34,7 @@
     "Dsts",
     "embeddedpostgres",
     "enablements",
+    "enterprisemeta",
     "errgroup",
     "eventsourcemock",
     "Failf",

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/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000121_add_template_cleanup_ttls.down.sql b/coderd/database/migrations/000121_add_template_cleanup_ttls.down.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY templates DROP COLUMN IF EXISTS failure_ttl;
+ALTER TABLE ONLY templates DROP COLUMN IF EXISTS inactivity_ttl;
diff --git a/coderd/database/migrations/000121_add_template_cleanup_ttls.up.sql b/coderd/database/migrations/000121_add_template_cleanup_ttls.up.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY templates ADD COLUMN IF NOT EXISTS failure_ttl BIGINT NOT NULL DEFAULT 0;
+ALTER TABLE ONLY templates ADD COLUMN IF NOT EXISTS inactivity_ttl BIGINT NOT NULL DEFAULT 0;
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/templates.sql b/coderd/database/queries/templates.sql
@@ -104,7 +104,9 @@ SET
 	name = $4,
 	icon = $5,
 	display_name = $6,
-	allow_user_cancel_workspace_jobs = $7
+	allow_user_cancel_workspace_jobs = $7,
+	failure_ttl = $8,
+	inactivity_ttl = $9
 WHERE
 	id = $1
 RETURNING

diff --git a/coderd/database/sqlc.yaml b/coderd/database/sqlc.yaml
@@ -51,6 +51,8 @@ overrides:
       template_max_ttl: TemplateMaxTTL
       motd_file: MOTDFile
       uuid: UUID
+      failure_ttl: FailureTTL
+      inactivity_ttl: InactivityTTL
 
 sql:
   - schema: "./dump.sql"

diff --git a/codersdk/templates.go b/codersdk/templates.go
@@ -97,6 +97,11 @@ type UpdateTemplateMeta struct {
 	AllowUserCancelWorkspaceJobs bool  `json:"allow_user_cancel_workspace_jobs,omitempty"`
 }
 
+type UpdateTemplateEnterpriseMeta struct {
+	FailureTTL    int64 `json:"failure_ttl,omitempty"`
+	InactivityTTL int64 `json:"inactivity_ttl,omitempty"`
+}
+
 type TemplateExample struct {
 	ID          string   `json:"id" format:"uuid"`
 	URL         string   `json:"url"`
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		ALTER TABLE ONLY templates DROP COLUMN IF EXISTS failure_ttl;
		ALTER TABLE ONLY templates DROP COLUMN IF EXISTS inactivity_ttl;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		ALTER TABLE ONLY templates ADD COLUMN IF NOT EXISTS failure_ttl BIGINT NOT NULL DEFAULT 0;
		ALTER TABLE ONLY templates ADD COLUMN IF NOT EXISTS inactivity_ttl BIGINT NOT NULL DEFAULT 0;