Changes between Version 1 and Version 2 of ImportatntUseCase001
- Timestamp:
- 02/10/25 11:34:11 (12 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ImportatntUseCase001
v1 v2 4 4 * Employee 5 5 === Steps in the Scenario === 6 1. Employee logs in. 6 **__1. Employee logs in.__** 7 7 8 SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check 8 9 9 2. employee views his shift. 10 **__2. Employee views his shift.__** 11 10 12 SELECT a.id, a.shift_id, a.manager_id, s.start_time, s.end_time FROM assignments a 11 13 LEFT JOIN public.shifts s on s.id = a.shift_id … … 13 15 WHERE s.date = current_date AND a.employee_id = 1; 14 16 15 3. Employee clocks in work. 17 **__3. Employee clocks in work.__** 18 16 19 UPDATE assignments SET clock_in_time = current_time WHERE assignments.employee_id = 1 AND assignments.shift_id = ?;