/*
* Copyright 2011, Mysema Ltd
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
* http://www.apache.org/licenses/LICENSE-2.0
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.mysema.query.sql.dml;
import javax.annotation.Nullable;
import java.sql.*;
import java.util.*;
import com.google.common.collect.ImmutableList;
import com.google.common.collect.Maps;
import com.mysema.query.*;
import com.mysema.query.QueryFlag.Position;
import com.mysema.query.dml.StoreClause;
import com.mysema.query.sql.*;
import com.mysema.query.sql.types.Null;
import com.mysema.query.types.*;
import com.mysema.util.ResultSetAdapter;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
/**
* SQLMergeClause defines an MERGE INTO clause
*
* @author tiwe
*
*/
public class SQLMergeClause extends AbstractSQLClause<SQLMergeClause> implements StoreClause<SQLMergeClause> {
private static final Logger logger = LoggerFactory.getLogger(SQLMergeClause.class);
private final List<Path<?>> columns = new ArrayList<Path<?>>();
private final Connection connection;
private final RelationalPath<?> entity;
private final QueryMetadata metadata = new DefaultQueryMetadata();
private final List<Path<?>> keys = new ArrayList<Path<?>>();
@Nullable
private SubQueryExpression<?> subQuery;
private final List<SQLMergeBatch> batches = new ArrayList<SQLMergeBatch>();
private final List<Expression<?>> values = new ArrayList<Expression<?>>();
private transient String queryString;
private transient List<Object> constants;
public SQLMergeClause(Connection connection, SQLTemplates templates, RelationalPath<?> entity) {
this(connection, new Configuration(templates), entity);
}
public SQLMergeClause(Connection connection, Configuration configuration, RelationalPath<?> entity) {
super(configuration);
this.connection = connection;
this.entity = entity;
metadata.addJoin(JoinType.DEFAULT, entity);
}
/**
* Add the given String literal at the given position as a query flag
*
* @param position
* @param flag
* @return
*/
public SQLMergeClause addFlag(Position position, String flag) {
metadata.addFlag(new QueryFlag(position, flag));
return this;
}
/**
* Add the given Expression at the given position as a query flag
*
* @param position
* @param flag
* @return
*/
public SQLMergeClause addFlag(Position position, Expression<?> flag) {
metadata.addFlag(new QueryFlag(position, flag));
return this;
}
private List<? extends Path<?>> getKeys() {
if (!keys.isEmpty()) {
return keys;
} else if (entity.getPrimaryKey() != null) {
return entity.getPrimaryKey().getLocalColumns();
} else {
throw new IllegalStateException("No keys were defined, invoke keys(..) to add keys");
}
}
/**
* Add the current state of bindings as a batch item
*
* @return
*/
public SQLMergeClause addBatch() {
if (!configuration.getTemplates().isNativeMerge()) {
throw new IllegalStateException("batch only supported for databases that support native merge");
}
batches.add(new SQLMergeBatch(keys, columns, values, subQuery));
columns.clear();
values.clear();
keys.clear();
subQuery = null;
return this;
}
public SQLMergeClause columns(Path<?>... columns) {
this.columns.addAll(Arrays.asList(columns));
return this;
}
/**
* Execute the clause and return the generated key with the type of the given path.
* If no rows were created, null is returned, otherwise the key of the first row is returned.
*
* @param <T>
* @param path
* @return
*/
@SuppressWarnings("unchecked")
@Nullable
public <T> T executeWithKey(Path<T> path) {
return executeWithKey((Class<T>)path.getType(), path);
}
/**
* Execute the clause and return the generated key cast to the given type.
* If no rows were created, null is returned, otherwise the key of the first row is returned.
*
* @param <T>
* @param type
* @return
*/
public <T> T executeWithKey(Class<T> type) {
return executeWithKey(type, null);
}
private <T> T executeWithKey(Class<T> type, @Nullable Path<T> path) {
ResultSet rs = executeWithKeys();
try{
if (rs.next()) {
return configuration.get(rs, path, 1, type);
} else {
return null;
}
} catch (SQLException e) {
throw configuration.translate(e);
}finally{
close(rs);
}
}
/**
* Execute the clause and return the generated key with the type of the given path.
* If no rows were created, or the referenced column is not a generated key, null is returned.
* Otherwise, the key of the first row is returned.
*
* @param <T>
* @param path
* @return
*/
@SuppressWarnings("unchecked")
public <T> List<T> executeWithKeys(Path<T> path) {
return executeWithKeys((Class<T>)path.getType(), path);
}
public <T> List<T> executeWithKeys(Class<T> type) {
return executeWithKeys(type, null);
}
private <T> List<T> executeWithKeys(Class<T> type, @Nullable Path<T> path) {
ResultSet rs = executeWithKeys();
try{
List<T> rv = new ArrayList<T>();
while (rs.next()) {
rv.add(configuration.get(rs, path, 1, type));
}
return rv;
} catch (SQLException e) {
throw configuration.translate(e);
}finally{
close(rs);
}
}
/**
* Execute the clause and return the generated keys as a ResultSet
*
* @return
*/
public ResultSet executeWithKeys() {
context = startContext(connection, metadata, entity);
try {
if (configuration.getTemplates().isNativeMerge()) {
PreparedStatement stmt = null;
if (batches.isEmpty()) {
stmt = createStatement(true);
listeners.notifyMerge(entity, metadata, keys, columns, values, subQuery);
listeners.preExecute(context);
stmt.executeUpdate();
listeners.executed(context);
} else {
Collection<PreparedStatement> stmts = createStatements(true);
if (stmts != null && stmts.size() > 1) {
throw new IllegalStateException("executeWithKeys called with batch statement and multiple SQL strings");
}
stmt = stmts.iterator().next();
listeners.notifyMerges(entity, metadata, batches);
listeners.preExecute(context);
stmt.executeBatch();
listeners.executed(context);
}
final Statement stmt2 = stmt;
ResultSet rs = stmt.getGeneratedKeys();
return new ResultSetAdapter(rs) {
@Override
public void close() throws SQLException {
try {
super.close();
} finally {
stmt2.close();
}
}
};
} else {
if (hasRow()) {
// update
SQLUpdateClause update = new SQLUpdateClause(connection, configuration, entity);
populate(update);
addKeyConditions(update);
return EmptyResultSet.DEFAULT;
} else {
// insert
SQLInsertClause insert = new SQLInsertClause(connection, configuration, entity);
populate(insert);
return insert.executeWithKeys();
}
}
} catch (SQLException e) {
onException(context,e);
throw configuration.translate(queryString, constants, e);
} finally {
endContext(context);
}
}
@Override
public long execute() {
if (configuration.getTemplates().isNativeMerge()) {
return executeNativeMerge();
} else {
return executeCompositeMerge();
}
}
@Override
public List<SQLBindings> getSQL() {
if (batches.isEmpty()) {
SQLSerializer serializer = createSerializer();
serializer.serializeMerge(metadata, entity, keys, columns, values, subQuery);
return ImmutableList.of(createBindings(metadata, serializer));
} else {
ImmutableList.Builder<SQLBindings> builder = ImmutableList.builder();
for (SQLMergeBatch batch : batches) {
SQLSerializer serializer = createSerializer();
serializer.serializeMerge(metadata, entity, batch.getKeys(), batch.getColumns(), batch.getValues(), batch.getSubQuery());
builder.add(createBindings(metadata, serializer));
}
return builder.build();
}
}
private boolean hasRow() {
SQLQuery query = new SQLQuery(connection, configuration).from(entity);
addKeyConditions(query);
return query.exists();
}
private void addKeyConditions(FilteredClause query) {
List<? extends Path<?>> keys = getKeys();
for (int i=0; i < columns.size(); i++) {
if (keys.contains(columns.get(i))) {
if (values.get(i) instanceof NullExpression) {
query.where(ExpressionUtils.isNull(columns.get(i)));
} else {
query.where(ExpressionUtils.eq(columns.get(i),(Expression)values.get(i)));
}
}
}
}
@SuppressWarnings("unchecked")
private long executeCompositeMerge() {
if (hasRow()) {
// update
SQLUpdateClause update = new SQLUpdateClause(connection, configuration, entity);
populate(update);
addKeyConditions(update);
return update.execute();
} else {
// insert
SQLInsertClause insert = new SQLInsertClause(connection, configuration, entity);
populate(insert);
return insert.execute();
}
}
@SuppressWarnings("unchecked")
private void populate(StoreClause<?> clause) {
for (int i = 0; i < columns.size(); i++) {
clause.set((Path)columns.get(i), (Object)values.get(i));
}
}
private PreparedStatement createStatement(boolean withKeys) throws SQLException {
listeners.preRender(context);
SQLSerializer serializer = createSerializer();
PreparedStatement stmt = null;
if (batches.isEmpty()) {
serializer.serializeMerge(metadata, entity, keys, columns, values, subQuery);
context.addSQL(serializer.toString());
listeners.rendered(context);
listeners.prePrepare(context);
stmt = prepareStatementAndSetParameters(serializer, withKeys);
context.addPreparedStatement(stmt);
listeners.prepared(context);
} else {
serializer.serializeMerge(metadata, entity,
batches.get(0).getKeys(), batches.get(0).getColumns(),
batches.get(0).getValues(), batches.get(0).getSubQuery());
context.addSQL(serializer.toString());
listeners.rendered(context);
stmt = prepareStatementAndSetParameters(serializer, withKeys);
// add first batch
stmt.addBatch();
// add other batches
for (int i = 1; i < batches.size(); i++) {
SQLMergeBatch batch = batches.get(i);
listeners.preRender(context);
serializer = createSerializer();
serializer.serializeMerge(metadata, entity, batch.getKeys(), batch.getColumns(), batch.getValues(), batch.getSubQuery());
context.addSQL(serializer.toString());
listeners.rendered(context);
setParameters(stmt, serializer.getConstants(), serializer.getConstantPaths(), metadata.getParams());
stmt.addBatch();
}
}
return stmt;
}
private Collection<PreparedStatement> createStatements(boolean withKeys) throws SQLException {
Map<String, PreparedStatement> stmts = Maps.newHashMap();
// add first batch
listeners.preRender(context);
SQLSerializer serializer = createSerializer();
serializer.serializeMerge(metadata, entity,
batches.get(0).getKeys(), batches.get(0).getColumns(),
batches.get(0).getValues(), batches.get(0).getSubQuery());
context.addSQL(serializer.toString());
listeners.rendered(context);
PreparedStatement stmt = prepareStatementAndSetParameters(serializer, withKeys);
stmts.put(serializer.toString(), stmt);
stmt.addBatch();
// add other batches
for (int i = 1; i < batches.size(); i++) {
SQLMergeBatch batch = batches.get(i);
serializer = createSerializer();
serializer.serializeMerge(metadata, entity,
batch.getKeys(), batch.getColumns(), batch.getValues(), batch.getSubQuery());
stmt = stmts.get(serializer.toString());
if (stmt == null) {
stmt = prepareStatementAndSetParameters(serializer, withKeys);
stmts.put(serializer.toString(), stmt);
} else {
setParameters(stmt, serializer.getConstants(), serializer.getConstantPaths(), metadata.getParams());
}
stmt.addBatch();
}
return stmts.values();
}
private PreparedStatement prepareStatementAndSetParameters(SQLSerializer serializer,
boolean withKeys) throws SQLException {
listeners.prePrepare(context);
queryString = serializer.toString();
constants = serializer.getConstants();
logger.debug(queryString);
PreparedStatement stmt;
if (withKeys) {
String[] target = new String[keys.size()];
for (int i = 0; i < target.length; i++) {
target[i] = ColumnMetadata.getName(getKeys().get(i));
}
stmt = connection.prepareStatement(queryString, target);
} else {
stmt = connection.prepareStatement(queryString);
}
setParameters(stmt, serializer.getConstants(), serializer.getConstantPaths(), metadata.getParams());
context.addPreparedStatement(stmt);
listeners.prepared(context);
return stmt;
}
private long executeNativeMerge() {
context = startContext(connection, metadata, entity);
PreparedStatement stmt = null;
Collection<PreparedStatement> stmts = null;
try {
if (batches.isEmpty()) {
stmt = createStatement(false);
listeners.notifyMerge(entity, metadata, keys, columns, values, subQuery);
listeners.preExecute(context);
int rc = stmt.executeUpdate();
listeners.executed(context);
return rc;
} else {
stmts = createStatements(false);
listeners.notifyMerges(entity, metadata, batches);
listeners.preExecute(context);
long rc = executeBatch(stmts);
listeners.executed(context);
return rc;
}
} catch (SQLException e) {
onException(context,e);
throw configuration.translate(queryString, constants, e);
} finally {
if (stmt != null) {
close(stmt);
}
if (stmts != null) {
close(stmts);
}
endContext(context);
}
}
/**
* Set the keys to be used in the MERGE clause
*
* @param paths
* @return
*/
public SQLMergeClause keys(Path<?>... paths) {
for (Path<?> path : paths) {
keys.add(path);
}
return this;
}
public SQLMergeClause select(SubQueryExpression<?> subQuery) {
this.subQuery = subQuery;
return this;
}
@Override
public <T> SQLMergeClause set(Path<T> path, @Nullable T value) {
columns.add(path);
if (value != null) {
values.add(ConstantImpl.create(value));
} else {
values.add(Null.CONSTANT);
}
return this;
}
@Override
public <T> SQLMergeClause set(Path<T> path, Expression<? extends T> expression) {
columns.add(path);
values.add(expression);
return this;
}
@Override
public <T> SQLMergeClause setNull(Path<T> path) {
columns.add(path);
values.add(Null.CONSTANT);
return this;
}
@Override
public String toString() {
SQLSerializer serializer = createSerializer();
serializer.serializeMerge(metadata, entity, keys, columns, values, subQuery);
return serializer.toString();
}
public SQLMergeClause values(Object... v) {
for (Object value : v) {
if (value instanceof Expression<?>) {
values.add((Expression<?>) value);
} else if (value != null) {
values.add(ConstantImpl.create(value));
} else {
values.add(Null.CONSTANT);
}
}
return this;
}
@Override
public boolean isEmpty() {
return values.isEmpty();
}
}