Mercurial > gemma

comparison controllers/user.go @ 327:363983d5c567

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Allow Waterway User to update a limited set of profile attributes
author Tom Gottfried <tom@intevation.de>
date Thu, 02 Aug 2018 19:25:30 +0200
parents a7b2db8b3d18
children 003243ec5ce5
comparison
equal deleted inserted replaced
326:a7b2db8b3d18 327:363983d5c567
13 const ( 13 const (
14 createUserSQL = `SELECT sys_admin.create_user($1, $2, $3, $4, NULL, $5)` 14 createUserSQL = `SELECT sys_admin.create_user($1, $2, $3, $4, NULL, $5)`
15 createUserExtentSQL = `SELECT sys_admin.create_user($1, $2, $3, $4, 15 createUserExtentSQL = `SELECT sys_admin.create_user($1, $2, $3, $4,
16 ST_MakeBox2D(ST_Point($5, $6), ST_Point($7, $8)), $9)` 16 ST_MakeBox2D(ST_Point($5, $6), ST_Point($7, $8)), $9)`
17 17
18 updateUserUnprivSQL = `UPDATE users.list_users
19 SET (pw, map_extent, email_address)
20 = ($2, ST_MakeBox2D(ST_Point($3, $4), ST_Point($5, $6)), $7)
21 WHERE username = $1`
18 updateUserSQL = `UPDATE users.list_users 22 updateUserSQL = `UPDATE users.list_users
19 SET (rolname, username, pw, country, map_extent, email_address) 23 SET (rolname, username, pw, country, map_extent, email_address)
20 = ($2, $3, $4, $5, NULL, $6) 24 = ($2, $3, $4, $5, NULL, $6)
21 WHERE username = $1` 25 WHERE username = $1`
22 updateUserExtentSQL = `UPDATE users.list_users 26 updateUserExtentSQL = `UPDATE users.list_users
110 newUser.Extent.X2, newUser.Extent.Y2, 114 newUser.Extent.X2, newUser.Extent.Y2,
111 newUser.Email, 115 newUser.Email,
112 ) 116 )
113 } 117 }
114 } else { 118 } else {
115 // ... 119 res, err = db.Exec(
120 updateUserUnprivSQL,
121 user,
122 newUser.Password,
123 newUser.Extent.X1, newUser.Extent.Y1,
124 newUser.Extent.X2, newUser.Extent.Y2,
125 newUser.Email,
126 )
116 } 127 }
117 128
118 if err != nil { 129 if err != nil {
119 return 130 return
120 } 131 }