Changes between Version 11 and Version 12 of DatabaseProgramming

Timestamp:

06/14/26 15:58:31 (3 days ago)

Author:

231072

Comment:

--

DatabaseProgramming

@@ -223 +223 @@
 
 
-
+= Процедура add_to_cart
+
+Додава продукт во кошничката.
+
+{{{
+CREATE OR REPLACE PROCEDURE add_to_cart(
+    p_cart_id    INT,
+    p_product_id INT,
+    p_quantity   INT
+)
+LANGUAGE plpgsql
+AS $$
+DECLARE
+    v_price NUMERIC;
+BEGIN
+    IF p_quantity <= 0 THEN
+        RAISE EXCEPTION 'Kolicinata mora da e pogolema od 0';
+    END IF;
+
+    SELECT price INTO v_price
+    FROM product
+    WHERE product_id = p_product_id AND is_active = 1;
+
+    IF NOT FOUND THEN
+        RAISE EXCEPTION 'Produktot ne postoi ili ne e aktiven';
+    END IF;
+   
+   PERFORM fn_validate_product_stock(p_product_id, p_quantity);
+
+    INSERT INTO cartitems (cart_id, product_id, quantity, price_at_time)
+    VALUES (p_cart_id, p_product_id, p_quantity, v_price);
+   
+   --azhurirame total price
+   UPDATE cart
+    SET total_price = fn_calc_cart_total(p_cart_id)
+    WHERE cart_id = p_cart_id;
+END;
+$$;
+}}}
+
+= Процедура remove_from_cart
+
+Отстранува продукт од кошничката.
+
+{{{
+CREATE OR REPLACE PROCEDURE remove_from_cart(
+    p_cart_id    INT,
+    p_product_id INT
+)
+LANGUAGE plpgsql
+AS $$
+BEGIN
+    DELETE FROM cartitems
+    WHERE cart_id = p_cart_id
+      AND product_id = p_product_id;
+
+    IF NOT FOUND THEN
+        RAISE EXCEPTION 'Produktot ne postoi vo kosnickata';
+    END IF;
+   
+   --azhurirame total price
+   UPDATE cart
+    SET total_price = fn_calc_cart_total(p_cart_id)
+    WHERE cart_id = p_cart_id;
+END;
+$$;
+}}}
+
+= Процедура update_cart_quantity
+
+Ја менува количината на постоечки продукт во кошничката.
+
+{{{
+CREATE OR REPLACE PROCEDURE update_cart_quantity(
+    p_cart_id    INT,
+    p_product_id INT,
+    p_quantity   INT
+)
+LANGUAGE plpgsql
+AS $$
+DECLARE
+    v_stock INT;
+BEGIN
+    IF p_quantity <= 0 THEN
+        RAISE EXCEPTION 'Kolicinata mora da e pogolema od 0';
+    END IF;
+   
+   PERFORM fn_validate_product_stock(p_product_id, p_quantity);
+
+    UPDATE cartitems
+    SET quantity = p_quantity
+    WHERE cart_id = p_cart_id
+      AND product_id = p_product_id;
+     
+    --azhurirame total price
+    UPDATE cart
+    SET total_price = fn_calc_cart_total(p_cart_id)
+    WHERE cart_id = p_cart_id;
+END;
+$$;
+}}}
+
+
+