Changes between Version 5 and Version 6 of WikiStart/DB

Timestamp:

03/22/25 20:34:56 (2 months ago)

Author:

203206

Comment:

trigger

WikiStart/DB

@@ -62 +62 @@
 == Triggers
 
+{{{
+create or replace function after_transaction_trigger()
+returns trigger as $$
+begin
+
+        if new.type = 'Deposit' then
+                insert into Deposit(account_id,amount, timestamp)
+                values (new.account_id, new.amount, new.timestamp);
+        
+        elsif new.type = 'Withdrawal' then
+                insert into Withdraw(account_id,amount, timestamp)
+                values (new.account_id, new.amount, new.timestamp);
+        
+        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, 'MKD'; 
+
+        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, 'USD';
+        
+        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, 'EUR';
+                        
+        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, 'GBP';
+
+        end if;
+        return new;
+end;
+$$ language plpgsql;
+
+create trigger after_transaction
+after insert on transaction
+for each row
+execute function after_transaction_trigger()
+
+}}}