0001-added-test-data.patch

From 9e826f30ee3c84bb2f30558547fc465c5d727a3c Mon Sep 17 00:00:00 2001
From: Johan Brinch <[email protected]>
Date: Fri, 9 Oct 2009 17:22:14 +0200
Subject: [PATCH] added test data

---
 test-data.sql |  112 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 112 insertions(+), 0 deletions(-)
 create mode 100644 test-data.sql

diff --git a/test-data.sql b/test-data.sql
new file mode 100644
index 0000000..909f8ec
--- /dev/null
+++ b/test-data.sql
@@ -0,0 +1,112 @@
+-- TEST DATA
+
+-- gimoas'
+INSERT INTO gimoas (
+       001, 'g', 1.0, '2009-01-01', '2010-01-01'
+);
+INSERT INTO gimoas (
+       002, 'i', 1.0, '2009-01-01', '2010-01-01'
+);
+INSERT INTO gimoas (
+       003, 'm', 1.0, '2009-01-01', '2010-01-01'
+);
+INSERT INTO gimoas (
+       004, 'o', 1.0, '2009-01-01', '2010-01-01'
+);
+INSERT INTO gimoas (
+       005, 'a', 1.0, '2009-01-01', '2010-01-01'
+);
+INSERT INTO gimoas (
+       006, 's', 1.0, '2009-01-01', '2010-01-01'
+);
+
+-- eaters
+INSERT INTO eater (
+       101, 'Homer'
+);
+INSERT INTO eater (
+       102, 'Marge'
+);
+INSERT INTO eater (
+       103, 'Bart'
+);
+INSERT INTO eater (
+       104, 'Lisa'
+);
+INSERT INTO eater (
+       105, 'Maggie'
+);
+
+-- recipies
+INSERT INTO recipe (
+       201, 'Pork Chops',
+       'http://justbraise.blogspot.com/2006/10/braised-pork-chops-w-apples.html'
+);
+INSERT INTO recipe (
+       202, 'Bacon Puff Rolls',
+       'http://homecooking.about.com/od/beefrecipes/r/blbeef175.htm'
+);
+INSERT INTO recipe (
+       203, 'MeatLoaf',
+       'http://www.tastymeatloafrecipes.com/easymeatloaf.htm'
+);
+INSERT INTO recipe (
+       204, 'BBQ Beef Ribs',
+       'http://www.bbq.co.uk/bbq-recipes/beef/bbq-beef-ribs-with-cabernet-sauce.htm'
+);
+INSERT INTO recipe (
+       205, 'Pumpkin Pancakes',
+       'http://www.halloweenishere.com/recpumpkin.html'
+);
+
+
+-- meals
+INSERT INTO meal (
+       301, '2009-10-31', 105
+);
+
+
+-- eater_meal_gimoas
+-- homer just eats
+INSERT INTO eater_meal_gimoas (
+       101, 301, 006, -1.0
+);
+
+-- marge does all the work
+INSERT INTO eater_meal_gimoas (
+       102, 301, 001, 1.0
+);
+INSERT INTO eater_meal_gimoas (
+       102, 301, 002, 1.0
+);
+INSERT INTO eater_meal_gimoas (
+       102, 301, 003, 1.0
+);
+INSERT INTO eater_meal_gimoas (
+       102, 301, 004, 1.0
+);
+INSERT INTO eater_meal_gimoas (
+       102, 301, 006, -1.0
+);
+
+-- bart helps when told to
+INSERT INTO eater_meal_gimoas (
+       102, 301, 004, 1.0
+);
+INSERT INTO eater_meal_gimoas (
+       102, 301, 006, -1.0
+);
+
+-- lisa helps because its fun (when bart is not there)
+INSERT INTO eater_meal_gimoas (
+       102, 301, 001, 1.0
+);
+INSERT INTO eater_meal_gimoas (
+       102, 301, 002, 1.0
+);
+INSERT INTO eater_meal_gimoas (
+       102, 301, 003, 1.0
+);
+INSERT INTO eater_meal_gimoas (
+       102, 301, 006, -1.0
+);
-- 
1.6.5.rc1