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
|
package database
import (
"database/sql"
"log"
)
type Fren struct {
Id string
Name string
}
func FindFren(dbConn *sql.DB, id string) (*Fren, error) {
row := dbConn.QueryRow(`SELECT id, name FROM frens WHERE id = ?;`, id)
var fren Fren
err := row.Scan(&fren.Id, &fren.Name)
if err != nil {
log.Println(err)
return nil, err
}
return &fren, nil
}
func FindFrenByName(dbConn *sql.DB, name string) (*Fren, error) {
row := dbConn.QueryRow(`SELECT id, name FROM frens WHERE name = ?;`, name)
var fren Fren
err := row.Scan(&fren.Id, &fren.Name)
if err != nil {
log.Println(err)
return nil, err
}
return &fren, nil
}
|
