Changes between Version 3 and Version 4 of WikiStart/Optimization/vtora_verzija

Timestamp:

04/01/25 22:04:07 (2 months ago)

Author:

203206

Comment:

db

WikiStart/Optimization/vtora_verzija

@@ -64 +64 @@
 
 
+=== Trigger 1
+{{{
+create or replace function after_transaction_trigger()
+returns trigger as $$
+begin
+
+        if new.type = 'Deposit' then
+                insert into Deposit(account_id, transaction_id, amount)
+                values (new.account_id, new.transaction_id, new.amount);
+        
+        elsif new.type = 'Withdrawal' then
+                insert into Deposit(account_id, transaction_id, amount)
+                values (new.account_id, new.transaction_id, new.amount);
+        
+        elsif new.type like '(MKD) Transfer Out to%' then
+                insert into transferred_money(s_account_id, r_account_id, t_id, currency)
+                select new.account_id, (select id from account where username = trim(substring(new.type from position('Transfer Out to ' in new.type)+15)) limit 1),
+                        new.id, new.currency; 
+
+        elsif new.type like '(USD) Transfer Out to%' then
+                insert into transferred_money(s_account_id, r_account_id, t_id, currency)
+                select new.account_id, (select id from account where username = trim(substring(new.type from position('Transfer Out to ' in new.type)+15)) limit 1),
+                        new.id, new.currency;
+        
+        elsif new.type like '(EUR) Transfer Out to%' then
+                insert into transferred_money(s_account_id, r_account_id, t_id, currency)
+                select new.account_id, (select id from account where username = trim(substring(new.type from position('Transfer Out to ' in new.type)+15)) limit 1),
+                        new.id, new.currency;
+                        
+        elsif new.type like '(GBP) Transfer Out to%' then
+                insert into transferred_money(s_account_id, r_account_id, t_id, currency)
+                select new.account_id, (select id from account where username = trim(substring(new.type from position('Transfer Out to ' in new.type)+15)) limit 1),
+                        new.id, new.currency;
+
+        end if;
+        return new;
+end;
+$$ language plpgsql;
+
+create trigger after_transaction
+after insert on transaction
+for each row
+execute function after_transaction_trigger();
+}}}
+
 
 === Trigger 2