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

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

2 files changed, 61 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
+}
diff --git a/model/recipes_test.go b/model/recipes_test.go
new file mode 100644
index 0000000..1d9eda1
--- /dev/null
+++ b/model/recipes_test.go
@@ -0,0 +1,24 @@
+package model
+
+import (
+	"testing"
+)
+
+func TestRecipesRead(t *testing.T) {
+	InitStorage()
+	defer RemoveStorage()
+
+	InitDatabase()
+	defer CloseDatabase()
+
+	r := make(Recipes, 0)
+
+	err := r.Read()
+	if err != nil {
+		t.Fatalf("Failed to read Recipes: %v\n", err)
+	}
+
+	if len(r) != 2 {  // TODO this needs to be aligned with model/sql/testdata.sql
+		t.Fatalf("Expected a list of one recipe but got %d", len(r))
+	}
+}