<commit_before>CREATE OR REPLACE TRIGGER BRG_{code}_{attribute_table}_TRIGGER
BEFORE DELETE OR INSERT OR UPDATE
ON {attribute_table}
FOR EACH ROW
DECLARE
  L_OPER        VARCHAR2(3);
  L_ERROR_STACK VARCHAR2(4000);
BEGIN
  IF INSERTING
  THEN
    L_OPER := 'INS';
  ELSIF UPDATING
    THEN
      L_OPER := 'UPD';
  ELSIF DELETING
    THEN
      L_OPER := 'DEL';
  END IF;
  DECLARE
    L_PASSED BOOLEAN := TRUE;
  BEGIN
    IF L_OPER IN ('INS', 'UPD')
    THEN
      L_PASSED := :NEW.{attribute_column} > {range_min} AND :NEW.{attribute_column} < {range_max};
      L_PASSED := L_PASSED {operand} L_PASSED;
      IF NOT L_PASSED
      THEN
        L_ERROR_STACK := L_ERROR_STACK || {error};
      END IF;
    END IF;
  END;
END;<commit_msg> :trollface: Templates fixed<commit_after>CREATE OR REPLACE TRIGGER BRG_{code}_{attribute_table}_TRIGGER
BEFORE DELETE OR INSERT OR UPDATE
ON {attribute_table}
FOR EACH ROW
DECLARE
  L_OPER        VARCHAR2(3);
  L_ERROR_STACK VARCHAR2(4000);
BEGIN
  IF INSERTING
  THEN
    L_OPER := 'INS';
  ELSIF UPDATING
    THEN
      L_OPER := 'UPD';
  ELSIF DELETING
    THEN
      L_OPER := 'DEL';
  END IF;
  DECLARE
    L_PASSED BOOLEAN := TRUE;
  BEGIN
    IF L_OPER IN ('INS', 'UPD')
    THEN
      L_PASSED := :NEW.{attribute_column} > {range_min} AND :NEW.{attribute_column} < {range_max};
      L_PASSED := L_PASSED {operand} TRUE ;
      IF NOT L_PASSED
      THEN
        L_ERROR_STACK := L_ERROR_STACK || {error};
      END IF;
    END IF;
  END;
END;
{'fraction_non_alphanumeric': 0.10053619302949061, 'fraction_numerical': 0.00938337801608579, 'mean_word_length': 2.898172323759791, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '135118', 'n_tokens_mistral': 620, 'n_tokens_neox': 575, 'n_words': 148}