From 43fdfde44bce659abd30186150f667d8ba24cf2b Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Sun, 11 Feb 2024 21:07:05 +0100
Subject: model: Add type 'Recipes' with Read() method

This type is provided to render overview pages easily with a list of all
recipes.
---
 model/recipes.go | 37 +++++++++++++++++++++++++++++++++++++
 1 file changed, 37 insertions(+)
 create mode 100644 model/recipes.go

(limited to 'model/recipes.go')

diff --git a/model/recipes.go b/model/recipes.go
new file mode 100644
index 0000000..bdd1cc1
--- /dev/null
+++ b/model/recipes.go
@@ -0,0 +1,37 @@
+package model
+
+import (
+	"errors"
+)
+
+type RecipesElement struct {
+	Id          int64
+	Title       string
+}
+
+type Recipes []RecipesElement
+
+func (r *Recipes) Read() error {
+	if len(*r) != 0 {
+		return errors.New("Recipes has to contain zero elements for .Read()")
+	}
+
+	query := `SELECT id, title FROM recipes`
+
+	rows, err := db.Query(query)
+	if err != nil {
+		return err
+	}
+	defer rows.Close()
+
+	for rows.Next() {
+		element := RecipesElement{}
+		err = rows.Scan(&element.Id, &element.Title)
+		if err != nil {
+			return err
+		}
+		*r = append(*r, element)
+	}
+
+	return nil
+}
-- 
cgit v1.2.3-70-g09d2