Skip to content

Commit 8c35a6e

Browse files
BrunoQuaresmaBrunoQuaresma
committed
chore: add sql query to suspend/active the user
1 parent 5575e3c commit 8c35a6e

File tree

7 files changed

+64
-12
lines changed

7 files changed

+64
-12
lines changed

‎coderd/database/dump.sql

Lines changed: 2 additions & 1 deletion
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/migrations/000007_user_suspended.down.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
ALTER TABLE ONLY users
2+
DROP COLUMN IF EXISTS suspended;

‎coderd/database/migrations/000007_user_suspended.up.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
ALTER TABLE ONLY users
2+
ADD COLUMN IF NOT EXISTS suspended boolean DEFAULT FALSE;

‎coderd/database/models.go

Lines changed: 7 additions & 6 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/querier.go

Lines changed: 1 addition & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries.sql.go

Lines changed: 41 additions & 5 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries/users.sql

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -90,3 +90,12 @@ ORDER BY
9090
LIMIT
9191
-- A null limit means "no limit", so -1 means return all
9292
NULLIF(@limit_opt :: int, -1);
93+
94+
-- name: UpdateUserSuspended :one
95+
UPDATE
96+
users
97+
SET
98+
suspended = $2,
99+
updated_at = $3
100+
WHERE
101+
id = $1 RETURNING *;

0 commit comments

Comments
 (0)