From f163a242792cd325c9414587d52f3d8584f28df1 Mon Sep 17 00:00:00 2001 From: Elizabeth Hunt Date: Fri, 3 Jan 2025 01:47:07 -0800 Subject: initial commit --- database/frens.go | 33 +++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 database/frens.go (limited to 'database/frens.go') diff --git a/database/frens.go b/database/frens.go new file mode 100644 index 0000000..b8b72ad --- /dev/null +++ b/database/frens.go @@ -0,0 +1,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 +} -- cgit v1.2.3-70-g09d2