Examples with DerivedReferrerOption org.dbflute.cbean.coption.DerivedReferrerOption used on opensource projects

Example 1 with DerivedReferrerOption

use of org.dbflute.cbean.coption.DerivedReferrerOption in project dbflute-core by dbflute.

the class AbstractConditionQuery method registerQueryDerivedReferrer.

// [DBFlute-0.8.8.1]
// ===================================================================================
// (Query)DerivedReferrer
// ======================
protected void registerQueryDerivedReferrer(String function, ConditionQuery subQuery, String columnDbName, String relatedColumnDbName, String propertyName, String referrerPropertyName, String operand, Object value, String parameterPropertyName, DerivedReferrerOption option) {
    final DerivedReferrerOption realOp = option != null ? option : newDefaultDerivedReferrerOption();
    doRegisterQueryDerivedReferrer(function, subQuery, columnDbName, relatedColumnDbName, propertyName, referrerPropertyName, operand, value, parameterPropertyName, realOp);
}

Example 2 with DerivedReferrerOption

use of org.dbflute.cbean.coption.DerivedReferrerOption in project dbflute-core by dbflute.

the class AbstractConditionQuery method doRegisterQueryDerivedReferrer.

protected void doRegisterQueryDerivedReferrer(String function, final ConditionQuery subQuery, String columnDbName, String relatedColumnDbName, String propertyName, String referrerPropertyName, String operand, Object value, String parameterPropertyName, DerivedReferrerOption option) {
    assertFunctionNotNull("QueryDerivedReferrer", columnDbName, function);
    assertSubQueryNotNull("QueryDerivedReferrer", columnDbName, subQuery);
    option.xacceptBaseCB(xgetBaseCB());
    if (isDerivedReferrerSelectAllPossible(subQuery, option)) {
        createCBExThrower().throwQueryDerivedReferrerSelectAllPossibleException(function, subQuery);
    }
    final SubQueryPath subQueryPath = new SubQueryPath(xgetLocation(propertyName));
    final GeneralColumnRealNameProvider localRealNameProvider = new GeneralColumnRealNameProvider();
    final int subQueryLevel = subQuery.xgetSqlClause().getSubQueryLevel();
    final SqlClause subQueryClause = subQuery.xgetSqlClause();
    final String subQueryIdentity = propertyName + "[" + subQueryLevel + "]";
    final ColumnSqlNameProvider subQuerySqlNameProvider = dbName -> subQuery.toColumnSqlName(dbName);
    final DBMeta subQueryDBMeta = findDBMeta(subQuery.asTableDbName());
    final GearedCipherManager cipherManager = xgetSqlClause().getGearedCipherManager();
    final String mainSubQueryIdentity = propertyName + "[" + subQueryLevel + ":subquerymain]";
    final String parameterPath = xgetLocation(parameterPropertyName);
    final QueryDerivedReferrer derivedReferrer = option.createQueryDerivedReferrer(subQueryPath, localRealNameProvider, subQuerySqlNameProvider, subQueryLevel, subQueryClause, subQueryIdentity, subQueryDBMeta, cipherManager, mainSubQueryIdentity, operand, value, parameterPath);
    xregisterParameterOption(option);
    final String correlatedFixedCondition = xbuildReferrerCorrelatedFixedCondition(subQuery, referrerPropertyName);
    final String clause = derivedReferrer.buildDerivedReferrer(function, columnDbName, relatedColumnDbName, correlatedFixedCondition, option);
    // /= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
    // is null or null-revived conversion (coalesce) -> no way to be inner
    // 
    // for example, the following SQL is no way to be inner
    // (suppose if PURCHASE refers WITHDRAWAL)
    // 
    // select mb.MEMBER_ID, mb.MEMBER_NAME
    // , mb.MEMBER_STATUS_CODE, wd.MEMBER_ID as WD_MEMBER_ID
    // from MEMBER mb
    // left outer join MEMBER_WITHDRAWAL wd on mb.MEMBER_ID = wd.MEMBER_ID
    // where (select max(pc.PURCHASE_PRICE)
    // from PURCHASE pc
    // where pc.MEMBER_ID = wd.MEMBER_ID -- may null
    // ) is null
    // order by mb.MEMBER_ID
    // 
    // and using coalesce means it may select records that have null value
    // so using coalesce is no way in spite of operand
    // = = = = = = = = = =/
    final boolean noWayInner = HpQDRParameter.isOperandIsNull(operand) || option.mayNullRevived();
    registerWhereClause(clause, noWayInner);
}

