|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--dke.smwp.trigger.AbstractTrigger
Abstract case class of all triggers;
Field Summary | |
protected ConnectionPool |
_connectionPool
|
protected java.lang.String |
NEW_OPERATOR
sql new operator |
protected java.lang.String |
OLD_OPERATOR
sql old operator |
Constructor Summary | |
AbstractTrigger()
default constructor |
Method Summary | |
void |
dropTrigger(java.lang.String fc_longName)
drops all derived fragment data trigger using fragment class fc_longName as trigger target |
protected int[] |
getTColumnPosition(java.lang.String tableName,
java.util.ArrayList columnNameList)
checks the position of a column in a TColumnTable object; not by using the TColumnsTable directly but checking for the same order of columns in the table tableName , also used for TColumnTable generation; |
protected int |
getTColumnPosition(java.lang.String tableName,
java.lang.String columnName)
checks the position of a column in a TColumnTable object; not by using the TColumnsTable directly but checking for the same order of columns in the table tableName , also used for TColumnTable generation; |
protected int[] |
getTColumnPosition(java.lang.String tableName,
java.lang.String[] columnNames)
checks the position of a column in a TColumnTable object; not using the TColumnsTable directly but checking for the same order of columns in table tableName used for TColumnTable generation; |
protected java.lang.String |
getTColumnString(java.lang.String tablename)
generates PL/SQL trigger code for creating and initializing TColumnTable objects within triger; TColumnTable
is used as container for tuples which are used by java stored procedures; |
java.lang.String |
getWhereClause(java.util.ArrayList columns_left,
java.util.ArrayList columns_right,
java.lang.String leftPrefix,
java.lang.String rightPrefix,
java.lang.String seperator,
java.lang.String comparison_operator)
generates sql where clause; used for PL/SQL trigger; columns_left and columns_right
can contain a mixture of Column and String objects
leftPrefix columnName_left comparison_operator rightPrefix columnName_right
{ seperator leftPrefix columnName_left comparison_operator rightPrefix columnName_right }
|
java.lang.String |
getWhereClause(java.util.ArrayList columns,
java.lang.String leftPrefix,
java.lang.String rightPrefix,
java.lang.String seperator,
java.lang.String comparison_operator)
generates sql where clause; used for PL/SQL trigger; the same colun name is used on both sides of the comparison operator; columns can contain a mixture of Column and String objects;
leftPrefix columnName comparison_operator rightPrefix columnName
{ seperator leftPrefix columnName comparison_operator rightPrefix columnName }
|
java.lang.String |
getWhereClause(java.lang.String[] columns_left,
java.lang.String[] columns_right,
java.lang.String leftPrefix,
java.lang.String rightPrefix,
java.lang.String seperator,
java.lang.String comparison_operator)
generates sql where clause; used for PL/SQL trigger; leftPrefix columnName_left comparison_operator rightPrefix columnName_right { seperator leftPrefix columnName_left comparison_operator rightPrefix columnName_right } |
java.lang.String |
getWhereClause(java.lang.String[] columns,
java.lang.String leftPrefix,
java.lang.String rightPrefix,
java.lang.String seperator,
java.lang.String comparison_operator)
generates sql where clause; used for PL/SQL trigger; the same coloumn name is used on both sides of the comarison operator with different prefixes; leftPrefix columnName comparison_operator rightPrefix columnName { seperator leftPrefix columnName comparison_operator rightPrefix columnName } |
static java.lang.String |
stingReplace(java.lang.String sourceString,
java.lang.String searchPattern,
java.lang.String replacePattern)
replace all occurrences in sourceString of searchPattern with replace pattern if replacePattern is used as column name; |
static java.lang.String |
stingTablenameReplace(java.lang.String sourceString,
java.lang.String searchPattern,
java.lang.String replacePattern)
replace all occurrences in sourceString of
searchPattern with replacePattern if
searchPattern is used as table name
.. ( |
Methods inherited from class java.lang.Object |
|
Field Detail |
protected ConnectionPool _connectionPool
protected java.lang.String NEW_OPERATOR
protected java.lang.String OLD_OPERATOR
Constructor Detail |
public AbstractTrigger()
Method Detail |
public void dropTrigger(java.lang.String fc_longName)
fc_longName
as trigger targetfc_shortName
- name of the fragment class relation,
which is trigger targetpublic java.lang.String getWhereClause(java.lang.String[] columns, java.lang.String leftPrefix, java.lang.String rightPrefix, java.lang.String seperator, java.lang.String comparison_operator)
leftPrefix columnName comparison_operator rightPrefix columnName { seperator leftPrefix columnName comparison_operator rightPrefix columnName }
columns
- Array of String containing column names used
for where clauseleftPrefix
- String prefix used on the left side of the
comparison operatorrightPrefix
- String prefix used on the right side of the
comparison operatorseperator
- seperaor of whereClauses; f.e. "AND", "OR"comparison_operator
- sql operator; f.e. "=", "!="java.lang.ClassCastException
- columns
contains object which is
neither String nor Columnpublic java.lang.String getWhereClause(java.util.ArrayList columns, java.lang.String leftPrefix, java.lang.String rightPrefix, java.lang.String seperator, java.lang.String comparison_operator)
columns
can contain a mixture of Column and String objects;
leftPrefix columnName comparison_operator rightPrefix columnName { seperator leftPrefix columnName comparison_operator rightPrefix columnName }
columns
- List containing Column objects or String objects
used for whereClauseleftPrefix
- String prefix, used on the left side of the
comparison operatorrightPrefix
- String prefix used on the right side of the
comparison operatorseperator
- seperator of whereClauses; f.e. "AND", "OR"comparison_operator
- sql operator; f.e. "=", "!="java.lang.ClassCastException
- columns
contains object which is
neither String nor Columnpublic java.lang.String getWhereClause(java.lang.String[] columns_left, java.lang.String[] columns_right, java.lang.String leftPrefix, java.lang.String rightPrefix, java.lang.String seperator, java.lang.String comparison_operator)
leftPrefix columnName_left comparison_operator rightPrefix columnName_right { seperator leftPrefix columnName_left comparison_operator rightPrefix columnName_right }
columns_left
- Array of String containing column names used
for left side of where clausecolumns_right
- Array of String containing column names used
for right side of where clauseleftPrefix
- String prefix, used on the left side of the
comparison operatorrightPrefix
- String prefix used on the right side of the
comparison operatorseperator
- seperator of whereClauses; f.e. "AND", "OR"comparison_operator
- sql operator; f.e. "=", "!="java.lang.ClassCastException
- columns
contains object which is
neither String nor Columnpublic java.lang.String getWhereClause(java.util.ArrayList columns_left, java.util.ArrayList columns_right, java.lang.String leftPrefix, java.lang.String rightPrefix, java.lang.String seperator, java.lang.String comparison_operator)
columns_left
and columns_right
can contain a mixture of Column and String objects
leftPrefix columnName_left comparison_operator rightPrefix columnName_right { seperator leftPrefix columnName_left comparison_operator rightPrefix columnName_right }
columns_left
- Array of String containing column names used
for left side of where clausecolumns_right
- Array of String containing column names used
for right side of where clauseleftPrefix
- String prefix, used on the left side of the
comparison operatorrightPrefix
- String prefix used on the right side of the
comparison operatorseperator
- seperator of whereClauses; f.e. "AND", "OR"comparison_operator
- sql operator; f.e. "=", "!="java.lang.ClassCastException
- columns
contains object which is
neither String nor Columnprotected int getTColumnPosition(java.lang.String tableName, java.lang.String columnName) throws java.sql.SQLException
tableName
, also used for TColumnTable generation;tableName
- relation which is checked for the position the columncolumnName
- name of column whose position is to be fetchedjava.sql.SQLException
- error on fetching table metadataTColumnTable
protected int[] getTColumnPosition(java.lang.String tableName, java.util.ArrayList columnNameList) throws java.sql.SQLException
tableName
, also used for TColumnTable generation;tableName
- relation which is checked for the position the columncolumnNameList
- List of String containing names of columns whose
position are to be fetchedjava.sql.SQLException
- error fetching table metadataTColumnTable
protected int[] getTColumnPosition(java.lang.String tableName, java.lang.String[] columnNames) throws java.sql.SQLException
tableName
used for TColumnTable generation;tableName
- relation containing the column which is to be checkedcolumnNames
- names of columns whose positions are to be checkedjava.sql.SQLException
- error on fetching table metadataprotected java.lang.String getTColumnString(java.lang.String tablename) throws java.sql.SQLException
TColumnTable
objects within triger; TColumnTable
is used as container for tuples which are used by java stored procedures;tablename
- table used as base for abstraction
as TColumnTable
java.sql.SQLException
- error fetching table meta-datapublic static java.lang.String stingReplace(java.lang.String sourceString, java.lang.String searchPattern, java.lang.String replacePattern)
sourceString
- string which is to be modifiedsearchPattern
- string pattern which is to be replacedreplacePattern
- string which replaces searchPatternpublic static java.lang.String stingTablenameReplace(java.lang.String sourceString, java.lang.String searchPattern, java.lang.String replacePattern)
sourceString
of
searchPattern
with replacePattern
if
searchPattern
is used as table name
.. ( operator | " " ) tableName "." columnName ..
sourceString
- string which is to be modifiedsearchPattern
- string pattern which is to be replacedreplacePattern
- string which replaces searchPattern
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |