2 files changed, 37 insertions, 0 deletions
diff --git a/model/recipe.go b/model/recipe.go
new file mode 100644
index 0000000..2b3953f
--- /dev/null
+++ b/model/recipe.go
@@ -0,0 +1,35 @@
+package model
+
+type Recipe struct {
+	Id       string  // FIXME has to be uint
+	Title    string
+	Portions string  // FIXME has to be uint
+	URL      string
+	Notes    string
+}
+
+func (d *Recipe) FromDB() error {
+	query, err := GetSql(`recipe-select`)
+	if err != nil {
+		return err
+	}
+
+	return db.QueryRow(query, d.Id).Scan(
+		&d.Id,
+		&d.Title,
+		&d.Portions,
+		&d.URL,
+		&d.Notes,
+	)
+}
+
+func (d *Recipe) ToDB() error {
+	query, err := GetSql(`recipe-update`)
+	if err != nil {
+		return err
+	}
+
+	_, err = db.Exec(query, d.Title, d.Portions, d.URL, d.Notes, d.Id)
+
+	return err
+}
diff --git a/model/sql/recipe-select.sql b/model/sql/recipe-select.sql
new file mode 100644
index 0000000..2d2bc60
--- /dev/null
+++ b/model/sql/recipe-select.sql
@@ -0,0 +1,2 @@
+SELECT id,title,portions,url,notes FROM recipes
+WHERE id=?;