Mercurial > gemma

comparison pkg/controllers/printtemplates.go @ 2267:37ae1bee3e4a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Ajjusted RLS for user templates.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 14 Feb 2019 15:11:00 +0100
parents e6fba449aa3c
children 1c8b8a4476af
comparison
equal deleted inserted replaced
2266:153c77e529dc 2267:37ae1bee3e4a
45 45
46 selectPrintTemplateSQL = ` 46 selectPrintTemplateSQL = `
47 SELECT template_data FROM users.templates WHERE template_name = $1` 47 SELECT template_data FROM users.templates WHERE template_name = $1`
48 48
49 insertPrintTemplateSQL = ` 49 insertPrintTemplateSQL = `
50 INSERT INTO users.templates (template_name, template_data) 50 INSERT INTO users.templates (template_name, template_data, country)
51 VALUES ($1, $2)` 51 SELECT
52 $1,
53 $2,
54 CASE WHEN pg_has_role('sys_admin', 'MEMBER') THEN NULL
55 ELSE users.current_user_country()
56 END`
52 57
53 updatePrintTemplateSQL = ` 58 updatePrintTemplateSQL = `
54 UPDATE user.templates template_data = $2 WHERE template_name = $1` 59 UPDATE user.templates template_data = $2 WHERE template_name = $1`
55 ) 60 )
56 61