Add database column allow_user_cancel_workspace_jobs

coder · mtojek · Nov 21, 2022 · Nov 17, 2022 · Nov 17, 2022 · Nov 17, 2022
commit 4dcbf5c98e315fdf67a4a2b391275d296c9c8dcd
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000081_template_allow_user_cancel_workspace_jobs.down.sql b/coderd/database/migrations/000081_template_allow_user_cancel_workspace_jobs.down.sql
@@ -0,0 +1 @@
+ALTER TABLE templates DROP COLUMN allow_user_cancel_workspace_jobs;
diff --git a/coderd/database/migrations/000081_template_allow_user_cancel_workspace_jobs.up.sql b/coderd/database/migrations/000081_template_allow_user_cancel_workspace_jobs.up.sql
@@ -0,0 +1,4 @@
+ALTER TABLE templates ADD COLUMN allow_user_cancel_workspace_jobs boolean NOT NULL DEFAULT true;
+
+COMMENT ON COLUMN templates.allow_user_cancel_workspace_jobs
+IS 'Allow users to cancel in-progress workspace jobs.';
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
@@ -70,10 +70,11 @@ INSERT INTO
 		icon,
 		user_acl,
 		group_acl,
-		display_name
+		display_name,
+		allow_user_cancel_workspace_jobs
 	)
 VALUES
-	($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) RETURNING *;
+	($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15) RETURNING *;
 
 -- name: UpdateTemplateActiveVersionByID :exec
 UPDATE
@@ -102,7 +103,8 @@ SET
 	default_ttl = $4,
 	name = $5,
 	icon = $6,
-	display_name = $7
+	display_name = $7,
+	allow_user_cancel_workspace_jobs = $8
 WHERE
 	id = $1
 RETURNING
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		ALTER TABLE templates DROP COLUMN allow_user_cancel_workspace_jobs;