RelationalDesign: dml_nutritioneer_populating_0.1.sql

File dml_nutritioneer_populating_0.1.sql, 6.3 KB (added by 201165, 2 weeks ago)

version 1_dml_pop

Line 
1
2INSERT INTO "user" (email, username, password, role) VALUES
3('admin@nutritioneer.mk', 'admin_nutri', 'testPass@1', 'administrator'),
4('marija.trajkovska@gmail.com', 'marija_t', 'testPass@1', 'user'),
5('stefan.petrov@gmail.com', 'stefan_p', 'testPass@1', 'user');
6
7
8INSERT INTO ingredient (name, description, energy, kcal, type) VALUES
9('Dry white beans', 'Dry white beans', 1393, 333, 'legume'),
10('Onion', 'Yellow onion', 167, 40, 'vegetable'),
11('Red bell pepper', 'Red bell pepper', 130, 31, 'vegetable'),
12('Sunflower oil', 'Sunflower oil', 3699, 884, 'oil'),
13('Paprika powder', 'Red paprika powder', 1180, 282, 'spice'),
14('Salt', 'Table salt', 0, 0, 'spice'),
15('Tomato', 'Fresh tomato', 75, 18, 'vegetable'),
16('Cucumber', 'Fresh cucumber', 63, 15, 'vegetable'),
17('White brine cheese', 'White brine cheese', 1105, 264, 'dairy'),
18('Olive oil', 'Olive oil', 3699, 884, 'oil'),
19('Chicken breast', 'Chicken breast, raw', 690, 165, 'meat'),
20('Bulgur', 'Bulgur wheat', 1431, 342, 'carb');
21
22
23INSERT INTO nutrient (id, description, quantity, unit, type) VALUES
24(1, 'Protein', 50, 'gram', 'macro'),
25(2, 'Total carbohydrate', 260, 'gram', 'macro'),
26(3, 'Total fat', 70, 'gram', 'macro'),
27(4, 'Dietary fibre', 30, 'gram', 'macro'),
28(5, 'Vitamin C', 80, 'milligram', 'micro'),
29(6, 'Calcium', 800, 'milligram', 'micro'),
30(7, 'Iron', 14, 'milligram', 'micro');
31
32
33INSERT INTO restriction (id, description, type) VALUES
34(1, 'Contains no ingredient of animal origin', 'vegan'),
35(2, 'Contains no meat and no fish', 'vegetarian'),
36(3, 'Contains milk protein and lactose', 'allergen'),
37(4, 'Free of gluten containing cereals', 'gluten_free'),
38(5, 'Free of lactose', 'lactose_free');
39
40INSERT INTO ingredient_contains_nutrient (ingredient_name, nutrient_id, quantity) VALUES
41('Dry white beans', 1, 21),
42('Dry white beans', 2, 60),
43('Dry white beans', 3, 1.2),
44('Dry white beans', 4, 15),
45('Dry white beans', 7, 5.5),
46('Onion', 1, 1.1),
47('Onion', 2, 9.3),
48('Onion', 3, 0.1),
49('Onion', 4, 1.7),
50('Red bell pepper', 1, 1),
51('Red bell pepper', 2, 6),
52('Red bell pepper', 3, 0.3),
53('Red bell pepper', 4, 2.1),
54('Red bell pepper', 5, 128),
55('Sunflower oil', 1, 0),
56('Sunflower oil', 2, 0),
57('Sunflower oil', 3, 100),
58('Sunflower oil', 4, 0),
59('Tomato', 1, 0.9),
60('Tomato', 2, 3.9),
61('Tomato', 3, 0.2),
62('Tomato', 4, 1.2),
63('Tomato', 5, 14),
64('Cucumber', 1, 0.7),
65('Cucumber', 2, 3.6),
66('Cucumber', 3, 0.1),
67('Cucumber', 4, 0.5),
68('White brine cheese', 1, 14),
69('White brine cheese', 2, 2),
70('White brine cheese', 3, 21),
71('White brine cheese', 6, 493),
72('Olive oil', 1, 0),
73('Olive oil', 2, 0),
74('Olive oil', 3, 100),
75('Chicken breast', 1, 31),
76('Chicken breast', 2, 0),
77('Chicken breast', 3, 3.6),
78('Bulgur', 1, 12),
79('Bulgur', 2, 76),
80('Bulgur', 3, 1.3),
81('Bulgur', 4, 18);
82
83
84INSERT INTO recipe (id, name, guide, kcal_sum, servings, user_email) VALUES
85(1, 'Tavce Gravce',
86 'Soak the beans overnight, boil them, fry the onion with paprika, bake everything together.',
87 2350, 6, 'marija.trajkovska@gmail.com'),
88(2, 'Shopska Salad',
89 'Dice the tomato and cucumber, add oil and salt, grate the cheese on top.',
90 800, 4, 'stefan.petrov@gmail.com'),
91(3, 'Chicken Bulgur Bowl',
92 'Boil the bulgur, grill the chicken, put it together with the vegetables.',
93 1560, 3, 'marija.trajkovska@gmail.com');
94
95
96INSERT INTO recipe_contains_ingredient (recipe_id, ingredient_name, ingredient_quantity) VALUES
97(1, 'Dry white beans', 500),
98(1, 'Onion', 200),
99(1, 'Red bell pepper', 100),
100(1, 'Sunflower oil', 60),
101(1, 'Paprika powder', 10),
102(1, 'Salt', 8),
103(2, 'Tomato', 400),
104(2, 'Cucumber', 300),
105(2, 'Onion', 80),
106(2, 'White brine cheese', 150),
107(2, 'Olive oil', 30),
108(2, 'Salt', 5),
109(3, 'Chicken breast', 400),
110(3, 'Bulgur', 200),
111(3, 'Tomato', 150),
112(3, 'Cucumber', 100),
113(3, 'Olive oil', 20),
114(3, 'Salt', 5);
115
116
117INSERT INTO recipe_contains_restriction (recipe_id, restriction_id) VALUES
118(1, 1),
119(1, 2),
120(1, 4),
121(1, 5),
122(2, 2),
123(2, 3),
124(2, 4),
125(3, 5);
126
127
128INSERT INTO post (id, created_by, recipe_id, is_private, is_favourite, status) VALUES
129(1, 'marija.trajkovska@gmail.com', 1, FALSE, TRUE, 'published'),
130(2, 'stefan.petrov@gmail.com', 2, FALSE, FALSE, 'published'),
131(3, 'marija.trajkovska@gmail.com', 3, FALSE, FALSE, 'draft');
132
133
134INSERT INTO comment (id, description, post_id, created_by) VALUES
135(1, 'Exactly how my grandmother made it.', 1, 'stefan.petrov@gmail.com'),
136(2, 'How long do the beans need to soak?', 1, 'stefan.petrov@gmail.com'),
137(3, 'Simple and perfect.', 2, 'marija.trajkovska@gmail.com');
138
139
140INSERT INTO grocery_list (id, date_time, notes, is_bought, kcal, user_email) VALUES
141(1, '2026-01-11 10:00:00', 'Weekly shopping', TRUE, 2350, 'marija.trajkovska@gmail.com');
142
143INSERT INTO grocery_list_bulk_add_ingredient (list_id, recipe_id) VALUES
144(1, 1);
145
146INSERT INTO grocery_list_single_add_ingredient (list_id, ingredient_name, buy_quantity) VALUES
147(1, 'Sunflower oil', 1000),
148(1, 'Salt', 500);
149
150
151INSERT INTO intake_planner (id, date_time, notes, kcal, is_consumed, user_email) VALUES
152(1, '2026-01-22 13:00:00', 'Lunch at home', 390, TRUE, 'marija.trajkovska@gmail.com'),
153(2, '2026-01-22 19:30:00', 'Light dinner', 200, TRUE, 'marija.trajkovska@gmail.com'),
154(3, '2026-01-23 13:15:00', 'Lunch', 520, TRUE, 'stefan.petrov@gmail.com');
155
156INSERT INTO intake_planner_save_to_list_post (planner_id, post_id) VALUES
157(1, 1),
158(2, 2),
159(3, 3);
160
161INSERT INTO biometrics (id, date, weight, height, age, muscle_fat_ratio, user_email) VALUES
162(1, '2026-01-05', 74.5, 168, 29, 1.80, 'marija.trajkovska@gmail.com'),
163(2, '2026-01-12', 73.8, 168, 29, 1.84, 'marija.trajkovska@gmail.com'),
164(3, '2026-01-06', 88.2, 182, 34, 2.10, 'stefan.petrov@gmail.com');