initial commit

1 files changed, 33 insertions, 0 deletions

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
+}