1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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
}
|
