org.dbflute.s2dao.sqlcommand.TnQueryInsertDynamicCommand Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of dbflute-runtime Show documentation
Show all versions of dbflute-runtime Show documentation
The runtime library of DBFlute
/*
* Copyright 2014-2023 the original author or authors.
*
* 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 org.dbflute.s2dao.sqlcommand;
import java.util.ArrayList;
import java.util.List;
import java.util.Set;
import javax.sql.DataSource;
import org.dbflute.Entity;
import org.dbflute.bhv.core.context.InternalMapContext;
import org.dbflute.bhv.writable.InsertOption;
import org.dbflute.bhv.writable.UpdateOption;
import org.dbflute.cbean.ConditionBean;
import org.dbflute.dbmeta.DBMeta;
import org.dbflute.dbmeta.info.ColumnInfo;
import org.dbflute.helper.StringKeyMap;
import org.dbflute.jdbc.StatementConfig;
import org.dbflute.jdbc.StatementFactory;
import org.dbflute.s2dao.metadata.TnPropertyType;
import org.dbflute.s2dao.sqlhandler.TnAbstractEntityHandler;
import org.dbflute.s2dao.sqlhandler.TnCommandContextHandler;
import org.dbflute.system.DBFluteSystem;
import org.dbflute.twowaysql.context.CommandContext;
import org.dbflute.util.Srl;
/**
* @author jflute
*/
public class TnQueryInsertDynamicCommand extends TnAbstractQueryDynamicCommand {
// ===================================================================================
// Constructor
// ===========
public TnQueryInsertDynamicCommand(DataSource dataSource, StatementFactory statementFactory) {
super(dataSource, statementFactory);
}
// ===================================================================================
// Execute
// =======
public Object execute(Object[] args) {
// analyze arguments
final Entity entity = extractEntityWithCheck(args);
final ConditionBean intoCB = extractIntoConditionBeanWithCheck(args);
final ConditionBean resourceCB = extractResourceConditionBeanWithCheck(args);
final InsertOption option = extractInsertOptionWithCheck(args);
prepareStatementConfigOnThreadIfExists(option);
// arguments for execution (not contains an option)
final String[] argNames = new String[] { "entity", "pmb" };
final Class[] argTypes = new Class[] { entity.getClass(), resourceCB.getClass() };
final Object[] realArgs = new Object[] { entity, resourceCB };
// prepare context
final List boundPropTypeList = new ArrayList();
final CommandContext context;
{
final String twoWaySql = buildQueryInsertTwoWaySql(entity, intoCB, resourceCB, option, boundPropTypeList);
context = createCommandContext(twoWaySql, argNames, argTypes, realArgs);
}
// execute
final TnCommandContextHandler handler = createCommandContextHandler(context);
handler.setExceptionMessageSqlArgs(context.getBindVariables());
final boolean identityDisabled = option != null && option.isPrimaryKeyIdentityDisabled();
if (identityDisabled) {
disableIdentityGeneration(entity);
}
final int rows;
RuntimeException sqlEx = null;
try {
rows = handler.execute(realArgs);
} catch (RuntimeException e) {
sqlEx = e;
throw e;
} finally {
if (identityDisabled) {
try {
enableIdentityGeneration(entity);
} catch (RuntimeException e) {
if (sqlEx == null) {
throw e;
}
// ignore the exception when main SQL fails
// not to close the main exception
}
}
}
return Integer.valueOf(rows);
}
// ===================================================================================
// Analyze Argument
// ================
protected Entity extractEntityWithCheck(Object[] args) {
assertArgument(args);
final Object fisrtArg = args[0];
if (!(fisrtArg instanceof Entity)) {
String msg = "The type of first argument should be " + Entity.class + ":";
msg = msg + " type=" + fisrtArg.getClass();
throw new IllegalArgumentException(msg);
}
return (Entity) fisrtArg;
}
protected ConditionBean extractIntoConditionBeanWithCheck(Object[] args) {
assertArgument(args);
final Object secondArg = args[1];
if (!(secondArg instanceof ConditionBean)) {
String msg = "The type of second argument should be " + ConditionBean.class + ":";
msg = msg + " type=" + secondArg.getClass();
throw new IllegalArgumentException(msg);
}
return (ConditionBean) secondArg;
}
protected ConditionBean extractResourceConditionBeanWithCheck(Object[] args) {
assertArgument(args);
final Object thirdArg = args[2];
if (!(thirdArg instanceof ConditionBean)) {
String msg = "The type of third argument should be " + ConditionBean.class + ":";
msg = msg + " type=" + thirdArg.getClass();
throw new IllegalArgumentException(msg);
}
return (ConditionBean) thirdArg;
}
protected InsertOption extractInsertOptionWithCheck(Object[] args) {
assertArgument(args);
if (args.length < 4) {
return null;
}
final Object fourthArg = args[3];
if (fourthArg == null) {
return null;
}
if (!(fourthArg instanceof InsertOption)) {
String msg = "The type of fourth argument should be " + UpdateOption.class + ":";
msg = msg + " type=" + fourthArg.getClass();
throw new IllegalArgumentException(msg);
}
@SuppressWarnings("unchecked")
final InsertOption option = (InsertOption) fourthArg;
return option;
}
protected void prepareStatementConfigOnThreadIfExists(InsertOption option) {
final StatementConfig config = option != null ? option.getInsertStatementConfig() : null;
if (config != null) {
InternalMapContext.setUpdateStatementConfig(config);
}
}
protected void assertArgument(Object[] args) {
if (args == null || args.length <= 1) {
String msg = "The arguments should have two argument at least! But:";
msg = msg + " args=" + (args != null ? args.length : null);
throw new IllegalArgumentException(msg);
}
}
// ===================================================================================
// Build SQL
// =========
/**
* @param entity The entity for fixed values. (NotNull)
* @param intoCB The condition-bean for insert into. (NotNull)
* @param resourceCB The condition-bean for resource. (NotNull)
* @param option The option of insert. (NullAllowed)
* @param boundPropTypeList The type list of bound property. (NotNull, Empty)
* @return The two-way SQL of query-insert. (NotNull)
*/
protected String buildQueryInsertTwoWaySql(Entity entity, ConditionBean intoCB, ConditionBean resourceCB,
InsertOption option, List boundPropTypeList) {
final StringKeyMap fixedValueQueryExpMap = StringKeyMap.createAsFlexibleOrdered();
final Set modifiedProperties = entity.mymodifiedProperties();
final DBMeta dbmeta = entity.asDBMeta();
final List columnInfoList = dbmeta.getColumnInfoList();
for (ColumnInfo columnInfo : columnInfoList) {
final String propertyName = columnInfo.getPropertyName();
if (!modifiedProperties.contains(propertyName)) {
continue;
}
final Object value = columnInfo.read(entity);
final String fixedValueQueryExp = (value != null ? "/*entity." + propertyName + "*/null" : null);
fixedValueQueryExpMap.put(columnInfo.getColumnDbName(), fixedValueQueryExp);
}
return intoCB.getSqlClause().getClauseQueryInsert(fixedValueQueryExpMap, resourceCB.getSqlClause());
}
// ===================================================================================
// Identity
// ========
protected void disableIdentityGeneration(Entity entity) {
final String tableDbName = entity.asTableDbName();
TnAbstractEntityHandler.delegateDisableIdentityGeneration(tableDbName, _dataSource, _statementFactory);
}
protected void enableIdentityGeneration(Entity entity) {
final String tableDbName = entity.asTableDbName();
TnAbstractEntityHandler.delegateEnableIdentityGeneration(tableDbName, _dataSource, _statementFactory);
}
// ===================================================================================
// Process Title
// =============
@Override
protected String getUpdateSQLFailureProcessTitle() {
return "query insert";
}
// ===================================================================================
// General Helper
// ==============
protected String replace(String text, String fromText, String toText) {
return Srl.replace(text, fromText, toText);
}
protected String ln() {
return DBFluteSystem.ln();
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy