/* * Helper method that determines the auto increment status using Firebird's * system tables. * * @param table The table */ protected void determineAutoIncrementColumns(Connection connection, Table table) throws SQLException { Column[] columns = table.getColumns(); for (int idx = 0; idx < columns.length; idx++) { columns[idx].setAutoIncrement(isAutoIncrement(connection, table, columns[idx])); } }
public void write(CsvData data) { String sql = null; switch (data.getDataEventType()) { case UPDATE: sql = buildSql( useUpsertStatements ? DmlType.UPSERT : DmlType.UPDATE, data.getParsedData(CsvData.ROW_DATA), currentTable.getColumns()); break; case INSERT: sql = buildSql( useUpsertStatements ? DmlType.UPSERT : DmlType.INSERT, data.getParsedData(CsvData.ROW_DATA), currentTable.getColumns()); break; case DELETE: sql = buildSql( DmlType.DELETE, data.getParsedData(CsvData.PK_DATA), currentTable.getPrimaryKeyColumns()); break; case SQL: sql = data.getParsedData(CsvData.ROW_DATA)[0]; break; case CREATE: IDdlBuilder builder = DdlBuilderFactory.createDdlBuilder(targetDatabaseName); sql = builder.createTable(currentTable); break; default: break; } if (sql != null) { this.payloadMap.get(this.currentBatch).add(sql); } }
private void alterCaseToMatchLogicalCase(Table table) { table.setName(table.getName().toUpperCase()); Column[] columns = table.getColumns(); for (Column column : columns) { column.setName(column.getName().toUpperCase()); } IIndex[] indexes = table.getIndices(); for (IIndex index : indexes) { index.setName(index.getName().toUpperCase()); IndexColumn[] indexColumns = index.getColumns(); for (IndexColumn indexColumn : indexColumns) { indexColumn.setName(indexColumn.getName().toUpperCase()); } } }
public static void write(Table table, Writer output) { try { output.write("\t<table name=\"" + StringEscapeUtils.escapeXml(table.getName()) + "\">\n"); for (Column column : table.getColumns()) { output.write("\t\t<column name=\"" + StringEscapeUtils.escapeXml(column.getName()) + "\""); if (column.isPrimaryKey()) { output.write(" primaryKey=\"" + column.isPrimaryKey() + "\""); } if (column.isRequired()) { output.write(" required=\"" + column.isRequired() + "\""); } if (column.getMappedType() != null) { output.write(" type=\"" + column.getMappedType() + "\""); } if (column.getSize() != null) { output.write(" size=\"" + column.getSize() + "\""); } if (column.getDefaultValue() != null) { output.write( " default=\"" + StringEscapeUtils.escapeXml(column.getDefaultValue()) + "\""); } if (column.isAutoIncrement()) { output.write(" autoIncrement=\"" + column.isAutoIncrement() + "\""); } if (column.getJavaName() != null) { output.write(" javaName=\"" + column.getJavaName() + "\""); } if (column.getPlatformColumns() != null && column.getPlatformColumns().size() > 0) { Collection<PlatformColumn> platformColumns = column.getPlatformColumns().values(); output.write(">\n"); for (PlatformColumn platformColumn : platformColumns) { output.write("\t\t\t<platform-column name=\"" + platformColumn.getName() + "\""); output.write(" type=\"" + platformColumn.getType() + "\""); if (platformColumn.getSize() > 0) { output.write(" size=\"" + platformColumn.getSize() + "\""); } if (platformColumn.getDecimalDigits() > 0) { output.write(" decimalDigits=\"" + platformColumn.getDecimalDigits() + "\""); } if (platformColumn.getDefaultValue() != null) { output.write( " default=\"" + StringEscapeUtils.escapeXml(platformColumn.getDefaultValue()) + "\""); } output.write("/>\n"); } output.write("\t\t</column>\n"); } else { output.write("/>\n"); } } for (ForeignKey fk : table.getForeignKeys()) { output.write( "\t\t<foreign-key name=\"" + StringEscapeUtils.escapeXml(fk.getName()) + "\" foreignTable=\"" + StringEscapeUtils.escapeXml(fk.getForeignTableName()) + "\">\n"); for (Reference ref : fk.getReferences()) { output.write( "\t\t\t<reference local=\"" + StringEscapeUtils.escapeXml(ref.getLocalColumnName()) + "\" foreign=\"" + StringEscapeUtils.escapeXml(ref.getForeignColumnName()) + "\"/>\n"); } output.write("\t\t</foreign-key>\n"); } for (IIndex index : table.getIndices()) { if (index.isUnique()) { output.write( "\t\t<unique name=\"" + StringEscapeUtils.escapeXml(index.getName()) + "\">\n"); for (IndexColumn column : index.getColumns()) { output.write( "\t\t\t<unique-column name=\"" + StringEscapeUtils.escapeXml(column.getName()) + "\"/>\n"); } output.write("\t\t</unique>\n"); } else { output.write( "\t\t<index name=\"" + StringEscapeUtils.escapeXml(index.getName()) + "\">\n"); for (IndexColumn column : index.getColumns()) { output.write( "\t\t\t<index-column name=\"" + StringEscapeUtils.escapeXml(column.getName()) + "\""); if (column.getSize() != null) { output.write(" size=\"" + column.getSize() + "\""); } output.write("/>\n"); } output.write("\t\t</index>\n"); } } output.write("\t</table>\n"); } catch (IOException e) { throw new IoException(e); } }