Changes between Initial Version and Version 1 of ImportatntUseCase002

Timestamp:

02/10/25 11:39:56 (9 months ago)

Author:

221128

Comment:

--

ImportatntUseCase002

@@ +1 @@
+== Manager creates and assigns shift ==
+=== Actors ===
+* Manager
+=== Steps in the Scenario ===
+**__1. Manager logs in.__**
+
+SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check
+
+**__2. Manager sees the created shifts.__**
+
+SELECT date, start_time, end_time FROM shifts WHERE manager_id = %s AND date >= current_date;
+
+**__3. Manager creates shift for the following week for employees.__**
+
+INSERT INTO shifts(id, date, start_time, end_time, manager_id) VALUES (1, '2025-01-05', '08:00:00', '17:00:00', 3);
+
+**__4. Manager assigns shifts to employees__**
+
+INSERT INTO assignments(id, manager_id, employee_id, shift_id) VALUES (1, 3, 1, 1);