OnUpdateWordsCExt.java

/*
** Module   : OnUpdateWordsCExt.java
** Abstract : AFTER UPDATE trigger populating word table (custom extent fields)
**
** 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.*;

/**
 * AFTER UPDATE trigger populating word table (extent fields)
 */
public class OnUpdateWordsCExt
extends WordsTrigger
{

   /**
    * Constructor
    * @param init
    *        initialization string. Contains the following values 
    *        separated by semicolon:
    *        - the name of the primary key of the master table
    *        - the name of the field 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 OnUpdateWordsCExt(String init)
   {
      super(init);
   }

   /**
    * 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);
      String field = newRow.getString(fieldName);
      long oldPk = oldRow.getLong(pkName); 
      if ( oldPk != pk)
      {
         throw new SQLException("PK mismatch: " + pk + "!=" + oldPk);
      }
      try(PreparedStatement pstmt = conn.prepareStatement(
            "DELETE FROM " + wordTableName + " WHERE PARENT__ID = ? AND LIST__INDEX = ?"
      ))
      {
         pstmt.setLong(1, pk);
         pstmt.setInt(2, pos);
         int result = pstmt.executeUpdate();
      }
      
      insertWords(conn, pk, pos, field);
   }

}