Changes between Version 1 and Version 2 of ImportatntUseCase002


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

--

Legend:

Unmodified
Added
Removed
Modified

  • ImportatntUseCase002

    v1 v2  
    55**__1. Manager logs in.__**
    66
    7 SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check
     7{{{SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check}}}
    88
    99**__2. Manager sees the created shifts.__**
    1010
    11 SELECT date, start_time, end_time FROM shifts WHERE manager_id = %s AND date >= current_date;
     11{{{SELECT date, start_time, end_time FROM shifts WHERE manager_id = %s AND date >= current_date}}}
    1212
    1313**__3. Manager creates shift for the following week for employees.__**
    1414
    15 INSERT INTO shifts(id, date, start_time, end_time, manager_id) VALUES (1, '2025-01-05', '08:00:00', '17:00:00', 3);
     15{{{INSERT INTO shifts(id, date, start_time, end_time, manager_id) VALUES (1, '2025-01-05', '08:00:00', '17:00:00', 3) }}}
    1616
    1717**__4. Manager assigns shifts to employees__**
    1818
    19 INSERT INTO assignments(id, manager_id, employee_id, shift_id) VALUES (1, 3, 1, 1);
     19{{{INSERT INTO assignments(id, manager_id, employee_id, shift_id) VALUES (1, 3, 1, 1)}}}