Mercurial > gemma
changeset 5505:2604beecbd1a deactivate-users
Fixed whitespace in SQL statement.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 22 Sep 2021 18:53:19 +0200 |
| parents | 5e3e3d9e2c23 |
| children | 90506606a7ef |
| files | pkg/controllers/user.go |
| diffstat | 1 files changed, 8 insertions(+), 8 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/controllers/user.go Wed Sep 22 18:50:16 2021 +0200 +++ b/pkg/controllers/user.go Wed Sep 22 18:53:19 2021 +0200 @@ -60,20 +60,20 @@ deleteUserSQL = ` WITH del AS ( DELETE FROM users.list_users - WHERE username = $1 AND ( - rolname NOT IN ('waterway_admin', 'sys_admin') - OR NOT EXISTS (SELECT 1 FROM import.imports WHERE username = $1)) - RETURNING * + WHERE username = $1 AND ( + rolname NOT IN ('waterway_admin', 'sys_admin') + OR NOT EXISTS (SELECT 1 FROM import.imports WHERE username = $1)) + RETURNING * ), up AS ( UPDATE users.list_users - SET (email_address, report_reciever, active) = ('nomail@example.com', false, false) - WHERE username = $1 AND NOT EXISTS (SELECT * FROM del) - RETURNING * + SET (email_address, report_reciever, active) = ('nomail@example.com', false, false) + WHERE username = $1 AND NOT EXISTS (SELECT * FROM del) + RETURNING * ) SELECT EXISTS (SELECT * FROM del) AS deleted, - EXISTS (SELECT * FROM up) AS updated` + EXISTS (SELECT * FROM up) AS updated` listUsersSQL = `SELECT rolname,