Changes between Version 1 and Version 2 of ImportatntUseCase001


Ignore:
Timestamp:
02/10/25 11:34:11 (12 days ago)
Author:
221128
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ImportatntUseCase001

    v1 v2  
    44* Employee
    55=== Steps in the Scenario ===
    6 1. Employee logs in.
     6**__1. Employee logs in.__**
     7
    78SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check
    89
    9 2. employee views his shift.
     10**__2. Employee views his shift.__**
     11
    1012SELECT a.id, a.shift_id, a.manager_id, s.start_time, s.end_time FROM assignments a
    1113LEFT JOIN public.shifts s on s.id = a.shift_id
     
    1315WHERE s.date = current_date AND a.employee_id = 1;
    1416
    15 3. Employee clocks in work.
     17**__3. Employee clocks in work.__**
     18
    1619UPDATE assignments SET clock_in_time = current_time WHERE assignments.employee_id = 1 AND assignments.shift_id = ?;