Class DB_Trigger
- java.lang.Object
-
- org.apache.derby.impl.tools.dblook.DB_Trigger
-
public class DB_Trigger extends java.lang.Object
-
-
Field Summary
Fields Modifier and Type Field Description private static java.lang.String
EVENT
private static java.lang.String
FIRINGTIME
private static java.lang.String
NEWREFERENCINGNAME
private static java.lang.String
OLDREFERENCINGNAME
private static java.lang.String
REFERENCEDCOLUMNS
private static java.lang.String
REFERENCINGNEW
private static java.lang.String
REFERENCINGOLD
private static java.lang.String
SCHEMAID
private static java.lang.String
TABLEID
private static java.lang.String
TRIGGERDEFINITION
private static java.lang.String
TRIGGERNAME
private static java.lang.String
TYPE
private static java.lang.String
WHENCLAUSETEXT
-
Constructor Summary
Constructors Constructor Description DB_Trigger()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description private static java.lang.String
createTrigger(java.lang.String trigName, java.lang.String tableName, java.lang.String whenClause, java.sql.ResultSet aTrig)
Generate DDL for a specific trigger.static void
doTriggers(java.sql.Connection conn, boolean supportsWhenClause)
Generate the DDL for all triggers in a given database.
-
-
-
Field Detail
-
TRIGGERNAME
private static final java.lang.String TRIGGERNAME
- See Also:
- Constant Field Values
-
SCHEMAID
private static final java.lang.String SCHEMAID
- See Also:
- Constant Field Values
-
EVENT
private static final java.lang.String EVENT
- See Also:
- Constant Field Values
-
FIRINGTIME
private static final java.lang.String FIRINGTIME
- See Also:
- Constant Field Values
-
TYPE
private static final java.lang.String TYPE
- See Also:
- Constant Field Values
-
TABLEID
private static final java.lang.String TABLEID
- See Also:
- Constant Field Values
-
REFERENCEDCOLUMNS
private static final java.lang.String REFERENCEDCOLUMNS
- See Also:
- Constant Field Values
-
TRIGGERDEFINITION
private static final java.lang.String TRIGGERDEFINITION
- See Also:
- Constant Field Values
-
REFERENCINGOLD
private static final java.lang.String REFERENCINGOLD
- See Also:
- Constant Field Values
-
REFERENCINGNEW
private static final java.lang.String REFERENCINGNEW
- See Also:
- Constant Field Values
-
OLDREFERENCINGNAME
private static final java.lang.String OLDREFERENCINGNAME
- See Also:
- Constant Field Values
-
NEWREFERENCINGNAME
private static final java.lang.String NEWREFERENCINGNAME
- See Also:
- Constant Field Values
-
WHENCLAUSETEXT
private static final java.lang.String WHENCLAUSETEXT
- See Also:
- Constant Field Values
-
-
Method Detail
-
doTriggers
public static void doTriggers(java.sql.Connection conn, boolean supportsWhenClause) throws java.sql.SQLException
Generate the DDL for all triggers in a given database.- Parameters:
conn
- Connection to the source database.supportsWhenClause
- Tells whether the database supports the trigger WHEN clause.- Throws:
java.sql.SQLException
-
createTrigger
private static java.lang.String createTrigger(java.lang.String trigName, java.lang.String tableName, java.lang.String whenClause, java.sql.ResultSet aTrig) throws java.sql.SQLException
Generate DDL for a specific trigger.- Parameters:
trigName
- Name of the trigger.tableName
- Name of the table on which the trigger fires.whenClause
- The WHEN clause text (possiblynull
).aTrig
- Information about the trigger.- Returns:
- The DDL for the current trigger is returned as a String.
- Throws:
java.sql.SQLException
-
-