api.spaceplanner.app

commit 22b68de73ddb87c6e5ef1ba5fe2b4feac265edfd
parent 400c878a4de7358729c952a41cfa1e5c5a3d1ec0
Author: Jacob R. Edwards <jacob@jacobedwards.org>
Date:   Fri, 30 Aug 2024 18:49:03 -0700

Fix invalid database operations

This was due to a substitution I knew I should have verified. Again,
great aren't I?

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

1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/internal/backend/user.go b/internal/backend/user.go
@@ -147,10 +147,10 @@ func (e *Env) VerifyEmail(username string, code *string) (bool, error) {
 	if err != nil {
 		return false, err
 	}
-	_, err = tx.Exec(`UPDATE spaceplanner.users SET emails.Verified_email = $2 WHERE name = $1`,
+	_, err = tx.Exec(`UPDATE spaceplanner.users SET verified_email = $2 WHERE name = $1`,
 		username, emails.Setting)
 	if err != nil {
-		return false, errors.New("UPDATE emails.Verified_email: " + err.Error())
+		return false, errors.New("UPDATE verified_email: " + err.Error())
 	}
 
 	if err := e.updateStripeEmail(username, *emails.Setting); err != nil {