model: Inject test data into database

This is useful for debugging and testing.

1 files changed, 13 insertions, 0 deletions

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')
+;