com.spun.util.database.automaticsetter.EndDateVariableSetter Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of approvaltests-util Show documentation

There is a newer version: 24.9.0

package com.spun.util.database.automaticsetter;

import com.spun.util.ObjectUtils;
import com.spun.util.database.AutomaticVariableSetter;
import com.spun.util.database.DatabaseObject;
import com.spun.util.logger.SimpleLogger;

import java.sql.Statement;

public class EndDateVariableSetter implements AutomaticVariableSetter
{
  public static final EndDateVariableSetter INSTANCE = new EndDateVariableSetter();
  private EndDateVariableSetter()
  {
  }
  public synchronized void setFor(DatabaseObject forObject, int atStage, Statement stmt)
  {
    // Grab a lock
    if (atStage == AutomaticVariableSetter.INSERT)
    {
      String endDateSQL = "UPDATE " + forObject.getMetadata().getTableName() + " " + "SET end_date = '"
          + ((AddDateAware) forObject).getAddDate() + "' " + "WHERE end_date IS NULL " + "  AND "
          + ((EndDateAware) forObject).getEffectivityKey();
      SimpleLogger.query("END DATE", endDateSQL);
      int rowsChanged = ObjectUtils.throwAsError(() -> stmt.executeUpdate(endDateSQL));
      if (rowsChanged > 1)
      {
        SimpleLogger.query("endDateSQL", endDateSQL);
        throw new Error("item_makeup:setEndDate set " + rowsChanged + " rows");
      }
    }
  }
}