model: Implement favorite recipes

This adds the ability to store a flag `is_favorite` inside the database.
The corresponding SQL migration is part of this commit.

Furthermore the Go code in the model package is adapted.

1 files changed, 11 insertions, 8 deletions

diff --git a/model/recipes.go b/model/recipes.go
index 324589a..e4fd1b8 100644
--- a/model/recipes.go
+++ b/model/recipes.go
@@ -7,8 +7,9 @@ import (
 )
 
 type RecipesElement struct {
-	Id    int64 // TODO change to string
-	Title string
+	Id         int64 // TODO change to string
+	Title      string
+	IsFavorite bool
 }
 
 type Recipes []RecipesElement
@@ -22,7 +23,7 @@ func (r *Recipes) Read(tx *sql.Tx) error {
 		return errors.New("Recipes has to contain zero elements for .Read()")
 	}
 
-	query := `SELECT id, title FROM recipes`
+	query := `SELECT id, title, is_favorite FROM recipes ORDER BY is_favorite DESC, created DESC`
 
 	rows, err := tx.Query(query)
 	if err != nil {
@@ -32,7 +33,7 @@ func (r *Recipes) Read(tx *sql.Tx) error {
 
 	for rows.Next() {
 		element := RecipesElement{}
-		err = rows.Scan(&element.Id, &element.Title)
+		err = rows.Scan(&element.Id, &element.Title, &element.IsFavorite)
 		if err != nil {
 			return err
 		}
@@ -53,12 +54,14 @@ func (r *Recipes) Delete(tx *sql.Tx) error {
 func RecipesTestData() Recipes {
 	return []RecipesElement{
 		{
-			Id:    1,
-			Title: "Pancakes",
+			Id:         1,
+			Title:      "Pancakes",
+			IsFavorite: true,
 		},
 		{
-			Id:    2,
-			Title: "Burger",
+			Id:         2,
+			Title:      "Burger",
+			IsFavorite: false,
 		},
 	}
 }