2 files changed, 35 insertions, 0 deletions
diff --git a/model/recipe_step.go b/model/recipe_step.go
new file mode 100644
index 0000000..980d312
--- /dev/null
+++ b/model/recipe_step.go
@@ -0,0 +1,33 @@
+package model
+
+import (
+	"log"
+)
+
+type RecipeStep struct {
+	Id       string  // FIXME has to be uint
+	RecipeId string  // FIXME has to be uint
+	Index    string  // FIXME has to be uint
+	Text     string
+}
+
+func (d *RecipeStep) String() string {
+	return d.Text
+}
+
+func (d *RecipeStep) FromDB() error {
+	query, err := GetSql(`recipe-step-select`)
+	if err != nil {
+		return err
+	}
+
+	err = db.QueryRow(query, d.Id).Scan(
+		&d.Id,
+		&d.RecipeId,
+		&d.Index,
+		&d.Text,
+	)
+
+	log.Printf("d.Text: %s %s %s %s\n", d.Id, d.RecipeId, d.Index, d.Text)
+	return err
+}
diff --git a/model/sql/recipe-step-select.sql b/model/sql/recipe-step-select.sql
new file mode 100644
index 0000000..0aba980
--- /dev/null
+++ b/model/sql/recipe-step-select.sql
@@ -0,0 +1,2 @@
+SELECT id,recipe_id,"index",text FROM recipe_steps
+WHERE id=?;