Changes between Version 4 and Version 5 of DatabaseProgramming

Timestamp:

06/10/26 22:34:55 (19 hours ago)

Author:

231020

Comment:

--

DatabaseProgramming

@@ -245 +245 @@
 }}}
 
+Тригер 2: При креирање на trade_request се креира broker_order
+
+{{{
+CREATE OR REPLACE FUNCTION create_broker_order_from_trade_request()
+RETURNS TRIGGER AS $$
+BEGIN
+    INSERT INTO broker_order (
+        order_type,
+        limit_price,
+        quantity,
+        status,
+        executed_price,
+        broker_fee,
+        mse_reference_number,
+        submitted_at,
+        trade_request_id
+    )
+    VALUES (
+        NEW.type,
+        NEW.price_per_unit,
+        NEW.quantity,
+        'PENDING',
+        NULL,
+        ROUND((NEW.price_per_unit * NEW.quantity * 0.005)::numeric, 2), -- 0.5% fee
+        'MSE-' || NEW.id || '-' || EXTRACT(EPOCH FROM NOW())::BIGINT,
+        NOW(),
+        NEW.id
+    );
+
+    RETURN NEW;
+END;
+$$ LANGUAGE plpgsql;
+
+
+CREATE TRIGGER trg_create_broker_order
+AFTER INSERT ON trade_request
+FOR EACH ROW
+EXECUTE FUNCTION create_broker_order_from_trade_request();
+}}}
 
 Тригер 2: При SELL - провери дали корисникот има доволно акции во holdings