Package org.pgcodekeeper.core.database.pg.schema

Class PgTrigger

java.lang.Object
org.pgcodekeeper.core.database.base.schema.AbstractStatement
org.pgcodekeeper.core.database.pg.schema.PgAbstractStatement
org.pgcodekeeper.core.database.pg.schema.PgTrigger
All Implemented Interfaces:
ISearchPath, IStatement, ISubElement, ITrigger, IHashable
public class PgTrigger extends PgAbstractStatement implements ITrigger
PostgreSQL trigger implementation. Triggers are functions that are automatically executed in response to database events like INSERT, UPDATE, DELETE, or TRUNCATE on tables or views.

  • Constructor Details

    • PgTrigger

      public PgTrigger(String name)
      Creates a new PostgreSQL trigger.
      Parameters:
      name - trigger name

  • Method Details

    • getCreationSQL

      public void getCreationSQL(SQLScript script)
      Description copied from interface: IStatement
      Generates the SQL statements needed to create this database object. This is an abstract method that must be implemented by subclasses to provide the specific CREATE SQL for each object type.
      Specified by:
      getCreationSQL in interface IStatement
      Parameters:
      script - the SQL script to append creation statements to

    • appendAlterSQL

      public ObjectState appendAlterSQL(IStatement newCondition, SQLScript script)
      Description copied from interface: IStatement
      Fill script with object changes and return change type
      Specified by:
      appendAlterSQL in interface IStatement
      Parameters:
      newCondition - new object state
      script - script to collect changes
      Returns:
      object change type

    • canDropBeforeCreate

      public boolean canDropBeforeCreate()
      Description copied from interface: IStatement
      Checks if this statement can be dropped before being recreated. Override in subclasses that support drop-before-create behavior.
      Specified by:
      canDropBeforeCreate in interface IStatement
      Overrides:
      canDropBeforeCreate in class AbstractStatement
      Returns:
      true if the statement can be dropped before recreation

    • appendFullName

      public void appendFullName(StringBuilder sb)

    • setType

      public void setType(PgTrigger.TgTypes tgType)

    • setForEachRow

      public void setForEachRow(boolean isForEachRow)

    • setFunction

      public void setFunction(String function)

    • setOnDelete

      public void setOnDelete(boolean isOnDelete)

    • setOnInsert

      public void setOnInsert(boolean isOnInsert)

    • setOnUpdate

      public void setOnUpdate(boolean isOnUpdate)

    • setOnTruncate

      public void setOnTruncate(boolean isOnTruncate)

    • setConstraint

      public void setConstraint(boolean isConstraint)

    • addUpdateColumn

      public void addUpdateColumn(String columnName)
      Adds a column name to the UPDATE OF clause.
      Parameters:
      columnName - column to monitor for updates

    • setWhen

      public void setWhen(String when)

    • setImmediate

      public void setImmediate(Boolean isImmediate)

    • setRefTableName

      public void setRefTableName(String refTableName)

    • setOldTable

      public void setOldTable(String oldTable)

    • setNewTable

      public void setNewTable(String newTable)

    • setTriggerState

      public void setTriggerState(PgTriggerState triggerState)

    • computeHash

      public void computeHash(Hasher hasher)
      Description copied from interface: IHashable
      Computes the hash of the implementing object using the provided hasher. The implementation should call appropriate put methods on the hasher for all fields that should contribute to the hash value.
      Specified by:
      computeHash in interface IHashable
      Parameters:
      hasher - the hasher instance to use for hash computation

    • compare

      public boolean compare(IStatement obj)
      Description copied from class: AbstractStatement
      This method does not account for nested child PgStatements. Shallow version of AbstractStatement.equals(Object)
      Specified by:
      compare in interface IStatement
      Overrides:
      compare in class AbstractStatement