public static String getLogging( ReportSubjectLocation filename ) throws KettleException { List<LogTableInterface> logTables; if ( filename.isTransformation() ) { TransMeta transMeta = TransformationInformation.getInstance().getTransMeta( filename ); logTables = transMeta.getLogTables(); } else { JobMeta jobMeta = JobInformation.getInstance().getJobMeta( filename ); logTables = jobMeta.getLogTables(); } String logging = ""; for ( Iterator<LogTableInterface> iterator = logTables.iterator(); iterator.hasNext(); ) { LogTableInterface logTableInterface = iterator.next(); if ( logTableInterface.getDatabaseMeta() != null && !Utils.isEmpty( logTableInterface.getTableName() ) ) { if ( logging.length() > 0 ) { logging += ", "; } logging += logTableInterface.getTableName() + "@" + logTableInterface.getDatabaseMeta().getName(); } } return logging; }
fdLogtable.right = new FormAttachment( 100, 0 ); wLogTable.setLayoutData( fdLogtable ); wLogTable.setText( Const.NVL( logTable.getTableName(), "" ) ); wLogTable.setToolTipText( BaseMessages.getString( PKG, "TransDialog.LogTable.Tooltip", logTable .getTableNameVariable() ) );
if ( logTable.getDatabaseMeta() != null && !Utils.isEmpty( logTable.getTableName() ) ) { String tableName = db.environmentSubstitute( logTable.getTableName() ); String schemaTable = logTable.getDatabaseMeta().getQuotedSchemaTableCombination( db.environmentSubstitute( logTable.getSchemaName() ), db.environmentSubstitute( logTable.getTableName() ) ); String createTable = db.getDDL( schemaTable, fields );
fdLogtable.right = new FormAttachment( 100, 0 ); wLogTable.setLayoutData( fdLogtable ); wLogTable.setText( Const.NVL( logTable.getTableName(), "" ) ); wLogTable.setToolTipText( BaseMessages.getString( PKG, "JobDialog.LogTable.Tooltip", logTable .getTableNameVariable() ) );
if ( logTable.getDatabaseMeta() != null && !Utils.isEmpty( logTable.getTableName() ) ) { String tableName = db.environmentSubstitute( logTable.getTableName() ); String schemaTable = logTable.getDatabaseMeta().getQuotedSchemaTableCombination(
sql += dbMeta.quoteField( logTable.getErrorsField().getFieldName() ) + ""; sql += " FROM "; sql += dbMeta.getQuotedSchemaTableCombination( logTable.getSchemaName(), logTable.getTableName() ); sql += " ORDER BY " + dbMeta.quoteField( logTable.getLogDateField().getFieldName() ) + " DESC";
for ( LogTableInterface logTable : new LogTableInterface[] { transLogTable, performanceLogTable, channelLogTable, stepLogTable, } ) { if ( logTable.getDatabaseMeta() != null && !Utils.isEmpty( logTable.getTableName() ) ) { schemaTable = logTable.getDatabaseMeta() .getQuotedSchemaTableCombination( logTable.getSchemaName(), logTable.getTableName() ); String sql = db.getDDL( schemaTable, fields ); if ( !Utils.isEmpty( sql ) ) {