LogicAndPhysicalDeisgn: polnenje.sql

delete from UserHasProgram;
delete from UserHasDay;
delete from DayHasMeal;
delete from MealHasIngredient;
delete from DayHasWorkout;
delete from WorkoutHasExercise;
delete from WorkoutProgramHasWorkout;

delete from _User;
delete from _Day;
delete from Meal;
delete from Ingredient;
delete from PersonalizedIngredient;
delete from Workout;
delete from Exercise;
delete from PersonalizedExercise;
delete from WorkoutProgram;



INSERT INTO _User (uID, name, password, age, height, weight, role)
VALUES 
    (1, 'JohnDoe', 'password123', 25, 180, 75, 'user'),
    (2, 'JaneDoe', 'securepass', 30, 165, 60, 'admin');



   
INSERT INTO _Day (dID, date)
VALUES 
    (1, '2024-02-08'),
    (2, '2024-02-09');


   
INSERT INTO Workout (wID, duration, name, uID)
VALUES 
    (1, 60, 'Morning Workout', 1),
    (2, 45, 'Evening Workout', 2);


   
INSERT INTO Meal (mID, name, type, uID)
VALUES 
    (1, 'Breakfast', 'Healthy', 1),
    (2, 'Lunch', 'Balanced', 2);


   INSERT INTO Ingredient (iID, name, calories, protein, carbs, fats)
VALUES 
    (1, 'Eggs', 70, 6, 1, 5),
    (2, 'Chicken Breast', 165, 31, 0, 3);


   
INSERT INTO PersonalizedIngredient (piID, quantity, iID)
VALUES 
    (1, 2, 1),
    (2, 150, 2);


   
INSERT INTO Exercise (eID, name, type)
VALUES 
    (1, 'Running', 'Cardio'),
    (2, 'Bench Press', 'Bodybuilding');


   
INSERT INTO PersonalizedExercise (pID, reps, sets, weight, time, eID)
VALUES 
    (1, 10, 3, 50, NULL, 1),
    (2, 12, 4, 80, NULL, 2);


   
INSERT INTO WorkoutProgram (wpID, name)
VALUES 
    (1, 'Weight Loss Program'),
    (2, 'Muscle Building Program');


   
INSERT INTO UserHasDay (uID, dID)
VALUES 
    (1, 1),
    (2, 2);


   
INSERT INTO UserHasProgram (uID, wpID)
VALUES 
    (1, 1),
    (2, 2);



INSERT INTO DayHasWorkout (wID, dID)
VALUES 
    (1, 1),
    (2, 2);


   
INSERT INTO WorkoutProgramHasWorkout (wID, wpID)
VALUES 
    (1, 1),
    (2, 2);

   
INSERT INTO DayHasMeal (mID, dID)
VALUES 
    (1, 1),
    (2, 2);


INSERT INTO MealHasIngredient (mID, iID)
VALUES 
    (1, 1),
    (2, 2);


INSERT INTO WorkoutHasExercise (eID, wID)
VALUES 
    (1, 1),
    (2, 2);