svnno****@sourc*****
svnno****@sourc*****
2007年 7月 19日 (木) 06:06:28 JST
Revision: 299
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=299
Author: takeharu
Date: 2007-07-19 06:06:26 +0900 (Thu, 19 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/BsManufacturersInfoBhv.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersDao.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersInfoDao.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturers.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturersInfo.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/ManufacturersInfoDbm.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/BsManufacturersInfoCB.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/AbstractBsManufacturersInfoCQ.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/BsManufacturersInfoCQ.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/ManufacturersInfoCIQ.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersInfoNss.java
pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersNss.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-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsManufacturersBhv.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -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.*;
@@ -32,13 +34,13 @@
*
*
* [refferer-property]
- *
+ * manufacturersInfoList
*
* [sequence]
*
*
* [identity]
- *
+ * manufacturersId
*
* [update-date]
*
@@ -456,10 +458,156 @@
// Load Referer
// ============
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // RefererTable = [MANUFACTURERS_INFO]
+ // RefererProperty = [manufacturersInfoList]
+ // * * * * * * * * */
+
+ /**
+ * Load referer of manufacturersInfoList.
+ * <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.loadManufacturersInfoList(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 loadManufacturersInfoList(java.util.List<Manufacturers> manufacturersList) {
+ final ConditionBeanSetupper<ManufacturersInfoCB> conditionBeanSetupper = new ConditionBeanSetupper<ManufacturersInfoCB>() {
+ public void setup(ManufacturersInfoCB cb) {
+ }
+ };
+ loadManufacturersInfoList(manufacturersList, conditionBeanSetupper);
+ }
+
+ /**
+ * Load referer of manufacturersInfoList.
+ * <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<ManufacturersInfoCB> conditionBeanSetupper = new ConditionBeanSetupper<ManufacturersInfoCB>() {
+ * public void setup(ManufacturersInfoCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * manufacturersBhv.loadManufacturersInfoList(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 loadManufacturersInfoList(java.util.List<Manufacturers> manufacturersList, ConditionBeanSetupper<ManufacturersInfoCB> conditionBeanSetupper) {
+ assertObjectNotNull("manufacturersList<Manufacturers>", manufacturersList);
+ assertObjectNotNull("conditionBeanSetupper<ManufacturersInfoCB>", conditionBeanSetupper);
+ if (manufacturersList.isEmpty()) {
+ return;
+ }
+ loadManufacturersInfoList(manufacturersList, new LoadRefererOption<ManufacturersInfoCB, ManufacturersInfo>(conditionBeanSetupper));
+ }
+
+ /**
+ * Load referer of manufacturersInfoList.
+ * <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<ManufacturersInfoCB> cbSetupper = new ConditionBeanSetupper<ManufacturersInfoCB>() {
+ * public void setup(ManufacturersInfoCB cb) {
+ * cb.query().setXxx_IsNotNull();
+ * cb.query().addOrderBy_Yyy_Desc();
+ * }
+ * };
+ * manufacturersBhv.loadManufacturersInfoList(manufacturersList, new LoadRefererOption<ManufacturersInfoCB, ManufacturersInfo>(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 loadManufacturersInfoList(java.util.List<Manufacturers> manufacturersList, LoadRefererOption<ManufacturersInfoCB, ManufacturersInfo> loadRefererOption) {
+ assertObjectNotNull("manufacturersList<Manufacturers>", manufacturersList);
+ assertObjectNotNull("loadRefererOption<ManufacturersInfo, ManufacturersInfoCB>", 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 ManufacturersInfoBhv refererBhv = getDaoSelector().getBehavior(ManufacturersInfoBhv.class);
+ final ManufacturersInfoCB 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<ManufacturersInfo> reffererList = refererBhv.selectList(cb);
+ loadRefererOption.delegateEntitySettingUp(reffererList);
+
+ final java.util.Map<java.math.BigDecimal, java.util.List<ManufacturersInfo>> pkReffererListMap = new java.util.LinkedHashMap<java.math.BigDecimal, java.util.List<ManufacturersInfo>>();
+ for (ManufacturersInfo reffererEntity : reffererList) {
+ if (!pkReffererListMap.containsKey(toLowerCaseIfString(reffererEntity.getManufacturersId()))) {
+ pkReffererListMap.put((java.math.BigDecimal)toLowerCaseIfString(reffererEntity.getManufacturersId()), new java.util.ArrayList<ManufacturersInfo>());
+ }
+ (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.setManufacturersInfoList((java.util.List<ManufacturersInfo>)pkReffererListMap.get(toLowerCaseIfString(manufacturers.getManufacturersId())));
+ } else {
+ manufacturers.setManufacturersInfoList(new java.util.ArrayList<ManufacturersInfo>());
+ }
+ }
+ }
+
// ===================================================================================
// Pull Out Foreign
// ================
-
+
// ===================================================================================
// Basic Entity Update
// ===================
@@ -679,6 +827,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 manufacturersId) {
+ Manufacturers entity = new Manufacturers();
+ entity.setManufacturersId(manufacturersId);
+ final ManufacturersCB cb = newMyConditionBean();
+ cb.acceptPrimaryKeyMapString(getDBMeta().extractPrimaryKeyMapString(entity));
+ final Manufacturers currentEntity = selectEntityWithDeletedCheck(cb);
+ return delegateInsert(currentEntity);
+ }
+
+ /**
+ * Filter 'copy-insert' entity.
+ *
+ * @param manufacturers Entity. (NotNull)
+ */
+ protected void filterCopyInsertEntity(Manufacturers manufacturers) {
+ }
// ===================================================================================
// CBSetupper
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsManufacturersInfoBhv.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsManufacturersInfoBhv.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsbhv/BsManufacturersInfoBhv.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -26,10 +26,10 @@
* MANUFACTURERS_ID, LANGUAGES_ID
*
* [column-property]
- * MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, URL_CLICKED, DATE_LAST_CLICK
+ * MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, MANUFACTURERS_SHORT_DESC, MANUFACTURERS_LONG_DESC, URL_CLICKED, DATE_LAST_CLICK
*
* [foreign-property]
- *
+ * manufacturers
*
* [refferer-property]
*
@@ -456,6 +456,26 @@
// Pull Out Foreign
// ================
+ /**
+ * Pull out the list of foreign table 'Manufacturers'.
+ *
+ * @param manufacturersInfoList The list of manufacturersInfo. (NotNull)
+ * @return The list of foreign table. (NotNull)
+ */
+ public java.util.List<Manufacturers> pulloutManufacturers(java.util.List<ManufacturersInfo> manufacturersInfoList) {
+ assertObjectNotNull("manufacturersInfoList", manufacturersInfoList);
+ final java.util.Set<Manufacturers> foreignSet = new java.util.LinkedHashSet<Manufacturers>();
+ for (java.util.Iterator ite = manufacturersInfoList.iterator(); ite.hasNext(); ) {
+ final ManufacturersInfo manufacturersInfo = (ManufacturersInfo)ite.next();
+ final Manufacturers foreignEntity = manufacturersInfo.getManufacturers();
+ if (foreignEntity == null || foreignSet.contains(foreignEntity)) {
+ continue;
+ }
+ foreignSet.add(foreignEntity);
+ }
+ return new java.util.ArrayList<Manufacturers>(foreignSet);
+ }
+
// ===================================================================================
// Basic Entity Update
// ===================
@@ -591,6 +611,8 @@
if (names.contains("manufacturersId")) { destinationMyEntity.setManufacturersId(sourceMyEntity.getManufacturersId()); }
if (names.contains("languagesId")) { destinationMyEntity.setLanguagesId(sourceMyEntity.getLanguagesId()); }
if (names.contains("manufacturersUrl")) { destinationMyEntity.setManufacturersUrl(sourceMyEntity.getManufacturersUrl()); }
+ if (names.contains("manufacturersShortDesc")) { destinationMyEntity.setManufacturersShortDesc(sourceMyEntity.getManufacturersShortDesc()); }
+ if (names.contains("manufacturersLongDesc")) { destinationMyEntity.setManufacturersLongDesc(sourceMyEntity.getManufacturersLongDesc()); }
if (names.contains("urlClicked")) { destinationMyEntity.setUrlClicked(sourceMyEntity.getUrlClicked()); }
if (names.contains("dateLastClick")) { destinationMyEntity.setDateLastClick(sourceMyEntity.getDateLastClick()); }
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-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersDao.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -17,13 +17,13 @@
*
*
* [refferer-property]
- *
+ * manufacturersInfoList
*
* [sequence]
*
*
* [identity]
- *
+ * manufacturersId
*
* [update-date]
*
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersInfoDao.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersInfoDao.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsdao/BsManufacturersInfoDao.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -11,10 +11,10 @@
* MANUFACTURERS_ID, LANGUAGES_ID
*
* [column-property]
- * MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, URL_CLICKED, DATE_LAST_CLICK
+ * MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, MANUFACTURERS_SHORT_DESC, MANUFACTURERS_LONG_DESC, URL_CLICKED, DATE_LAST_CLICK
*
* [foreign-property]
- *
+ * manufacturers
*
* [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-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturers.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -19,13 +19,13 @@
*
*
* [refferer-property]
- *
+ * manufacturersInfoList
*
* [sequence]
*
*
* [identity]
- *
+ * manufacturersId
*
* [update-date]
*
@@ -45,6 +45,9 @@
/** TABLE-Annotation for S2Dao */
public static final String TABLE = "MANUFACTURERS";
+
+ /** ID-Annotation */
+ public static final String manufacturersId_ID = "identity";
// ===================================================================================
// Attribute
@@ -53,7 +56,7 @@
protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties();
- /** The value of manufacturersId. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** The value of manufacturersId. ColumnDefinition -- PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]*/
protected java.math.BigDecimal _manufacturersId;
/** The value of manufacturersName. ColumnDefinition -- VARCHAR(32) : NotNull*/
@@ -124,12 +127,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 manufacturersId_COLUMN = "MANUFACTURERS_ID";
/**
* Get the value of manufacturersId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @return The value of manufacturersId. (Nullable)
*/
@@ -139,7 +142,7 @@
/**
* Set the value of manufacturersId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INC : INTEGER : NotNull : Default=[AUTOINCREMENT: start 1 increment 1]}
*
* @param manufacturersId The value of manufacturersId. (Nullable)
*/
@@ -267,6 +270,34 @@
// Refferer Table
// ==============
+
+ // /* * * * * * * * * * * * * * * * * * * * * * *
+ // ReffererTable = [MANUFACTURERS_INFO]
+ // ReffererProperty = [manufacturersInfoList]
+ // * * * * * * * * */
+
+ /** The list of refferer table. */
+ protected java.util.List<jp.sf.pal.pompei.exentity.ManufacturersInfo> _childrenManufacturersInfoList;
+
+ /**
+ * 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.ManufacturersInfo> getManufacturersInfoList() {
+ return _childrenManufacturersInfoList;
+ }
+
+ /**
+ * Set the list of refferer table.
+ *
+ * @param value The list of refferer table. (Nullable)
+ */
+ public void setManufacturersInfoList(java.util.List<jp.sf.pal.pompei.exentity.ManufacturersInfo> entity) {
+ this._childrenManufacturersInfoList = entity;
+ }
+
// ===================================================================================
// Accept
// ======
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturersInfo.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturersInfo.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/BsManufacturersInfo.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -13,10 +13,10 @@
* MANUFACTURERS_ID, LANGUAGES_ID
*
* [column-property]
- * MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, URL_CLICKED, DATE_LAST_CLICK
+ * MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, MANUFACTURERS_SHORT_DESC, MANUFACTURERS_LONG_DESC, URL_CLICKED, DATE_LAST_CLICK
*
* [foreign-property]
- *
+ * manufacturers
*
* [refferer-property]
*
@@ -53,7 +53,7 @@
protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties();
- /** The value of manufacturersId. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** The value of manufacturersId. ColumnDefinition -- PK : INTEGER : NotNull : FK to MANUFACTURERS*/
protected java.math.BigDecimal _manufacturersId;
/** The value of languagesId. ColumnDefinition -- PK : INTEGER : NotNull*/
@@ -62,6 +62,12 @@
/** The value of manufacturersUrl. ColumnDefinition -- VARCHAR(255) : NotNull*/
protected String _manufacturersUrl;
+ /** The value of manufacturersShortDesc. ColumnDefinition -- VARCHAR(100)*/
+ protected String _manufacturersShortDesc;
+
+ /** The value of manufacturersLongDesc. ColumnDefinition -- VARCHAR(1000)*/
+ protected String _manufacturersLongDesc;
+
/** The value of urlClicked. ColumnDefinition -- INTEGER : NotNull : Default=[0]*/
protected java.math.BigDecimal _urlClicked;
@@ -124,12 +130,12 @@
// Accessor
// ========
- /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull*/
+ /** Column-Annotation for S2Dao. ColumnDefinition -- PK : INTEGER : NotNull : FK to MANUFACTURERS*/
public static final String manufacturersId_COLUMN = "MANUFACTURERS_ID";
/**
* Get the value of manufacturersId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INTEGER : NotNull : FK to MANUFACTURERS}
*
* @return The value of manufacturersId. (Nullable)
*/
@@ -139,7 +145,7 @@
/**
* Set the value of manufacturersId. <br />
- * {PK : INTEGER : NotNull}
+ * {PK : INTEGER : NotNull : FK to MANUFACTURERS}
*
* @param manufacturersId The value of manufacturersId. (Nullable)
*/
@@ -196,6 +202,54 @@
_manufacturersUrl = manufacturersUrl;
}
+ /** Column-Annotation for S2Dao. ColumnDefinition -- VARCHAR(100)*/
+ public static final String manufacturersShortDesc_COLUMN = "MANUFACTURERS_SHORT_DESC";
+
+ /**
+ * Get the value of manufacturersShortDesc. <br />
+ * {VARCHAR(100)}
+ *
+ * @return The value of manufacturersShortDesc. (Nullable)
+ */
+ public String getManufacturersShortDesc() {
+ return _manufacturersShortDesc;
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc. <br />
+ * {VARCHAR(100)}
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc. (Nullable)
+ */
+ public void setManufacturersShortDesc(String manufacturersShortDesc) {
+ _modifiedProperties.addPropertyName("manufacturersShortDesc");
+ _manufacturersShortDesc = manufacturersShortDesc;
+ }
+
+ /** Column-Annotation for S2Dao. ColumnDefinition -- VARCHAR(1000)*/
+ public static final String manufacturersLongDesc_COLUMN = "MANUFACTURERS_LONG_DESC";
+
+ /**
+ * Get the value of manufacturersLongDesc. <br />
+ * {VARCHAR(1000)}
+ *
+ * @return The value of manufacturersLongDesc. (Nullable)
+ */
+ public String getManufacturersLongDesc() {
+ return _manufacturersLongDesc;
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc. <br />
+ * {VARCHAR(1000)}
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc. (Nullable)
+ */
+ public void setManufacturersLongDesc(String manufacturersLongDesc) {
+ _modifiedProperties.addPropertyName("manufacturersLongDesc");
+ _manufacturersLongDesc = manufacturersLongDesc;
+ }
+
/** Column-Annotation for S2Dao. ColumnDefinition -- INTEGER : NotNull : Default=[0]*/
public static final String urlClicked_COLUMN = "URL_CLICKED";
@@ -248,21 +302,63 @@
// ===================================================================================
// Classify Method
// ===============
-
+
// ===================================================================================
// Classification Determination
// ============================
-
+
// ===================================================================================
// Classification Getter
// =====================
-
+
// ===================================================================================
// 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
// ==============
@@ -471,6 +567,8 @@
sb.append(delimiter).append(getManufacturersId());
sb.append(delimiter).append(getLanguagesId());
sb.append(delimiter).append(getManufacturersUrl());
+ sb.append(delimiter).append(getManufacturersShortDesc());
+ sb.append(delimiter).append(getManufacturersLongDesc());
sb.append(delimiter).append(getUrlClicked());
sb.append(delimiter).append(getDateLastClick());
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-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturersDbm.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -20,13 +20,13 @@
*
*
* [refferer-property]
- *
+ * manufacturersInfoList
*
* [sequence]
*
*
* [identity]
- *
+ * manufacturersId
*
* [update-date]
*
@@ -105,6 +105,8 @@
public static final String COLUMN_CAP_PROP_NAME_OF_LastModified = "LastModified";
+ /** Cap-prop-name of ManufacturersInfoList. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_ManufacturersInfoList = "ManufacturersInfoList";
/** Uncap-prop-name of ManufacturersId. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ManufacturersId = "manufacturersId";
@@ -118,6 +120,8 @@
public static final String COLUMN_UNCAP_PROP_NAME_OF_LastModified = "lastModified";
+ /** Uncap-prop-name of manufacturersInfoList. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_ManufacturersInfoList = "manufacturersInfoList";
/** {db-name : cap-prop-name} map. */
private static java.util.Map<String, String> _dbNameCapPropNameMap;
@@ -460,7 +464,7 @@
throw new RuntimeException(e.getCause());
}
}
-
+
// ===================================================================================
// Determination
// =============
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturersInfoDbm.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturersInfoDbm.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/bsentity/dbmeta/ManufacturersInfoDbm.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -14,10 +14,10 @@
* MANUFACTURERS_ID, LANGUAGES_ID
*
* [column-property]
- * MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, URL_CLICKED, DATE_LAST_CLICK
+ * MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, MANUFACTURERS_SHORT_DESC, MANUFACTURERS_LONG_DESC, URL_CLICKED, DATE_LAST_CLICK
*
* [foreign-property]
- *
+ * manufacturers
*
* [refferer-property]
*
@@ -88,6 +88,10 @@
public static final String COLUMN_DB_NAME_OF_LanguagesId = "LANGUAGES_ID";
/** Db-name of ManufacturersUrl. */
public static final String COLUMN_DB_NAME_OF_ManufacturersUrl = "MANUFACTURERS_URL";
+ /** Db-name of ManufacturersShortDesc. */
+ public static final String COLUMN_DB_NAME_OF_ManufacturersShortDesc = "MANUFACTURERS_SHORT_DESC";
+ /** Db-name of ManufacturersLongDesc. */
+ public static final String COLUMN_DB_NAME_OF_ManufacturersLongDesc = "MANUFACTURERS_LONG_DESC";
/** Db-name of UrlClicked. */
public static final String COLUMN_DB_NAME_OF_UrlClicked = "URL_CLICKED";
/** Db-name of DateLastClick. */
@@ -99,11 +103,17 @@
public static final String COLUMN_CAP_PROP_NAME_OF_LanguagesId = "LanguagesId";
/** Cap-prop-name of ManufacturersUrl. */
public static final String COLUMN_CAP_PROP_NAME_OF_ManufacturersUrl = "ManufacturersUrl";
+ /** Cap-prop-name of ManufacturersShortDesc. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_ManufacturersShortDesc = "ManufacturersShortDesc";
+ /** Cap-prop-name of ManufacturersLongDesc. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_ManufacturersLongDesc = "ManufacturersLongDesc";
/** Cap-prop-name of UrlClicked. */
public static final String COLUMN_CAP_PROP_NAME_OF_UrlClicked = "UrlClicked";
/** Cap-prop-name of DateLastClick. */
public static final String COLUMN_CAP_PROP_NAME_OF_DateLastClick = "DateLastClick";
+ /** Cap-prop-name of manufacturers. */
+ public static final String COLUMN_CAP_PROP_NAME_OF_Manufacturers = "Manufacturers";
/** Uncap-prop-name of ManufacturersId. */
@@ -112,11 +122,17 @@
public static final String COLUMN_UNCAP_PROP_NAME_OF_LanguagesId = "languagesId";
/** Uncap-prop-name of ManufacturersUrl. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_ManufacturersUrl = "manufacturersUrl";
+ /** Uncap-prop-name of ManufacturersShortDesc. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_ManufacturersShortDesc = "manufacturersShortDesc";
+ /** Uncap-prop-name of ManufacturersLongDesc. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_ManufacturersLongDesc = "manufacturersLongDesc";
/** Uncap-prop-name of UrlClicked. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_UrlClicked = "urlClicked";
/** Uncap-prop-name of DateLastClick. */
public static final String COLUMN_UNCAP_PROP_NAME_OF_DateLastClick = "dateLastClick";
+ /** Uncap-prop-name of manufacturers. */
+ public static final String COLUMN_UNCAP_PROP_NAME_OF_Manufacturers = "manufacturers";
/** {db-name : cap-prop-name} map. */
@@ -131,6 +147,8 @@
map.put(COLUMN_DB_NAME_OF_ManufacturersId, COLUMN_CAP_PROP_NAME_OF_ManufacturersId);
map.put(COLUMN_DB_NAME_OF_LanguagesId, COLUMN_CAP_PROP_NAME_OF_LanguagesId);
map.put(COLUMN_DB_NAME_OF_ManufacturersUrl, COLUMN_CAP_PROP_NAME_OF_ManufacturersUrl);
+ map.put(COLUMN_DB_NAME_OF_ManufacturersShortDesc, COLUMN_CAP_PROP_NAME_OF_ManufacturersShortDesc);
+ map.put(COLUMN_DB_NAME_OF_ManufacturersLongDesc, COLUMN_CAP_PROP_NAME_OF_ManufacturersLongDesc);
map.put(COLUMN_DB_NAME_OF_UrlClicked, COLUMN_CAP_PROP_NAME_OF_UrlClicked);
map.put(COLUMN_DB_NAME_OF_DateLastClick, COLUMN_CAP_PROP_NAME_OF_DateLastClick);
@@ -150,6 +168,8 @@
map.put(COLUMN_DB_NAME_OF_ManufacturersId, COLUMN_UNCAP_PROP_NAME_OF_ManufacturersId);
map.put(COLUMN_DB_NAME_OF_LanguagesId, COLUMN_UNCAP_PROP_NAME_OF_LanguagesId);
map.put(COLUMN_DB_NAME_OF_ManufacturersUrl, COLUMN_UNCAP_PROP_NAME_OF_ManufacturersUrl);
+ map.put(COLUMN_DB_NAME_OF_ManufacturersShortDesc, COLUMN_UNCAP_PROP_NAME_OF_ManufacturersShortDesc);
+ map.put(COLUMN_DB_NAME_OF_ManufacturersLongDesc, COLUMN_UNCAP_PROP_NAME_OF_ManufacturersLongDesc);
map.put(COLUMN_DB_NAME_OF_UrlClicked, COLUMN_UNCAP_PROP_NAME_OF_UrlClicked);
map.put(COLUMN_DB_NAME_OF_DateLastClick, COLUMN_UNCAP_PROP_NAME_OF_DateLastClick);
@@ -169,6 +189,8 @@
map.put(COLUMN_CAP_PROP_NAME_OF_ManufacturersId, COLUMN_DB_NAME_OF_ManufacturersId);
map.put(COLUMN_CAP_PROP_NAME_OF_LanguagesId, COLUMN_DB_NAME_OF_LanguagesId);
map.put(COLUMN_CAP_PROP_NAME_OF_ManufacturersUrl, COLUMN_DB_NAME_OF_ManufacturersUrl);
+ map.put(COLUMN_CAP_PROP_NAME_OF_ManufacturersShortDesc, COLUMN_DB_NAME_OF_ManufacturersShortDesc);
+ map.put(COLUMN_CAP_PROP_NAME_OF_ManufacturersLongDesc, COLUMN_DB_NAME_OF_ManufacturersLongDesc);
map.put(COLUMN_CAP_PROP_NAME_OF_UrlClicked, COLUMN_DB_NAME_OF_UrlClicked);
map.put(COLUMN_CAP_PROP_NAME_OF_DateLastClick, COLUMN_DB_NAME_OF_DateLastClick);
@@ -188,6 +210,8 @@
map.put(COLUMN_CAP_PROP_NAME_OF_ManufacturersId, COLUMN_UNCAP_PROP_NAME_OF_ManufacturersId);
map.put(COLUMN_CAP_PROP_NAME_OF_LanguagesId, COLUMN_UNCAP_PROP_NAME_OF_LanguagesId);
map.put(COLUMN_CAP_PROP_NAME_OF_ManufacturersUrl, COLUMN_UNCAP_PROP_NAME_OF_ManufacturersUrl);
+ map.put(COLUMN_CAP_PROP_NAME_OF_ManufacturersShortDesc, COLUMN_UNCAP_PROP_NAME_OF_ManufacturersShortDesc);
+ map.put(COLUMN_CAP_PROP_NAME_OF_ManufacturersLongDesc, COLUMN_UNCAP_PROP_NAME_OF_ManufacturersLongDesc);
map.put(COLUMN_CAP_PROP_NAME_OF_UrlClicked, COLUMN_UNCAP_PROP_NAME_OF_UrlClicked);
map.put(COLUMN_CAP_PROP_NAME_OF_DateLastClick, COLUMN_UNCAP_PROP_NAME_OF_DateLastClick);
@@ -207,6 +231,8 @@
map.put(COLUMN_UNCAP_PROP_NAME_OF_ManufacturersId, COLUMN_DB_NAME_OF_ManufacturersId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_LanguagesId, COLUMN_DB_NAME_OF_LanguagesId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_ManufacturersUrl, COLUMN_DB_NAME_OF_ManufacturersUrl);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_ManufacturersShortDesc, COLUMN_DB_NAME_OF_ManufacturersShortDesc);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_ManufacturersLongDesc, COLUMN_DB_NAME_OF_ManufacturersLongDesc);
map.put(COLUMN_UNCAP_PROP_NAME_OF_UrlClicked, COLUMN_DB_NAME_OF_UrlClicked);
map.put(COLUMN_UNCAP_PROP_NAME_OF_DateLastClick, COLUMN_DB_NAME_OF_DateLastClick);
@@ -226,6 +252,8 @@
map.put(COLUMN_UNCAP_PROP_NAME_OF_ManufacturersId, COLUMN_CAP_PROP_NAME_OF_ManufacturersId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_LanguagesId, COLUMN_CAP_PROP_NAME_OF_LanguagesId);
map.put(COLUMN_UNCAP_PROP_NAME_OF_ManufacturersUrl, COLUMN_CAP_PROP_NAME_OF_ManufacturersUrl);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_ManufacturersShortDesc, COLUMN_CAP_PROP_NAME_OF_ManufacturersShortDesc);
+ map.put(COLUMN_UNCAP_PROP_NAME_OF_ManufacturersLongDesc, COLUMN_CAP_PROP_NAME_OF_ManufacturersLongDesc);
map.put(COLUMN_UNCAP_PROP_NAME_OF_UrlClicked, COLUMN_CAP_PROP_NAME_OF_UrlClicked);
map.put(COLUMN_UNCAP_PROP_NAME_OF_DateLastClick, COLUMN_CAP_PROP_NAME_OF_DateLastClick);
@@ -356,7 +384,7 @@
* @return Column-db-name comma-string. (NotNull)
*/
public String getColumnDbNameCommaString() {
- return "MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, URL_CLICKED, DATE_LAST_CLICK";
+ return "MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, MANUFACTURERS_SHORT_DESC, MANUFACTURERS_LONG_DESC, URL_CLICKED, DATE_LAST_CLICK";
}
// ===================================================================================
@@ -461,6 +489,15 @@
}
}
+ /**
+ * Get foreign dbmeta of Manufacturers.
+ *
+ * @return Foreign DBMeta. (NotNull)
+ */
+ public ManufacturersDbm getForeignDBMeta_Manufacturers() {
+ return ManufacturersDbm.getInstance();
+ }
+
// ===================================================================================
// Determination
// =============
@@ -531,6 +568,8 @@
if (analyzer.init("MANUFACTURERS_ID", "manufacturersId", "manufacturersId")) { myEntity.setManufacturersId(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
if (analyzer.init("LANGUAGES_ID", "languagesId", "languagesId")) { myEntity.setLanguagesId(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
if (analyzer.init("MANUFACTURERS_URL", "manufacturersUrl", "manufacturersUrl")) { myEntity.setManufacturersUrl(analyzer.analyzeString(String.class)); };
+ if (analyzer.init("MANUFACTURERS_SHORT_DESC", "manufacturersShortDesc", "manufacturersShortDesc")) { myEntity.setManufacturersShortDesc(analyzer.analyzeString(String.class)); };
+ if (analyzer.init("MANUFACTURERS_LONG_DESC", "manufacturersLongDesc", "manufacturersLongDesc")) { myEntity.setManufacturersLongDesc(analyzer.analyzeString(String.class)); };
if (analyzer.init("URL_CLICKED", "urlClicked", "urlClicked")) { myEntity.setUrlClicked(analyzer.analyzeNumber(java.math.BigDecimal.class)); };
if (analyzer.init("DATE_LAST_CLICK", "dateLastClick", "dateLastClick")) { myEntity.setDateLastClick(analyzer.analyzeDate(java.sql.Timestamp.class)); };
@@ -610,6 +649,8 @@
helpAppendingColumnValueString(sb, delimiter, equal, "MANUFACTURERS_ID", myEntity.getManufacturersId());
helpAppendingColumnValueString(sb, delimiter, equal, "LANGUAGES_ID", myEntity.getLanguagesId());
helpAppendingColumnValueString(sb, delimiter, equal, "MANUFACTURERS_URL", myEntity.getManufacturersUrl());
+ helpAppendingColumnValueString(sb, delimiter, equal, "MANUFACTURERS_SHORT_DESC", myEntity.getManufacturersShortDesc());
+ helpAppendingColumnValueString(sb, delimiter, equal, "MANUFACTURERS_LONG_DESC", myEntity.getManufacturersLongDesc());
helpAppendingColumnValueString(sb, delimiter, equal, "URL_CLICKED", myEntity.getUrlClicked());
helpAppendingColumnValueString(sb, delimiter, equal, "DATE_LAST_CLICK", myEntity.getDateLastClick());
@@ -657,6 +698,8 @@
valueMap.put("MANUFACTURERS_ID", myEntity.getManufacturersId());
valueMap.put("LANGUAGES_ID", myEntity.getLanguagesId());
valueMap.put("MANUFACTURERS_URL", myEntity.getManufacturersUrl());
+ valueMap.put("MANUFACTURERS_SHORT_DESC", myEntity.getManufacturersShortDesc());
+ valueMap.put("MANUFACTURERS_LONG_DESC", myEntity.getManufacturersLongDesc());
valueMap.put("URL_CLICKED", myEntity.getUrlClicked());
valueMap.put("DATE_LAST_CLICK", myEntity.getDateLastClick());
return valueMap;
@@ -672,6 +715,8 @@
valueMap.put("MANUFACTURERS_ID", helpGettingColumnStringValue(myEntity.getManufacturersId()));
valueMap.put("LANGUAGES_ID", helpGettingColumnStringValue(myEntity.getLanguagesId()));
valueMap.put("MANUFACTURERS_URL", helpGettingColumnStringValue(myEntity.getManufacturersUrl()));
+ valueMap.put("MANUFACTURERS_SHORT_DESC", helpGettingColumnStringValue(myEntity.getManufacturersShortDesc()));
+ valueMap.put("MANUFACTURERS_LONG_DESC", helpGettingColumnStringValue(myEntity.getManufacturersLongDesc()));
valueMap.put("URL_CLICKED", helpGettingColumnStringValue(myEntity.getUrlClicked()));
valueMap.put("DATE_LAST_CLICK", helpGettingColumnStringValue(myEntity.getDateLastClick()));
return valueMap;
@@ -681,11 +726,11 @@
// JDBC Support
// ============
public String getPreparedInsertClause() {
- return "insert into MANUFACTURERS_INFO(MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, URL_CLICKED, DATE_LAST_CLICK) values(? , ? , ? , ? , ? )";
+ return "insert into MANUFACTURERS_INFO(MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, MANUFACTURERS_SHORT_DESC, MANUFACTURERS_LONG_DESC, URL_CLICKED, DATE_LAST_CLICK) values(? , ? , ? , ? , ? , ? , ? )";
}
public String getPreparedInsertClause(String tablePrefix) {
- return "insert into " + tablePrefix + "MANUFACTURERS_INFO(MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, URL_CLICKED, DATE_LAST_CLICK) values(? , ? , ? , ? , ? )";
+ return "insert into " + tablePrefix + "MANUFACTURERS_INFO(MANUFACTURERS_ID, LANGUAGES_ID, MANUFACTURERS_URL, MANUFACTURERS_SHORT_DESC, MANUFACTURERS_LONG_DESC, URL_CLICKED, DATE_LAST_CLICK) 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-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsManufacturersCB.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -189,7 +189,7 @@
// ===================================================================================
// Setup-Select
// ============
-
+
// ===================================================================================
// Basic Override
// ==============
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsManufacturersInfoCB.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsManufacturersInfoCB.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/bs/BsManufacturersInfoCB.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -216,6 +216,50 @@
// ===================================================================================
// 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/cq/bs/AbstractBsManufacturersCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersCQ.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersCQ.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -134,6 +134,40 @@
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_ManufacturersInfoList using inScopeSubQuery.
+ * { in (select xxx.MANUFACTURERS_ID from MANUFACTURERS_INFO 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_ManufacturersInfoList using inScopeSubQuery. (NotNull)
+ */
+ public void setManufacturersId_InScopeSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(subQuery);// for saving query-value.
+ registerInScopeSubQuery(subQuery, COL_MANUFACTURERS_ID, "MANUFACTURERS_ID", "manufacturersId_InScopeSubQuery_ManufacturersInfoList");
+ }
+
+ abstract public void keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery);
+
+ /**
+ * Set the sub-query of ManufacturersId_ExistsSubQuery_ManufacturersInfoList using existsSubQuery.
+ * { exists (select xxx.MANUFACTURERS_ID from MANUFACTURERS_INFO 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_ManufacturersInfoList using existsSubQuery. (NotNull)
+ */
+ public void setManufacturersId_ExistsSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
+ assertObjectNotNull("subQuery", subQuery);
+ keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(subQuery);// for saving query-value.
+ registerExistsSubQuery(subQuery, COL_MANUFACTURERS_ID, "MANUFACTURERS_ID", "manufacturersId_ExistsSubQuery_ManufacturersInfoList");
+ }
+
+ abstract public void keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery);
/**
* Register condition of manufacturersId.
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersInfoCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersInfoCQ.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/AbstractBsManufacturersInfoCQ.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -134,8 +134,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);
+
+ /**
* Register condition of manufacturersId.
*
* @param key Condition key. (NotNull)
@@ -405,6 +422,320 @@
abstract protected ConditionValue getCValueManufacturersUrl();
+ /** Column db name of manufacturersShortDesc. */
+ protected static final String COL_MANUFACTURERS_SHORT_DESC = "MANUFACTURERS_SHORT_DESC";
+
+ /** Column java name of manufacturersShortDesc. */
+ protected static final String J_ManufacturersShortDesc = "ManufacturersShortDesc";
+
+ /** Column uncapitalised java name of manufacturersShortDesc. */
+ protected static final String UJ_manufacturersShortDesc = "manufacturersShortDesc";
+
+ /**
+ * Set the value of manufacturersShortDesc using equal. { = }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc as equal.
+ */
+ public void setManufacturersShortDesc_Equal(String manufacturersShortDesc) {
+ registerManufacturersShortDesc(ConditionKey.CK_EQUAL, filterRemoveEmptyString(manufacturersShortDesc));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using notEqual. { != }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc as notEqual.
+ */
+ public void setManufacturersShortDesc_NotEqual(String manufacturersShortDesc) {
+ registerManufacturersShortDesc(ConditionKey.CK_NOT_EQUAL, filterRemoveEmptyString(manufacturersShortDesc));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using greaterThan. { > }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc as greaterThan.
+ */
+ public void setManufacturersShortDesc_GreaterThan(String manufacturersShortDesc) {
+ registerManufacturersShortDesc(ConditionKey.CK_GREATER_THAN, filterRemoveEmptyString(manufacturersShortDesc));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using lessThan. { < }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc as lessThan.
+ */
+ public void setManufacturersShortDesc_LessThan(String manufacturersShortDesc) {
+ registerManufacturersShortDesc(ConditionKey.CK_LESS_THAN, filterRemoveEmptyString(manufacturersShortDesc));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using greaterEqual. { >= }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc as greaterEqual.
+ */
+ public void setManufacturersShortDesc_GreaterEqual(String manufacturersShortDesc) {
+ registerManufacturersShortDesc(ConditionKey.CK_GREATER_EQUAL, filterRemoveEmptyString(manufacturersShortDesc));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using lessEqual. { <= }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc as lessEqual.
+ */
+ public void setManufacturersShortDesc_LessEqual(String manufacturersShortDesc) {
+ registerManufacturersShortDesc(ConditionKey.CK_LESS_EQUAL, filterRemoveEmptyString(manufacturersShortDesc));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using prefixSearch. { like 'xxx%' }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc as prefixSearch.
+ */
+ public void setManufacturersShortDesc_PrefixSearch(String manufacturersShortDesc) {
+ registerManufacturersShortDesc(ConditionKey.CK_PREFIX_SEARCH, filterRemoveEmptyString(manufacturersShortDesc));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc 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 manufacturersShortDesc The value of manufacturersShortDesc as likeSearch.
+ * @param likeSearchOption Like search option. (NotNull)
+ */
+ public void setManufacturersShortDesc_LikeSearch(String manufacturersShortDesc, jp.sf.pal.pompei.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
+ registerLikeSearchQuery(ConditionKey.CK_LIKE_SEARCH, filterRemoveEmptyString(manufacturersShortDesc), getCValueManufacturersShortDesc(), COL_MANUFACTURERS_SHORT_DESC, J_ManufacturersShortDesc, UJ_manufacturersShortDesc, likeSearchOption);
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using inScope. { in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param manufacturersShortDescList The value of manufacturersShortDesc as inScope.
+ */
+ public void setManufacturersShortDesc_InScope(java.util.List<String> manufacturersShortDescList) {
+ registerManufacturersShortDesc(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyStringFromList(manufacturersShortDescList));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using inScope. { in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param manufacturersShortDesc The value of manufacturersShortDesc as inScope.
+ */
+ public void setManufacturersShortDesc_InScope(String manufacturersShortDesc, jp.sf.pal.pompei.allcommon.cbean.coption.InScopeOption option) {
+ registerInScopeQuery(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyString(manufacturersShortDesc), getCValueManufacturersShortDesc(), COL_MANUFACTURERS_SHORT_DESC, J_ManufacturersShortDesc, UJ_manufacturersShortDesc, option);
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using notInScope. { not in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param manufacturersShortDescList The value of manufacturersShortDesc as notInScope.
+ */
+ public void setManufacturersShortDesc_NotInScope(java.util.List<String> manufacturersShortDescList) {
+ registerManufacturersShortDesc(ConditionKey.CK_NOT_IN_SCOPE, filterRemoveEmptyStringFromList(manufacturersShortDescList));
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using isNull. { is null }
+ */
+ public void setManufacturersShortDesc_IsNull() {
+ registerManufacturersShortDesc(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
+ }
+
+ /**
+ * Set the value of manufacturersShortDesc using isNotNull. { is not null }
+ */
+ public void setManufacturersShortDesc_IsNotNull() {
+ registerManufacturersShortDesc(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
+ }
+
+ /**
+ * Register condition of manufacturersShortDesc.
+ *
+ * @param key Condition key. (NotNull)
+ * @param value The value of manufacturersShortDesc. (Nullable)
+ */
+ protected void registerManufacturersShortDesc(ConditionKey key, Object value) {
+ registerQuery(key, value, getCValueManufacturersShortDesc(), COL_MANUFACTURERS_SHORT_DESC, J_ManufacturersShortDesc, UJ_manufacturersShortDesc);
+ }
+
+ /**
+ * Register inline condition of manufacturersShortDesc.
+ *
+ * @param key Condition key. (NotNull)
+ * @param value The value of manufacturersShortDesc. (Nullable)
+ */
+ protected void registerInlineManufacturersShortDesc(ConditionKey key, Object value) {
+ registerInlineQuery(key, value, getCValueManufacturersShortDesc(), COL_MANUFACTURERS_SHORT_DESC, J_ManufacturersShortDesc, UJ_manufacturersShortDesc);
+ }
+
+ abstract protected ConditionValue getCValueManufacturersShortDesc();
+
+ /** Column db name of manufacturersLongDesc. */
+ protected static final String COL_MANUFACTURERS_LONG_DESC = "MANUFACTURERS_LONG_DESC";
+
+ /** Column java name of manufacturersLongDesc. */
+ protected static final String J_ManufacturersLongDesc = "ManufacturersLongDesc";
+
+ /** Column uncapitalised java name of manufacturersLongDesc. */
+ protected static final String UJ_manufacturersLongDesc = "manufacturersLongDesc";
+
+ /**
+ * Set the value of manufacturersLongDesc using equal. { = }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc as equal.
+ */
+ public void setManufacturersLongDesc_Equal(String manufacturersLongDesc) {
+ registerManufacturersLongDesc(ConditionKey.CK_EQUAL, filterRemoveEmptyString(manufacturersLongDesc));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using notEqual. { != }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc as notEqual.
+ */
+ public void setManufacturersLongDesc_NotEqual(String manufacturersLongDesc) {
+ registerManufacturersLongDesc(ConditionKey.CK_NOT_EQUAL, filterRemoveEmptyString(manufacturersLongDesc));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using greaterThan. { > }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc as greaterThan.
+ */
+ public void setManufacturersLongDesc_GreaterThan(String manufacturersLongDesc) {
+ registerManufacturersLongDesc(ConditionKey.CK_GREATER_THAN, filterRemoveEmptyString(manufacturersLongDesc));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using lessThan. { < }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc as lessThan.
+ */
+ public void setManufacturersLongDesc_LessThan(String manufacturersLongDesc) {
+ registerManufacturersLongDesc(ConditionKey.CK_LESS_THAN, filterRemoveEmptyString(manufacturersLongDesc));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using greaterEqual. { >= }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc as greaterEqual.
+ */
+ public void setManufacturersLongDesc_GreaterEqual(String manufacturersLongDesc) {
+ registerManufacturersLongDesc(ConditionKey.CK_GREATER_EQUAL, filterRemoveEmptyString(manufacturersLongDesc));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using lessEqual. { <= }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc as lessEqual.
+ */
+ public void setManufacturersLongDesc_LessEqual(String manufacturersLongDesc) {
+ registerManufacturersLongDesc(ConditionKey.CK_LESS_EQUAL, filterRemoveEmptyString(manufacturersLongDesc));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using prefixSearch. { like 'xxx%' }
+ * If the value is null or empty-string, this condition is ignored.
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc as prefixSearch.
+ */
+ public void setManufacturersLongDesc_PrefixSearch(String manufacturersLongDesc) {
+ registerManufacturersLongDesc(ConditionKey.CK_PREFIX_SEARCH, filterRemoveEmptyString(manufacturersLongDesc));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc 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 manufacturersLongDesc The value of manufacturersLongDesc as likeSearch.
+ * @param likeSearchOption Like search option. (NotNull)
+ */
+ public void setManufacturersLongDesc_LikeSearch(String manufacturersLongDesc, jp.sf.pal.pompei.allcommon.cbean.coption.LikeSearchOption likeSearchOption) {
+ registerLikeSearchQuery(ConditionKey.CK_LIKE_SEARCH, filterRemoveEmptyString(manufacturersLongDesc), getCValueManufacturersLongDesc(), COL_MANUFACTURERS_LONG_DESC, J_ManufacturersLongDesc, UJ_manufacturersLongDesc, likeSearchOption);
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using inScope. { in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param manufacturersLongDescList The value of manufacturersLongDesc as inScope.
+ */
+ public void setManufacturersLongDesc_InScope(java.util.List<String> manufacturersLongDescList) {
+ registerManufacturersLongDesc(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyStringFromList(manufacturersLongDescList));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using inScope. { in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param manufacturersLongDesc The value of manufacturersLongDesc as inScope.
+ */
+ public void setManufacturersLongDesc_InScope(String manufacturersLongDesc, jp.sf.pal.pompei.allcommon.cbean.coption.InScopeOption option) {
+ registerInScopeQuery(ConditionKey.CK_IN_SCOPE, filterRemoveEmptyString(manufacturersLongDesc), getCValueManufacturersLongDesc(), COL_MANUFACTURERS_LONG_DESC, J_ManufacturersLongDesc, UJ_manufacturersLongDesc, option);
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using notInScope. { not in ('a', 'b') }
+ * If the element in the list is null or empty-string, the condition-element is ignored.
+ *
+ * @param manufacturersLongDescList The value of manufacturersLongDesc as notInScope.
+ */
+ public void setManufacturersLongDesc_NotInScope(java.util.List<String> manufacturersLongDescList) {
+ registerManufacturersLongDesc(ConditionKey.CK_NOT_IN_SCOPE, filterRemoveEmptyStringFromList(manufacturersLongDescList));
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using isNull. { is null }
+ */
+ public void setManufacturersLongDesc_IsNull() {
+ registerManufacturersLongDesc(ConditionKey.CK_IS_NULL, DUMMY_OBJECT);
+ }
+
+ /**
+ * Set the value of manufacturersLongDesc using isNotNull. { is not null }
+ */
+ public void setManufacturersLongDesc_IsNotNull() {
+ registerManufacturersLongDesc(ConditionKey.CK_IS_NOT_NULL, DUMMY_OBJECT);
+ }
+
+ /**
+ * Register condition of manufacturersLongDesc.
+ *
+ * @param key Condition key. (NotNull)
+ * @param value The value of manufacturersLongDesc. (Nullable)
+ */
+ protected void registerManufacturersLongDesc(ConditionKey key, Object value) {
+ registerQuery(key, value, getCValueManufacturersLongDesc(), COL_MANUFACTURERS_LONG_DESC, J_ManufacturersLongDesc, UJ_manufacturersLongDesc);
+ }
+
+ /**
+ * Register inline condition of manufacturersLongDesc.
+ *
+ * @param key Condition key. (NotNull)
+ * @param value The value of manufacturersLongDesc. (Nullable)
+ */
+ protected void registerInlineManufacturersLongDesc(ConditionKey key, Object value) {
+ registerInlineQuery(key, value, getCValueManufacturersLongDesc(), COL_MANUFACTURERS_LONG_DESC, J_ManufacturersLongDesc, UJ_manufacturersLongDesc);
+ }
+
+ abstract protected ConditionValue getCValueManufacturersLongDesc();
+
/** Column db name of urlClicked. */
protected static final String COL_URL_CLICKED = "URL_CLICKED";
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-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturersCQ.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -176,8 +176,40 @@
return getManufacturersId();
}
-
+
+ /** The sub-query of ManufacturersId_InScopeSubQuery_ManufacturersInfoList using inScopeSubQuery. */
+ protected ManufacturersInfoCQ _manufacturersId_InScopeSubQuery_ManufacturersInfoList;
+
/**
+ * Get the sub-query of ManufacturersId_InScopeSubQuery_ManufacturersInfoList using inScopeSubQuery.
+ *
+ * @return The sub-query of ManufacturersId_InScopeSubQuery_ManufacturersInfoList using inScopeSubQuery. (Nullable)
+ */
+ public ManufacturersInfoCQ getManufacturersId_InScopeSubQuery_ManufacturersInfoList() {
+ return _manufacturersId_InScopeSubQuery_ManufacturersInfoList;
+ }
+
+ public void keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
+ _manufacturersId_InScopeSubQuery_ManufacturersInfoList = subQuery;
+ }
+
+ /** The sub-query of ManufacturersId_ExistsSubQuery_ManufacturersInfoList using existsSubQuery. */
+ protected ManufacturersInfoCQ _manufacturersId_ExistsSubQuery_ManufacturersInfoList;
+
+ /**
+ * Get the sub-query of ManufacturersId_ExistsSubQuery_ManufacturersInfoList using existsSubQuery.
+ *
+ * @return The sub-query of ManufacturersId_ExistsSubQuery_ManufacturersInfoList using existsSubQuery. (Nullable)
+ */
+ public ManufacturersInfoCQ getManufacturersId_ExistsSubQuery_ManufacturersInfoList() {
+ return _manufacturersId_ExistsSubQuery_ManufacturersInfoList;
+ }
+
+ public void keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
+ _manufacturersId_ExistsSubQuery_ManufacturersInfoList = subQuery;
+ }
+
+ /**
* Add order-by of manufacturersId as ASC.
*
* @return this. (NotNull)
@@ -369,12 +401,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/BsManufacturersInfoCQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturersInfoCQ.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/bs/BsManufacturersInfoCQ.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -111,6 +111,42 @@
}
/**
+ * Include select-column of manufacturersShortDesc as mine.
+ * Alias name is java-name of this column.
+ * Be careful to whether your table have the same column.
+ */
+ public void includeAsMine_ManufacturersShortDesc() {
+ registerIncludedSelectColumn("ManufacturersShortDesc", getRealColumnName("MANUFACTURERS_SHORT_DESC"));
+ }
+
+ /**
+ * Include select-column of manufacturersShortDesc as mine.
+ *
+ * @param aliasName Alias name. {select columnName as aliasName from ...} This should not contain comma. (NotNull)
+ */
+ public void includeAsMine_ManufacturersShortDesc(String aliasName) {
+ registerIncludedSelectColumn(aliasName, getRealColumnName("MANUFACTURERS_SHORT_DESC"));
+ }
+
+ /**
+ * Include select-column of manufacturersLongDesc as mine.
+ * Alias name is java-name of this column.
+ * Be careful to whether your table have the same column.
+ */
+ public void includeAsMine_ManufacturersLongDesc() {
+ registerIncludedSelectColumn("ManufacturersLongDesc", getRealColumnName("MANUFACTURERS_LONG_DESC"));
+ }
+
+ /**
+ * Include select-column of manufacturersLongDesc as mine.
+ *
+ * @param aliasName Alias name. {select columnName as aliasName from ...} This should not contain comma. (NotNull)
+ */
+ public void includeAsMine_ManufacturersLongDesc(String aliasName) {
+ registerIncludedSelectColumn(aliasName, getRealColumnName("MANUFACTURERS_LONG_DESC"));
+ }
+
+ /**
* Include select-column of urlClicked as mine.
* Alias name is java-name of this column.
* Be careful to whether your table have the same column.
@@ -176,8 +212,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)
@@ -280,6 +332,90 @@
}
// /- - - - - - - - - - - - - - - - - - - - - - -
+ // Column = [MANUFACTURERS_SHORT_DESC]
+ // - - - - - - - - -/
+
+ /** The attribute of manufacturersShortDesc. */
+ protected ConditionValue _manufacturersShortDesc;
+
+ /**
+ * Get the value of manufacturersShortDesc.
+ *
+ * @return The value of manufacturersShortDesc.
+ */
+ public ConditionValue getManufacturersShortDesc() {
+ if (_manufacturersShortDesc == null) {
+ _manufacturersShortDesc = new ConditionValue();
+ }
+ return _manufacturersShortDesc;
+ }
+
+ protected ConditionValue getCValueManufacturersShortDesc() {
+ return getManufacturersShortDesc();
+ }
+
+
+ /**
+ * Add order-by of manufacturersShortDesc as ASC.
+ *
+ * @return this. (NotNull)
+ */
+ public BsManufacturersInfoCQ addOrderBy_ManufacturersShortDesc_Asc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_MANUFACTURERS_SHORT_DESC), null, true);return this;
+ }
+
+ /**
+ * Add order-by of manufacturersShortDesc as DESC.
+ *
+ * @return this. (NotNull)
+ */
+ public BsManufacturersInfoCQ addOrderBy_ManufacturersShortDesc_Desc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_MANUFACTURERS_SHORT_DESC), null, false);return this;
+ }
+
+ // /- - - - - - - - - - - - - - - - - - - - - - -
+ // Column = [MANUFACTURERS_LONG_DESC]
+ // - - - - - - - - -/
+
+ /** The attribute of manufacturersLongDesc. */
+ protected ConditionValue _manufacturersLongDesc;
+
+ /**
+ * Get the value of manufacturersLongDesc.
+ *
+ * @return The value of manufacturersLongDesc.
+ */
+ public ConditionValue getManufacturersLongDesc() {
+ if (_manufacturersLongDesc == null) {
+ _manufacturersLongDesc = new ConditionValue();
+ }
+ return _manufacturersLongDesc;
+ }
+
+ protected ConditionValue getCValueManufacturersLongDesc() {
+ return getManufacturersLongDesc();
+ }
+
+
+ /**
+ * Add order-by of manufacturersLongDesc as ASC.
+ *
+ * @return this. (NotNull)
+ */
+ public BsManufacturersInfoCQ addOrderBy_ManufacturersLongDesc_Asc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_MANUFACTURERS_LONG_DESC), null, true);return this;
+ }
+
+ /**
+ * Add order-by of manufacturersLongDesc as DESC.
+ *
+ * @return this. (NotNull)
+ */
+ public BsManufacturersInfoCQ addOrderBy_ManufacturersLongDesc_Desc() {
+ getSqlClause().registerOrderBy(getRealColumnName(COL_MANUFACTURERS_LONG_DESC), null, false);return this;
+ }
+
+ // /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [URL_CLICKED]
// - - - - - - - - -/
@@ -369,12 +505,81 @@
protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, ConditionQuery unionQueryAsSuper) {
final ManufacturersInfoCQ baseQuery = (ManufacturersInfoCQ)baseQueryAsSuper;
final ManufacturersInfoCQ unionQuery = (ManufacturersInfoCQ)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/ciq/ManufacturersCIQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersCIQ.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersCIQ.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -74,7 +74,16 @@
return _myCQ.getManufacturersId();
}
-
+
+ public void keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
+ _myCQ.keepManufacturersId_InScopeSubQuery_ManufacturersInfoList(subQuery);
+ }
+
+ public void keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(ManufacturersInfoCQ subQuery) {
+ throw new UnsupportedOperationException("ExistsSubQuery at inline() is unsupported! Sorry!");
+ // _myCQ.keepManufacturersId_ExistsSubQuery_ManufacturersInfoList(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [MANUFACTURERS_NAME]
// - - - - - - - - -/
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersInfoCIQ.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersInfoCIQ.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/cq/ciq/ManufacturersInfoCIQ.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -74,7 +74,11 @@
return _myCQ.getManufacturersId();
}
-
+
+ public void keepManufacturersId_InScopeSubQuery_Manufacturers(ManufacturersCQ subQuery) {
+ _myCQ.keepManufacturersId_InScopeSubQuery_Manufacturers(subQuery);
+ }
+
// /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [LANGUAGES_ID]
// - - - - - - - - -/
@@ -92,6 +96,22 @@
// /- - - - - - - - - - - - - - - - - - - - - - -
+ // Column = [MANUFACTURERS_SHORT_DESC]
+ // - - - - - - - - -/
+ protected ConditionValue getCValueManufacturersShortDesc() {
+ return _myCQ.getManufacturersShortDesc();
+ }
+
+
+ // /- - - - - - - - - - - - - - - - - - - - - - -
+ // Column = [MANUFACTURERS_LONG_DESC]
+ // - - - - - - - - -/
+ protected ConditionValue getCValueManufacturersLongDesc() {
+ return _myCQ.getManufacturersLongDesc();
+ }
+
+
+ // /- - - - - - - - - - - - - - - - - - - - - - -
// Column = [URL_CLICKED]
// - - - - - - - - -/
protected ConditionValue getCValueUrlClicked() {
Modified: pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersInfoNss.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersInfoNss.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersInfoNss.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -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/ManufacturersNss.java
===================================================================
--- pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersNss.java 2007-07-18 21:05:38 UTC (rev 298)
+++ pompei/trunk/src/main/java/jp/sf/pal/pompei/cbean/nss/ManufacturersNss.java 2007-07-18 21:06:26 UTC (rev 299)
@@ -51,7 +51,7 @@
// ===================================================================================
// With...
// =======
-
+
// ===================================================================================
// Helper
// ======