chore: add sql query to suspend/active the user

coder · BrunoQuaresma · Apr 26, 2022 · Apr 25, 2022 · Apr 25, 2022 · Apr 25, 2022
commit 8c35a6e60194323293f2c548c23ac33cb80825e0
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000007_user_suspended.down.sql b/coderd/database/migrations/000007_user_suspended.down.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY users
+    DROP COLUMN IF EXISTS suspended;
diff --git a/coderd/database/migrations/000007_user_suspended.up.sql b/coderd/database/migrations/000007_user_suspended.up.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY users
+    ADD COLUMN IF NOT EXISTS suspended boolean DEFAULT FALSE;
diff --git a/coderd/database/models.go b/coderd/database/models.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/users.sql b/coderd/database/queries/users.sql
@@ -90,3 +90,12 @@ ORDER BY
 LIMIT
 	-- A null limit means "no limit", so -1 means return all
 	NULLIF(@limit_opt :: int, -1);
+
+-- name: UpdateUserSuspended :one
+UPDATE
+	users
+SET
+	suspended = $2,
+	updated_at = $3
+WHERE
+	id = $1 RETURNING *;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		ALTER TABLE ONLY users
		DROP COLUMN IF EXISTS suspended;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		ALTER TABLE ONLY users
		ADD COLUMN IF NOT EXISTS suspended boolean DEFAULT FALSE;