Class CreateTriggerConstantAction

java.lang.Object

org.apache.derby.impl.sql.execute.DDLConstantAction

org.apache.derby.impl.sql.execute.DDLSingleTableConstantAction

org.apache.derby.impl.sql.execute.CreateTriggerConstantAction

All Implemented Interfaces:

ConstantAction

class CreateTriggerConstantAction
extends DDLSingleTableConstantAction

This class describes actions that are ALWAYS performed for a CREATE TRIGGER Statement at Execution time.

Field Summary

Fields

Modifier and Type	Field	Description
private UUID	actionSPSId
private String	actionText
private int	eventMask
private boolean	isBefore
private boolean	isEnabled
private boolean	isRow
private String	newReferencingName
private String	oldReferencingName
private String	originalActionText
private final String	originalWhenText
private final ProviderInfo[]	providerInfo
private int[]	referencedCols
private int[]	referencedColsInTriggerAction
private boolean	referencingNew
private boolean	referencingOld
private UUID	spsCompSchemaId
private String	triggerName
private String	triggerSchemaName
private TableDescriptor	triggerTable
private UUID	triggerTableId
private UUID	whenSPSId
private String	whenText

Fields inherited from class DDLSingleTableConstantAction

tableId

Fields inherited from interface ConstantAction

WHEN_MATCHED_THEN_DELETE, WHEN_MATCHED_THEN_UPDATE, WHEN_NOT_MATCHED_THEN_INSERT

Constructor Summary

Constructors

Constructor

Description

CreateTriggerConstantAction(String triggerSchemaName, String triggerName, int eventMask, boolean isBefore, boolean isRow, boolean isEnabled, TableDescriptor triggerTable, UUID whenSPSId, String whenText, UUID actionSPSId, String actionText, UUID spsCompSchemaId, int[] referencedCols, int[] referencedColsInTriggerAction, String originalWhenText, String originalActionText, boolean referencingOld, boolean referencingNew, String oldReferencingName, String newReferencingName, ProviderInfo[] providerInfo)

Make the ConstantAction for a CREATE TRIGGER statement.

Method Summary

Modifier and Type	Method	Description
private SPSDescriptor	createSPS(LanguageConnectionContext lcc, DataDescriptorGenerator ddg, DataDictionary dd, TransactionController tc, UUID triggerId, SchemaDescriptor sd, UUID spsId, UUID compSchemaId, String text, boolean isWhen, TableDescriptor triggerTable)
void	executeConstantAction(Activation activation)	This is the guts of the Execution-time logic for CREATE TRIGGER.
private Timestamp	makeCreationTimestamp(DataDictionary dd)	Construct the creation timestamp for the trigger.
String	toString()

Methods inherited from class DDLSingleTableConstantAction

dropConglomerate, dropConglomerate, dropConstraint, dropConstraint, dropConstraint, executeConglomReplacement, getConglomReplacementAction, recreateUniqueConstraintBackingIndexAsUniqueWhenNotNull

Methods inherited from class DDLConstantAction

addColumnDependencies, adjustUDTDependencies, adjustUDTDependencies, constructToString, getAndCheckSchemaDescriptor, getSchemaDescriptorForCreate, lockTableForDDL, storeConstraintDependenciesOnPrivileges, storeViewTriggerDependenciesOnPrivileges

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Details

triggerName

private String triggerName

triggerSchemaName

private String triggerSchemaName

triggerTable

private TableDescriptor triggerTable

triggerTableId

private UUID triggerTableId

eventMask

private int eventMask

isBefore

private boolean isBefore

isRow

private boolean isRow

isEnabled

private boolean isEnabled

referencingOld

private boolean referencingOld

referencingNew

private boolean referencingNew

whenSPSId

private UUID whenSPSId

whenText

private String whenText

actionSPSId

private UUID actionSPSId

actionText

private String actionText

originalWhenText

private final String originalWhenText

originalActionText

private String originalActionText

oldReferencingName

private String oldReferencingName

newReferencingName

private String newReferencingName

spsCompSchemaId

private UUID spsCompSchemaId

referencedCols

private int[] referencedCols

referencedColsInTriggerAction

private int[] referencedColsInTriggerAction

providerInfo

private final ProviderInfo[] providerInfo

Constructor Details

CreateTriggerConstantAction

CreateTriggerConstantAction(String triggerSchemaName,
 String triggerName,
 int eventMask,
 boolean isBefore,
 boolean isRow,
 boolean isEnabled,
 TableDescriptor triggerTable,
 UUID whenSPSId,
 String whenText,
 UUID actionSPSId,
 String actionText,
 UUID spsCompSchemaId,
 int[] referencedCols,
 int[] referencedColsInTriggerAction,
 String originalWhenText,
 String originalActionText,
 boolean referencingOld,
 boolean referencingNew,
 String oldReferencingName,
 String newReferencingName,
 ProviderInfo[] providerInfo)

Make the ConstantAction for a CREATE TRIGGER statement.

Parameters:

triggerSchemaName - name for the schema that trigger lives in.

triggerName - Name of trigger

eventMask - TriggerDescriptor.TRIGGER_EVENT_XXXX

isBefore - is this a before (as opposed to after) trigger

isRow - is this a row trigger or statement trigger

isEnabled - is this trigger enabled or disabled

triggerTable - the table upon which this trigger is defined

whenSPSId - the sps id for the when clause (may be null)

whenText - the text of the when clause (may be null)

actionSPSId - the spsid for the trigger action (may be null)

actionText - the text of the trigger action

spsCompSchemaId - the compilation schema for the action and when spses. If null, will be set to the current default schema

referencedCols - what columns does this trigger reference (may be null)

referencedColsInTriggerAction - what columns does the trigger action reference through old/new transition variables (may be null)

originalWhenText - The original user text of the WHEN clause (may be null)

originalActionText - The original user text of the trigger action

referencingOld - whether or not OLD appears in REFERENCING clause

referencingNew - whether or not NEW appears in REFERENCING clause

oldReferencingName - old referencing table name, if any, that appears in REFERENCING clause

newReferencingName - new referencing table name, if any, that appears in REFERENCING clause

providerInfo - array of providers that the trigger depends on

Method Details

executeConstantAction

public void executeConstantAction(Activation activation)
                           throws StandardException

This is the guts of the Execution-time logic for CREATE TRIGGER.

Parameters:

activation - The execution environment for this constant action.

Throws:

StandardException - Thrown on failure

See Also:

• ConstantAction.executeConstantAction(Activation)

createSPS

private SPSDescriptor createSPS(LanguageConnectionContext lcc,
 DataDescriptorGenerator ddg,
 DataDictionary dd,
 TransactionController tc,
 UUID triggerId,
 SchemaDescriptor sd,
 UUID spsId,
 UUID compSchemaId,
 String text,
 boolean isWhen,
 TableDescriptor triggerTable)
                         throws StandardException

Throws:

StandardException

toString

public String toString()

Overrides:

toString in class Object

makeCreationTimestamp

private Timestamp makeCreationTimestamp(DataDictionary dd)
                                 throws StandardException

Construct the creation timestamp for the trigger. DERBY-5866: Also make sure the creation timestamp is higher than any timestamp on an existing trigger on the same table. Otherwise, the triggers may not fire in the correct order.

Throws:

StandardException