package main.resources.domain.templates;

import main.resources.model.BusinessRule;

public abstract class TriggerTemplate {
	public String generateCode(BusinessRule br) {
		String code = "CREATE OR REPLACE TRIGGER " + br.getConstraintName();
		code += "\nBEFORE DELETE OR INSERT OR UPDATE"
		+ "\nON " + br.getTableNameOne()
		+ "\nFOR EACH ROW"
		+ "\nDECLARE"
		+ "\nl_oper varchar2 ( 3 );"
		+ "\nl_error_stack varchar2 ( 4000 );"
		+ "\nBEGIN"
		+ "\nIF INSERTING"
		+ "\nTHEN"
		+ "\nl_oper := 'INS';"
		+ "\nELSIF UPDATING"
		+ "\nTHEN"
		+ "\nl_oper := 'UPD';"
		+ "\nELSIF DELETING"
		+ "\nTHEN"
		+ "\nl_oper := 'DEL';"
		+ "\nEND IF;"

		+ "\nDECLARE"
		+ "\nl_passed boolean := true;"
		+ "\nBEGIN";

		return code;
	}
}