INSERT INTO "user" (email, username, password, role) VALUES
('admin@nutritioneer.mk',       'admin_nutri', 'testPass@1', 'administrator'),
('marija.trajkovska@gmail.com', 'marija_t',    'testPass@1', 'user'),
('stefan.petrov@gmail.com',     'stefan_p',    'testPass@1', 'user');


INSERT INTO ingredient (name, description, energy, kcal, type) VALUES
('Dry white beans',    'Dry white beans',        1393, 333, 'legume'),
('Onion',              'Yellow onion',            167,  40, 'vegetable'),
('Red bell pepper',    'Red bell pepper',         130,  31, 'vegetable'),
('Sunflower oil',      'Sunflower oil',          3699, 884, 'oil'),
('Paprika powder',     'Red paprika powder',     1180, 282, 'spice'),
('Salt',               'Table salt',                0,   0, 'spice'),
('Tomato',             'Fresh tomato',             75,  18, 'vegetable'),
('Cucumber',           'Fresh cucumber',           63,  15, 'vegetable'),
('White brine cheese', 'White brine cheese',     1105, 264, 'dairy'),
('Olive oil',          'Olive oil',              3699, 884, 'oil'),
('Chicken breast',     'Chicken breast, raw',     690, 165, 'meat'),
('Bulgur',             'Bulgur wheat',           1431, 342, 'carb');


INSERT INTO nutrient (id, description, quantity, unit, type) VALUES
(1, 'Protein',            50, 'gram',      'macro'),
(2, 'Total carbohydrate', 260, 'gram',     'macro'),
(3, 'Total fat',          70, 'gram',      'macro'),
(4, 'Dietary fibre',      30, 'gram',      'macro'),
(5, 'Vitamin C',          80, 'milligram', 'micro'),
(6, 'Calcium',           800, 'milligram', 'micro'),
(7, 'Iron',               14, 'milligram', 'micro');


INSERT INTO restriction (id, description, type) VALUES
(1, 'Contains no ingredient of animal origin', 'vegan'),
(2, 'Contains no meat and no fish',            'vegetarian'),
(3, 'Contains milk protein and lactose',       'allergen'),
(4, 'Free of gluten containing cereals',       'gluten_free'),
(5, 'Free of lactose',                         'lactose_free');

INSERT INTO ingredient_contains_nutrient (ingredient_name, nutrient_id, quantity) VALUES
('Dry white beans',    1, 21),
('Dry white beans',    2, 60),
('Dry white beans',    3, 1.2),
('Dry white beans',    4, 15),
('Dry white beans',    7, 5.5),
('Onion',              1, 1.1),
('Onion',              2, 9.3),
('Onion',              3, 0.1),
('Onion',              4, 1.7),
('Red bell pepper',    1, 1),
('Red bell pepper',    2, 6),
('Red bell pepper',    3, 0.3),
('Red bell pepper',    4, 2.1),
('Red bell pepper',    5, 128),
('Sunflower oil',      1, 0),
('Sunflower oil',      2, 0),
('Sunflower oil',      3, 100),
('Sunflower oil',      4, 0),
('Tomato',             1, 0.9),
('Tomato',             2, 3.9),
('Tomato',             3, 0.2),
('Tomato',             4, 1.2),
('Tomato',             5, 14),
('Cucumber',           1, 0.7),
('Cucumber',           2, 3.6),
('Cucumber',           3, 0.1),
('Cucumber',           4, 0.5),
('White brine cheese', 1, 14),
('White brine cheese', 2, 2),
('White brine cheese', 3, 21),
('White brine cheese', 6, 493),
('Olive oil',          1, 0),
('Olive oil',          2, 0),
('Olive oil',          3, 100),
('Chicken breast',     1, 31),
('Chicken breast',     2, 0),
('Chicken breast',     3, 3.6),
('Bulgur',             1, 12),
('Bulgur',             2, 76),
('Bulgur',             3, 1.3),
('Bulgur',             4, 18);


