StringBuilder createPrimaryKey(SchemaCreator.Column column) { StringBuilder b = new StringBuilder(20); b.append(column.getName()); b.append(" "); b.append(column.getDatatype().getTypeName()); b.append(" PRIMARY KEY "); return b; }
String createSql(SchemaCreator.Table table, int revision) { StringBuilder builder = new StringBuilder(); builder.append("CREATE TABLE "); builder.append(table.getName()); builder.append(" ("); builder.append(createPrimaryKey(table.getPrimaryKey())); List<SchemaCreator.Column> columns = table.getColumns(); for (SchemaCreator.Column column : columns) { if (column.getAppearedInRevision() > revision) continue; builder.append(", \n "); builder.append(column.getName()); builder.append(" "); builder.append(column.getDatatype().getTypeName()); } builder.append(" )"); return builder.toString(); }