api.spaceplanner.app

commit bfc41dd7ac1e3a3afa390fe5fa9a5bcca00077bc
parent 19d963decc8a89940f56a32769daa44398e9d167
Author: Jacob R. Edwards <jacob@jacobedwards.org>
Date:   Sun,  6 Oct 2024 20:42:01 -0700

Fix more schema-less references

Diffstat:
M
internal/backend/settings.go
 | 
2
+-
M
internal/backend/user.go
 | 
2
+-

2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/internal/backend/settings.go b/internal/backend/settings.go
@@ -75,7 +75,7 @@ func (e *Env) GetUserSettings(tx *sql.Tx, username string, names ...string) (map
 
 func (e *Env) DeleteUserSettings(tx *sql.Tx, username string, names ...string) (map[string]interface{}, error) {
 	var deleted map[string]interface{}
-	stmt, err := e.CacheTxStmt(tx, "del_user_settings", `DELETE FROM user_settings WHERE user_settings.username = $1 AND
+	stmt, err := e.CacheTxStmt(tx, "del_user_settings", `DELETE FROM spaceplanner.user_settings WHERE user_settings.username = $1 AND
 		(ARRAY_LENGTH($2::varchar[], 1) IS NULL OR user_settings.name = ANY ($2)) RETURNING *`)
 	if err != nil {
 		return deleted, err
diff --git a/internal/backend/user.go b/internal/backend/user.go
@@ -231,7 +231,7 @@ safely ignore this message (and sorry to bother).`, e.Config.SMTP.Name, e.Config
 func (e *Env) UserEmails(username string) (UserEmails, error) {
 	get, err := e.CacheTxStmt(nil, "get_both_emails", `
 	SELECT users.verified_email, user_settings.strval AS setting
-		FROM spaceplanner.users LEFT OUTER JOIN user_settings
+		FROM spaceplanner.users LEFT OUTER JOIN spaceplanner.user_settings
 		ON users.name = user_settings.username AND user_settings.name = 'email'
 		WHERE users.name = $1`)
 	if err != nil {