org.dbflute.cbean.sqlclause.AbstractSqlClause 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-2021 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.cbean.sqlclause;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.LinkedHashSet;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;
import java.util.StringTokenizer;
import org.dbflute.cbean.ConditionBean;
import org.dbflute.cbean.chelper.HpCBPurpose;
import org.dbflute.cbean.chelper.HpCalcSpecification;
import org.dbflute.cbean.chelper.HpDerivingSubQueryInfo;
import org.dbflute.cbean.chelper.HpFixedConditionQueryResolver;
import org.dbflute.cbean.chelper.HpInvalidQueryInfo;
import org.dbflute.cbean.cipher.ColumnFunctionCipher;
import org.dbflute.cbean.cipher.GearedCipherManager;
import org.dbflute.cbean.ckey.ConditionKey;
import org.dbflute.cbean.coption.ConditionOption;
import org.dbflute.cbean.coption.LikeSearchOption;
import org.dbflute.cbean.coption.ScalarSelectOption;
import org.dbflute.cbean.cvalue.ConditionValue;
import org.dbflute.cbean.cvalue.ConditionValue.QueryModeProvider;
import org.dbflute.cbean.dream.SpecifiedColumn;
import org.dbflute.cbean.ordering.ManualOrderOption;
import org.dbflute.cbean.sqlclause.clause.ClauseLazyReflector;
import org.dbflute.cbean.sqlclause.clause.SelectClauseType;
import org.dbflute.cbean.sqlclause.join.FixedConditionLazyChecker;
import org.dbflute.cbean.sqlclause.join.FixedConditionResolver;
import org.dbflute.cbean.sqlclause.join.InnerJoinLazyReflector;
import org.dbflute.cbean.sqlclause.join.InnerJoinLazyReflectorBase;
import org.dbflute.cbean.sqlclause.join.LeftOuterJoinInfo;
import org.dbflute.cbean.sqlclause.orderby.OrderByClause;
import org.dbflute.cbean.sqlclause.orderby.OrderByElement;
import org.dbflute.cbean.sqlclause.query.OrScopeQueryAndPartQueryClause;
import org.dbflute.cbean.sqlclause.query.OrScopeQueryInfo;
import org.dbflute.cbean.sqlclause.query.OrScopeQueryReflector;
import org.dbflute.cbean.sqlclause.query.QueryClause;
import org.dbflute.cbean.sqlclause.query.QueryClauseFilter;
import org.dbflute.cbean.sqlclause.query.QueryUsedAliasInfo;
import org.dbflute.cbean.sqlclause.query.StringQueryClause;
import org.dbflute.cbean.sqlclause.select.SelectedRelationColumn;
import org.dbflute.cbean.sqlclause.select.SpecifiedSelectColumnHandler;
import org.dbflute.cbean.sqlclause.subquery.SubQueryIndentProcessor;
import org.dbflute.cbean.sqlclause.union.UnionClauseProvider;
import org.dbflute.dbmeta.DBMeta;
import org.dbflute.dbmeta.DBMetaProvider;
import org.dbflute.dbmeta.info.ColumnInfo;
import org.dbflute.dbmeta.info.ForeignInfo;
import org.dbflute.dbmeta.name.ColumnRealName;
import org.dbflute.dbmeta.name.ColumnSqlName;
import org.dbflute.dbmeta.name.TableSqlName;
import org.dbflute.dbway.DBWay;
import org.dbflute.exception.IllegalConditionBeanOperationException;
import org.dbflute.helper.StringKeyMap;
import org.dbflute.helper.message.ExceptionMessageBuilder;
import org.dbflute.system.DBFluteSystem;
import org.dbflute.util.DfAssertUtil;
import org.dbflute.util.DfCollectionUtil;
import org.dbflute.util.Srl;
/**
* The abstract class of SQL clause.
* @author jflute
*/
public abstract class AbstractSqlClause implements SqlClause, Serializable {
// ===================================================================================
// Definition
// ==========
/** The serial version UID for object serialization. (Default) */
private static final long serialVersionUID = 1L; // but serializing is already bankrupt
protected static final SelectClauseType DEFAULT_SELECT_CLAUSE_TYPE = SelectClauseType.COLUMNS;
protected static final String SELECT_HINT = "/*$pmb.selectHint*/";
// ===================================================================================
// Attribute
// =========
// -----------------------------------------------------
// Basic
// -----
/** The DB name of table. */
protected final String _tableDbName;
/** The DB meta of table. (basically NotNull: null only when treated as dummy) */
protected DBMeta _dbmeta;
/** The DB meta of target table. (basically NotNull: null only when treated as dummy) */
protected DBMetaProvider _dbmetaProvider;
/** The cache map of DB meta for basically related tables. */
protected Map _cachedDBMetaMap;
/** The hierarchy level of sub-query. (NotMinus: if zero, not for sub-query) */
protected int _subQueryLevel;
// -----------------------------------------------------
// Clause Resource
// ---------------
// /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
// The resources that are not frequently used to are lazy-loaded for performance.
// - - - - - - - - - -/
/**
* The basic map of selected relation. (NullAllowed: lazy-loaded)
* map:{foreignRelationPath: relationNoSuffix = foreignPropertyName}
*/
protected Map _selectedRelationBasicMap;
/**
* The path-to-alias map of selected relation. (NullAllowed: lazy-loaded)
* map:{foreignRelationPath: relationNoSuffix = foreignTableAliasName}
*/
protected Map _selectedRelationPathToTableAliasMap;
/**
* The column map of selected relation. (NullAllowed: lazy-loaded)
* map:{foreignTableAliasName = map:{columnName = selectedRelationColumn}}
*/
protected Map> _selectedRelationColumnMap;
/** The set of relation connecting to selected next relation. (NulAllowed: lazy-loaded) */
protected Set _selectedNextConnectingRelationSet;
/**
* Specified select column map. (NullAllowed: lazy-loaded)
* map:{tableAliasName = map:{ columnName = specifiedInfo}}
*/
protected Map> _specifiedSelectColumnMap; // [DBFlute-0.7.4]
/**
* Specified select column map for backup. (NullAllowed: lazy-loaded)
* map:{tableAliasName = map:{ columnName = specifiedInfo}}
*/
protected Map> _backupSpecifiedSelectColumnMap; // [DBFlute-0.9.5.3]
/** Specified derive sub-query map. A null key is acceptable. (NullAllowed: lazy-load) */
protected Map _specifiedDerivingSubQueryMap; // [DBFlute-0.7.4]
/** The map of real column and alias of select clause. map:{realColumnName : aliasName} (NullAllowed: lazy-load) */
protected Map _selectClauseRealColumnAliasMap;
/** The type of select clause. (NotNull) */
protected SelectClauseType _selectClauseType = DEFAULT_SELECT_CLAUSE_TYPE;
/** The previous type of select clause. (NullAllowed: The default is null) */
protected SelectClauseType _previousSelectClauseType;
/**
* The map of select index by key name of select column. (NullAllowed: lazy-load or no use select index)
* map:{entityNo(e.g. loc00 or _0_3) = map:{selectColumnKeyName = selectIndex}}
*/
protected Map> _selectIndexMap;
/**
* The map of key name of select column by on-query name. (NullAllowed: lazy-load or no use select index)
* map:{onQueryAlias = selectColumnKeyName}}
*/
protected Map _selectColumnKeyNameMap;
/** Is use select index? Default value is true. */
protected boolean _useSelectIndex = true;
/** The limit size of alias name to adjust alias length on query. */
protected int _aliasNameLimitSize = getDefaultAliasNameLimitSize();
/**
* The map of left-outer-join info. (NullAllowed: lazy-load)
* map:{foreignAliasName : leftOuterJoinInfo}
*/
protected Map _outerJoinMap;
/**
* The map of relationPath and foreignAliasName. (NullAllowed: lazy-load)
* map:{relationPath : foreignAliasName}
*/
protected Map _relationPathForeignAliasMap;
/** The list of lazy checker for fixed-condition e.g. dynamic parameters. (NullAllowed: lazy-load) */
protected List _fixedConditionLazyChecker;
/** Does it allow to auto-detect joins that can be structural-possible inner-join? */
protected boolean _structuralPossibleInnerJoinEnabled;
/** Does it allow to auto-detect joins that can be where-used inner-join? */
protected boolean _whereUsedInnerJoinEnabled;
/** The list of lazy reflector for auto-detected inner-join. (NullAllowed: lazy-load) */
protected List _innerJoinLazyReflector;
/** The list of where clause. (NullAllowed: lazy-load) */
protected List _whereList;
/** The backup list of where clause. (NullAllowed: lazy-load) */
protected List _backupWhereList;
/** The list of in-line where clause for base table. (NullAllowed: lazy-load) */
protected List _baseTableInlineWhereList;
/** The clause of order-by. (NotNull) */
protected OrderByClause _orderByClause;
/** The list of union clause. (NullAllowed: lazy-loaded) (NullAllowed: lazy-load) */
protected List _unionQueryInfoList;
/** Is order-by effective? Default value is false. True when registered. */
protected boolean _orderByEffective;
// -----------------------------------------------------
// Fetch Property
// --------------
/** Fetch start index. (for fetchXxx()) */
protected int _fetchStartIndex = 0;
/** Fetch size. (for fetchXxx()) */
protected int _fetchSize = 0;
/** Fetch page number. (for fetchXxx()) This value should be plus. */
protected int _fetchPageNumber = 1;
/** Is fetch-narrowing effective? Default value is false but true when registered. */
protected boolean _fetchScopeEffective;
// -----------------------------------------------------
// OrScopeQuery
// ------------
/** Is or-scope query effective? */
protected boolean _orScopeQueryEffective;
/** The current temporary information of or-scope query?*/
protected OrScopeQueryInfo _currentTmpOrScopeQueryInfo;
/** Is or-scope query in and-part?*/
protected boolean _orScopeQueryAndPartEffective;
/** The identity for and-part of or-scope query */
protected int _orScopeQueryAndPartIdentity;
// -----------------------------------------------------
// SubQuery Indent
// ---------------
/** The processor for sub-query indent. */
protected SubQueryIndentProcessor _subQueryIndentProcessor;
// -----------------------------------------------------
// Invalid Query Info
// ------------------
/** Does it check an invalid query? (save-only attribute) */
protected boolean _nullOrEmptyChecked;
/** The list of invalid query info. (NullAllowed: lazy-load) (save-only attribute) */
protected List _invalidQueryList;
/** Does it accept an empty string for query? (save-only attribute) */
protected boolean _emptyStringQueryAllowed;
/** Does it allow overriding query? (save-only attribute) */
protected boolean _overridingQueryAllowed;
// -----------------------------------------------------
// WhereClauseSimpleFilter
// -----------------------
/** The filter for where clause. (NullAllowed: lazy-load) */
protected transient List _whereClauseSimpleFilterList; // transient because of non-serializable
// -----------------------------------------------------
// ColumnQuery Object
// ------------------
/** The map for column query objects. (only for saving) (NullAllowed: lazy-load) */
protected Map _columyQueryObjectMap;
// -----------------------------------------------------
// ManualOrder Parameter
// ---------------------
/** The map for ManualOrder parameters. (only for saving) (NullAllowed: lazy-load) */
protected Map _manualOrderParameterMap;
// -----------------------------------------------------
// Free Parameter
// --------------
/** The map for free parameters. (only for saving) (NullAllowed: lazy-load) */
protected Map _freeParameterMap;
// -----------------------------------------------------
// Geared Cipher
// -------------
/** The manager of geared cipher. (also for saving) (NullAllowed: lazy-load) */
protected GearedCipherManager _gearedCipherManager;
/** Does it use cipher for select columns? (true if cipher manager is set) */
protected boolean _selectColumnCipherEffective;
// -----------------------------------------------------
// Scalar Select
// -------------
/** The option for ScalarSelect. */
protected ScalarSelectOption _scalarSelectOption;
// -----------------------------------------------------
// Paging Select
// -------------
/** Is the clause for paging select? (save-only attribute) */
protected boolean _pagingAdjustmentEnabled;
/** Is the joins of count least? (save-only attribute) */
protected boolean _pagingCountLeastJoinEnabled;
/** Is the count executed later? (save-only attribute) */
protected boolean _pagingCountLaterEnabled;
/** Does it forcedly select only primary key? (basically for paging select and query split) */
protected boolean _pkOnlySelectForcedlyEnabled;
// -----------------------------------------------------
// Query Update
// ------------
/** Does it allowed to use in-scope clause in query update? */
protected boolean _queryUpdateForcedDirectEffective;
// -----------------------------------------------------
// Purpose Type
// ------------
/** The purpose of condition-bean for check at condition-query. (NotNull) (save-only attribute) */
protected HpCBPurpose _purpose = HpCBPurpose.NORMAL_USE; // as default
/** Is the clause object locked? e.g. true if in sub-query process. (save-only attribute) */
protected boolean _locked;
/** Does it allow "that's bad timing" check? (save-only attribute) */
protected boolean _thatsBadTimingDetectEffective;
// -----------------------------------------------------
// Lazy Reflector
// --------------
/** The list of lazy reflector for clause. (NullAllowed: lazy-load) */
protected List _clauseLazyReflectorList;
// -----------------------------------------------------
// ExistsReferrer Way
// ------------------
/** Does it use in-scope sub-query for exists-referrer? (save-only attribute) */
protected boolean _useInScopeSubQueryForExistsReferrer;
// -----------------------------------------------------
// Column NullObject
// -----------------
/** Does it allow the handling of column null object? */
protected boolean _columnNullObjectAllowed;
/** Is column null object geared to specify? */
protected boolean _columnNullObjectGearedToSpecify;
/** The map of specified column null object. map:{ alias-name = set:{ column-info } } (NullAllowed: lazy-loaded) */
protected Map> _columnNullObjectSpecifiedMap;
// -----------------------------------------------------
// Date-time Precision
// -------------------
/** Does it truncate date-time precision of condition value? */
protected boolean _datetimePrecisionTruncationOfCondition;
// -----------------------------------------------------
// Dynamic Hint
// ------------
/** The hint expression of from-base-table as dynamic. (NullAllowed: option) */
protected String _dynamicHintFromBaseTable;
// ===================================================================================
// Constructor
// ===========
/**
* Constructor.
* @param tableDbName The DB name of table. (NotNull)
**/
public AbstractSqlClause(String tableDbName) {
if (tableDbName == null) {
String msg = "The argument 'tableDbName' should not be null.";
throw new IllegalArgumentException(msg);
}
_tableDbName = tableDbName;
}
/**
* Set the provider of DB meta.
* If you want to use all functions, this method is required.
* @param dbmetaProvider The provider of DB meta. (NotNull)
* @return this. (NotNull)
*/
public AbstractSqlClause dbmetaProvider(DBMetaProvider dbmetaProvider) {
if (dbmetaProvider == null) {
String msg = "The argument 'dbmetaProvider' should not be null: tableDbName=" + _tableDbName;
throw new IllegalArgumentException(msg);
}
_dbmetaProvider = dbmetaProvider;
_dbmeta = findDBMeta(_tableDbName);
return this;
}
/**
* Set the manager of geared cipher.
* And enable cipher of select column.
* @param manager The manager of geared cipher. (NullAllowed)
* @return this. (NotNull)
*/
public AbstractSqlClause cipherManager(GearedCipherManager manager) {
_gearedCipherManager = manager;
_selectColumnCipherEffective = true;
return this;
}
// ===================================================================================
// SubQuery Level
// ==============
/**
* {@inheritDoc}
*/
public int getSubQueryLevel() {
return _subQueryLevel;
}
/**
* {@inheritDoc}
*/
public void setupForSubQuery(int subQueryLevel) {
_subQueryLevel = subQueryLevel;
}
/**
* {@inheritDoc}
*/
public boolean isForSubQuery() {
return _subQueryLevel > 0;
}
// ===================================================================================
// Whole Clause
// ============
// -----------------------------------------------------
// Complete Clause
// ---------------
public String getClause() {
reflectClauseLazilyIfExists();
final StringBuilder sb = new StringBuilder(512);
final String selectClause = getSelectClause();
sb.append(selectClause);
buildClauseWithoutMainSelect(sb, selectClause);
String sql = sb.toString();
sql = filterEnclosingClause(sql);
sql = processSubQueryIndent(sql);
return sql;
}
protected void buildClauseWithoutMainSelect(StringBuilder sb, String selectClause) {
buildFromClause(sb);
sb.append(getFromHint());
buildWhereClause(sb);
sb.append(deleteUnionWhereTemplateMark(prepareUnionClause(selectClause)));
if (!needsUnionNormalSelectEnclosing()) {
sb.append(prepareClauseOrderBy());
sb.append(prepareClauseSqlSuffix());
}
}
protected String deleteUnionWhereTemplateMark(String unionClause) {
if (unionClause != null && unionClause.trim().length() > 0) {
unionClause = replace(unionClause, getUnionWhereClauseMark(), "");
unionClause = replace(unionClause, getUnionWhereFirstConditionMark(), "");
}
return unionClause;
}
// -----------------------------------------------------
// Fragment Clause
// ---------------
public String getClauseFromWhereWithUnionTemplate() {
reflectClauseLazilyIfExists();
return buildClauseFromWhereAsTemplate(false);
}
public String getClauseFromWhereWithWhereUnionTemplate() {
reflectClauseLazilyIfExists();
return buildClauseFromWhereAsTemplate(true);
}
protected String buildClauseFromWhereAsTemplate(boolean template) {
final StringBuilder sb = new StringBuilder(256);
buildFromClause(sb);
sb.append(getFromHint());
buildWhereClause(sb, template);
sb.append(prepareUnionClause(getUnionSelectClauseMark()));
return sb.toString();
}
protected String prepareUnionClause(String selectClause) {
if (!hasUnionQuery()) {
return "";
}
final StringBuilder sb = new StringBuilder();
for (UnionQueryInfo unionQueryInfo : _unionQueryInfoList) {
final UnionClauseProvider unionClauseProvider = unionQueryInfo.getUnionClauseProvider();
final String unionQueryClause = unionClauseProvider.provide();
final boolean unionAll = unionQueryInfo.isUnionAll();
sb.append(ln()).append(unionAll ? " union all " : " union ").append(ln());
sb.append(selectClause).append(" ").append(unionQueryClause);
}
return sb.toString();
}
protected String prepareClauseOrderBy() {
if (!_orderByEffective || !hasOrderByClause()) {
return "";
}
final StringBuilder sb = new StringBuilder();
sb.append(" ");
sb.append(getOrderByClause());
return sb.toString();
}
protected String prepareClauseSqlSuffix() {
final String sqlSuffix = getSqlSuffix();
if (sqlSuffix == null || sqlSuffix.trim().length() == 0) {
return "";
}
final StringBuilder sb = new StringBuilder();
sb.append(" ");
sb.append(sqlSuffix);
return sb.toString();
}
protected String filterEnclosingClause(String sql) {
sql = filterUnionNormalSelectEnclosing(sql);
sql = filterUnionCountOrScalarEnclosing(sql);
return sql;
}
protected String filterUnionNormalSelectEnclosing(String sql) {
if (!needsUnionNormalSelectEnclosing()) {
return sql;
}
final String selectClause = "select" + SELECT_HINT + " *";
final String inlineViewAlias = getUnionQueryInlineViewAlias();
final String beginMark = resolveSubQueryBeginMark(inlineViewAlias) + ln();
final String endMark = resolveSubQueryEndMark(inlineViewAlias);
final StringBuilder sb = new StringBuilder();
sb.append(selectClause).append(ln());
sb.append(" from (").append(beginMark).append(sql).append(ln()).append(" ) ");
sb.append(inlineViewAlias).append(endMark);
sb.append(prepareClauseOrderBy()).append(prepareClauseSqlSuffix());
return sb.toString();
}
protected String filterUnionCountOrScalarEnclosing(String sql) {
if (!needsUnionCountOrScalarEnclosing()) {
return sql;
}
final String inlineViewAlias = getUnionQueryInlineViewAlias();
final String selectClause = buildSelectClauseScalar(inlineViewAlias);
final String beginMark = resolveSubQueryBeginMark(inlineViewAlias) + ln();
final String endMark = resolveSubQueryEndMark(inlineViewAlias);
final StringBuilder sb = new StringBuilder();
sb.append(selectClause).append(ln());
sb.append(" from (").append(beginMark).append(sql).append(ln()).append(" ) ");
sb.append(inlineViewAlias).append(endMark);
return sb.toString();
}
protected boolean needsUnionNormalSelectEnclosing() {
if (!isUnionNormalSelectEnclosingRequired()) {
return false;
}
return hasUnionQuery() && !isSelectClauseTypeScalar();
}
protected boolean isUnionNormalSelectEnclosingRequired() { // for extension
return false; // false as default
}
protected boolean needsUnionCountOrScalarEnclosing() {
return hasUnionQuery() && isSelectClauseTypeScalar();
}
// ===================================================================================
// Select Clause
// =============
// Clause Parts
public String getSelectClause() {
reflectClauseLazilyIfExists();
if (isSelectClauseNonUnionScalar()) {
final String specifiedColumnTableAliasName = getSpecifiedColumnTableAliasNameAsOne(); // not null here
return buildSelectClauseScalar(specifiedColumnTableAliasName);
}
// if it's a scalar-select, it always has union-query since here
final StringBuilder sb = new StringBuilder();
clearSelectIndex(); // suppress duplicate registration
int selectIndex = processSelectClauseLocal(sb); // inherit select index incremented
selectIndex = processSelectClauseRelation(sb, selectIndex);
processSelectClauseDerivedReferrer(sb, selectIndex);
return sb.toString();
}
protected int processSelectClauseLocal(StringBuilder sb) {
final String basePointAliasName = getBasePointAliasName();
final DBMeta dbmeta = getDBMeta();
final Map localSpecifiedMap;
if (_specifiedSelectColumnMap != null) {
localSpecifiedMap = _specifiedSelectColumnMap.get(basePointAliasName);
} else {
localSpecifiedMap = null;
}
final List columnInfoList;
final boolean validSpecifiedLocal;
final boolean selectClauseTypeUniqueScalar = isSelectClauseTypeUniqueScalar();
ColumnInfo specifiedUniqueScalarColumnInfo = null; // unique scalar, has PK, specified scalar, specified column
if (selectClauseTypeUniqueScalar) {
// it always has union-query because it's handled before this process
if (dbmeta.hasPrimaryKey()) {
columnInfoList = new ArrayList();
columnInfoList.addAll(dbmeta.getPrimaryInfo().getPrimaryColumnList());
if (isSelectClauseTypeSpecifiedScalar()) {
final ColumnInfo specifiedColumn = getSpecifiedColumnInfoAsOne();
if (specifiedColumn != null && !specifiedColumn.isPrimary()) {
specifiedUniqueScalarColumnInfo = specifiedColumn;
columnInfoList.add(specifiedColumn);
}
// derivingSubQuery is handled after this process
}
} else {
// all columns are target if no-PK and unique-scalar and union-query
columnInfoList = dbmeta.getColumnInfoList();
}
validSpecifiedLocal = false; // because specified columns are fixed here
} else {
columnInfoList = dbmeta.getColumnInfoList();
validSpecifiedLocal = localSpecifiedMap != null && !localSpecifiedMap.isEmpty();
}
int selectIndex = 0; // because 1 origin in JDBC
boolean needsDelimiter = false;
for (ColumnInfo columnInfo : columnInfoList) {
final String columnDbName = columnInfo.getColumnDbName();
final ColumnSqlName columnSqlName = columnInfo.getColumnSqlName();
if (_pkOnlySelectForcedlyEnabled && !columnInfo.isPrimary()) {
continue;
}
if (validSpecifiedLocal && !localSpecifiedMap.containsKey(columnDbName)) {
continue; // a case for scalar-select has been already resolved here
}
if (canBeNullObjectSpecifiedColumn(columnInfo)) {
registerColumnNullObject(basePointAliasName, columnInfo);
continue;
}
if (needsDelimiter) {
sb.append(", ");
} else {
sb.append("select");
appendSelectHint(sb);
sb.append(" ");
needsDelimiter = true;
}
final String realAliasName;
if (selectClauseTypeUniqueScalar) {
if (specifiedUniqueScalarColumnInfo != null && columnInfo.equals(specifiedUniqueScalarColumnInfo)) {
// has PK, specified column in unique scalar
realAliasName = getSpecifiedColumnTableAliasNameAsOne(); // might be relation column
} else { // has no PK
realAliasName = basePointAliasName;
}
} else {
realAliasName = basePointAliasName;
}
final String realColumnName = realAliasName + "." + columnSqlName;
final String onQueryName;
++selectIndex;
if (_useSelectIndex) {
final String entityNo = BASE_POINT_HANDLING_ENTITY_NO;
onQueryName = buildSelectIndexAlias(columnSqlName, null, selectIndex, entityNo);
registerSelectIndex(entityNo, columnDbName, onQueryName, selectIndex);
} else {
onQueryName = columnSqlName.toString();
}
sb.append(decryptSelectColumnIfNeeds(columnInfo, realColumnName)).append(" as ").append(onQueryName);
getSelectClauseRealColumnAliasMap().put(realColumnName, onQueryName);
if (validSpecifiedLocal && localSpecifiedMap.containsKey(columnDbName)) {
final SpecifiedColumn specifiedColumn = localSpecifiedMap.get(columnDbName);
specifiedColumn.setOnQueryName(onQueryName); // basically for queryInsert()
}
}
return selectIndex;
}
protected int processSelectClauseRelation(StringBuilder sb, int selectIndex) {
if (_pkOnlySelectForcedlyEnabled) {
return selectIndex;
}
for (Entry> entry : getSelectedRelationColumnMap().entrySet()) {
final String tableAliasName = entry.getKey();
final Map relationColumnMap = entry.getValue();
Map foreginSpecifiedMap = null;
if (_specifiedSelectColumnMap != null) {
foreginSpecifiedMap = _specifiedSelectColumnMap.get(tableAliasName);
}
final boolean validSpecifiedForeign = foreginSpecifiedMap != null && !foreginSpecifiedMap.isEmpty();
boolean finishedForeignIndent = false;
for (SelectedRelationColumn selectColumnInfo : relationColumnMap.values()) {
final ColumnInfo columnInfo = selectColumnInfo.getColumnInfo();
final String columnDbName = columnInfo.getColumnDbName();
if (validSpecifiedForeign && !foreginSpecifiedMap.containsKey(columnDbName)) {
continue;
}
if (canBeNullObjectSpecifiedColumn(columnInfo)) {
registerColumnNullObject(tableAliasName, columnInfo);
continue;
}
final String realColumnName = selectColumnInfo.buildRealColumnSqlName();
final String columnAliasName = selectColumnInfo.buildColumnAliasName();
final String relationNoSuffix = selectColumnInfo.getRelationNoSuffix();
final String onQueryName;
++selectIndex;
if (_useSelectIndex) {
final ColumnSqlName columnSqlName = columnInfo.getColumnSqlName();
onQueryName = buildSelectIndexAlias(columnSqlName, columnAliasName, selectIndex, relationNoSuffix);
registerSelectIndex(relationNoSuffix, columnAliasName, onQueryName, selectIndex);
} else {
onQueryName = columnAliasName;
}
if (!finishedForeignIndent) {
sb.append(ln()).append(" ");
finishedForeignIndent = true;
}
sb.append(", ");
sb.append(decryptSelectColumnIfNeeds(columnInfo, realColumnName)).append(" as ").append(onQueryName);
getSelectClauseRealColumnAliasMap().put(realColumnName, onQueryName);
if (validSpecifiedForeign && foreginSpecifiedMap.containsKey(columnDbName)) {
final SpecifiedColumn specifiedColumn = foreginSpecifiedMap.get(columnDbName);
specifiedColumn.setOnQueryName(onQueryName); // basically for queryInsert()
}
}
}
return selectIndex;
}
protected int processSelectClauseDerivedReferrer(StringBuilder sb, int selectIndex) {
if (_specifiedDerivingSubQueryMap == null || _specifiedDerivingSubQueryMap.isEmpty()) {
return selectIndex;
}
for (Entry entry : _specifiedDerivingSubQueryMap.entrySet()) {
final String subQueryAlias = entry.getKey();
if (_pkOnlySelectForcedlyEnabled && !isSpecifiedDerivedOrderBy(subQueryAlias)) {
// even if PK only add one used as specified derived order-by
// (because it needs in order-by)
continue;
}
final String derivingSubQuery = entry.getValue().getDerivingSubQuery();
sb.append(ln()).append(" ");
sb.append(", ").append(derivingSubQuery);
// for SpecifiedDerivedOrderBy
if (subQueryAlias != null) {
getSelectClauseRealColumnAliasMap().put(subQueryAlias, subQueryAlias);
}
++selectIndex;
registerSelectIndex(BASE_POINT_HANDLING_ENTITY_NO, subQueryAlias, subQueryAlias, selectIndex);
}
return selectIndex;
}
protected Map getSelectClauseRealColumnAliasMap() {
if (_selectClauseRealColumnAliasMap == null) {
_selectClauseRealColumnAliasMap = new HashMap(); // order no needed
}
return _selectClauseRealColumnAliasMap;
}
// -----------------------------------------------------
// Count or Scalar
// ---------------
protected boolean isSelectClauseTypeCount() {
return _selectClauseType.isCount();
}
protected boolean isSelectClauseTypeScalar() {
return _selectClauseType.isScalar();
}
protected boolean isSelectClauseTypeUniqueScalar() {
return _selectClauseType.isUniqueScalar();
}
protected boolean isSelectClauseTypeSpecifiedScalar() {
return _selectClauseType.isSpecifiedScalar();
}
protected boolean isSelectClauseTypeNonUnionCount() {
return !hasUnionQuery() && isSelectClauseTypeCount();
}
protected boolean isSelectClauseNonUnionScalar() {
return !hasUnionQuery() && isSelectClauseTypeScalar();
}
protected boolean isSelectClauseNonUnionSelect() {
return !hasUnionQuery() && !isSelectClauseTypeScalar();
}
protected String buildSelectClauseScalar(String aliasName) {
if (isSelectClauseTypeCount()) {
return buildSelectClauseCount();
} else if (_selectClauseType.equals(SelectClauseType.COUNT_DISTINCT)) {
return buildSelectClauseCountDistinct(aliasName);
} else if (_selectClauseType.equals(SelectClauseType.MAX)) {
return buildSelectClauseMax(aliasName);
} else if (_selectClauseType.equals(SelectClauseType.MIN)) {
return buildSelectClauseMin(aliasName);
} else if (_selectClauseType.equals(SelectClauseType.SUM)) {
return buildSelectClauseSum(aliasName);
} else if (_selectClauseType.equals(SelectClauseType.AVG)) {
return buildSelectClauseAvg(aliasName);
}
String msg = "The type of select clause is not for scalar:";
msg = msg + " type=" + _selectClauseType;
throw new IllegalStateException(msg);
}
protected String buildSelectClauseCount() {
return "select count(*)";
}
protected String buildSelectClauseCountDistinct(String aliasName) {
return buildSelectClauseSpecifiedScalar(aliasName, "count(distinct");
}
protected String buildSelectClauseMax(String aliasName) {
return buildSelectClauseSpecifiedScalar(aliasName, "max");
}
protected String buildSelectClauseMin(String aliasName) {
return buildSelectClauseSpecifiedScalar(aliasName, "min");
}
protected String buildSelectClauseSum(String aliasName) {
return buildSelectClauseSpecifiedScalar(aliasName, "sum");
}
protected String buildSelectClauseAvg(String aliasName) {
return buildSelectClauseSpecifiedScalar(aliasName, "avg");
}
protected String buildSelectClauseSpecifiedScalar(String aliasName, String function) {
final String columnAlias = getScalarSelectColumnAlias();
final ColumnSqlName columnSqlName = getSpecifiedColumnSqlNameAsOne();
if (columnSqlName != null) { // normal column
final String valueExp = aliasName + "." + columnSqlName;
if (hasUnionQuery() && hasSpecifyCalculation(getSpecifiedColumnAsOne())) {
throwScalarSelectUnionQuerySpecifyCalculationUnsupportedException();
}
final ColumnInfo columnInfo = getSpecifiedColumnInfoAsOne(); // not null here
final String functionExp = doBuildFunctionExp(function, columnInfo, valueExp); // calculation resolved
return "select " + functionExp + " as " + columnAlias;
}
final String subQuery = getSpecifiedDerivingSubQueryAsOne();
if (subQuery != null) { // derived column
// SpecifyCalculation is already resolved in DerivedReferrer process
if (hasUnionQuery()) {
final String valueExp = aliasName + "." + columnAlias;
final ColumnInfo columnInfo = getSpecifiedDerivingColumnInfoAsOne(); // not null here
return "select " + doBuildFunctionExp(function, decryptSelectColumnIfNeeds(columnInfo, valueExp));
} else {
// adjusts alias definition target (move to function's scope)
final String aliasDef = " as " + columnAlias;
final StringBuilder sb = new StringBuilder();
final String pureSubQuery = Srl.substringLastFront(subQuery, aliasDef);
final String aliasDefRear = Srl.substringLastRear(subQuery, aliasDef); // just in case
final String functionExp = doBuildFunctionExp(function, pureSubQuery);
sb.append("select ").append(functionExp).append(aliasDef).append(aliasDefRear);
return sb.toString();
}
}
String msg = "Not found specifed column for scalar: function=" + function;
throw new IllegalStateException(msg); // basically no way (checked before)
}
protected void throwScalarSelectUnionQuerySpecifyCalculationUnsupportedException() {
String msg = "ScalarSelect using UnionQuery with SpecifyCalculation is unsupported: " + _tableDbName;
throw new IllegalConditionBeanOperationException(msg);
}
protected String doBuildFunctionExp(String function, ColumnInfo columnInfo, String valueExp) {
final ColumnRealName filtered;
{
final String decrypted = decryptSelectColumnIfNeeds(columnInfo, valueExp);
final ColumnRealName beforeFilter = ColumnRealName.create(null, new ColumnSqlName(decrypted));
final SpecifiedColumn specifiedColumn = getSpecifiedColumnAsOne();
filtered = filterSpecifyColumnCalculation(beforeFilter, specifiedColumn);
}
return doBuildFunctionExp(function, filtered.toString());
}
protected String doBuildFunctionExp(String function, String columnExp) {
final String frontConnector = function.contains("(") ? " " : "("; // e.g. "count(distinct"
final String functionExp = function + frontConnector + columnExp + ")";
return _scalarSelectOption != null ? _scalarSelectOption.filterFunction(functionExp) : functionExp;
}
// -----------------------------------------------------
// Select Index
// ------------
/**
* {@inheritDoc}
*/
public Map> getSelectIndexMap() {
return _selectIndexMap; // null allowed
}
/**
* {@inheritDoc}
*/
public Map getSelectColumnKeyNameMap() {
return _selectColumnKeyNameMap; // null allowed
}
protected void clearSelectIndex() {
_selectIndexMap = null;
_selectColumnKeyNameMap = null;
}
protected void registerSelectIndex(String entityNo, String keyName, String onQueryName, Integer selectIndex) {
doRegisterSelectIndex(entityNo, keyName, selectIndex);
doRegisterSelectOnQueryColumnKey(entityNo, keyName, onQueryName);
}
protected void doRegisterSelectIndex(String entityNo, String keyName, Integer selectIndex) {
if (_selectIndexMap == null) { // lazy load
_selectIndexMap = createSelectIndexEntryMap();
}
Map indexElementMap = _selectIndexMap.get(entityNo);
if (indexElementMap == null) {
indexElementMap = createSelectIndexInnerMap();
_selectIndexMap.put(entityNo, indexElementMap);
}
indexElementMap.put(keyName, selectIndex);
}
protected Map createSelectIndexEntryMap() {
return new HashMap(); // it does not need to be ordered
}
protected Map createSelectIndexInnerMap() {
// flexible for resolving non-compilable connectors and reservation words
// (and it does not need to be ordered)
return StringKeyMap.createAsFlexible();
}
protected void doRegisterSelectOnQueryColumnKey(String entityNo, String keyName, String onQueryName) {
if (_selectColumnKeyNameMap == null) { // lazy load
_selectColumnKeyNameMap = createSelectOnQueryColumnKeyMap();
}
_selectColumnKeyNameMap.put(onQueryName, keyName); // found by column label provided by JDBC
}
protected Map createSelectOnQueryColumnKeyMap() {
return StringKeyMap.createAsFlexible(); // same reason with SelectIndexInnerMap
}
protected String buildSelectIndexAlias(ColumnSqlName sqlName, String aliasName, int selectIndex, String entityNo) {
if (sqlName.hasIrregularChar()) {
return buildSelectIndexSimpleName(selectIndex); // use index only for safety
}
// regular case only here
final String baseName;
if (aliasName != null) { // relation column
baseName = aliasName;
} else { // local column
baseName = sqlName.toString();
}
final String resolvedName;
final int limitSize = _aliasNameLimitSize;
if (baseName.length() > limitSize) {
resolvedName = buildSelectIndexCuttingName(selectIndex, baseName, limitSize);
} else {
resolvedName = baseName;
}
if (isDuplicateAliasName(resolvedName)) { // e.g. local:FOO_0, relation:FOO(_0)
return buildSelectIndexSimpleName(selectIndex); // rare case so use index only
}
return resolvedName;
}
protected String buildSelectIndexCuttingName(int selectIndex, String baseName, int limitSize) {
final int aliasNameBaseSize = limitSize - 10;
return Srl.substring(baseName, 0, aliasNameBaseSize) + "_c" + selectIndex;
}
protected String buildSelectIndexSimpleName(int selectIndex) {
final String baseName = "c" + selectIndex;
if (isDuplicateAliasName(baseName)) {
return "df" + selectIndex; // last retry
}
return baseName;
}
protected boolean isDuplicateAliasName(final String resolvedName) {
return _selectColumnKeyNameMap != null && _selectColumnKeyNameMap.containsKey(resolvedName);
}
public void changeAliasNameLimitSize(int aliasNameLimitSize) { // basically for test
if (aliasNameLimitSize < 1) {
String msg = "The argument 'aliasNameLimitSize' should not be minus or zero: " + aliasNameLimitSize;
throw new IllegalArgumentException(msg);
}
_aliasNameLimitSize = aliasNameLimitSize;
}
protected int getDefaultAliasNameLimitSize() {
return 30; // the default is the least limit size in DBMSs (Oracle)
}
public void disableSelectIndex() {
_useSelectIndex = false; // for e.g. scalar select (internal handling)
}
// -----------------------------------------------------
// Select Hint
// -----------
public String getSelectHint() {
return createSelectHint();
}
protected void appendSelectHint(StringBuilder sb) { // for extension
sb.append(SELECT_HINT);
}
// ===================================================================================
// From Clause
// ===========
// Clause Parts
public String getFromClause() {
reflectClauseLazilyIfExists();
final StringBuilder sb = new StringBuilder();
buildFromClause(sb);
return sb.toString();
}
protected void buildFromClause(StringBuilder sb) {
sb.append(ln()).append(" ");
sb.append("from ");
int tablePos = 7; // basically for in-line view indent
if (isJoinInParentheses()) {
for (int i = 0; i < getOuterJoinMap().size(); i++) {
sb.append("(");
++tablePos;
}
}
final TableSqlName tableSqlName = getDBMeta().getTableSqlName();
final String basePointAliasName = getBasePointAliasName();
if (hasBaseTableInlineWhereClause()) {
final List baseTableInlineWhereList = getBaseTableInlineWhereList();
sb.append(getInlineViewClause(tableSqlName, baseTableInlineWhereList, tablePos));
sb.append(" ").append(basePointAliasName);
} else {
sb.append(tableSqlName).append(" ").append(basePointAliasName);
}
sb.append(getFromBaseTableHint());
if (_dynamicHintFromBaseTable != null) {
sb.append(" ").append(_dynamicHintFromBaseTable);
}
sb.append(getLeftOuterJoinClause());
}
public String getFromBaseTableHint() {
return createFromBaseTableHint();
}
// ===================================================================================
// Join Clause
// ===========
// Clause Parts
protected String getLeftOuterJoinClause() {
final StringBuilder sb = new StringBuilder();
checkFixedConditionLazily();
reflectInnerJoinAutoDetectLazily();
final boolean countLeastJoinAllowed = checkCountLeastJoinAllowed();
final boolean structuralPossibleInnerJoinAllowed = checkStructuralPossibleInnerJoinAllowed();
for (Entry outerJoinEntry : getOuterJoinMap().entrySet()) {
final String foreignAliasName = outerJoinEntry.getKey();
final LeftOuterJoinInfo joinInfo = outerJoinEntry.getValue();
if (countLeastJoinAllowed && canBeCountLeastJoin(joinInfo)) {
continue; // means only joined countable
}
buildLeftOuterJoinClause(sb, foreignAliasName, joinInfo, structuralPossibleInnerJoinAllowed);
}
return sb.toString();
}
protected void checkFixedConditionLazily() {
if (_fixedConditionLazyChecker != null && !_fixedConditionLazyChecker.isEmpty()) {
for (FixedConditionLazyChecker lazyChecker : _fixedConditionLazyChecker) {
lazyChecker.check();
}
}
}
protected void reflectInnerJoinAutoDetectLazily() {
if (!hasInnerJoinLazyReflector()) {
return;
}
final List reflectorList = getInnerJoinLazyReflectorList();
for (InnerJoinLazyReflector reflector : reflectorList) {
reflector.reflect();
}
reflectorList.clear();
}
protected boolean checkCountLeastJoinAllowed() {
if (!canPagingCountLeastJoin()) {
return false;
}
if (!isSelectClauseTypeNonUnionCount()) {
return false;
}
return !hasFixedConditionOverRelationJoin();
}
protected boolean checkStructuralPossibleInnerJoinAllowed() {
if (!_structuralPossibleInnerJoinEnabled) {
return false;
}
return !hasFixedConditionOverRelationJoin();
}
// to use over-relation provides very complex logic
// so it suppresses PagingCountLeastJoin and StructuralPossibleInnerJoin
protected boolean hasFixedConditionOverRelationJoin() {
for (LeftOuterJoinInfo joinInfo : getOuterJoinMap().values()) {
if (joinInfo.hasFixedConditionOverRelation()) {
// because over-relation may have references of various relations
return true;
}
}
return false;
}
protected boolean canBeCountLeastJoin(LeftOuterJoinInfo joinInfo) {
return !joinInfo.isCountableJoin();
}
protected void buildLeftOuterJoinClause(StringBuilder sb, String foreignAliasName, LeftOuterJoinInfo joinInfo,
boolean structuralPossibleInnerJoinAllowed) {
final Map joinOnMap = joinInfo.getJoinOnMap();
assertJoinOnMapNotEmpty(joinOnMap, foreignAliasName);
sb.append(ln()).append(" ");
final String joinExp;
final boolean canBeInnerJoin = canBeInnerJoin(joinInfo, structuralPossibleInnerJoinAllowed);
if (canBeInnerJoin) {
joinExp = " inner join ";
} else {
joinExp = " left outer join "; // is main!
}
sb.append(joinExp); // is main!
buildJoinTableClause(sb, joinInfo, joinExp, canBeInnerJoin);
sb.append(" ").append(foreignAliasName);
if (joinInfo.hasInlineOrOnClause() || joinInfo.hasFixedCondition()) {
sb.append(ln()).append(" "); // only when additional conditions exist
}
sb.append(" on ");
buildJoinOnClause(sb, joinInfo, joinOnMap);
if (isJoinInParentheses()) {
sb.append(")");
}
}
protected boolean canBeInnerJoin(LeftOuterJoinInfo joinInfo, boolean structuralPossibleInnerJoinAllowed) {
if (joinInfo.isInnerJoin()) {
return true;
}
if (structuralPossibleInnerJoinAllowed) {
return joinInfo.isStructuralPossibleInnerJoin();
}
return false;
}
protected boolean isJoinInParentheses() { // for DBMS that needs to join in parentheses
return false; // as default
}
protected void buildJoinTableClause(StringBuilder sb, LeftOuterJoinInfo joinInfo, String joinExp, boolean canBeInnerJoin) {
final String foreignTableDbName = joinInfo.getForeignTableDbName();
final int tablePos = 3 + joinExp.length(); // basically for in-line view indent
final DBMeta foreignDBMeta = findDBMeta(foreignTableDbName);
final TableSqlName foreignTableSqlName = foreignDBMeta.getTableSqlName();
final List inlineWhereClauseList = joinInfo.getInlineWhereClauseList();
final String tableExp;
if (inlineWhereClauseList.isEmpty()) {
tableExp = foreignTableSqlName.toString();
} else {
tableExp = getInlineViewClause(foreignTableSqlName, inlineWhereClauseList, tablePos);
}
if (joinInfo.hasFixedCondition()) {
sb.append(joinInfo.resolveFixedInlineView(tableExp, canBeInnerJoin));
} else {
sb.append(tableExp);
}
}
protected String getInlineViewClause(TableSqlName inlineTableSqlName, List inlineWhereClauseList, int tablePos) {
final String inlineBaseAlias = getInlineViewBasePointAlias();
final StringBuilder sb = new StringBuilder();
sb.append("(select * from ").append(inlineTableSqlName).append(" ").append(inlineBaseAlias);
final String baseIndent = buildSpaceBar(tablePos + 1);
sb.append(ln()).append(baseIndent);
sb.append(" where ");
int count = 0;
for (QueryClause whereClause : inlineWhereClauseList) {
final String clauseElement = filterWhereClauseSimply(whereClause.toString());
if (count > 0) {
sb.append(ln()).append(baseIndent);
sb.append(" and ");
}
sb.append(clauseElement);
++count;
}
sb.append(")");
return sb.toString();
}
protected void buildJoinOnClause(StringBuilder sb, LeftOuterJoinInfo joinInfo, Map joinOnMap) {
int currentConditionCount = 0;
currentConditionCount = doBuildJoinOnClauseBasic(sb, joinInfo, joinOnMap, currentConditionCount);
currentConditionCount = doBuildJoinOnClauseFixed(sb, joinInfo, joinOnMap, currentConditionCount);
currentConditionCount = doBuildJoinOnClauseAdditional(sb, joinInfo, joinOnMap, currentConditionCount);
}
protected int doBuildJoinOnClauseBasic(StringBuilder sb, LeftOuterJoinInfo joinInfo, Map joinOnMap,
int currentConditionCount) {
for (Entry joinOnEntry : joinOnMap.entrySet()) {
final ColumnRealName localRealName = joinOnEntry.getKey();
final ColumnRealName foreignRealName = joinOnEntry.getValue();
sb.append(currentConditionCount > 0 ? " and " : "");
sb.append(localRealName).append(" = ").append(foreignRealName);
++currentConditionCount;
}
return currentConditionCount;
}
protected int doBuildJoinOnClauseFixed(StringBuilder sb, LeftOuterJoinInfo joinInfo, Map joinOnMap,
int currentConditionCount) {
if (joinInfo.hasFixedCondition()) {
final String fixedCondition = joinInfo.getFixedCondition();
if (isInlineViewOptimizedCondition(fixedCondition)) {
return currentConditionCount;
}
if (currentConditionCount > 0) { // basically true from first loop (false if fixedOnlyJoin)
sb.append(ln()).append(" ");
sb.append(" and ");
}
sb.append(fixedCondition);
++currentConditionCount;
}
return currentConditionCount;
}
protected boolean isInlineViewOptimizedCondition(String fixedCondition) {
return HpFixedConditionQueryResolver.OPTIMIZED_MARK.equals(fixedCondition);
}
protected int doBuildJoinOnClauseAdditional(StringBuilder sb, LeftOuterJoinInfo joinInfo, Map joinOnMap,
int currentConditionCount) {
final List additionalOnClauseList = joinInfo.getAdditionalOnClauseList();
for (QueryClause additionalOnClause : additionalOnClauseList) {
sb.append(ln()).append(" ");
sb.append(currentConditionCount > 0 ? " and " : "");
sb.append(additionalOnClause);
++currentConditionCount;
}
return currentConditionCount;
}
// -----------------------------------------------------
// From Hint
// ---------
public String getFromHint() {
return createFromHint();
}
// ===================================================================================
// Where Clause
// ============
// Clause Parts
public String getWhereClause() {
reflectClauseLazilyIfExists();
final StringBuilder sb = new StringBuilder();
buildWhereClause(sb);
return sb.toString();
}
protected void buildWhereClause(StringBuilder sb) {
buildWhereClause(sb, false);
}
protected void buildWhereClause(StringBuilder sb, boolean template) {
final List whereList = getWhereList();
if (whereList.isEmpty()) {
if (template) {
sb.append(" ").append(getWhereClauseMark());
}
return;
}
int count = 0;
for (QueryClause whereClause : whereList) {
final String clauseElement = filterWhereClauseSimply(whereClause.toString());
if (count == 0) {
sb.append(ln()).append(" ");
sb.append("where ").append(template ? getWhereFirstConditionMark() : "").append(clauseElement);
} else {
sb.append(ln()).append(" ");
sb.append(" and ").append(clauseElement);
}
++count;
}
}
// ===================================================================================
// OrderBy Clause
// ==============
// Clause Parts
public String getOrderByClause() {
reflectClauseLazilyIfExists();
final OrderByClause orderBy = getOrderBy();
String orderByClause = null;
if (hasUnionQuery()) {
final Map selectClauseRealColumnAliasMap = getSelectClauseRealColumnAliasMap();
if (selectClauseRealColumnAliasMap.isEmpty()) {
String msg = "The selectClauseColumnAliasMap should not be empty when union query exists.";
throw new IllegalStateException(msg);
}
orderByClause = orderBy.getOrderByClause(selectClauseRealColumnAliasMap);
} else {
orderByClause = orderBy.getOrderByClause();
}
if (orderByClause != null && orderByClause.trim().length() > 0) {
return ln() + " " + orderByClause;
} else {
return orderByClause;
}
}
// ===================================================================================
// SQL Suffix
// ==========
// Clause Parts
public String getSqlSuffix() {
reflectClauseLazilyIfExists();
final String sqlSuffix = createSqlSuffix();
if (sqlSuffix != null && sqlSuffix.trim().length() > 0) {
return ln() + sqlSuffix;
} else {
return sqlSuffix;
}
}
// ===================================================================================
// Selected Relation
// =================
/** {@inheritDoc} */
public void registerSelectedRelation(String foreignTableAliasName, String localTableDbName, String foreignPropertyName,
String localRelationPath, String foreignRelationPath) {
assertObjectNotNull("foreignTableAliasName", foreignTableAliasName);
assertObjectNotNull("localTableDbName", localTableDbName);
assertObjectNotNull("foreignPropertyName", foreignPropertyName);
assertObjectNotNull("foreignRelationPath", foreignRelationPath);
getSelectedRelationBasicMap().put(foreignRelationPath, foreignPropertyName);
getSelectedRelationPathToAliasMap().put(foreignRelationPath, foreignTableAliasName);
final Map columnMap =
createSelectedSelectColumnInfo(foreignTableAliasName, localTableDbName, foreignPropertyName, localRelationPath);
getSelectedRelationColumnMap().put(foreignTableAliasName, columnMap);
analyzeSelectedNextConnectingRelation(foreignRelationPath);
}
/** {@inheritDoc} */
public String translateSelectedRelationPathToPropName(String foreignRelationPath) {
if (_selectedRelationBasicMap == null) {
return null;
}
return _selectedRelationBasicMap.get(foreignRelationPath);
}
protected Map getSelectedRelationBasicMap() {
if (_selectedRelationBasicMap == null) {
_selectedRelationBasicMap = new LinkedHashMap();
}
return _selectedRelationBasicMap;
}
/** {@inheritDoc} */
public String translateSelectedRelationPathToTableAlias(String foreignRelationPath) {
if (_selectedRelationPathToTableAliasMap == null) {
return null;
}
return _selectedRelationPathToTableAliasMap.get(foreignRelationPath);
}
protected Map getSelectedRelationPathToAliasMap() {
if (_selectedRelationPathToTableAliasMap == null) {
_selectedRelationPathToTableAliasMap = new LinkedHashMap();
}
return _selectedRelationPathToTableAliasMap;
}
protected Map createSelectedSelectColumnInfo(String foreignTableAliasName, String localTableDbName,
String foreignPropertyName, String localRelationPath) {
final DBMeta dbmeta = findDBMeta(localTableDbName);
final ForeignInfo foreignInfo = dbmeta.findForeignInfo(foreignPropertyName);
final int relationNo = foreignInfo.getRelationNo();
String nextRelationPath = RELATION_PATH_DELIMITER + relationNo;
if (localRelationPath != null) {
nextRelationPath = localRelationPath + nextRelationPath;
}
final Map resultMap = new LinkedHashMap();
final DBMeta foreignDBMeta = foreignInfo.getForeignDBMeta();
final List columnInfoList = foreignDBMeta.getColumnInfoList();
for (ColumnInfo columnInfo : columnInfoList) {
final String columnDbName = columnInfo.getColumnDbName();
final SelectedRelationColumn selectColumnInfo = new SelectedRelationColumn();
selectColumnInfo.setTableAliasName(foreignTableAliasName);
selectColumnInfo.setColumnInfo(columnInfo);
selectColumnInfo.setRelationNoSuffix(nextRelationPath);
resultMap.put(columnDbName, selectColumnInfo);
}
return resultMap;
}
protected void analyzeSelectedNextConnectingRelation(String foreignRelationPath) {
if (foreignRelationPath.length() <= 3) { // fast check e.g. _12, _3
return; // three characters cannot make two elements
}
final String delimiter = RELATION_PATH_DELIMITER;
final int delimiterCount = Srl.count(foreignRelationPath, delimiter);
if (delimiterCount < 2) { // has no previous relation
return;
}
final String previousPath = Srl.substringLastFront(foreignRelationPath, delimiter);
getSelectedNextConnectingRelationSet().add(previousPath);
}
/** {@inheritDoc} */
public int getSelectedRelationCount() {
return _selectedRelationBasicMap != null ? _selectedRelationBasicMap.size() : 0;
}
/** {@inheritDoc} */
public boolean isSelectedRelationEmpty() {
return _selectedRelationBasicMap == null || _selectedRelationBasicMap.isEmpty();
}
/** {@inheritDoc} */
public boolean hasSelectedRelation(String foreignRelationPath) {
return _selectedRelationBasicMap != null && _selectedRelationBasicMap.containsKey(foreignRelationPath);
}
/** {@inheritDoc} */
public Map> getSelectedRelationColumnMap() {
if (_selectedRelationColumnMap == null) {
_selectedRelationColumnMap = new LinkedHashMap>();
}
return _selectedRelationColumnMap;
}
/** {@inheritDoc} */
public boolean isSelectedNextConnectingRelation(String foreignRelationPath) {
return _selectedNextConnectingRelationSet != null && _selectedNextConnectingRelationSet.contains(foreignRelationPath);
}
protected Set getSelectedNextConnectingRelationSet() {
if (_selectedNextConnectingRelationSet == null) {
_selectedNextConnectingRelationSet = new HashSet();
}
return _selectedNextConnectingRelationSet;
}
// ===================================================================================
// OuterJoin
// =========
// -----------------------------------------------------
// Registration
// ------------
/**
* {@inheritDoc}
*/
public void registerOuterJoin(String foreignAliasName, String foreignTableDbName, String localAliasName, String localTableDbName,
Map joinOnMap, String relationPath, ForeignInfo foreignInfo, String fixedCondition,
FixedConditionResolver fixedConditionResolver) {
doRegisterOuterJoin(foreignAliasName, foreignTableDbName, localAliasName, localTableDbName // basic
, joinOnMap, relationPath, foreignInfo // join object
, fixedCondition, fixedConditionResolver); // fixed condition
}
/**
* {@inheritDoc}
*/
public void registerOuterJoinFixedInline(String foreignAliasName, String foreignTableDbName, String localAliasName,
String localTableDbName, Map joinOnMap, String relationPath, ForeignInfo foreignInfo,
String fixedCondition, FixedConditionResolver fixedConditionResolver) {
doRegisterOuterJoin(foreignAliasName, foreignTableDbName, localAliasName, localTableDbName // same as normal
, joinOnMap, relationPath, foreignInfo // normal until here
, null, null); // null set to OnClause
if (fixedCondition != null) { // uses it instead of null set
if (fixedConditionResolver != null) {
fixedCondition = fixedConditionResolver.resolveVariable(fixedCondition, true);
}
final String inlineBaseAlias = getInlineViewBasePointAlias();
final String clause = Srl.replace(fixedCondition, foreignAliasName + ".", inlineBaseAlias + ".");
registerOuterJoinInlineWhereClause(foreignAliasName, clause, false);
}
}
protected void doRegisterOuterJoin(String foreignAliasName, String foreignTableDbName, String localAliasName, String localTableDbName,
Map joinOnMap, String relationPath, ForeignInfo foreignInfo, String fixedCondition,
FixedConditionResolver fixedConditionResolver) {
assertAlreadyOuterJoin(foreignAliasName);
assertJoinOnMapNotEmpty(joinOnMap, foreignAliasName);
final Map outerJoinMap = getOuterJoinMap();
final LeftOuterJoinInfo joinInfo = new LeftOuterJoinInfo();
joinInfo.setForeignAliasName(foreignAliasName);
joinInfo.setForeignTableDbName(foreignTableDbName);
joinInfo.setLocalAliasName(localAliasName);
joinInfo.setLocalTableDbName(localTableDbName);
joinInfo.setJoinOnMap(joinOnMap);
final LeftOuterJoinInfo localJoinInfo = outerJoinMap.get(localAliasName);
if (localJoinInfo != null) { // means local is also joined (not base point)
joinInfo.setLocalJoinInfo(localJoinInfo);
}
joinInfo.setRelationPath(relationPath);
joinInfo.setPureFK(foreignInfo.isPureFK());
joinInfo.setNotNullFKColumn(foreignInfo.isNotNullFKColumn());
joinInfo.setFixedCondition(fixedCondition);
joinInfo.setFixedConditionResolver(fixedConditionResolver);
// it should be resolved before registration because
// the process may have Query(Relation) as precondition
joinInfo.resolveFixedCondition();
outerJoinMap.put(foreignAliasName, joinInfo);
getRelationPathForeignAliasMap().put(relationPath, foreignAliasName);
}
/**
* {@inheritDoc}
*/
public void registerFixedConditionLazyChecker(FixedConditionLazyChecker checker) {
if (_fixedConditionLazyChecker == null) {
_fixedConditionLazyChecker = new ArrayList(4);
}
_fixedConditionLazyChecker.add(checker);
}
// -----------------------------------------------------
// OuterJoin Attribute
// -------------------
/**
* {@inheritDoc}
*/
public Map getOuterJoinMap() {
if (_outerJoinMap == null) {
_outerJoinMap = new LinkedHashMap(4);
}
return _outerJoinMap;
}
/**
* {@inheritDoc}
*/
public boolean hasOuterJoin() {
return _outerJoinMap != null && !_outerJoinMap.isEmpty();
}
protected Map getRelationPathForeignAliasMap() {
if (_relationPathForeignAliasMap == null) {
_relationPathForeignAliasMap = new LinkedHashMap(4);
}
return _relationPathForeignAliasMap;
}
/**
* {@inheritDoc}
*/
public boolean canUseRelationCache(String relationPath) {
// if over-relation, possible following case:
// sea (1) -> dock(21) -(over)-> {21, FOO}
// land(2) -> dock(21) -(over)-> {21, BAR}
// 'dock' is the same record but should be different instance
return !isUnderOverRelation(relationPath);
}
/**
* {@inheritDoc}
*/
public boolean isUnderOverRelation(String relationPath) {
final Map relationPathForeignAliasMap = getRelationPathForeignAliasMap();
final String foreignAliasName = relationPathForeignAliasMap.get(relationPath);
if (foreignAliasName == null) { // basically no way
String msg = "Not found the foreign alias name by the relation path:";
msg = msg + " " + relationPath + ", " + relationPathForeignAliasMap.keySet();
throw new IllegalStateException(msg);
}
final Map outerJoinMap = getOuterJoinMap();
final LeftOuterJoinInfo outerJoinInfo = outerJoinMap.get(foreignAliasName);
if (outerJoinInfo == null) { // basically no way
String msg = "Not found the outer join info by the foreign alias name:";
msg = msg + " " + relationPath + ", " + foreignAliasName + ", " + outerJoinMap.keySet();
throw new IllegalStateException(msg);
}
return outerJoinInfo.isUnderOverRelation();
}
// -----------------------------------------------------
// InnerJoin Handling
// ------------------
/**
* {@inheritDoc}
*/
public void changeToInnerJoin(String foreignAliasName) {
doChangeToInnerJoin(foreignAliasName, false);
}
protected void doChangeToInnerJoin(String foreignAliasName, boolean autoDetect) {
final Map outerJoinMap = getOuterJoinMap();
final LeftOuterJoinInfo joinInfo = outerJoinMap.get(foreignAliasName);
if (joinInfo == null) {
String msg = "The foreignAliasName was not found:";
msg = msg + " " + foreignAliasName + " in " + outerJoinMap.keySet();
throw new IllegalStateException(msg);
}
joinInfo.setInnerJoin(true);
reflectUnderInnerJoinToJoin(joinInfo, autoDetect);
}
protected void reflectUnderInnerJoinToJoin(final LeftOuterJoinInfo foreignJoinInfo, boolean autoDetect) {
LeftOuterJoinInfo currentJoinInfo = foreignJoinInfo.getLocalJoinInfo();
while (true) {
if (currentJoinInfo == null) { // means base point
break;
}
// all join-info are overridden because of complex logic
if (autoDetect) {
currentJoinInfo.setInnerJoin(true); // be inner-join as we can if auto-detect
} else {
currentJoinInfo.setUnderInnerJoin(true); // manual is pinpoint setting
}
currentJoinInfo = currentJoinInfo.getLocalJoinInfo(); // trace back toward base point
}
}
// -----------------------------------------------------
// InnerJoin AutoDetect
// --------------------
// has several items of inner-join auto-detected
public void enableInnerJoinAutoDetect() {
enableStructuralPossibleInnerJoin();
enableWhereUsedInnerJoin();
}
public void disableInnerJoinAutoDetect() {
disableStructuralPossibleInnerJoin();
disableWhereUsedInnerJoin();
}
// -----------------------------------------------------
// StructuralPossible InnerJoin
// ----------------------------
// one of inner-join auto-detect
public void enableStructuralPossibleInnerJoin() {
_structuralPossibleInnerJoinEnabled = true;
}
public void disableStructuralPossibleInnerJoin() {
_structuralPossibleInnerJoinEnabled = false;
}
public boolean isStructuralPossibleInnerJoinEnabled() {
return _structuralPossibleInnerJoinEnabled;
}
// -----------------------------------------------------
// WhereUsed InnerJoin
// -------------------
// one of inner-join auto-detect
public void enableWhereUsedInnerJoin() {
_whereUsedInnerJoinEnabled = true;
}
public void disableWhereUsedInnerJoin() {
_whereUsedInnerJoinEnabled = false;
}
public boolean isWhereUsedInnerJoinEnabled() {
return _whereUsedInnerJoinEnabled;
}
// -----------------------------------------------------
// InnerJoin LazyReflector
// -----------------------
protected List getInnerJoinLazyReflectorList() {
if (_innerJoinLazyReflector == null) {
_innerJoinLazyReflector = new ArrayList(4);
}
return _innerJoinLazyReflector;
}
protected boolean hasInnerJoinLazyReflector() {
return _innerJoinLazyReflector != null && !_innerJoinLazyReflector.isEmpty();
}
// -----------------------------------------------------
// Assert Helper
// -------------
protected void assertAlreadyOuterJoin(String foreignAliasName) {
if (getOuterJoinMap().containsKey(foreignAliasName)) {
String msg = "The foreign alias name have already registered in outer join: " + foreignAliasName;
throw new IllegalStateException(msg);
}
}
protected void assertJoinOnMapNotEmpty(Map joinOnMap, String foreignAliasName) {
// joinOnMap can be empty only when fixedOnlyJoin
// though it should be checked when the option is false
// it does not have the option info in runtime meta data
// and it needs big refactor (but get small joy)
// and checked in engine so no check here
//if (joinOnMap.isEmpty()) {
// String msg = "The joinOnMap should not be empty: foreignAliasName=" + foreignAliasName;
// throw new IllegalStateException(msg);
//}
}
// ===================================================================================
// Where
// =====
// -----------------------------------------------------
// Registration
// ------------
/**
* {@inheritDoc}
*/
public void registerWhereClause(ColumnRealName columnRealName // real name of column
, ConditionKey key, ConditionValue value // basic resources
, ColumnFunctionCipher cipher, ConditionOption option // optional resources
, String usedAliasName) { // table alias name used on where clause
assertObjectNotNull("columnRealName", columnRealName);
assertObjectNotNull("key", key);
assertObjectNotNull("value", value);
assertStringNotNullAndNotTrimmedEmpty("usedAliasName", usedAliasName);
final List clauseList = getWhereClauseList4Register();
doRegisterWhereClause(clauseList, columnRealName, key, value, cipher, option, false, false);
doReflectWhereUsedToJoin(usedAliasName);
if (!key.isNullaleKey()) {
registerInnerJoinLazyReflector(usedAliasName);
}
}
/**
* {@inheritDoc}
*/
public void registerWhereClause(String clause, String usedAliasName) {
registerWhereClause(clause, usedAliasName, false); // possible to be inner-join as default
}
/**
* {@inheritDoc}
*/
public void registerWhereClause(String clause, String usedAliasName, boolean noWayInner) {
assertStringNotNullAndNotTrimmedEmpty("clause", clause);
assertStringNotNullAndNotTrimmedEmpty("usedAliasName", usedAliasName);
final List clauseList = getWhereClauseList4Register();
doRegisterWhereClause(clauseList, clause);
doReflectWhereUsedToJoin(usedAliasName);
if (!noWayInner) {
registerInnerJoinLazyReflector(usedAliasName);
}
}
/**
* {@inheritDoc}
*/
public void registerWhereClause(QueryClause clause, QueryUsedAliasInfo... usedAliasInfos) {
assertObjectNotNull("clause", clause);
assertObjectNotNull("usedAliasInfos", usedAliasInfos);
if (usedAliasInfos.length == 0) {
String msg = "The argument 'usedAliasInfos' should not be empty.";
throw new IllegalArgumentException(msg);
}
final List clauseList = getWhereClauseList4Register();
doRegisterWhereClause(clauseList, clause);
for (QueryUsedAliasInfo usedAliasInfo : usedAliasInfos) {
reflectWhereUsedToJoin(usedAliasInfo);
}
}
// -----------------------------------------------------
// WhereUsed Join
// --------------
/**
* {@inheritDoc}
*/
public void reflectWhereUsedToJoin(QueryUsedAliasInfo usedAliasInfo) {
assertObjectNotNull("usedAliasInfo", usedAliasInfo);
final String usedAliasName = usedAliasInfo.getUsedAliasName();
doReflectWhereUsedToJoin(usedAliasName);
registerInnerJoinLazyReflector(usedAliasInfo);
}
protected void doReflectWhereUsedToJoin(String usedAliasName) {
LeftOuterJoinInfo currentJoinInfo = getOuterJoinMap().get(usedAliasName);
while (true) {
if (currentJoinInfo == null) { // means base point
break;
}
if (currentJoinInfo.isWhereUsedJoin()) { // means already traced
break;
}
currentJoinInfo.setWhereUsedJoin(true);
currentJoinInfo = currentJoinInfo.getLocalJoinInfo(); // trace back toward base point
}
}
// -----------------------------------------------------
// InnerJoin Reflection
// --------------------
protected void registerInnerJoinLazyReflector(String usedAliasName) { // without no-way speaker
if (isOutOfWhereUsedInnerJoin()) {
return;
}
final QueryUsedAliasInfo usedAliasInfo = new QueryUsedAliasInfo(usedAliasName, null);
registerInnerJoinLazyReflector(usedAliasInfo);
}
protected void registerInnerJoinLazyReflector(QueryUsedAliasInfo usedAliasInfo) {
if (isOutOfWhereUsedInnerJoin()) {
return;
}
final List reflectorList = getInnerJoinLazyReflectorList();
reflectorList.add(createInnerJoinLazyReflector(usedAliasInfo));
}
protected boolean isOutOfWhereUsedInnerJoin() {
return !_whereUsedInnerJoinEnabled || _orScopeQueryEffective;
}
protected InnerJoinLazyReflectorBase createInnerJoinLazyReflector(QueryUsedAliasInfo usedAliasInfo) {
final String usedAliasName = usedAliasInfo.getUsedAliasName();
return new InnerJoinLazyReflectorBase(usedAliasInfo.getInnerJoinAutoDetectNoWaySpeaker()) {
@Override
protected void doReflect() {
if (getOuterJoinMap().containsKey(usedAliasName)) { // checked because it may be local
doChangeToInnerJoin(usedAliasName, true);
}
}
};
}
// -----------------------------------------------------
// Where Attribute
// ---------------
protected List getWhereClauseList4Register() {
if (_orScopeQueryEffective) {
return getTmpOrWhereList();
} else {
return getWhereList();
}
}
/**
* {@inheritDoc}
*/
public void exchangeFirstWhereClauseForLastOne() {
final List whereList = getWhereList();
if (whereList.size() > 1) {
final QueryClause first = whereList.get(0);
final QueryClause last = whereList.get(whereList.size() - 1);
whereList.set(0, last);
whereList.set(whereList.size() - 1, first);
}
}
protected List getWhereList() {
if (_whereList == null) {
_whereList = new ArrayList(8);
}
return _whereList;
}
/**
* {@inheritDoc}
*/
public boolean hasWhereClauseOnBaseQuery() {
return _whereList != null && !_whereList.isEmpty();
}
/**
* {@inheritDoc}
*/
public void clearWhereClauseOnBaseQuery() {
if (_whereList != null) {
_whereList.clear();
}
}
public void backupWhereClauseOnBaseQuery() {
_backupWhereList = _whereList;
}
public void restoreWhereClauseOnBaseQuery() {
_whereList = _backupWhereList;
_backupWhereList = null;
}
// ===================================================================================
// In-line Where
// =============
// -----------------------------------------------------
// In-line for Base Table
// ----------------------
public void registerBaseTableInlineWhereClause(ColumnSqlName columnSqlName // SQL name of column
, ConditionKey key, ConditionValue value // basic resources
, ColumnFunctionCipher cipher, ConditionOption option) { // optional resources
final List clauseList = getBaseTableInlineWhereClauseList4Register();
final String inlineBaseAlias = getInlineViewBasePointAlias();
final ColumnRealName columnRealName = ColumnRealName.create(inlineBaseAlias, columnSqlName);
doRegisterWhereClause(clauseList, columnRealName, key, value, cipher, option, true, false);
}
public void registerBaseTableInlineWhereClause(String value) {
final List clauseList = getBaseTableInlineWhereClauseList4Register();
doRegisterWhereClause(clauseList, value);
}
protected List getBaseTableInlineWhereClauseList4Register() {
if (_orScopeQueryEffective) {
return getTmpOrBaseTableInlineWhereList();
} else {
return getBaseTableInlineWhereList();
}
}
protected List getBaseTableInlineWhereList() {
if (_baseTableInlineWhereList == null) {
_baseTableInlineWhereList = new ArrayList(2);
}
return _baseTableInlineWhereList;
}
public boolean hasBaseTableInlineWhereClause() {
return _baseTableInlineWhereList != null && !_baseTableInlineWhereList.isEmpty();
}
public void clearBaseTableInlineWhereClause() {
if (_baseTableInlineWhereList != null) {
_baseTableInlineWhereList.clear();
}
}
// -----------------------------------------------------
// In-line for Outer Join
// ----------------------
public void registerOuterJoinInlineWhereClause(String foreignAliasName // foreign alias of column
, ColumnSqlName columnSqlName // SQL name of column
, ConditionKey key, ConditionValue value // basic resources
, ColumnFunctionCipher cipher, ConditionOption option // optional resources
, boolean onClause) {
assertNotYetOuterJoin(foreignAliasName);
final List clauseList = getOuterJoinInlineWhereClauseList4Register(foreignAliasName, onClause);
final String tableAliasName = onClause ? foreignAliasName : getInlineViewBasePointAlias();
final ColumnRealName columnRealName = ColumnRealName.create(tableAliasName, columnSqlName);
doRegisterWhereClause(clauseList, columnRealName, key, value, cipher, option, true, onClause);
}
public void registerOuterJoinInlineWhereClause(String foreignAliasName, String clause, boolean onClause) {
assertNotYetOuterJoin(foreignAliasName);
final List clauseList = getOuterJoinInlineWhereClauseList4Register(foreignAliasName, onClause);
doRegisterWhereClause(clauseList, clause);
}
protected List getOuterJoinInlineWhereClauseList4Register(String foreignAliasName, boolean onClause) {
final LeftOuterJoinInfo joinInfo = getOuterJoinMap().get(foreignAliasName);
final List clauseList;
if (onClause) {
if (_orScopeQueryEffective) {
clauseList = getTmpOrAdditionalOnClauseList(foreignAliasName);
} else {
clauseList = joinInfo.getAdditionalOnClauseList();
}
} else {
if (_orScopeQueryEffective) {
clauseList = getTmpOrOuterJoinInlineClauseList(foreignAliasName);
} else {
clauseList = joinInfo.getInlineWhereClauseList();
}
}
return clauseList;
}
protected void assertNotYetOuterJoin(String aliasName) {
if (!getOuterJoinMap().containsKey(aliasName)) {
String msg = "The alias name have not registered in outer join yet: " + aliasName;
throw new IllegalStateException(msg);
}
}
public boolean hasOuterJoinInlineWhereClause() {
if (_outerJoinMap == null) {
return false;
}
for (Entry entry : _outerJoinMap.entrySet()) {
final LeftOuterJoinInfo joinInfo = entry.getValue();
if (joinInfo.hasInlineOrOnClause()) { // contains on-clause condition
return true;
}
}
return false;
}
public void clearOuterJoinInlineWhereClause() {
if (_outerJoinMap == null) {
return;
}
for (Entry entry : _outerJoinMap.entrySet()) {
final LeftOuterJoinInfo joinInfo = entry.getValue();
if (joinInfo.hasInlineOrOnClause()) {
joinInfo.getInlineWhereClauseList().clear();
joinInfo.getAdditionalOnClauseList().clear(); // contains on-clause condition
}
}
}
// -----------------------------------------------------
// Assist Helper
// -------------
protected void doRegisterWhereClause(List clauseList // the list of query clause
, ColumnRealName columnRealName, ConditionKey key, ConditionValue value // basic resources
, ColumnFunctionCipher cipher, ConditionOption option // optional resources
, final boolean inline, final boolean onClause) {
key.addWhereClause(new QueryModeProvider() {
public boolean isOrScopeQuery() {
return isOrScopeQueryEffective();
}
public boolean isInline() {
return inline;
}
public boolean isOnClause() {
return onClause;
}
}, clauseList, columnRealName, value, cipher, option);
markOrScopeQueryAndPart(clauseList);
}
protected void doRegisterWhereClause(List clauseList, String clause) {
doRegisterWhereClause(clauseList, new StringQueryClause(clause));
}
protected void doRegisterWhereClause(List clauseList, QueryClause clause) {
clauseList.add(clause);
markOrScopeQueryAndPart(clauseList);
}
// ===================================================================================
// OrScopeQuery
// ============
public void beginOrScopeQuery() {
final OrScopeQueryInfo tmpOrScopeQueryInfo = new OrScopeQueryInfo();
if (_currentTmpOrScopeQueryInfo != null) {
_currentTmpOrScopeQueryInfo.addChildInfo(tmpOrScopeQueryInfo);
}
_currentTmpOrScopeQueryInfo = tmpOrScopeQueryInfo;
_orScopeQueryEffective = true;
}
public void endOrScopeQuery() {
assertCurrentTmpOrScopeQueryInfo();
final OrScopeQueryInfo parentInfo = _currentTmpOrScopeQueryInfo.getParentInfo();
if (parentInfo != null) {
_currentTmpOrScopeQueryInfo = parentInfo;
} else {
reflectTmpOrClauseToRealObject(_currentTmpOrScopeQueryInfo);
clearOrScopeQuery();
}
}
protected void clearOrScopeQuery() {
_currentTmpOrScopeQueryInfo = null;
_orScopeQueryEffective = false;
_orScopeQueryAndPartEffective = false;
}
protected void reflectTmpOrClauseToRealObject(OrScopeQueryInfo localInfo) {
final OrScopeQueryReflector reflector = createOrClauseReflector();
reflector.reflectTmpOrClauseToRealObject(localInfo);
}
protected OrScopeQueryReflector createOrClauseReflector() {
return new OrScopeQueryReflector(getWhereList(), getBaseTableInlineWhereList(), getOuterJoinMap());
}
public boolean isOrScopeQueryEffective() {
return _orScopeQueryEffective;
}
public boolean isOrScopeQueryAndPartEffective() {
return _orScopeQueryAndPartEffective;
}
protected List getTmpOrWhereList() {
assertCurrentTmpOrScopeQueryInfo();
return _currentTmpOrScopeQueryInfo.getTmpOrWhereList();
}
protected List getTmpOrBaseTableInlineWhereList() {
assertCurrentTmpOrScopeQueryInfo();
return _currentTmpOrScopeQueryInfo.getTmpOrBaseTableInlineWhereList();
}
protected List getTmpOrAdditionalOnClauseList(String aliasName) {
assertCurrentTmpOrScopeQueryInfo();
return _currentTmpOrScopeQueryInfo.getTmpOrAdditionalOnClauseList(aliasName);
}
protected List getTmpOrOuterJoinInlineClauseList(String aliasName) {
assertCurrentTmpOrScopeQueryInfo();
return _currentTmpOrScopeQueryInfo.getTmpOrOuterJoinInlineClauseList(aliasName);
}
public void beginOrScopeQueryAndPart() {
assertCurrentTmpOrScopeQueryInfo();
++_orScopeQueryAndPartIdentity;
_orScopeQueryAndPartEffective = true;
}
public void endOrScopeQueryAndPart() {
assertCurrentTmpOrScopeQueryInfo();
_orScopeQueryAndPartEffective = false;
}
protected void markOrScopeQueryAndPart(List clauseList) {
if (_orScopeQueryEffective && _orScopeQueryAndPartEffective && !clauseList.isEmpty()) {
final QueryClause original = clauseList.remove(clauseList.size() - 1); // as latest
clauseList.add(new OrScopeQueryAndPartQueryClause(original, _orScopeQueryAndPartIdentity));
}
}
protected void assertCurrentTmpOrScopeQueryInfo() {
if (_currentTmpOrScopeQueryInfo == null) {
String msg = "The attribute 'currentTmpOrScopeQueryInfo' should not be null in or-scope query:";
msg = msg + " orScopeQueryEffective=" + _orScopeQueryEffective;
throw new IllegalStateException(msg);
}
}
// ===================================================================================
// OrderBy
// =======
public OrderByClause getOrderByComponent() {
return getOrderBy();
}
protected OrderByClause getOrderBy() {
if (_orderByClause == null) {
_orderByClause = new OrderByClause();
}
return _orderByClause;
}
public OrderByElement getOrderByLastElement() {
if (_orderByClause == null) {
return null;
}
return _orderByClause.getOrderByLastElement();
}
public void clearOrderBy() {
_orderByEffective = false;
getOrderBy().clear();
}
public void suppressOrderBy() {
_orderByEffective = false;
}
public void reviveOrderBy() {
if (hasOrderByClause()) {
_orderByEffective = true;
}
}
public void registerOrderBy(String orderByProperty, boolean ascOrDesc, ColumnInfo columnInfo) {
doRegisterOrderBy(orderByProperty, ascOrDesc, columnInfo, false);
}
public void registerSpecifiedDerivedOrderBy(String orderByProperty, boolean ascOrDesc) {
final HpDerivingSubQueryInfo specifiedDerivingInfo = getSpecifiedDerivingInfo(orderByProperty);
if (specifiedDerivingInfo == null) { // basically no way because of already checked
String msg = "The deriving column was not found by the property: " + orderByProperty;
throw new IllegalStateException(msg);
}
final ColumnInfo columnInfo = specifiedDerivingInfo.extractDerivingColumnInfo();
doRegisterOrderBy(orderByProperty, ascOrDesc, columnInfo, true);
}
protected void doRegisterOrderBy(String orderByProperty, boolean ascOrDesc, ColumnInfo columnInfo, boolean derived) {
try {
_orderByEffective = true;
final List orderByList = new ArrayList();
{
final StringTokenizer st = new StringTokenizer(orderByProperty, "/");
while (st.hasMoreElements()) {
orderByList.add(st.nextToken());
}
}
for (String orderBy : orderByList) {
_orderByEffective = true;
final String aliasName;
final String columnName;
if (orderBy.indexOf(".") < 0) {
aliasName = null;
columnName = orderBy;
} else {
aliasName = orderBy.substring(0, orderBy.lastIndexOf("."));
columnName = orderBy.substring(orderBy.lastIndexOf(".") + 1);
}
final OrderByElement element = newOrderByElement(columnInfo, derived, aliasName, columnName);
if (ascOrDesc) {
element.setupAsc();
} else {
element.setupDesc();
}
element.setGearedCipherManager(_gearedCipherManager);
getOrderBy().addOrderByElement(element);
}
} catch (RuntimeException e) {
String msg = "Failed to register order-by:";
msg = msg + " orderByProperty=" + orderByProperty + " ascOrDesc=" + ascOrDesc;
msg = msg + " table=" + _tableDbName;
throw new IllegalStateException(msg, e);
}
}
protected OrderByElement newOrderByElement(ColumnInfo columnInfo, boolean derived, String aliasName, String columnName) {
return new OrderByElement(aliasName, columnName, columnInfo, derived);
}
public void addNullsFirstToPreviousOrderBy() {
getOrderBy().addNullsFirstToPreviousOrderByElement(createOrderByNullsSetupper());
}
public void addNullsLastToPreviousOrderBy() {
getOrderBy().addNullsLastToPreviousOrderByElement(createOrderByNullsSetupper());
}
protected OrderByClause.OrderByNullsSetupper createOrderByNullsSetupper() { // as default
return new OrderByClause.OrderByNullsSetupper() {
public String setup(String columnName, String orderByElementClause, boolean nullsFirst) {
return orderByElementClause + " nulls " + (nullsFirst ? "first" : "last");
}
};
}
protected OrderByClause.OrderByNullsSetupper createOrderByNullsSetupperByCaseWhen() { // helper for nulls unsupported DBMS
return new OrderByClause.OrderByNullsSetupper() {
public String setup(String columnName, String orderByElementClause, boolean nullsFirst) {
final String thenNumber = nullsFirst ? "1" : "0";
final String elseNumber = nullsFirst ? "0" : "1";
final String caseWhen = "case when " + columnName + " is not null then " + thenNumber + " else " + elseNumber + " end asc";
return caseWhen + ", " + orderByElementClause;
}
};
}
public void addManualOrderToPreviousOrderByElement(ManualOrderOption manualOrderOption) {
assertObjectNotNull("manualOrderOption", manualOrderOption);
getOrderBy().addManualOrderByElement(manualOrderOption);
}
public boolean hasOrderByClause() {
return _orderByClause != null && !_orderByClause.isEmpty();
}
public boolean hasSpecifiedDerivedOrderByClause() {
if (!hasOrderByClause()) {
return false;
}
final List orderByList = _orderByClause.getOrderByList();
for (OrderByElement orderByElement : orderByList) {
if (orderByElement.isDerivedOrderBy()) {
return true;
}
}
return false;
}
protected boolean isSpecifiedDerivedOrderBy(String derivedAliasName) {
if (!hasOrderByClause()) {
return false;
}
final List orderByList = _orderByClause.getOrderByList();
for (OrderByElement orderByElement : orderByList) {
if (orderByElement.isDerivedOrderBy()) {
if (orderByElement.getColumnName().equals(derivedAliasName)) {
return true;
}
}
}
return false;
}
// ===================================================================================
// UnionQuery
// ==========
public void registerUnionQuery(UnionClauseProvider unionClauseProvider, boolean unionAll) {
assertObjectNotNull("unionClauseProvider", unionClauseProvider);
UnionQueryInfo unionQueryInfo = new UnionQueryInfo();
unionQueryInfo.setUnionClauseProvider(unionClauseProvider);
unionQueryInfo.setUnionAll(unionAll);
addUnionQueryInfo(unionQueryInfo);
}
protected void addUnionQueryInfo(UnionQueryInfo unionQueryInfo) {
if (_unionQueryInfoList == null) {
_unionQueryInfoList = new ArrayList();
}
_unionQueryInfoList.add(unionQueryInfo);
}
public boolean hasUnionQuery() {
return _unionQueryInfoList != null && !_unionQueryInfoList.isEmpty();
}
public void clearUnionQuery() {
if (_unionQueryInfoList != null) {
_unionQueryInfoList.clear();
}
}
protected static class UnionQueryInfo {
protected UnionClauseProvider _unionClauseProvider;
protected boolean _unionAll;
public UnionClauseProvider getUnionClauseProvider() {
return _unionClauseProvider;
}
public void setUnionClauseProvider(UnionClauseProvider unionClauseProvider) {
_unionClauseProvider = unionClauseProvider;
}
public boolean isUnionAll() {
return _unionAll;
}
public void setUnionAll(boolean unionAll) {
_unionAll = unionAll;
}
}
// ===================================================================================
// FetchScope
// ==========
/**
* {@inheritDoc}
*/
public void fetchFirst(int fetchSize) {
_fetchScopeEffective = true;
if (fetchSize <= 0) {
String msg = "Argument[fetchSize] should be plus: " + fetchSize;
throw new IllegalArgumentException(msg);
}
_fetchStartIndex = 0;
_fetchSize = fetchSize;
_fetchPageNumber = 1;
doClearFetchPageClause();
doFetchFirst();
}
/**
* {@inheritDoc}
*/
public void fetchScope(int fetchStartIndex, int fetchSize) {
_fetchScopeEffective = true;
if (fetchStartIndex < 0) {
String msg = "Argument[fetchStartIndex] must be plus or zero: " + fetchStartIndex;
throw new IllegalArgumentException(msg);
}
if (fetchSize <= 0) {
String msg = "Argument[fetchSize] should be plus: " + fetchSize;
throw new IllegalArgumentException(msg);
}
_fetchStartIndex = fetchStartIndex;
_fetchSize = fetchSize;
fetchPage(1);
}
/**
* {@inheritDoc}
*/
public void fetchPage(int fetchPageNumber) {
_fetchScopeEffective = true;
if (fetchPageNumber <= 0) {
fetchPageNumber = 1;
}
if (_fetchSize <= 0) {
throwFetchSizeNotPlusException(fetchPageNumber);
}
_fetchPageNumber = fetchPageNumber;
if (_fetchPageNumber == 1 && _fetchStartIndex == 0) {
fetchFirst(_fetchSize);
}
doClearFetchPageClause();
doFetchPage();
}
protected void throwFetchSizeNotPlusException(int fetchPageNumber) { // as system exception
String msg = "Look! Read the message below." + ln();
msg = msg + "/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *" + ln();
msg = msg + "Fetch size should not be minus or zero!" + ln();
msg = msg + ln();
msg = msg + "[Fetch Size]" + ln();
msg = msg + "fetchSize=" + _fetchSize + ln();
msg = msg + ln();
msg = msg + "[Fetch Page Number]" + ln();
msg = msg + "fetchPageNumber=" + fetchPageNumber + ln();
msg = msg + "* * * * * * * * * */";
throw new IllegalStateException(msg);
}
protected abstract void doFetchFirst();
protected abstract void doFetchPage();
protected abstract void doClearFetchPageClause();
protected class RownumPagingProcessor {
protected String _rownumExpression;
protected String _selectHint = "";
protected String _sqlSuffix = "";
protected Integer _pagingBindFrom;
protected Integer _pagingBindTo;
protected boolean _bind;
public RownumPagingProcessor(String rownumExpression) {
_rownumExpression = rownumExpression;
}
public void useBindVariable() {
_bind = true;
}
public void processRowNumberPaging() {
final boolean offset = isFetchStartIndexSupported();
final boolean limit = isFetchSizeSupported();
if (!offset && !limit) {
return;
}
final StringBuilder hintSb = new StringBuilder();
final String rownum = _rownumExpression;
hintSb.append(" *").append(ln());
hintSb.append(" from (").append(ln());
hintSb.append("select plain.*, ").append(rownum).append(" as rn").append(ln());
hintSb.append(" from (").append(ln());
hintSb.append("select"); // main select
final StringBuilder suffixSb = new StringBuilder();
final String fromEnd = " ) plain" + ln() + " ) ext" + ln();
if (offset) {
final int pageStartIndex = getPageStartIndex();
_pagingBindFrom = pageStartIndex;
final String exp = _bind ? "/*pmb.sqlClause.pagingBindFrom*/" : String.valueOf(pageStartIndex);
suffixSb.append(fromEnd).append(" where ext.rn > ").append(exp);
}
if (limit) {
final int pageEndIndex = getPageEndIndex();
_pagingBindTo = pageEndIndex;
final String exp = _bind ? "/*pmb.sqlClause.pagingBindTo*/" : String.valueOf(pageEndIndex);
if (offset) {
suffixSb.append(ln()).append(" and ext.rn <= ").append(exp);
} else {
suffixSb.append(fromEnd).append(" where ext.rn <= ").append(exp);
}
}
_selectHint = hintSb.toString();
_sqlSuffix = suffixSb.toString();
}
public String getSelectHint() {
return _selectHint;
}
public String getSqlSuffix() {
return _sqlSuffix;
}
public Integer getPagingBindFrom() {
return _pagingBindFrom;
}
public Integer getPagingBindTo() {
return _pagingBindTo;
}
}
public int getFetchStartIndex() {
return _fetchStartIndex;
}
public int getFetchSize() {
return _fetchSize;
}
public int getFetchPageNumber() {
return _fetchPageNumber;
}
/**
* @return Page start index. 0 origin. (NotMinus)
*/
public int getPageStartIndex() {
if (_fetchPageNumber <= 0) {
String msg = "_fetchPageNumber must be plus: " + _fetchPageNumber;
throw new IllegalStateException(msg);
}
return _fetchStartIndex + (_fetchSize * (_fetchPageNumber - 1));
}
/**
* @return Page end index. 0 origin. (NotMinus)
*/
public int getPageEndIndex() {
if (_fetchPageNumber <= 0) {
String msg = "_fetchPageNumber must be plus: " + _fetchPageNumber;
throw new IllegalStateException(msg);
}
return _fetchStartIndex + (_fetchSize * _fetchPageNumber);
}
public void suppressFetchScope() {
_fetchScopeEffective = false;
doClearFetchPageClause();
}
public void reviveFetchScope() {
if (getFetchSize() > 0 && getFetchPageNumber() > 0) {
fetchPage(getFetchPageNumber());
}
}
public boolean isFetchScopeEffective() {
return _fetchScopeEffective;
}
public boolean isFetchStartIndexSupported() {
return true; // as default
}
public boolean isFetchSizeSupported() {
return true; // as default
}
protected abstract String createSelectHint();
protected abstract String createFromBaseTableHint();
protected abstract String createFromHint();
protected abstract String createSqlSuffix();
// ===================================================================================
// Fetch Narrowing
// ===============
/** {@inheritDoc} */
public int getFetchNarrowingSkipStartIndex() {
return getPageStartIndex();
}
/** {@inheritDoc} */
public int getFetchNarrowingLoopCount() {
return getFetchSize();
}
/** {@inheritDoc} */
public boolean isFetchNarrowingEffective() {
return _fetchScopeEffective;
}
// ===================================================================================
// Table Alias Info
// ================
/** {@inheritDoc} */
public String getBasePointAliasName() {
// the variable should be resolved when making a sub-query clause
return isForSubQuery() ? "sub" + getSubQueryLevel() + "loc" : BASE_POINT_ALIAS_NAME;
}
/** {@inheritDoc} */
public String resolveJoinAliasName(String relationPath, int nestLevel) {
return (isForSubQuery() ? "sub" + getSubQueryLevel() : "df") + "rel" + relationPath;
// nestLevel is unused because relationPath has same role
// (that was used long long ago)
}
/** {@inheritDoc} */
public int resolveRelationNo(String localTableName, String foreignPropertyName) {
final DBMeta dbmeta = findDBMeta(localTableName);
final ForeignInfo foreignInfo = dbmeta.findForeignInfo(foreignPropertyName);
return foreignInfo.getRelationNo();
}
/** {@inheritDoc} */
public String getInlineViewBasePointAlias() {
return "dfinlineloc";
}
/** {@inheritDoc} */
public String getUnionQueryInlineViewAlias() {
return "dfunionview";
}
/** {@inheritDoc} */
public String getDerivedReferrerNestedAlias() {
return "dfrefview";
}
/** {@inheritDoc} */
public String getScalarSelectColumnAlias() {
return "dfscalar";
}
// ===================================================================================
// Template Mark
// =============
public String getWhereClauseMark() {
return "#df:whereClause#";
}
public String getWhereFirstConditionMark() {
return "#df:whereFirstCondition#";
}
public String getUnionSelectClauseMark() {
return "#df:unionSelectClause#";
}
public String getUnionWhereClauseMark() {
return "#df:unionWhereClause#";
}
public String getUnionWhereFirstConditionMark() {
return "#df:unionWhereFirstCondition#";
}
// ===================================================================================
// Sub Query Indent
// ================
public String resolveSubQueryBeginMark(String subQueryIdentity) {
return getSubQueryIndentProcessor().resolveSubQueryBeginMark(subQueryIdentity);
}
public String resolveSubQueryEndMark(String subQueryIdentity) {
return getSubQueryIndentProcessor().resolveSubQueryEndMark(subQueryIdentity);
}
public String processSubQueryIndent(String sql) {
return processSubQueryIndent(sql, "", sql);
}
protected String processSubQueryIndent(String sql, String preIndent, String originalSql) {
return getSubQueryIndentProcessor().processSubQueryIndent(sql, preIndent, originalSql);
}
protected SubQueryIndentProcessor getSubQueryIndentProcessor() {
if (_subQueryIndentProcessor == null) {
_subQueryIndentProcessor = new SubQueryIndentProcessor();
}
return _subQueryIndentProcessor;
}
// [DBFlute-0.7.4]
// ===================================================================================
// Specification
// =============
// -----------------------------------------------------
// Specify Column
// --------------
public void specifySelectColumn(SpecifiedColumn specifiedColumn) {
if (_specifiedSelectColumnMap == null) {
// should not be flexible to avoid alias conflict (e.g. dfrel_10, dfrel_1_0) by jflute (2020/12/30)
_specifiedSelectColumnMap = StringKeyMap.createAsCaseInsensitive(); // not needs order
}
final String tableAliasName = specifiedColumn.getTableAliasName();
if (!_specifiedSelectColumnMap.containsKey(tableAliasName)) {
// flexible for column name, while may not need order...but no change for now by jflute (2020/12/30)
final Map elementMap = StringKeyMap.createAsFlexibleOrdered();
_specifiedSelectColumnMap.put(tableAliasName, elementMap);
}
final String columnDbName = specifiedColumn.getColumnDbName();
final Map elementMap = _specifiedSelectColumnMap.get(tableAliasName);
elementMap.put(columnDbName, specifiedColumn);
}
public boolean hasSpecifiedSelectColumn(String tableAliasName) {
return _specifiedSelectColumnMap != null && _specifiedSelectColumnMap.containsKey(tableAliasName);
}
public boolean hasSpecifiedSelectColumn(String tableAliasName, String columnDbName) {
if (_specifiedSelectColumnMap == null) {
return false;
}
final Map elementMap = _specifiedSelectColumnMap.get(tableAliasName);
if (elementMap == null) {
return false;
}
return elementMap.containsKey(columnDbName);
}
public void handleSpecifiedSelectColumn(String tableAliasName, SpecifiedSelectColumnHandler columnHandler) {
if (_specifiedSelectColumnMap == null) {
return;
}
final Map elementMap = _specifiedSelectColumnMap.get(tableAliasName);
if (elementMap == null) {
return;
}
for (SpecifiedColumn specifiedColumn : elementMap.values()) {
columnHandler.handle(tableAliasName, specifiedColumn);
}
}
public void backupSpecifiedSelectColumn() {
_backupSpecifiedSelectColumnMap = _specifiedSelectColumnMap;
}
public void restoreSpecifiedSelectColumn() {
_specifiedSelectColumnMap = _backupSpecifiedSelectColumnMap;
_backupSpecifiedSelectColumnMap = null;
}
public void removeSpecifiedSelectColumn(String tableAliasName) {
if (_specifiedSelectColumnMap != null) {
_specifiedSelectColumnMap.remove(tableAliasName);
}
}
public void clearSpecifiedSelectColumn() {
if (_specifiedSelectColumnMap != null) {
_specifiedSelectColumnMap.clear();
_specifiedSelectColumnMap = null;
}
}
// -----------------------------------------------------
// Specified as One
// ----------------
public SpecifiedColumn getSpecifiedColumnAsOne() {
final Map elementMap = getSpecifiedColumnElementMapAsOne();
if (elementMap != null && elementMap.size() == 1) {
return elementMap.values().iterator().next();
}
return null;
}
public String getSpecifiedColumnDbNameAsOne() {
final ColumnInfo columnInfo = getSpecifiedColumnInfoAsOne();
return columnInfo != null ? columnInfo.getColumnDbName() : null;
}
public ColumnInfo getSpecifiedColumnInfoAsOne() {
final Map elementMap = getSpecifiedColumnElementMapAsOne();
if (elementMap != null && elementMap.size() == 1) {
return elementMap.values().iterator().next().getColumnInfo();
}
return null;
}
public ColumnRealName getSpecifiedColumnRealNameAsOne() {
final ColumnSqlName columnSqlName = getSpecifiedColumnSqlNameAsOne();
if (columnSqlName != null) {
return ColumnRealName.create(getSpecifiedColumnTableAliasNameAsOne(), columnSqlName);
}
return null;
}
public ColumnSqlName getSpecifiedColumnSqlNameAsOne() {
final ColumnInfo columnInfo = getSpecifiedColumnInfoAsOne();
return columnInfo != null ? columnInfo.getColumnSqlName() : null;
}
protected String getSpecifiedColumnTableAliasNameAsOne() {
if (_specifiedSelectColumnMap != null && _specifiedSelectColumnMap.size() == 1) {
return _specifiedSelectColumnMap.keySet().iterator().next();
}
return null;
}
protected Map getSpecifiedColumnElementMapAsOne() {
if (_specifiedSelectColumnMap != null && _specifiedSelectColumnMap.size() == 1) {
return _specifiedSelectColumnMap.values().iterator().next();
}
return null;
}
// -----------------------------------------------------
// Specify Deriving
// ----------------
public void specifyDerivingSubQuery(HpDerivingSubQueryInfo subQueryInfo) {
if (_specifiedDerivingSubQueryMap == null) {
_specifiedDerivingSubQueryMap = StringKeyMap.createAsFlexibleOrdered();
}
final String aliasName = subQueryInfo.getAliasName(); // null allowed (treated as null key)
_specifiedDerivingSubQueryMap.put(aliasName, subQueryInfo);
}
public boolean hasSpecifiedDerivingSubQuery() {
return _specifiedDerivingSubQueryMap != null && !_specifiedDerivingSubQueryMap.isEmpty();
}
public boolean hasSpecifiedDerivingSubQuery(String aliasName) {
return _specifiedDerivingSubQueryMap != null && _specifiedDerivingSubQueryMap.containsKey(aliasName);
}
public List getSpecifiedDerivingAliasList() {
if (_specifiedDerivingSubQueryMap == null) {
@SuppressWarnings("unchecked")
final List emptyList = Collections.EMPTY_LIST;
return emptyList;
}
return new ArrayList(_specifiedDerivingSubQueryMap.keySet());
}
public HpDerivingSubQueryInfo getSpecifiedDerivingInfo(String aliasName) {
if (_specifiedDerivingSubQueryMap == null) {
return null;
}
return _specifiedDerivingSubQueryMap.get(aliasName);
}
public ColumnInfo getSpecifiedDerivingColumnInfo(String aliasName) {
final HpDerivingSubQueryInfo derivingInfo = getSpecifiedDerivingInfo(aliasName);
return derivingInfo != null ? derivingInfo.extractDerivingColumnInfo() : null;
}
public void clearSpecifiedDerivingSubQuery() {
if (_specifiedDerivingSubQueryMap != null) {
_specifiedDerivingSubQueryMap.clear();
_specifiedDerivingSubQueryMap = null;
}
}
// -----------------------------------------------------
// Deriving as One
// ---------------
public SpecifiedColumn getSpecifiedDerivingColumnAsOne() {
final HpDerivingSubQueryInfo derivingInfo = getSpecifiedDerivingInfoAsOne();
return derivingInfo != null ? derivingInfo.extractDerivingColumn() : null;
}
public ColumnInfo getSpecifiedDerivingColumnInfoAsOne() {
final HpDerivingSubQueryInfo derivingInfo = getSpecifiedDerivingInfoAsOne();
return derivingInfo != null ? derivingInfo.extractDerivingColumnInfo() : null;
}
public String getSpecifiedDerivingAliasNameAsOne() {
final HpDerivingSubQueryInfo derivingInfo = getSpecifiedDerivingInfoAsOne();
return derivingInfo != null ? derivingInfo.getAliasName() : null;
}
public String getSpecifiedDerivingSubQueryAsOne() {
final HpDerivingSubQueryInfo derivingInfo = getSpecifiedDerivingInfoAsOne();
return derivingInfo != null ? derivingInfo.getDerivingSubQuery() : null;
}
protected HpDerivingSubQueryInfo getSpecifiedDerivingInfoAsOne() {
if (_specifiedDerivingSubQueryMap != null && _specifiedDerivingSubQueryMap.size() == 1) {
return _specifiedDerivingSubQueryMap.values().iterator().next();
}
return null;
}
// -----------------------------------------------------
// Resolved as One
// ---------------
public ColumnSqlName getSpecifiedResolvedColumnSqlNameAsOne() {
final ColumnSqlName specifiedColumn = getSpecifiedColumnSqlNameAsOne();
if (specifiedColumn != null) {
return specifiedColumn;
} else {
final String nestedSubQuery = getSpecifiedDerivingSubQueryAsOne();
if (nestedSubQuery != null) {
return new ColumnSqlName(nestedSubQuery);
} else {
return null;
}
}
}
public ColumnRealName getSpecifiedResolvedColumnRealNameAsOne() {
final ColumnRealName specifiedRealName = getSpecifiedColumnRealNameAsOne();
if (specifiedRealName != null) { // e.g. subCB.specify().column...()
final SpecifiedColumn hpCol = getSpecifiedColumnAsOne();
return filterSpecifyColumnCalculation(specifiedRealName, hpCol);
} else {
final String nestedSubQuery = getSpecifiedDerivingSubQueryAsOne();
if (nestedSubQuery != null) { // e.g. subCB.specify().derived...()
// already resolved in nested process of e.g. derived-referrer
return ColumnRealName.create(null, new ColumnSqlName(nestedSubQuery));
} else {
return null;
}
}
}
protected ColumnRealName filterSpecifyColumnCalculation(ColumnRealName specifiedRealName, SpecifiedColumn hpCol) {
if (hasSpecifyCalculation(hpCol)) {
hpCol.xinitSpecifyCalculation();
final HpCalcSpecification calcSpecification = hpCol.getSpecifyCalculation();
final String statement = calcSpecification.buildStatementToSpecifidName(specifiedRealName.toString());
return ColumnRealName.create(null, new ColumnSqlName(statement));
}
return specifiedRealName;
}
protected boolean hasSpecifyCalculation(SpecifiedColumn hpCol) {
return hpCol != null && hpCol.hasSpecifyCalculation();
}
// ===================================================================================
// Invalid Query Info
// ==================
// -----------------------------------------------------
// NullOrEmpty Query
// -----------------
public void checkNullOrEmptyQuery() {
_nullOrEmptyChecked = true;
}
public void ignoreNullOrEmptyQuery() {
_nullOrEmptyChecked = false;
}
public boolean isNullOrEmptyQueryChecked() {
return _nullOrEmptyChecked;
}
/**
* {@inheritDoc}
*/
public List getInvalidQueryList() {
return new ArrayList(doGetInvalidQueryList());
}
public void saveInvalidQuery(HpInvalidQueryInfo invalidQueryInfo) {
doGetInvalidQueryList().add(invalidQueryInfo);
}
protected List doGetInvalidQueryList() {
if (_invalidQueryList == null) {
_invalidQueryList = new ArrayList();
}
return _invalidQueryList;
}
// -----------------------------------------------------
// Empty String
// ------------
public void enableEmptyStringQuery() {
_emptyStringQueryAllowed = true;
}
public void disableEmptyStringQuery() {
_emptyStringQueryAllowed = false;
}
public boolean isEmptyStringQueryAllowed() {
return _emptyStringQueryAllowed;
}
// -----------------------------------------------------
// Overriding Query
// ----------------
public void enableOverridingQuery() {
_overridingQueryAllowed = true;
}
public void disableOverridingQuery() {
_overridingQueryAllowed = false;
}
public boolean isOverridingQueryAllowed() {
return _overridingQueryAllowed;
}
// ===================================================================================
// Where Clause Simple Filter
// ==========================
public void addWhereClauseSimpleFilter(QueryClauseFilter whereClauseSimpleFilter) {
if (_whereClauseSimpleFilterList == null) {
_whereClauseSimpleFilterList = new ArrayList();
}
_whereClauseSimpleFilterList.add(whereClauseSimpleFilter);
}
protected String filterWhereClauseSimply(String clauseElement) {
if (_whereClauseSimpleFilterList == null || _whereClauseSimpleFilterList.isEmpty()) {
return clauseElement;
}
for (final Iterator ite = _whereClauseSimpleFilterList.iterator(); ite.hasNext();) {
final QueryClauseFilter filter = ite.next();
if (filter == null) {
String msg = "The list of filter should not have null: _whereClauseSimpleFilterList=" + _whereClauseSimpleFilterList;
throw new IllegalStateException(msg);
}
clauseElement = filter.filterClauseElement(clauseElement);
}
return clauseElement;
}
// [DBFlute-0.8.6]
// ===================================================================================
// Select Clause Type
// ==================
public void classifySelectClauseType(SelectClauseType selectClauseType) {
changeSelectClauseType(selectClauseType);
}
protected void changeSelectClauseType(SelectClauseType selectClauseType) {
savePreviousSelectClauseType();
_selectClauseType = selectClauseType;
}
protected void savePreviousSelectClauseType() {
_previousSelectClauseType = _selectClauseType;
}
public void rollbackSelectClauseType() {
_selectClauseType = _previousSelectClauseType != null ? _previousSelectClauseType : DEFAULT_SELECT_CLAUSE_TYPE;
}
// [DBFlute-0.9.8.6]
// ===================================================================================
// ColumnQuery Object
// ==================
/** {@inheritDoc} */
public Map getColumnQueryObjectMap() {
return _columyQueryObjectMap;
}
/** {@inheritDoc} */
public String registerColumnQueryObjectToThemeList(String themeKey, Object addedValue) {
if (_columyQueryObjectMap == null) {
_columyQueryObjectMap = new LinkedHashMap();
}
final int listIndex = doAddValueToThemeList(themeKey, addedValue, _columyQueryObjectMap);
return buildColumnQueryObjectBindExp(themeKey + ".get(" + listIndex + ")");
}
protected String buildColumnQueryObjectBindExp(String relativePath) {
// no end mark because the path is continued
return "/*pmb.conditionQuery.colQyCBMap." + relativePath + ".conditionQuery.";
}
// [DBFlute-0.9.8.6]
// ===================================================================================
// ManualOrder Parameter
// =====================
/**
* {@inheritDoc}
*/
public Map getManualOrderParameterMap() {
return _manualOrderParameterMap;
}
/**
* {@inheritDoc}
*/
public String registerManualOrderParameterToThemeList(String themeKey, Object addedValue) {
if (_manualOrderParameterMap == null) {
_manualOrderParameterMap = new LinkedHashMap();
}
final int listIndex = doAddValueToThemeList(themeKey, addedValue, _manualOrderParameterMap);
return buildManualOrderParameterBindExp(themeKey + ".get(" + listIndex + ")");
}
protected String buildManualOrderParameterBindExp(String relativePath) {
return "/*pmb.conditionQuery.mnuOdrPrmMap." + relativePath + "*/null";
}
// [DBFlute-0.9.8.2]
// ===================================================================================
// Free Parameter
// ==============
/**
* {@inheritDoc}
*/
public Map getFreeParameterMap() {
return _freeParameterMap;
}
/**
* {@inheritDoc}
*/
public String registerFreeParameterToThemeList(String themeKey, Object addedValue) {
if (_freeParameterMap == null) {
_freeParameterMap = new LinkedHashMap();
}
final int listIndex = doAddValueToThemeList(themeKey, addedValue, _freeParameterMap);
return buildFreeParameterBindExp(themeKey + ".get(" + listIndex + ")");
}
protected String buildFreeParameterBindExp(String relativePath) {
return "/*pmb.conditionQuery.freePrmMap." + relativePath + "*/null";
}
protected int doAddValueToThemeList(String themeKey, Object addedValue, Map map) {
@SuppressWarnings("unchecked")
List © 2015 - 2025 Weber Informatics LLC | Privacy Policy