Mercurial > gemma

diff controllers/user.go @ 343:5b03f420957d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use INSTEAD OF trigger for user creation Now make the whole thing look like a real table. There is no more function in schema sys_admin, thus remove respective privilege test.
author Tom Gottfried <tom@intevation.de>
date Mon, 06 Aug 2018 13:25:18 +0200
parents c6bd6ed18942
children
line wrap: on
line diff
--- a/controllers/user.go	Mon Aug 06 12:37:06 2018 +0200
+++ b/controllers/user.go	Mon Aug 06 13:25:18 2018 +0200
@@ -11,8 +11,10 @@
 )
 
 const (
-	createUserSQL       = `SELECT sys_admin.create_user($1, $2, $3, $4, NULL, $5)`
-	createUserExtentSQL = `SELECT sys_admin.create_user($1, $2, $3, $4,
+	createUserSQL = `INSERT INTO users.list_users
+  VALUES ($1, $2, $3, $4, NULL, $5)`
+	createUserExtentSQL = `INSERT INTO users.list_users
+  VALUES ($1, $2, $3, $4,
   ST_MakeBox2D(ST_Point($5, $6), ST_Point($7, $8)), $9)`
 
 	updateUserUnprivSQL = `UPDATE users.list_users