LoadDataRowBuilder(EntityInfo entityInfo) { this.columns = entityInfo.getColumns(); }
public void addColumnNames() { sb.append("("); List<ColumnInfo> columns = entityInfo.getColumns(); sb.append(columns.stream().map(ColumnInfo::getColumnName) .map(this::scapeName).collect(Collectors.joining(", "))); sb.append(")"); }
public ColumnInfo findColumn(String columnName) { return entityInfo.getColumns().stream().filter(c -> c.getColumnName().equals(columnName)).findFirst().get(); }
public CsvWriter(CsvConfiguration<T> config) { this.config = config; this.typeSerializer = config.getTypeSerializer(); this.columns = getEntityInfo(config).getColumns(); this.csvEscaper = new CsvEscaper(config); this.emptyText = Character.toString(config.getTextDelimiter()) + config.getTextDelimiter(); }
@Override public String createTableSentence(EntityInfo entityInfo) { StringBuilder sb = new StringBuilder("CREATE TABLE "); sb.append(entityInfo.getTableName()); sb.append(" ("); List<ColumnInfo> columns = entityInfo.getColumns(); for (int i = 0; i < columns.size(); i++) { ColumnInfo columnInfo = columns.get(i); String dbType = getDbType(columnInfo.getFieldType()); if (dbType == null) { throw new RuntimeException("Type not found for " + columnInfo.getFieldType().getFieldType().name()); } sb.append(columnInfo.getColumnName()).append(" "); sb.append(dbType); if (columnInfo.getFieldType().isPrimitive()) { sb.append(" NOT NULL"); } if (i < columns.size() - 1) { sb.append(", "); } } sb.append(getPrimaryKey(columns)); sb.append(")"); return sb.toString(); }
@Override public String createTableSentence(EntityInfo entityInfo) { StringBuilder sb = new StringBuilder("CREATE TABLE "); sb.append(scapeName(entityInfo.getTableName())); sb.append(" ("); List<ColumnInfo> columns = entityInfo.getColumns(); for (int i = 0; i < columns.size(); i++) { ColumnInfo columnInfo = columns.get(i); String dbType = getDbType(columnInfo.getFieldType()); if (dbType == null) { throw new RuntimeException("Type not found for " + columnInfo.getFieldType().getFieldType().name()); } sb.append(scapeName(columnInfo.getColumnName())).append(" "); sb.append(dbType); if (columnInfo.getFieldType().isPrimitive()) { sb.append(" NOT NULL"); } sb.append(getAutoIncrement(columnInfo)); if (i < columns.size() - 1) { sb.append(", "); } } sb.append(getPrimaryKey(columns)); sb.append(") DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci"); return sb.toString(); }