== Employee clocks in ==

=== Actors ===
* Employee
=== Steps in the Scenario ===
**__1. Employee logs in.__**

{{{SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check}}}

**__2. Employee views his shift.__**

{{{
SELECT a.id, a.shift_id, a.manager_id, s.start_time, s.end_time FROM assignments a
LEFT JOIN public.shifts s on s.id = a.shift_id
LEFT JOIN public.managers m on a.manager_id = m.employee_id
WHERE s.date = current_date AND a.employee_id = 1;
}}}

**__3. Employee clocks in work.__**
{{{
UPDATE assignments SET clock_in_time = current_time WHERE assignments.employee_id = 1 AND assignments.shift_id = ?;
}}}