Mercurial > gemma

changeset 5330:b1b9b384540d extented-report

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adjust user model and controller to handle reports field.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 31 May 2021 12:56:44 +0200
parents 795a0a0b5047
children 9df7b39297ed
files pkg/controllers/user.go pkg/models/user.go
diffstat 2 files changed, 18 insertions(+), 8 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/user.go	Mon May 31 10:10:31 2021 +0200
+++ b/pkg/controllers/user.go	Mon May 31 12:56:44 2021 +0200
@@ -37,22 +37,22 @@
 
 const (
 	createUserSQL = `INSERT INTO users.list_users
-  VALUES ($1, $2, $3, $4, NULL, $5)`
+  VALUES ($1, $2, $3, $4, NULL, $5, $6)`
 	createUserExtentSQL = `INSERT INTO users.list_users
   VALUES ($1, $2, $3, $4,
-  ST_MakeBox2D(ST_Point($5, $6), ST_Point($7, $8)), $9)`
+  ST_MakeBox2D(ST_Point($5, $6), ST_Point($7, $8)), $9, $10)`
 
 	updateUserUnprivSQL = `UPDATE users.list_users
   SET (pw, map_extent, email_address)
   = ($2, ST_MakeBox2D(ST_Point($3, $4), ST_Point($5, $6)), $7)
   WHERE username = $1`
 	updateUserSQL = `UPDATE users.list_users
-  SET (rolname, username, pw, country, map_extent, email_address)
-  = ($2, $3, $4, $5, NULL, $6)
+  SET (rolname, username, pw, country, map_extent, email_address, report_reciever)
+  = ($2, $3, $4, $5, NULL, $6, $7)
   WHERE username = $1`
 	updateUserExtentSQL = `UPDATE users.list_users
-  SET (rolname, username, pw, country, map_extent, email_address)
-  = ($2, $3, $4, $5, ST_MakeBox2D(ST_Point($6, $7), ST_Point($8, $9)), $10)
+  SET (rolname, username, pw, country, map_extent, email_address, report_reciever)
+  = ($2, $3, $4, $5, ST_MakeBox2D(ST_Point($6, $7), ST_Point($8, $9)), $10, $11)
   WHERE username = $1`
 
 	deleteUserSQL = `DELETE FROM users.list_users WHERE username = $1`
@@ -63,7 +63,8 @@
   country,
   email_address,
   ST_XMin(map_extent), ST_YMin(map_extent),
-  ST_XMax(map_extent), ST_YMax(map_extent)
+  ST_XMax(map_extent), ST_YMax(map_extent),
+  report_reciever
 FROM users.list_users`
 
 	listUserSQL = `SELECT
@@ -71,7 +72,8 @@
   country,
   email_address,
   ST_XMin(map_extent), ST_YMin(map_extent),
-  ST_XMax(map_extent), ST_YMax(map_extent)
+  ST_XMax(map_extent), ST_YMax(map_extent),
+  report_reciever
 FROM users.list_users
 WHERE username = $1`
 )
@@ -181,6 +183,7 @@
 				newUser.Password,
 				newUser.Country,
 				newUser.Email,
+				newUser.Reports,
 			)
 		} else {
 			res, err = db.ExecContext(
@@ -194,6 +197,7 @@
 				newUser.Extent.X1, newUser.Extent.Y1,
 				newUser.Extent.X2, newUser.Extent.Y2,
 				newUser.Email,
+				newUser.Reports,
 			)
 		}
 	} else {
@@ -256,6 +260,7 @@
 			user.Password,
 			user.Country,
 			user.Email,
+			user.Reports,
 		)
 	} else {
 		_, err = db.ExecContext(
@@ -268,6 +273,7 @@
 			user.Extent.X1, user.Extent.Y1,
 			user.Extent.X2, user.Extent.Y2,
 			user.Email,
+			user.Reports,
 		)
 	}
 
@@ -307,6 +313,7 @@
 			&user.Email,
 			&user.Extent.X1, &user.Extent.Y1,
 			&user.Extent.X2, &user.Extent.Y2,
+			&user.Reports,
 		); err != nil {
 			return
 		}
@@ -343,6 +350,7 @@
 		&result.Email,
 		&result.Extent.X1, &result.Extent.Y1,
 		&result.Extent.X2, &result.Extent.Y2,
+		&result.Reports,
 	)
 
 	switch {
@@ -382,6 +390,7 @@
 		&userData.Email,
 		&userData.Extent.X1, &userData.Extent.Y1,
 		&userData.Extent.X2, &userData.Extent.Y2,
+		&userData.Reports,
 	)
 
 	switch {
--- a/pkg/models/user.go	Mon May 31 10:10:31 2021 +0200
+++ b/pkg/models/user.go	Mon May 31 12:56:44 2021 +0200
@@ -46,6 +46,7 @@
 		Password string       `json:"password,omitempty"`
 		Email    Email        `json:"email"`
 		Country  Country      `json:"country"`
+		Reports  bool         `json:"reports,omitempty"`
 		Extent   *BoundingBox `json:"extent"`
 	}