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);
}
/**
* 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);
}
/**
* 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);
}
/**
* 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);
}
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);
}