protected Table toAuditTable(Table table) { Table auditTable = table.copy(); String tableName = table.getName(); if (!FormatUtils.isMixedCase(tableName)) { tableName = tableName.toUpperCase(); } auditTable.setName(String.format("%s_AUDIT", tableName)); Column[] columns = auditTable.getColumns(); auditTable.removeAllColumns(); auditTable.addColumn(new Column(COLUMN_AUDIT_ID, true, Types.BIGINT, 0, 0)); auditTable.addColumn(new Column(COLUMN_AUDIT_TIME, false, Types.TIMESTAMP, 0, 0)); auditTable.addColumn(new Column(COLUMN_AUDIT_EVENT, false, Types.CHAR, 1, 0)); for (Column column : columns) { column.setRequired(false); column.setPrimaryKey(false); column.setAutoIncrement(false); auditTable.addColumn(column); } auditTable.removeAllForeignKeys(); auditTable.removeAllIndices(); engine.getDatabasePlatform().alterCaseToMatchDatabaseDefaultCase(auditTable); return auditTable; }
new String[rowData.keySet().size()]); for (String colName : columnNames) { table.addColumn(new Column(colName));
new String[rowData.keySet().size()]); for (String colName : columnNames) { table.addColumn(new Column(colName));
@Override protected void init() { try { this.csvReader = CsvUtils.getCsvReader(reader); this.csvReader.setUseComments(true); this.csvReader.readHeaders(); String[] columnNames = this.csvReader.getHeaders(); for (String columnName : columnNames) { table.addColumn(new Column(columnName)); } } catch (IOException e) { throw new IoException(e); } }
public Table buildTargetTable() { Table table = null; String[] columnNames = getColumnNames(); String[] keyNames = getKeyNames(); if (columnNames != null && columnNames.length > 0) { table = new Table(transformation.getTargetCatalogName(), transformation.getTargetSchemaName(), transformation.getTargetTableName()); for (String colName : columnNames) { Column col = new Column(colName); table.addColumn(col); if (keyNames != null) { for (String keyName : keyNames) { if (keyName.equals(colName)) { col.setPrimaryKey(true); } } } } } return table; }
Column column = new Column(tokens[i], keys != null && keys.contains(tokens[i])); table.addColumn(column);