package main.resources.domain.templates;

import main.resources.model.BusinessRule;
import main.resources.model.Operator;
import main.resources.model.Values;

public class TemplateTriggerACMPOracle extends TriggerTemplate {

	@Override
	public String generateCode(BusinessRule br) {
		String valueOne = br.getValueList().get(0);
		String code = 	super.generateCode(br);

		code += "\nIF l_oper in ('INS', 'UPD')"
					+ "\nTHEN"
					+ "\nl_passed := :new." + br.getAttributeNameOne() + " " + br.getOperator().getValue() + " " + valueOne + ";"
					+ "\nIF NOT l_passed"
					+ "\nTHEN"
					+ "\nl_error_stack := l_error_stack || '" + "ERROR MESSAGE" + "';"
					+ "\nEND IF;"
					+ "\nEND IF;"
					+ "\nEND;"
					+ "\nIF l_error_stack is not null"
					+ "\nTHEN"
					+ "\nraise_application_error(-20800, l_error_stack);"
					+ "\nEND IF;"
					+ "\nEND " + br.getConstraintName() + ";";

		return code;
	}

	public static void main(String args[]) {
		Values testval = new Values();
		testval.addValue("1");
		testval.addValue("10");
		TriggerTemplate test = new TemplateTriggerACMPOracle();


		BusinessRule testbr = new BusinessRule.Builder("BRG_TEST_TRIGGER_ACMP")
				.firstComparableTable("product")
				.comparableValues(testval)
				.firstComparableAttribute("prijs")
				.usingOperator(new Operator("GREATER THAN", ">"))
				.usingTemplate(test)
				.build();

		System.out.println(test.generateCode(testbr));
	}

}