-- Insert a test data set to simulate an active game for testing
-- @author Eric Pietrocupo
-- @date February 19th, 2026
-- @license GNU GPL 3.0
--
-- Test with already a game going on
-- don't forget to call testafter.sql


INSERT INTO player ( pk, name, money, ishuman)
VALUES
( 1, "Jerry", 750, 'Y'),
( 2, "Jimmy", 925, 'Y'),
( 3, "Johnny", 325, 'Y'),
( 4, "Jane", 750, 'Y'),
( 5, "Jeoffrey", 925, 'Y'),
( 6, "Julia", 325, 'Y');

-- assign event cards

INSERT INTO player_event ( fk_player, fk_event)
VALUES
(1, 1),
(2, 2),
(3, 3),
(4, 7),
(5, 8),
(6, 9);

--INSERT INTO roll ( fk_stock, move, number)
--VALUES
--(5, 1, 20), -- GOLD UP 20
--(0, -1, 5), -- GRAIN DOWN 5
--(2, 0, 10); -- BONDS DIV 10

INSERT INTO game ( turn_number, game_length, fk_active_player, nb_roll)
VALUES ( 10, 100, 2, 3);

-- Change the stock market default value
/*UPDATE stock SET current_price = 120 WHERE pk = 0;
UPDATE stock SET current_price = 145 WHERE pk = 1;
UPDATE stock SET current_price = 155 WHERE pk = 2;
UPDATE stock SET current_price = 80 WHERE pk = 3;
UPDATE stock SET current_price = 85 WHERE pk = 4;
UPDATE stock SET current_price = 50 WHERE pk = 5;
UPDATE stock SET previous_price = 100 WHERE pk = 0;
UPDATE stock SET previous_price = 140 WHERE pk = 1;
UPDATE stock SET previous_price = 165 WHERE pk = 2;
UPDATE stock SET previous_price = 90 WHERE pk = 3;
UPDATE stock SET previous_price = 65 WHERE pk = 4;
UPDATE stock SET previous_price = 70 WHERE pk = 5;*/
--UPDATE stock SET current_price = 95 WHERE pk = 0;
--UPDATE stock SET current_price = 100 WHERE pk = 1;
--UPDATE stock SET current_price = 155 WHERE pk = 2;
--UPDATE stock SET current_price = 100 WHERE pk = 5;
--UPDATE stock SET previous_price = 115 WHERE pk = 0;
--UPDATE stock SET previous_price = 15 WHERE pk = 1;
--UPDATE stock SET previous_price = 145 WHERE pk = 2;
--UPDATE stock SET previous_price = 180 WHERE pk = 5;
--UPDATE stock SET isdivpaid = 'Y' WHERE pk = 2;
--UPDATE stock SET isdivpaid = 'Y' WHERE pk = 5;
--UPDATE stock SET split = 'Y' WHERE pk = 5;
--UPDATE stock SET crash = 'Y' WHERE pk = 1;


