SQL_inserts.sql

-- INSERTING DATA:
-- COACHES:
-- Password for coaches : Alan@123 - $2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa
SELECT * FROM coaches;
SELECT * FROM athletes;

-- Alan Hunt    Football, Basketball, Wrestling
-- Emma Williams Football, Tennis, Swimming
-- Jenny B       Football, Basketball, Swimming
-- TJ            Basketball,  Tennis, Wrestling


-- -- 1
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (1, 'Michael Johnson', '6691114467', 'michael.johnson@harvard.com', 25, 'Football', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 2
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (2, 'Emily Davis', '6692225678', 'emily.davis@harvard.com', 22, 'Football', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 3
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (3, 'David Smith', '6693336789', 'david.smith@harvard.com', 27, 'Football', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 4
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (4, 'Sophia Chen', '6694447890', 'sophia.chen@harvard.com', 23, 'Football', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 5
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (5, 'Matthew Brown', '7165558901', 'matthew.brown@harvard.com', 24, 'Football', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 6
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (6, 'Olivia Rodriguez', '7166669012', 'olivia.rodriguez@harvard.com', 26, 'Football', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 7
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (7, 'Ethan Williams', '7167770123', 'ethan.williams@harvard.com', 21, 'Football', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 8
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (8,'Ava Miller', '7168881234', 'ava.miller@harvard.com', 28, 'Football', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 9
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (9,'William Taylor', '7169992345', 'william.taylor@harvard.com', 22, 'Football', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 10
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (10, 'Emma Martinez', '7160103456', 'emma.martinez@harvard.com', 25, 'Football', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');




-- -- Mens and Womens Basketball
-- -- 11
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (11,'Benjamin Turner', '5151114567', 'benjamin.turner@harvard.edu', 26, 'Basketball', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 12
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (12, 'Natalie Foster', '5252225678', 'natalie.foster@harvard.edu', 23, 'Basketball', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 13
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (13,'Cameron Mitchell', '5353336789', 'cameron.mitchell@harvard.edu', 24, 'Basketball', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 14
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (14,'Alyssa Baker', '5454447890', 'alyssa.baker@harvard.edu', 22, 'Basketball', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 15
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (15,'Dylan Carter', '5555558901', 'dylan.carter@harvard.edu', 27, 'Basketball', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 16
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (16,'Megan Thompson', '5656669012', 'megan.thompson@harvard.edu', 24, 'Basketball', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 17
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (17,'Ryan Collins', '5757770123', 'ryan.collins@harvard.edu', 25, 'Basketball', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 18
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (18,'Hailey White', '5858881234', 'hailey.white@harvard.edu', 22, 'Basketball', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 19
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (19,'Evan Anderson', '5959992345', 'evan.anderson@harvard.edu', 26, 'Basketball', 'male', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 20
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (20,'Hannah Davis', '5050103456', 'hannah.davis@harvard.edu', 23, 'Basketball', 'female', 'Harvard', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');



-- -- 21
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (21,'Jordan Miller', '7641114567', 'jordan.miller@daemen.edu', 24, 'Tennis', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 22
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (22,'Madison Turner', '7642225678', 'madison.turner@daemen.edu', 22, 'Basketball', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 23

-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (23,'Carter Davis', '7643456789', 'carter.davis@daemen.edu', 26, 'Tennis', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 24
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (24,'Olivia Foster', '7644567890', 'olivia.foster@daemen.edu', 23, 'Basketball', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 25
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (25,'Ethan Baker', '7645678901', 'ethan.baker@daemen.edu', 27, 'Tennis', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 26
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (26,'Ava Collins', '7646789012', 'ava.collins@daemen.edu', 24, 'Basketball', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 27
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (27,'Tyler White', '7647890123', 'tyler.white@daemen.edu', 25, 'Tennis', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 28
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (28,'Emma Anderson', '7648901234', 'emma.anderson@daemen.edu', 22, 'Basketball', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 29
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (29,'Logan Taylor', '7649012345', 'logan.taylor@daemen.edu', 26, 'Tennis', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- -- 30
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (30,'Sophie Davis', '7640123456', 'sophie.davis@daemen.edu', 23, 'Basketball', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 31
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (36,'Michael Thompson', '4566666666', 'michael.thompson@daemen.edu', 28, 'Basketball', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 32
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (37,'Christopher Davis', '4567777777', 'christopher.davis@daemen.edu', 25, 'Basketball', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 33
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (38,'Andrew Wilson', '4568888888', 'andrew.wilson@daemen.edu', 27, 'Basketball', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 34
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (39,'Jonathan Smith', '4569999999', 'jonathan.smith@daemen.edu', 24, 'Basketball', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 35
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (40,'Matthew Turner', '4560000000', 'matthew.turner@daemen.edu', 26, 'Basketball', 'male', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 36
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (41,'Emma Thompson', '8326666666', 'emma.thompson@daemen.edu', 28, 'Tennis', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 37
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (42,'Sophia Davis', '8327777777', 'sophia.davis@daemen.edu', 25, 'Tennis', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 38
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (43,'Olivia Wilson', '8328888888', 'olivia.wilson@daemen.edu', 27, 'Tennis', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 39
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (44,'Isabella Smith', '8329999999', 'isabella.smith@daemen.edu', 24, 'Tennis', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

-- 40
INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
VALUES (45,'Ava Turner', '8320000000', 'ava.turner@daemen.edu', 26, 'Tennis', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');


-- -- PERSONAL ATHLETES
-- INSERT INTO athletes (athlete_id , name, phone, email, age, sports, gender, institute, password)
-- VALUES (30,'Shawn Mendes', '6694563456', 'Shawn.mendes@daemen.edu', 23, 'Basketball', 'female', 'Daemen University', '$2b$12$FdvZ8SQtvi8yHWRTsjUfB.vuQSA/SMm2bzGCiOIZgBk3vBzYXg2Qa');

SELECT * FROM sports;

-- 1 ,3,5,7,9 - Harvard Mens Football
-- 2,4,6,8,10 - Harvard Womens Football

-- 11,13,15,17,19 - Harvard Mens BasketBall
-- 12,14,16,18,20 - Harvard Womens BasketBall

-- 21,23,25,27,29 - Daemen Mens Tennis
-- 22,24,26,28,30 - Daemen Womens BasketBall

-- ////////////////////////////////////////////////////////////////////////////////////////////////
-- CREATING TEAMS
SELECT * FROM coaches;
SELECT * FROM teams;
INSERT INTO teams(name, sport, coach_id)
VALUES ('Harvard Crimson Mens Football','football', 3),
 ('Harvard Hawks  Mens Basketball','basketball', 3);

INSERT INTO teams(name, sport, coach_id)
VALUES ('Harvard Crimson Womens Football','football', 4),
 ('Harvard Hawks  Womens Basketball','basketball', 4);

 
 INSERT INTO teams( name, sport, coach_id)
VALUES ('Daemen Wildcats Mens Basketball','basketball', 2),
 ('Daemen Thunder Tennis','tennis', 2);

INSERT INTO teams(name, sport, coach_id)
VALUES ('Daemen Wildcats Womens Basketball','basketball', 5),
 ('Daemen Dragons Womens Football','football', 5);
 
 
-- ////////////////////////////////////////////////////////////////////////////////////////////////
-- ASSIGNING PLAYERS
SELECT * FROM athletes;
SELECT * FROM coaches;
WHERE sports IN ('Football,BasketBall');
1	Harvard Crimson Mens Football	football	3
2	Harvard Hawks  Mens Basketball	basketball	3
3	Harvard Crimson Womens Football	football	4
4	Harvard Hawks  Womens Basketball	basketball	4
5	Daemen Wildcats Mens Basketball	basketball	2
6	Daemen Thunder Tennis	tennis	2
7	Daemen Wildcats Womens Basketball	basketball	5
8	Daemen Dragons Womens Football	football	5

SELECT * FROM team_memberships;
SELECT * FROM teams;


-- INSERTING PREDEFINED EXERCISES:

Select * from define_exercise;
Select * from category;
Select * from exercise_type;

CREATE TABLE category (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL UNIQUE
);

CREATE TABLE exercise_type (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL UNIQUE,
    category_id INT,
    FOREIGN KEY (category_id) REFERENCES category (id)
);

CREATE TABLE define_exercise (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    type_id INT,
    FOREIGN KEY (type_id) REFERENCES exercise_type (id)
);

INSERT INTO category (name) VALUES
    ('Cardio'),
    ('Strength training'),
    ('Core'),
    ('Yoga');

-- Cardio
INSERT INTO exercise_type (name, category_id) VALUES
    ('Treadmill', 1),
    ('Elliptical', 1),
    ('Stationary bike', 1),
    ('Rowing machine', 1),
    ('Stair climber', 1);

-- Strength training
INSERT INTO exercise_type (name, category_id) VALUES
    ('Push', 2),
    ('Pull', 2),
    ('Hip hinge', 2),
    ('Squat', 2);

-- Core
INSERT INTO exercise_type (name, category_id) VALUES
    ('Plank', 3),
    ('Crunches', 3),
    ('Russian twists', 3);

-- Yoga
INSERT INTO exercise_type (name, category_id) VALUES
    ('Downward-facing dog', 4),
    ('Warrior I pose', 4),
    ('Triangle pose', 4),
    ('Tree pose', 4),
    ('Bridge pose', 4);
    

-- Define exercise

-- Cardio exercises
INSERT INTO define_exercise (name, type_id) VALUES
    ('Running', 1),
    ('Elliptical training', 2),
    ('Cycling', 3),
    ('Rowing', 4),
    ('Stair climbing', 5);

-- Strength training exercises (Push)
INSERT INTO define_exercise (name, type_id) VALUES
    ('Bench press', 6),
    ('Overhead press', 6),
    ('Push-ups', 7),
    ('Machine chest press', 8);

-- Strength training exercises (Pull)
INSERT INTO define_exercise (name, type_id) VALUES
    ('Pull-ups', 9),
    ('Lat pulldown', 9),
    ('Barbell row', 10),
    ('Dumbbell row', 10),
    ('Cable row', 10);

-- ... and so on for the remaining exercises in 'Strength training'

-- Core exercises (Plank)
INSERT INTO define_exercise (name, type_id) VALUES
    ('Plank', 11),
    ('Side plank', 11),
    ('Knee raise plank', 11),
    ('Hollow body hold', 11);

-- Core exercises (Crunches)
INSERT INTO define_exercise (name, type_id) VALUES
    ('Crunches', 12),
    ('Leg raises', 12),
    ('Sit-ups', 12);

-- ... and so on for the remaining exercises in 'Core'

-- Yoga exercises (Downward-facing dog)
INSERT INTO define_exercise (name, type_id) VALUES
    ('Downward-facing dog', 13);

-- Yoga exercises (Warrior I pose)
INSERT INTO define_exercise (name, type_id) VALUES
    ('Warrior I pose', 14);

-- extras

-- Downwarf facing
INSERT INTO define_exercise (name, type_id) VALUES
    ('Puppy pose', 13),
    ('Chils pose', 13),
    ('Upward facing dog', 13),
    ('Corpse pose', 13);

-- Push
INSERT INTO define_exercise (name, type_id) VALUES
    ('Machine shoulder press', 6),
    ('Dumbbell bench press', 6),
    ('Incline bench press', 6),
    ('Machine flyes', 6);

-- Pull
INSERT INTO define_exercise (name, type_id) VALUES
    ('Chest-supported T-bar row', 7),
    ('Wide-grip pull-ups', 7),
    ('Close-grip pull-ups', 7),
    ('Resistance band face pulls', 7);

-- Crunches
INSERT INTO define_exercise (name, type_id) VALUES
    ('Chest-supported T-bar row', 11),
    ('Wide-grip pull-ups', 11),
    ('Close-grip pull-ups', 11),
    ('Resistance band face pulls', 11)
    
SELECT * FROM define_exercise;

INSERT INTO team_memberships(athlete_id, team_id)  -- 1 Harvard Crimson Mens Football	football
VALUES (1,1),(3,1),(5,1),(7,1),(9,1);

INSERT INTO team_memberships(athlete_id, team_id)  -- 3	Harvard Crimson Womens Football
VALUES (2,3),(4,3),(6,3),(8,3),(10,3);

INSERT INTO team_memberships(athlete_id, team_id)  -- 2	Harvard Hawks  Mens Basketball	basketball	
VALUES (11,2),(13,2),(15,2),(17,2),(19,2);

INSERT INTO team_memberships(athlete_id, team_id)  -- 4	Harvard Hawks  Womens Basketball	basketball	
VALUES (12,4),(14,4),(16,4),(18,4),(20,4);


SELECT * FROM teams;
INSERT INTO team_memberships(athlete_id, team_id)  -- '5', 'Daemen Wildcats Mens Basketball', 'basketball'  2
VALUES (36,5),(37,5),(38,5),(39,5),(40,5);

INSERT INTO team_memberships(athlete_id, team_id)  --  7 Daemen Wildcats Womens Basketball	basketball	   5
VALUES (22,7),(24,7),(26,7),(28,7),(30,7);

INSERT INTO team_memberships(athlete_id, team_id)  -- 6	Daemen Thunder Tennis	tennis     2
VALUES (21,6),(23,6),(25,6),(27,6),(29,6);

INSERT INTO team_memberships(athlete_id, team_id)  -- 8	Daemen Lightning Tennis	tennis	  5
VALUES (41,8),(42,8),(43,8),(44,8),(45,8);
-- ##############################################################

SELECT * FROM teams;
SELECT * FROM team_memberships;

SELECT * FROM blocks;



-- ------------------------------------
SELECT * FROM define_exercise;

-- TESTING Athlete landing page : ----------- DROP ALL WORKOUTS ETC AFTER TEST
SELECT * FROM coaches;
SELECT * FROM athletes;
SELECT * FROM workouts;

SELECT * FROM teams;
SELECT * FROM team_memberships;

SELECT * FROM coach_athlete_memberships;
INSERT INTO workouts (name, coach_id, date_added)
VALUES ('FootBall_Wk1', 3 , '2022-11-11'),('Wrestling_Wk1',3,'2022-11-11') , ('BasketBall_Wk1',2,'2022-11-11');

INSERT INTO team_workouts_assignments(team_id, workout_id)
VALUES (1,1),(6,3);

-- BLOCKS
SELECT * FROM blocks;

INSERT INTO blocks(name, workout_id)
VALUES('FootBall-dribble',1),('FootBall-freestyle' , 1) , ('BasketBall-3-ptr',3),('BasketBall-escape',3);

INSERT INTO blocks(name, workout_id)
VALUES('Wrestling_Grapple_1',2),('Wrestling_Grapple_2' , 2) , ('Wrestling_Grapple_3',2),('Wrestling_Finishin',2);

-- Exercises:
-- Football-dribble
INSERT INTO exercises (block_id, name, loads_reps, sets)
VALUES (1, 'FootBall-dribble-fast', '{"coach":[{"load": 25, "reps": 2}, {"load": 50, "reps": 1}]}', 2),
       (1, 'FootBall-dribble-slow', '{"coach":[{"load": 25, "reps": 2}]}', 1);

-- Football-freestyle
INSERT INTO exercises (block_id, name, loads_reps, sets)
VALUES (2, 'FootBall-freestyle-move1', '{"coach":[{"load": 30, "reps": 3}]}', 1),
       (2, 'FootBall-freestyle-move2', '{"coach":[{"load": 40, "reps": 2}, {"load": 60, "reps": 1}]}', 2);

-- Basketball-3-ptr
INSERT INTO exercises (block_id, name, loads_reps, sets)
VALUES (3, 'BasketBall-3-ptr-left', '{"coach":[{"load": 20, "reps": 3}]}', 1),
       (3, 'BasketBall-3-ptr-right', '{"coach":[{"load": 25, "reps": 2}]}', 1);

-- Basketball-escape
INSERT INTO exercises (block_id, name, loads_reps, sets)
VALUES (4, 'BasketBall-escape-drill1', '{"coach":[{"load": 30, "reps": 2}]}', 1),
       (4, 'BasketBall-escape-drill2', '{"coach":[{"load": 40, "reps": 2}, {"load": 60, "reps": 1}]}', 2);

-- Wrestling-Grapple-1
INSERT INTO exercises (block_id, name, loads_reps, sets)
VALUES (5, 'Wrestling-Grapple-1-move1', '{"coach":[{"load": 50, "reps": 1}]}', 1),
       (5, 'Wrestling-Grapple-1-move2', '{"coach":[{"load": 60, "reps": 1}]}', 1);

-- Wrestling-Grapple-2
INSERT INTO exercises (block_id, name, loads_reps, sets)
VALUES (6, 'Wrestling-Grapple-2-move1', '{"coach":[{"load": 70, "reps": 1}]}', 1),
       (6, 'Wrestling-Grapple-2-move2', '{"coach":[{"load": 80, "reps": 1}]}', 1);

-- Wrestling-Grapple-3
INSERT INTO exercises (block_id, name, loads_reps, sets)
VALUES (7, 'Wrestling-Grapple-3-move1', '{"coach":[{"load": 90, "reps": 1}]}', 1),
       (7, 'Wrestling-Grapple-3-move2', '{"coach":[{"load": 100, "reps": 1}]}', 1);
       
       

-- Wrestling-Finishing
INSERT INTO exercises (block_id, name, loads_reps, sets)
VALUES (8, 'Wrestling-Finishing-move1', '{"coach":[{"load": 80, "reps": 2}]}', 1),
       (8, 'Wrestling-Finishing-move2', '{"coach":[{"load": 90, "reps": 2}]}', 1);

SELECT * FROM coach_athlete_memberships;
INSERT INTO coach_athlete_memberships(coach_id, athlete_id)
VALUES (3,9),(3,1);

SELECT * FROM workouts;
SELECT * FROM athlete_workouts;
INSERT INTO athlete_workouts(athlete_id, workout_id)

SELECT * FROM exercises;
SELECT * FROM athlete_exercise_input_loads;

INSERT INTO athlete_workouts(athlete_id, workout_id)
VALUES(9, 2);
--
-- TESTING FootBall-dribble-slow Exercise_id = 2; ( Modifying the exercise_loads and reps to see if this will change the athlete side )
-- Athlete has submitted input_load as 2 for this. Load required was : 25 by coach


-- EDGE CASES IMPORTANT cases
-- 1. Modifying the load from coach side.
-- Initial 25
-- Changed to 60 now.

UPDATE exercises
SET loads_reps = '{"coach": [{"load": 60, "reps": 2}]}'
WHERE exercise_id = 2;
-- The athletes load_input remains same.

-- 2. Deleting/Modifying the load itself.
-- Now load is 60, input from athlete is 2
UPDATE exercises
SET loads_reps = '{"coach": []}'
WHERE exercise_id = 2;
-- ( Should reset the exercise_input loads on the athlete page as well ) --> Function for writing resetting database values during modify

-- 3. Deleting the exercise itself
-- Now If I delete the exercise from coach side, and the athlete has input the loads earlier,
-- Deleting the exercise from coach side should delete the entries of athlete_input_loads on the database.