Changes between Version 2 and Version 3 of ImportatntUseCase001

Timestamp:

02/10/25 11:52:12 (12 days ago)

Author:

221128

Comment:

--

ImportatntUseCase001

@@ -6 +6 @@
 **__1. Employee logs in.__**
 
-SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check
+{{{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 = ?;
+}}}