liquibase.statement.InsertExecutablePreparedStatement Maven / Gradle / Ivy
package liquibase.statement;
import liquibase.change.ColumnConfig;
import liquibase.changelog.ChangeSet;
import liquibase.database.Database;
import liquibase.resource.ResourceAccessor;
import java.util.List;
/**
* Handles INSERT Execution
*/
public class InsertExecutablePreparedStatement extends ExecutablePreparedStatementBase {
public InsertExecutablePreparedStatement(
Database database, String catalogName, String schemaName, String tableName, List columns,
ChangeSet changeSet, ResourceAccessor resourceAccessor) {
super(database, catalogName, schemaName, tableName, columns, changeSet, resourceAccessor);
}
@Override
public boolean continueOnError() {
return false;
}
@Override
protected String generateSql(List cols) {
StringBuilder sql = new StringBuilder("INSERT INTO ");
StringBuilder params = new StringBuilder("VALUES(");
sql.append(database.escapeTableName(getCatalogName(), getSchemaName(), getTableName()));
sql.append("(");
for(ColumnConfig column : getColumns()) {
if(database.supportsAutoIncrement()
&& Boolean.TRUE.equals(column.isAutoIncrement())) {
continue;
}
sql.append(database.escapeColumnName(getCatalogName(), getSchemaName(), getTableName(), column.getName()));
sql.append(", ");
params.append("?, ");
cols.add(column);
}
sql.deleteCharAt(sql.lastIndexOf(" "));
sql.deleteCharAt(sql.lastIndexOf(","));
params.deleteCharAt(params.lastIndexOf(" "));
params.deleteCharAt(params.lastIndexOf(","));
params.append(")");
sql.append(") ");
sql.append(params);
return sql.toString();
}
}