Changes between Version 11 and Version 12 of DatabaseProgramming

Timestamp:

05/23/26 22:07:30 (2 days ago)

Author:

231028

Comment:

--

DatabaseProgramming

@@ -31 +31 @@
 $$;
 }}}
-
+{{{
+create or replace procedure finish_shift(
+    in driver_id int4
+)
+    language plpgsql as
+$$
+declare
+    num_of_shifts int4;
+begin
+    if not exists(select user_id from driver where user_id = driver_id) then
+        raise exception 'Driver with id % does not exist', driver_id;
+    end if;
+
+    num_of_shifts := (select count(*) from driver_vehicle where id_driver = driver_id and time_to is null);
+
+    if (num_of_shifts != 1) then
+        raise exception 'Driver has not started a shift';
+    end if;
+
+    update driver_vehicle
+    set time_to=now()
+    where id_driver = driver_id
+      and time_to is null;
+    commit;
+end;
+$$;
+}}}
 **Процедура за вработување на возач во компанија**
 
@@ -401 +427 @@
 
 {{{
-create or replace procedure public_schema.finish_shift(
-    in driver_id int4
-)
-    language plpgsql as
-$$
-declare
-    num_of_shifts int4;
-begin
-    if not exists(select user_id from driver where user_id = driver_id) then
-        raise exception 'Driver with id % does not exist', driver_id;
-    end if;
-
-    num_of_shifts := (select count(*) from driver_vehicle where id_driver = driver_id and time_to is null);
-
-    if (num_of_shifts != 1) then
-        raise exception 'Driver has not started a shift';
-    end if;
-
-    update driver_vehicle
-    set time_to=now()
-    where id_driver = driver_id
-      and time_to is null;
-    commit;
-end;
-$$;
-}}}
-
-{{{
 create or replace procedure create_offer(
     request_id int4,
@@ -488 +486 @@
 $$;
 }}}
-{{{
-create or replace procedure public_schema.finish_shift(
-    in driver_id int4
-)
-    language plpgsql as
-$$
-declare
-    num_of_shifts int4;
-begin
-    if not exists(select user_id from driver where user_id = driver_id) then
-        raise exception 'Driver with id % does not exist', driver_id;
-    end if;
-
-    num_of_shifts := (select count(*) from driver_vehicle where id_driver = driver_id and time_to is null);
-
-    if (num_of_shifts != 1) then
-        raise exception 'Driver has not started a shift';
-    end if;
-
-    update driver_vehicle
-    set time_to=now()
-    where id_driver = driver_id
-      and time_to is null;
-    commit;
-end;
-$$;
-}}}
 == Функции и тригери