| java.lang.Object org.netbeans.modules.etl.codegen.impl.BaseETLStrategyBuilder org.netbeans.modules.etl.codegen.impl.PipelinedStrategyBuilderImpl
All known Subclasses: org.netbeans.modules.etl.codegen.impl.ValidatingStrategyBuilderImpl,
PipelinedStrategyBuilderImpl | public class PipelinedStrategyBuilderImpl extends BaseETLStrategyBuilder (Code) | | author: Jonathan Giron author: Ritesh Adval version: $Revision$ |
Method Summary | |
public void | addSelectRejectedRowCountStatement(ETLTaskNode updateStats, TargetTable tt) | protected void | buildCleanupStatements(ETLTaskNode cleanupTask, List targetTables) | public ETLTaskNode | buildCleanupTask(List targetTables) Builds ETLTaskNode to hold and execute statements associated with execution cleanup
for the given List of TargetTables. | void | buildFlatfileSQLParts(ETLTaskNode initTask, ETLTaskNode cleanupTask, TargetTable tTable, ETLScriptBuilderModel model) | public ETLTaskNode | buildInitTask(List targetTables) | protected void | buildInitializationStatements(SQLDBTable table, ETLTaskNode initTask, Map connDefToLinkName) | ETLTaskNode | buildPipelineTransformTask(ETLStrategyBuilderContext context, TargetTable tt) | protected void | createTargetTableIfNotExists(TargetTable table, ETLTaskNode taskNode, String trgtConnName, DB targetDB) | protected SQLPart | createTransformStatement(TargetTable tt, StatementContext context) Creates SQLPart containing appropriate transformation statement for the given run
mode and TargetTable instance, using the given StatementContext to assist in
statement generation. | public void | generateScriptForTable(ETLStrategyBuilderContext context) | protected String | getCommentForTransformer(TargetTable targetTable) | protected String | getCreateDBLinkSQL(DBConnectionDefinition connDef, String linkName) | protected String | getDropExternalTableSQL(SQLDBTable table, String localName, boolean ifExists, StatementContext context) Generates drop external statement for the given SQLDBTable if appropriate. | public String | getScriptToDisplay(ETLStrategyBuilderContext context) | protected String | getTaskType() | protected boolean | requiresRemoteAccess(SQLDBTable table) |
addSelectRejectedRowCountStatement | public void addSelectRejectedRowCountStatement(ETLTaskNode updateStats, TargetTable tt) throws BaseException(Code) | | |
buildCleanupStatements | protected void buildCleanupStatements(ETLTaskNode cleanupTask, List targetTables) throws BaseException(Code) | | Parameters: cleanupTask - Parameters: pfGen - Parameters: targetTables - |
buildCleanupTask | public ETLTaskNode buildCleanupTask(List targetTables) throws BaseException(Code) | | Builds ETLTaskNode to hold and execute statements associated with execution cleanup
for the given List of TargetTables.
Parameters: pfGen - PipelinedFlowGenerator to use in building the cleanup task node Parameters: targetTables - List of TargetTables whose cleanup statements are to begenerated ETLTaskNode containing cleanup statements to be executed throws: BaseException - if error occurs during statement generation |
buildInitTask | public ETLTaskNode buildInitTask(List targetTables) throws BaseException(Code) | | |
buildInitializationStatements | protected void buildInitializationStatements(SQLDBTable table, ETLTaskNode initTask, Map connDefToLinkName) throws BaseException(Code) | | |
createTargetTableIfNotExists | protected void createTargetTableIfNotExists(TargetTable table, ETLTaskNode taskNode, String trgtConnName, DB targetDB) throws BaseException(Code) | | |
createTransformStatement | protected SQLPart createTransformStatement(TargetTable tt, StatementContext context) throws BaseException(Code) | | Creates SQLPart containing appropriate transformation statement for the given run
mode and TargetTable instance, using the given StatementContext to assist in
statement generation.
Parameters: runMode - ETLProcessFlowGenerator.DESIGN_TIME if statement will be executed indesign time, ETLProcessFlowGenerator.RUN_TIME if statement will be executedin runtime on an app server Parameters: tt - TargetTable whose transformation statement is to be generated Parameters: context - StatementContext to use in generating transformation statement SQLPart containing transformation statement throws: BaseException - if error occurs during statement generation |
generateScriptForTable | public void generateScriptForTable(ETLStrategyBuilderContext context) throws BaseException(Code) | | Before calling apply appropriate applyConnections
|
getCommentForTransformer | protected String getCommentForTransformer(TargetTable targetTable) throws BaseException(Code) | | Generate Transformer comment line for a given target table
Parameters: targetTable - Comment String |
getDropExternalTableSQL | protected String getDropExternalTableSQL(SQLDBTable table, String localName, boolean ifExists, StatementContext context) throws BaseException(Code) | | Generates drop external statement for the given SQLDBTable if appropriate.
Parameters: table - SQLDBTable for which to generate a drop external statement Parameters: localName - local name of table as used in the Axion database; may bedifferent from the table name contained in table Parameters: ifExists - true if statement should include an "IF EXISTS" qualifier Parameters: context - StatementContext to use in generating statement SQL statement representing drop external statement for SQLDBTable. throws: BaseException - if error occurs during statement generation |
requiresRemoteAccess | protected boolean requiresRemoteAccess(SQLDBTable table)(Code) | | |
Methods inherited from org.netbeans.modules.etl.codegen.impl.BaseETLStrategyBuilder | protected void addCreateIfNotExistsSummaryTableStatement(ETLTaskNode initTask) throws BaseException(Code)(Java Doc) protected void addInsertNewExecutionRecordStatement(ETLTaskNode taskNode, TargetTable tt) throws BaseException(Code)(Java Doc) protected void addSelectExecutionIdForNewExecutionRecordStatement(ETLTaskNode pipeline, TargetTable tt) throws BaseException(Code)(Java Doc) protected void addUpdateExecutionRecordPreparedStatement(ETLTaskNode updateStats, TargetTable tt) throws BaseException(Code)(Java Doc) protected boolean areAllAssociatedTablesInternal(TargetTable tt) throws BaseException(Code)(Java Doc) protected void checkTargetConnectionDefinition(ETLStrategyBuilderContext context) throws BaseException(Code)(Java Doc) protected void createCorrelatedUpdateSQLParts(TargetTable tt, ETLTaskNode correlatedQueryExecutor, String trgtConnName, DB targetDB, DB statsDB, boolean genInsertSelect) throws BaseException(Code)(Java Doc) protected SQLPart createSQLPart(String sqlString, String key, String conDefnName)(Code)(Java Doc) protected void createTargetTableIfNotExists(TargetTable table, ETLTaskNode taskNode, String trgtConnName, DB targetDB, StatementContext context) throws BaseException(Code)(Java Doc) protected void createTransformerSQLPart(TargetTable tt, boolean useSourceFilter, ETLTaskNode transformerTask, String trgtConnName, ETLTaskNode cleanupTask, DB targetDB, DB statsDB) throws BaseException(Code)(Java Doc) protected SQLPart generateDefragPart(TargetTable tt, DB targetDB, int statementType) throws BaseException(Code)(Java Doc) protected SQLPart generateSQLPart(FlatfileDBTable flatfileDBTable, String tableName, String staticDirectory, String stmtType, String connPoolName, String flatfileRuntimeFilePath, boolean isDynamicPath, boolean createDataFileIfNotExist)(Code)(Java Doc) protected SQLPart generateTransformerSQLPart(TargetTable tt, boolean useSourceFilter, DB targetDB, int statementType, List srcTblList) throws BaseException(Code)(Java Doc) protected String getCommentForTransformer(TargetTable targetTable) throws BaseException(Code)(Java Doc) protected String getConDefnName(DBConnectionDefinition srcCondefn)(Code)(Java Doc) public static Properties getConnectionPropertiesFrom(DBConnectionDefinition def)(Code)(Java Doc) protected Map getCorrelatedUpdateQueries(TargetTable tt, DB targetDB, boolean genInsertSelect) throws BaseException(Code)(Java Doc) protected DB getDBFor(DBConnectionDefinition srcConDefn) throws BaseException(Code)(Java Doc) protected ETLEngine getEngine()(Code)(Java Doc) protected void getFlatfileInitSQLParts(FlatfileDefinition ffdb, InternalDBMetadata ffMetadata, boolean isAllDBTypeInternal, ETLTaskNode initTask, ETLTaskNode cleanupTask, String connPoolName, SQLDBTable flatfileRuntime, boolean createDataFileIfNotExist)(Code)(Java Doc) protected void getFlatfileInitSQLParts(FlatfileDefinition ffdb, InternalDBMetadata internalMetadata, ETLTaskNode initTask, ETLTaskNode cleanupTask, SQLDBTable flatfileRuntime, boolean createDataFileIfNotExist)(Code)(Java Doc) protected Statements getStatementsForTableDB(DBTable table) throws BaseException(Code)(Java Doc) protected Statements getStatementsForTableDB(DBTable table, ETLStrategyBuilderContext context) throws BaseException(Code)(Java Doc) protected Statements getStatementsForTargetTableDB(ETLStrategyBuilderContext context) throws BaseException(Code)(Java Doc) protected String getTargetConnName()(Code)(Java Doc) protected Statements getTargetStatements() throws BaseException(Code)(Java Doc) protected String getTransformerSQL(TargetTable targetTable, DB targetDB, List srcTblList, boolean useSourceFilter) throws BaseException(Code)(Java Doc) protected boolean isExtractionRequired(SourceTable sourceTable, TargetTable targetTable) throws BaseException(Code)(Java Doc) protected List makeUniqueTableNames(ETLStrategyBuilderContext context) throws BaseException(Code)(Java Doc) protected void populateFlatfileMetadata(TargetTable tTable, String tgtConnPoolName, InternalDBMetadata tgtInternalMetadata, ETLTaskNode initTask, ETLTaskNode cleanupTask) throws BaseException(Code)(Java Doc) protected void populateInitTask(ETLTaskNode initTask, ETLTaskNode cleanupTask, TargetTable tTable) throws BaseException(Code)(Java Doc) public void setETLScriptBuilderModel(ETLScriptBuilderModel model)(Code)(Java Doc) protected void truncateTableIfExists(SQLDBTable dbt, ETLTaskNode taskNode, String trgtConnName, Statements stmts, StatementContext sc) throws BaseException(Code)(Java Doc) protected void truncateTargetTableIfExists(TargetTable tt, ETLTaskNode taskNode, String trgtConnName, Statements stmts, StatementContext sc) throws BaseException(Code)(Java Doc) final protected void useUniqueNameIfRequired(SQLDBTable table, StatementContext sc) throws BaseException(Code)(Java Doc)
|
|
|