Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION bumadev_rds.trg_log_karyawan()
- RETURNS trigger AS
- $BODY$ DECLARE
- col RECORD;
- newValue text;
- oldValue text;
- isChange boolean;
- BEGIN
- IF TG_OP<>'DELETE' then
- INSERT INTO bumadev_rds.log_karyawan
- (
- `log_time`,
- `log_action`,
- `id`,
- `nama`,
- `jabatan`,
- `tanggal_masuk`
- )
- VALUES
- (
- now(),
- TG_OP,
- new.`id`,
- new.`nama`,
- new.`jabatan`,
- new.`tanggal_masuk`
- );
- RETURN NEW;
- ELSIF TG_OP='DELETE' then
- INSERT INTO `bumadev_rds`.`log_karyawan`
- (
- `log_time`,
- `log_action`,
- `id`,
- `nama`,
- `jabatan`,
- `tanggal_masuk`
- )
- VALUES
- (
- now(),
- TG_OP,
- old.`id`,
- old.`nama`,
- old.`jabatan`,
- old.`tanggal_masuk`
- );
- RETURN OLD;
- END IF;
- RETURN NULL;
- END;$BODY$
- LANGUAGE plpgsql VOLATILE;
- CREATE TRIGGER trg_log_karyawan
- BEFORE INSERT OR UPDATE OR DELETE
- ON `bumadev_rds`.`karyawan`
- FOR EACH ROW
- EXECUTE PROCEDURE bumadev_rds.trg_log_karyawan();
- 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