# OnInsertWordsCExt.java

    /*
    ** Module   : OnInsertWordsCExt.java
    ** Abstract : AFTER INSERT trigger populating word table (custom extent field)
    **
    ** Copyright (c) 2021, Golden Code Development Corporation.
    **
    ** -#- -I- --Date-- --------------------------------Description----------------------------------
    ** 001 IAS 20210219 Created initial version.
    */

    /*
    ** This program is free software: you can redistribute it and/or modify
    ** it under the terms of the GNU Affero General Public License as
    ** published by the Free Software Foundation, either version 3 of the
    ** License, or (at your option) any later version.
    **
    ** This program is distributed in the hope that it will be useful,
    ** but WITHOUT ANY WARRANTY; without even the implied warranty of
    ** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    ** GNU Affero General Public License for more details.
    **
    ** You may find a copy of the GNU Affero GPL version 3 at the following
    ** location: https://www.gnu.org/licenses/agpl-3.0.en.html
    **
    ** Additional terms under GNU Affero GPL version 3 section 7:
    **
    **   Under Section 7 of the GNU Affero GPL version 3, the following additional
    **   terms apply to the works covered under the License.  These additional terms
    **   are non-permissive additional terms allowed under Section 7 of the GNU
    **   Affero GPL version 3 and may not be removed by you.
    **
    **   0. Attribution Requirement.
    **
    **     You must preserve all legal notices or author attributions in the covered
    **     work or Appropriate Legal Notices displayed by works containing the covered
    **     work.  You may not remove from the covered work any author or developer
    **     credit already included within the covered work.
    **
    **   1. No License To Use Trademarks.
    **
    **     This license does not grant any license or rights to use the trademarks
    **     Golden Code, FWD, any Golden Code or FWD logo, or any other trademarks
    **     of Golden Code Development Corporation. You are not authorized to use the
    **     name Golden Code, FWD, or the names of any author or contributor, for
    **     publicity purposes without written authorization.
    **
    **   2. No Misrepresentation of Affiliation.
    **
    **     You may not represent yourself as Golden Code Development Corporation or FWD.
    **
    **     You may not represent yourself for publicity purposes as associated with
    **     Golden Code Development Corporation, FWD, or any author or contributor to
    **     the covered work, without written authorization.
    **
    **   3. No Misrepresentation of Source or Origin.
    **
    **     You may not represent the covered work as solely your work.  All modified
    **     versions of the covered work must be marked in a reasonable way to make it
    **     clear that the modified work is not originating from Golden Code Development
    **     Corporation or FWD.  All modified versions must contain the notices of
    **     attribution required in this license.
    */

    package com.goldencode.p2j.persist.h2;

    import java.sql.*;
    import java.util.*;

    /**
     * AFTER INSERT trigger populating word table
     */
    public class OnInsertWordsCExt
    extends WordsTrigger
    {
       /** List of the custom extent field names */
       private final List<String> extFields;
       /**
        * Constructor
        * @param init
        *        initialization string. Contains the following values
        *        separated by semicolon:
        *        - the name of the primary key of the master table
        *        - the comma separated names of the extend fields of the master table
        *        - the word table name
        *        - the flag indicating that the field is case sensitive ('true'/'false')
        *        - the extent field position ( != 0 only for the custom extents)
        */
        public OnInsertWordsCExt(String init)
       {
          super(init);
          this.extFields = Collections.unmodifiableList(Arrays.asList(fieldName.split(",")));
       }

       /**
        * This method is called for each triggered action by the default
        * fire(Connection conn, Object[] oldRow, Object[] newRow) method.
        * ResultSet.next does not need to be called (and calling it has no effect;
        * it will always return true).
        * <p>
        * For "before" triggers, the new values of the new row may be changed
        * using the ResultSet.updateX methods.
        * </p>
        *
        * @param conn a connection to the database
        * @param oldRow the old row, or null if no old row is available (for
        *            INSERT)
        * @param newRow the new row, or null if no new row is available (for
        *            DELETE)
        * @throws SQLException if the operation must be undone
        */
       @Override
       public void fire(Connection conn, ResultSet oldRow, ResultSet newRow)
       throws SQLException
       {
          long pk = newRow.getLong(pkName);
          int pos = 1;
          for (String extField: extFields)
          {
             String value = newRow.getString(extField);
             insertWords(conn, pk, pos++, value);
          }
       }
    }