19 lines
408 B
Go
19 lines
408 B
Go
package user
|
|
|
|
import (
|
|
"database/sql"
|
|
)
|
|
|
|
type Password struct {
|
|
password sql.NullString
|
|
}
|
|
|
|
func Verify(db *sql.DB, username string, password string) (bool, error) {
|
|
row := db.QueryRow("SELECT password FROM users WHERE username = ?;", username)
|
|
dbPassword := &Password{}
|
|
err := row.Scan(&dbPassword.password)
|
|
if err != nil {
|
|
return false, err
|
|
}
|
|
return (dbPassword.password.String == password), nil
|
|
} |