model: Add type 'Recipes' with Read() method

This type is provided to render overview pages easily with a list of all
recipes.

1 files changed, 37 insertions, 0 deletions

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