svnno****@sourc*****
svnno****@sourc*****
2007年 7月 23日 (月) 08:48:49 JST
Revision: 328
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=328
Author: takeharu
Date: 2007-07-23 08:48:44 +0900 (Mon, 23 Jul 2007)
Log Message:
-----------
updated pompei db shema
Modified Paths:
--------------
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsManufacturersBhv.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsAttributesBhv.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsDescriptionBhv.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsToCategoriesBhv.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersDao.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsAttributesDao.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDescriptionDao.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsToCategoriesDao.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturers.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsAttributes.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsDescription.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsToCategories.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturersDbm.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsAttributesDbm.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDescriptionDbm.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsToCategoriesDbm.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsManufacturersCB.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsDescriptionCB.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsToCategoriesCB.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersCQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsDescriptionCQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsToCategoriesCQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturersCQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsDescriptionCQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsToCategoriesCQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersCIQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsDescriptionCIQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsToCategoriesCIQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersNss.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsDescriptionNss.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsToCategoriesNss.java
-------------- next part --------------
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsManufacturersBhv.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsManufacturersBhv.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsManufacturersBhv.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -34,7 +34,7 @@
*
*
* [refferer-property]
- * manufacturersInfoList
+ * manufacturersInfoList, productsList
*
* [sequence]
*
@@ -604,10 +604,156 @@
}
}
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // RefererTable = [PRODUCTS]
+ // RefererProperty = [productsList]
+ // * * * * * * * * */
+
+ /**
+ * Load referer of productsList.
+ * <pre>
+ * You can load referer.
+ *
+ * ex) {Client Example}
+ * final ManufacturersCB cb = new ManufacturersCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Manufacturers> manufacturersList = manufacturersBhv.selectList(cb);
+ * manufacturersBhv.loadProductsList(manufacturersList);
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param manufacturersList Entity list of manufacturers. (NotNull)
+ */
+ public void loadProductsList(java.util.List<Manufacturers> manufacturersList) {
+ final ConditionBeanSetupper<ProductsCB> conditionBeanSetupper = new ConditionBeanSetupper<ProductsCB>() {
+ public void setup(ProductsCB cb) {
+ }
+ };
+ loadProductsList(manufacturersList, conditionBeanSetupper);
+ }
+
+ /**
+ * Load referer of productsList.
+ * <pre>
+ * You can load referer with your original condition.
+ *
+ * ex) {Client Example}: Referer conditions are 'Xxx' is not null and order-by 'Yyy' desc
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * final ManufacturersCB cb = new ManufacturersCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Manufacturers> manufacturersList = manufacturersBhv.selectList(cb);
+ * final ConditionBeanSetupper<ProductsCB> conditionBeanSetupper = new ConditionBeanSetupper<ProductsCB>() {
+ * public void setup(ProductsCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * manufacturersBhv.loadProductsList(manufacturersList, conditionBeanSetupper);
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setManufacturersId_InScope(pkList);
+ * cb.query().addOrderBy_ManufacturersId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param manufacturersList Entity list of manufacturers. (NotNull)
+ * @param conditionBeanSetupper Referer condition setupper instance for registering referer condition. (NotNull)
+ */
+ public void loadProductsList(java.util.List<Manufacturers> manufacturersList, ConditionBeanSetupper<ProductsCB> conditionBeanSetupper) {
+ assertObjectNotNull("manufacturersList<Manufacturers>", manufacturersList);
+ assertObjectNotNull("conditionBeanSetupper<ProductsCB>", conditionBeanSetupper);
+ if (manufacturersList.isEmpty()) {
+ return;
+ }
+ loadProductsList(manufacturersList, new LoadRefererOption<ProductsCB, Products>(conditionBeanSetupper));
+ }
+
+ /**
+ * Load referer of productsList.
+ * <pre>
+ * You can load referer with your original condition.
+ *
+ * ex) {Client Example}: Referer conditions are 'Xxx' is not null and order-by 'Yyy' desc
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * final ManufacturersCB cb = new ManufacturersCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Manufacturers> manufacturersList = manufacturersBhv.selectList(cb);
+ * final ConditionBeanSetupper<ProductsCB> cbSetupper = new ConditionBeanSetupper<ProductsCB>() {
+ * public void setup(ProductsCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * manufacturersBhv.loadProductsList(manufacturersList, new LoadRefererOption<ProductsCB, Products>(cbSetupper));
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setManufacturersId_InScope(pkList);
+ * cb.query().addOrderBy_ManufacturersId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param manufacturersList Entity list of manufacturers. (NotNull)
+ * @param loadRefererOption Load-referer option. (NotNull)
+ */
+ public void loadProductsList(java.util.List<Manufacturers> manufacturersList, LoadRefererOption<ProductsCB, Products> loadRefererOption) {
+ assertObjectNotNull("manufacturersList<Manufacturers>", manufacturersList);
+ assertObjectNotNull("loadRefererOption<Products, ProductsCB>", loadRefererOption);
+ if (manufacturersList.isEmpty()) {
+ return;
+ }
+
+ final java.util.Map<java.math.BigDecimal, Manufacturers> pkMyEntityMap = new java.util.LinkedHashMap<java.math.BigDecimal, Manufacturers>();
+ final java.util.List<java.math.BigDecimal> pkList = new java.util.ArrayList<java.math.BigDecimal>();
+ for (Manufacturers manufacturers : manufacturersList) {
+ pkList.add(manufacturers.getManufacturersId());
+ pkMyEntityMap.put((java.math.BigDecimal)toLowerCaseIfString(manufacturers.getManufacturersId()), manufacturers);
+ }
+ final ProductsBhv refererBhv = getDaoSelector().getBehavior(ProductsBhv.class);
+ final ProductsCB cb = loadRefererOption.getReffererConditionBean() != null ? loadRefererOption.getReffererConditionBean() : refererBhv.newMyConditionBean();
+ cb.query().setManufacturersId_InScope(pkList);
+ loadRefererOption.delegateKeyConditionExchangingFirstWhereClauseForLastOne(cb);
+ if (!loadRefererOption.isStopOrderByKey()) {
+ cb.query().addOrderBy_ManufacturersId_Asc();
+ cb.getSqlComponentOfOrderByClause().exchangeFirstOrderByElementForLastOne();
+ }
+ loadRefererOption.delegateConditionBeanSettingUp(cb);
+ final java.util.List<Products> reffererList = refererBhv.selectList(cb);
+ loadRefererOption.delegateEntitySettingUp(reffererList);
+
+ final java.util.Map<java.math.BigDecimal, java.util.List<Products>> pkReffererListMap = new java.util.LinkedHashMap<java.math.BigDecimal, java.util.List<Products>>();
+ for (Products reffererEntity : reffererList) {
+ if (!pkReffererListMap.containsKey(toLowerCaseIfString(reffererEntity.getManufacturersId()))) {
+ pkReffererListMap.put((java.math.BigDecimal)toLowerCaseIfString(reffererEntity.getManufacturersId()), new java.util.ArrayList<Products>());
+ }
+ (pkReffererListMap.get(toLowerCaseIfString(reffererEntity.getManufacturersId()))).add(reffererEntity);
+
+ // for Reverse Reference.
+ final Manufacturers myEntity = pkMyEntityMap.get(toLowerCaseIfString(reffererEntity.getManufacturersId()));
+ reffererEntity.setManufacturers(myEntity);
+ }
+
+ for (Manufacturers manufacturers : manufacturersList) {
+ if (pkReffererListMap.containsKey(toLowerCaseIfString(manufacturers.getManufacturersId()))) {
+ manufacturers.setProductsList((java.util.List<Products>)pkReffererListMap.get(toLowerCaseIfString(manufacturers.getManufacturersId())));
+ } else {
+ manufacturers.setProductsList(new java.util.ArrayList<Products>());
+ }
+ }
+ }
+
// ===================================================================================
// Pull Out Foreign
// ================
-
+
// ===================================================================================
// Basic Entity Update
// ===================
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsAttributesBhv.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsAttributesBhv.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsAttributesBhv.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -38,7 +38,7 @@
*
*
* [identity]
- *
+ * productsAttributesId
*
* [update-date]
*
@@ -680,6 +680,30 @@
// ===================================================================================
// Various Insert
// ==============
+
+ /* (non-javadoc)
+ * Copy-insert.
+ *
+ * @param primaryKey Primary-keys. (NotNull)
+ * @return Inserted count.
+ * @exception jp.sf.pal.pompei.allcommon.exception.RecordHasAlreadyBeenDeletedException
+ */
+ public int copyInsertByPKValueAfterSelect(java.math.BigDecimal productsAttributesId) {
+ ProductsAttributes entity = new ProductsAttributes();
+ entity.setProductsAttributesId(productsAttributesId);
+ final ProductsAttributesCB cb = newMyConditionBean();
+ cb.acceptPrimaryKeyMapString(getDBMeta().extractPrimaryKeyMapString(entity));
+ final ProductsAttributes currentEntity = selectEntityWithDeletedCheck(cb);
+ return delegateInsert(currentEntity);
+ }
+
+ /**
+ * Filter 'copy-insert' entity.
+ *
+ * @param productsAttributes Entity. (NotNull)
+ */
+ protected void filterCopyInsertEntity(ProductsAttributes productsAttributes) {
+ }
// ===================================================================================
// CBSetupper
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsBhv.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -11,6 +11,8 @@
import jp.sf.pal.pompei.allcommon.cbean.PagingResultBean;
import jp.sf.pal.pompei.allcommon.dbmeta.DBMeta;
+import jp.sf.pal.pompei.exbhv.*;
+
import jp.sf.pal.pompei.exdao.*;
import jp.sf.pal.pompei.exentity.*;
import jp.sf.pal.pompei.bsentity.dbmeta.*;
@@ -29,16 +31,16 @@
* PRODUCTS_ID, PRODUCTS_QUANTITY, PRODUCTS_MODEL, PRODUCTS_IMAGE, PRODUCTS_PRICE, PRODUCTS_DATE_ADDED, PRODUCTS_LAST_MODIFIED, PRODUCTS_DATE_AVAILABLE, PRODUCTS_WEIGHT, PRODUCTS_STATUS, PRODUCTS_TAX_CLASS_ID, MANUFACTURERS_ID, PRODUCTS_ORDERED
*
* [foreign-property]
- *
+ * manufacturers
*
* [refferer-property]
- *
+ * productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
*
* [identity]
- *
+ * productsId
*
* [update-date]
*
@@ -456,10 +458,322 @@
// Load Referer
// ============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // RefererTable = [PRODUCTS_DESCRIPTION]
+ // RefererProperty = [productsDescriptionList]
+ // * * * * * * * * */
+
+ /**
+ * Load referer of productsDescriptionList.
+ * <pre>
+ * You can load referer.
+ *
+ * ex) {Client Example}
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * productsBhv.loadProductsDescriptionList(productsList);
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ */
+ public void loadProductsDescriptionList(java.util.List<Products> productsList) {
+ final ConditionBeanSetupper<ProductsDescriptionCB> conditionBeanSetupper = new ConditionBeanSetupper<ProductsDescriptionCB>() {
+ public void setup(ProductsDescriptionCB cb) {
+ }
+ };
+ loadProductsDescriptionList(productsList, conditionBeanSetupper);
+ }
+
+ /**
+ * Load referer of productsDescriptionList.
+ * <pre>
+ * You can load referer with your original condition.
+ *
+ * ex) {Client Example}: Referer conditions are 'Xxx' is not null and order-by 'Yyy' desc
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * final ConditionBeanSetupper<ProductsDescriptionCB> conditionBeanSetupper = new ConditionBeanSetupper<ProductsDescriptionCB>() {
+ * public void setup(ProductsDescriptionCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * productsBhv.loadProductsDescriptionList(productsList, conditionBeanSetupper);
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setProductsId_InScope(pkList);
+ * cb.query().addOrderBy_ProductsId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ * @param conditionBeanSetupper Referer condition setupper instance for registering referer condition. (NotNull)
+ */
+ public void loadProductsDescriptionList(java.util.List<Products> productsList, ConditionBeanSetupper<ProductsDescriptionCB> conditionBeanSetupper) {
+ assertObjectNotNull("productsList<Products>", productsList);
+ assertObjectNotNull("conditionBeanSetupper<ProductsDescriptionCB>", conditionBeanSetupper);
+ if (productsList.isEmpty()) {
+ return;
+ }
+ loadProductsDescriptionList(productsList, new LoadRefererOption<ProductsDescriptionCB, ProductsDescription>(conditionBeanSetupper));
+ }
+
+ /**
+ * Load referer of productsDescriptionList.
+ * <pre>
+ * You can load referer with your original condition.
+ *
+ * ex) {Client Example}: Referer conditions are 'Xxx' is not null and order-by 'Yyy' desc
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * final ConditionBeanSetupper<ProductsDescriptionCB> cbSetupper = new ConditionBeanSetupper<ProductsDescriptionCB>() {
+ * public void setup(ProductsDescriptionCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * productsBhv.loadProductsDescriptionList(productsList, new LoadRefererOption<ProductsDescriptionCB, ProductsDescription>(cbSetupper));
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setProductsId_InScope(pkList);
+ * cb.query().addOrderBy_ProductsId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ * @param loadRefererOption Load-referer option. (NotNull)
+ */
+ public void loadProductsDescriptionList(java.util.List<Products> productsList, LoadRefererOption<ProductsDescriptionCB, ProductsDescription> loadRefererOption) {
+ assertObjectNotNull("productsList<Products>", productsList);
+ assertObjectNotNull("loadRefererOption<ProductsDescription, ProductsDescriptionCB>", loadRefererOption);
+ if (productsList.isEmpty()) {
+ return;
+ }
+
+ final java.util.Map<java.math.BigDecimal, Products> pkMyEntityMap = new java.util.LinkedHashMap<java.math.BigDecimal, Products>();
+ final java.util.List<java.math.BigDecimal> pkList = new java.util.ArrayList<java.math.BigDecimal>();
+ for (Products products : productsList) {
+ pkList.add(products.getProductsId());
+ pkMyEntityMap.put((java.math.BigDecimal)toLowerCaseIfString(products.getProductsId()), products);
+ }
+ final ProductsDescriptionBhv refererBhv = getDaoSelector().getBehavior(ProductsDescriptionBhv.class);
+ final ProductsDescriptionCB cb = loadRefererOption.getReffererConditionBean() != null ? loadRefererOption.getReffererConditionBean() : refererBhv.newMyConditionBean();
+ cb.query().setProductsId_InScope(pkList);
+ loadRefererOption.delegateKeyConditionExchangingFirstWhereClauseForLastOne(cb);
+ if (!loadRefererOption.isStopOrderByKey()) {
+ cb.query().addOrderBy_ProductsId_Asc();
+ cb.getSqlComponentOfOrderByClause().exchangeFirstOrderByElementForLastOne();
+ }
+ loadRefererOption.delegateConditionBeanSettingUp(cb);
+ final java.util.List<ProductsDescription> reffererList = refererBhv.selectList(cb);
+ loadRefererOption.delegateEntitySettingUp(reffererList);
+
+ final java.util.Map<java.math.BigDecimal, java.util.List<ProductsDescription>> pkReffererListMap = new java.util.LinkedHashMap<java.math.BigDecimal, java.util.List<ProductsDescription>>();
+ for (ProductsDescription reffererEntity : reffererList) {
+ if (!pkReffererListMap.containsKey(toLowerCaseIfString(reffererEntity.getProductsId()))) {
+ pkReffererListMap.put((java.math.BigDecimal)toLowerCaseIfString(reffererEntity.getProductsId()), new java.util.ArrayList<ProductsDescription>());
+ }
+ (pkReffererListMap.get(toLowerCaseIfString(reffererEntity.getProductsId()))).add(reffererEntity);
+
+ // for Reverse Reference.
+ final Products myEntity = pkMyEntityMap.get(toLowerCaseIfString(reffererEntity.getProductsId()));
+ reffererEntity.setProducts(myEntity);
+ }
+
+ for (Products products : productsList) {
+ if (pkReffererListMap.containsKey(toLowerCaseIfString(products.getProductsId()))) {
+ products.setProductsDescriptionList((java.util.List<ProductsDescription>)pkReffererListMap.get(toLowerCaseIfString(products.getProductsId())));
+ } else {
+ products.setProductsDescriptionList(new java.util.ArrayList<ProductsDescription>());
+ }
+ }
+ }
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // RefererTable = [PRODUCTS_TO_CATEGORIES]
+ // RefererProperty = [productsToCategoriesList]
+ // * * * * * * * * */
+
+ /**
+ * Load referer of productsToCategoriesList.
+ * <pre>
+ * You can load referer.
+ *
+ * ex) {Client Example}
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * productsBhv.loadProductsToCategoriesList(productsList);
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ */
+ public void loadProductsToCategoriesList(java.util.List<Products> productsList) {
+ final ConditionBeanSetupper<ProductsToCategoriesCB> conditionBeanSetupper = new ConditionBeanSetupper<ProductsToCategoriesCB>() {
+ public void setup(ProductsToCategoriesCB cb) {
+ }
+ };
+ loadProductsToCategoriesList(productsList, conditionBeanSetupper);
+ }
+
+ /**
+ * Load referer of productsToCategoriesList.
+ * <pre>
+ * You can load referer with your original condition.
+ *
+ * ex) {Client Example}: Referer conditions are 'Xxx' is not null and order-by 'Yyy' desc
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * final ConditionBeanSetupper<ProductsToCategoriesCB> conditionBeanSetupper = new ConditionBeanSetupper<ProductsToCategoriesCB>() {
+ * public void setup(ProductsToCategoriesCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * productsBhv.loadProductsToCategoriesList(productsList, conditionBeanSetupper);
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setProductsId_InScope(pkList);
+ * cb.query().addOrderBy_ProductsId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ * @param conditionBeanSetupper Referer condition setupper instance for registering referer condition. (NotNull)
+ */
+ public void loadProductsToCategoriesList(java.util.List<Products> productsList, ConditionBeanSetupper<ProductsToCategoriesCB> conditionBeanSetupper) {
+ assertObjectNotNull("productsList<Products>", productsList);
+ assertObjectNotNull("conditionBeanSetupper<ProductsToCategoriesCB>", conditionBeanSetupper);
+ if (productsList.isEmpty()) {
+ return;
+ }
+ loadProductsToCategoriesList(productsList, new LoadRefererOption<ProductsToCategoriesCB, ProductsToCategories>(conditionBeanSetupper));
+ }
+
+ /**
+ * Load referer of productsToCategoriesList.
+ * <pre>
+ * You can load referer with your original condition.
+ *
+ * ex) {Client Example}: Referer conditions are 'Xxx' is not null and order-by 'Yyy' desc
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * final ProductsCB cb = new ProductsCB();
+ * cb.query().setXxx_Equal("xxx");
+ * final List<Products> productsList = productsBhv.selectList(cb);
+ * final ConditionBeanSetupper<ProductsToCategoriesCB> cbSetupper = new ConditionBeanSetupper<ProductsToCategoriesCB>() {
+ * public void setup(ProductsToCategoriesCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * productsBhv.loadProductsToCategoriesList(productsList, new LoadRefererOption<ProductsToCategoriesCB, ProductsToCategories>(cbSetupper));
+ * - - - - - - - - - -/
+ *
+ * The condition-bean that the setupper provides have settings before you touch it. It is as follows:
+ * /- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+ * cb.query().setProductsId_InScope(pkList);
+ * cb.query().addOrderBy_ProductsId_Asc();
+ * - - - - - - - - - -/
+ *
+ * *About internal policy, the value of primary key(and others too) is treated as CaseInsensitive.
+ * </pre>
+ *
+ * @param productsList Entity list of products. (NotNull)
+ * @param loadRefererOption Load-referer option. (NotNull)
+ */
+ public void loadProductsToCategoriesList(java.util.List<Products> productsList, LoadRefererOption<ProductsToCategoriesCB, ProductsToCategories> loadRefererOption) {
+ assertObjectNotNull("productsList<Products>", productsList);
+ assertObjectNotNull("loadRefererOption<ProductsToCategories, ProductsToCategoriesCB>", loadRefererOption);
+ if (productsList.isEmpty()) {
+ return;
+ }
+
+ final java.util.Map<java.math.BigDecimal, Products> pkMyEntityMap = new java.util.LinkedHashMap<java.math.BigDecimal, Products>();
+ final java.util.List<java.math.BigDecimal> pkList = new java.util.ArrayList<java.math.BigDecimal>();
+ for (Products products : productsList) {
+ pkList.add(products.getProductsId());
+ pkMyEntityMap.put((java.math.BigDecimal)toLowerCaseIfString(products.getProductsId()), products);
+ }
+ final ProductsToCategoriesBhv refererBhv = getDaoSelector().getBehavior(ProductsToCategoriesBhv.class);
+ final ProductsToCategoriesCB cb = loadRefererOption.getReffererConditionBean() != null ? loadRefererOption.getReffererConditionBean() : refererBhv.newMyConditionBean();
+ cb.query().setProductsId_InScope(pkList);
+ loadRefererOption.delegateKeyConditionExchangingFirstWhereClauseForLastOne(cb);
+ if (!loadRefererOption.isStopOrderByKey()) {
+ cb.query().addOrderBy_ProductsId_Asc();
+ cb.getSqlComponentOfOrderByClause().exchangeFirstOrderByElementForLastOne();
+ }
+ loadRefererOption.delegateConditionBeanSettingUp(cb);
+ final java.util.List<ProductsToCategories> reffererList = refererBhv.selectList(cb);
+ loadRefererOption.delegateEntitySettingUp(reffererList);
+
+ final java.util.Map<java.math.BigDecimal, java.util.List<ProductsToCategories>> pkReffererListMap = new java.util.LinkedHashMap<java.math.BigDecimal, java.util.List<ProductsToCategories>>();
+ for (ProductsToCategories reffererEntity : reffererList) {
+ if (!pkReffererListMap.containsKey(toLowerCaseIfString(reffererEntity.getProductsId()))) {
+ pkReffererListMap.put((java.math.BigDecimal)toLowerCaseIfString(reffererEntity.getProductsId()), new java.util.ArrayList<ProductsToCategories>());
+ }
+ (pkReffererListMap.get(toLowerCaseIfString(reffererEntity.getProductsId()))).add(reffererEntity);
+
+ // for Reverse Reference.
+ final Products myEntity = pkMyEntityMap.get(toLowerCaseIfString(reffererEntity.getProductsId()));
+ reffererEntity.setProducts(myEntity);
+ }
+
+ for (Products products : productsList) {
+ if (pkReffererListMap.containsKey(toLowerCaseIfString(products.getProductsId()))) {
+ products.setProductsToCategoriesList((java.util.List<ProductsToCategories>)pkReffererListMap.get(toLowerCaseIfString(products.getProductsId())));
+ } else {
+ products.setProductsToCategoriesList(new java.util.ArrayList<ProductsToCategories>());
+ }
+ }
+ }
+
// ===================================================================================
// Pull Out Foreign
// ================
+ /**
+ * Pull out the list of foreign table 'Manufacturers'.
+ *
+ * @param productsList The list of products. (NotNull)
+ * @return The list of foreign table. (NotNull)
+ */
+ public java.util.List<Manufacturers> pulloutManufacturers(java.util.List<Products> productsList) {
+ assertObjectNotNull("productsList", productsList);
+ final java.util.Set<Manufacturers> foreignSet = new java.util.LinkedHashSet<Manufacturers>();
+ for (java.util.Iterator ite = productsList.iterator(); ite.hasNext(); ) {
+ final Products products = (Products)ite.next();
+ final Manufacturers foreignEntity = products.getManufacturers();
+ if (foreignEntity == null || foreignSet.contains(foreignEntity)) {
+ continue;
+ }
+ foreignSet.add(foreignEntity);
+ }
+ return new java.util.ArrayList<Manufacturers>(foreignSet);
+ }
+
// ===================================================================================
// Basic Entity Update
// ===================
@@ -687,6 +1001,30 @@
// ===================================================================================
// Various Insert
// ==============
+
+ /* (non-javadoc)
+ * Copy-insert.
+ *
+ * @param primaryKey Primary-keys. (NotNull)
+ * @return Inserted count.
+ * @exception jp.sf.pal.pompei.allcommon.exception.RecordHasAlreadyBeenDeletedException
+ */
+ public int copyInsertByPKValueAfterSelect(java.math.BigDecimal productsId) {
+ Products entity = new Products();
+ entity.setProductsId(productsId);
+ final ProductsCB cb = newMyConditionBean();
+ cb.acceptPrimaryKeyMapString(getDBMeta().extractPrimaryKeyMapString(entity));
+ final Products currentEntity = selectEntityWithDeletedCheck(cb);
+ return delegateInsert(currentEntity);
+ }
+
+ /**
+ * Filter 'copy-insert' entity.
+ *
+ * @param products Entity. (NotNull)
+ */
+ protected void filterCopyInsertEntity(Products products) {
+ }
// ===================================================================================
// CBSetupper
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsDescriptionBhv.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsDescriptionBhv.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsDescriptionBhv.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -29,7 +29,7 @@
* PRODUCTS_ID, LANGUAGE_ID, PRODUCTS_NAME, PRODUCTS_DESCRIPTION, PRODUCTS_URL, PRODUCTS_VIEWED
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -456,6 +456,26 @@
// Pull Out Foreign
// ================
+ /**
+ * Pull out the list of foreign table 'Products'.
+ *
+ * @param productsDescriptionList The list of productsDescription. (NotNull)
+ * @return The list of foreign table. (NotNull)
+ */
+ public java.util.List<Products> pulloutProducts(java.util.List<ProductsDescription> productsDescriptionList) {
+ assertObjectNotNull("productsDescriptionList", productsDescriptionList);
+ final java.util.Set<Products> foreignSet = new java.util.LinkedHashSet<Products>();
+ for (java.util.Iterator ite = productsDescriptionList.iterator(); ite.hasNext(); ) {
+ final ProductsDescription productsDescription = (ProductsDescription)ite.next();
+ final Products foreignEntity = productsDescription.getProducts();
+ if (foreignEntity == null || foreignSet.contains(foreignEntity)) {
+ continue;
+ }
+ foreignSet.add(foreignEntity);
+ }
+ return new java.util.ArrayList<Products>(foreignSet);
+ }
+
// ===================================================================================
// Basic Entity Update
// ===================
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsToCategoriesBhv.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsToCategoriesBhv.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsProductsToCategoriesBhv.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -26,10 +26,10 @@
* PRODUCTS_ID, CATEGORIES_ID
*
* [column-property]
- * PRODUCTS_ID, CATEGORIES_ID
+ * PRODUCTS_ID, CATEGORIES_ID, COMMENT
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -456,6 +456,26 @@
// Pull Out Foreign
// ================
+ /**
+ * Pull out the list of foreign table 'Products'.
+ *
+ * @param productsToCategoriesList The list of productsToCategories. (NotNull)
+ * @return The list of foreign table. (NotNull)
+ */
+ public java.util.List<Products> pulloutProducts(java.util.List<ProductsToCategories> productsToCategoriesList) {
+ assertObjectNotNull("productsToCategoriesList", productsToCategoriesList);
+ final java.util.Set<Products> foreignSet = new java.util.LinkedHashSet<Products>();
+ for (java.util.Iterator ite = productsToCategoriesList.iterator(); ite.hasNext(); ) {
+ final ProductsToCategories productsToCategories = (ProductsToCategories)ite.next();
+ final Products foreignEntity = productsToCategories.getProducts();
+ if (foreignEntity == null || foreignSet.contains(foreignEntity)) {
+ continue;
+ }
+ foreignSet.add(foreignEntity);
+ }
+ return new java.util.ArrayList<Products>(foreignSet);
+ }
+
// ===================================================================================
// Basic Entity Update
// ===================
@@ -590,6 +610,7 @@
if (names.contains("productsId")) { destinationMyEntity.setProductsId(sourceMyEntity.getProductsId()); }
if (names.contains("categoriesId")) { destinationMyEntity.setCategoriesId(sourceMyEntity.getCategoriesId()); }
+ if (names.contains("comment")) { destinationMyEntity.setComment(sourceMyEntity.getComment()); }
}
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersDao.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersDao.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersDao.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -17,7 +17,7 @@
*
*
* [refferer-property]
- * manufacturersInfoList
+ * manufacturersInfoList, productsList
*
* [sequence]
*
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsAttributesDao.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsAttributesDao.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsAttributesDao.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -23,7 +23,7 @@
*
*
* [identity]
- *
+ * productsAttributesId
*
* [update-date]
*
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDao.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -14,16 +14,16 @@
* PRODUCTS_ID, PRODUCTS_QUANTITY, PRODUCTS_MODEL, PRODUCTS_IMAGE, PRODUCTS_PRICE, PRODUCTS_DATE_ADDED, PRODUCTS_LAST_MODIFIED, PRODUCTS_DATE_AVAILABLE, PRODUCTS_WEIGHT, PRODUCTS_STATUS, PRODUCTS_TAX_CLASS_ID, MANUFACTURERS_ID, PRODUCTS_ORDERED
*
* [foreign-property]
- *
+ * manufacturers
*
* [refferer-property]
- *
+ * productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
*
* [identity]
- *
+ * productsId
*
* [update-date]
*
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDescriptionDao.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDescriptionDao.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsDescriptionDao.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -14,7 +14,7 @@
* PRODUCTS_ID, LANGUAGE_ID, PRODUCTS_NAME, PRODUCTS_DESCRIPTION, PRODUCTS_URL, PRODUCTS_VIEWED
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsToCategoriesDao.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsToCategoriesDao.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsProductsToCategoriesDao.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -11,10 +11,10 @@
* PRODUCTS_ID, CATEGORIES_ID
*
* [column-property]
- * PRODUCTS_ID, CATEGORIES_ID
+ * PRODUCTS_ID, CATEGORIES_ID, COMMENT
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturers.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturers.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturers.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -19,7 +19,7 @@
*
*
* [refferer-property]
- * manufacturersInfoList
+ * manufacturersInfoList, productsList
*
* [sequence]
*
@@ -298,6 +298,34 @@
this._childrenManufacturersInfoList = entity;
}
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ReffererTable = [PRODUCTS]
+ // ReffererProperty = [productsList]
+ // * * * * * * * * */
+
+ /** The list of refferer table. */
+ protected java.util.List<jp.sf.pal.pompei.exentity.Products> _childrenProductsList;
+
+ /**
+ * Get the list of refferer table without lazyload.
+ * If it's not loaded yet, returns null.
+ *
+ * @return The list of refferer table. (Nullable)
+ */
+ public java.util.List<jp.sf.pal.pompei.exentity.Products> getProductsList() {
+ return _childrenProductsList;
+ }
+
+ /**
+ * Set the list of refferer table.
+ *
+ * @param value The list of refferer table. (Nullable)
+ */
+ public void setProductsList(java.util.List<jp.sf.pal.pompei.exentity.Products> entity) {
+ this._childrenProductsList = entity;
+ }
+
// ===================================================================================
// Accept
// ======
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProducts.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -16,16 +16,16 @@
* PRODUCTS_ID, PRODUCTS_QUANTITY, PRODUCTS_MODEL, PRODUCTS_IMAGE, PRODUCTS_PRICE, PRODUCTS_DATE_ADDED, PRODUCTS_LAST_MODIFIED, PRODUCTS_DATE_AVAILABLE, PRODUCTS_WEIGHT, PRODUCTS_STATUS, PRODUCTS_TAX_CLASS_ID, MANUFACTURERS_ID, PRODUCTS_ORDERED
*
* [foreign-property]
- *
+ * manufacturers
*
* [refferer-property]
- *
+ * productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
*
* [identity]
- *
+ * productsId
*
* [update-date]
*
@@ -45,6 +45,9 @@
/** TABLE-Annotation for S2Dao */
public static final String TABLE = "PRODUCTS";
+
+ /** ID-Annotation */
+ public static final String productsId_ID = "identity";
// ===================================================================================
// Attribute
@@ -53,7 +56,7 @@
protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties();
- /** The value of productsId. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** The value of productsId. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
protected java.math.BigDecimal _productsId;
/** The value of productsQuantity. ColumnDefinition -- INTEGER : NotNull*/
@@ -86,7 +89,7 @@
/** The value of productsTaxClassId. ColumnDefinition -- INTEGER : NotNull*/
protected java.math.BigDecimal _productsTaxClassId;
- /** The value of manufacturersId. ColumnDefinition -- INTEGER*/
+ /** The value of manufacturersId. ColumnDefinition -- INTEGER : FK to MANUFACTURERS*/
protected java.math.BigDecimal _manufacturersId;
/** The value of productsOrdered. ColumnDefinition -- INTEGER : NotNull : Default=[0]*/
@@ -148,12 +151,12 @@
// Accessor
// ========
- /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
public static final String productsId_COLUMN = "PRODUCTS_ID";
/**
* Get the value of productsId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @return The value of productsId. (Nullable)
*/
@@ -163,7 +166,7 @@
/**
* Set the value of productsId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @param productsId The value of productsId. (Nullable)
*/
@@ -412,12 +415,12 @@
_productsTaxClassId = productsTaxClassId;
}
- /** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER : FK to MANUFACTURERS*/
public static final String manufacturersId_COLUMN = "MANUFACTURERS_ID";
/**
* Get the value of manufacturersId. <br />
- * {INTEGER}
+ * {INTEGER : FK to MANUFACTURERS}
*
* @return The value of manufacturersId. (Nullable)
*/
@@ -427,7 +430,7 @@
/**
* Set the value of manufacturersId. <br />
- * {INTEGER}
+ * {INTEGER : FK to MANUFACTURERS}
*
* @param manufacturersId The value of manufacturersId. (Nullable)
*/
@@ -479,10 +482,108 @@
// Foreign Table
// =============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [MANUFACTURERS]
+ // ForeignProperty = [manufacturers]
+ // * * * * * * * * */
+
+ /** RELNO of foreign table for s2dao. */
+ public static final int manufacturers_RELNO = 0;
+
+ /** RELKEYS of foreign table for s2dao. */
+ public static final String manufacturers_RELKEYS = "MANUFACTURERS_ID:MANUFACTURERS_ID";
+
+ /** The entity of foreign table. */
+ protected jp.sf.pal.pompei.exentity.Manufacturers _parentManufacturers;
+
+ /**
+ * Get the entity of foreign table without lazyload.
+ *
+ * @return The entity of foreign table.
+ */
+ public jp.sf.pal.pompei.exentity.Manufacturers getManufacturers() {
+ return _parentManufacturers;
+ }
+
+ /**
+ * Set the entity of foreign table.
+ *
+ * @param v The entity of foreign table.
+ */
+ public void setManufacturers(jp.sf.pal.pompei.exentity.Manufacturers entity) {
+ this._parentManufacturers = entity;
+ }
+
+ /**
+ * Has relation object of manufacturers.
+ *
+ * @return Determination.
+ */
+ public boolean hasRelationManufacturers() {
+ return _parentManufacturers != null && _parentManufacturers.hasPrimaryKeyValue();
+ }
+
+
// ===================================================================================
// Refferer Table
// ==============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ReffererTable = [PRODUCTS_DESCRIPTION]
+ // ReffererProperty = [productsDescriptionList]
+ // * * * * * * * * */
+
+ /** The list of refferer table. */
+ protected java.util.List<jp.sf.pal.pompei.exentity.ProductsDescription> _childrenProductsDescriptionList;
+
+ /**
+ * Get the list of refferer table without lazyload.
+ * If it's not loaded yet, returns null.
+ *
+ * @return The list of refferer table. (Nullable)
+ */
+ public java.util.List<jp.sf.pal.pompei.exentity.ProductsDescription> getProductsDescriptionList() {
+ return _childrenProductsDescriptionList;
+ }
+
+ /**
+ * Set the list of refferer table.
+ *
+ * @param value The list of refferer table. (Nullable)
+ */
+ public void setProductsDescriptionList(java.util.List<jp.sf.pal.pompei.exentity.ProductsDescription> entity) {
+ this._childrenProductsDescriptionList = entity;
+ }
+
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ReffererTable = [PRODUCTS_TO_CATEGORIES]
+ // ReffererProperty = [productsToCategoriesList]
+ // * * * * * * * * */
+
+ /** The list of refferer table. */
+ protected java.util.List<jp.sf.pal.pompei.exentity.ProductsToCategories> _childrenProductsToCategoriesList;
+
+ /**
+ * Get the list of refferer table without lazyload.
+ * If it's not loaded yet, returns null.
+ *
+ * @return The list of refferer table. (Nullable)
+ */
+ public java.util.List<jp.sf.pal.pompei.exentity.ProductsToCategories> getProductsToCategoriesList() {
+ return _childrenProductsToCategoriesList;
+ }
+
+ /**
+ * Set the list of refferer table.
+ *
+ * @param value The list of refferer table. (Nullable)
+ */
+ public void setProductsToCategoriesList(java.util.List<jp.sf.pal.pompei.exentity.ProductsToCategories> entity) {
+ this._childrenProductsToCategoriesList = entity;
+ }
+
// ===================================================================================
// Accept
// ======
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsAttributes.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsAttributes.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsAttributes.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -25,7 +25,7 @@
*
*
* [identity]
- *
+ * productsAttributesId
*
* [update-date]
*
@@ -45,6 +45,9 @@
/** TABLE-Annotation for S2Dao */
public static final String TABLE = "PRODUCTS_ATTRIBUTES";
+
+ /** ID-Annotation */
+ public static final String productsAttributesId_ID = "identity";
// ===================================================================================
// Attribute
@@ -53,7 +56,7 @@
protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties();
- /** The value of productsAttributesId. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** The value of productsAttributesId. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
protected java.math.BigDecimal _productsAttributesId;
/** The value of productsId. ColumnDefinition -- INTEGER : NotNull*/
@@ -127,12 +130,12 @@
// Accessor
// ========
- /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
public static final String productsAttributesId_COLUMN = "PRODUCTS_ATTRIBUTES_ID";
/**
* Get the value of productsAttributesId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @return The value of productsAttributesId. (Nullable)
*/
@@ -142,7 +145,7 @@
/**
* Set the value of productsAttributesId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @param productsAttributesId The value of productsAttributesId. (Nullable)
*/
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsDescription.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsDescription.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsDescription.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -16,7 +16,7 @@
* PRODUCTS_ID, LANGUAGE_ID, PRODUCTS_NAME, PRODUCTS_DESCRIPTION, PRODUCTS_URL, PRODUCTS_VIEWED
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -53,7 +53,7 @@
protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties();
- /** The value of productsId. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** The value of productsId. ColumnDefinition -- PK : INTEGER : NotNull : FK to PRODUCTS*/
protected java.math.BigDecimal _productsId;
/** The value of languageId. ColumnDefinition -- PK : INTEGER : NotNull : Default=[1]*/
@@ -127,12 +127,12 @@
// Accessor
// ========
- /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull : FK to PRODUCTS*/
public static final String productsId_COLUMN = "PRODUCTS_ID";
/**
* Get the value of productsId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INTEGER : NotNull : FK to PRODUCTS}
*
* @return The value of productsId. (Nullable)
*/
@@ -142,7 +142,7 @@
/**
* Set the value of productsId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INTEGER : NotNull : FK to PRODUCTS}
*
* @param productsId The value of productsId. (Nullable)
*/
@@ -290,6 +290,48 @@
// Foreign Table
// =============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /** RELNO of foreign table for s2dao. */
+ public static final int products_RELNO = 0;
+
+ /** RELKEYS of foreign table for s2dao. */
+ public static final String products_RELKEYS = "PRODUCTS_ID:PRODUCTS_ID";
+
+ /** The entity of foreign table. */
+ protected jp.sf.pal.pompei.exentity.Products _parentProducts;
+
+ /**
+ * Get the entity of foreign table without lazyload.
+ *
+ * @return The entity of foreign table.
+ */
+ public jp.sf.pal.pompei.exentity.Products getProducts() {
+ return _parentProducts;
+ }
+
+ /**
+ * Set the entity of foreign table.
+ *
+ * @param v The entity of foreign table.
+ */
+ public void setProducts(jp.sf.pal.pompei.exentity.Products entity) {
+ this._parentProducts = entity;
+ }
+
+ /**
+ * Has relation object of products.
+ *
+ * @return Determination.
+ */
+ public boolean hasRelationProducts() {
+ return _parentProducts != null && _parentProducts.hasPrimaryKeyValue();
+ }
+
+
// ===================================================================================
// Refferer Table
// ==============
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsToCategories.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsToCategories.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsProductsToCategories.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -13,10 +13,10 @@
* PRODUCTS_ID, CATEGORIES_ID
*
* [column-property]
- * PRODUCTS_ID, CATEGORIES_ID
+ * PRODUCTS_ID, CATEGORIES_ID, COMMENT
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -53,11 +53,14 @@
protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties();
- /** The value of productsId. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** The value of productsId. ColumnDefinition -- PK : INTEGER : NotNull : FK to PRODUCTS*/
protected java.math.BigDecimal _productsId;
/** The value of categoriesId. ColumnDefinition -- PK : INTEGER : NotNull*/
protected java.math.BigDecimal _categoriesId;
+
+ /** The value of comment. ColumnDefinition -- VARCHAR(40)*/
+ protected String _comment;
// ===================================================================================
// Constructor
@@ -115,12 +118,12 @@
// Accessor
// ========
- /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull : FK to PRODUCTS*/
public static final String productsId_COLUMN = "PRODUCTS_ID";
/**
* Get the value of productsId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INTEGER : NotNull : FK to PRODUCTS}
*
* @return The value of productsId. (Nullable)
*/
@@ -130,7 +133,7 @@
/**
* Set the value of productsId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INTEGER : NotNull : FK to PRODUCTS}
*
* @param productsId The value of productsId. (Nullable)
*/
@@ -163,25 +166,91 @@
_categoriesId = categoriesId;
}
+ /** Column-Annotation for S2Dao. ColumnDefinition -- VARCHAR(40)*/
+ public static final String comment_COLUMN = "COMMENT";
+ /**
+ * Get the value of comment. <br />
+ * {VARCHAR(40)}
+ *
+ * @return The value of comment. (Nullable)
+ */
+ public String getComment() {
+ return _comment;
+ }
+
+ /**
+ * Set the value of comment. <br />
+ * {VARCHAR(40)}
+ *
+ * @param comment The value of comment. (Nullable)
+ */
+ public void setComment(String comment) {
+ _modifiedProperties.addPropertyName("comment");
+ _comment = comment;
+ }
+
+
// ===================================================================================
// Classify Method
// ===============
-
+
// ===================================================================================
// Classification Determination
// ============================
-
+
// ===================================================================================
// Classification Getter
// =====================
-
+
// ===================================================================================
// Foreign Table
// =============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /** RELNO of foreign table for s2dao. */
+ public static final int products_RELNO = 0;
+
+ /** RELKEYS of foreign table for s2dao. */
+ public static final String products_RELKEYS = "PRODUCTS_ID:PRODUCTS_ID";
+
+ /** The entity of foreign table. */
+ protected jp.sf.pal.pompei.exentity.Products _parentProducts;
+
+ /**
+ * Get the entity of foreign table without lazyload.
+ *
+ * @return The entity of foreign table.
+ */
+ public jp.sf.pal.pompei.exentity.Products getProducts() {
+ return _parentProducts;
+ }
+
+ /**
+ * Set the entity of foreign table.
+ *
+ * @param v The entity of foreign table.
+ */
+ public void setProducts(jp.sf.pal.pompei.exentity.Products entity) {
+ this._parentProducts = entity;
+ }
+
+ /**
+ * Has relation object of products.
+ *
+ * @return Determination.
+ */
+ public boolean hasRelationProducts() {
+ return _parentProducts != null && _parentProducts.hasPrimaryKeyValue();
+ }
+
+
// ===================================================================================
// Refferer Table
// ==============
@@ -389,6 +458,7 @@
sb.append(delimiter).append(getProductsId());
sb.append(delimiter).append(getCategoriesId());
+ sb.append(delimiter).append(getComment());
sb.delete(0, delimiter.length());
sb.insert(0, "{").append("}");
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturersDbm.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturersDbm.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturersDbm.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -20,7 +20,7 @@
*
*
* [refferer-property]
- * manufacturersInfoList
+ * manufacturersInfoList, productsList
*
* [sequence]
*
@@ -107,6 +107,8 @@
/** Cap-prop-name of ManufacturersInfoList. */
public static final String COLUMN_CAP_PROP_NAME_OF_ManufacturersInfoList = "ManufacturersInfoList";
+ /** Cap-prop-name of ProductsList. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_ProductsList = "ProductsList";
/** Uncap-prop-name of ManufacturersId. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ManufacturersId = "manufacturersId";
@@ -122,6 +124,8 @@
/** Uncap-prop-name of manufacturersInfoList. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ManufacturersInfoList = "manufacturersInfoList";
+ /** Uncap-prop-name of productsList. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsList = "productsList";
/** {db-name : cap-prop-name} map. */
private static java.util.Map<String, String> _dbNameCapPropNameMap;
@@ -464,7 +468,7 @@
throw new RuntimeException(e.getCause());
}
}
-
+
// ===================================================================================
// Determination
// =============
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsAttributesDbm.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsAttributesDbm.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsAttributesDbm.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -26,7 +26,7 @@
*
*
* [identity]
- *
+ * productsAttributesId
*
* [update-date]
*
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDbm.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -17,16 +17,16 @@
* PRODUCTS_ID, PRODUCTS_QUANTITY, PRODUCTS_MODEL, PRODUCTS_IMAGE, PRODUCTS_PRICE, PRODUCTS_DATE_ADDED, PRODUCTS_LAST_MODIFIED, PRODUCTS_DATE_AVAILABLE, PRODUCTS_WEIGHT, PRODUCTS_STATUS, PRODUCTS_TAX_CLASS_ID, MANUFACTURERS_ID, PRODUCTS_ORDERED
*
* [foreign-property]
- *
+ * manufacturers
*
* [refferer-property]
- *
+ * productsDescriptionList, productsToCategoriesList
*
* [sequence]
*
*
* [identity]
- *
+ * productsId
*
* [update-date]
*
@@ -136,7 +136,13 @@
/** Cap-prop-name of ProductsOrdered. */
public static final String COLUMN_CAP_PROP_NAME_OF_ProductsOrdered = "ProductsOrdered";
+ /** Cap-prop-name of manufacturers. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_Manufacturers = "Manufacturers";
+ /** Cap-prop-name of ProductsDescriptionList. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_ProductsDescriptionList = "ProductsDescriptionList";
+ /** Cap-prop-name of ProductsToCategoriesList. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_ProductsToCategoriesList = "ProductsToCategoriesList";
/** Uncap-prop-name of ProductsId. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsId = "productsId";
@@ -165,7 +171,13 @@
/** Uncap-prop-name of ProductsOrdered. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsOrdered = "productsOrdered";
+ /** Uncap-prop-name of manufacturers. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_Manufacturers = "manufacturers";
+ /** Uncap-prop-name of productsDescriptionList. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsDescriptionList = "productsDescriptionList";
+ /** Uncap-prop-name of productsToCategoriesList. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsToCategoriesList = "productsToCategoriesList";
/** {db-name : cap-prop-name} map. */
private static java.util.Map<String, String> _dbNameCapPropNameMap;
@@ -557,6 +569,15 @@
}
}
+ /**
+ * Get foreign dbmeta of Manufacturers.
+ *
+ * @return Foreign DBMeta. (NotNull)
+ */
+ public ManufacturersDbm getForeignDBMeta_Manufacturers() {
+ return ManufacturersDbm.getInstance();
+ }
+
// ===================================================================================
// Determination
// =============
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDescriptionDbm.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDescriptionDbm.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsDescriptionDbm.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -17,7 +17,7 @@
* PRODUCTS_ID, LANGUAGE_ID, PRODUCTS_NAME, PRODUCTS_DESCRIPTION, PRODUCTS_URL, PRODUCTS_VIEWED
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -108,6 +108,8 @@
/** Cap-prop-name of ProductsViewed. */
public static final String COLUMN_CAP_PROP_NAME_OF_ProductsViewed = "ProductsViewed";
+ /** Cap-prop-name of products. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_Products = "Products";
/** Uncap-prop-name of ProductsId. */
@@ -123,6 +125,8 @@
/** Uncap-prop-name of ProductsViewed. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsViewed = "productsViewed";
+ /** Uncap-prop-name of products. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_Products = "products";
/** {db-name : cap-prop-name} map. */
@@ -473,6 +477,15 @@
}
}
+ /**
+ * Get foreign dbmeta of Products.
+ *
+ * @return Foreign DBMeta. (NotNull)
+ */
+ public ProductsDbm getForeignDBMeta_Products() {
+ return ProductsDbm.getInstance();
+ }
+
// ===================================================================================
// Determination
// =============
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsToCategoriesDbm.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsToCategoriesDbm.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ProductsToCategoriesDbm.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -14,10 +14,10 @@
* PRODUCTS_ID, CATEGORIES_ID
*
* [column-property]
- * PRODUCTS_ID, CATEGORIES_ID
+ * PRODUCTS_ID, CATEGORIES_ID, COMMENT
*
* [foreign-property]
- *
+ * products
*
* [refferer-property]
*
@@ -86,19 +86,29 @@
public static final String COLUMN_DB_NAME_OF_ProductsId = "PRODUCTS_ID";
/** Db-name of CategoriesId. */
public static final String COLUMN_DB_NAME_OF_CategoriesId = "CATEGORIES_ID";
+ /** Db-name of Comment. */
+ public static final String COLUMN_DB_NAME_OF_Comment = "COMMENT";
/** Cap-prop-name of ProductsId. */
public static final String COLUMN_CAP_PROP_NAME_OF_ProductsId = "ProductsId";
/** Cap-prop-name of CategoriesId. */
public static final String COLUMN_CAP_PROP_NAME_OF_CategoriesId = "CategoriesId";
+ /** Cap-prop-name of Comment. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_Comment = "Comment";
+ /** Cap-prop-name of products. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_Products = "Products";
/** Uncap-prop-name of ProductsId. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ProductsId = "productsId";
/** Uncap-prop-name of CategoriesId. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_CategoriesId = "categoriesId";
+ /** Uncap-prop-name of Comment. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_Comment = "comment";
+ /** Uncap-prop-name of products. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_Products = "products";
/** {db-name : cap-prop-name} map. */
@@ -112,6 +122,7 @@
map.put(COLUMN_DB_NAME_OF_ProductsId, COLUMN_CAP_PROP_NAME_OF_ProductsId);
map.put(COLUMN_DB_NAME_OF_CategoriesId, COLUMN_CAP_PROP_NAME_OF_CategoriesId);
+ map.put(COLUMN_DB_NAME_OF_Comment, COLUMN_CAP_PROP_NAME_OF_Comment);
_dbNameCapPropNameMap = java.util.Collections.unmodifiableMap(map);
return _dbNameCapPropNameMap;
@@ -128,6 +139,7 @@
map.put(COLUMN_DB_NAME_OF_ProductsId, COLUMN_UNCAP_PROP_NAME_OF_ProductsId);
map.put(COLUMN_DB_NAME_OF_CategoriesId, COLUMN_UNCAP_PROP_NAME_OF_CategoriesId);
+ map.put(COLUMN_DB_NAME_OF_Comment, COLUMN_UNCAP_PROP_NAME_OF_Comment);
_dbNameUncapPropNameMap = java.util.Collections.unmodifiableMap(map);
return _dbNameUncapPropNameMap;
@@ -144,6 +156,7 @@
map.put(COLUMN_CAP_PROP_NAME_OF_ProductsId, COLUMN_DB_NAME_OF_ProductsId);
map.put(COLUMN_CAP_PROP_NAME_OF_CategoriesId, COLUMN_DB_NAME_OF_CategoriesId);
+ map.put(COLUMN_CAP_PROP_NAME_OF_Comment, COLUMN_DB_NAME_OF_Comment);
_capPropNameDbNameMap = java.util.Collections.unmodifiableMap(map);
return _capPropNameDbNameMap;
@@ -160,6 +173,7 @@
map.put(COLUMN_CAP_PROP_NAME_OF_ProductsId, COLUMN_UNCAP_PROP_NAME_OF_ProductsId);
map.put(COLUMN_CAP_PROP_NAME_OF_CategoriesId, COLUMN_UNCAP_PROP_NAME_OF_CategoriesId);
+ map.put(COLUMN_CAP_PROP_NAME_OF_Comment, COLUMN_UNCAP_PROP_NAME_OF_Comment);
_capPropNameUncapPropNameMap = java.util.Collections.unmodifiableMap(map);
return _capPropNameUncapPropNameMap;
@@ -176,6 +190,7 @@
map.put(COLUMN_UNCAP_PROP_NAME_OF_ProductsId, COLUMN_DB_NAME_OF_ProductsId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CategoriesId, COLUMN_DB_NAME_OF_CategoriesId);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_Comment, COLUMN_DB_NAME_OF_Comment);
_uncapPropNameDbNameMap = java.util.Collections.unmodifiableMap(map);
return _uncapPropNameDbNameMap;
@@ -192,6 +207,7 @@
map.put(COLUMN_UNCAP_PROP_NAME_OF_ProductsId, COLUMN_CAP_PROP_NAME_OF_ProductsId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_CategoriesId, COLUMN_CAP_PROP_NAME_OF_CategoriesId);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_Comment, COLUMN_CAP_PROP_NAME_OF_Comment);
_uncapPropNameCapPropNameMap = java.util.Collections.unmodifiableMap(map);
return _uncapPropNameCapPropNameMap;
@@ -320,7 +336,7 @@
* @return Column-db-name comma-string. (NotNull)
*/
public String getColumnDbNameCommaString() {
- return "PRODUCTS_ID, CATEGORIES_ID";
+ return "PRODUCTS_ID, CATEGORIES_ID, COMMENT";
}
// ===================================================================================
@@ -425,6 +441,15 @@
}
}
+ /**
+ * Get foreign dbmeta of Products.
+ *
+ * @return Foreign DBMeta. (NotNull)
+ */
+ public ProductsDbm getForeignDBMeta_Products() {
+ return ProductsDbm.getInstance();
+ }
+
// ===================================================================================
// Determination
// =============
@@ -494,6 +519,7 @@
if (analyzer.init("PRODUCTS_ID", "productsId", "productsId")) { myEntity.setProductsId(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
if (analyzer.init("CATEGORIES_ID", "categoriesId", "categoriesId")) { myEntity.setCategoriesId(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
+ if (analyzer.init("COMMENT", "comment", "comment")) { myEntity.setComment(analyzer.analyzeString(String.class)); };
}
@@ -570,6 +596,7 @@
final StringBuffer sb = new StringBuffer();
helpAppendingColumnValueString(sb, delimiter, equal, "PRODUCTS_ID", myEntity.getProductsId());
helpAppendingColumnValueString(sb, delimiter, equal, "CATEGORIES_ID", myEntity.getCategoriesId());
+ helpAppendingColumnValueString(sb, delimiter, equal, "COMMENT", myEntity.getComment());
sb.delete(0, delimiter.length()).insert(0, mapMarkAndStartBrace).append(endBrace);
return sb.toString();
@@ -614,6 +641,7 @@
final java.util.Map<String, Object> valueMap = new java.util.LinkedHashMap<String, Object>();
valueMap.put("PRODUCTS_ID", myEntity.getProductsId());
valueMap.put("CATEGORIES_ID", myEntity.getCategoriesId());
+ valueMap.put("COMMENT", myEntity.getComment());
return valueMap;
}
@@ -626,6 +654,7 @@
final java.util.Map<String, String> valueMap = new java.util.LinkedHashMap<String, String>();
valueMap.put("PRODUCTS_ID", helpGettingColumnStringValue(myEntity.getProductsId()));
valueMap.put("CATEGORIES_ID", helpGettingColumnStringValue(myEntity.getCategoriesId()));
+ valueMap.put("COMMENT", helpGettingColumnStringValue(myEntity.getComment()));
return valueMap;
}
@@ -633,11 +662,11 @@
// JDBC Support
// ============
public String getPreparedInsertClause() {
- return "insert into PRODUCTS_TO_CATEGORIES(PRODUCTS_ID, CATEGORIES_ID) values(? , ? )";
+ return "insert into PRODUCTS_TO_CATEGORIES(PRODUCTS_ID, CATEGORIES_ID, COMMENT) values(? , ? , ? )";
}
public String getPreparedInsertClause(String tablePrefix) {
- return "insert into " + tablePrefix + "PRODUCTS_TO_CATEGORIES(PRODUCTS_ID, CATEGORIES_ID) values(? , ? )";
+ return "insert into " + tablePrefix + "PRODUCTS_TO_CATEGORIES(PRODUCTS_ID, CATEGORIES_ID, COMMENT) values(? , ? , ? )";
}
// ===================================================================================
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsManufacturersCB.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsManufacturersCB.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsManufacturersCB.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -189,7 +189,7 @@
// ===================================================================================
// Setup-Select
// ============
-
+
// ===================================================================================
// Basic Override
// ==============
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsCB.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -189,7 +189,51 @@
// ===================================================================================
// Setup-Select
// ============
-
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [MANUFACTURERS]
+ // ForeignProperty = [manufacturers]
+ // * * * * * * * * */
+
+ /** Is select for manufacturers? */
+ protected boolean _isSelectManufacturers;
+ /** Nest select setupper for manufacturers. */
+ protected ManufacturersNss _nssManufacturers;
+ /**
+ * Is select for manufacturers? {For Internal}
+ *
+ * @return Determination.
+ */
+ public boolean isSelectManufacturers() {
+ return _isSelectManufacturers;
+ }
+ /**
+ * Get nest select setupper for manufacturers. {For Internal}
+ *
+ * @return Nest select setupper. (NotNull)
+ */
+ public ManufacturersNss getNssManufacturers() {
+ if (_nssManufacturers == null) {
+ _nssManufacturers = new ManufacturersNss(null);// for Dummy
+ }
+ return _nssManufacturers;
+ }
+ /**
+ * Set up select for manufacturers.
+ * If you invoke this, this entity is target of select.
+ *
+ * @return Nest select setupper for manufacturers. (NotNull)
+ */
+ public ManufacturersNss setupSelect_Manufacturers() {
+ query().queryManufacturers();// For setting outer join.
+ if (_nssManufacturers == null || !_nssManufacturers.hasConditionQuery()) {
+ _nssManufacturers = new ManufacturersNss(query().queryManufacturers());
+ }
+ _isSelectManufacturers = true;
+ limitSelect_Off();
+ return _nssManufacturers;
+ }
+
// ===================================================================================
// Basic Override
// ==============
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsDescriptionCB.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsDescriptionCB.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsDescriptionCB.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -216,6 +216,50 @@
// ===================================================================================
// Setup-Select
// ============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /** Is select for products? */
+ protected boolean _isSelectProducts;
+ /** Nest select setupper for products. */
+ protected ProductsNss _nssProducts;
+ /**
+ * Is select for products? {For Internal}
+ *
+ * @return Determination.
+ */
+ public boolean isSelectProducts() {
+ return _isSelectProducts;
+ }
+ /**
+ * Get nest select setupper for products. {For Internal}
+ *
+ * @return Nest select setupper. (NotNull)
+ */
+ public ProductsNss getNssProducts() {
+ if (_nssProducts == null) {
+ _nssProducts = new ProductsNss(null);// for Dummy
+ }
+ return _nssProducts;
+ }
+ /**
+ * Set up select for products.
+ * If you invoke this, this entity is target of select.
+ *
+ * @return Nest select setupper for products. (NotNull)
+ */
+ public ProductsNss setupSelect_Products() {
+ query().queryProducts();// For setting outer join.
+ if (_nssProducts == null || !_nssProducts.hasConditionQuery()) {
+ _nssProducts = new ProductsNss(query().queryProducts());
+ }
+ _isSelectProducts = true;
+ limitSelect_Off();
+ return _nssProducts;
+ }
// ===================================================================================
// Basic Override
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsToCategoriesCB.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsToCategoriesCB.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsProductsToCategoriesCB.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -216,6 +216,50 @@
// ===================================================================================
// Setup-Select
// ============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /** Is select for products? */
+ protected boolean _isSelectProducts;
+ /** Nest select setupper for products. */
+ protected ProductsNss _nssProducts;
+ /**
+ * Is select for products? {For Internal}
+ *
+ * @return Determination.
+ */
+ public boolean isSelectProducts() {
+ return _isSelectProducts;
+ }
+ /**
+ * Get nest select setupper for products. {For Internal}
+ *
+ * @return Nest select setupper. (NotNull)
+ */
+ public ProductsNss getNssProducts() {
+ if (_nssProducts == null) {
+ _nssProducts = new ProductsNss(null);// for Dummy
+ }
+ return _nssProducts;
+ }
+ /**
+ * Set up select for products.
+ * If you invoke this, this entity is target of select.
+ *
+ * @return Nest select setupper for products. (NotNull)
+ */
+ public ProductsNss setupSelect_Products() {
+ query().queryProducts();// For setting outer join.
+ if (_nssProducts == null || !_nssProducts.hasConditionQuery()) {
+ _nssProducts = new ProductsNss(query().queryProducts());
+ }
+ _isSelectProducts = true;
+ limitSelect_Off();
+ return _nssProducts;
+ }
// ===================================================================================
// Basic Override
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersCQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersCQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -151,6 +151,23 @@
}
abstract public void keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery);
+
+ /**
+ * Set the sub-query of ManufacturersId_InScopeSubQuery_ProductsList using inScopeSubQuery.
+ * { in (select xxx.MANUFACTURERS_ID from PRODUCTS where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ManufacturersId_InScopeSubQuery_ProductsList using inScopeSubQuery. (NotNull)
+ */
+ public void setManufacturersId_InScopeSubQuery_ProductsList(ProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepManufacturersId_InScopeSubQuery_ProductsList(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_MANUFACTURERS_ID, "MANUFACTURERS_ID", "manufacturersId_InScopeSubQuery_ProductsList");
+ }
+
+ abstract public void keepManufacturersId_InScopeSubQuery_ProductsList(ProductsCQ subQuery);
/**
* Set the sub-query of ManufacturersId_ExistsSubQuery_ManufacturersInfoList using existsSubQuery.
@@ -168,6 +185,23 @@
}
abstract public void keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery);
+
+ /**
+ * Set the sub-query of ManufacturersId_ExistsSubQuery_ProductsList using existsSubQuery.
+ * { exists (select xxx.MANUFACTURERS_ID from PRODUCTS where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ManufacturersId_ExistsSubQuery_ProductsList using existsSubQuery. (NotNull)
+ */
+ public void setManufacturersId_ExistsSubQuery_ProductsList(ProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepManufacturersId_ExistsSubQuery_ProductsList(subQuery);// for saving query-value.
+ registerExistsSubQuery(subQuery, COL_MANUFACTURERS_ID, "MANUFACTURERS_ID", "manufacturersId_ExistsSubQuery_ProductsList");
+ }
+
+ abstract public void keepManufacturersId_ExistsSubQuery_ProductsList(ProductsCQ subQuery);
/**
* Register condition of manufacturersId.
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsCQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -134,6 +134,74 @@
public void setProductsId_NotInScope(java.util.List<java.math.BigDecimal> productsIdList) {
registerProductsId(ConditionKey.CK_NOT_IN_SCOPE, productsIdList);
}
+
+ /**
+ * Set the sub-query of ProductsId_InScopeSubQuery_ProductsDescriptionList using inScopeSubQuery.
+ * { in (select xxx.PRODUCTS_ID from PRODUCTS_DESCRIPTION where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_InScopeSubQuery_ProductsDescriptionList using inScopeSubQuery. (NotNull)
+ */
+ public void setProductsId_InScopeSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_InScopeSubQuery_ProductsDescriptionList(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_InScopeSubQuery_ProductsDescriptionList");
+ }
+
+ abstract public void keepProductsId_InScopeSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery);
+
+ /**
+ * Set the sub-query of ProductsId_InScopeSubQuery_ProductsToCategoriesList using inScopeSubQuery.
+ * { in (select xxx.PRODUCTS_ID from PRODUCTS_TO_CATEGORIES where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_InScopeSubQuery_ProductsToCategoriesList using inScopeSubQuery. (NotNull)
+ */
+ public void setProductsId_InScopeSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_InScopeSubQuery_ProductsToCategoriesList(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_InScopeSubQuery_ProductsToCategoriesList");
+ }
+
+ abstract public void keepProductsId_InScopeSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery);
+
+ /**
+ * Set the sub-query of ProductsId_ExistsSubQuery_ProductsDescriptionList using existsSubQuery.
+ * { exists (select xxx.PRODUCTS_ID from PRODUCTS_DESCRIPTION where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_ExistsSubQuery_ProductsDescriptionList using existsSubQuery. (NotNull)
+ */
+ public void setProductsId_ExistsSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_ExistsSubQuery_ProductsDescriptionList(subQuery);// for saving query-value.
+ registerExistsSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_ExistsSubQuery_ProductsDescriptionList");
+ }
+
+ abstract public void keepProductsId_ExistsSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery);
+
+ /**
+ * Set the sub-query of ProductsId_ExistsSubQuery_ProductsToCategoriesList using existsSubQuery.
+ * { exists (select xxx.PRODUCTS_ID from PRODUCTS_TO_CATEGORIES where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_ExistsSubQuery_ProductsToCategoriesList using existsSubQuery. (NotNull)
+ */
+ public void setProductsId_ExistsSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_ExistsSubQuery_ProductsToCategoriesList(subQuery);// for saving query-value.
+ registerExistsSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_ExistsSubQuery_ProductsToCategoriesList");
+ }
+
+ abstract public void keepProductsId_ExistsSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery);
/**
* Register condition of productsId.
@@ -1391,8 +1459,25 @@
public void setManufacturersId_NotInScope(java.util.List<java.math.BigDecimal> manufacturersIdList) {
registerManufacturersId(ConditionKey.CK_NOT_IN_SCOPE, manufacturersIdList);
}
-
+
/**
+ * Set the sub-query of ManufacturersId_InScopeSubQuery_Manufacturers using inScopeSubQuery.
+ * { in (select xxx.MANUFACTURERS_ID from MANUFACTURERS where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ManufacturersId_InScopeSubQuery_Manufacturers using inScopeSubQuery. (NotNull)
+ */
+ public void setManufacturersId_InScopeSubQuery_Manufacturers(ManufacturersCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepManufacturersId_InScopeSubQuery_Manufacturers(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_MANUFACTURERS_ID, "MANUFACTURERS_ID", "manufacturersId_InScopeSubQuery_Manufacturers");
+ }
+
+ abstract public void keepManufacturersId_InScopeSubQuery_Manufacturers(ManufacturersCQ subQuery);
+
+ /**
* Set the value of manufacturersId using isNull. { is null }
*/
public void setManufacturersId_IsNull() {
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsDescriptionCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsDescriptionCQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsDescriptionCQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -134,8 +134,25 @@
public void setProductsId_NotInScope(java.util.List<java.math.BigDecimal> productsIdList) {
registerProductsId(ConditionKey.CK_NOT_IN_SCOPE, productsIdList);
}
-
+
/**
+ * Set the sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery.
+ * { in (select xxx.PRODUCTS_ID from PRODUCTS where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. (NotNull)
+ */
+ public void setProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_InScopeSubQuery_Products(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_InScopeSubQuery_Products");
+ }
+
+ abstract public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery);
+
+ /**
* Register condition of productsId.
*
* @param key Condition key. (NotNull)
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsToCategoriesCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsToCategoriesCQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsProductsToCategoriesCQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -134,8 +134,25 @@
public void setProductsId_NotInScope(java.util.List<java.math.BigDecimal> productsIdList) {
registerProductsId(ConditionKey.CK_NOT_IN_SCOPE, productsIdList);
}
-
+
/**
+ * Set the sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery.
+ * { in (select xxx.PRODUCTS_ID from PRODUCTS where ...) }
+ * This method use from clause and where clause of the sub-query instance.
+ * this query keep the sub-query instance for query-value.
+ * After you invoke this, If you set query in the argument[subQuery], the query is ignored.
+ *
+ * @param subQuery The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. (NotNull)
+ */
+ public void setProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepProductsId_InScopeSubQuery_Products(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_PRODUCTS_ID, "PRODUCTS_ID", "productsId_InScopeSubQuery_Products");
+ }
+
+ abstract public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery);
+
+ /**
* Register condition of productsId.
*
* @param key Condition key. (NotNull)
@@ -261,6 +278,163 @@
}
abstract protected ConditionValue getCValueCategoriesId();
+
+ /** Column db name of comment. */
+ protected static final String COL_COMMENT = "COMMENT";
+
+ /** Column java name of comment. */
+ protected static final String J_Comment = "Comment";
+
+ /** Column uncapitalised java name of comment. */
+ protected static final String UJ_comment = "comment";
+
+ /**
+ * Set the value of comment using equal. { = }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param comment The value of comment as equal.
+ */
+ public void setComment_Equal(String comment) {
+ registerComment(ConditionKey.CK_EQUAL, filterRemoveEmptyString(comment));
+ }
+
+ /**
+ * Set the value of comment using notEqual. { != }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param comment The value of comment as notEqual.
+ */
+ public void setComment_NotEqual(String comment) {
+ registerComment(ConditionKey.CK_NOT_EQUAL, filterRemoveEmptyString(comment));
+ }
+
+ /**
+ * Set the value of comment using greaterThan. { > }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param comment The value of comment as greaterThan.
+ */
+ public void setComment_GreaterThan(String comment) {
+ registerComment(ConditionKey.CK_GREATER_THAN, filterRemoveEmptyString(comment));
+ }
+
+ /**
+ * Set the value of comment using lessThan. { < }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param comment The value of comment as lessThan.
+ */
+ public void setComment_LessThan(String comment) {
+ registerComment(ConditionKey.CK_LESS_THAN, filterRemoveEmptyString(comment));
+ }
+
+ /**
+ * Set the value of comment using greaterEqual. { >= }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param comment The value of comment as greaterEqual.
+ */
+ public void setComment_GreaterEqual(String comment) {
+ registerComment(ConditionKey.CK_GREATER_EQUAL, filterRemoveEmptyString(comment));
+ }
+
+ /**
+ * Set the value of comment using lessEqual. { <= }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param comment The value of comment as lessEqual.
+ */
+ public void setComment_LessEqual(String comment) {
+ registerComment(ConditionKey.CK_LESS_EQUAL, filterRemoveEmptyString(comment));
+ }
+
+ /**
+ * Set the value of comment using prefixSearch. { like 'xxx%' }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param comment The value of comment as prefixSearch.
+ */
+ public void setComment_PrefixSearch(String comment) {
+ registerComment(ConditionKey.CK_PREFIX_SEARCH, filterRemoveEmptyString(comment));
+ }
+
+ /**
+ * Set the value of comment using likeSearch. { like '%xxx%' }
+ * If the value is null or empty-string, this condition is ignored.
+ * You can invoke this method several times and the conditions are set up.
+ *
+ * @param comment The value of comment as likeSearch.
+ * @param likeSearchOption Like search option. (NotNull)
+ */
+ public void setComment_LikeSearch(String comment, jp.sf.pal.pompei.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
+ registerLikeSearchQuery(ConditionKey.CK_LIKE_SEARCH, filterRemoveEmptyString(comment), getCValueComment(), COL_COMMENT, J_Comment, UJ_comment, likeSearchOption);
+ }
+
+ /**
+ * Set the value of comment using inScope. { in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param commentList The value of comment as inScope.
+ */
+ public void setComment_InScope(java.util.List<String> commentList) {
+ registerComment(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyStringFromList(commentList));
+ }
+
+ /**
+ * Set the value of comment using inScope. { in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param comment The value of comment as inScope.
+ */
+ public void setComment_InScope(String comment, jp.sf.pal.pompei.allcommon.cbean.coption.InScopeOption option) {
+ registerInScopeQuery(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyString(comment), getCValueComment(), COL_COMMENT, J_Comment, UJ_comment, option);
+ }
+
+ /**
+ * Set the value of comment using notInScope. { not in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param commentList The value of comment as notInScope.
+ */
+ public void setComment_NotInScope(java.util.List<String> commentList) {
+ registerComment(ConditionKey.CK_NOT_IN_SCOPE, filterRemoveEmptyStringFromList(commentList));
+ }
+
+ /**
+ * Set the value of comment using isNull. { is null }
+ */
+ public void setComment_IsNull() {
+ registerComment(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
+ }
+
+ /**
+ * Set the value of comment using isNotNull. { is not null }
+ */
+ public void setComment_IsNotNull() {
+ registerComment(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
+ }
+
+ /**
+ * Register condition of comment.
+ *
+ * @param key Condition key. (NotNull)
+ * @param value The value of comment. (Nullable)
+ */
+ protected void registerComment(ConditionKey key, Object value) {
+ registerQuery(key, value, getCValueComment(), COL_COMMENT, J_Comment, UJ_comment);
+ }
+
+ /**
+ * Register inline condition of comment.
+ *
+ * @param key Condition key. (NotNull)
+ * @param value The value of comment. (Nullable)
+ */
+ protected void registerInlineComment(ConditionKey key, Object value) {
+ registerInlineQuery(key, value, getCValueComment(), COL_COMMENT, J_Comment, UJ_comment);
+ }
+
+ abstract protected ConditionValue getCValueComment();
// ===================================================================================
// Basic Override
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturersCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturersCQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturersCQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -192,6 +192,22 @@
public void keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
_manufacturersId_InScopeSubQuery_ManufacturersInfoList = subQuery;
}
+
+ /** The sub-query of ManufacturersId_InScopeSubQuery_ProductsList using inScopeSubQuery. */
+ protected ProductsCQ _manufacturersId_InScopeSubQuery_ProductsList;
+
+ /**
+ * Get the sub-query of ManufacturersId_InScopeSubQuery_ProductsList using inScopeSubQuery.
+ *
+ * @return The sub-query of ManufacturersId_InScopeSubQuery_ProductsList using inScopeSubQuery. (Nullable)
+ */
+ public ProductsCQ getManufacturersId_InScopeSubQuery_ProductsList() {
+ return _manufacturersId_InScopeSubQuery_ProductsList;
+ }
+
+ public void keepManufacturersId_InScopeSubQuery_ProductsList(ProductsCQ subQuery) {
+ _manufacturersId_InScopeSubQuery_ProductsList = subQuery;
+ }
/** The sub-query of ManufacturersId_ExistsSubQuery_ManufacturersInfoList using existsSubQuery. */
protected ManufacturersInfoCQ _manufacturersId_ExistsSubQuery_ManufacturersInfoList;
@@ -208,6 +224,22 @@
public void keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
_manufacturersId_ExistsSubQuery_ManufacturersInfoList = subQuery;
}
+
+ /** The sub-query of ManufacturersId_ExistsSubQuery_ProductsList using existsSubQuery. */
+ protected ProductsCQ _manufacturersId_ExistsSubQuery_ProductsList;
+
+ /**
+ * Get the sub-query of ManufacturersId_ExistsSubQuery_ProductsList using existsSubQuery.
+ *
+ * @return The sub-query of ManufacturersId_ExistsSubQuery_ProductsList using existsSubQuery. (Nullable)
+ */
+ public ProductsCQ getManufacturersId_ExistsSubQuery_ProductsList() {
+ return _manufacturersId_ExistsSubQuery_ProductsList;
+ }
+
+ public void keepManufacturersId_ExistsSubQuery_ProductsList(ProductsCQ subQuery) {
+ _manufacturersId_ExistsSubQuery_ProductsList = subQuery;
+ }
/**
* Add order-by of manufacturersId as ASC.
@@ -401,12 +433,12 @@
protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, ConditionQuery unionQueryAsSuper) {
final ManufacturersCQ baseQuery = (ManufacturersCQ)baseQueryAsSuper;
final ManufacturersCQ unionQuery = (ManufacturersCQ)unionQueryAsSuper;
-
+
}
// ===================================================================================
// Foreign Query
// =============
-
+
}
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsCQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -320,8 +320,72 @@
return getProductsId();
}
-
+
+ /** The sub-query of ProductsId_InScopeSubQuery_ProductsDescriptionList using inScopeSubQuery. */
+ protected ProductsDescriptionCQ _productsId_InScopeSubQuery_ProductsDescriptionList;
+
/**
+ * Get the sub-query of ProductsId_InScopeSubQuery_ProductsDescriptionList using inScopeSubQuery.
+ *
+ * @return The sub-query of ProductsId_InScopeSubQuery_ProductsDescriptionList using inScopeSubQuery. (Nullable)
+ */
+ public ProductsDescriptionCQ getProductsId_InScopeSubQuery_ProductsDescriptionList() {
+ return _productsId_InScopeSubQuery_ProductsDescriptionList;
+ }
+
+ public void keepProductsId_InScopeSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
+ _productsId_InScopeSubQuery_ProductsDescriptionList = subQuery;
+ }
+
+ /** The sub-query of ProductsId_InScopeSubQuery_ProductsToCategoriesList using inScopeSubQuery. */
+ protected ProductsToCategoriesCQ _productsId_InScopeSubQuery_ProductsToCategoriesList;
+
+ /**
+ * Get the sub-query of ProductsId_InScopeSubQuery_ProductsToCategoriesList using inScopeSubQuery.
+ *
+ * @return The sub-query of ProductsId_InScopeSubQuery_ProductsToCategoriesList using inScopeSubQuery. (Nullable)
+ */
+ public ProductsToCategoriesCQ getProductsId_InScopeSubQuery_ProductsToCategoriesList() {
+ return _productsId_InScopeSubQuery_ProductsToCategoriesList;
+ }
+
+ public void keepProductsId_InScopeSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery) {
+ _productsId_InScopeSubQuery_ProductsToCategoriesList = subQuery;
+ }
+
+ /** The sub-query of ProductsId_ExistsSubQuery_ProductsDescriptionList using existsSubQuery. */
+ protected ProductsDescriptionCQ _productsId_ExistsSubQuery_ProductsDescriptionList;
+
+ /**
+ * Get the sub-query of ProductsId_ExistsSubQuery_ProductsDescriptionList using existsSubQuery.
+ *
+ * @return The sub-query of ProductsId_ExistsSubQuery_ProductsDescriptionList using existsSubQuery. (Nullable)
+ */
+ public ProductsDescriptionCQ getProductsId_ExistsSubQuery_ProductsDescriptionList() {
+ return _productsId_ExistsSubQuery_ProductsDescriptionList;
+ }
+
+ public void keepProductsId_ExistsSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
+ _productsId_ExistsSubQuery_ProductsDescriptionList = subQuery;
+ }
+
+ /** The sub-query of ProductsId_ExistsSubQuery_ProductsToCategoriesList using existsSubQuery. */
+ protected ProductsToCategoriesCQ _productsId_ExistsSubQuery_ProductsToCategoriesList;
+
+ /**
+ * Get the sub-query of ProductsId_ExistsSubQuery_ProductsToCategoriesList using existsSubQuery.
+ *
+ * @return The sub-query of ProductsId_ExistsSubQuery_ProductsToCategoriesList using existsSubQuery. (Nullable)
+ */
+ public ProductsToCategoriesCQ getProductsId_ExistsSubQuery_ProductsToCategoriesList() {
+ return _productsId_ExistsSubQuery_ProductsToCategoriesList;
+ }
+
+ public void keepProductsId_ExistsSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery) {
+ _productsId_ExistsSubQuery_ProductsToCategoriesList = subQuery;
+ }
+
+ /**
* Add order-by of productsId as ASC.
*
* @return this. (NotNull)
@@ -782,8 +846,24 @@
return getManufacturersId();
}
-
+
+ /** The sub-query of ManufacturersId_InScopeSubQuery_Manufacturers using inScopeSubQuery. */
+ protected ManufacturersCQ _manufacturersId_InScopeSubQuery_Manufacturers;
+
/**
+ * Get the sub-query of ManufacturersId_InScopeSubQuery_Manufacturers using inScopeSubQuery.
+ *
+ * @return The sub-query of ManufacturersId_InScopeSubQuery_Manufacturers using inScopeSubQuery. (Nullable)
+ */
+ public ManufacturersCQ getManufacturersId_InScopeSubQuery_Manufacturers() {
+ return _manufacturersId_InScopeSubQuery_Manufacturers;
+ }
+
+ public void keepManufacturersId_InScopeSubQuery_Manufacturers(ManufacturersCQ subQuery) {
+ _manufacturersId_InScopeSubQuery_Manufacturers = subQuery;
+ }
+
+ /**
* Add order-by of manufacturersId as ASC.
*
* @return this. (NotNull)
@@ -849,12 +929,81 @@
protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, ConditionQuery unionQueryAsSuper) {
final ProductsCQ baseQuery = (ProductsCQ)baseQueryAsSuper;
final ProductsCQ unionQuery = (ProductsCQ)unionQueryAsSuper;
-
+
+ if (baseQuery.hasConditionQueryManufacturers()) {
+ unionQuery.queryManufacturers().reflectRelationOnUnionQuery(baseQuery.queryManufacturers(), unionQuery.queryManufacturers());
+ }
+
}
// ===================================================================================
// Foreign Query
// =============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [MANUFACTURERS]
+ // ForeignProperty = [manufacturers]
+ // * * * * * * * * */
+
+ /**
+ * Query for manufacturers.
+ *
+ * @return Instance of ManufacturersCQ as manufacturers. (NotNull)
+ */
+ public ManufacturersCQ queryManufacturers() {
+ return getConditionQueryManufacturers();
+ }
+
+ /** Condition-query for manufacturers. */
+ protected ManufacturersCQ _conditionQueryManufacturers;
+
+ /**
+ * Get condition-query for manufacturers.
+ *
+ * @return Instance of ManufacturersCQ as manufacturers. (NotNull)
+ */
+ public ManufacturersCQ getConditionQueryManufacturers() {
+ if (_conditionQueryManufacturers == null) {
+ _conditionQueryManufacturers = newQueryManufacturers();
+ setupOuterJoin_Manufacturers();
+ }
+ return _conditionQueryManufacturers;
+ }
+
+ /**
+ * Setup outer join for ${foreignPropertyName}.
+ */
+ protected void setupOuterJoin_Manufacturers() {
+ final java.util.Map<String, String> joinOnMap = new java.util.LinkedHashMap<String, String>();
+ String key = null;
+ String value = null;
+
+ key = getRealColumnName("MANUFACTURERS_ID");
+ value = getConditionQueryManufacturers().getRealColumnName("MANUFACTURERS_ID");
+ joinOnMap.put(key, value);
+
+ final String joinTableName = "MANUFACTURERS";
+ final String aliasName = getConditionQueryManufacturers().getRealAliasName();
+ getSqlClause().registerOuterJoin(joinTableName, aliasName, joinOnMap);
+ }
+
+ /**
+ * New query for manufacturers.
+ *
+ * @return Query for manufacturers. (NotNull)
+ */
+ protected ManufacturersCQ newQueryManufacturers() {
+ return new ManufacturersCQ(this, getSqlClause(), "Manufacturers", getNextNestLevel());
+ }
+
+ /**
+ * Has condition query?
+ *
+ * @return Determination.
+ */
+ public boolean hasConditionQueryManufacturers() {
+ return _conditionQueryManufacturers != null;
+ }
-
+
}
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsDescriptionCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsDescriptionCQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsDescriptionCQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -194,8 +194,24 @@
return getProductsId();
}
-
+
+ /** The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. */
+ protected ProductsCQ _productsId_InScopeSubQuery_Products;
+
/**
+ * Get the sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery.
+ *
+ * @return The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. (Nullable)
+ */
+ public ProductsCQ getProductsId_InScopeSubQuery_Products() {
+ return _productsId_InScopeSubQuery_Products;
+ }
+
+ public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ _productsId_InScopeSubQuery_Products = subQuery;
+ }
+
+ /**
* Add order-by of productsId as ASC.
*
* @return this. (NotNull)
@@ -429,12 +445,81 @@
protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, ConditionQuery unionQueryAsSuper) {
final ProductsDescriptionCQ baseQuery = (ProductsDescriptionCQ)baseQueryAsSuper;
final ProductsDescriptionCQ unionQuery = (ProductsDescriptionCQ)unionQueryAsSuper;
+
+ if (baseQuery.hasConditionQueryProducts()) {
+ unionQuery.queryProducts().reflectRelationOnUnionQuery(baseQuery.queryProducts(), unionQuery.queryProducts());
+ }
}
// ===================================================================================
// Foreign Query
// =============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /**
+ * Query for products.
+ *
+ * @return Instance of ProductsCQ as products. (NotNull)
+ */
+ public ProductsCQ queryProducts() {
+ return getConditionQueryProducts();
+ }
+
+ /** Condition-query for products. */
+ protected ProductsCQ _conditionQueryProducts;
+
+ /**
+ * Get condition-query for products.
+ *
+ * @return Instance of ProductsCQ as products. (NotNull)
+ */
+ public ProductsCQ getConditionQueryProducts() {
+ if (_conditionQueryProducts == null) {
+ _conditionQueryProducts = newQueryProducts();
+ setupOuterJoin_Products();
+ }
+ return _conditionQueryProducts;
+ }
+
+ /**
+ * Setup outer join for ${foreignPropertyName}.
+ */
+ protected void setupOuterJoin_Products() {
+ final java.util.Map<String, String> joinOnMap = new java.util.LinkedHashMap<String, String>();
+ String key = null;
+ String value = null;
+
+ key = getRealColumnName("PRODUCTS_ID");
+ value = getConditionQueryProducts().getRealColumnName("PRODUCTS_ID");
+ joinOnMap.put(key, value);
+
+ final String joinTableName = "PRODUCTS";
+ final String aliasName = getConditionQueryProducts().getRealAliasName();
+ getSqlClause().registerOuterJoin(joinTableName, aliasName, joinOnMap);
+ }
+
+ /**
+ * New query for products.
+ *
+ * @return Query for products. (NotNull)
+ */
+ protected ProductsCQ newQueryProducts() {
+ return new ProductsCQ(this, getSqlClause(), "Products", getNextNestLevel());
+ }
+
+ /**
+ * Has condition query?
+ *
+ * @return Determination.
+ */
+ public boolean hasConditionQueryProducts() {
+ return _conditionQueryProducts != null;
+ }
}
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsToCategoriesCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsToCategoriesCQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsProductsToCategoriesCQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -92,6 +92,24 @@
registerIncludedSelectColumn(aliasName, getRealColumnName("CATEGORIES_ID"));
}
+ /**
+ * Include select-column of comment as mine.
+ * Alias name is java-name of this column.
+ * Be careful to whether your table have the same column.
+ */
+ public void includeAsMine_Comment() {
+ registerIncludedSelectColumn("Comment", getRealColumnName("COMMENT"));
+ }
+
+ /**
+ * Include select-column of comment as mine.
+ *
+ * @param aliasName Alias name. {select columnName as aliasName from ...} This should not contain comma. (NotNull)
+ */
+ public void includeAsMine_Comment(String aliasName) {
+ registerIncludedSelectColumn(aliasName, getRealColumnName("COMMENT"));
+ }
+
// ===================================================================================
// Query
// =====
@@ -122,8 +140,24 @@
return getProductsId();
}
-
+
+ /** The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. */
+ protected ProductsCQ _productsId_InScopeSubQuery_Products;
+
/**
+ * Get the sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery.
+ *
+ * @return The sub-query of ProductsId_InScopeSubQuery_Products using inScopeSubQuery. (Nullable)
+ */
+ public ProductsCQ getProductsId_InScopeSubQuery_Products() {
+ return _productsId_InScopeSubQuery_Products;
+ }
+
+ public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ _productsId_InScopeSubQuery_Products = subQuery;
+ }
+
+ /**
* Add order-by of productsId as ASC.
*
* @return this. (NotNull)
@@ -183,18 +217,129 @@
getSqlClause().registerOrderBy(getRealColumnName(COL_CATEGORIES_ID), null, false);return this;
}
+ // /- - - - - - - - - - - - - - - - - - - - - - -
+ // Column = [COMMENT]
+ // - - - - - - - - -/
+
+ /** The attribute of comment. */
+ protected ConditionValue _comment;
+
+ /**
+ * Get the value of comment.
+ *
+ * @return The value of comment.
+ */
+ public ConditionValue getComment() {
+ if (_comment == null) {
+ _comment = new ConditionValue();
+ }
+ return _comment;
+ }
+
+ protected ConditionValue getCValueComment() {
+ return getComment();
+ }
+
+
+ /**
+ * Add order-by of comment as ASC.
+ *
+ * @return this. (NotNull)
+ */
+ public BsProductsToCategoriesCQ addOrderBy_Comment_Asc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_COMMENT), null, true);return this;
+ }
+
+ /**
+ * Add order-by of comment as DESC.
+ *
+ * @return this. (NotNull)
+ */
+ public BsProductsToCategoriesCQ addOrderBy_Comment_Desc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_COMMENT), null, false);return this;
+ }
+
// ===================================================================================
// Union Query
// ===========
protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, ConditionQuery unionQueryAsSuper) {
final ProductsToCategoriesCQ baseQuery = (ProductsToCategoriesCQ)baseQueryAsSuper;
final ProductsToCategoriesCQ unionQuery = (ProductsToCategoriesCQ)unionQueryAsSuper;
+
+ if (baseQuery.hasConditionQueryProducts()) {
+ unionQuery.queryProducts().reflectRelationOnUnionQuery(baseQuery.queryProducts(), unionQuery.queryProducts());
+ }
}
// ===================================================================================
// Foreign Query
// =============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ForeignTable = [PRODUCTS]
+ // ForeignProperty = [products]
+ // * * * * * * * * */
+
+ /**
+ * Query for products.
+ *
+ * @return Instance of ProductsCQ as products. (NotNull)
+ */
+ public ProductsCQ queryProducts() {
+ return getConditionQueryProducts();
+ }
+
+ /** Condition-query for products. */
+ protected ProductsCQ _conditionQueryProducts;
+
+ /**
+ * Get condition-query for products.
+ *
+ * @return Instance of ProductsCQ as products. (NotNull)
+ */
+ public ProductsCQ getConditionQueryProducts() {
+ if (_conditionQueryProducts == null) {
+ _conditionQueryProducts = newQueryProducts();
+ setupOuterJoin_Products();
+ }
+ return _conditionQueryProducts;
+ }
+
+ /**
+ * Setup outer join for ${foreignPropertyName}.
+ */
+ protected void setupOuterJoin_Products() {
+ final java.util.Map<String, String> joinOnMap = new java.util.LinkedHashMap<String, String>();
+ String key = null;
+ String value = null;
+
+ key = getRealColumnName("PRODUCTS_ID");
+ value = getConditionQueryProducts().getRealColumnName("PRODUCTS_ID");
+ joinOnMap.put(key, value);
+
+ final String joinTableName = "PRODUCTS";
+ final String aliasName = getConditionQueryProducts().getRealAliasName();
+ getSqlClause().registerOuterJoin(joinTableName, aliasName, joinOnMap);
+ }
+
+ /**
+ * New query for products.
+ *
+ * @return Query for products. (NotNull)
+ */
+ protected ProductsCQ newQueryProducts() {
+ return new ProductsCQ(this, getSqlClause(), "Products", getNextNestLevel());
+ }
+
+ /**
+ * Has condition query?
+ *
+ * @return Determination.
+ */
+ public boolean hasConditionQueryProducts() {
+ return _conditionQueryProducts != null;
+ }
}
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersCIQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersCIQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersCIQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -78,11 +78,20 @@
public void keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
_myCQ.keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(subQuery);
}
+
+ public void keepManufacturersId_InScopeSubQuery_ProductsList(ProductsCQ subQuery) {
+ _myCQ.keepManufacturersId_InScopeSubQuery_ProductsList(subQuery);
+ }
public void keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
// _myCQ.keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(subQuery);
}
+
+ public void keepManufacturersId_ExistsSubQuery_ProductsList(ProductsCQ subQuery) {
+ throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
+ // _myCQ.keepManufacturersId_ExistsSubQuery_ProductsList(subQuery);
+ }
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [MANUFACTURERS_NAME]
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsCIQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -74,7 +74,25 @@
return _myCQ.getProductsId();
}
-
+
+ public void keepProductsId_InScopeSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
+ _myCQ.keepProductsId_InScopeSubQuery_ProductsDescriptionList(subQuery);
+ }
+
+ public void keepProductsId_InScopeSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery) {
+ _myCQ.keepProductsId_InScopeSubQuery_ProductsToCategoriesList(subQuery);
+ }
+
+ public void keepProductsId_ExistsSubQuery_ProductsDescriptionList(ProductsDescriptionCQ subQuery) {
+ throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
+ // _myCQ.keepProductsId_ExistsSubQuery_ProductsDescriptionList(subQuery);
+ }
+
+ public void keepProductsId_ExistsSubQuery_ProductsToCategoriesList(ProductsToCategoriesCQ subQuery) {
+ throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
+ // _myCQ.keepProductsId_ExistsSubQuery_ProductsToCategoriesList(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [PRODUCTS_QUANTITY]
// - - - - - - - - -/
@@ -162,7 +180,11 @@
return _myCQ.getManufacturersId();
}
-
+
+ public void keepManufacturersId_InScopeSubQuery_Manufacturers(ManufacturersCQ subQuery) {
+ _myCQ.keepManufacturersId_InScopeSubQuery_Manufacturers(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [PRODUCTS_ORDERED]
// - - - - - - - - -/
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsDescriptionCIQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsDescriptionCIQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsDescriptionCIQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -74,7 +74,11 @@
return _myCQ.getProductsId();
}
-
+
+ public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ _myCQ.keepProductsId_InScopeSubQuery_Products(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [LANGUAGE_ID]
// - - - - - - - - -/
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsToCategoriesCIQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsToCategoriesCIQ.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ProductsToCategoriesCIQ.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -74,7 +74,11 @@
return _myCQ.getProductsId();
}
-
+
+ public void keepProductsId_InScopeSubQuery_Products(ProductsCQ subQuery) {
+ _myCQ.keepProductsId_InScopeSubQuery_Products(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [CATEGORIES_ID]
// - - - - - - - - -/
@@ -83,4 +87,12 @@
}
+ // /- - - - - - - - - - - - - - - - - - - - - - -
+ // Column = [COMMENT]
+ // - - - - - - - - -/
+ protected ConditionValue getCValueComment() {
+ return _myCQ.getComment();
+ }
+
+
}
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersNss.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersNss.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersNss.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -51,7 +51,7 @@
// ===================================================================================
// With...
// =======
-
+
// ===================================================================================
// Helper
// ======
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsDescriptionNss.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsDescriptionNss.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsDescriptionNss.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -52,6 +52,27 @@
// With...
// =======
+ /** Is select products? */
+ protected boolean _isSelectProducts;
+
+ /**
+ * Is select products?
+ *
+ * @return Determination.
+ */
+ public boolean isSelectProducts() {
+ return _isSelectProducts;
+ }
+
+ /**
+ * Set up select with products.
+ */
+ public void withProducts() {
+ assertConditionQuery();
+ _query.queryProducts();
+ _isSelectProducts = true;
+ }
+
// ===================================================================================
// Helper
// ======
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsNss.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -52,6 +52,27 @@
// With...
// =======
+ /** Is select manufacturers? */
+ protected boolean _isSelectManufacturers;
+
+ /**
+ * Is select manufacturers?
+ *
+ * @return Determination.
+ */
+ public boolean isSelectManufacturers() {
+ return _isSelectManufacturers;
+ }
+
+ /**
+ * Set up select with manufacturers.
+ */
+ public void withManufacturers() {
+ assertConditionQuery();
+ _query.queryManufacturers();
+ _isSelectManufacturers = true;
+ }
+
// ===================================================================================
// Helper
// ======
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsToCategoriesNss.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsToCategoriesNss.java 2007-07-22 23:42:30 UTC (rev 327)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ProductsToCategoriesNss.java 2007-07-22 23:48:44 UTC (rev 328)
@@ -52,6 +52,27 @@
// With...
// =======
+ /** Is select products? */
+ protected boolean _isSelectProducts;
+
+ /**
+ * Is select products?
+ *
+ * @return Determination.
+ */
+ public boolean isSelectProducts() {
+ return _isSelectProducts;
+ }
+
+ /**
+ * Set up select with products.
+ */
+ public void withProducts() {
+ assertConditionQuery();
+ _query.queryProducts();
+ _isSelectProducts = true;
+ }
+
// ===================================================================================
// Helper
// ======