Example 3 with DerivedReferrerOption

use of org.dbflute.cbean.coption.DerivedReferrerOption in project dbflute-core by dbflute.

the class AbstractConditionQuery method resolveMyselfDerivedReferrerOption.

protected DerivedReferrerOption resolveMyselfDerivedReferrerOption(DerivedReferrerOption option) {
    final DerivedReferrerOption resolvedOption = option != null ? option : newDefaultDerivedReferrerOption();
    resolvedOption.suppressCorrelation();
    return resolvedOption;
}

Example 4 with DerivedReferrerOption

use of org.dbflute.cbean.coption.DerivedReferrerOption in project dbflute-core by dbflute.

the class HpQDRFunction method max.

/**
 * An overload method for max(). So refer to the method's java-doc about basic info.
 * <pre>
 * cb.query().derivedPurchaseList().<span style="color: #CC4747">max</span>(<span style="color: #553000">purchaseCB</span> <span style="color: #90226C; font-weight: bold"><span style="font-size: 120%">-</span>&gt;</span> {
 *     <span style="color: #553000">purchaseCB</span>.specify().<span style="color: #994747">columnPurchasePrice</span>(); <span style="color: #3F7E5E">// *Point</span>
 *     <span style="color: #553000">purchaseCB</span>.query().setPaymentCompleteFlg_Equal_True();
 * }).<span style="color: #994747">greaterEqual</span>(123, <span style="color: #553000">op</span> <span style="color: #90226C; font-weight: bold"><span style="font-size: 120%">-</span>&gt;</span> <span style="color: #553000">op</span>.<span style="color: #CC4747">coalesce</span>(0));
 * </pre>
 * @param derivedCBLambda The callback for sub-query of referrer. (NotNull)
 * @param opLambda The callback for option of DerivedReferrer. For example, you can use a coalesce function. (NotNull)
 * @return The parameter for comparing with scalar. (NotNull)
 */
public HpQDRParameter<CB, Object> max(SubQuery<CB> derivedCBLambda, FunctionFilterOptionCall<DerivedReferrerOption> opLambda) {
    assertDerivedReferrerOption(opLambda);
    final DerivedReferrerOption option = createDerivedReferrerOption();
    opLambda.callback(option);
    return doMax(derivedCBLambda, option);
}

Example 5 with DerivedReferrerOption

use of org.dbflute.cbean.coption.DerivedReferrerOption in project dbflute-core by dbflute.

the class HpQDRFunction method count.

/**
 * An overload method for count(). So refer to the method's java-doc about basic info.
 * <pre>
 * cb.query().derivedPurchaseList().<span style="color: #CC4747">count</span>(<span style="color: #553000">purchaseCB</span> <span style="color: #90226C; font-weight: bold"><span style="font-size: 120%">-</span>&gt;</span> {
 *     <span style="color: #553000">purchaseCB</span>.specify().<span style="color: #994747">columnPurchasePrice</span>(); <span style="color: #3F7E5E">// *Point</span>
 *     <span style="color: #553000">purchaseCB</span>.query().setPaymentCompleteFlg_Equal_True();
 * }).<span style="color: #994747">greaterEqual</span>(123, <span style="color: #553000">op</span> <span style="color: #90226C; font-weight: bold"><span style="font-size: 120%">-</span>&gt;</span> <span style="color: #553000">op</span>.<span style="color: #CC4747">coalesce</span>(0));
 * </pre>
 * @param derivedCBLambda The callback for sub-query of referrer. (NotNull)
 * @param opLambda The callback for option of DerivedReferrer. For example, you can use a coalesce function. (NotNull)
 * @return The parameter for comparing with scalar. (NotNull)
 */
public HpQDRParameter<CB, Integer> count(SubQuery<CB> derivedCBLambda, FunctionFilterOptionCall<DerivedReferrerOption> opLambda) {
    assertDerivedReferrerOption(opLambda);
    final DerivedReferrerOption option = createDerivedReferrerOption();
    opLambda.callback(option);
    return doCount(derivedCBLambda, option);
}