From 6e3c40ccb5597a93c3e9d9b4766005c6de424f85 Mon Sep 17 00:00:00 2001 From: Steven Le Rouzic Date: Sun, 21 Apr 2024 01:24:47 +0200 Subject: Start of big cleanup --- model/user.go | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'model') diff --git a/model/user.go b/model/user.go index 4959371..09562bd 100644 --- a/model/user.go +++ b/model/user.go @@ -1,8 +1,36 @@ package model +import ( + "database/sql" +) + type User struct { Id UUID Name string Salt string Password []byte } + +func GetUserByName(db *sql.DB, name string) *User { + row := db.QueryRow("SELECT Id, Name, Salt, Password FROM User WHERE Name=$1", name) + if row == nil { + return nil + } + + var user User + row.Scan(&user.Id, &user.Name, &user.Salt, &user.Password) + + return &user +} + +func GetUserById(db *sql.DB, id UUID) *User { + row := db.QueryRow("SELECT Id, Name, Salt, Password FROM User WHERE Id=$1", id) + if row == nil { + return nil + } + + var user User + row.Scan(&user.Id, &user.Name, &user.Salt, &user.Password) + + return &user +} -- cgit