INSERT INTO recipe (id, name, guide, kcal_sum, servings, user_email) VALUES
(1, 'Tavce Gravce',
    'Soak the beans overnight, boil them, fry the onion with paprika, bake everything together.',
    2350, 6, 'marija.trajkovska@gmail.com'),
(2, 'Shopska Salad',
    'Dice the tomato and cucumber, add oil and salt, grate the cheese on top.',
    800, 4, 'stefan.petrov@gmail.com'),
(3, 'Chicken Bulgur Bowl',
    'Boil the bulgur, grill the chicken, put it together with the vegetables.',
    1560, 3, 'marija.trajkovska@gmail.com');


INSERT INTO recipe_contains_ingredient (recipe_id, ingredient_name, ingredient_quantity) VALUES
(1, 'Dry white beans',   500),
(1, 'Onion',             200),
(1, 'Red bell pepper',   100),
(1, 'Sunflower oil',      60),
(1, 'Paprika powder',     10),
(1, 'Salt',                8),
(2, 'Tomato',            400),
(2, 'Cucumber',          300),
(2, 'Onion',              80),
(2, 'White brine cheese', 150),
(2, 'Olive oil',          30),
(2, 'Salt',                5),
(3, 'Chicken breast',    400),
(3, 'Bulgur',            200),
(3, 'Tomato',            150),
(3, 'Cucumber',          100),
(3, 'Olive oil',          20),
(3, 'Salt',                5);


INSERT INTO recipe_contains_restriction (recipe_id, restriction_id) VALUES
(1, 1),
(1, 2),
(1, 4),
(1, 5),
(2, 2),
(2, 3),
(2, 4),
(3, 5);


INSERT INTO post (id, created_by, recipe_id, is_private, is_favourite, status) VALUES
(1, 'marija.trajkovska@gmail.com', 1, FALSE, TRUE,  'published'),
(2, 'stefan.petrov@gmail.com',     2, FALSE, FALSE, 'published'),
(3, 'marija.trajkovska@gmail.com', 3, FALSE, FALSE, 'draft');


INSERT INTO comment (id, description, post_id, created_by) VALUES
(1, 'Exactly how my grandmother made it.', 1, 'stefan.petrov@gmail.com'),
(2, 'How long do the beans need to soak?', 1, 'stefan.petrov@gmail.com'),
(3, 'Simple and perfect.',                 2, 'marija.trajkovska@gmail.com');


INSERT INTO grocery_list (id, date_time, notes, is_bought, kcal, user_email) VALUES
(1, '2026-01-11 10:00:00', 'Weekly shopping', TRUE, 2350, 'marija.trajkovska@gmail.com');

INSERT INTO grocery_list_bulk_add_ingredient (list_id, recipe_id) VALUES
(1, 1);

INSERT INTO grocery_list_single_add_ingredient (list_id, ingredient_name, buy_quantity) VALUES
(1, 'Sunflower oil', 1000),
(1, 'Salt',           500);


INSERT INTO intake_planner (id, date_time, notes, kcal, is_consumed, user_email) VALUES
(1, '2026-01-22 13:00:00', 'Lunch at home', 390, TRUE, 'marija.trajkovska@gmail.com'),
(2, '2026-01-22 19:30:00', 'Light dinner',  200, TRUE, 'marija.trajkovska@gmail.com'),
(3, '2026-01-23 13:15:00', 'Lunch',         520, TRUE, 'stefan.petrov@gmail.com');

INSERT INTO intake_planner_save_to_list_post (planner_id, post_id) VALUES
(1, 1),
(2, 2),
(3, 3);

INSERT INTO biometrics (id, date, weight, height, age, muscle_fat_ratio, user_email) VALUES
(1, '2026-01-05', 74.5, 168, 29, 1.80, 'marija.trajkovska@gmail.com'),
(2, '2026-01-12', 73.8, 168, 29, 1.84, 'marija.trajkovska@gmail.com'),
(3, '2026-01-06', 88.2, 182, 34, 2.10, 'stefan.petrov@gmail.com');