blob: e2bac38864f42767c0d93cfb2eccb7a40da750b3 (
plain) (
blame)
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
package db
import (
"crypto/subtle"
"database/sql"
)
type AuthProvider interface {
SaltedHash(username string) [32]byte
Salt(username string) [16]byte
UserExists(username string) bool
}
type DBAuthProvider struct {
db *sql.DB
}
func NewDBAuthProvider(db *sql.DB) AuthProvider {
provider := new(DBAuthProvider)
provider.db = db
return provider
}
func (dbAuth DBAuthProvider) Close() {
dbAuth.db.Close()
}
func (dbAuth DBAuthProvider) SaltedHash(username string) [32]byte {
row := dbAuth.db.QueryRow(`
SELECT saltedhash FROM users WHERE username = ?
`, username)
buf := make([]byte, 32)
should_copy := 1
saltedHash := [32]byte{0}
err := row.Scan(&buf)
if err != nil {
should_copy = 0
}
subtle.ConstantTimeCopy(should_copy, saltedHash[:], buf[:32])
return saltedHash
}
func (dbAuth DBAuthProvider) Salt(username string) [16]byte {
row := dbAuth.db.QueryRow(`
SELECT salt FROM users WHERE username = ?
`, username)
buf := make([]byte, 16)
should_copy := 1
salt := [16]byte{0}
err := row.Scan(&buf)
if err != nil {
should_copy = 0
}
subtle.ConstantTimeCopy(should_copy, salt[:], buf[:16])
return salt
}
func (dbAuth DBAuthProvider) UserExists(username string) bool {
row := dbAuth.db.QueryRow(`
SELECT 1 FROM users WHERE username = ?
`, username)
err := row.Scan(new(int))
if err != nil {
return false
}
return true
}
|
