From 8ce328fafd9b2ad152f0afc16176cf01e1e66669 Mon Sep 17 00:00:00 2001
From: xengineering <me@xengineering.eu>
Date: Wed, 27 Dec 2023 13:04:26 +0100
Subject: model: Inject test data into database

This is useful for debugging and testing.
---
 model/database.go      |  2 +-
 model/sql/testdata.sql | 13 +++++++++++++
 2 files changed, 14 insertions(+), 1 deletion(-)
 create mode 100644 model/sql/testdata.sql

diff --git a/model/database.go b/model/database.go
index 8ce1897..fac4d35 100644
--- a/model/database.go
+++ b/model/database.go
@@ -38,7 +38,7 @@ func InitDatabase() {
 		log.Fatal(err)
 	}
 
-	for _, v := range []string{`migrate`} {
+	for _, v := range []string{`migrate`, `testdata`} {
 		query, err := GetSql(v)
 		if err != nil {
 			log.Fatal(err)
diff --git a/model/sql/testdata.sql b/model/sql/testdata.sql
new file mode 100644
index 0000000..f2cd6e3
--- /dev/null
+++ b/model/sql/testdata.sql
@@ -0,0 +1,13 @@
+INSERT INTO 'recipes'
+	('id', 'title', 'portions', 'url', 'notes')
+VALUES
+	(1, 'Pancakes', 4, 'https://example.org', 'Very fluffy'),
+	(2, 'Burger', 2, 'https://xengineering.eu/git/ceres', 'Delicious!')
+;
+
+INSERT INTO 'recipe_steps'
+	('id', 'recipe_id', 'rank', 'text')
+VALUES
+	(1, 1, 1, 'Stir the dough'),
+	(2, 1, 2, 'Fry pancakes')
+;
-- 
cgit v1.2.3-70-g09d2