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/sql/testdata.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 model/sql/testdata.sql

(limited to 'model/sql/testdata.sql')

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.3

