From bc65aaa83f2fcb6afcf1a6bc564fba9dc78f9f7d Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sat, 2 Nov 2024 00:56:13 +0300
Subject: fix: remove insert trigger on users, check insert user on login err
 (#224)

---
 backend/database/init.sql | 2 +-
 backend/handlers/login.go | 6 +++++-
 2 files changed, 6 insertions(+), 2 deletions(-)

(limited to 'backend')

diff --git a/backend/database/init.sql b/backend/database/init.sql
index 11ccd38..e238eae 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -13,7 +13,7 @@ CREATE TABLE users (
 );
 
 CREATE TRIGGER "users"
-AFTER INSERT OR UPDATE OR DELETE ON "users"
+AFTER UPDATE OR DELETE ON "users"
 FOR EACH ROW EXECUTE FUNCTION log_audit();
 
 CREATE TABLE games (
diff --git a/backend/handlers/login.go b/backend/handlers/login.go
index 51c90d0..777327c 100644
--- a/backend/handlers/login.go
+++ b/backend/handlers/login.go
@@ -58,8 +58,12 @@ func Login(c *gin.Context) {
 				user.LocCountryCode = "XX"
 			}
 			// Insert new user to database
-			database.DB.Exec(`INSERT INTO users (steam_id, user_name, avatar_link, country_code)
+			_, err = database.DB.Exec(`INSERT INTO users (steam_id, user_name, avatar_link, country_code)
 			VALUES ($1, $2, $3, $4)`, steamID, user.PersonaName, user.AvatarFull, user.LocCountryCode)
+			if err != nil {
+				c.JSON(http.StatusOK, models.ErrorResponse(err.Error()))
+				return
+			}
 		}
 		moderator := false
 		rows, _ := database.DB.Query("SELECT title_name FROM titles t INNER JOIN user_titles ut ON t.id=ut.title_id WHERE ut.user_id = $1", steamID)
-- 
cgit v1.2.3