in backup-core/src/main/java/org/apache/iotdb/backup/core/pipeline/out/sink/OutSqlFileSink.java [142:171]
public String generateSqlString(TimeSeriesRowModel timeSeriesRowModel) {
DeviceModel deviceModel = timeSeriesRowModel.getDeviceModel();
StringBuilder sql = new StringBuilder();
StringBuilder timeseries = new StringBuilder();
StringBuilder values = new StringBuilder();
sql.append(" insert into ").append(deviceModel.getDeviceName());
timeseries.append("(time");
values.append(" values (").append(timeSeriesRowModel.getTimestamp());
timeSeriesRowModel
.getIFieldList()
.forEach(
column -> {
if (column.getField() != null) {
timeseries
.append(",")
.append(column.getColumnName().replace(deviceModel.getDeviceName() + ".", ""));
values
.append(",")
.append(column.getField().getObjectValue(column.getField().getDataType()));
}
});
timeseries.append(") ");
values.append(");");
sql.append(timeseries);
if (deviceModel.isAligned()) {
sql.append(" aligned ");
}
sql.append(values).append("\r\n");
return sql.toString();
}