Advertisement
GWibisono

biar bawah saya yg nerusin

Aug 16th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION bumadev_rds.trg_log_karyawan()
  2. RETURNS trigger AS
  3. $BODY$ DECLARE
  4. col RECORD;
  5. newValue text;
  6. oldValue text;
  7. isChange boolean;
  8. BEGIN
  9. IF TG_OP<>'DELETE' then
  10. INSERT INTO bumadev_rds.log_karyawan
  11. (
  12. `log_time`,
  13. `log_action`,
  14. `id`,
  15. `nama`,
  16. `jabatan`,
  17. `tanggal_masuk`
  18. )
  19. VALUES
  20. (
  21. now(),
  22. TG_OP,
  23. new.`id`,
  24. new.`nama`,
  25. new.`jabatan`,
  26. new.`tanggal_masuk`
  27. );
  28. RETURN NEW;
  29. ELSIF TG_OP='DELETE' then
  30. INSERT INTO `bumadev_rds`.`log_karyawan`
  31. (
  32. `log_time`,
  33. `log_action`,
  34. `id`,
  35. `nama`,
  36. `jabatan`,
  37. `tanggal_masuk`
  38. )
  39. VALUES
  40. (
  41. now(),
  42. TG_OP,
  43. old.`id`,
  44. old.`nama`,
  45. old.`jabatan`,
  46. old.`tanggal_masuk`
  47. );
  48. RETURN OLD;
  49. END IF;
  50. RETURN NULL;
  51. END;$BODY$
  52. LANGUAGE plpgsql VOLATILE;
  53.  
  54. CREATE TRIGGER trg_log_karyawan
  55. BEFORE INSERT OR UPDATE OR DELETE
  56. ON `bumadev_rds`.`karyawan`
  57. FOR EACH ROW
  58. EXECUTE PROCEDURE bumadev_rds.trg_log_karyawan();
  59.  
  60. insert into bumadev_rds.karyawan (nama, jabatan, tanggal_masuk) values('Lisa', 'Manajer', '2014-12-12');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement