Mercurial > gemma

comparison pkg/controllers/user.go @ 5505:2604beecbd1a deactivate-users

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 5680c44ff6c0
comparison
equal deleted inserted replaced
5504:5e3e3d9e2c23 5505:2604beecbd1a
58 WHERE username = $1` 58 WHERE username = $1`
59 59
60 deleteUserSQL = ` 60 deleteUserSQL = `
61 WITH del AS ( 61 WITH del AS (
62 DELETE FROM users.list_users 62 DELETE FROM users.list_users
63 WHERE username = $1 AND ( 63 WHERE username = $1 AND (
64 rolname NOT IN ('waterway_admin', 'sys_admin') 64 rolname NOT IN ('waterway_admin', 'sys_admin')
65 OR NOT EXISTS (SELECT 1 FROM import.imports WHERE username = $1)) 65 OR NOT EXISTS (SELECT 1 FROM import.imports WHERE username = $1))
66 RETURNING * 66 RETURNING *
67 ), 67 ),
68 up AS ( 68 up AS (
69 UPDATE users.list_users 69 UPDATE users.list_users
70 SET (email_address, report_reciever, active) = ('nomail@example.com', false, false) 70 SET (email_address, report_reciever, active) = ('nomail@example.com', false, false)
71 WHERE username = $1 AND NOT EXISTS (SELECT * FROM del) 71 WHERE username = $1 AND NOT EXISTS (SELECT * FROM del)
72 RETURNING * 72 RETURNING *
73 ) 73 )
74 SELECT 74 SELECT
75 EXISTS (SELECT * FROM del) AS deleted, 75 EXISTS (SELECT * FROM del) AS deleted,
76 EXISTS (SELECT * FROM up) AS updated` 76 EXISTS (SELECT * FROM up) AS updated`
77 77
78 listUsersSQL = `SELECT 78 listUsersSQL = `SELECT
79 rolname, 79 rolname,
80 username, 80 username,
81 country, 81 country,