public void xqderiveMemberServiceList( String function, SubQuery<MemberServiceCB> subQuery, String operand, Object value, DerivedReferrerOption option) { assertObjectNotNull("subQuery<MemberServiceCB>", subQuery); MemberServiceCB cb = new MemberServiceCB(); cb.xsetupForDerivedReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepServiceRankCode_QueryDerivedReferrer_MemberServiceList( cb.query()); // for saving query-value. String parameterPropertyName = keepServiceRankCode_QueryDerivedReferrer_MemberServiceListParameter(value); registerQueryDerivedReferrer( function, cb.query(), "SERVICE_RANK_CODE", "SERVICE_RANK_CODE", subQueryPropertyName, operand, value, parameterPropertyName, option); }
public void xqderiveMemberAddressList( String function, SubQuery<MemberAddressCB> subQuery, String operand, Object value, DerivedReferrerOption option) { assertObjectNotNull("subQuery<MemberAddressCB>", subQuery); MemberAddressCB cb = new MemberAddressCB(); cb.xsetupForDerivedReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepRegionId_QueryDerivedReferrer_MemberAddressList(cb.query()); // for saving query-value. String parameterPropertyName = keepRegionId_QueryDerivedReferrer_MemberAddressListParameter(value); registerQueryDerivedReferrer( function, cb.query(), "REGION_ID", "REGION_ID", subQueryPropertyName, operand, value, parameterPropertyName, option); }
/** * Prepare for MyselfExists (correlated sub-query). * * @param subCBLambda The implementation of sub-query. (NotNull) */ public void myselfExists(SubQuery<TweetCB> subCBLambda) { assertObjectNotNull("subCBLambda", subCBLambda); TweetCB cb = new TweetCB(); cb.xsetupForMyselfExists(this); lockCall(() -> subCBLambda.query(cb)); String pp = keepMyselfExists(cb.query()); registerMyselfExists(cb.query(), pp); }
/** * Myself InScope (SubQuery). {mainly to avoid CLOB and Union problem or no master table} * * @param subQuery The implementation of sub query. (NotNull) */ public void myselfInScope(SubQuery<ServiceRankCB> subQuery) { assertObjectNotNull("subQuery<ServiceRankCB>", subQuery); ServiceRankCB cb = new ServiceRankCB(); cb.xsetupForMyselfInScope(this); subQuery.query(cb); String subQueryPropertyName = keepMyselfInScope(cb.query()); // for saving query-value. registerMyselfInScope(cb.query(), subQueryPropertyName); }
protected void xscalarCondition(String function, SubQuery<RegionCB> subQuery, String operand) { assertObjectNotNull("subQuery<RegionCB>", subQuery); RegionCB cb = new RegionCB(); cb.xsetupForScalarCondition(this); subQuery.query(cb); String subQueryPropertyName = keepScalarCondition(cb.query()); // for saving query-value. registerScalarCondition(function, cb.query(), subQueryPropertyName, operand); }
// =================================================================================== // MyselfDerived // ============= public void xsmyselfDerive(String fn, SubQuery<TweetCB> sq, String al, DerivedReferrerOption op) { assertObjectNotNull("subQuery", sq); TweetCB cb = new TweetCB(); cb.xsetupForDerivedReferrer(this); lockCall(() -> sq.query(cb)); String pp = keepSpecifyMyselfDerived(cb.query()); String pk = "TWEET_ID"; registerSpecifyMyselfDerived(fn, cb.query(), pk, pk, pp, "myselfDerived", al, op); }
/** * Set up NotInScopeRelation (sub-query). <br> * {not in (select REGION_ID from MEMBER_ADDRESS where ...)} <br> * MEMBER_ADDRESS as 'memberAddressAsOne'. * * @param subQuery The sub-query of MemberAddressList for 'not in-scope'. (NotNull) */ public void notInScopeMemberAddressList(SubQuery<MemberAddressCB> subQuery) { assertObjectNotNull("subQuery<MemberAddressCB>", subQuery); MemberAddressCB cb = new MemberAddressCB(); cb.xsetupForInScopeRelation(this); subQuery.query(cb); String subQueryPropertyName = keepRegionId_NotInScopeRelation_MemberAddressList(cb.query()); // for saving query-value. registerNotInScopeRelation(cb.query(), "REGION_ID", "REGION_ID", subQueryPropertyName); }
/** * Set up ExistsReferrer (co-related sub-query). <br> * {exists (select REGION_ID from MEMBER_ADDRESS where ...)} <br> * MEMBER_ADDRESS as 'memberAddressAsOne'. * * <pre> * cb.query().<span style="color: #FD4747">existsMemberAddressList</span>(new SubQuery<MemberAddressCB>() { * public void query(RegionCB subCB) { * subCB.query().setXxx... * } * }); * </pre> * * @param subQuery The sub-query of MemberAddressList for 'exists'. (NotNull) */ public void existsMemberAddressList(SubQuery<MemberAddressCB> subQuery) { assertObjectNotNull("subQuery<MemberAddressCB>", subQuery); MemberAddressCB cb = new MemberAddressCB(); cb.xsetupForExistsReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepRegionId_ExistsReferrer_MemberAddressList(cb.query()); // for saving query-value. registerExistsReferrer(cb.query(), "REGION_ID", "REGION_ID", subQueryPropertyName); }
@SuppressWarnings("unchecked") protected <CB extends ConditionBean> void xscalarCondition( String fn, SubQuery<CB> sq, String rd, HpSLCCustomized<CB> cs, ScalarConditionOption op) { assertObjectNotNull("subQuery", sq); TweetCB cb = xcreateScalarConditionCB(); sq.query((CB) cb); String pp = keepScalarCondition(cb.query()); // for saving query-value cs.setPartitionByCBean((CB) xcreateScalarConditionPartitionByCB()); // for using partition-by registerScalarCondition(fn, cb.query(), pp, rd, cs, op); }
/** * Set up ExistsReferrer (co-related sub-query). <br> * {exists (select SERVICE_RANK_CODE from MEMBER_SERVICE where ...)} <br> * MEMBER_SERVICE as 'memberServiceAsOne'. * * <pre> * cb.query().<span style="color: #FD4747">existsMemberServiceList</span>(new SubQuery<MemberServiceCB>() { * public void query(ServiceRankCB subCB) { * subCB.query().setXxx... * } * }); * </pre> * * @param subQuery The sub-query of MemberServiceList for 'exists'. (NotNull) */ public void existsMemberServiceList(SubQuery<MemberServiceCB> subQuery) { assertObjectNotNull("subQuery<MemberServiceCB>", subQuery); MemberServiceCB cb = new MemberServiceCB(); cb.xsetupForExistsReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepServiceRankCode_ExistsReferrer_MemberServiceList(cb.query()); // for saving query-value. registerExistsReferrer( cb.query(), "SERVICE_RANK_CODE", "SERVICE_RANK_CODE", subQueryPropertyName); }
/** * Set up NotInScopeRelation (sub-query). <br> * {not in (select SERVICE_RANK_CODE from MEMBER_SERVICE where ...)} <br> * MEMBER_SERVICE as 'memberServiceAsOne'. * * @param subQuery The sub-query of MemberServiceList for 'not in-scope'. (NotNull) */ public void notInScopeMemberServiceList(SubQuery<MemberServiceCB> subQuery) { assertObjectNotNull("subQuery<MemberServiceCB>", subQuery); MemberServiceCB cb = new MemberServiceCB(); cb.xsetupForInScopeRelation(this); subQuery.query(cb); String subQueryPropertyName = keepServiceRankCode_NotInScopeRelation_MemberServiceList( cb.query()); // for saving query-value. registerNotInScopeRelation( cb.query(), "SERVICE_RANK_CODE", "SERVICE_RANK_CODE", subQueryPropertyName); }
@SuppressWarnings("unchecked") protected <CB extends ConditionBean> void xqderiveMyselfDerived( String fn, SubQuery<CB> sq, String rd, Object vl, DerivedReferrerOption op) { assertObjectNotNull("subQuery", sq); TweetCB cb = new TweetCB(); cb.xsetupForDerivedReferrer(this); sq.query((CB) cb); String pk = "TWEET_ID"; String sqpp = keepQueryMyselfDerived(cb.query()); // for saving query-value. String prpp = keepQueryMyselfDerivedParameter(vl); registerQueryMyselfDerived(fn, cb.query(), pk, pk, sqpp, "myselfDerived", rd, vl, prpp, op); }
public void xsderiveMemberAddressList( String function, SubQuery<MemberAddressCB> subQuery, String aliasName, DerivedReferrerOption option) { assertObjectNotNull("subQuery<MemberAddressCB>", subQuery); MemberAddressCB cb = new MemberAddressCB(); cb.xsetupForDerivedReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepRegionId_SpecifyDerivedReferrer_MemberAddressList( cb.query()); // for saving query-value. registerSpecifyDerivedReferrer( function, cb.query(), "REGION_ID", "REGION_ID", subQueryPropertyName, aliasName, option); }
public void xsderiveMemberServiceList( String function, SubQuery<MemberServiceCB> subQuery, String aliasName, DerivedReferrerOption option) { assertObjectNotNull("subQuery<MemberServiceCB>", subQuery); MemberServiceCB cb = new MemberServiceCB(); cb.xsetupForDerivedReferrer(this); subQuery.query(cb); String subQueryPropertyName = keepServiceRankCode_SpecifyDerivedReferrer_MemberServiceList( cb.query()); // for saving query-value. registerSpecifyDerivedReferrer( function, cb.query(), "SERVICE_RANK_CODE", "SERVICE_RANK_CODE", subQueryPropertyName, aliasName, option); }