svnno****@sourc*****
svnno****@sourc*****
2008年 11月 7日 (金) 12:32:26 JST
Revision: 1300 http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=1300 Author: shinsuke Date: 2008-11-07 12:32:26 +0900 (Fri, 07 Nov 2008) Log Message: ----------- updated schema, added config pages, updated ui. Modified Paths: -------------- userinfo/trunk/src/main/config/erd/userinfo.erd userinfo/trunk/src/main/config/sql/userinfo.ddl userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/GroupInfoAction.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/RoleInfoAction.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/UserInfoAction.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/allcommon/dbmeta/DBMetaInstanceHandler.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupInfoBhv.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleInfoBhv.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsUserInfoBhv.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupInfo.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleInfo.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsUserInfo.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupInfoDbm.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleInfoDbm.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/UserInfoDbm.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupInfoCB.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleInfoCB.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsUserInfoCB.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupInfoCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleInfoCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsUserInfoCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupInfoCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleInfoCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsUserInfoCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupInfoCIQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleInfoCIQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/UserInfoCIQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/service/GroupInfoService.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/service/RoleInfoService.java userinfo/trunk/src/main/resources/dbflute.dicon userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.1.log.db userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.data.db userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.index.db userinfo/trunk/src/main/webapp/WEB-INF/userinfo.xml userinfo/trunk/src/main/webapp/WEB-INF/view/config/index.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/confirm.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/edit.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/error.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/index.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/confirm.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/edit.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/error.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/index.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/confirm.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/edit.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/error.jsp userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/index.jsp Added Paths: ----------- userinfo/trunk/mydbflute/README.txt userinfo/trunk/src/main/java/jp/sf/pal/userinfo/UserInfoConstants.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/ConfigAction.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupMappingBhv.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleMappingBhv.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsGroupMappingDao.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsRoleMappingDao.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupMapping.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleMapping.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupMappingDbm.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleMappingDbm.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/GroupMappingCB.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/RoleMappingCB.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupMappingCB.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleMappingCB.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/GroupMappingCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/RoleMappingCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupMappingCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleMappingCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupMappingCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleMappingCQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupMappingCIQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleMappingCIQ.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/GroupMappingNss.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/RoleMappingNss.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/GroupMappingBhv.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/RoleMappingBhv.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/GroupMappingDao.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/RoleMappingDao.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/GroupMapping.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/RoleMapping.java userinfo/trunk/src/main/java/jp/sf/pal/userinfo/form/ConfigForm.java -------------- next part -------------- Added: userinfo/trunk/mydbflute/README.txt =================================================================== --- userinfo/trunk/mydbflute/README.txt (rev 0) +++ userinfo/trunk/mydbflute/README.txt 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,3 @@ +$ mkdir dbflute-0.8.2 +$ cd dbflute-0.8.2 +$ unzip ../dbflute-0.8.2.zip Property changes on: userinfo/trunk/mydbflute/README.txt ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/config/erd/userinfo.erd =================================================================== --- userinfo/trunk/src/main/config/erd/userinfo.erd 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/config/erd/userinfo.erd 2008-11-07 03:32:26 UTC (rev 1300) @@ -234,8 +234,8 @@ </columns> <indices/> <constraint> - <x>157</x> - <y>40</y> + <x>185</x> + <y>199</y> <width>-1</width> <height>-1</height> </constraint> @@ -403,13 +403,124 @@ <indices/> <constraint> <x>40</x> - <y>484</y> + <y>643</y> <width>-1</width> <height>-1</height> </constraint> <sourceConnections/> <targetConnections> <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/> + <net.java.amateras.db.visual.model.ForeignKeyModel> + <foreignKeyName>FK_from_mapping_to_group</foreignKeyName> + <references> + <entry> + <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/> + <net.java.amateras.db.visual.model.ColumnModel> + <columnName>group_id</columnName> + <logicalName>Group ID</logicalName> + <columnType class="net.java.amateras.db.dialect.ColumnType"> + <name>VARCHAR</name> + <logicalName>String</logicalName> + <supportSize>true</supportSize> + <type>12</type> + </columnType> + <size>255</size> + <notNull>true</notNull> + <primaryKey>false</primaryKey> + <description></description> + <autoIncrement>false</autoIncrement> + <defaultValue></defaultValue> + </net.java.amateras.db.visual.model.ColumnModel> + </entry> + </references> + <source class="net.java.amateras.db.visual.model.TableModel"> + <error></error> + <linkedPath></linkedPath> + <tableName>group_mapping</tableName> + <logicalName>Group Mapping</logicalName> + <description></description> + <columns> + <net.java.amateras.db.visual.model.ColumnModel> + <columnName>id</columnName> + <logicalName>ID</logicalName> + <columnType class="net.java.amateras.db.dialect.ColumnType"> + <name>INTEGER</name> + <logicalName>Integer</logicalName> + <supportSize>false</supportSize> + <type>4</type> + </columnType> + <size>10</size> + <notNull>true</notNull> + <primaryKey>true</primaryKey> + <description></description> + <autoIncrement>true</autoIncrement> + <defaultValue></defaultValue> + </net.java.amateras.db.visual.model.ColumnModel> + <net.java.amateras.db.visual.model.ColumnModel> + <columnName>user_id</columnName> + <logicalName>User ID</logicalName> + <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/> + <size>255</size> + <notNull>true</notNull> + <primaryKey>false</primaryKey> + <description></description> + <autoIncrement>false</autoIncrement> + <defaultValue></defaultValue> + </net.java.amateras.db.visual.model.ColumnModel> + <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/> + </columns> + <indices/> + <constraint> + <x>44</x> + <y>40</y> + <width>-1</width> + <height>-1</height> + </constraint> + <sourceConnections> + <net.java.amateras.db.visual.model.ForeignKeyModel> + <foreignKeyName>FK_from_mapping_to_user</foreignKeyName> + <references> + <entry> + <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/> + <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]"/> + </entry> + </references> + <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/> + <target class="net.java.amateras.db.visual.model.TableModel" reference="../../../../../../../../.."/> + <listeners serialization="custom"> + <java.beans.PropertyChangeSupport> + <default> + <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion> + <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/> + </default> + <null/> + </java.beans.PropertyChangeSupport> + </listeners> + </net.java.amateras.db.visual.model.ForeignKeyModel> + <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/> + </sourceConnections> + <targetConnections/> + <listeners serialization="custom"> + <java.beans.PropertyChangeSupport> + <default> + <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion> + <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/> + </default> + <null/> + </java.beans.PropertyChangeSupport> + </listeners> + </source> + <target class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/> + <listeners serialization="custom"> + <java.beans.PropertyChangeSupport> + <default> + <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion> + <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/> + </default> + <null/> + </java.beans.PropertyChangeSupport> + </listeners> + </net.java.amateras.db.visual.model.ForeignKeyModel> </targetConnections> <listeners serialization="custom"> <java.beans.PropertyChangeSupport> @@ -593,14 +704,120 @@ </columns> <indices/> <constraint> - <x>308</x> - <y>484</y> + <x>364</x> + <y>643</y> <width>-1</width> <height>-1</height> </constraint> <sourceConnections/> <targetConnections> <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/> + <net.java.amateras.db.visual.model.ForeignKeyModel> + <foreignKeyName>FK_from_mapping_to_role</foreignKeyName> + <references> + <entry> + <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../references/entry/net.java.amateras.db.visual.model.ColumnModel"/> + <net.java.amateras.db.visual.model.ColumnModel> + <columnName>role_id</columnName> + <logicalName>Role ID</logicalName> + <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/> + <size>255</size> + <notNull>true</notNull> + <primaryKey>false</primaryKey> + <description></description> + <autoIncrement>false</autoIncrement> + <defaultValue></defaultValue> + </net.java.amateras.db.visual.model.ColumnModel> + </entry> + </references> + <source class="net.java.amateras.db.visual.model.TableModel"> + <error></error> + <linkedPath></linkedPath> + <tableName>role_mapping</tableName> + <logicalName>Role Mapping</logicalName> + <description></description> + <columns> + <net.java.amateras.db.visual.model.ColumnModel> + <columnName>id</columnName> + <logicalName>ID</logicalName> + <columnType class="net.java.amateras.db.dialect.ColumnType"> + <name>INT</name> + <logicalName>Integer</logicalName> + <supportSize>false</supportSize> + <type>4</type> + </columnType> + <size>10</size> + <notNull>true</notNull> + <primaryKey>true</primaryKey> + <description></description> + <autoIncrement>true</autoIncrement> + <defaultValue></defaultValue> + </net.java.amateras.db.visual.model.ColumnModel> + <net.java.amateras.db.visual.model.ColumnModel> + <columnName>user_id</columnName> + <logicalName>User ID</logicalName> + <columnType class="net.java.amateras.db.dialect.ColumnType" reference="../../../../../../../../net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/references/entry/net.java.amateras.db.visual.model.ColumnModel[2]/columnType"/> + <size>255</size> + <notNull>true</notNull> + <primaryKey>false</primaryKey> + <description></description> + <autoIncrement>false</autoIncrement> + <defaultValue></defaultValue> + </net.java.amateras.db.visual.model.ColumnModel> + <net.java.amateras.db.visual.model.ColumnModel reference="../../../references/entry/net.java.amateras.db.visual.model.ColumnModel[2]"/> + </columns> + <indices/> + <constraint> + <x>372</x> + <y>40</y> + <width>-1</width> + <height>-1</height> + </constraint> + <sourceConnections> + <net.java.amateras.db.visual.model.ForeignKeyModel> + <foreignKeyName>FK_from_mapping_to_user</foreignKeyName> + <references> + <entry> + <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../../../../../../../columns/net.java.amateras.db.visual.model.ColumnModel"/> + <net.java.amateras.db.visual.model.ColumnModel reference="../../../../../columns/net.java.amateras.db.visual.model.ColumnModel[2]"/> + </entry> + </references> + <source class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/> + <target class="net.java.amateras.db.visual.model.TableModel" reference="../../../../../../../../.."/> + <listeners serialization="custom"> + <java.beans.PropertyChangeSupport> + <default> + <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion> + <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/> + </default> + <null/> + </java.beans.PropertyChangeSupport> + </listeners> + </net.java.amateras.db.visual.model.ForeignKeyModel> + <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../.."/> + </sourceConnections> + <targetConnections/> + <listeners serialization="custom"> + <java.beans.PropertyChangeSupport> + <default> + <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion> + <source class="net.java.amateras.db.visual.model.TableModel" reference="../../../.."/> + </default> + <null/> + </java.beans.PropertyChangeSupport> + </listeners> + </source> + <target class="net.java.amateras.db.visual.model.TableModel" reference="../../.."/> + <listeners serialization="custom"> + <java.beans.PropertyChangeSupport> + <default> + <propertyChangeSupportSerializedDataVersion>2</propertyChangeSupportSerializedDataVersion> + <source class="net.java.amateras.db.visual.model.ForeignKeyModel" reference="../../../.."/> + </default> + <null/> + </java.beans.PropertyChangeSupport> + </listeners> + </net.java.amateras.db.visual.model.ForeignKeyModel> </targetConnections> <listeners serialization="custom"> <java.beans.PropertyChangeSupport> @@ -623,7 +840,10 @@ </listeners> </net.java.amateras.db.visual.model.ForeignKeyModel> </sourceConnections> - <targetConnections/> + <targetConnections> + <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel"/> + <net.java.amateras.db.visual.model.ForeignKeyModel reference="../../sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel"/> + </targetConnections> <listeners serialization="custom"> <java.beans.PropertyChangeSupport> <default> @@ -636,6 +856,8 @@ </net.java.amateras.db.visual.model.TableModel> <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target"/> <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target"/> + <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source"/> + <net.java.amateras.db.visual.model.TableModel reference="../net.java.amateras.db.visual.model.TableModel/sourceConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/target/targetConnections/net.java.amateras.db.visual.model.ForeignKeyModel[2]/source"/> </children> <dommains/> <dialectName>hsqldb</dialectName> Modified: userinfo/trunk/src/main/config/sql/userinfo.ddl =================================================================== --- userinfo/trunk/src/main/config/sql/userinfo.ddl 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/config/sql/userinfo.ddl 2008-11-07 03:32:26 UTC (rev 1300) @@ -1,3 +1,5 @@ +DROP TABLE role_mapping; +DROP TABLE group_mapping; DROP TABLE user_info; DROP TABLE role_info; DROP TABLE group_info; @@ -66,3 +68,25 @@ FOREIGN KEY (role_id) REFERENCES role_info (role_id) ); +/********************************** +Table Name: Group Mapping +**********************************/ +CREATE TABLE group_mapping( + id INTEGER NOT NULL IDENTITY PRIMARY KEY, + user_id VARCHAR(255) NOT NULL, + group_id VARCHAR(255) NOT NULL, + FOREIGN KEY (user_id) REFERENCES user_info (user_id), + FOREIGN KEY (group_id) REFERENCES group_info (group_id) +); + +/********************************** +Table Name: Role Mapping +**********************************/ +CREATE TABLE role_mapping( + id INT NOT NULL IDENTITY PRIMARY KEY, + user_id VARCHAR(255) NOT NULL, + role_id VARCHAR(255) NOT NULL, + FOREIGN KEY (user_id) REFERENCES user_info (user_id), + FOREIGN KEY (role_id) REFERENCES role_info (role_id) +); + Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/UserInfoConstants.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/UserInfoConstants.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/UserInfoConstants.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,9 @@ +package jp.sf.pal.userinfo; + +public class UserInfoConstants { + + public static final String ROLE_AVAILABLE = "features.role"; + + public static final String GROUP_AVAILABLE = "features.group"; + +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/UserInfoConstants.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/ConfigAction.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/ConfigAction.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/ConfigAction.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,78 @@ +package jp.sf.pal.userinfo.action; + +import java.io.Serializable; + +import javax.servlet.http.HttpServletRequest; + +import jp.sf.pal.userinfo.UserInfoConstants; +import jp.sf.pal.userinfo.common.util.ConfigUtil; +import jp.sf.pal.userinfo.common.util.SAStrutsUtil; +import jp.sf.pal.userinfo.form.ConfigForm; + +import org.apache.commons.configuration.ConfigurationException; +import org.apache.commons.logging.Log; +import org.apache.commons.logging.LogFactory; +import org.seasar.struts.annotation.ActionForm; +import org.seasar.struts.annotation.Execute; +import org.seasar.struts.exception.ActionMessagesException; + +public class ConfigAction implements Serializable { + + private static final long serialVersionUID = 1L; + + private static final Log log = LogFactory.getLog(ConfigAction.class); + + @ActionForm + private ConfigForm configForm; + + private transient HttpServletRequest request; + + protected String displayIndex() { + configForm.roleAvailable = ConfigUtil.getString( + UserInfoConstants.ROLE_AVAILABLE, "true"); + configForm.groupAvailable = ConfigUtil.getString( + UserInfoConstants.GROUP_AVAILABLE, "true"); + return "index.jsp"; + } + + @Execute(validator = false, input = "index.jsp") + public String index() { + ConfigUtil.init(request); + return displayIndex(); + } + + @Execute(validator = false, input = "index.jsp") + public String update() { + ConfigUtil.init(request); + ConfigUtil.setProperty(UserInfoConstants.ROLE_AVAILABLE, + configForm.roleAvailable); + ConfigUtil.setProperty(UserInfoConstants.GROUP_AVAILABLE, + configForm.groupAvailable); + try { + ConfigUtil.save(); + SAStrutsUtil.addMessage(request, "success.update_config"); + + return displayIndex(); + } catch (ConfigurationException e) { + log.error(e.getMessage(), e); + throw new ActionMessagesException("errors.failed_to_update_config"); + } + } + + public ConfigForm getConfigForm() { + return configForm; + } + + public void setConfigForm(ConfigForm configForm) { + this.configForm = configForm; + } + + public HttpServletRequest getRequest() { + return request; + } + + public void setRequest(HttpServletRequest request) { + this.request = request; + } + +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/ConfigAction.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/GroupInfoAction.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/GroupInfoAction.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/GroupInfoAction.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -5,6 +5,7 @@ import javax.servlet.http.HttpServletRequest; +import jp.sf.pal.userinfo.UserInfoConstants; import jp.sf.pal.userinfo.common.CommonConstants; import jp.sf.pal.userinfo.common.dxo.PagerDxo; import jp.sf.pal.userinfo.common.util.ConfigUtil; @@ -276,6 +277,14 @@ private void loadDetailsPageParameters() { } + public boolean isRoleAvailable() { + return ConfigUtil.getBoolean(UserInfoConstants.ROLE_AVAILABLE, true); + } + + public boolean isGroupAvailable() { + return ConfigUtil.getBoolean(UserInfoConstants.GROUP_AVAILABLE, true); + } + /** * @return the request */ Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/RoleInfoAction.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/RoleInfoAction.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/RoleInfoAction.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -5,6 +5,7 @@ import javax.servlet.http.HttpServletRequest; +import jp.sf.pal.userinfo.UserInfoConstants; import jp.sf.pal.userinfo.common.CommonConstants; import jp.sf.pal.userinfo.common.dxo.PagerDxo; import jp.sf.pal.userinfo.common.util.ConfigUtil; @@ -274,6 +275,14 @@ private void loadDetailsPageParameters() { } + public boolean isRoleAvailable() { + return ConfigUtil.getBoolean(UserInfoConstants.ROLE_AVAILABLE, true); + } + + public boolean isGroupAvailable() { + return ConfigUtil.getBoolean(UserInfoConstants.GROUP_AVAILABLE, true); + } + /** * @return the request */ Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/UserInfoAction.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/UserInfoAction.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/action/UserInfoAction.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -5,14 +5,19 @@ import javax.servlet.http.HttpServletRequest; +import jp.sf.pal.userinfo.UserInfoConstants; import jp.sf.pal.userinfo.common.CommonConstants; import jp.sf.pal.userinfo.common.dxo.PagerDxo; import jp.sf.pal.userinfo.common.util.ConfigUtil; import jp.sf.pal.userinfo.common.util.SAStrutsUtil; +import jp.sf.pal.userinfo.db.exentity.GroupInfo; +import jp.sf.pal.userinfo.db.exentity.RoleInfo; import jp.sf.pal.userinfo.db.exentity.UserInfo; import jp.sf.pal.userinfo.dxo.UserInfoDxo; import jp.sf.pal.userinfo.form.UserInfoForm; import jp.sf.pal.userinfo.pager.UserInfoPager; +import jp.sf.pal.userinfo.service.GroupInfoService; +import jp.sf.pal.userinfo.service.RoleInfoService; import jp.sf.pal.userinfo.service.UserInfoService; import org.apache.commons.logging.Log; @@ -38,6 +43,10 @@ private UserInfoService userInfoService; + private RoleInfoService roleInfoService; + + private GroupInfoService groupInfoService; + private UserInfoPager userInfoPager; private PagerDxo pagerDxo; @@ -274,6 +283,22 @@ private void loadDetailsPageParameters() { } + public List<RoleInfo> getRoleInfoItems() { + return roleInfoService.getRoleInfoList(); + } + + public List<GroupInfo> getGroupInfoItems() { + return groupInfoService.getGroupInfoList(); + } + + public boolean isRoleAvailable() { + return ConfigUtil.getBoolean(UserInfoConstants.ROLE_AVAILABLE, true); + } + + public boolean isGroupAvailable() { + return ConfigUtil.getBoolean(UserInfoConstants.GROUP_AVAILABLE, true); + } + /** * @return the request */ @@ -328,4 +353,20 @@ this.userInfoDxo = userInfoDxo; } + public RoleInfoService getRoleInfoService() { + return roleInfoService; + } + + public void setRoleInfoService(RoleInfoService roleInfoService) { + this.roleInfoService = roleInfoService; + } + + public GroupInfoService getGroupInfoService() { + return groupInfoService; + } + + public void setGroupInfoService(GroupInfoService groupInfoService) { + this.groupInfoService = groupInfoService; + } + } Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/allcommon/dbmeta/DBMetaInstanceHandler.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/allcommon/dbmeta/DBMetaInstanceHandler.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/allcommon/dbmeta/DBMetaInstanceHandler.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -29,8 +29,12 @@ tmpMap.put("GROUP_INFO", "jp.sf.pal.userinfo.db.bsentity.dbmeta.GroupInfoDbm"); + tmpMap.put("GROUP_MAPPING", + "jp.sf.pal.userinfo.db.bsentity.dbmeta.GroupMappingDbm"); tmpMap.put("ROLE_INFO", "jp.sf.pal.userinfo.db.bsentity.dbmeta.RoleInfoDbm"); + tmpMap.put("ROLE_MAPPING", + "jp.sf.pal.userinfo.db.bsentity.dbmeta.RoleMappingDbm"); tmpMap.put("USER_INFO", "jp.sf.pal.userinfo.db.bsentity.dbmeta.UserInfoDbm"); @@ -43,7 +47,9 @@ Map<String, String> tmpMap = new LinkedHashMap<String, String>(); tmpMap.put("GROUP_INFO".toLowerCase(), "groupInfo"); + tmpMap.put("GROUP_MAPPING".toLowerCase(), "groupMapping"); tmpMap.put("ROLE_INFO".toLowerCase(), "roleInfo"); + tmpMap.put("ROLE_MAPPING".toLowerCase(), "roleMapping"); tmpMap.put("USER_INFO".toLowerCase(), "userInfo"); _tableDbNamePropertyNameKeyToLowerMap = Collections @@ -56,7 +62,9 @@ Map<String, String> tmpMap = new LinkedHashMap<String, String>(); tmpMap.put("groupInfo".toLowerCase(), "GROUP_INFO"); + tmpMap.put("groupMapping".toLowerCase(), "GROUP_MAPPING"); tmpMap.put("roleInfo".toLowerCase(), "ROLE_INFO"); + tmpMap.put("roleMapping".toLowerCase(), "ROLE_MAPPING"); tmpMap.put("userInfo".toLowerCase(), "USER_INFO"); _tablePropertyNameDbNameKeyToLowerMap = Collections Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupInfoBhv.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupInfoBhv.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupInfoBhv.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -18,10 +18,13 @@ import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; import jp.sf.pal.userinfo.db.bsentity.dbmeta.GroupInfoDbm; import jp.sf.pal.userinfo.db.cbean.GroupInfoCB; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; +import jp.sf.pal.userinfo.db.exbhv.GroupMappingBhv; import jp.sf.pal.userinfo.db.exbhv.UserInfoBhv; import jp.sf.pal.userinfo.db.exdao.GroupInfoDao; import jp.sf.pal.userinfo.db.exentity.GroupInfo; +import jp.sf.pal.userinfo.db.exentity.GroupMapping; import jp.sf.pal.userinfo.db.exentity.UserInfo; /** @@ -47,13 +50,13 @@ * * * [referrer-table] - * USER_INFO + * GROUP_MAPPING, USER_INFO * * [foreign-property] * * * [referrer-property] - * userInfoList + * groupMappingList, userInfoList * </pre> * * @author DBFlute(AutoGenerator) @@ -282,6 +285,97 @@ // Load Referrer // ============= /** + * Load referrer of groupMappingList with the setupper for condition-bean of + * referrer. <br /> About internal policy, the value of primary key(and + * others too) is treated as case-insensitive. <br /> The condition-bean + * that the setupper provides have settings before you touch it. It is as + * follows: + * + * <pre> + * cb.query().setGroupId_InScope(pkList); + * cb.query().addOrderBy_GroupId_Asc(); + * </pre> + * + * @param groupInfoList The entity list of groupInfo. (NotNull) + * @param conditionBeanSetupper The instance of referrer condition-bean + * setupper for registering referrer condition. (NotNull) + */ + public void loadGroupMappingList(List<GroupInfo> groupInfoList, + ConditionBeanSetupper<GroupMappingCB> conditionBeanSetupper) { + assertObjectNotNull("groupInfoList<GroupInfo>", groupInfoList); + assertObjectNotNull("conditionBeanSetupper<GroupMappingCB>", + conditionBeanSetupper); + if (groupInfoList.isEmpty()) { + return; + } + loadGroupMappingList(groupInfoList, + new LoadReferrerOption<GroupMappingCB, GroupMapping>( + conditionBeanSetupper)); + } + + /** + * {Refer to overload method that has an argument of condition-bean + * setupper.} + * + * @param groupInfoList The entity list of groupInfo. (NotNull) + * @param loadReferrerOption The option of load-referrer. (NotNull) + */ + public void loadGroupMappingList(List<GroupInfo> groupInfoList, + LoadReferrerOption<GroupMappingCB, GroupMapping> loadReferrerOption) { + assertObjectNotNull("groupInfoList<GroupInfo>", groupInfoList); + assertObjectNotNull("loadReferrerOption<GroupMapping, GroupMappingCB>", + loadReferrerOption); + if (groupInfoList.isEmpty()) { + return; + } + final GroupMappingBhv referrerBhv = xgetBSFLR().select( + GroupMappingBhv.class); + helpLoadReferrerInternally( + groupInfoList, + loadReferrerOption, + new InternalLoadReferrerCallback<GroupInfo, String, GroupMappingCB, GroupMapping>() { + public String callbackBase_getPrimaryKeyValue( + GroupInfo entity) { + return entity.getGroupId(); + } + + public void callbackBase_setReferrerList(GroupInfo entity, + List<GroupMapping> referrerList) { + entity.setGroupMappingList(referrerList); + } + + public GroupMappingCB callbackReferrer_newMyConditionBean() { + return referrerBhv.newMyConditionBean(); + } + + public void callbackReferrer_queryForeignKeyInScope( + GroupMappingCB cb, List<String> pkList) { + cb.query().setGroupId_InScope(pkList); + } + + public void callbackReferrer_queryAddOrderByForeignKeyAsc( + GroupMappingCB cb) { + cb.query().addOrderBy_GroupId_Asc(); + } + + public List<GroupMapping> callbackReferrer_selectList( + GroupMappingCB cb) { + return referrerBhv.selectList(cb); + } + + public String callbackReferrer_getForeignKeyValue( + GroupMapping entity) { + return entity.getGroupId(); + } + + public void callbackReferrer_setForeignEntity( + GroupMapping referrerEntity, GroupInfo baseEntity) { + referrerEntity.setGroupInfo(baseEntity); + } + }); + } + + /** * Load referrer of userInfoList with the setupper for condition-bean of * referrer. <br /> About internal policy, the value of primary key(and * others too) is treated as case-insensitive. <br /> The condition-bean Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupMappingBhv.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupMappingBhv.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupMappingBhv.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,602 @@ +package jp.sf.pal.userinfo.db.bsbhv; + +import java.util.List; + +import jp.sf.pal.userinfo.db.allcommon.DaoReadable; +import jp.sf.pal.userinfo.db.allcommon.DaoWritable; +import jp.sf.pal.userinfo.db.allcommon.Entity; +import jp.sf.pal.userinfo.db.allcommon.bhv.setup.ValueLabelSetupper; +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.ListResultBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.PagingBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.PagingHandler; +import jp.sf.pal.userinfo.db.allcommon.cbean.PagingInvoker; +import jp.sf.pal.userinfo.db.allcommon.cbean.PagingResultBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.ResultBeanBuilder; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; +import jp.sf.pal.userinfo.db.bsentity.dbmeta.GroupMappingDbm; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; +import jp.sf.pal.userinfo.db.exdao.GroupMappingDao; +import jp.sf.pal.userinfo.db.exentity.GroupInfo; +import jp.sf.pal.userinfo.db.exentity.GroupMapping; +import jp.sf.pal.userinfo.db.exentity.UserInfo; + +/** + * The behavior of GROUP_MAPPING. + * + * <pre> + * [primary-key] + * ID + * + * [column] + * ID, USER_ID, GROUP_ID + * + * [sequence] + * + * + * [identity] + * ID + * + * [version-no] + * + * + * [foreign-table] + * GROUP_INFO, USER_INFO + * + * [referrer-table] + * + * + * [foreign-property] + * groupInfo, userInfo + * + * [referrer-property] + * + * </pre> + * + * @author DBFlute(AutoGenerator) + */ +public abstract class BsGroupMappingBhv extends + jp.sf.pal.userinfo.db.allcommon.bhv.AbstractBehaviorWritable { + + //========================================================================== + // ========= + // Definition + // ========== + /* df:BehaviorQueryPathBegin */ + /* df:BehaviorQueryPathEnd */ + + //========================================================================== + // ========= + // Attribute + // ========= + protected GroupMappingDao _dao; + + //========================================================================== + // ========= + // Table name + // ========== + /** @return The name on database of table. (NotNull) */ + public String getTableDbName() { + return "GROUP_MAPPING"; + } + + //========================================================================== + // ========= + // DBMeta + // ====== + /** @return The meta data of the database. (NotNull) */ + public DBMeta getDBMeta() { + return GroupMappingDbm.getInstance(); + } + + /** @return The meta data of the database as my table type. (NotNull) */ + public GroupMappingDbm getMyDBMeta() { + return GroupMappingDbm.getInstance(); + } + + //========================================================================== + // ========= + // Dao Accessor + // ============ + public GroupMappingDao getMyDao() { + return _dao; + } + + public void setMyDao(GroupMappingDao dao) { + assertObjectNotNull("dao", dao); + _dao = dao; + } + + public DaoReadable getDaoReadable() { + return getMyDao(); + } + + public DaoWritable getDaoWritable() { + return getMyDao(); + } + + //========================================================================== + // ========= + // New Instance + // ============ + public Entity newEntity() { + return newMyEntity(); + } + + public ConditionBean newConditionBean() { + return newMyConditionBean(); + } + + public GroupMapping newMyEntity() { + return new GroupMapping(); + } + + public GroupMappingCB newMyConditionBean() { + return new GroupMappingCB(); + } + + //========================================================================== + // ========= + // Count Select + // ============ + /** + * Select the count of the condition-bean. {IgnorePagingCondition} + * + * @param cb The condition-bean of GroupMapping. (NotNull) + * @return The selected count. + */ + public int selectCount(GroupMappingCB cb) { + assertConditionBeanNotNull(cb); + return delegateSelectCount(cb); + } + + //========================================================================== + // ========= + // Entity Select + // ============= + /** + * Select the entity by the condition-bean. + * + * @param cb The condition-bean of GroupMapping. (NotNull) + * @return The selected entity. (Nullalble) + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + */ + public GroupMapping selectEntity(final GroupMappingCB cb) { + return helpSelectEntityInternally( + cb, + new InternalSelectEntityCallback<GroupMapping, GroupMappingCB>() { + public List<GroupMapping> callbackSelectList( + GroupMappingCB cb) { + return selectList(cb); + } + }); + } + + /** + * Select the entity by the condition-bean with deleted check. + * + * @param cb The condition-bean of GroupMapping. (NotNull) + * @return The selected entity. (NotNull) + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + */ + public GroupMapping selectEntityWithDeletedCheck(final GroupMappingCB cb) { + return helpSelectEntityWithDeletedCheckInternally( + cb, + new InternalSelectEntityWithDeletedCheckCallback<GroupMapping, GroupMappingCB>() { + public List<GroupMapping> callbackSelectList( + GroupMappingCB cb) { + return selectList(cb); + } + }); + } + + /* + * (non-javadoc) Select the entity with deleted check. {by primary-key + * value} + * @param primaryKey The keys of primary. + * @return The selected entity. (NotNull) + * @exception + * jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception + * jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException When + * the entity has been duplicated. + */ + public GroupMapping selectByPKValueWithDeletedCheck(Integer id) { + GroupMapping entity = new GroupMapping(); + entity.setId(id); + final GroupMappingCB cb = newMyConditionBean(); + cb.acceptPrimaryKeyMapString(getDBMeta().extractPrimaryKeyMapString( + entity)); + return selectEntityWithDeletedCheck(cb); + } + + //========================================================================== + // ========= + // List Select + // =========== + /** + * Select the list as result bean. + * + * @param cb The condition-bean of GroupMapping. (NotNull) + * @return The result bean of selected list. (NotNull) + */ + public ListResultBean<GroupMapping> selectList(GroupMappingCB cb) { + assertConditionBeanNotNull(cb); + return new ResultBeanBuilder<GroupMapping>(getTableDbName()) + .buildListResultBean(cb, delegateSelectList(cb)); + } + + //========================================================================== + // ========= + // Page Select + // =========== + /** + * Select the page as result bean. + * + * @param cb The condition-bean of GroupMapping. (NotNull) + * @return The result bean of selected page. (NotNull) + */ + public PagingResultBean<GroupMapping> selectPage(final GroupMappingCB cb) { + assertConditionBeanNotNull(cb); + final PagingInvoker<GroupMapping> invoker = new PagingInvoker<GroupMapping>( + getTableDbName()); + final PagingHandler<GroupMapping> handler = new PagingHandler<GroupMapping>() { + public PagingBean getPagingBean() { + return cb; + } + + public int count() { + return selectCount(cb); + } + + public List<GroupMapping> paging() { + return selectList(cb); + } + }; + return invoker.invokePaging(handler); + } + + //========================================================================== + // ========= + // Various Select + // ============== + /** + * Select the list of value-label. + * + * @param cb The condition-bean of GroupMapping. (NotNull) + * @param valueLabelSetupper The setupper of value-label. (NotNull) + * @return The list of value-label. (NotNull) + */ + public List<java.util.Map<String, Object>> selectValueLabelList( + GroupMappingCB cb, + ValueLabelSetupper<GroupMapping> valueLabelSetupper) { + return createValueLabelList(selectList(cb), valueLabelSetupper); + } + + //========================================================================== + // ========= + // Load Referrer + // ============= + + //========================================================================== + // ========= + // Pullout Foreign + // =============== + /** + * Pull out the list of foreign table 'GroupInfo'. + * + * @param groupMappingList The list of groupMapping. (NotNull) + * @return The list of foreign table. (NotNull) + */ + public List<GroupInfo> pulloutGroupInfo(List<GroupMapping> groupMappingList) { + return helpPulloutInternally(groupMappingList, + new InternalPulloutCallback<GroupMapping, GroupInfo>() { + public GroupInfo callbackGetForeignEntity( + GroupMapping entity) { + return entity.getGroupInfo(); + } + }); + } + + /** + * Pull out the list of foreign table 'UserInfo'. + * + * @param groupMappingList The list of groupMapping. (NotNull) + * @return The list of foreign table. (NotNull) + */ + public List<UserInfo> pulloutUserInfo(List<GroupMapping> groupMappingList) { + return helpPulloutInternally(groupMappingList, + new InternalPulloutCallback<GroupMapping, UserInfo>() { + public UserInfo callbackGetForeignEntity(GroupMapping entity) { + return entity.getUserInfo(); + } + }); + } + + //========================================================================== + // ========= + // Entity Update + // ============= + /** + * Insert the entity. + * + * @param groupMapping The entity of insert target. (NotNull) + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyExistsException + * When the entity already exists. (Unique Constraint + * Violation) + */ + public void insert(GroupMapping groupMapping) { + assertEntityNotNull(groupMapping); + delegateInsert(groupMapping); + } + + @Override + protected void doCreate(Entity groupMapping) { + insert((GroupMapping) groupMapping); + } + + /** + * Update the entity modified-only. {UpdateCountZeroException, + * ConcurrencyControl} + * + * @param groupMapping The entity of update target. (NotNull) + * {PrimaryKeyRequired, ConcurrencyColumnRequired} + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyExistsException + * When the entity already exists. (Unique Constraint + * Violation) + */ + public void update(final GroupMapping groupMapping) { + helpUpdateInternally(groupMapping, + new InternalUpdateCallback<GroupMapping>() { + public int callbackDelegateUpdate(GroupMapping entity) { + return delegateUpdate(entity); + } + }); + } + + @Override + protected void doModify(Entity entity) { + update((GroupMapping) entity); + } + + @Override + protected void doModifyNonstrict(Entity entity) { + update((GroupMapping) entity); + } + + /** + * Insert or update the entity modified-only. {ConcurrencyControl(when + * update)} + * + * @param groupMapping The entity of insert or update target. (NotNull) + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyExistsException + * When the entity already exists. (Unique Constraint + * Violation) + */ + public void insertOrUpdate(final GroupMapping groupMapping) { + helpInsertOrUpdateInternally( + groupMapping, + new InternalInsertOrUpdateCallback<GroupMapping, GroupMappingCB>() { + public void callbackInsert(GroupMapping entity) { + insert(entity); + } + + public void callbackUpdate(GroupMapping entity) { + update(entity); + } + + public GroupMappingCB callbackNewMyConditionBean() { + return newMyConditionBean(); + } + + public int callbackSelectCount(GroupMappingCB cb) { + return selectCount(cb); + } + }); + } + + @Override + protected void doCreateOrUpdate(Entity groupMapping) { + insertOrUpdate((GroupMapping) groupMapping); + } + + @Override + protected void doCreateOrUpdateNonstrict(Entity entity) { + insertOrUpdate((GroupMapping) entity); + } + + /** + * Delete the entity. {UpdateCountZeroException, ConcurrencyControl} + * + * @param groupMapping The entity of delete target. (NotNull) + * {PrimaryKeyRequired, ConcurrencyColumnRequired} + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + */ + public void delete(GroupMapping groupMapping) { + helpDeleteInternally(groupMapping, + new InternalDeleteCallback<GroupMapping>() { + public int callbackDelegateDelete(GroupMapping entity) { + return delegateDelete(entity); + } + }); + } + + @Override + protected void doRemove(Entity groupMapping) { + delete((GroupMapping) groupMapping); + } + + //========================================================================== + // ========= + // Batch Update + // ============ + /** + * Batch insert the list. This method use 'Batch Update' of + * java.sql.PreparedStatement. + * + * @param groupMappingList The list of the entity. (NotNull) + * @return The array of inserted count. + */ + public int[] batchInsert(List<GroupMapping> groupMappingList) { + assertObjectNotNull("groupMappingList", groupMappingList); + return delegateInsertList(groupMappingList); + } + + /** + * Batch update the list. All columns are update target. {NOT modified only} + * <br /> This method use 'Batch Update' of java.sql.PreparedStatement. + * + * @param groupMappingList The list of the entity. (NotNull) + * @return The array of updated count. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + */ + public int[] batchUpdate(List<GroupMapping> groupMappingList) { + assertObjectNotNull("groupMappingList", groupMappingList); + return delegateUpdateList(groupMappingList); + } + + /** + * Batch delete the list. <br /> This method use 'Batch Update' of + * java.sql.PreparedStatement. + * + * @param groupMappingList The list of the entity. (NotNull) + * @return The array of deleted count. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + */ + public int[] batchDelete(List<GroupMapping> groupMappingList) { + assertObjectNotNull("groupMappingList", groupMappingList); + return delegateDeleteList(groupMappingList); + } + + //========================================================================== + // ========= + // Query Update + // ============ + /** + * Query update the several entities. {NoConcurrencyControl} + * + * @param groupMapping Entity. (NotNull) {PrimaryKeyNotRequired} + * @param cb Condition-bean. (NotNull) + * @return The updated count. + */ + public int queryUpdate(GroupMapping groupMapping, GroupMappingCB cb) { + assertObjectNotNull("groupMapping", groupMapping); + assertConditionBeanNotNull(cb); + setupCommonColumnOfUpdateIfNeeds(groupMapping); + filterEntityOfUpdate(groupMapping); + assertEntityOfUpdate(groupMapping); + return getMyDao().updateByQuery(cb, groupMapping); + } + + /** + * Query delete the several entities. {NoConcurrencyControl} + * + * @param cb Condition-bean. (NotNull) + * @return The deleted count. + */ + public int queryDelete(GroupMappingCB cb) { + assertConditionBeanNotNull(cb); + return getMyDao().deleteByQuery(cb); + } + + //========================================================================== + // ========= + // Various Update + // ============== + + //========================================================================== + // ========= + // Delegate Method + // =============== + // ----------------------------------------------------- + // Select + // ------ + protected int delegateSelectCount(GroupMappingCB cb) { + assertConditionBeanNotNull(cb); + return getMyDao().selectCount(cb); + } + + protected List<GroupMapping> delegateSelectList(GroupMappingCB cb) { + assertConditionBeanNotNull(cb); + return getMyDao().selectList(cb); + } + + // ----------------------------------------------------- + // Update + // ------ + protected int delegateInsert(GroupMapping e) { + if (!processBeforeInsert(e)) { + return 1; + } + return getMyDao().insert(e); + } + + protected int delegateUpdate(GroupMapping e) { + if (!processBeforeUpdate(e)) { + return 1; + } + return getMyDao().updateModifiedOnly(e); + } + + protected int delegateDelete(GroupMapping e) { + if (!processBeforeDelete(e)) { + return 1; + } + return getMyDao().delete(e); + } + + protected int[] delegateInsertList(List<GroupMapping> ls) { + assertObjectNotNull("groupMappingList", ls); + return getMyDao().insertList(helpFilterBeforeInsertInternally(ls)); + } + + protected int[] delegateUpdateList(List<GroupMapping> ls) { + assertObjectNotNull("groupMappingList", ls); + return getMyDao().updateList(helpFilterBeforeUpdateInternally(ls)); + } + + protected int[] delegateDeleteList(List<GroupMapping> ls) { + assertObjectNotNull("groupMappingList", ls); + return getMyDao().deleteList(helpFilterBeforeDeleteInternally(ls)); + } + + //========================================================================== + // ========= + // Optimistic Lock Info + // ==================== + @Override + protected boolean hasVersionNoValue(Entity entity) { + return false; + } + + @Override + protected boolean hasUpdateDateValue(Entity entity) { + return false; + } + + //========================================================================== + // ========= + // Helper + // ====== + protected GroupMapping downcast(Entity entity) { + return helpDowncastInternally(entity, GroupMapping.class); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsGroupMappingBhv.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleInfoBhv.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleInfoBhv.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleInfoBhv.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -18,10 +18,13 @@ import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; import jp.sf.pal.userinfo.db.bsentity.dbmeta.RoleInfoDbm; import jp.sf.pal.userinfo.db.cbean.RoleInfoCB; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; +import jp.sf.pal.userinfo.db.exbhv.RoleMappingBhv; import jp.sf.pal.userinfo.db.exbhv.UserInfoBhv; import jp.sf.pal.userinfo.db.exdao.RoleInfoDao; import jp.sf.pal.userinfo.db.exentity.RoleInfo; +import jp.sf.pal.userinfo.db.exentity.RoleMapping; import jp.sf.pal.userinfo.db.exentity.UserInfo; /** @@ -47,13 +50,13 @@ * * * [referrer-table] - * USER_INFO + * ROLE_MAPPING, USER_INFO * * [foreign-property] * * * [referrer-property] - * userInfoList + * roleMappingList, userInfoList * </pre> * * @author DBFlute(AutoGenerator) @@ -282,6 +285,97 @@ // Load Referrer // ============= /** + * Load referrer of roleMappingList with the setupper for condition-bean of + * referrer. <br /> About internal policy, the value of primary key(and + * others too) is treated as case-insensitive. <br /> The condition-bean + * that the setupper provides have settings before you touch it. It is as + * follows: + * + * <pre> + * cb.query().setRoleId_InScope(pkList); + * cb.query().addOrderBy_RoleId_Asc(); + * </pre> + * + * @param roleInfoList The entity list of roleInfo. (NotNull) + * @param conditionBeanSetupper The instance of referrer condition-bean + * setupper for registering referrer condition. (NotNull) + */ + public void loadRoleMappingList(List<RoleInfo> roleInfoList, + ConditionBeanSetupper<RoleMappingCB> conditionBeanSetupper) { + assertObjectNotNull("roleInfoList<RoleInfo>", roleInfoList); + assertObjectNotNull("conditionBeanSetupper<RoleMappingCB>", + conditionBeanSetupper); + if (roleInfoList.isEmpty()) { + return; + } + loadRoleMappingList(roleInfoList, + new LoadReferrerOption<RoleMappingCB, RoleMapping>( + conditionBeanSetupper)); + } + + /** + * {Refer to overload method that has an argument of condition-bean + * setupper.} + * + * @param roleInfoList The entity list of roleInfo. (NotNull) + * @param loadReferrerOption The option of load-referrer. (NotNull) + */ + public void loadRoleMappingList(List<RoleInfo> roleInfoList, + LoadReferrerOption<RoleMappingCB, RoleMapping> loadReferrerOption) { + assertObjectNotNull("roleInfoList<RoleInfo>", roleInfoList); + assertObjectNotNull("loadReferrerOption<RoleMapping, RoleMappingCB>", + loadReferrerOption); + if (roleInfoList.isEmpty()) { + return; + } + final RoleMappingBhv referrerBhv = xgetBSFLR().select( + RoleMappingBhv.class); + helpLoadReferrerInternally( + roleInfoList, + loadReferrerOption, + new InternalLoadReferrerCallback<RoleInfo, String, RoleMappingCB, RoleMapping>() { + public String callbackBase_getPrimaryKeyValue( + RoleInfo entity) { + return entity.getRoleId(); + } + + public void callbackBase_setReferrerList(RoleInfo entity, + List<RoleMapping> referrerList) { + entity.setRoleMappingList(referrerList); + } + + public RoleMappingCB callbackReferrer_newMyConditionBean() { + return referrerBhv.newMyConditionBean(); + } + + public void callbackReferrer_queryForeignKeyInScope( + RoleMappingCB cb, List<String> pkList) { + cb.query().setRoleId_InScope(pkList); + } + + public void callbackReferrer_queryAddOrderByForeignKeyAsc( + RoleMappingCB cb) { + cb.query().addOrderBy_RoleId_Asc(); + } + + public List<RoleMapping> callbackReferrer_selectList( + RoleMappingCB cb) { + return referrerBhv.selectList(cb); + } + + public String callbackReferrer_getForeignKeyValue( + RoleMapping entity) { + return entity.getRoleId(); + } + + public void callbackReferrer_setForeignEntity( + RoleMapping referrerEntity, RoleInfo baseEntity) { + referrerEntity.setRoleInfo(baseEntity); + } + }); + } + + /** * Load referrer of userInfoList with the setupper for condition-bean of * referrer. <br /> About internal policy, the value of primary key(and * others too) is treated as case-insensitive. <br /> The condition-bean Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleMappingBhv.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleMappingBhv.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleMappingBhv.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,597 @@ +package jp.sf.pal.userinfo.db.bsbhv; + +import java.util.List; + +import jp.sf.pal.userinfo.db.allcommon.DaoReadable; +import jp.sf.pal.userinfo.db.allcommon.DaoWritable; +import jp.sf.pal.userinfo.db.allcommon.Entity; +import jp.sf.pal.userinfo.db.allcommon.bhv.setup.ValueLabelSetupper; +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.ListResultBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.PagingBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.PagingHandler; +import jp.sf.pal.userinfo.db.allcommon.cbean.PagingInvoker; +import jp.sf.pal.userinfo.db.allcommon.cbean.PagingResultBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.ResultBeanBuilder; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; +import jp.sf.pal.userinfo.db.bsentity.dbmeta.RoleMappingDbm; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; +import jp.sf.pal.userinfo.db.exdao.RoleMappingDao; +import jp.sf.pal.userinfo.db.exentity.RoleInfo; +import jp.sf.pal.userinfo.db.exentity.RoleMapping; +import jp.sf.pal.userinfo.db.exentity.UserInfo; + +/** + * The behavior of ROLE_MAPPING. + * + * <pre> + * [primary-key] + * ID + * + * [column] + * ID, USER_ID, ROLE_ID + * + * [sequence] + * + * + * [identity] + * ID + * + * [version-no] + * + * + * [foreign-table] + * ROLE_INFO, USER_INFO + * + * [referrer-table] + * + * + * [foreign-property] + * roleInfo, userInfo + * + * [referrer-property] + * + * </pre> + * + * @author DBFlute(AutoGenerator) + */ +public abstract class BsRoleMappingBhv extends + jp.sf.pal.userinfo.db.allcommon.bhv.AbstractBehaviorWritable { + + //========================================================================== + // ========= + // Definition + // ========== + /* df:BehaviorQueryPathBegin */ + /* df:BehaviorQueryPathEnd */ + + //========================================================================== + // ========= + // Attribute + // ========= + protected RoleMappingDao _dao; + + //========================================================================== + // ========= + // Table name + // ========== + /** @return The name on database of table. (NotNull) */ + public String getTableDbName() { + return "ROLE_MAPPING"; + } + + //========================================================================== + // ========= + // DBMeta + // ====== + /** @return The meta data of the database. (NotNull) */ + public DBMeta getDBMeta() { + return RoleMappingDbm.getInstance(); + } + + /** @return The meta data of the database as my table type. (NotNull) */ + public RoleMappingDbm getMyDBMeta() { + return RoleMappingDbm.getInstance(); + } + + //========================================================================== + // ========= + // Dao Accessor + // ============ + public RoleMappingDao getMyDao() { + return _dao; + } + + public void setMyDao(RoleMappingDao dao) { + assertObjectNotNull("dao", dao); + _dao = dao; + } + + public DaoReadable getDaoReadable() { + return getMyDao(); + } + + public DaoWritable getDaoWritable() { + return getMyDao(); + } + + //========================================================================== + // ========= + // New Instance + // ============ + public Entity newEntity() { + return newMyEntity(); + } + + public ConditionBean newConditionBean() { + return newMyConditionBean(); + } + + public RoleMapping newMyEntity() { + return new RoleMapping(); + } + + public RoleMappingCB newMyConditionBean() { + return new RoleMappingCB(); + } + + //========================================================================== + // ========= + // Count Select + // ============ + /** + * Select the count of the condition-bean. {IgnorePagingCondition} + * + * @param cb The condition-bean of RoleMapping. (NotNull) + * @return The selected count. + */ + public int selectCount(RoleMappingCB cb) { + assertConditionBeanNotNull(cb); + return delegateSelectCount(cb); + } + + //========================================================================== + // ========= + // Entity Select + // ============= + /** + * Select the entity by the condition-bean. + * + * @param cb The condition-bean of RoleMapping. (NotNull) + * @return The selected entity. (Nullalble) + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + */ + public RoleMapping selectEntity(final RoleMappingCB cb) { + return helpSelectEntityInternally(cb, + new InternalSelectEntityCallback<RoleMapping, RoleMappingCB>() { + public List<RoleMapping> callbackSelectList(RoleMappingCB cb) { + return selectList(cb); + } + }); + } + + /** + * Select the entity by the condition-bean with deleted check. + * + * @param cb The condition-bean of RoleMapping. (NotNull) + * @return The selected entity. (NotNull) + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + */ + public RoleMapping selectEntityWithDeletedCheck(final RoleMappingCB cb) { + return helpSelectEntityWithDeletedCheckInternally( + cb, + new InternalSelectEntityWithDeletedCheckCallback<RoleMapping, RoleMappingCB>() { + public List<RoleMapping> callbackSelectList(RoleMappingCB cb) { + return selectList(cb); + } + }); + } + + /* + * (non-javadoc) Select the entity with deleted check. {by primary-key + * value} + * @param primaryKey The keys of primary. + * @return The selected entity. (NotNull) + * @exception + * jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception + * jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException When + * the entity has been duplicated. + */ + public RoleMapping selectByPKValueWithDeletedCheck(Integer id) { + RoleMapping entity = new RoleMapping(); + entity.setId(id); + final RoleMappingCB cb = newMyConditionBean(); + cb.acceptPrimaryKeyMapString(getDBMeta().extractPrimaryKeyMapString( + entity)); + return selectEntityWithDeletedCheck(cb); + } + + //========================================================================== + // ========= + // List Select + // =========== + /** + * Select the list as result bean. + * + * @param cb The condition-bean of RoleMapping. (NotNull) + * @return The result bean of selected list. (NotNull) + */ + public ListResultBean<RoleMapping> selectList(RoleMappingCB cb) { + assertConditionBeanNotNull(cb); + return new ResultBeanBuilder<RoleMapping>(getTableDbName()) + .buildListResultBean(cb, delegateSelectList(cb)); + } + + //========================================================================== + // ========= + // Page Select + // =========== + /** + * Select the page as result bean. + * + * @param cb The condition-bean of RoleMapping. (NotNull) + * @return The result bean of selected page. (NotNull) + */ + public PagingResultBean<RoleMapping> selectPage(final RoleMappingCB cb) { + assertConditionBeanNotNull(cb); + final PagingInvoker<RoleMapping> invoker = new PagingInvoker<RoleMapping>( + getTableDbName()); + final PagingHandler<RoleMapping> handler = new PagingHandler<RoleMapping>() { + public PagingBean getPagingBean() { + return cb; + } + + public int count() { + return selectCount(cb); + } + + public List<RoleMapping> paging() { + return selectList(cb); + } + }; + return invoker.invokePaging(handler); + } + + //========================================================================== + // ========= + // Various Select + // ============== + /** + * Select the list of value-label. + * + * @param cb The condition-bean of RoleMapping. (NotNull) + * @param valueLabelSetupper The setupper of value-label. (NotNull) + * @return The list of value-label. (NotNull) + */ + public List<java.util.Map<String, Object>> selectValueLabelList( + RoleMappingCB cb, ValueLabelSetupper<RoleMapping> valueLabelSetupper) { + return createValueLabelList(selectList(cb), valueLabelSetupper); + } + + //========================================================================== + // ========= + // Load Referrer + // ============= + + //========================================================================== + // ========= + // Pullout Foreign + // =============== + /** + * Pull out the list of foreign table 'RoleInfo'. + * + * @param roleMappingList The list of roleMapping. (NotNull) + * @return The list of foreign table. (NotNull) + */ + public List<RoleInfo> pulloutRoleInfo(List<RoleMapping> roleMappingList) { + return helpPulloutInternally(roleMappingList, + new InternalPulloutCallback<RoleMapping, RoleInfo>() { + public RoleInfo callbackGetForeignEntity(RoleMapping entity) { + return entity.getRoleInfo(); + } + }); + } + + /** + * Pull out the list of foreign table 'UserInfo'. + * + * @param roleMappingList The list of roleMapping. (NotNull) + * @return The list of foreign table. (NotNull) + */ + public List<UserInfo> pulloutUserInfo(List<RoleMapping> roleMappingList) { + return helpPulloutInternally(roleMappingList, + new InternalPulloutCallback<RoleMapping, UserInfo>() { + public UserInfo callbackGetForeignEntity(RoleMapping entity) { + return entity.getUserInfo(); + } + }); + } + + //========================================================================== + // ========= + // Entity Update + // ============= + /** + * Insert the entity. + * + * @param roleMapping The entity of insert target. (NotNull) + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyExistsException + * When the entity already exists. (Unique Constraint + * Violation) + */ + public void insert(RoleMapping roleMapping) { + assertEntityNotNull(roleMapping); + delegateInsert(roleMapping); + } + + @Override + protected void doCreate(Entity roleMapping) { + insert((RoleMapping) roleMapping); + } + + /** + * Update the entity modified-only. {UpdateCountZeroException, + * ConcurrencyControl} + * + * @param roleMapping The entity of update target. (NotNull) + * {PrimaryKeyRequired, ConcurrencyColumnRequired} + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyExistsException + * When the entity already exists. (Unique Constraint + * Violation) + */ + public void update(final RoleMapping roleMapping) { + helpUpdateInternally(roleMapping, + new InternalUpdateCallback<RoleMapping>() { + public int callbackDelegateUpdate(RoleMapping entity) { + return delegateUpdate(entity); + } + }); + } + + @Override + protected void doModify(Entity entity) { + update((RoleMapping) entity); + } + + @Override + protected void doModifyNonstrict(Entity entity) { + update((RoleMapping) entity); + } + + /** + * Insert or update the entity modified-only. {ConcurrencyControl(when + * update)} + * + * @param roleMapping The entity of insert or update target. (NotNull) + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyExistsException + * When the entity already exists. (Unique Constraint + * Violation) + */ + public void insertOrUpdate(final RoleMapping roleMapping) { + helpInsertOrUpdateInternally( + roleMapping, + new InternalInsertOrUpdateCallback<RoleMapping, RoleMappingCB>() { + public void callbackInsert(RoleMapping entity) { + insert(entity); + } + + public void callbackUpdate(RoleMapping entity) { + update(entity); + } + + public RoleMappingCB callbackNewMyConditionBean() { + return newMyConditionBean(); + } + + public int callbackSelectCount(RoleMappingCB cb) { + return selectCount(cb); + } + }); + } + + @Override + protected void doCreateOrUpdate(Entity roleMapping) { + insertOrUpdate((RoleMapping) roleMapping); + } + + @Override + protected void doCreateOrUpdateNonstrict(Entity entity) { + insertOrUpdate((RoleMapping) entity); + } + + /** + * Delete the entity. {UpdateCountZeroException, ConcurrencyControl} + * + * @param roleMapping The entity of delete target. (NotNull) + * {PrimaryKeyRequired, ConcurrencyColumnRequired} + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityDuplicatedException + * When the entity has been duplicated. + */ + public void delete(RoleMapping roleMapping) { + helpDeleteInternally(roleMapping, + new InternalDeleteCallback<RoleMapping>() { + public int callbackDelegateDelete(RoleMapping entity) { + return delegateDelete(entity); + } + }); + } + + @Override + protected void doRemove(Entity roleMapping) { + delete((RoleMapping) roleMapping); + } + + //========================================================================== + // ========= + // Batch Update + // ============ + /** + * Batch insert the list. This method use 'Batch Update' of + * java.sql.PreparedStatement. + * + * @param roleMappingList The list of the entity. (NotNull) + * @return The array of inserted count. + */ + public int[] batchInsert(List<RoleMapping> roleMappingList) { + assertObjectNotNull("roleMappingList", roleMappingList); + return delegateInsertList(roleMappingList); + } + + /** + * Batch update the list. All columns are update target. {NOT modified only} + * <br /> This method use 'Batch Update' of java.sql.PreparedStatement. + * + * @param roleMappingList The list of the entity. (NotNull) + * @return The array of updated count. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + */ + public int[] batchUpdate(List<RoleMapping> roleMappingList) { + assertObjectNotNull("roleMappingList", roleMappingList); + return delegateUpdateList(roleMappingList); + } + + /** + * Batch delete the list. <br /> This method use 'Batch Update' of + * java.sql.PreparedStatement. + * + * @param roleMappingList The list of the entity. (NotNull) + * @return The array of deleted count. + * @exception jp.sf.pal.userinfo.db.allcommon.exception.EntityAlreadyDeletedException + * When the entity has already been deleted. + */ + public int[] batchDelete(List<RoleMapping> roleMappingList) { + assertObjectNotNull("roleMappingList", roleMappingList); + return delegateDeleteList(roleMappingList); + } + + //========================================================================== + // ========= + // Query Update + // ============ + /** + * Query update the several entities. {NoConcurrencyControl} + * + * @param roleMapping Entity. (NotNull) {PrimaryKeyNotRequired} + * @param cb Condition-bean. (NotNull) + * @return The updated count. + */ + public int queryUpdate(RoleMapping roleMapping, RoleMappingCB cb) { + assertObjectNotNull("roleMapping", roleMapping); + assertConditionBeanNotNull(cb); + setupCommonColumnOfUpdateIfNeeds(roleMapping); + filterEntityOfUpdate(roleMapping); + assertEntityOfUpdate(roleMapping); + return getMyDao().updateByQuery(cb, roleMapping); + } + + /** + * Query delete the several entities. {NoConcurrencyControl} + * + * @param cb Condition-bean. (NotNull) + * @return The deleted count. + */ + public int queryDelete(RoleMappingCB cb) { + assertConditionBeanNotNull(cb); + return getMyDao().deleteByQuery(cb); + } + + //========================================================================== + // ========= + // Various Update + // ============== + + //========================================================================== + // ========= + // Delegate Method + // =============== + // ----------------------------------------------------- + // Select + // ------ + protected int delegateSelectCount(RoleMappingCB cb) { + assertConditionBeanNotNull(cb); + return getMyDao().selectCount(cb); + } + + protected List<RoleMapping> delegateSelectList(RoleMappingCB cb) { + assertConditionBeanNotNull(cb); + return getMyDao().selectList(cb); + } + + // ----------------------------------------------------- + // Update + // ------ + protected int delegateInsert(RoleMapping e) { + if (!processBeforeInsert(e)) { + return 1; + } + return getMyDao().insert(e); + } + + protected int delegateUpdate(RoleMapping e) { + if (!processBeforeUpdate(e)) { + return 1; + } + return getMyDao().updateModifiedOnly(e); + } + + protected int delegateDelete(RoleMapping e) { + if (!processBeforeDelete(e)) { + return 1; + } + return getMyDao().delete(e); + } + + protected int[] delegateInsertList(List<RoleMapping> ls) { + assertObjectNotNull("roleMappingList", ls); + return getMyDao().insertList(helpFilterBeforeInsertInternally(ls)); + } + + protected int[] delegateUpdateList(List<RoleMapping> ls) { + assertObjectNotNull("roleMappingList", ls); + return getMyDao().updateList(helpFilterBeforeUpdateInternally(ls)); + } + + protected int[] delegateDeleteList(List<RoleMapping> ls) { + assertObjectNotNull("roleMappingList", ls); + return getMyDao().deleteList(helpFilterBeforeDeleteInternally(ls)); + } + + //========================================================================== + // ========= + // Optimistic Lock Info + // ==================== + @Override + protected boolean hasVersionNoValue(Entity entity) { + return false; + } + + @Override + protected boolean hasUpdateDateValue(Entity entity) { + return false; + } + + //========================================================================== + // ========= + // Helper + // ====== + protected RoleMapping downcast(Entity entity) { + return helpDowncastInternally(entity, RoleMapping.class); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsRoleMappingBhv.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsUserInfoBhv.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsUserInfoBhv.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsbhv/BsUserInfoBhv.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -5,6 +5,8 @@ import jp.sf.pal.userinfo.db.allcommon.DaoReadable; import jp.sf.pal.userinfo.db.allcommon.DaoWritable; import jp.sf.pal.userinfo.db.allcommon.Entity; +import jp.sf.pal.userinfo.db.allcommon.bhv.load.LoadReferrerOption; +import jp.sf.pal.userinfo.db.allcommon.bhv.setup.ConditionBeanSetupper; import jp.sf.pal.userinfo.db.allcommon.bhv.setup.ValueLabelSetupper; import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionBean; import jp.sf.pal.userinfo.db.allcommon.cbean.ListResultBean; @@ -15,10 +17,16 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.ResultBeanBuilder; import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; import jp.sf.pal.userinfo.db.bsentity.dbmeta.UserInfoDbm; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; +import jp.sf.pal.userinfo.db.exbhv.GroupMappingBhv; +import jp.sf.pal.userinfo.db.exbhv.RoleMappingBhv; import jp.sf.pal.userinfo.db.exdao.UserInfoDao; import jp.sf.pal.userinfo.db.exentity.GroupInfo; +import jp.sf.pal.userinfo.db.exentity.GroupMapping; import jp.sf.pal.userinfo.db.exentity.RoleInfo; +import jp.sf.pal.userinfo.db.exentity.RoleMapping; import jp.sf.pal.userinfo.db.exentity.UserInfo; /** @@ -44,13 +52,13 @@ * GROUP_INFO, ROLE_INFO * * [referrer-table] - * + * GROUP_MAPPING, ROLE_MAPPING * * [foreign-property] * groupInfo, roleInfo * * [referrer-property] - * + * groupMappingList, roleMappingList * </pre> * * @author DBFlute(AutoGenerator) @@ -278,7 +286,188 @@ // ========= // Load Referrer // ============= + /** + * Load referrer of groupMappingList with the setupper for condition-bean of + * referrer. <br /> About internal policy, the value of primary key(and + * others too) is treated as case-insensitive. <br /> The condition-bean + * that the setupper provides have settings before you touch it. It is as + * follows: + * + * <pre> + * cb.query().setUserId_InScope(pkList); + * cb.query().addOrderBy_UserId_Asc(); + * </pre> + * + * @param userInfoList The entity list of userInfo. (NotNull) + * @param conditionBeanSetupper The instance of referrer condition-bean + * setupper for registering referrer condition. (NotNull) + */ + public void loadGroupMappingList(List<UserInfo> userInfoList, + ConditionBeanSetupper<GroupMappingCB> conditionBeanSetupper) { + assertObjectNotNull("userInfoList<UserInfo>", userInfoList); + assertObjectNotNull("conditionBeanSetupper<GroupMappingCB>", + conditionBeanSetupper); + if (userInfoList.isEmpty()) { + return; + } + loadGroupMappingList(userInfoList, + new LoadReferrerOption<GroupMappingCB, GroupMapping>( + conditionBeanSetupper)); + } + /** + * {Refer to overload method that has an argument of condition-bean + * setupper.} + * + * @param userInfoList The entity list of userInfo. (NotNull) + * @param loadReferrerOption The option of load-referrer. (NotNull) + */ + public void loadGroupMappingList(List<UserInfo> userInfoList, + LoadReferrerOption<GroupMappingCB, GroupMapping> loadReferrerOption) { + assertObjectNotNull("userInfoList<UserInfo>", userInfoList); + assertObjectNotNull("loadReferrerOption<GroupMapping, GroupMappingCB>", + loadReferrerOption); + if (userInfoList.isEmpty()) { + return; + } + final GroupMappingBhv referrerBhv = xgetBSFLR().select( + GroupMappingBhv.class); + helpLoadReferrerInternally( + userInfoList, + loadReferrerOption, + new InternalLoadReferrerCallback<UserInfo, String, GroupMappingCB, GroupMapping>() { + public String callbackBase_getPrimaryKeyValue( + UserInfo entity) { + return entity.getUserId(); + } + + public void callbackBase_setReferrerList(UserInfo entity, + List<GroupMapping> referrerList) { + entity.setGroupMappingList(referrerList); + } + + public GroupMappingCB callbackReferrer_newMyConditionBean() { + return referrerBhv.newMyConditionBean(); + } + + public void callbackReferrer_queryForeignKeyInScope( + GroupMappingCB cb, List<String> pkList) { + cb.query().setUserId_InScope(pkList); + } + + public void callbackReferrer_queryAddOrderByForeignKeyAsc( + GroupMappingCB cb) { + cb.query().addOrderBy_UserId_Asc(); + } + + public List<GroupMapping> callbackReferrer_selectList( + GroupMappingCB cb) { + return referrerBhv.selectList(cb); + } + + public String callbackReferrer_getForeignKeyValue( + GroupMapping entity) { + return entity.getUserId(); + } + + public void callbackReferrer_setForeignEntity( + GroupMapping referrerEntity, UserInfo baseEntity) { + referrerEntity.setUserInfo(baseEntity); + } + }); + } + + /** + * Load referrer of roleMappingList with the setupper for condition-bean of + * referrer. <br /> About internal policy, the value of primary key(and + * others too) is treated as case-insensitive. <br /> The condition-bean + * that the setupper provides have settings before you touch it. It is as + * follows: + * + * <pre> + * cb.query().setUserId_InScope(pkList); + * cb.query().addOrderBy_UserId_Asc(); + * </pre> + * + * @param userInfoList The entity list of userInfo. (NotNull) + * @param conditionBeanSetupper The instance of referrer condition-bean + * setupper for registering referrer condition. (NotNull) + */ + public void loadRoleMappingList(List<UserInfo> userInfoList, + ConditionBeanSetupper<RoleMappingCB> conditionBeanSetupper) { + assertObjectNotNull("userInfoList<UserInfo>", userInfoList); + assertObjectNotNull("conditionBeanSetupper<RoleMappingCB>", + conditionBeanSetupper); + if (userInfoList.isEmpty()) { + return; + } + loadRoleMappingList(userInfoList, + new LoadReferrerOption<RoleMappingCB, RoleMapping>( + conditionBeanSetupper)); + } + + /** + * {Refer to overload method that has an argument of condition-bean + * setupper.} + * + * @param userInfoList The entity list of userInfo. (NotNull) + * @param loadReferrerOption The option of load-referrer. (NotNull) + */ + public void loadRoleMappingList(List<UserInfo> userInfoList, + LoadReferrerOption<RoleMappingCB, RoleMapping> loadReferrerOption) { + assertObjectNotNull("userInfoList<UserInfo>", userInfoList); + assertObjectNotNull("loadReferrerOption<RoleMapping, RoleMappingCB>", + loadReferrerOption); + if (userInfoList.isEmpty()) { + return; + } + final RoleMappingBhv referrerBhv = xgetBSFLR().select( + RoleMappingBhv.class); + helpLoadReferrerInternally( + userInfoList, + loadReferrerOption, + new InternalLoadReferrerCallback<UserInfo, String, RoleMappingCB, RoleMapping>() { + public String callbackBase_getPrimaryKeyValue( + UserInfo entity) { + return entity.getUserId(); + } + + public void callbackBase_setReferrerList(UserInfo entity, + List<RoleMapping> referrerList) { + entity.setRoleMappingList(referrerList); + } + + public RoleMappingCB callbackReferrer_newMyConditionBean() { + return referrerBhv.newMyConditionBean(); + } + + public void callbackReferrer_queryForeignKeyInScope( + RoleMappingCB cb, List<String> pkList) { + cb.query().setUserId_InScope(pkList); + } + + public void callbackReferrer_queryAddOrderByForeignKeyAsc( + RoleMappingCB cb) { + cb.query().addOrderBy_UserId_Asc(); + } + + public List<RoleMapping> callbackReferrer_selectList( + RoleMappingCB cb) { + return referrerBhv.selectList(cb); + } + + public String callbackReferrer_getForeignKeyValue( + RoleMapping entity) { + return entity.getUserId(); + } + + public void callbackReferrer_setForeignEntity( + RoleMapping referrerEntity, UserInfo baseEntity) { + referrerEntity.setUserInfo(baseEntity); + } + }); + } + //========================================================================== // ========= // Pullout Foreign Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsGroupMappingDao.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsGroupMappingDao.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsGroupMappingDao.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,37 @@ +package jp.sf.pal.userinfo.db.bsdao; + +import java.util.List; + +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; +import jp.sf.pal.userinfo.db.exentity.GroupMapping; + +/** + * The DAO interface of GROUP_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ +public interface BsGroupMappingDao extends + jp.sf.pal.userinfo.db.allcommon.DaoWritable { + + public Class<?> BEAN = GroupMapping.class; // For S2Dao + + public int selectCount(GroupMappingCB cb); + + public List<GroupMapping> selectList(GroupMappingCB cb); + + int insert(GroupMapping entity); + + int updateModifiedOnly(GroupMapping entity); + + int delete(GroupMapping entity); + + int[] insertList(List<GroupMapping> entityList); + + int[] updateList(List<GroupMapping> entityList); + + int updateByQuery(GroupMappingCB cb, GroupMapping entity); + + int[] deleteList(List<GroupMapping> entityList); + + int deleteByQuery(GroupMappingCB cb); +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsGroupMappingDao.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsRoleMappingDao.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsRoleMappingDao.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsRoleMappingDao.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,37 @@ +package jp.sf.pal.userinfo.db.bsdao; + +import java.util.List; + +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; +import jp.sf.pal.userinfo.db.exentity.RoleMapping; + +/** + * The DAO interface of ROLE_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ +public interface BsRoleMappingDao extends + jp.sf.pal.userinfo.db.allcommon.DaoWritable { + + public Class<?> BEAN = RoleMapping.class; // For S2Dao + + public int selectCount(RoleMappingCB cb); + + public List<RoleMapping> selectList(RoleMappingCB cb); + + int insert(RoleMapping entity); + + int updateModifiedOnly(RoleMapping entity); + + int delete(RoleMapping entity); + + int[] insertList(List<RoleMapping> entityList); + + int[] updateList(List<RoleMapping> entityList); + + int updateByQuery(RoleMappingCB cb, RoleMapping entity); + + int[] deleteList(List<RoleMapping> entityList); + + int deleteByQuery(RoleMappingCB cb); +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsdao/BsRoleMappingDao.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupInfo.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupInfo.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupInfo.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -7,6 +7,7 @@ import jp.sf.pal.userinfo.db.allcommon.Entity; import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMetaInstanceHandler; +import jp.sf.pal.userinfo.db.exentity.GroupMapping; import jp.sf.pal.userinfo.db.exentity.UserInfo; /** @@ -32,13 +33,13 @@ * * * [referrer-table] - * USER_INFO + * GROUP_MAPPING, USER_INFO * * [foreign-property] * * * [referrer-property] - * userInfoList + * groupMappingList, userInfoList * </pre> * * @author DBFlute(AutoGenerator) @@ -159,6 +160,36 @@ // Referrer Property // ================= // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + // Referrer Property = [groupMappingList] + // * * * * * * * * */ + /** GROUP_MAPPING as 'groupMappingList'. */ + protected List<GroupMapping> _childrenGroupMappingList; + + /** + * GROUP_MAPPING as 'groupMappingList'. {without lazy-load} <br /> + * + * @return The entity list of referrer property 'groupMappingList'. + * (NotNull: If it's not loaded yet, initializes the list instance + * of referrer as empty and returns it.) + */ + public List<GroupMapping> getGroupMappingList() { + if (_childrenGroupMappingList == null) { + _childrenGroupMappingList = new ArrayList<GroupMapping>(); + } + return _childrenGroupMappingList; + } + + /** + * GROUP_MAPPING as 'groupMappingList'. + * + * @param groupMappingList The entity list of referrer property + * 'groupMappingList'. (Nullable) + */ + public void setGroupMappingList(List<GroupMapping> groupMappingList) { + _childrenGroupMappingList = groupMappingList; + } + + // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * // Referrer Property = [userInfoList] // * * * * * * * * */ /** USER_INFO as 'userInfoList'. */ Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupMapping.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupMapping.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupMapping.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,356 @@ +package jp.sf.pal.userinfo.db.bsentity; + +import java.util.Set; + +import jp.sf.pal.userinfo.db.allcommon.Entity; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMetaInstanceHandler; +import jp.sf.pal.userinfo.db.exentity.GroupInfo; +import jp.sf.pal.userinfo.db.exentity.UserInfo; + +/** + * The entity of GROUP_MAPPING that the type is TABLE. <br /> + * + * <pre> + * [primary-key] + * ID + * + * [column] + * ID, USER_ID, GROUP_ID + * + * [sequence] + * + * + * [identity] + * ID + * + * [version-no] + * + * + * [foreign-table] + * GROUP_INFO, USER_INFO + * + * [referrer-table] + * + * + * [foreign-property] + * groupInfo, userInfo + * + * [referrer-property] + * + * </pre> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public abstract class BsGroupMapping implements Entity, java.io.Serializable { + + //========================================================================== + // ========= + // Definition + // ========== + /** Serial version UID. (Default) */ + private static final long serialVersionUID = 1L; + + /** TABLE-Annotation for S2Dao. The value is GROUP_MAPPING. */ + public static final String TABLE = "GROUP_MAPPING"; + + /** ID-Annotation */ + public static final String id_ID = "identity"; + + //========================================================================== + // ========= + // Attribute + // ========= + // ----------------------------------------------------- + // Column + // ------ + /** ID: {PK : ID : NotNull : INTEGER} */ + protected Integer _id; + + /** USER_ID: {NotNull : VARCHAR(255) : FK to USER_INFO} */ + protected String _userId; + + /** GROUP_ID: {NotNull : VARCHAR(255) : FK to GROUP_INFO} */ + protected String _groupId; + + // ----------------------------------------------------- + // Internal + // -------- + /** The attribute of entity modified properties. (for S2Dao) */ + protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties(); + + //========================================================================== + // ========= + // Constructor + // =========== + public BsGroupMapping() { + } + + //========================================================================== + // ========= + // Table Name + // ========== + public String getTableDbName() { + return "GROUP_MAPPING"; + } + + public String getTablePropertyName() {// as JavaBeansRule + return "groupMapping"; + } + + //========================================================================== + // ========= + // DBMeta + // ====== + public DBMeta getDBMeta() { + return DBMetaInstanceHandler.findDBMeta(getTableDbName()); + } + + //========================================================================== + // ========= + // Classification Classifying + // ========================== + //========================================================================== + // ========= + // Classification Determination + // ============================ + //========================================================================== + // ========= + // Classification Name/Alias + // ========================= + //========================================================================== + // ========= + // Foreign Property + // ================ + // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + // Foreign Property = [groupInfo] + // * * * * * * * * */ + public static final int groupInfo_RELNO = 0; + + public static final String groupInfo_RELKEYS = "GROUP_ID:GROUP_ID"; + + /** GROUP_INFO as 'groupInfo'. */ + protected GroupInfo _parentGroupInfo; + + /** + * GROUP_INFO as 'groupInfo'. {without lazy-load} + * + * @return The entity of foreign property 'groupInfo'. (Nullable: If the + * foreign key does not have 'NotNull' constraint, please check + * null.) + */ + public GroupInfo getGroupInfo() { + return _parentGroupInfo; + } + + /** + * GROUP_INFO as 'groupInfo'. + * + * @param groupInfo The entity of foreign property 'groupInfo'. (Nullable) + */ + public void setGroupInfo(GroupInfo groupInfo) { + _parentGroupInfo = groupInfo; + } + + // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + // Foreign Property = [userInfo] + // * * * * * * * * */ + public static final int userInfo_RELNO = 1; + + public static final String userInfo_RELKEYS = "USER_ID:USER_ID"; + + /** USER_INFO as 'userInfo'. */ + protected UserInfo _parentUserInfo; + + /** + * USER_INFO as 'userInfo'. {without lazy-load} + * + * @return The entity of foreign property 'userInfo'. (Nullable: If the + * foreign key does not have 'NotNull' constraint, please check + * null.) + */ + public UserInfo getUserInfo() { + return _parentUserInfo; + } + + /** + * USER_INFO as 'userInfo'. + * + * @param userInfo The entity of foreign property 'userInfo'. (Nullable) + */ + public void setUserInfo(UserInfo userInfo) { + _parentUserInfo = userInfo; + } + + //========================================================================== + // ========= + // Referrer Property + // ================= + + //========================================================================== + // ========= + // Determination + // ============= + public boolean hasPrimaryKeyValue() { + if (_id == null) { + return false; + } + return true; + } + + //========================================================================== + // ========= + // Modified Properties + // =================== + public Set<String> getModifiedPropertyNames() { + return _modifiedProperties.getPropertyNames(); + } + + protected EntityModifiedProperties newEntityModifiedProperties() { + return new EntityModifiedProperties(); + } + + public void clearModifiedPropertyNames() { + _modifiedProperties.clear(); + } + + public boolean hasModification() { + return !_modifiedProperties.isEmpty(); + } + + //========================================================================== + // ========= + // Basic Override + // ============== + /** + * If the primary-key of the other is same as this one, returns true. + * + * @param other Other entity. + * @return Comparing result. + */ + public boolean equals(Object other) { + if (other == null || !(other instanceof BsGroupMapping)) { + return false; + } + BsGroupMapping otherEntity = (BsGroupMapping) other; + if (!helpComparingValue(getId(), otherEntity.getId())) { + return false; + } + return true; + } + + protected boolean helpComparingValue(Object value1, Object value2) { + if (value1 == null && value2 == null) { + return true; + } + return value1 != null && value2 != null && value1.equals(value2); + } + + /** + * Calculates hash-code from primary-key. + * + * @return Hash-code from primary-keys. + */ + public int hashCode() { + int result = 17; + if (this.getId() != null) { + result = result + getId().hashCode(); + } + return result; + } + + /** + * @return The view string of columns. (NotNull) + */ + public String toString() { + String delimiter = ","; + StringBuilder sb = new StringBuilder(); + sb.append(delimiter).append(getId()); + sb.append(delimiter).append(getUserId()); + sb.append(delimiter).append(getGroupId()); + if (sb.length() > 0) { + sb.delete(0, delimiter.length()); + } + sb.insert(0, "{").append("}"); + return sb.toString(); + } + + //========================================================================== + // ========= + // Accessor + // ======== + + /** The column annotation for S2Dao. {PK : ID : NotNull : INTEGER} */ + public static final String id_COLUMN = "ID"; + + /** + * ID: {PK : ID : NotNull : INTEGER} <br /> + * + * @return The value of the column 'ID'. (Nullable) + */ + public Integer getId() { + return _id; + } + + /** + * ID: {PK : ID : NotNull : INTEGER} <br /> + * + * @param id The value of the column 'ID'. (Nullable) + */ + public void setId(Integer id) { + _modifiedProperties.addPropertyName("id"); + this._id = id; + } + + /** + * The column annotation for S2Dao. {NotNull : VARCHAR(255) : FK to + * USER_INFO} + */ + public static final String userId_COLUMN = "USER_ID"; + + /** + * USER_ID: {NotNull : VARCHAR(255) : FK to USER_INFO} <br /> + * + * @return The value of the column 'USER_ID'. (Nullable) + */ + public String getUserId() { + return _userId; + } + + /** + * USER_ID: {NotNull : VARCHAR(255) : FK to USER_INFO} <br /> + * + * @param userId The value of the column 'USER_ID'. (Nullable) + */ + public void setUserId(String userId) { + _modifiedProperties.addPropertyName("userId"); + this._userId = userId; + } + + /** + * The column annotation for S2Dao. {NotNull : VARCHAR(255) : FK to + * GROUP_INFO} + */ + public static final String groupId_COLUMN = "GROUP_ID"; + + /** + * GROUP_ID: {NotNull : VARCHAR(255) : FK to GROUP_INFO} <br /> + * + * @return The value of the column 'GROUP_ID'. (Nullable) + */ + public String getGroupId() { + return _groupId; + } + + /** + * GROUP_ID: {NotNull : VARCHAR(255) : FK to GROUP_INFO} <br /> + * + * @param groupId The value of the column 'GROUP_ID'. (Nullable) + */ + public void setGroupId(String groupId) { + _modifiedProperties.addPropertyName("groupId"); + this._groupId = groupId; + } + +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsGroupMapping.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleInfo.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleInfo.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleInfo.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -7,6 +7,7 @@ import jp.sf.pal.userinfo.db.allcommon.Entity; import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMetaInstanceHandler; +import jp.sf.pal.userinfo.db.exentity.RoleMapping; import jp.sf.pal.userinfo.db.exentity.UserInfo; /** @@ -32,13 +33,13 @@ * * * [referrer-table] - * USER_INFO + * ROLE_MAPPING, USER_INFO * * [foreign-property] * * * [referrer-property] - * userInfoList + * roleMappingList, userInfoList * </pre> * * @author DBFlute(AutoGenerator) @@ -159,6 +160,36 @@ // Referrer Property // ================= // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + // Referrer Property = [roleMappingList] + // * * * * * * * * */ + /** ROLE_MAPPING as 'roleMappingList'. */ + protected List<RoleMapping> _childrenRoleMappingList; + + /** + * ROLE_MAPPING as 'roleMappingList'. {without lazy-load} <br /> + * + * @return The entity list of referrer property 'roleMappingList'. (NotNull: + * If it's not loaded yet, initializes the list instance of referrer + * as empty and returns it.) + */ + public List<RoleMapping> getRoleMappingList() { + if (_childrenRoleMappingList == null) { + _childrenRoleMappingList = new ArrayList<RoleMapping>(); + } + return _childrenRoleMappingList; + } + + /** + * ROLE_MAPPING as 'roleMappingList'. + * + * @param roleMappingList The entity list of referrer property + * 'roleMappingList'. (Nullable) + */ + public void setRoleMappingList(List<RoleMapping> roleMappingList) { + _childrenRoleMappingList = roleMappingList; + } + + // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * // Referrer Property = [userInfoList] // * * * * * * * * */ /** USER_INFO as 'userInfoList'. */ Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleMapping.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleMapping.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleMapping.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,356 @@ +package jp.sf.pal.userinfo.db.bsentity; + +import java.util.Set; + +import jp.sf.pal.userinfo.db.allcommon.Entity; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMetaInstanceHandler; +import jp.sf.pal.userinfo.db.exentity.RoleInfo; +import jp.sf.pal.userinfo.db.exentity.UserInfo; + +/** + * The entity of ROLE_MAPPING that the type is TABLE. <br /> + * + * <pre> + * [primary-key] + * ID + * + * [column] + * ID, USER_ID, ROLE_ID + * + * [sequence] + * + * + * [identity] + * ID + * + * [version-no] + * + * + * [foreign-table] + * ROLE_INFO, USER_INFO + * + * [referrer-table] + * + * + * [foreign-property] + * roleInfo, userInfo + * + * [referrer-property] + * + * </pre> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public abstract class BsRoleMapping implements Entity, java.io.Serializable { + + //========================================================================== + // ========= + // Definition + // ========== + /** Serial version UID. (Default) */ + private static final long serialVersionUID = 1L; + + /** TABLE-Annotation for S2Dao. The value is ROLE_MAPPING. */ + public static final String TABLE = "ROLE_MAPPING"; + + /** ID-Annotation */ + public static final String id_ID = "identity"; + + //========================================================================== + // ========= + // Attribute + // ========= + // ----------------------------------------------------- + // Column + // ------ + /** ID: {PK : ID : NotNull : INTEGER} */ + protected Integer _id; + + /** USER_ID: {NotNull : VARCHAR(255) : FK to USER_INFO} */ + protected String _userId; + + /** ROLE_ID: {NotNull : VARCHAR(255) : FK to ROLE_INFO} */ + protected String _roleId; + + // ----------------------------------------------------- + // Internal + // -------- + /** The attribute of entity modified properties. (for S2Dao) */ + protected EntityModifiedProperties _modifiedProperties = newEntityModifiedProperties(); + + //========================================================================== + // ========= + // Constructor + // =========== + public BsRoleMapping() { + } + + //========================================================================== + // ========= + // Table Name + // ========== + public String getTableDbName() { + return "ROLE_MAPPING"; + } + + public String getTablePropertyName() {// as JavaBeansRule + return "roleMapping"; + } + + //========================================================================== + // ========= + // DBMeta + // ====== + public DBMeta getDBMeta() { + return DBMetaInstanceHandler.findDBMeta(getTableDbName()); + } + + //========================================================================== + // ========= + // Classification Classifying + // ========================== + //========================================================================== + // ========= + // Classification Determination + // ============================ + //========================================================================== + // ========= + // Classification Name/Alias + // ========================= + //========================================================================== + // ========= + // Foreign Property + // ================ + // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + // Foreign Property = [roleInfo] + // * * * * * * * * */ + public static final int roleInfo_RELNO = 0; + + public static final String roleInfo_RELKEYS = "ROLE_ID:ROLE_ID"; + + /** ROLE_INFO as 'roleInfo'. */ + protected RoleInfo _parentRoleInfo; + + /** + * ROLE_INFO as 'roleInfo'. {without lazy-load} + * + * @return The entity of foreign property 'roleInfo'. (Nullable: If the + * foreign key does not have 'NotNull' constraint, please check + * null.) + */ + public RoleInfo getRoleInfo() { + return _parentRoleInfo; + } + + /** + * ROLE_INFO as 'roleInfo'. + * + * @param roleInfo The entity of foreign property 'roleInfo'. (Nullable) + */ + public void setRoleInfo(RoleInfo roleInfo) { + _parentRoleInfo = roleInfo; + } + + // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + // Foreign Property = [userInfo] + // * * * * * * * * */ + public static final int userInfo_RELNO = 1; + + public static final String userInfo_RELKEYS = "USER_ID:USER_ID"; + + /** USER_INFO as 'userInfo'. */ + protected UserInfo _parentUserInfo; + + /** + * USER_INFO as 'userInfo'. {without lazy-load} + * + * @return The entity of foreign property 'userInfo'. (Nullable: If the + * foreign key does not have 'NotNull' constraint, please check + * null.) + */ + public UserInfo getUserInfo() { + return _parentUserInfo; + } + + /** + * USER_INFO as 'userInfo'. + * + * @param userInfo The entity of foreign property 'userInfo'. (Nullable) + */ + public void setUserInfo(UserInfo userInfo) { + _parentUserInfo = userInfo; + } + + //========================================================================== + // ========= + // Referrer Property + // ================= + + //========================================================================== + // ========= + // Determination + // ============= + public boolean hasPrimaryKeyValue() { + if (_id == null) { + return false; + } + return true; + } + + //========================================================================== + // ========= + // Modified Properties + // =================== + public Set<String> getModifiedPropertyNames() { + return _modifiedProperties.getPropertyNames(); + } + + protected EntityModifiedProperties newEntityModifiedProperties() { + return new EntityModifiedProperties(); + } + + public void clearModifiedPropertyNames() { + _modifiedProperties.clear(); + } + + public boolean hasModification() { + return !_modifiedProperties.isEmpty(); + } + + //========================================================================== + // ========= + // Basic Override + // ============== + /** + * If the primary-key of the other is same as this one, returns true. + * + * @param other Other entity. + * @return Comparing result. + */ + public boolean equals(Object other) { + if (other == null || !(other instanceof BsRoleMapping)) { + return false; + } + BsRoleMapping otherEntity = (BsRoleMapping) other; + if (!helpComparingValue(getId(), otherEntity.getId())) { + return false; + } + return true; + } + + protected boolean helpComparingValue(Object value1, Object value2) { + if (value1 == null && value2 == null) { + return true; + } + return value1 != null && value2 != null && value1.equals(value2); + } + + /** + * Calculates hash-code from primary-key. + * + * @return Hash-code from primary-keys. + */ + public int hashCode() { + int result = 17; + if (this.getId() != null) { + result = result + getId().hashCode(); + } + return result; + } + + /** + * @return The view string of columns. (NotNull) + */ + public String toString() { + String delimiter = ","; + StringBuilder sb = new StringBuilder(); + sb.append(delimiter).append(getId()); + sb.append(delimiter).append(getUserId()); + sb.append(delimiter).append(getRoleId()); + if (sb.length() > 0) { + sb.delete(0, delimiter.length()); + } + sb.insert(0, "{").append("}"); + return sb.toString(); + } + + //========================================================================== + // ========= + // Accessor + // ======== + + /** The column annotation for S2Dao. {PK : ID : NotNull : INTEGER} */ + public static final String id_COLUMN = "ID"; + + /** + * ID: {PK : ID : NotNull : INTEGER} <br /> + * + * @return The value of the column 'ID'. (Nullable) + */ + public Integer getId() { + return _id; + } + + /** + * ID: {PK : ID : NotNull : INTEGER} <br /> + * + * @param id The value of the column 'ID'. (Nullable) + */ + public void setId(Integer id) { + _modifiedProperties.addPropertyName("id"); + this._id = id; + } + + /** + * The column annotation for S2Dao. {NotNull : VARCHAR(255) : FK to + * USER_INFO} + */ + public static final String userId_COLUMN = "USER_ID"; + + /** + * USER_ID: {NotNull : VARCHAR(255) : FK to USER_INFO} <br /> + * + * @return The value of the column 'USER_ID'. (Nullable) + */ + public String getUserId() { + return _userId; + } + + /** + * USER_ID: {NotNull : VARCHAR(255) : FK to USER_INFO} <br /> + * + * @param userId The value of the column 'USER_ID'. (Nullable) + */ + public void setUserId(String userId) { + _modifiedProperties.addPropertyName("userId"); + this._userId = userId; + } + + /** + * The column annotation for S2Dao. {NotNull : VARCHAR(255) : FK to + * ROLE_INFO} + */ + public static final String roleId_COLUMN = "ROLE_ID"; + + /** + * ROLE_ID: {NotNull : VARCHAR(255) : FK to ROLE_INFO} <br /> + * + * @return The value of the column 'ROLE_ID'. (Nullable) + */ + public String getRoleId() { + return _roleId; + } + + /** + * ROLE_ID: {NotNull : VARCHAR(255) : FK to ROLE_INFO} <br /> + * + * @param roleId The value of the column 'ROLE_ID'. (Nullable) + */ + public void setRoleId(String roleId) { + _modifiedProperties.addPropertyName("roleId"); + this._roleId = roleId; + } + +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsRoleMapping.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsUserInfo.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsUserInfo.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/BsUserInfo.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -1,12 +1,16 @@ package jp.sf.pal.userinfo.db.bsentity; +import java.util.ArrayList; +import java.util.List; import java.util.Set; import jp.sf.pal.userinfo.db.allcommon.Entity; import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMeta; import jp.sf.pal.userinfo.db.allcommon.dbmeta.DBMetaInstanceHandler; import jp.sf.pal.userinfo.db.exentity.GroupInfo; +import jp.sf.pal.userinfo.db.exentity.GroupMapping; import jp.sf.pal.userinfo.db.exentity.RoleInfo; +import jp.sf.pal.userinfo.db.exentity.RoleMapping; /** * The entity of USER_INFO that the type is TABLE. <br /> @@ -31,13 +35,13 @@ * GROUP_INFO, ROLE_INFO * * [referrer-table] - * + * GROUP_MAPPING, ROLE_MAPPING * * [foreign-property] * groupInfo, roleInfo * * [referrer-property] - * + * groupMappingList, roleMappingList * </pre> * * @author DBFlute(AutoGenerator) @@ -232,7 +236,66 @@ // ========= // Referrer Property // ================= + // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + // Referrer Property = [groupMappingList] + // * * * * * * * * */ + /** GROUP_MAPPING as 'groupMappingList'. */ + protected List<GroupMapping> _childrenGroupMappingList; + /** + * GROUP_MAPPING as 'groupMappingList'. {without lazy-load} <br /> + * + * @return The entity list of referrer property 'groupMappingList'. + * (NotNull: If it's not loaded yet, initializes the list instance + * of referrer as empty and returns it.) + */ + public List<GroupMapping> getGroupMappingList() { + if (_childrenGroupMappingList == null) { + _childrenGroupMappingList = new ArrayList<GroupMapping>(); + } + return _childrenGroupMappingList; + } + + /** + * GROUP_MAPPING as 'groupMappingList'. + * + * @param groupMappingList The entity list of referrer property + * 'groupMappingList'. (Nullable) + */ + public void setGroupMappingList(List<GroupMapping> groupMappingList) { + _childrenGroupMappingList = groupMappingList; + } + + // /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * + // Referrer Property = [roleMappingList] + // * * * * * * * * */ + /** ROLE_MAPPING as 'roleMappingList'. */ + protected List<RoleMapping> _childrenRoleMappingList; + + /** + * ROLE_MAPPING as 'roleMappingList'. {without lazy-load} <br /> + * + * @return The entity list of referrer property 'roleMappingList'. (NotNull: + * If it's not loaded yet, initializes the list instance of referrer + * as empty and returns it.) + */ + public List<RoleMapping> getRoleMappingList() { + if (_childrenRoleMappingList == null) { + _childrenRoleMappingList = new ArrayList<RoleMapping>(); + } + return _childrenRoleMappingList; + } + + /** + * ROLE_MAPPING as 'roleMappingList'. + * + * @param roleMappingList The entity list of referrer property + * 'roleMappingList'. (Nullable) + */ + public void setRoleMappingList(List<RoleMapping> roleMappingList) { + _childrenRoleMappingList = roleMappingList; + } + //========================================================================== // ========= // Determination Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupInfoDbm.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupInfoDbm.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupInfoDbm.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -242,6 +242,13 @@ // ----------------------------------------------------- // Referrer Property // ----------------- + public ReferrerInfo referrerGroupMappingList() { + Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnGroupId(), + GroupMappingDbm.getInstance().columnGroupId()); + return cri("groupMappingList", this, GroupMappingDbm.getInstance(), + map, false); + } + public ReferrerInfo referrerUserInfoList() { Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnGroupId(), UserInfoDbm.getInstance().columnGroupId()); Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupMappingDbm.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupMappingDbm.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupMappingDbm.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,299 @@ +package jp.sf.pal.userinfo.db.bsentity.dbmeta; + +import java.util.List; +import java.util.Map; + +import jp.sf.pal.userinfo.db.allcommon.Entity; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.AbstractDBMeta; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.ColumnInfo; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.ForeignInfo; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.UniqueInfo; +import jp.sf.pal.userinfo.db.exentity.GroupMapping; + +/** + * The DB meta of GROUP_MAPPING. (Singleton) + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class GroupMappingDbm extends AbstractDBMeta { + + private static final GroupMappingDbm _instance = new GroupMappingDbm(); + + private GroupMappingDbm() { + } + + public static GroupMappingDbm getInstance() { + return _instance; + } + + //========================================================================== + // ========= + // Table Info + // ========== + public String getTableDbName() { + return "GROUP_MAPPING"; + } + + public String getTablePropertyName() { + return "groupMapping"; + } + + public String getTableSqlName() { + return "GROUP_MAPPING"; + } + + //========================================================================== + // ========= + // Column Info + // =========== + protected ColumnInfo _columnId = cci("ID", "id", Integer.class, true, null, + null); + + protected ColumnInfo _columnUserId = cci("USER_ID", "userId", String.class, + false, 255, 0); + + protected ColumnInfo _columnGroupId = cci("GROUP_ID", "groupId", + String.class, false, 255, 0); + + public ColumnInfo columnId() { + return _columnId; + } + + public ColumnInfo columnUserId() { + return _columnUserId; + } + + public ColumnInfo columnGroupId() { + return _columnGroupId; + } + + { + initializeColumnInfoList(); + } + + //========================================================================== + // ========= + // Name Map + // ======== + public Map<String, String> getDbNamePropertyNameKeyToLowerMap() { + return createDbNamePropertyNameKeyToLowerMap(); + } + + public Map<String, String> getPropertyNameDbNameKeyToLowerMap() { + return createPropertyNameDbNameKeyToLowerMap(); + } + + protected static Map<String, String> _dbNamePropertyNameKeyToLowerMap; + + protected Map<String, String> createDbNamePropertyNameKeyToLowerMap() { + if (_dbNamePropertyNameKeyToLowerMap == null) { + _dbNamePropertyNameKeyToLowerMap = setupKeyToLowerMap(true); + } + return _dbNamePropertyNameKeyToLowerMap; + } + + protected static Map<String, String> _propertyNameDbNameKeyToLowerMap; + + protected Map<String, String> createPropertyNameDbNameKeyToLowerMap() { + if (_propertyNameDbNameKeyToLowerMap == null) { + _propertyNameDbNameKeyToLowerMap = setupKeyToLowerMap(false); + } + return _propertyNameDbNameKeyToLowerMap; + } + + //========================================================================== + // ========= + // Type Name + // ========= + public String getEntityTypeName() { + return "jp.sf.pal.userinfo.db.exentity.GroupMapping"; + } + + public String getConditionBeanTypeName() { + return "jp.sf.pal.userinfo.db.cbean.bs.GroupMappingCB"; + } + + public String getDaoTypeName() { + return "jp.sf.pal.userinfo.db.exdao.GroupMappingDao"; + } + + public String getBehaviorTypeName() { + return "jp.sf.pal.userinfo.db.exbhv.GroupMappingBhv"; + } + + //========================================================================== + // ========= + // Object Type + // =========== + public Class<GroupMapping> getEntityType() { + return GroupMapping.class; + } + + //========================================================================== + // ========= + // Object Instance + // =============== + public Entity newEntity() { + return newMyEntity(); + } + + public GroupMapping newMyEntity() { + return new GroupMapping(); + } + + //========================================================================== + // ========= + // Unique Info + // =========== + // ----------------------------------------------------- + // Primary Element + // --------------- + public UniqueInfo getPrimaryUniqueInfo() { + return createPrimaryUniqueInfo(columnId()); + } + + public boolean hasPrimaryKey() { + return true; + } + + public boolean hasTwoOrMorePrimaryKeys() { + return false; + } + + //========================================================================== + // ========= + // Relation Info + // ============= + // ----------------------------------------------------- + // Foreign Property + // ---------------- + public ForeignInfo foreignGroupInfo() { + Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnGroupId(), + GroupInfoDbm.getInstance().columnGroupId()); + return cfi("groupInfo", this, GroupInfoDbm.getInstance(), map, 0, false); + } + + public ForeignInfo foreignUserInfo() { + Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnUserId(), + UserInfoDbm.getInstance().columnUserId()); + return cfi("userInfo", this, UserInfoDbm.getInstance(), map, 1, false); + } + + // ----------------------------------------------------- + // Referrer Property + // ----------------- + + //========================================================================== + // ========= + // Various Info + // ============ + + //========================================================================== + // ========= + // Entity Handling + // =============== + // ----------------------------------------------------- + // Accept + // ------ + public void acceptPrimaryKeyMap(Entity entity, + Map<String, ? extends Object> primaryKeyMap) { + doAcceptPrimaryKeyMap((GroupMapping) entity, primaryKeyMap, _epsMap); + } + + public void acceptPrimaryKeyMapString(Entity entity, + String primaryKeyMapString) { + MapStringUtil.acceptPrimaryKeyMapString(primaryKeyMapString, entity); + } + + public void acceptColumnValueMap(Entity entity, + Map<String, ? extends Object> columnValueMap) { + doAcceptColumnValueMap((GroupMapping) entity, columnValueMap, _epsMap); + } + + public void acceptColumnValueMapString(Entity entity, + String columnValueMapString) { + MapStringUtil.acceptColumnValueMapString(columnValueMapString, entity); + } + + // ----------------------------------------------------- + // Extract + // ------- + public String extractPrimaryKeyMapString(Entity entity) { + return MapStringUtil.extractPrimaryKeyMapString(entity); + } + + public String extractPrimaryKeyMapString(Entity entity, String startBrace, + String endBrace, String delimiter, String equal) { + return doExtractPrimaryKeyMapString(entity, startBrace, endBrace, + delimiter, equal); + } + + public String extractColumnValueMapString(Entity entity) { + return MapStringUtil.extractColumnValueMapString(entity); + } + + public String extractColumnValueMapString(Entity entity, String startBrace, + String endBrace, String delimiter, String equal) { + return doExtractColumnValueMapString(entity, startBrace, endBrace, + delimiter, equal); + } + + // ----------------------------------------------------- + // Convert + // ------- + public List<Object> convertToColumnValueList(Entity entity) { + return newArrayList(convertToColumnValueMap(entity).values()); + } + + public Map<String, Object> convertToColumnValueMap(Entity entity) { + return doConvertToColumnValueMap(entity); + } + + public List<String> convertToColumnStringValueList(Entity entity) { + return newArrayList(convertToColumnStringValueMap(entity).values()); + } + + public Map<String, String> convertToColumnStringValueMap(Entity entity) { + return doConvertToColumnStringValueMap(entity); + } + + //========================================================================== + // ========= + // Entity Property Setup + // ===================== + // It's very INTERNAL! + protected Map<String, Eps<GroupMapping>> _epsMap = newHashMap(); + { + setupEps(_epsMap, new EpsId(), columnId()); + setupEps(_epsMap, new EpsUserId(), columnUserId()); + setupEps(_epsMap, new EpsGroupId(), columnGroupId()); + } + + public boolean hasEntityPropertySetupper(String propertyName) { + return _epsMap.containsKey(propertyName); + } + + public void setupEntityProperty(String propertyName, Object entity, + Object value) { + findEps(_epsMap, propertyName).setup((GroupMapping) entity, value); + } + + public static class EpsId implements Eps<GroupMapping> { + public void setup(GroupMapping e, Object v) { + e.setId((Integer) v); + } + } + + public static class EpsUserId implements Eps<GroupMapping> { + public void setup(GroupMapping e, Object v) { + e.setUserId((String) v); + } + } + + public static class EpsGroupId implements Eps<GroupMapping> { + public void setup(GroupMapping e, Object v) { + e.setGroupId((String) v); + } + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/GroupMappingDbm.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleInfoDbm.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleInfoDbm.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleInfoDbm.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -242,6 +242,13 @@ // ----------------------------------------------------- // Referrer Property // ----------------- + public ReferrerInfo referrerRoleMappingList() { + Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnRoleId(), + RoleMappingDbm.getInstance().columnRoleId()); + return cri("roleMappingList", this, RoleMappingDbm.getInstance(), map, + false); + } + public ReferrerInfo referrerUserInfoList() { Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnRoleId(), UserInfoDbm.getInstance().columnRoleId()); Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleMappingDbm.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleMappingDbm.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleMappingDbm.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,299 @@ +package jp.sf.pal.userinfo.db.bsentity.dbmeta; + +import java.util.List; +import java.util.Map; + +import jp.sf.pal.userinfo.db.allcommon.Entity; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.AbstractDBMeta; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.ColumnInfo; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.ForeignInfo; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.UniqueInfo; +import jp.sf.pal.userinfo.db.exentity.RoleMapping; + +/** + * The DB meta of ROLE_MAPPING. (Singleton) + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class RoleMappingDbm extends AbstractDBMeta { + + private static final RoleMappingDbm _instance = new RoleMappingDbm(); + + private RoleMappingDbm() { + } + + public static RoleMappingDbm getInstance() { + return _instance; + } + + //========================================================================== + // ========= + // Table Info + // ========== + public String getTableDbName() { + return "ROLE_MAPPING"; + } + + public String getTablePropertyName() { + return "roleMapping"; + } + + public String getTableSqlName() { + return "ROLE_MAPPING"; + } + + //========================================================================== + // ========= + // Column Info + // =========== + protected ColumnInfo _columnId = cci("ID", "id", Integer.class, true, null, + null); + + protected ColumnInfo _columnUserId = cci("USER_ID", "userId", String.class, + false, 255, 0); + + protected ColumnInfo _columnRoleId = cci("ROLE_ID", "roleId", String.class, + false, 255, 0); + + public ColumnInfo columnId() { + return _columnId; + } + + public ColumnInfo columnUserId() { + return _columnUserId; + } + + public ColumnInfo columnRoleId() { + return _columnRoleId; + } + + { + initializeColumnInfoList(); + } + + //========================================================================== + // ========= + // Name Map + // ======== + public Map<String, String> getDbNamePropertyNameKeyToLowerMap() { + return createDbNamePropertyNameKeyToLowerMap(); + } + + public Map<String, String> getPropertyNameDbNameKeyToLowerMap() { + return createPropertyNameDbNameKeyToLowerMap(); + } + + protected static Map<String, String> _dbNamePropertyNameKeyToLowerMap; + + protected Map<String, String> createDbNamePropertyNameKeyToLowerMap() { + if (_dbNamePropertyNameKeyToLowerMap == null) { + _dbNamePropertyNameKeyToLowerMap = setupKeyToLowerMap(true); + } + return _dbNamePropertyNameKeyToLowerMap; + } + + protected static Map<String, String> _propertyNameDbNameKeyToLowerMap; + + protected Map<String, String> createPropertyNameDbNameKeyToLowerMap() { + if (_propertyNameDbNameKeyToLowerMap == null) { + _propertyNameDbNameKeyToLowerMap = setupKeyToLowerMap(false); + } + return _propertyNameDbNameKeyToLowerMap; + } + + //========================================================================== + // ========= + // Type Name + // ========= + public String getEntityTypeName() { + return "jp.sf.pal.userinfo.db.exentity.RoleMapping"; + } + + public String getConditionBeanTypeName() { + return "jp.sf.pal.userinfo.db.cbean.bs.RoleMappingCB"; + } + + public String getDaoTypeName() { + return "jp.sf.pal.userinfo.db.exdao.RoleMappingDao"; + } + + public String getBehaviorTypeName() { + return "jp.sf.pal.userinfo.db.exbhv.RoleMappingBhv"; + } + + //========================================================================== + // ========= + // Object Type + // =========== + public Class<RoleMapping> getEntityType() { + return RoleMapping.class; + } + + //========================================================================== + // ========= + // Object Instance + // =============== + public Entity newEntity() { + return newMyEntity(); + } + + public RoleMapping newMyEntity() { + return new RoleMapping(); + } + + //========================================================================== + // ========= + // Unique Info + // =========== + // ----------------------------------------------------- + // Primary Element + // --------------- + public UniqueInfo getPrimaryUniqueInfo() { + return createPrimaryUniqueInfo(columnId()); + } + + public boolean hasPrimaryKey() { + return true; + } + + public boolean hasTwoOrMorePrimaryKeys() { + return false; + } + + //========================================================================== + // ========= + // Relation Info + // ============= + // ----------------------------------------------------- + // Foreign Property + // ---------------- + public ForeignInfo foreignRoleInfo() { + Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnRoleId(), + RoleInfoDbm.getInstance().columnRoleId()); + return cfi("roleInfo", this, RoleInfoDbm.getInstance(), map, 0, false); + } + + public ForeignInfo foreignUserInfo() { + Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnUserId(), + UserInfoDbm.getInstance().columnUserId()); + return cfi("userInfo", this, UserInfoDbm.getInstance(), map, 1, false); + } + + // ----------------------------------------------------- + // Referrer Property + // ----------------- + + //========================================================================== + // ========= + // Various Info + // ============ + + //========================================================================== + // ========= + // Entity Handling + // =============== + // ----------------------------------------------------- + // Accept + // ------ + public void acceptPrimaryKeyMap(Entity entity, + Map<String, ? extends Object> primaryKeyMap) { + doAcceptPrimaryKeyMap((RoleMapping) entity, primaryKeyMap, _epsMap); + } + + public void acceptPrimaryKeyMapString(Entity entity, + String primaryKeyMapString) { + MapStringUtil.acceptPrimaryKeyMapString(primaryKeyMapString, entity); + } + + public void acceptColumnValueMap(Entity entity, + Map<String, ? extends Object> columnValueMap) { + doAcceptColumnValueMap((RoleMapping) entity, columnValueMap, _epsMap); + } + + public void acceptColumnValueMapString(Entity entity, + String columnValueMapString) { + MapStringUtil.acceptColumnValueMapString(columnValueMapString, entity); + } + + // ----------------------------------------------------- + // Extract + // ------- + public String extractPrimaryKeyMapString(Entity entity) { + return MapStringUtil.extractPrimaryKeyMapString(entity); + } + + public String extractPrimaryKeyMapString(Entity entity, String startBrace, + String endBrace, String delimiter, String equal) { + return doExtractPrimaryKeyMapString(entity, startBrace, endBrace, + delimiter, equal); + } + + public String extractColumnValueMapString(Entity entity) { + return MapStringUtil.extractColumnValueMapString(entity); + } + + public String extractColumnValueMapString(Entity entity, String startBrace, + String endBrace, String delimiter, String equal) { + return doExtractColumnValueMapString(entity, startBrace, endBrace, + delimiter, equal); + } + + // ----------------------------------------------------- + // Convert + // ------- + public List<Object> convertToColumnValueList(Entity entity) { + return newArrayList(convertToColumnValueMap(entity).values()); + } + + public Map<String, Object> convertToColumnValueMap(Entity entity) { + return doConvertToColumnValueMap(entity); + } + + public List<String> convertToColumnStringValueList(Entity entity) { + return newArrayList(convertToColumnStringValueMap(entity).values()); + } + + public Map<String, String> convertToColumnStringValueMap(Entity entity) { + return doConvertToColumnStringValueMap(entity); + } + + //========================================================================== + // ========= + // Entity Property Setup + // ===================== + // It's very INTERNAL! + protected Map<String, Eps<RoleMapping>> _epsMap = newHashMap(); + { + setupEps(_epsMap, new EpsId(), columnId()); + setupEps(_epsMap, new EpsUserId(), columnUserId()); + setupEps(_epsMap, new EpsRoleId(), columnRoleId()); + } + + public boolean hasEntityPropertySetupper(String propertyName) { + return _epsMap.containsKey(propertyName); + } + + public void setupEntityProperty(String propertyName, Object entity, + Object value) { + findEps(_epsMap, propertyName).setup((RoleMapping) entity, value); + } + + public static class EpsId implements Eps<RoleMapping> { + public void setup(RoleMapping e, Object v) { + e.setId((Integer) v); + } + } + + public static class EpsUserId implements Eps<RoleMapping> { + public void setup(RoleMapping e, Object v) { + e.setUserId((String) v); + } + } + + public static class EpsRoleId implements Eps<RoleMapping> { + public void setup(RoleMapping e, Object v) { + e.setRoleId((String) v); + } + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/RoleMappingDbm.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/UserInfoDbm.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/UserInfoDbm.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/bsentity/dbmeta/UserInfoDbm.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -7,6 +7,7 @@ import jp.sf.pal.userinfo.db.allcommon.dbmeta.AbstractDBMeta; import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.ColumnInfo; import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.ForeignInfo; +import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.ReferrerInfo; import jp.sf.pal.userinfo.db.allcommon.dbmeta.info.UniqueInfo; import jp.sf.pal.userinfo.db.exentity.UserInfo; @@ -288,7 +289,20 @@ // ----------------------------------------------------- // Referrer Property // ----------------- + public ReferrerInfo referrerGroupMappingList() { + Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnUserId(), + GroupMappingDbm.getInstance().columnUserId()); + return cri("groupMappingList", this, GroupMappingDbm.getInstance(), + map, false); + } + public ReferrerInfo referrerRoleMappingList() { + Map<ColumnInfo, ColumnInfo> map = newLinkedHashMap(columnUserId(), + RoleMappingDbm.getInstance().columnUserId()); + return cri("roleMappingList", this, RoleMappingDbm.getInstance(), map, + false); + } + //========================================================================== // ========= // Various Info Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/GroupMappingCB.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/GroupMappingCB.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/GroupMappingCB.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,15 @@ +package jp.sf.pal.userinfo.db.cbean; + +/** + * The condition-bean of GROUP_MAPPING. + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class GroupMappingCB extends + jp.sf.pal.userinfo.db.cbean.bs.BsGroupMappingCB { +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/GroupMappingCB.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/RoleMappingCB.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/RoleMappingCB.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/RoleMappingCB.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,15 @@ +package jp.sf.pal.userinfo.db.cbean; + +/** + * The condition-bean of ROLE_MAPPING. + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class RoleMappingCB extends + jp.sf.pal.userinfo.db.cbean.bs.BsRoleMappingCB { +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/RoleMappingCB.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupInfoCB.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupInfoCB.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupInfoCB.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -8,6 +8,7 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.SubQuery; import jp.sf.pal.userinfo.db.allcommon.cbean.UnionQuery; import jp.sf.pal.userinfo.db.cbean.GroupInfoCB; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; @@ -254,6 +255,19 @@ return "GROUP_INFO"; } + public RAFunction<GroupMappingCB, GroupInfoCQ> derivedGroupMappingList() { + return new RAFunction<GroupMappingCB, GroupInfoCQ>(_baseCB, + _myQyCall.qy(), + new RAQSetupper<GroupMappingCB, GroupInfoCQ>() { + public void setup(String function, + SubQuery<GroupMappingCB> subQuery, + GroupInfoCQ cq, String aliasName) { + cq.xderiveGroupMappingList(function, subQuery, + aliasName); + } + }); + } + public RAFunction<UserInfoCB, GroupInfoCQ> derivedUserInfoList() { return new RAFunction<UserInfoCB, GroupInfoCQ>(_baseCB, _myQyCall .qy(), new RAQSetupper<UserInfoCB, GroupInfoCQ>() { Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupMappingCB.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupMappingCB.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupMappingCB.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,325 @@ +package jp.sf.pal.userinfo.db.cbean.bs; + +import java.util.Map; + +import jp.sf.pal.userinfo.db.allcommon.cbean.AbstractConditionBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.SubQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.UnionQuery; +import jp.sf.pal.userinfo.db.cbean.GroupInfoCB; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; +import jp.sf.pal.userinfo.db.cbean.UserInfoCB; +import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; +import jp.sf.pal.userinfo.db.cbean.nss.GroupInfoNss; +import jp.sf.pal.userinfo.db.cbean.nss.UserInfoNss; + +/** + * The base condition-bean of GROUP_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class BsGroupMappingCB extends AbstractConditionBean { + + //========================================================================== + // ========= + // Attribute + // ========= + protected GroupMappingCQ _conditionQuery; + + //========================================================================== + // ========= + // Table Name + // ========== + public String getTableDbName() { + return "GROUP_MAPPING"; + } + + public String getTableSqlName() { + return "GROUP_MAPPING"; + } + + //========================================================================== + // ========= + // PrimaryKey Map + // ============== + public void acceptPrimaryKeyMap(Map<String, ? extends Object> primaryKeyMap) { + assertPrimaryKeyMap(primaryKeyMap); + { + Object obj = primaryKeyMap.get("ID"); + if (obj instanceof Integer) { + query().setId_Equal((Integer) obj); + } else { + query().setId_Equal(new Integer((String) obj)); + } + } + + } + + //========================================================================== + // ========= + // OrderBy Setting + // =============== + public ConditionBean addOrderBy_PK_Asc() { + query().addOrderBy_Id_Asc(); + return this; + } + + public ConditionBean addOrderBy_PK_Desc() { + query().addOrderBy_Id_Desc(); + return this; + } + + //========================================================================== + // ========= + // Query + // ===== + public GroupMappingCQ query() { + return getConditionQuery(); + } + + public GroupMappingCQ getConditionQuery() { + if (_conditionQuery == null) { + _conditionQuery = new GroupMappingCQ(null, getSqlClause(), + getSqlClause().getLocalTableAliasName(), 0); + } + return _conditionQuery; + } + + public ConditionQuery getConditionQueryAsInterface() { + return getConditionQuery(); + } + + //========================================================================== + // ========= + // Union + // ===== + /** + * Set up 'union'. + * + * <pre> + * cb.query().union(new UnionQuery<GroupMappingCB>() { + * public void query(GroupMappingCB unionCB) { + * unionCB.query().setXxx... + * } + * }); + * </pre> + * + * @param unionQuery The query of 'union'. (NotNull) + */ + public void union(UnionQuery<GroupMappingCB> unionQuery) { + final GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForUnion(); + unionQuery.query(cb); + final GroupMappingCQ cq = cb.query(); + query().xsetUnionQuery(cq); + } + + /** + * Set up 'union all'. + * + * <pre> + * cb.query().unionAll(new UnionQuery<GroupMappingCB>() { + * public void query(GroupMappingCB unionCB) { + * unionCB.query().setXxx... + * } + * }); + * </pre> + * + * @param unionQuery The query of 'union'. (NotNull) + */ + public void unionAll(UnionQuery<GroupMappingCB> unionQuery) { + final GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForUnion(); + unionQuery.query(cb); + final GroupMappingCQ cq = cb.query(); + query().xsetUnionAllQuery(cq); + } + + /** + * @param unionQuery The query of 'union'. (NotNull) + * @deprecated Sorry! Please use union(UnionQuery<GroupMappingCB> + * unionQuery). + */ + public void union(GroupMappingCQ unionQuery) { + query().xsetUnionQuery(unionQuery); + } + + /** + * @param unionQuery The query of 'union'. (NotNull) + * @deprecated Sorry! Please use unionAll(UnionQuery<GroupMappingCB> + * unionQuery). + */ + public void unionAll(GroupMappingCQ unionQuery) { + query().xsetUnionAllQuery(unionQuery); + } + + public boolean hasUnionQueryOrUnionAllQuery() { + return query().hasUnionQueryOrUnionAllQuery(); + } + + //========================================================================== + // ========= + // Setup Select + // ============ + + protected GroupInfoNss _nssGroupInfo; + + public GroupInfoNss getNssGroupInfo() { + if (_nssGroupInfo == null) { + _nssGroupInfo = new GroupInfoNss(null); + } + return _nssGroupInfo; + } + + public GroupInfoNss setupSelect_GroupInfo() { + doSetupSelect(new SsCall() { + public ConditionQuery qf() { + return query().queryGroupInfo(); + } + }); + if (_nssGroupInfo == null || !_nssGroupInfo.hasConditionQuery()) { + _nssGroupInfo = new GroupInfoNss(query().queryGroupInfo()); + } + return _nssGroupInfo; + } + + protected UserInfoNss _nssUserInfo; + + public UserInfoNss getNssUserInfo() { + if (_nssUserInfo == null) { + _nssUserInfo = new UserInfoNss(null); + } + return _nssUserInfo; + } + + public UserInfoNss setupSelect_UserInfo() { + doSetupSelect(new SsCall() { + public ConditionQuery qf() { + return query().queryUserInfo(); + } + }); + if (_nssUserInfo == null || !_nssUserInfo.hasConditionQuery()) { + _nssUserInfo = new UserInfoNss(query().queryUserInfo()); + } + return _nssUserInfo; + } + + // [DBFlute-0.7.4] + //========================================================================== + // ========= + // Specify + // ======= + protected Specification _specification; + + public Specification specify() { + if (_specification == null) { + _specification = new Specification(this, + new SpQyCall<GroupMappingCQ>() { + public boolean has() { + return true; + } + + public GroupMappingCQ qy() { + return query(); + } + }, _forDeriveReferrer); + } + return _specification; + } + + public static class Specification extends + AbstractSpecification<GroupMappingCQ> { + protected SpQyCall<GroupMappingCQ> _myQyCall; + + protected GroupInfoCB.Specification _groupInfo; + + protected UserInfoCB.Specification _userInfo; + + public Specification(ConditionBean baseCB, + SpQyCall<GroupMappingCQ> qyCall, boolean forDeriveReferrer) { + super(baseCB, qyCall, forDeriveReferrer); + _myQyCall = qyCall; + } + + public void columnId() { + doColumn("ID"); + } + + public void columnUserId() { + doColumn("USER_ID"); + } + + public void columnGroupId() { + doColumn("GROUP_ID"); + } + + protected void doSpecifyRequiredColumn() { + columnId();// PK + if (_myQyCall.qy().hasConditionQueryGroupInfo()) { + columnGroupId();// FK + } + if (_myQyCall.qy().hasConditionQueryUserInfo()) { + columnUserId();// FK + } + } + + protected String getTableDbName() { + return "GROUP_MAPPING"; + } + + public GroupInfoCB.Specification specifyGroupInfo() { + assertForeign("groupInfo"); + if (_groupInfo == null) { + _groupInfo = new GroupInfoCB.Specification(_baseCB, + new SpQyCall<GroupInfoCQ>() { + public boolean has() { + return _myQyCall.has() + && _myQyCall.qy() + .hasConditionQueryGroupInfo(); + } + + public GroupInfoCQ qy() { + return _myQyCall.qy().queryGroupInfo(); + } + }, _forDeriveReferrer); + } + return _groupInfo; + } + + public UserInfoCB.Specification specifyUserInfo() { + assertForeign("userInfo"); + if (_userInfo == null) { + _userInfo = new UserInfoCB.Specification(_baseCB, + new SpQyCall<UserInfoCQ>() { + public boolean has() { + return _myQyCall.has() + && _myQyCall.qy() + .hasConditionQueryUserInfo(); + } + + public UserInfoCQ qy() { + return _myQyCall.qy().queryUserInfo(); + } + }, _forDeriveReferrer); + } + return _userInfo; + } + } + + // Very Internal (for Suppressing Warn about 'Not Use Import') + protected String getConditionBeanClassNameInternally() { + return GroupMappingCB.class.getName(); + } + + protected String getConditionQueryClassNameInternally() { + return GroupMappingCQ.class.getName(); + } + + protected String getSubQueryClassNameInternally() { + return SubQuery.class.getName(); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsGroupMappingCB.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleInfoCB.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleInfoCB.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleInfoCB.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -8,6 +8,7 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.SubQuery; import jp.sf.pal.userinfo.db.allcommon.cbean.UnionQuery; import jp.sf.pal.userinfo.db.cbean.RoleInfoCB; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; @@ -253,6 +254,17 @@ return "ROLE_INFO"; } + public RAFunction<RoleMappingCB, RoleInfoCQ> derivedRoleMappingList() { + return new RAFunction<RoleMappingCB, RoleInfoCQ>(_baseCB, _myQyCall + .qy(), new RAQSetupper<RoleMappingCB, RoleInfoCQ>() { + public void setup(String function, + SubQuery<RoleMappingCB> subQuery, RoleInfoCQ cq, + String aliasName) { + cq.xderiveRoleMappingList(function, subQuery, aliasName); + } + }); + } + public RAFunction<UserInfoCB, RoleInfoCQ> derivedUserInfoList() { return new RAFunction<UserInfoCB, RoleInfoCQ>(_baseCB, _myQyCall .qy(), new RAQSetupper<UserInfoCB, RoleInfoCQ>() { Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleMappingCB.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleMappingCB.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleMappingCB.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,325 @@ +package jp.sf.pal.userinfo.db.cbean.bs; + +import java.util.Map; + +import jp.sf.pal.userinfo.db.allcommon.cbean.AbstractConditionBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionBean; +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.SubQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.UnionQuery; +import jp.sf.pal.userinfo.db.cbean.RoleInfoCB; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; +import jp.sf.pal.userinfo.db.cbean.UserInfoCB; +import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; +import jp.sf.pal.userinfo.db.cbean.nss.RoleInfoNss; +import jp.sf.pal.userinfo.db.cbean.nss.UserInfoNss; + +/** + * The base condition-bean of ROLE_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class BsRoleMappingCB extends AbstractConditionBean { + + //========================================================================== + // ========= + // Attribute + // ========= + protected RoleMappingCQ _conditionQuery; + + //========================================================================== + // ========= + // Table Name + // ========== + public String getTableDbName() { + return "ROLE_MAPPING"; + } + + public String getTableSqlName() { + return "ROLE_MAPPING"; + } + + //========================================================================== + // ========= + // PrimaryKey Map + // ============== + public void acceptPrimaryKeyMap(Map<String, ? extends Object> primaryKeyMap) { + assertPrimaryKeyMap(primaryKeyMap); + { + Object obj = primaryKeyMap.get("ID"); + if (obj instanceof Integer) { + query().setId_Equal((Integer) obj); + } else { + query().setId_Equal(new Integer((String) obj)); + } + } + + } + + //========================================================================== + // ========= + // OrderBy Setting + // =============== + public ConditionBean addOrderBy_PK_Asc() { + query().addOrderBy_Id_Asc(); + return this; + } + + public ConditionBean addOrderBy_PK_Desc() { + query().addOrderBy_Id_Desc(); + return this; + } + + //========================================================================== + // ========= + // Query + // ===== + public RoleMappingCQ query() { + return getConditionQuery(); + } + + public RoleMappingCQ getConditionQuery() { + if (_conditionQuery == null) { + _conditionQuery = new RoleMappingCQ(null, getSqlClause(), + getSqlClause().getLocalTableAliasName(), 0); + } + return _conditionQuery; + } + + public ConditionQuery getConditionQueryAsInterface() { + return getConditionQuery(); + } + + //========================================================================== + // ========= + // Union + // ===== + /** + * Set up 'union'. + * + * <pre> + * cb.query().union(new UnionQuery<RoleMappingCB>() { + * public void query(RoleMappingCB unionCB) { + * unionCB.query().setXxx... + * } + * }); + * </pre> + * + * @param unionQuery The query of 'union'. (NotNull) + */ + public void union(UnionQuery<RoleMappingCB> unionQuery) { + final RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForUnion(); + unionQuery.query(cb); + final RoleMappingCQ cq = cb.query(); + query().xsetUnionQuery(cq); + } + + /** + * Set up 'union all'. + * + * <pre> + * cb.query().unionAll(new UnionQuery<RoleMappingCB>() { + * public void query(RoleMappingCB unionCB) { + * unionCB.query().setXxx... + * } + * }); + * </pre> + * + * @param unionQuery The query of 'union'. (NotNull) + */ + public void unionAll(UnionQuery<RoleMappingCB> unionQuery) { + final RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForUnion(); + unionQuery.query(cb); + final RoleMappingCQ cq = cb.query(); + query().xsetUnionAllQuery(cq); + } + + /** + * @param unionQuery The query of 'union'. (NotNull) + * @deprecated Sorry! Please use union(UnionQuery<RoleMappingCB> + * unionQuery). + */ + public void union(RoleMappingCQ unionQuery) { + query().xsetUnionQuery(unionQuery); + } + + /** + * @param unionQuery The query of 'union'. (NotNull) + * @deprecated Sorry! Please use unionAll(UnionQuery<RoleMappingCB> + * unionQuery). + */ + public void unionAll(RoleMappingCQ unionQuery) { + query().xsetUnionAllQuery(unionQuery); + } + + public boolean hasUnionQueryOrUnionAllQuery() { + return query().hasUnionQueryOrUnionAllQuery(); + } + + //========================================================================== + // ========= + // Setup Select + // ============ + + protected RoleInfoNss _nssRoleInfo; + + public RoleInfoNss getNssRoleInfo() { + if (_nssRoleInfo == null) { + _nssRoleInfo = new RoleInfoNss(null); + } + return _nssRoleInfo; + } + + public RoleInfoNss setupSelect_RoleInfo() { + doSetupSelect(new SsCall() { + public ConditionQuery qf() { + return query().queryRoleInfo(); + } + }); + if (_nssRoleInfo == null || !_nssRoleInfo.hasConditionQuery()) { + _nssRoleInfo = new RoleInfoNss(query().queryRoleInfo()); + } + return _nssRoleInfo; + } + + protected UserInfoNss _nssUserInfo; + + public UserInfoNss getNssUserInfo() { + if (_nssUserInfo == null) { + _nssUserInfo = new UserInfoNss(null); + } + return _nssUserInfo; + } + + public UserInfoNss setupSelect_UserInfo() { + doSetupSelect(new SsCall() { + public ConditionQuery qf() { + return query().queryUserInfo(); + } + }); + if (_nssUserInfo == null || !_nssUserInfo.hasConditionQuery()) { + _nssUserInfo = new UserInfoNss(query().queryUserInfo()); + } + return _nssUserInfo; + } + + // [DBFlute-0.7.4] + //========================================================================== + // ========= + // Specify + // ======= + protected Specification _specification; + + public Specification specify() { + if (_specification == null) { + _specification = new Specification(this, + new SpQyCall<RoleMappingCQ>() { + public boolean has() { + return true; + } + + public RoleMappingCQ qy() { + return query(); + } + }, _forDeriveReferrer); + } + return _specification; + } + + public static class Specification extends + AbstractSpecification<RoleMappingCQ> { + protected SpQyCall<RoleMappingCQ> _myQyCall; + + protected RoleInfoCB.Specification _roleInfo; + + protected UserInfoCB.Specification _userInfo; + + public Specification(ConditionBean baseCB, + SpQyCall<RoleMappingCQ> qyCall, boolean forDeriveReferrer) { + super(baseCB, qyCall, forDeriveReferrer); + _myQyCall = qyCall; + } + + public void columnId() { + doColumn("ID"); + } + + public void columnUserId() { + doColumn("USER_ID"); + } + + public void columnRoleId() { + doColumn("ROLE_ID"); + } + + protected void doSpecifyRequiredColumn() { + columnId();// PK + if (_myQyCall.qy().hasConditionQueryRoleInfo()) { + columnRoleId();// FK + } + if (_myQyCall.qy().hasConditionQueryUserInfo()) { + columnUserId();// FK + } + } + + protected String getTableDbName() { + return "ROLE_MAPPING"; + } + + public RoleInfoCB.Specification specifyRoleInfo() { + assertForeign("roleInfo"); + if (_roleInfo == null) { + _roleInfo = new RoleInfoCB.Specification(_baseCB, + new SpQyCall<RoleInfoCQ>() { + public boolean has() { + return _myQyCall.has() + && _myQyCall.qy() + .hasConditionQueryRoleInfo(); + } + + public RoleInfoCQ qy() { + return _myQyCall.qy().queryRoleInfo(); + } + }, _forDeriveReferrer); + } + return _roleInfo; + } + + public UserInfoCB.Specification specifyUserInfo() { + assertForeign("userInfo"); + if (_userInfo == null) { + _userInfo = new UserInfoCB.Specification(_baseCB, + new SpQyCall<UserInfoCQ>() { + public boolean has() { + return _myQyCall.has() + && _myQyCall.qy() + .hasConditionQueryUserInfo(); + } + + public UserInfoCQ qy() { + return _myQyCall.qy().queryUserInfo(); + } + }, _forDeriveReferrer); + } + return _userInfo; + } + } + + // Very Internal (for Suppressing Warn about 'Not Use Import') + protected String getConditionBeanClassNameInternally() { + return RoleMappingCB.class.getName(); + } + + protected String getConditionQueryClassNameInternally() { + return RoleMappingCQ.class.getName(); + } + + protected String getSubQueryClassNameInternally() { + return SubQuery.class.getName(); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsRoleMappingCB.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsUserInfoCB.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsUserInfoCB.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/bs/BsUserInfoCB.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -8,7 +8,9 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.SubQuery; import jp.sf.pal.userinfo.db.allcommon.cbean.UnionQuery; import jp.sf.pal.userinfo.db.cbean.GroupInfoCB; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; import jp.sf.pal.userinfo.db.cbean.RoleInfoCB; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; @@ -367,6 +369,30 @@ } return _roleInfo; } + + public RAFunction<GroupMappingCB, UserInfoCQ> derivedGroupMappingList() { + return new RAFunction<GroupMappingCB, UserInfoCQ>(_baseCB, + _myQyCall.qy(), + new RAQSetupper<GroupMappingCB, UserInfoCQ>() { + public void setup(String function, + SubQuery<GroupMappingCB> subQuery, + UserInfoCQ cq, String aliasName) { + cq.xderiveGroupMappingList(function, subQuery, + aliasName); + } + }); + } + + public RAFunction<RoleMappingCB, UserInfoCQ> derivedRoleMappingList() { + return new RAFunction<RoleMappingCB, UserInfoCQ>(_baseCB, _myQyCall + .qy(), new RAQSetupper<RoleMappingCB, UserInfoCQ>() { + public void setup(String function, + SubQuery<RoleMappingCB> subQuery, UserInfoCQ cq, + String aliasName) { + cq.xderiveRoleMappingList(function, subQuery, aliasName); + } + }); + } } // Very Internal (for Suppressing Warn about 'Not Use Import') Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/GroupMappingCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/GroupMappingCQ.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/GroupMappingCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,45 @@ +package jp.sf.pal.userinfo.db.cbean.cq; + +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; +import jp.sf.pal.userinfo.db.cbean.cq.bs.BsGroupMappingCQ; + +/** + * The condition-query of GROUP_MAPPING. + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class GroupMappingCQ extends BsGroupMappingCQ { + + //========================================================================== + // ========= + // Constructor + // =========== + /** + * Constructor. + * + * @param childQuery Child query as abstract class. (Nullable: If null, this + * is base instance.) + * @param sqlClause SQL clause instance. (NotNull) + * @param aliasName My alias name. (NotNull) + * @param nestLevel Nest level. + */ + public GroupMappingCQ(ConditionQuery childQuery, SqlClause sqlClause, + String aliasName, int nestLevel) { + super(childQuery, sqlClause, aliasName, nestLevel); + } + + //========================================================================== + // ========= + // Arrange Method + // ============== + // You can make original arrange query methods here. + // public void arranegeXxx() { + // ... + // } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/GroupMappingCQ.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/RoleMappingCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/RoleMappingCQ.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/RoleMappingCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,45 @@ +package jp.sf.pal.userinfo.db.cbean.cq; + +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; +import jp.sf.pal.userinfo.db.cbean.cq.bs.BsRoleMappingCQ; + +/** + * The condition-query of ROLE_MAPPING. + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class RoleMappingCQ extends BsRoleMappingCQ { + + //========================================================================== + // ========= + // Constructor + // =========== + /** + * Constructor. + * + * @param childQuery Child query as abstract class. (Nullable: If null, this + * is base instance.) + * @param sqlClause SQL clause instance. (NotNull) + * @param aliasName My alias name. (NotNull) + * @param nestLevel Nest level. + */ + public RoleMappingCQ(ConditionQuery childQuery, SqlClause sqlClause, + String aliasName, int nestLevel) { + super(childQuery, sqlClause, aliasName, nestLevel); + } + + //========================================================================== + // ========= + // Arrange Method + // ============== + // You can make original arrange query methods here. + // public void arranegeXxx() { + // ... + // } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/RoleMappingCQ.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupInfoCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupInfoCQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupInfoCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -9,8 +9,10 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.GroupInfoCB; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; /** @@ -160,6 +162,36 @@ } /** + * @param groupMappingCBquery Query. + * @deprecated Please use inScopeGroupMappingList(subQuery) method. + */ + public void setGroupId_InScopeSubQuery_GroupMappingList( + GroupMappingCQ groupMappingCBquery) { + String subQueryPropertyName = keepGroupId_InScopeSubQuery_GroupMappingList(groupMappingCBquery);// for + // saving + // query + // - + // value + // . + registerInScopeSubQuery(groupMappingCBquery, "GROUP_ID", "GROUP_ID", + subQueryPropertyName); + } + + public void inScopeGroupMappingList(SubQuery<GroupMappingCB> subQuery) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepGroupId_InScopeSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerInScopeSubQuery(cb.query(), "GROUP_ID", "GROUP_ID", + subQueryPropertyName); + } + + abstract public String keepGroupId_InScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + + /** * @param userInfoCBquery Query. * @deprecated Please use inScopeUserInfoList(subQuery) method. */ @@ -189,6 +221,20 @@ abstract public String keepGroupId_InScopeSubQuery_UserInfoList( UserInfoCQ subQuery); + public void notInScopeGroupMappingList(SubQuery<GroupMappingCB> subQuery) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepGroupId_NotInScopeSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerNotInScopeSubQuery(cb.query(), "GROUP_ID", "GROUP_ID", + subQueryPropertyName); + } + + abstract public String keepGroupId_NotInScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + public void notInScopeUserInfoList(SubQuery<UserInfoCB> subQuery) { assertObjectNotNull("subQuery<UserInfoCB>", subQuery); UserInfoCB cb = new UserInfoCB(); @@ -204,6 +250,43 @@ UserInfoCQ subQuery); /** + * @param groupMappingCBquery Query. + * @deprecated Please use existsGroupMappingList(subQuery) method. + */ + public void setGroupId_ExistsSubQuery_GroupMappingList( + GroupMappingCQ groupMappingCBquery) { + String subQueryPropertyName = keepGroupId_ExistsSubQuery_GroupMappingList(groupMappingCBquery);// for + // saving + // query + // - + // value + // . + registerExistsSubQuery(groupMappingCBquery, "GROUP_ID", "GROUP_ID", + subQueryPropertyName); + } + + /** + * Set up 'exists' sub-query. {exists (select GROUP_ID from GROUP_MAPPING + * where ...)} + * + * @param subQuery The sub-query of GroupId_ExistsSubQuery_GroupMappingList + * for 'exists'. (NotNull) + */ + public void existsGroupMappingList(SubQuery<GroupMappingCB> subQuery) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForExistsSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepGroupId_ExistsSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerExistsSubQuery(cb.query(), "GROUP_ID", "GROUP_ID", + subQueryPropertyName); + } + + abstract public String keepGroupId_ExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + + /** * @param userInfoCBquery Query. * @deprecated Please use existsUserInfoList(subQuery) method. */ @@ -242,6 +325,28 @@ /** * Set up 'not exists' sub-query. {not exists (select GROUP_ID from + * GROUP_MAPPING where ...)} + * + * @param subQuery The sub-query of + * GroupId_NotExistsSubQuery_GroupMappingList for 'not exists'. + * (NotNull) + */ + public void notExistsGroupMappingList(SubQuery<GroupMappingCB> subQuery) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForExistsSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepGroupId_NotExistsSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerNotExistsSubQuery(cb.query(), "GROUP_ID", "GROUP_ID", + subQueryPropertyName); + } + + abstract public String keepGroupId_NotExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + + /** + * Set up 'not exists' sub-query. {not exists (select GROUP_ID from * USER_INFO where ...)} * * @param subQuery The sub-query of GroupId_NotExistsSubQuery_UserInfoList @@ -261,6 +366,21 @@ abstract public String keepGroupId_NotExistsSubQuery_UserInfoList( UserInfoCQ subQuery); + public void xderiveGroupMappingList(String function, + SubQuery<GroupMappingCB> subQuery, String aliasName) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForDeriveReferrer(); + subQuery.query(cb); + String subQueryPropertyName = keepGroupId_DeriveSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerDeriveSubQuery(function, cb.query(), "GROUP_ID", "GROUP_ID", + subQueryPropertyName, aliasName); + } + + abstract public String keepGroupId_DeriveSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + public void xderiveUserInfoList(String function, SubQuery<UserInfoCB> subQuery, String aliasName) { assertObjectNotNull("subQuery<UserInfoCB>", subQuery); Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupMappingCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupMappingCQ.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupMappingCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,465 @@ +package jp.sf.pal.userinfo.db.cbean.cq.bs; + +import java.util.Collection; + +import jp.sf.pal.userinfo.db.allcommon.cbean.AbstractConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.SubQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.ckey.ConditionKey; +import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; +import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; +import jp.sf.pal.userinfo.db.cbean.GroupInfoCB; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; +import jp.sf.pal.userinfo.db.cbean.UserInfoCB; +import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; + +/** + * The abstract condition-query of GROUP_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public abstract class AbstractBsGroupMappingCQ extends AbstractConditionQuery { + + //========================================================================== + // ========= + // Constructor + // =========== + public AbstractBsGroupMappingCQ(ConditionQuery childQuery, + SqlClause sqlClause, String aliasName, int nestLevel) { + super(childQuery, sqlClause, aliasName, nestLevel); + } + + //========================================================================== + // ========= + // Table Name + // ========== + public String getTableDbName() { + return "GROUP_MAPPING"; + } + + public String getTableSqlName() { + return "GROUP_MAPPING"; + } + + //========================================================================== + // ========= + // Query + // ===== + + /** + * Equal(=). And NullIgnored, OnceRegistered. {PK : ID : NotNull : INTEGER} + * + * @param id The value of id as equal. + */ + public void setId_Equal(Integer id) { + regId(CK_EQ, id); + } + + /** + * NotEqual(!=). And NullIgnored, OnceRegistered. + * + * @param id The value of id as notEqual. + */ + public void setId_NotEqual(Integer id) { + regId(CK_NE, id); + } + + /** + * GreaterThan(>). And NullIgnored, OnceRegistered. + * + * @param id The value of id as greaterThan. + */ + public void setId_GreaterThan(Integer id) { + regId(CK_GT, id); + } + + /** + * LessThan(<). And NullIgnored, OnceRegistered. + * + * @param id The value of id as lessThan. + */ + public void setId_LessThan(Integer id) { + regId(CK_LT, id); + } + + /** + * GreaterEqual(>=). And NullIgnored, OnceRegistered. + * + * @param id The value of id as greaterEqual. + */ + public void setId_GreaterEqual(Integer id) { + regId(CK_GE, id); + } + + /** + * LessEqual(<=). And NullIgnored, OnceRegistered. + * + * @param id The value of id as lessEqual. + */ + public void setId_LessEqual(Integer id) { + regId(CK_LE, id); + } + + /** + * InScope(in (1, 2)). And NullIgnored, NullElementIgnored, + * SeveralRegistered. + * + * @param idList The collection of id as inScope. + */ + public void setId_InScope(Collection<Integer> idList) { + regId(CK_INS, cTL(idList)); + } + + /** + * NotInScope(not in (1, 2)). And NullIgnored, NullElementIgnored, + * SeveralRegistered. + * + * @param idList The collection of id as notInScope. + */ + public void setId_NotInScope(Collection<Integer> idList) { + regId(CK_NINS, cTL(idList)); + } + + /** + * IsNull(is null). And OnceRegistered. + */ + public void setId_IsNull() { + regId(CK_ISN, DUMMY_OBJECT); + } + + /** + * IsNotNull(is not null). And OnceRegistered. + */ + public void setId_IsNotNull() { + regId(CK_ISNN, DUMMY_OBJECT); + } + + protected void regId(ConditionKey key, Object value) { + registerQuery(key, value, getCValueId(), "ID", "Id", "id"); + } + + protected void registerInlineId(ConditionKey key, Object value) { + registerInlineQuery(key, value, getCValueId(), "ID", "Id", "id"); + } + + abstract protected ConditionValue getCValueId(); + + /** + * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {NotNull : VARCHAR(255) + * : FK to USER_INFO} + * + * @param userId The value of userId as equal. + */ + public void setUserId_Equal(String userId) { + regUserId(CK_EQ, fRES(userId)); + } + + /** + * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as notEqual. + */ + public void setUserId_NotEqual(String userId) { + regUserId(CK_NE, fRES(userId)); + } + + /** + * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as greaterThan. + */ + public void setUserId_GreaterThan(String userId) { + regUserId(CK_GT, fRES(userId)); + } + + /** + * LessThan(<). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as lessThan. + */ + public void setUserId_LessThan(String userId) { + regUserId(CK_LT, fRES(userId)); + } + + /** + * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as greaterEqual. + */ + public void setUserId_GreaterEqual(String userId) { + regUserId(CK_GE, fRES(userId)); + } + + /** + * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as lessEqual. + */ + public void setUserId_LessEqual(String userId) { + regUserId(CK_LE, fRES(userId)); + } + + /** + * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as prefixSearch. + */ + public void setUserId_PrefixSearch(String userId) { + regUserId(CK_PS, fRES(userId)); + } + + /** + * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, + * SeveralRegistered. + * + * @param userId The value of userId as likeSearch. + * @param likeSearchOption The option of like-search. (NotNull) + */ + public void setUserId_LikeSearch( + String userId, + jp.sf.pal.userinfo.db.allcommon.cbean.coption.LikeSearchOption likeSearchOption) { + registerLikeSearchQuery(CK_LS, fRES(userId), getCValueUserId(), + "USER_ID", "UserId", "userId", likeSearchOption); + } + + /** + * InScope(in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param userIdList The collection of userId as inScope. + */ + public void setUserId_InScope(Collection<String> userIdList) { + regUserId(CK_INS, cTL(userIdList)); + } + + /** + * InScope(in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param userId The collection of userId as inScope. + * @param inScopeOption The option of in-scope. (NotNull) + */ + public void setUserId_InScope( + String userId, + jp.sf.pal.userinfo.db.allcommon.cbean.coption.InScopeOption inScopeOption) { + registerInScopeQuery(CK_INS, fRES(userId), getCValueUserId(), + "USER_ID", "UserId", "userId", inScopeOption); + } + + /** + * NotInScope(not in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param userIdList The collection of userId as notInScope. + */ + public void setUserId_NotInScope(Collection<String> userIdList) { + regUserId(CK_NINS, cTL(userIdList)); + } + + /** + * @param userInfoCBquery Query. + * @deprecated Please use inScopeUserInfo(subQuery) method. + */ + public void setUserId_InScopeSubQuery_UserInfo(UserInfoCQ userInfoCBquery) { + String subQueryPropertyName = keepUserId_InScopeSubQuery_UserInfo(userInfoCBquery);// for + // saving + // query + // - + // value + // . + registerInScopeSubQuery(userInfoCBquery, "USER_ID", "USER_ID", + subQueryPropertyName); + } + + public void inScopeUserInfo(SubQuery<UserInfoCB> subQuery) { + assertObjectNotNull("subQuery<UserInfoCB>", subQuery); + UserInfoCB cb = new UserInfoCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_InScopeSubQuery_UserInfo(cb + .query());// for saving query-value. + registerInScopeSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_InScopeSubQuery_UserInfo( + jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ subQuery); + + protected void regUserId(ConditionKey key, Object value) { + registerQuery(key, value, getCValueUserId(), "USER_ID", "UserId", + "userId"); + } + + protected void registerInlineUserId(ConditionKey key, Object value) { + registerInlineQuery(key, value, getCValueUserId(), "USER_ID", "UserId", + "userId"); + } + + abstract protected ConditionValue getCValueUserId(); + + /** + * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {NotNull : VARCHAR(255) + * : FK to GROUP_INFO} + * + * @param groupId The value of groupId as equal. + */ + public void setGroupId_Equal(String groupId) { + regGroupId(CK_EQ, fRES(groupId)); + } + + /** + * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param groupId The value of groupId as notEqual. + */ + public void setGroupId_NotEqual(String groupId) { + regGroupId(CK_NE, fRES(groupId)); + } + + /** + * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered. + * + * @param groupId The value of groupId as greaterThan. + */ + public void setGroupId_GreaterThan(String groupId) { + regGroupId(CK_GT, fRES(groupId)); + } + + /** + * LessThan(<). And NullOrEmptyIgnored, OnceRegistered. + * + * @param groupId The value of groupId as lessThan. + */ + public void setGroupId_LessThan(String groupId) { + regGroupId(CK_LT, fRES(groupId)); + } + + /** + * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param groupId The value of groupId as greaterEqual. + */ + public void setGroupId_GreaterEqual(String groupId) { + regGroupId(CK_GE, fRES(groupId)); + } + + /** + * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param groupId The value of groupId as lessEqual. + */ + public void setGroupId_LessEqual(String groupId) { + regGroupId(CK_LE, fRES(groupId)); + } + + /** + * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered. + * + * @param groupId The value of groupId as prefixSearch. + */ + public void setGroupId_PrefixSearch(String groupId) { + regGroupId(CK_PS, fRES(groupId)); + } + + /** + * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, + * SeveralRegistered. + * + * @param groupId The value of groupId as likeSearch. + * @param likeSearchOption The option of like-search. (NotNull) + */ + public void setGroupId_LikeSearch( + String groupId, + jp.sf.pal.userinfo.db.allcommon.cbean.coption.LikeSearchOption likeSearchOption) { + registerLikeSearchQuery(CK_LS, fRES(groupId), getCValueGroupId(), + "GROUP_ID", "GroupId", "groupId", likeSearchOption); + } + + /** + * InScope(in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param groupIdList The collection of groupId as inScope. + */ + public void setGroupId_InScope(Collection<String> groupIdList) { + regGroupId(CK_INS, cTL(groupIdList)); + } + + /** + * InScope(in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param groupId The collection of groupId as inScope. + * @param inScopeOption The option of in-scope. (NotNull) + */ + public void setGroupId_InScope( + String groupId, + jp.sf.pal.userinfo.db.allcommon.cbean.coption.InScopeOption inScopeOption) { + registerInScopeQuery(CK_INS, fRES(groupId), getCValueGroupId(), + "GROUP_ID", "GroupId", "groupId", inScopeOption); + } + + /** + * NotInScope(not in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param groupIdList The collection of groupId as notInScope. + */ + public void setGroupId_NotInScope(Collection<String> groupIdList) { + regGroupId(CK_NINS, cTL(groupIdList)); + } + + /** + * @param groupInfoCBquery Query. + * @deprecated Please use inScopeGroupInfo(subQuery) method. + */ + public void setGroupId_InScopeSubQuery_GroupInfo( + GroupInfoCQ groupInfoCBquery) { + String subQueryPropertyName = keepGroupId_InScopeSubQuery_GroupInfo(groupInfoCBquery);// for + // saving + // query + // - + // value + // . + registerInScopeSubQuery(groupInfoCBquery, "GROUP_ID", "GROUP_ID", + subQueryPropertyName); + } + + public void inScopeGroupInfo(SubQuery<GroupInfoCB> subQuery) { + assertObjectNotNull("subQuery<GroupInfoCB>", subQuery); + GroupInfoCB cb = new GroupInfoCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepGroupId_InScopeSubQuery_GroupInfo(cb + .query());// for saving query-value. + registerInScopeSubQuery(cb.query(), "GROUP_ID", "GROUP_ID", + subQueryPropertyName); + } + + abstract public String keepGroupId_InScopeSubQuery_GroupInfo( + jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ subQuery); + + protected void regGroupId(ConditionKey key, Object value) { + registerQuery(key, value, getCValueGroupId(), "GROUP_ID", "GroupId", + "groupId"); + } + + protected void registerInlineGroupId(ConditionKey key, Object value) { + registerInlineQuery(key, value, getCValueGroupId(), "GROUP_ID", + "GroupId", "groupId"); + } + + abstract protected ConditionValue getCValueGroupId(); + + // Very Internal (for Suppressing Warn about 'Not Use Import') + protected String getConditionBeanClassNameInternally() { + return GroupMappingCB.class.getName(); + } + + protected String getConditionQueryClassNameInternally() { + return GroupMappingCQ.class.getName(); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsGroupMappingCQ.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleInfoCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleInfoCQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleInfoCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -9,8 +9,10 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.RoleInfoCB; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; /** @@ -160,6 +162,36 @@ } /** + * @param roleMappingCBquery Query. + * @deprecated Please use inScopeRoleMappingList(subQuery) method. + */ + public void setRoleId_InScopeSubQuery_RoleMappingList( + RoleMappingCQ roleMappingCBquery) { + String subQueryPropertyName = keepRoleId_InScopeSubQuery_RoleMappingList(roleMappingCBquery);// for + // saving + // query + // - + // value + // . + registerInScopeSubQuery(roleMappingCBquery, "ROLE_ID", "ROLE_ID", + subQueryPropertyName); + } + + public void inScopeRoleMappingList(SubQuery<RoleMappingCB> subQuery) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepRoleId_InScopeSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerInScopeSubQuery(cb.query(), "ROLE_ID", "ROLE_ID", + subQueryPropertyName); + } + + abstract public String keepRoleId_InScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + + /** * @param userInfoCBquery Query. * @deprecated Please use inScopeUserInfoList(subQuery) method. */ @@ -189,6 +221,20 @@ abstract public String keepRoleId_InScopeSubQuery_UserInfoList( UserInfoCQ subQuery); + public void notInScopeRoleMappingList(SubQuery<RoleMappingCB> subQuery) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepRoleId_NotInScopeSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerNotInScopeSubQuery(cb.query(), "ROLE_ID", "ROLE_ID", + subQueryPropertyName); + } + + abstract public String keepRoleId_NotInScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + public void notInScopeUserInfoList(SubQuery<UserInfoCB> subQuery) { assertObjectNotNull("subQuery<UserInfoCB>", subQuery); UserInfoCB cb = new UserInfoCB(); @@ -204,6 +250,43 @@ UserInfoCQ subQuery); /** + * @param roleMappingCBquery Query. + * @deprecated Please use existsRoleMappingList(subQuery) method. + */ + public void setRoleId_ExistsSubQuery_RoleMappingList( + RoleMappingCQ roleMappingCBquery) { + String subQueryPropertyName = keepRoleId_ExistsSubQuery_RoleMappingList(roleMappingCBquery);// for + // saving + // query + // - + // value + // . + registerExistsSubQuery(roleMappingCBquery, "ROLE_ID", "ROLE_ID", + subQueryPropertyName); + } + + /** + * Set up 'exists' sub-query. {exists (select ROLE_ID from ROLE_MAPPING + * where ...)} + * + * @param subQuery The sub-query of RoleId_ExistsSubQuery_RoleMappingList + * for 'exists'. (NotNull) + */ + public void existsRoleMappingList(SubQuery<RoleMappingCB> subQuery) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForExistsSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepRoleId_ExistsSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerExistsSubQuery(cb.query(), "ROLE_ID", "ROLE_ID", + subQueryPropertyName); + } + + abstract public String keepRoleId_ExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + + /** * @param userInfoCBquery Query. * @deprecated Please use existsUserInfoList(subQuery) method. */ @@ -240,6 +323,27 @@ UserInfoCQ subQuery); /** + * Set up 'not exists' sub-query. {not exists (select ROLE_ID from + * ROLE_MAPPING where ...)} + * + * @param subQuery The sub-query of RoleId_NotExistsSubQuery_RoleMappingList + * for 'not exists'. (NotNull) + */ + public void notExistsRoleMappingList(SubQuery<RoleMappingCB> subQuery) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForExistsSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepRoleId_NotExistsSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerNotExistsSubQuery(cb.query(), "ROLE_ID", "ROLE_ID", + subQueryPropertyName); + } + + abstract public String keepRoleId_NotExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + + /** * Set up 'not exists' sub-query. {not exists (select ROLE_ID from USER_INFO * where ...)} * @@ -260,6 +364,21 @@ abstract public String keepRoleId_NotExistsSubQuery_UserInfoList( UserInfoCQ subQuery); + public void xderiveRoleMappingList(String function, + SubQuery<RoleMappingCB> subQuery, String aliasName) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForDeriveReferrer(); + subQuery.query(cb); + String subQueryPropertyName = keepRoleId_DeriveSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerDeriveSubQuery(function, cb.query(), "ROLE_ID", "ROLE_ID", + subQueryPropertyName, aliasName); + } + + abstract public String keepRoleId_DeriveSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + public void xderiveUserInfoList(String function, SubQuery<UserInfoCB> subQuery, String aliasName) { assertObjectNotNull("subQuery<UserInfoCB>", subQuery); Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleMappingCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleMappingCQ.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleMappingCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,464 @@ +package jp.sf.pal.userinfo.db.cbean.cq.bs; + +import java.util.Collection; + +import jp.sf.pal.userinfo.db.allcommon.cbean.AbstractConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.SubQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.ckey.ConditionKey; +import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; +import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; +import jp.sf.pal.userinfo.db.cbean.RoleInfoCB; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; +import jp.sf.pal.userinfo.db.cbean.UserInfoCB; +import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; + +/** + * The abstract condition-query of ROLE_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public abstract class AbstractBsRoleMappingCQ extends AbstractConditionQuery { + + //========================================================================== + // ========= + // Constructor + // =========== + public AbstractBsRoleMappingCQ(ConditionQuery childQuery, + SqlClause sqlClause, String aliasName, int nestLevel) { + super(childQuery, sqlClause, aliasName, nestLevel); + } + + //========================================================================== + // ========= + // Table Name + // ========== + public String getTableDbName() { + return "ROLE_MAPPING"; + } + + public String getTableSqlName() { + return "ROLE_MAPPING"; + } + + //========================================================================== + // ========= + // Query + // ===== + + /** + * Equal(=). And NullIgnored, OnceRegistered. {PK : ID : NotNull : INTEGER} + * + * @param id The value of id as equal. + */ + public void setId_Equal(Integer id) { + regId(CK_EQ, id); + } + + /** + * NotEqual(!=). And NullIgnored, OnceRegistered. + * + * @param id The value of id as notEqual. + */ + public void setId_NotEqual(Integer id) { + regId(CK_NE, id); + } + + /** + * GreaterThan(>). And NullIgnored, OnceRegistered. + * + * @param id The value of id as greaterThan. + */ + public void setId_GreaterThan(Integer id) { + regId(CK_GT, id); + } + + /** + * LessThan(<). And NullIgnored, OnceRegistered. + * + * @param id The value of id as lessThan. + */ + public void setId_LessThan(Integer id) { + regId(CK_LT, id); + } + + /** + * GreaterEqual(>=). And NullIgnored, OnceRegistered. + * + * @param id The value of id as greaterEqual. + */ + public void setId_GreaterEqual(Integer id) { + regId(CK_GE, id); + } + + /** + * LessEqual(<=). And NullIgnored, OnceRegistered. + * + * @param id The value of id as lessEqual. + */ + public void setId_LessEqual(Integer id) { + regId(CK_LE, id); + } + + /** + * InScope(in (1, 2)). And NullIgnored, NullElementIgnored, + * SeveralRegistered. + * + * @param idList The collection of id as inScope. + */ + public void setId_InScope(Collection<Integer> idList) { + regId(CK_INS, cTL(idList)); + } + + /** + * NotInScope(not in (1, 2)). And NullIgnored, NullElementIgnored, + * SeveralRegistered. + * + * @param idList The collection of id as notInScope. + */ + public void setId_NotInScope(Collection<Integer> idList) { + regId(CK_NINS, cTL(idList)); + } + + /** + * IsNull(is null). And OnceRegistered. + */ + public void setId_IsNull() { + regId(CK_ISN, DUMMY_OBJECT); + } + + /** + * IsNotNull(is not null). And OnceRegistered. + */ + public void setId_IsNotNull() { + regId(CK_ISNN, DUMMY_OBJECT); + } + + protected void regId(ConditionKey key, Object value) { + registerQuery(key, value, getCValueId(), "ID", "Id", "id"); + } + + protected void registerInlineId(ConditionKey key, Object value) { + registerInlineQuery(key, value, getCValueId(), "ID", "Id", "id"); + } + + abstract protected ConditionValue getCValueId(); + + /** + * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {NotNull : VARCHAR(255) + * : FK to USER_INFO} + * + * @param userId The value of userId as equal. + */ + public void setUserId_Equal(String userId) { + regUserId(CK_EQ, fRES(userId)); + } + + /** + * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as notEqual. + */ + public void setUserId_NotEqual(String userId) { + regUserId(CK_NE, fRES(userId)); + } + + /** + * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as greaterThan. + */ + public void setUserId_GreaterThan(String userId) { + regUserId(CK_GT, fRES(userId)); + } + + /** + * LessThan(<). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as lessThan. + */ + public void setUserId_LessThan(String userId) { + regUserId(CK_LT, fRES(userId)); + } + + /** + * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as greaterEqual. + */ + public void setUserId_GreaterEqual(String userId) { + regUserId(CK_GE, fRES(userId)); + } + + /** + * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as lessEqual. + */ + public void setUserId_LessEqual(String userId) { + regUserId(CK_LE, fRES(userId)); + } + + /** + * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered. + * + * @param userId The value of userId as prefixSearch. + */ + public void setUserId_PrefixSearch(String userId) { + regUserId(CK_PS, fRES(userId)); + } + + /** + * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, + * SeveralRegistered. + * + * @param userId The value of userId as likeSearch. + * @param likeSearchOption The option of like-search. (NotNull) + */ + public void setUserId_LikeSearch( + String userId, + jp.sf.pal.userinfo.db.allcommon.cbean.coption.LikeSearchOption likeSearchOption) { + registerLikeSearchQuery(CK_LS, fRES(userId), getCValueUserId(), + "USER_ID", "UserId", "userId", likeSearchOption); + } + + /** + * InScope(in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param userIdList The collection of userId as inScope. + */ + public void setUserId_InScope(Collection<String> userIdList) { + regUserId(CK_INS, cTL(userIdList)); + } + + /** + * InScope(in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param userId The collection of userId as inScope. + * @param inScopeOption The option of in-scope. (NotNull) + */ + public void setUserId_InScope( + String userId, + jp.sf.pal.userinfo.db.allcommon.cbean.coption.InScopeOption inScopeOption) { + registerInScopeQuery(CK_INS, fRES(userId), getCValueUserId(), + "USER_ID", "UserId", "userId", inScopeOption); + } + + /** + * NotInScope(not in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param userIdList The collection of userId as notInScope. + */ + public void setUserId_NotInScope(Collection<String> userIdList) { + regUserId(CK_NINS, cTL(userIdList)); + } + + /** + * @param userInfoCBquery Query. + * @deprecated Please use inScopeUserInfo(subQuery) method. + */ + public void setUserId_InScopeSubQuery_UserInfo(UserInfoCQ userInfoCBquery) { + String subQueryPropertyName = keepUserId_InScopeSubQuery_UserInfo(userInfoCBquery);// for + // saving + // query + // - + // value + // . + registerInScopeSubQuery(userInfoCBquery, "USER_ID", "USER_ID", + subQueryPropertyName); + } + + public void inScopeUserInfo(SubQuery<UserInfoCB> subQuery) { + assertObjectNotNull("subQuery<UserInfoCB>", subQuery); + UserInfoCB cb = new UserInfoCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_InScopeSubQuery_UserInfo(cb + .query());// for saving query-value. + registerInScopeSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_InScopeSubQuery_UserInfo( + jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ subQuery); + + protected void regUserId(ConditionKey key, Object value) { + registerQuery(key, value, getCValueUserId(), "USER_ID", "UserId", + "userId"); + } + + protected void registerInlineUserId(ConditionKey key, Object value) { + registerInlineQuery(key, value, getCValueUserId(), "USER_ID", "UserId", + "userId"); + } + + abstract protected ConditionValue getCValueUserId(); + + /** + * Equal(=). And NullOrEmptyIgnored, OnceRegistered. {NotNull : VARCHAR(255) + * : FK to ROLE_INFO} + * + * @param roleId The value of roleId as equal. + */ + public void setRoleId_Equal(String roleId) { + regRoleId(CK_EQ, fRES(roleId)); + } + + /** + * NotEqual(!=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param roleId The value of roleId as notEqual. + */ + public void setRoleId_NotEqual(String roleId) { + regRoleId(CK_NE, fRES(roleId)); + } + + /** + * GreaterThan(>). And NullOrEmptyIgnored, OnceRegistered. + * + * @param roleId The value of roleId as greaterThan. + */ + public void setRoleId_GreaterThan(String roleId) { + regRoleId(CK_GT, fRES(roleId)); + } + + /** + * LessThan(<). And NullOrEmptyIgnored, OnceRegistered. + * + * @param roleId The value of roleId as lessThan. + */ + public void setRoleId_LessThan(String roleId) { + regRoleId(CK_LT, fRES(roleId)); + } + + /** + * GreaterEqual(>=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param roleId The value of roleId as greaterEqual. + */ + public void setRoleId_GreaterEqual(String roleId) { + regRoleId(CK_GE, fRES(roleId)); + } + + /** + * LessEqual(<=). And NullOrEmptyIgnored, OnceRegistered. + * + * @param roleId The value of roleId as lessEqual. + */ + public void setRoleId_LessEqual(String roleId) { + regRoleId(CK_LE, fRES(roleId)); + } + + /** + * PrefixSearch(like 'xxx%'). And NullOrEmptyIgnored, OnceRegistered. + * + * @param roleId The value of roleId as prefixSearch. + */ + public void setRoleId_PrefixSearch(String roleId) { + regRoleId(CK_PS, fRES(roleId)); + } + + /** + * LikeSearch(like 'xxx%' escape ...). And NullOrEmptyIgnored, + * SeveralRegistered. + * + * @param roleId The value of roleId as likeSearch. + * @param likeSearchOption The option of like-search. (NotNull) + */ + public void setRoleId_LikeSearch( + String roleId, + jp.sf.pal.userinfo.db.allcommon.cbean.coption.LikeSearchOption likeSearchOption) { + registerLikeSearchQuery(CK_LS, fRES(roleId), getCValueRoleId(), + "ROLE_ID", "RoleId", "roleId", likeSearchOption); + } + + /** + * InScope(in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param roleIdList The collection of roleId as inScope. + */ + public void setRoleId_InScope(Collection<String> roleIdList) { + regRoleId(CK_INS, cTL(roleIdList)); + } + + /** + * InScope(in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param roleId The collection of roleId as inScope. + * @param inScopeOption The option of in-scope. (NotNull) + */ + public void setRoleId_InScope( + String roleId, + jp.sf.pal.userinfo.db.allcommon.cbean.coption.InScopeOption inScopeOption) { + registerInScopeQuery(CK_INS, fRES(roleId), getCValueRoleId(), + "ROLE_ID", "RoleId", "roleId", inScopeOption); + } + + /** + * NotInScope(not in ('a', 'b')). And NullOrEmptyIgnored, + * NullOrEmptyElementIgnored, SeveralRegistered. + * + * @param roleIdList The collection of roleId as notInScope. + */ + public void setRoleId_NotInScope(Collection<String> roleIdList) { + regRoleId(CK_NINS, cTL(roleIdList)); + } + + /** + * @param roleInfoCBquery Query. + * @deprecated Please use inScopeRoleInfo(subQuery) method. + */ + public void setRoleId_InScopeSubQuery_RoleInfo(RoleInfoCQ roleInfoCBquery) { + String subQueryPropertyName = keepRoleId_InScopeSubQuery_RoleInfo(roleInfoCBquery);// for + // saving + // query + // - + // value + // . + registerInScopeSubQuery(roleInfoCBquery, "ROLE_ID", "ROLE_ID", + subQueryPropertyName); + } + + public void inScopeRoleInfo(SubQuery<RoleInfoCB> subQuery) { + assertObjectNotNull("subQuery<RoleInfoCB>", subQuery); + RoleInfoCB cb = new RoleInfoCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepRoleId_InScopeSubQuery_RoleInfo(cb + .query());// for saving query-value. + registerInScopeSubQuery(cb.query(), "ROLE_ID", "ROLE_ID", + subQueryPropertyName); + } + + abstract public String keepRoleId_InScopeSubQuery_RoleInfo( + jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ subQuery); + + protected void regRoleId(ConditionKey key, Object value) { + registerQuery(key, value, getCValueRoleId(), "ROLE_ID", "RoleId", + "roleId"); + } + + protected void registerInlineRoleId(ConditionKey key, Object value) { + registerInlineQuery(key, value, getCValueRoleId(), "ROLE_ID", "RoleId", + "roleId"); + } + + abstract protected ConditionValue getCValueRoleId(); + + // Very Internal (for Suppressing Warn about 'Not Use Import') + protected String getConditionBeanClassNameInternally() { + return RoleMappingCB.class.getName(); + } + + protected String getConditionQueryClassNameInternally() { + return RoleMappingCQ.class.getName(); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsRoleMappingCQ.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsUserInfoCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsUserInfoCQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/AbstractBsUserInfoCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -9,10 +9,14 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.GroupInfoCB; +import jp.sf.pal.userinfo.db.cbean.GroupMappingCB; import jp.sf.pal.userinfo.db.cbean.RoleInfoCB; +import jp.sf.pal.userinfo.db.cbean.RoleMappingCB; import jp.sf.pal.userinfo.db.cbean.UserInfoCB; import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; /** @@ -162,6 +166,241 @@ } /** + * @param groupMappingCBquery Query. + * @deprecated Please use inScopeGroupMappingList(subQuery) method. + */ + public void setUserId_InScopeSubQuery_GroupMappingList( + GroupMappingCQ groupMappingCBquery) { + String subQueryPropertyName = keepUserId_InScopeSubQuery_GroupMappingList(groupMappingCBquery);// for + // saving + // query + // - + // value + // . + registerInScopeSubQuery(groupMappingCBquery, "USER_ID", "USER_ID", + subQueryPropertyName); + } + + public void inScopeGroupMappingList(SubQuery<GroupMappingCB> subQuery) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_InScopeSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerInScopeSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_InScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + + /** + * @param roleMappingCBquery Query. + * @deprecated Please use inScopeRoleMappingList(subQuery) method. + */ + public void setUserId_InScopeSubQuery_RoleMappingList( + RoleMappingCQ roleMappingCBquery) { + String subQueryPropertyName = keepUserId_InScopeSubQuery_RoleMappingList(roleMappingCBquery);// for + // saving + // query + // - + // value + // . + registerInScopeSubQuery(roleMappingCBquery, "USER_ID", "USER_ID", + subQueryPropertyName); + } + + public void inScopeRoleMappingList(SubQuery<RoleMappingCB> subQuery) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_InScopeSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerInScopeSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_InScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + + public void notInScopeGroupMappingList(SubQuery<GroupMappingCB> subQuery) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_NotInScopeSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerNotInScopeSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_NotInScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + + public void notInScopeRoleMappingList(SubQuery<RoleMappingCB> subQuery) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForInScopeSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_NotInScopeSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerNotInScopeSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_NotInScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + + /** + * @param groupMappingCBquery Query. + * @deprecated Please use existsGroupMappingList(subQuery) method. + */ + public void setUserId_ExistsSubQuery_GroupMappingList( + GroupMappingCQ groupMappingCBquery) { + String subQueryPropertyName = keepUserId_ExistsSubQuery_GroupMappingList(groupMappingCBquery);// for + // saving + // query + // - + // value + // . + registerExistsSubQuery(groupMappingCBquery, "USER_ID", "USER_ID", + subQueryPropertyName); + } + + /** + * Set up 'exists' sub-query. {exists (select USER_ID from GROUP_MAPPING + * where ...)} + * + * @param subQuery The sub-query of UserId_ExistsSubQuery_GroupMappingList + * for 'exists'. (NotNull) + */ + public void existsGroupMappingList(SubQuery<GroupMappingCB> subQuery) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForExistsSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_ExistsSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerExistsSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_ExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + + /** + * @param roleMappingCBquery Query. + * @deprecated Please use existsRoleMappingList(subQuery) method. + */ + public void setUserId_ExistsSubQuery_RoleMappingList( + RoleMappingCQ roleMappingCBquery) { + String subQueryPropertyName = keepUserId_ExistsSubQuery_RoleMappingList(roleMappingCBquery);// for + // saving + // query + // - + // value + // . + registerExistsSubQuery(roleMappingCBquery, "USER_ID", "USER_ID", + subQueryPropertyName); + } + + /** + * Set up 'exists' sub-query. {exists (select USER_ID from ROLE_MAPPING + * where ...)} + * + * @param subQuery The sub-query of UserId_ExistsSubQuery_RoleMappingList + * for 'exists'. (NotNull) + */ + public void existsRoleMappingList(SubQuery<RoleMappingCB> subQuery) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForExistsSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_ExistsSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerExistsSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_ExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + + /** + * Set up 'not exists' sub-query. {not exists (select USER_ID from + * GROUP_MAPPING where ...)} + * + * @param subQuery The sub-query of + * UserId_NotExistsSubQuery_GroupMappingList for 'not exists'. + * (NotNull) + */ + public void notExistsGroupMappingList(SubQuery<GroupMappingCB> subQuery) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForExistsSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_NotExistsSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerNotExistsSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_NotExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + + /** + * Set up 'not exists' sub-query. {not exists (select USER_ID from + * ROLE_MAPPING where ...)} + * + * @param subQuery The sub-query of UserId_NotExistsSubQuery_RoleMappingList + * for 'not exists'. (NotNull) + */ + public void notExistsRoleMappingList(SubQuery<RoleMappingCB> subQuery) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForExistsSubQuery(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_NotExistsSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerNotExistsSubQuery(cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName); + } + + abstract public String keepUserId_NotExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + + public void xderiveGroupMappingList(String function, + SubQuery<GroupMappingCB> subQuery, String aliasName) { + assertObjectNotNull("subQuery<GroupMappingCB>", subQuery); + GroupMappingCB cb = new GroupMappingCB(); + cb.xsetupForDeriveReferrer(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_DeriveSubQuery_GroupMappingList(cb + .query());// for saving query-value. + registerDeriveSubQuery(function, cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName, aliasName); + } + + abstract public String keepUserId_DeriveSubQuery_GroupMappingList( + GroupMappingCQ subQuery); + + public void xderiveRoleMappingList(String function, + SubQuery<RoleMappingCB> subQuery, String aliasName) { + assertObjectNotNull("subQuery<RoleMappingCB>", subQuery); + RoleMappingCB cb = new RoleMappingCB(); + cb.xsetupForDeriveReferrer(); + subQuery.query(cb); + String subQueryPropertyName = keepUserId_DeriveSubQuery_RoleMappingList(cb + .query());// for saving query-value. + registerDeriveSubQuery(function, cb.query(), "USER_ID", "USER_ID", + subQueryPropertyName, aliasName); + } + + abstract public String keepUserId_DeriveSubQuery_RoleMappingList( + RoleMappingCQ subQuery); + + /** * IsNull(is null). And OnceRegistered. */ public void setUserId_IsNull() { Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupInfoCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupInfoCQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupInfoCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -6,6 +6,7 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.ciq.GroupInfoCIQ; @@ -85,6 +86,23 @@ return getGroupId(); } + protected Map<String, GroupMappingCQ> _groupId_InScopeSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getGroupId_InScopeSubQuery_GroupMappingList() { + return _groupId_InScopeSubQuery_GroupMappingListMap; + } + + public String keepGroupId_InScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_groupId_InScopeSubQuery_GroupMappingListMap == null) { + _groupId_InScopeSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_groupId_InScopeSubQuery_GroupMappingListMap.size() + 1); + _groupId_InScopeSubQuery_GroupMappingListMap.put(key, subQuery); + return "groupId_InScopeSubQuery_GroupMappingList." + key; + } + protected Map<String, UserInfoCQ> _groupId_InScopeSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getGroupId_InScopeSubQuery_UserInfoList() { @@ -101,6 +119,23 @@ return "groupId_InScopeSubQuery_UserInfoList." + key; } + protected Map<String, GroupMappingCQ> _groupId_NotInScopeSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getGroupId_NotInScopeSubQuery_GroupMappingList() { + return _groupId_NotInScopeSubQuery_GroupMappingListMap; + } + + public String keepGroupId_NotInScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_groupId_NotInScopeSubQuery_GroupMappingListMap == null) { + _groupId_NotInScopeSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_groupId_NotInScopeSubQuery_GroupMappingListMap.size() + 1); + _groupId_NotInScopeSubQuery_GroupMappingListMap.put(key, subQuery); + return "groupId_NotInScopeSubQuery_GroupMappingList." + key; + } + protected Map<String, UserInfoCQ> _groupId_NotInScopeSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getGroupId_NotInScopeSubQuery_UserInfoList() { @@ -118,6 +153,23 @@ return "groupId_NotInScopeSubQuery_UserInfoList." + key; } + protected Map<String, GroupMappingCQ> _groupId_ExistsSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getGroupId_ExistsSubQuery_GroupMappingList() { + return _groupId_ExistsSubQuery_GroupMappingListMap; + } + + public String keepGroupId_ExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_groupId_ExistsSubQuery_GroupMappingListMap == null) { + _groupId_ExistsSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_groupId_ExistsSubQuery_GroupMappingListMap.size() + 1); + _groupId_ExistsSubQuery_GroupMappingListMap.put(key, subQuery); + return "groupId_ExistsSubQuery_GroupMappingList." + key; + } + protected Map<String, UserInfoCQ> _groupId_ExistsSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getGroupId_ExistsSubQuery_UserInfoList() { @@ -134,6 +186,23 @@ return "groupId_ExistsSubQuery_UserInfoList." + key; } + protected Map<String, GroupMappingCQ> _groupId_NotExistsSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getGroupId_NotExistsSubQuery_GroupMappingList() { + return _groupId_NotExistsSubQuery_GroupMappingListMap; + } + + public String keepGroupId_NotExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_groupId_NotExistsSubQuery_GroupMappingListMap == null) { + _groupId_NotExistsSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_groupId_NotExistsSubQuery_GroupMappingListMap.size() + 1); + _groupId_NotExistsSubQuery_GroupMappingListMap.put(key, subQuery); + return "groupId_NotExistsSubQuery_GroupMappingList." + key; + } + protected Map<String, UserInfoCQ> _groupId_NotExistsSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getGroupId_NotExistsSubQuery_UserInfoList() { @@ -150,6 +219,23 @@ return "groupId_NotExistsSubQuery_UserInfoList." + key; } + protected Map<String, GroupMappingCQ> _groupId_DeriveSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getGroupId_DeriveSubQuery_GroupMappingList() { + return _groupId_DeriveSubQuery_GroupMappingListMap; + } + + public String keepGroupId_DeriveSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_groupId_DeriveSubQuery_GroupMappingListMap == null) { + _groupId_DeriveSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_groupId_DeriveSubQuery_GroupMappingListMap.size() + 1); + _groupId_DeriveSubQuery_GroupMappingListMap.put(key, subQuery); + return "groupId_DeriveSubQuery_GroupMappingList." + key; + } + protected Map<String, UserInfoCQ> _groupId_DeriveSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getGroupId_DeriveSubQuery_UserInfoList() { Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupMappingCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupMappingCQ.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupMappingCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,291 @@ +package jp.sf.pal.userinfo.db.cbean.cq.bs; + +import java.util.Map; + +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; +import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; +import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.ciq.GroupMappingCIQ; + +/** + * The base condition-query of GROUP_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class BsGroupMappingCQ extends AbstractBsGroupMappingCQ { + + //========================================================================== + // ========= + // Attribute + // ========= + protected GroupMappingCIQ _inlineQuery; + + //========================================================================== + // ========= + // Constructor + // =========== + public BsGroupMappingCQ(ConditionQuery childQuery, SqlClause sqlClause, + String aliasName, int nestLevel) { + super(childQuery, sqlClause, aliasName, nestLevel); + } + + //========================================================================== + // ========= + // Inline + // ====== + /** + * Prepare inline query. <br /> {select ... from ... left outer join (select + * * from GROUP_MAPPING) where abc = [abc] ...} + * + * @return Inline query. (NotNull) + */ + public GroupMappingCIQ inline() { + if (_inlineQuery == null) { + _inlineQuery = new GroupMappingCIQ(getChildQuery(), getSqlClause(), + getAliasName(), getNestLevel(), this); + } + _inlineQuery.xsetOnClauseInline(false); + return _inlineQuery; + } + + /** + * Prepare on-clause query. <br /> {select ... from ... left outer join + * GROUP_MAPPING on ... and abc = [abc] ...} + * + * @return On-clause query. (NotNull) + */ + public GroupMappingCIQ on() { + if (isBaseQuery(this)) { + throw new UnsupportedOperationException( + "Unsupported onClause of Base Table!"); + } + GroupMappingCIQ inlineQuery = inline(); + inlineQuery.xsetOnClauseInline(true); + return inlineQuery; + } + + //========================================================================== + // ========= + // Query + // ===== + + protected ConditionValue _id; + + public ConditionValue getId() { + if (_id == null) { + _id = new ConditionValue(); + } + return _id; + } + + protected ConditionValue getCValueId() { + return getId(); + } + + public BsGroupMappingCQ addOrderBy_Id_Asc() { + regOBA("ID"); + return this; + } + + public BsGroupMappingCQ addOrderBy_Id_Desc() { + regOBD("ID"); + return this; + } + + protected ConditionValue _userId; + + public ConditionValue getUserId() { + if (_userId == null) { + _userId = new ConditionValue(); + } + return _userId; + } + + protected ConditionValue getCValueUserId() { + return getUserId(); + } + + protected Map<String, UserInfoCQ> _userId_InScopeSubQuery_UserInfoMap; + + public Map<String, UserInfoCQ> getUserId_InScopeSubQuery_UserInfo() { + return _userId_InScopeSubQuery_UserInfoMap; + } + + public String keepUserId_InScopeSubQuery_UserInfo(UserInfoCQ subQuery) { + if (_userId_InScopeSubQuery_UserInfoMap == null) { + _userId_InScopeSubQuery_UserInfoMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_InScopeSubQuery_UserInfoMap.size() + 1); + _userId_InScopeSubQuery_UserInfoMap.put(key, subQuery); + return "userId_InScopeSubQuery_UserInfo." + key; + } + + public BsGroupMappingCQ addOrderBy_UserId_Asc() { + regOBA("USER_ID"); + return this; + } + + public BsGroupMappingCQ addOrderBy_UserId_Desc() { + regOBD("USER_ID"); + return this; + } + + protected ConditionValue _groupId; + + public ConditionValue getGroupId() { + if (_groupId == null) { + _groupId = new ConditionValue(); + } + return _groupId; + } + + protected ConditionValue getCValueGroupId() { + return getGroupId(); + } + + protected Map<String, GroupInfoCQ> _groupId_InScopeSubQuery_GroupInfoMap; + + public Map<String, GroupInfoCQ> getGroupId_InScopeSubQuery_GroupInfo() { + return _groupId_InScopeSubQuery_GroupInfoMap; + } + + public String keepGroupId_InScopeSubQuery_GroupInfo(GroupInfoCQ subQuery) { + if (_groupId_InScopeSubQuery_GroupInfoMap == null) { + _groupId_InScopeSubQuery_GroupInfoMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_groupId_InScopeSubQuery_GroupInfoMap.size() + 1); + _groupId_InScopeSubQuery_GroupInfoMap.put(key, subQuery); + return "groupId_InScopeSubQuery_GroupInfo." + key; + } + + public BsGroupMappingCQ addOrderBy_GroupId_Asc() { + regOBA("GROUP_ID"); + return this; + } + + public BsGroupMappingCQ addOrderBy_GroupId_Desc() { + regOBD("GROUP_ID"); + return this; + } + + //========================================================================== + // ========= + // Specified Derived OrderBy + // ========================= + public BsGroupMappingCQ addSpecifiedDerivedOrderBy_Asc(String aliasName) { + registerSpecifiedDerivedOrderBy_Asc(aliasName); + return this; + } + + public BsGroupMappingCQ addSpecifiedDerivedOrderBy_Desc(String aliasName) { + registerSpecifiedDerivedOrderBy_Desc(aliasName); + return this; + } + + //========================================================================== + // ========= + // Union Query + // =========== + protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, + ConditionQuery unionQueryAsSuper) { + GroupMappingCQ baseQuery = (GroupMappingCQ) baseQueryAsSuper; + GroupMappingCQ unionQuery = (GroupMappingCQ) unionQueryAsSuper; + if (baseQuery.hasConditionQueryGroupInfo()) { + unionQuery.queryGroupInfo().reflectRelationOnUnionQuery( + baseQuery.queryGroupInfo(), unionQuery.queryGroupInfo()); + } + if (baseQuery.hasConditionQueryUserInfo()) { + unionQuery.queryUserInfo().reflectRelationOnUnionQuery( + baseQuery.queryUserInfo(), unionQuery.queryUserInfo()); + } + } + + //========================================================================== + // ========= + // Foreign Query + // ============= + + public GroupInfoCQ queryGroupInfo() { + return getConditionQueryGroupInfo(); + } + + protected GroupInfoCQ _conditionQueryGroupInfo; + + public GroupInfoCQ getConditionQueryGroupInfo() { + if (_conditionQueryGroupInfo == null) { + _conditionQueryGroupInfo = createQueryGroupInfo(); + setupOuterJoin_GroupInfo(); + } + return _conditionQueryGroupInfo; + } + + protected void setupOuterJoin_GroupInfo() { + Map<String, String> joinOnMap = newLinkedHashMap(); + joinOnMap.put(getRealColumnName("GROUP_ID"), + getConditionQueryGroupInfo().getRealColumnName("GROUP_ID")); + registerOuterJoin(getConditionQueryGroupInfo(), joinOnMap); + } + + protected GroupInfoCQ createQueryGroupInfo() { + String nrp = resolveNextRelationPath("GROUP_MAPPING", "groupInfo"); + String jan = resolveJoinAliasName(nrp, getNextNestLevel()); + GroupInfoCQ cq = new GroupInfoCQ(this, getSqlClause(), jan, + getNextNestLevel()); + cq.xsetForeignPropertyName("groupInfo"); + cq.xsetRelationPath(nrp); + return cq; + } + + public boolean hasConditionQueryGroupInfo() { + return _conditionQueryGroupInfo != null; + } + + public UserInfoCQ queryUserInfo() { + return getConditionQueryUserInfo(); + } + + protected UserInfoCQ _conditionQueryUserInfo; + + public UserInfoCQ getConditionQueryUserInfo() { + if (_conditionQueryUserInfo == null) { + _conditionQueryUserInfo = createQueryUserInfo(); + setupOuterJoin_UserInfo(); + } + return _conditionQueryUserInfo; + } + + protected void setupOuterJoin_UserInfo() { + Map<String, String> joinOnMap = newLinkedHashMap(); + joinOnMap.put(getRealColumnName("USER_ID"), getConditionQueryUserInfo() + .getRealColumnName("USER_ID")); + registerOuterJoin(getConditionQueryUserInfo(), joinOnMap); + } + + protected UserInfoCQ createQueryUserInfo() { + String nrp = resolveNextRelationPath("GROUP_MAPPING", "userInfo"); + String jan = resolveJoinAliasName(nrp, getNextNestLevel()); + UserInfoCQ cq = new UserInfoCQ(this, getSqlClause(), jan, + getNextNestLevel()); + cq.xsetForeignPropertyName("userInfo"); + cq.xsetRelationPath(nrp); + return cq; + } + + public boolean hasConditionQueryUserInfo() { + return _conditionQueryUserInfo != null; + } + + protected String getConditionQueryClassNameInternally() { + return GroupMappingCQ.class.getName(); + } + + protected String getMapClassNameInternally() { + return Map.class.getName(); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsGroupMappingCQ.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleInfoCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleInfoCQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleInfoCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -6,6 +6,7 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.ciq.RoleInfoCIQ; @@ -85,6 +86,23 @@ return getRoleId(); } + protected Map<String, RoleMappingCQ> _roleId_InScopeSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getRoleId_InScopeSubQuery_RoleMappingList() { + return _roleId_InScopeSubQuery_RoleMappingListMap; + } + + public String keepRoleId_InScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_roleId_InScopeSubQuery_RoleMappingListMap == null) { + _roleId_InScopeSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_roleId_InScopeSubQuery_RoleMappingListMap.size() + 1); + _roleId_InScopeSubQuery_RoleMappingListMap.put(key, subQuery); + return "roleId_InScopeSubQuery_RoleMappingList." + key; + } + protected Map<String, UserInfoCQ> _roleId_InScopeSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getRoleId_InScopeSubQuery_UserInfoList() { @@ -101,6 +119,23 @@ return "roleId_InScopeSubQuery_UserInfoList." + key; } + protected Map<String, RoleMappingCQ> _roleId_NotInScopeSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getRoleId_NotInScopeSubQuery_RoleMappingList() { + return _roleId_NotInScopeSubQuery_RoleMappingListMap; + } + + public String keepRoleId_NotInScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_roleId_NotInScopeSubQuery_RoleMappingListMap == null) { + _roleId_NotInScopeSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_roleId_NotInScopeSubQuery_RoleMappingListMap.size() + 1); + _roleId_NotInScopeSubQuery_RoleMappingListMap.put(key, subQuery); + return "roleId_NotInScopeSubQuery_RoleMappingList." + key; + } + protected Map<String, UserInfoCQ> _roleId_NotInScopeSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getRoleId_NotInScopeSubQuery_UserInfoList() { @@ -117,6 +152,23 @@ return "roleId_NotInScopeSubQuery_UserInfoList." + key; } + protected Map<String, RoleMappingCQ> _roleId_ExistsSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getRoleId_ExistsSubQuery_RoleMappingList() { + return _roleId_ExistsSubQuery_RoleMappingListMap; + } + + public String keepRoleId_ExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_roleId_ExistsSubQuery_RoleMappingListMap == null) { + _roleId_ExistsSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_roleId_ExistsSubQuery_RoleMappingListMap.size() + 1); + _roleId_ExistsSubQuery_RoleMappingListMap.put(key, subQuery); + return "roleId_ExistsSubQuery_RoleMappingList." + key; + } + protected Map<String, UserInfoCQ> _roleId_ExistsSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getRoleId_ExistsSubQuery_UserInfoList() { @@ -133,6 +185,23 @@ return "roleId_ExistsSubQuery_UserInfoList." + key; } + protected Map<String, RoleMappingCQ> _roleId_NotExistsSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getRoleId_NotExistsSubQuery_RoleMappingList() { + return _roleId_NotExistsSubQuery_RoleMappingListMap; + } + + public String keepRoleId_NotExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_roleId_NotExistsSubQuery_RoleMappingListMap == null) { + _roleId_NotExistsSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_roleId_NotExistsSubQuery_RoleMappingListMap.size() + 1); + _roleId_NotExistsSubQuery_RoleMappingListMap.put(key, subQuery); + return "roleId_NotExistsSubQuery_RoleMappingList." + key; + } + protected Map<String, UserInfoCQ> _roleId_NotExistsSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getRoleId_NotExistsSubQuery_UserInfoList() { @@ -149,6 +218,23 @@ return "roleId_NotExistsSubQuery_UserInfoList." + key; } + protected Map<String, RoleMappingCQ> _roleId_DeriveSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getRoleId_DeriveSubQuery_RoleMappingList() { + return _roleId_DeriveSubQuery_RoleMappingListMap; + } + + public String keepRoleId_DeriveSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_roleId_DeriveSubQuery_RoleMappingListMap == null) { + _roleId_DeriveSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_roleId_DeriveSubQuery_RoleMappingListMap.size() + 1); + _roleId_DeriveSubQuery_RoleMappingListMap.put(key, subQuery); + return "roleId_DeriveSubQuery_RoleMappingList." + key; + } + protected Map<String, UserInfoCQ> _roleId_DeriveSubQuery_UserInfoListMap; public Map<String, UserInfoCQ> getRoleId_DeriveSubQuery_UserInfoList() { Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleMappingCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleMappingCQ.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleMappingCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,291 @@ +package jp.sf.pal.userinfo.db.cbean.cq.bs; + +import java.util.Map; + +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; +import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; +import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.ciq.RoleMappingCIQ; + +/** + * The base condition-query of ROLE_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class BsRoleMappingCQ extends AbstractBsRoleMappingCQ { + + //========================================================================== + // ========= + // Attribute + // ========= + protected RoleMappingCIQ _inlineQuery; + + //========================================================================== + // ========= + // Constructor + // =========== + public BsRoleMappingCQ(ConditionQuery childQuery, SqlClause sqlClause, + String aliasName, int nestLevel) { + super(childQuery, sqlClause, aliasName, nestLevel); + } + + //========================================================================== + // ========= + // Inline + // ====== + /** + * Prepare inline query. <br /> {select ... from ... left outer join (select + * * from ROLE_MAPPING) where abc = [abc] ...} + * + * @return Inline query. (NotNull) + */ + public RoleMappingCIQ inline() { + if (_inlineQuery == null) { + _inlineQuery = new RoleMappingCIQ(getChildQuery(), getSqlClause(), + getAliasName(), getNestLevel(), this); + } + _inlineQuery.xsetOnClauseInline(false); + return _inlineQuery; + } + + /** + * Prepare on-clause query. <br /> {select ... from ... left outer join + * ROLE_MAPPING on ... and abc = [abc] ...} + * + * @return On-clause query. (NotNull) + */ + public RoleMappingCIQ on() { + if (isBaseQuery(this)) { + throw new UnsupportedOperationException( + "Unsupported onClause of Base Table!"); + } + RoleMappingCIQ inlineQuery = inline(); + inlineQuery.xsetOnClauseInline(true); + return inlineQuery; + } + + //========================================================================== + // ========= + // Query + // ===== + + protected ConditionValue _id; + + public ConditionValue getId() { + if (_id == null) { + _id = new ConditionValue(); + } + return _id; + } + + protected ConditionValue getCValueId() { + return getId(); + } + + public BsRoleMappingCQ addOrderBy_Id_Asc() { + regOBA("ID"); + return this; + } + + public BsRoleMappingCQ addOrderBy_Id_Desc() { + regOBD("ID"); + return this; + } + + protected ConditionValue _userId; + + public ConditionValue getUserId() { + if (_userId == null) { + _userId = new ConditionValue(); + } + return _userId; + } + + protected ConditionValue getCValueUserId() { + return getUserId(); + } + + protected Map<String, UserInfoCQ> _userId_InScopeSubQuery_UserInfoMap; + + public Map<String, UserInfoCQ> getUserId_InScopeSubQuery_UserInfo() { + return _userId_InScopeSubQuery_UserInfoMap; + } + + public String keepUserId_InScopeSubQuery_UserInfo(UserInfoCQ subQuery) { + if (_userId_InScopeSubQuery_UserInfoMap == null) { + _userId_InScopeSubQuery_UserInfoMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_InScopeSubQuery_UserInfoMap.size() + 1); + _userId_InScopeSubQuery_UserInfoMap.put(key, subQuery); + return "userId_InScopeSubQuery_UserInfo." + key; + } + + public BsRoleMappingCQ addOrderBy_UserId_Asc() { + regOBA("USER_ID"); + return this; + } + + public BsRoleMappingCQ addOrderBy_UserId_Desc() { + regOBD("USER_ID"); + return this; + } + + protected ConditionValue _roleId; + + public ConditionValue getRoleId() { + if (_roleId == null) { + _roleId = new ConditionValue(); + } + return _roleId; + } + + protected ConditionValue getCValueRoleId() { + return getRoleId(); + } + + protected Map<String, RoleInfoCQ> _roleId_InScopeSubQuery_RoleInfoMap; + + public Map<String, RoleInfoCQ> getRoleId_InScopeSubQuery_RoleInfo() { + return _roleId_InScopeSubQuery_RoleInfoMap; + } + + public String keepRoleId_InScopeSubQuery_RoleInfo(RoleInfoCQ subQuery) { + if (_roleId_InScopeSubQuery_RoleInfoMap == null) { + _roleId_InScopeSubQuery_RoleInfoMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_roleId_InScopeSubQuery_RoleInfoMap.size() + 1); + _roleId_InScopeSubQuery_RoleInfoMap.put(key, subQuery); + return "roleId_InScopeSubQuery_RoleInfo." + key; + } + + public BsRoleMappingCQ addOrderBy_RoleId_Asc() { + regOBA("ROLE_ID"); + return this; + } + + public BsRoleMappingCQ addOrderBy_RoleId_Desc() { + regOBD("ROLE_ID"); + return this; + } + + //========================================================================== + // ========= + // Specified Derived OrderBy + // ========================= + public BsRoleMappingCQ addSpecifiedDerivedOrderBy_Asc(String aliasName) { + registerSpecifiedDerivedOrderBy_Asc(aliasName); + return this; + } + + public BsRoleMappingCQ addSpecifiedDerivedOrderBy_Desc(String aliasName) { + registerSpecifiedDerivedOrderBy_Desc(aliasName); + return this; + } + + //========================================================================== + // ========= + // Union Query + // =========== + protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, + ConditionQuery unionQueryAsSuper) { + RoleMappingCQ baseQuery = (RoleMappingCQ) baseQueryAsSuper; + RoleMappingCQ unionQuery = (RoleMappingCQ) unionQueryAsSuper; + if (baseQuery.hasConditionQueryRoleInfo()) { + unionQuery.queryRoleInfo().reflectRelationOnUnionQuery( + baseQuery.queryRoleInfo(), unionQuery.queryRoleInfo()); + } + if (baseQuery.hasConditionQueryUserInfo()) { + unionQuery.queryUserInfo().reflectRelationOnUnionQuery( + baseQuery.queryUserInfo(), unionQuery.queryUserInfo()); + } + } + + //========================================================================== + // ========= + // Foreign Query + // ============= + + public RoleInfoCQ queryRoleInfo() { + return getConditionQueryRoleInfo(); + } + + protected RoleInfoCQ _conditionQueryRoleInfo; + + public RoleInfoCQ getConditionQueryRoleInfo() { + if (_conditionQueryRoleInfo == null) { + _conditionQueryRoleInfo = createQueryRoleInfo(); + setupOuterJoin_RoleInfo(); + } + return _conditionQueryRoleInfo; + } + + protected void setupOuterJoin_RoleInfo() { + Map<String, String> joinOnMap = newLinkedHashMap(); + joinOnMap.put(getRealColumnName("ROLE_ID"), getConditionQueryRoleInfo() + .getRealColumnName("ROLE_ID")); + registerOuterJoin(getConditionQueryRoleInfo(), joinOnMap); + } + + protected RoleInfoCQ createQueryRoleInfo() { + String nrp = resolveNextRelationPath("ROLE_MAPPING", "roleInfo"); + String jan = resolveJoinAliasName(nrp, getNextNestLevel()); + RoleInfoCQ cq = new RoleInfoCQ(this, getSqlClause(), jan, + getNextNestLevel()); + cq.xsetForeignPropertyName("roleInfo"); + cq.xsetRelationPath(nrp); + return cq; + } + + public boolean hasConditionQueryRoleInfo() { + return _conditionQueryRoleInfo != null; + } + + public UserInfoCQ queryUserInfo() { + return getConditionQueryUserInfo(); + } + + protected UserInfoCQ _conditionQueryUserInfo; + + public UserInfoCQ getConditionQueryUserInfo() { + if (_conditionQueryUserInfo == null) { + _conditionQueryUserInfo = createQueryUserInfo(); + setupOuterJoin_UserInfo(); + } + return _conditionQueryUserInfo; + } + + protected void setupOuterJoin_UserInfo() { + Map<String, String> joinOnMap = newLinkedHashMap(); + joinOnMap.put(getRealColumnName("USER_ID"), getConditionQueryUserInfo() + .getRealColumnName("USER_ID")); + registerOuterJoin(getConditionQueryUserInfo(), joinOnMap); + } + + protected UserInfoCQ createQueryUserInfo() { + String nrp = resolveNextRelationPath("ROLE_MAPPING", "userInfo"); + String jan = resolveJoinAliasName(nrp, getNextNestLevel()); + UserInfoCQ cq = new UserInfoCQ(this, getSqlClause(), jan, + getNextNestLevel()); + cq.xsetForeignPropertyName("userInfo"); + cq.xsetRelationPath(nrp); + return cq; + } + + public boolean hasConditionQueryUserInfo() { + return _conditionQueryUserInfo != null; + } + + protected String getConditionQueryClassNameInternally() { + return RoleMappingCQ.class.getName(); + } + + protected String getMapClassNameInternally() { + return Map.class.getName(); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsRoleMappingCQ.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsUserInfoCQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsUserInfoCQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/bs/BsUserInfoCQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -6,7 +6,9 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.ciq.UserInfoCIQ; @@ -86,6 +88,176 @@ return getUserId(); } + protected Map<String, GroupMappingCQ> _userId_InScopeSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getUserId_InScopeSubQuery_GroupMappingList() { + return _userId_InScopeSubQuery_GroupMappingListMap; + } + + public String keepUserId_InScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_userId_InScopeSubQuery_GroupMappingListMap == null) { + _userId_InScopeSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_InScopeSubQuery_GroupMappingListMap.size() + 1); + _userId_InScopeSubQuery_GroupMappingListMap.put(key, subQuery); + return "userId_InScopeSubQuery_GroupMappingList." + key; + } + + protected Map<String, RoleMappingCQ> _userId_InScopeSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getUserId_InScopeSubQuery_RoleMappingList() { + return _userId_InScopeSubQuery_RoleMappingListMap; + } + + public String keepUserId_InScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_userId_InScopeSubQuery_RoleMappingListMap == null) { + _userId_InScopeSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_InScopeSubQuery_RoleMappingListMap.size() + 1); + _userId_InScopeSubQuery_RoleMappingListMap.put(key, subQuery); + return "userId_InScopeSubQuery_RoleMappingList." + key; + } + + protected Map<String, GroupMappingCQ> _userId_NotInScopeSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getUserId_NotInScopeSubQuery_GroupMappingList() { + return _userId_NotInScopeSubQuery_GroupMappingListMap; + } + + public String keepUserId_NotInScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_userId_NotInScopeSubQuery_GroupMappingListMap == null) { + _userId_NotInScopeSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_NotInScopeSubQuery_GroupMappingListMap.size() + 1); + _userId_NotInScopeSubQuery_GroupMappingListMap.put(key, subQuery); + return "userId_NotInScopeSubQuery_GroupMappingList." + key; + } + + protected Map<String, RoleMappingCQ> _userId_NotInScopeSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getUserId_NotInScopeSubQuery_RoleMappingList() { + return _userId_NotInScopeSubQuery_RoleMappingListMap; + } + + public String keepUserId_NotInScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_userId_NotInScopeSubQuery_RoleMappingListMap == null) { + _userId_NotInScopeSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_NotInScopeSubQuery_RoleMappingListMap.size() + 1); + _userId_NotInScopeSubQuery_RoleMappingListMap.put(key, subQuery); + return "userId_NotInScopeSubQuery_RoleMappingList." + key; + } + + protected Map<String, GroupMappingCQ> _userId_ExistsSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getUserId_ExistsSubQuery_GroupMappingList() { + return _userId_ExistsSubQuery_GroupMappingListMap; + } + + public String keepUserId_ExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_userId_ExistsSubQuery_GroupMappingListMap == null) { + _userId_ExistsSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_ExistsSubQuery_GroupMappingListMap.size() + 1); + _userId_ExistsSubQuery_GroupMappingListMap.put(key, subQuery); + return "userId_ExistsSubQuery_GroupMappingList." + key; + } + + protected Map<String, RoleMappingCQ> _userId_ExistsSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getUserId_ExistsSubQuery_RoleMappingList() { + return _userId_ExistsSubQuery_RoleMappingListMap; + } + + public String keepUserId_ExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_userId_ExistsSubQuery_RoleMappingListMap == null) { + _userId_ExistsSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_ExistsSubQuery_RoleMappingListMap.size() + 1); + _userId_ExistsSubQuery_RoleMappingListMap.put(key, subQuery); + return "userId_ExistsSubQuery_RoleMappingList." + key; + } + + protected Map<String, GroupMappingCQ> _userId_NotExistsSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getUserId_NotExistsSubQuery_GroupMappingList() { + return _userId_NotExistsSubQuery_GroupMappingListMap; + } + + public String keepUserId_NotExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_userId_NotExistsSubQuery_GroupMappingListMap == null) { + _userId_NotExistsSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_NotExistsSubQuery_GroupMappingListMap.size() + 1); + _userId_NotExistsSubQuery_GroupMappingListMap.put(key, subQuery); + return "userId_NotExistsSubQuery_GroupMappingList." + key; + } + + protected Map<String, RoleMappingCQ> _userId_NotExistsSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getUserId_NotExistsSubQuery_RoleMappingList() { + return _userId_NotExistsSubQuery_RoleMappingListMap; + } + + public String keepUserId_NotExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_userId_NotExistsSubQuery_RoleMappingListMap == null) { + _userId_NotExistsSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_NotExistsSubQuery_RoleMappingListMap.size() + 1); + _userId_NotExistsSubQuery_RoleMappingListMap.put(key, subQuery); + return "userId_NotExistsSubQuery_RoleMappingList." + key; + } + + protected Map<String, GroupMappingCQ> _userId_DeriveSubQuery_GroupMappingListMap; + + public Map<String, GroupMappingCQ> getUserId_DeriveSubQuery_GroupMappingList() { + return _userId_DeriveSubQuery_GroupMappingListMap; + } + + public String keepUserId_DeriveSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + if (_userId_DeriveSubQuery_GroupMappingListMap == null) { + _userId_DeriveSubQuery_GroupMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_DeriveSubQuery_GroupMappingListMap.size() + 1); + _userId_DeriveSubQuery_GroupMappingListMap.put(key, subQuery); + return "userId_DeriveSubQuery_GroupMappingList." + key; + } + + protected Map<String, RoleMappingCQ> _userId_DeriveSubQuery_RoleMappingListMap; + + public Map<String, RoleMappingCQ> getUserId_DeriveSubQuery_RoleMappingList() { + return _userId_DeriveSubQuery_RoleMappingListMap; + } + + public String keepUserId_DeriveSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + if (_userId_DeriveSubQuery_RoleMappingListMap == null) { + _userId_DeriveSubQuery_RoleMappingListMap = newLinkedHashMap(); + } + String key = "subQueryMapKey" + + (_userId_DeriveSubQuery_RoleMappingListMap.size() + 1); + _userId_DeriveSubQuery_RoleMappingListMap.put(key, subQuery); + return "userId_DeriveSubQuery_RoleMappingList." + key; + } + public BsUserInfoCQ addOrderBy_UserId_Asc() { regOBA("USER_ID"); return this; Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupInfoCIQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupInfoCIQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupInfoCIQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -6,6 +6,7 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.bs.AbstractBsGroupInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.bs.BsGroupInfoCQ; @@ -95,25 +96,53 @@ return _myCQ.getGroupId(); } + public String keepGroupId_InScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + return _myCQ.keepGroupId_InScopeSubQuery_GroupMappingList(subQuery); + } + public String keepGroupId_InScopeSubQuery_UserInfoList(UserInfoCQ subQuery) { return _myCQ.keepGroupId_InScopeSubQuery_UserInfoList(subQuery); } + public String keepGroupId_NotInScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + return _myCQ.keepGroupId_NotInScopeSubQuery_GroupMappingList(subQuery); + } + public String keepGroupId_NotInScopeSubQuery_UserInfoList( UserInfoCQ subQuery) { return _myCQ.keepGroupId_NotInScopeSubQuery_UserInfoList(subQuery); } + public String keepGroupId_ExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + throw new UnsupportedOperationException( + "ExistsSubQuery at inline() is unsupported! Sorry!"); + } + public String keepGroupId_ExistsSubQuery_UserInfoList(UserInfoCQ subQuery) { throw new UnsupportedOperationException( "ExistsSubQuery at inline() is unsupported! Sorry!"); } + public String keepGroupId_NotExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + throw new UnsupportedOperationException( + "NotExistsSubQuery at inline() is unsupported! Sorry!"); + } + public String keepGroupId_NotExistsSubQuery_UserInfoList(UserInfoCQ subQuery) { throw new UnsupportedOperationException( "NotExistsSubQuery at inline() is unsupported! Sorry!"); } + public String keepGroupId_DeriveSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + throw new UnsupportedOperationException( + "DeriveSubQuery at inline() is unsupported! Sorry!"); + } + public String keepGroupId_DeriveSubQuery_UserInfoList(UserInfoCQ subQuery) { throw new UnsupportedOperationException( "DeriveSubQuery at inline() is unsupported! Sorry!"); Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupMappingCIQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupMappingCIQ.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupMappingCIQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,118 @@ +package jp.sf.pal.userinfo.db.cbean.cq.ciq; + +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.ckey.ConditionKey; +import jp.sf.pal.userinfo.db.allcommon.cbean.coption.ConditionOption; +import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; +import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; +import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.bs.AbstractBsGroupMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.bs.BsGroupMappingCQ; + +/** + * The condition-inline-query of GROUP_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class GroupMappingCIQ extends AbstractBsGroupMappingCQ { + + //========================================================================== + // ========= + // Attribute + // ========= + protected BsGroupMappingCQ _myCQ; + + //========================================================================== + // ========= + // Constructor + // =========== + public GroupMappingCIQ(ConditionQuery childQuery, SqlClause sqlClause, + String aliasName, int nestLevel, BsGroupMappingCQ myCQ) { + super(childQuery, sqlClause, aliasName, nestLevel); + _myCQ = myCQ; + _foreignPropertyName = _myCQ.getForeignPropertyName();// Accept foreign + // property name. + _relationPath = _myCQ.getRelationPath();// Accept relation path. + } + + //========================================================================== + // ========= + // Override about Register + // ======================= + @Override + protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, + ConditionQuery unionQueryAsSuper) { + throw new UnsupportedOperationException( + "InlineQuery must not need UNION method: " + baseQueryAsSuper + + " : " + unionQueryAsSuper); + } + + @Override + protected void setupConditionValueAndRegisterWhereClause(ConditionKey key, + Object value, ConditionValue cvalue, String colName, + String capPropName, String uncapPropName) { + registerInlineQuery(key, value, cvalue, colName, capPropName, + uncapPropName); + } + + @Override + protected void setupConditionValueAndRegisterWhereClause(ConditionKey key, + Object value, ConditionValue cvalue, String colName, + String capPropName, String uncapPropName, ConditionOption option) { + registerInlineQuery(key, value, cvalue, colName, capPropName, + uncapPropName, option); + } + + @Override + protected void registerWhereClause(String whereClause) { + registerInlineWhereClause(whereClause); + } + + @Override + protected String getInScopeSubQueryRealColumnName(String columnName) { + if (_onClauseInline) { + throw new UnsupportedOperationException( + "InScopeSubQuery of on-clause is unsupported"); + } + return _onClauseInline ? getRealAliasName() + "." + columnName + : columnName; + } + + @Override + protected void registerExistsSubQuery(ConditionQuery subQuery, + String columnName, String relatedColumnName, String propertyName) { + throw new UnsupportedOperationException( + "Sorry! ExistsSubQuery at inline view is unsupported. So please use InScopeSubQyery."); + } + + //========================================================================== + // ========= + // Override about Query + // ==================== + protected ConditionValue getCValueId() { + return _myCQ.getId(); + } + + protected ConditionValue getCValueUserId() { + return _myCQ.getUserId(); + } + + public String keepUserId_InScopeSubQuery_UserInfo(UserInfoCQ subQuery) { + return _myCQ.keepUserId_InScopeSubQuery_UserInfo(subQuery); + } + + protected ConditionValue getCValueGroupId() { + return _myCQ.getGroupId(); + } + + public String keepGroupId_InScopeSubQuery_GroupInfo(GroupInfoCQ subQuery) { + return _myCQ.keepGroupId_InScopeSubQuery_GroupInfo(subQuery); + } + + protected String getConditionQueryClassNameInternally() { + return GroupMappingCQ.class.getName(); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/GroupMappingCIQ.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleInfoCIQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleInfoCIQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleInfoCIQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -6,6 +6,7 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.bs.AbstractBsRoleInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.bs.BsRoleInfoCQ; @@ -95,24 +96,52 @@ return _myCQ.getRoleId(); } + public String keepRoleId_InScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + return _myCQ.keepRoleId_InScopeSubQuery_RoleMappingList(subQuery); + } + public String keepRoleId_InScopeSubQuery_UserInfoList(UserInfoCQ subQuery) { return _myCQ.keepRoleId_InScopeSubQuery_UserInfoList(subQuery); } + public String keepRoleId_NotInScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + return _myCQ.keepRoleId_NotInScopeSubQuery_RoleMappingList(subQuery); + } + public String keepRoleId_NotInScopeSubQuery_UserInfoList(UserInfoCQ subQuery) { return _myCQ.keepRoleId_NotInScopeSubQuery_UserInfoList(subQuery); } + public String keepRoleId_ExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + throw new UnsupportedOperationException( + "ExistsSubQuery at inline() is unsupported! Sorry!"); + } + public String keepRoleId_ExistsSubQuery_UserInfoList(UserInfoCQ subQuery) { throw new UnsupportedOperationException( "ExistsSubQuery at inline() is unsupported! Sorry!"); } + public String keepRoleId_NotExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + throw new UnsupportedOperationException( + "NotExistsSubQuery at inline() is unsupported! Sorry!"); + } + public String keepRoleId_NotExistsSubQuery_UserInfoList(UserInfoCQ subQuery) { throw new UnsupportedOperationException( "NotExistsSubQuery at inline() is unsupported! Sorry!"); } + public String keepRoleId_DeriveSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + throw new UnsupportedOperationException( + "DeriveSubQuery at inline() is unsupported! Sorry!"); + } + public String keepRoleId_DeriveSubQuery_UserInfoList(UserInfoCQ subQuery) { throw new UnsupportedOperationException( "DeriveSubQuery at inline() is unsupported! Sorry!"); Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleMappingCIQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleMappingCIQ.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleMappingCIQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,118 @@ +package jp.sf.pal.userinfo.db.cbean.cq.ciq; + +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.allcommon.cbean.ckey.ConditionKey; +import jp.sf.pal.userinfo.db.allcommon.cbean.coption.ConditionOption; +import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; +import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; +import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.bs.AbstractBsRoleMappingCQ; +import jp.sf.pal.userinfo.db.cbean.cq.bs.BsRoleMappingCQ; + +/** + * The condition-inline-query of ROLE_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class RoleMappingCIQ extends AbstractBsRoleMappingCQ { + + //========================================================================== + // ========= + // Attribute + // ========= + protected BsRoleMappingCQ _myCQ; + + //========================================================================== + // ========= + // Constructor + // =========== + public RoleMappingCIQ(ConditionQuery childQuery, SqlClause sqlClause, + String aliasName, int nestLevel, BsRoleMappingCQ myCQ) { + super(childQuery, sqlClause, aliasName, nestLevel); + _myCQ = myCQ; + _foreignPropertyName = _myCQ.getForeignPropertyName();// Accept foreign + // property name. + _relationPath = _myCQ.getRelationPath();// Accept relation path. + } + + //========================================================================== + // ========= + // Override about Register + // ======================= + @Override + protected void reflectRelationOnUnionQuery(ConditionQuery baseQueryAsSuper, + ConditionQuery unionQueryAsSuper) { + throw new UnsupportedOperationException( + "InlineQuery must not need UNION method: " + baseQueryAsSuper + + " : " + unionQueryAsSuper); + } + + @Override + protected void setupConditionValueAndRegisterWhereClause(ConditionKey key, + Object value, ConditionValue cvalue, String colName, + String capPropName, String uncapPropName) { + registerInlineQuery(key, value, cvalue, colName, capPropName, + uncapPropName); + } + + @Override + protected void setupConditionValueAndRegisterWhereClause(ConditionKey key, + Object value, ConditionValue cvalue, String colName, + String capPropName, String uncapPropName, ConditionOption option) { + registerInlineQuery(key, value, cvalue, colName, capPropName, + uncapPropName, option); + } + + @Override + protected void registerWhereClause(String whereClause) { + registerInlineWhereClause(whereClause); + } + + @Override + protected String getInScopeSubQueryRealColumnName(String columnName) { + if (_onClauseInline) { + throw new UnsupportedOperationException( + "InScopeSubQuery of on-clause is unsupported"); + } + return _onClauseInline ? getRealAliasName() + "." + columnName + : columnName; + } + + @Override + protected void registerExistsSubQuery(ConditionQuery subQuery, + String columnName, String relatedColumnName, String propertyName) { + throw new UnsupportedOperationException( + "Sorry! ExistsSubQuery at inline view is unsupported. So please use InScopeSubQyery."); + } + + //========================================================================== + // ========= + // Override about Query + // ==================== + protected ConditionValue getCValueId() { + return _myCQ.getId(); + } + + protected ConditionValue getCValueUserId() { + return _myCQ.getUserId(); + } + + public String keepUserId_InScopeSubQuery_UserInfo(UserInfoCQ subQuery) { + return _myCQ.keepUserId_InScopeSubQuery_UserInfo(subQuery); + } + + protected ConditionValue getCValueRoleId() { + return _myCQ.getRoleId(); + } + + public String keepRoleId_InScopeSubQuery_RoleInfo(RoleInfoCQ subQuery) { + return _myCQ.keepRoleId_InScopeSubQuery_RoleInfo(subQuery); + } + + protected String getConditionQueryClassNameInternally() { + return RoleMappingCQ.class.getName(); + } +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/RoleMappingCIQ.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/UserInfoCIQ.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/UserInfoCIQ.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/cq/ciq/UserInfoCIQ.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -6,7 +6,9 @@ import jp.sf.pal.userinfo.db.allcommon.cbean.cvalue.ConditionValue; import jp.sf.pal.userinfo.db.allcommon.cbean.sqlclause.SqlClause; import jp.sf.pal.userinfo.db.cbean.cq.GroupInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.RoleInfoCQ; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; import jp.sf.pal.userinfo.db.cbean.cq.UserInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.bs.AbstractBsUserInfoCQ; import jp.sf.pal.userinfo.db.cbean.cq.bs.BsUserInfoCQ; @@ -96,6 +98,62 @@ return _myCQ.getUserId(); } + public String keepUserId_InScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + return _myCQ.keepUserId_InScopeSubQuery_GroupMappingList(subQuery); + } + + public String keepUserId_InScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + return _myCQ.keepUserId_InScopeSubQuery_RoleMappingList(subQuery); + } + + public String keepUserId_NotInScopeSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + return _myCQ.keepUserId_NotInScopeSubQuery_GroupMappingList(subQuery); + } + + public String keepUserId_NotInScopeSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + return _myCQ.keepUserId_NotInScopeSubQuery_RoleMappingList(subQuery); + } + + public String keepUserId_ExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + throw new UnsupportedOperationException( + "ExistsSubQuery at inline() is unsupported! Sorry!"); + } + + public String keepUserId_ExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + throw new UnsupportedOperationException( + "ExistsSubQuery at inline() is unsupported! Sorry!"); + } + + public String keepUserId_NotExistsSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + throw new UnsupportedOperationException( + "NotExistsSubQuery at inline() is unsupported! Sorry!"); + } + + public String keepUserId_NotExistsSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + throw new UnsupportedOperationException( + "NotExistsSubQuery at inline() is unsupported! Sorry!"); + } + + public String keepUserId_DeriveSubQuery_GroupMappingList( + GroupMappingCQ subQuery) { + throw new UnsupportedOperationException( + "DeriveSubQuery at inline() is unsupported! Sorry!"); + } + + public String keepUserId_DeriveSubQuery_RoleMappingList( + RoleMappingCQ subQuery) { + throw new UnsupportedOperationException( + "DeriveSubQuery at inline() is unsupported! Sorry!"); + } + protected ConditionValue getCValueGivenName() { return _myCQ.getGivenName(); } Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/GroupMappingNss.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/GroupMappingNss.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/GroupMappingNss.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,50 @@ +package jp.sf.pal.userinfo.db.cbean.nss; + +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.cbean.cq.GroupMappingCQ; + +/** + * The nest-select-setupper of GROUP_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class GroupMappingNss { + + protected GroupMappingCQ _query; + + public GroupMappingNss(GroupMappingCQ query) { + _query = query; + } + + public boolean hasConditionQuery() { + return _query != null; + } + + //========================================================================== + // ========= + // With Nested Foreign Table + // ========================= + public GroupInfoNss withGroupInfo() { + _query.doNss(new GroupMappingCQ.NssCall() { + public ConditionQuery qf() { + return _query.queryGroupInfo(); + } + }); + return new GroupInfoNss(_query.queryGroupInfo()); + } + + public UserInfoNss withUserInfo() { + _query.doNss(new GroupMappingCQ.NssCall() { + public ConditionQuery qf() { + return _query.queryUserInfo(); + } + }); + return new UserInfoNss(_query.queryUserInfo()); + } + + //========================================================================== + // ========= + // With Nested Referrer Table + // ========================== +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/GroupMappingNss.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/RoleMappingNss.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/RoleMappingNss.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/RoleMappingNss.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,50 @@ +package jp.sf.pal.userinfo.db.cbean.nss; + +import jp.sf.pal.userinfo.db.allcommon.cbean.ConditionQuery; +import jp.sf.pal.userinfo.db.cbean.cq.RoleMappingCQ; + +/** + * The nest-select-setupper of ROLE_MAPPING. + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class RoleMappingNss { + + protected RoleMappingCQ _query; + + public RoleMappingNss(RoleMappingCQ query) { + _query = query; + } + + public boolean hasConditionQuery() { + return _query != null; + } + + //========================================================================== + // ========= + // With Nested Foreign Table + // ========================= + public RoleInfoNss withRoleInfo() { + _query.doNss(new RoleMappingCQ.NssCall() { + public ConditionQuery qf() { + return _query.queryRoleInfo(); + } + }); + return new RoleInfoNss(_query.queryRoleInfo()); + } + + public UserInfoNss withUserInfo() { + _query.doNss(new RoleMappingCQ.NssCall() { + public ConditionQuery qf() { + return _query.queryUserInfo(); + } + }); + return new UserInfoNss(_query.queryUserInfo()); + } + + //========================================================================== + // ========= + // With Nested Referrer Table + // ========================== +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/cbean/nss/RoleMappingNss.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/GroupMappingBhv.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/GroupMappingBhv.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/GroupMappingBhv.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,15 @@ +package jp.sf.pal.userinfo.db.exbhv; + +/** + * The behavior of GROUP_MAPPING. + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class GroupMappingBhv extends + jp.sf.pal.userinfo.db.bsbhv.BsGroupMappingBhv { +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/GroupMappingBhv.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/RoleMappingBhv.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/RoleMappingBhv.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/RoleMappingBhv.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,15 @@ +package jp.sf.pal.userinfo.db.exbhv; + +/** + * The behavior of ROLE_MAPPING. + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class RoleMappingBhv extends + jp.sf.pal.userinfo.db.bsbhv.BsRoleMappingBhv { +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exbhv/RoleMappingBhv.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/GroupMappingDao.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/GroupMappingDao.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/GroupMappingDao.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,15 @@ +package jp.sf.pal.userinfo.db.exdao; + +/** + * The dao interface of GROUP_MAPPING. <br /> + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public interface GroupMappingDao extends + jp.sf.pal.userinfo.db.bsdao.BsGroupMappingDao { +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/GroupMappingDao.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/RoleMappingDao.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/RoleMappingDao.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/RoleMappingDao.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,15 @@ +package jp.sf.pal.userinfo.db.exdao; + +/** + * The dao interface of ROLE_MAPPING. <br /> + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public interface RoleMappingDao extends + jp.sf.pal.userinfo.db.bsdao.BsRoleMappingDao { +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exdao/RoleMappingDao.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/GroupMapping.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/GroupMapping.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/GroupMapping.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,17 @@ +package jp.sf.pal.userinfo.db.exentity; + +/** + * The entity of GROUP_MAPPING. + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class GroupMapping extends jp.sf.pal.userinfo.db.bsentity.BsGroupMapping { + + /** Serial version UID. (Default) */ + private static final long serialVersionUID = 1L; +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/GroupMapping.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/RoleMapping.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/RoleMapping.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/RoleMapping.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,17 @@ +package jp.sf.pal.userinfo.db.exentity; + +/** + * The entity of ROLE_MAPPING. + * <p> + * You can implement your original methods here. This class is NOT overrided + * when re-generating. + * </p> + * + * @author DBFlute(AutoGenerator) + */ + @ SuppressWarnings("unchecked") +public class RoleMapping extends jp.sf.pal.userinfo.db.bsentity.BsRoleMapping { + + /** Serial version UID. (Default) */ + private static final long serialVersionUID = 1L; +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/db/exentity/RoleMapping.java ___________________________________________________________________ Name: svn:eol-style + native Added: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/form/ConfigForm.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/form/ConfigForm.java (rev 0) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/form/ConfigForm.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -0,0 +1,17 @@ +package jp.sf.pal.userinfo.form; + +import java.io.Serializable; + +import org.seasar.struts.annotation.Required; + +public class ConfigForm implements Serializable { + + private static final long serialVersionUID = 2108115319030589706L; + + @Required(target = "update") + public String roleAvailable; + + @Required(target = "update") + public String groupAvailable; + +} Property changes on: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/form/ConfigForm.java ___________________________________________________________________ Name: svn:eol-style + native Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/service/GroupInfoService.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/service/GroupInfoService.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/service/GroupInfoService.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -50,6 +50,20 @@ return groupInfoList; } + public List<GroupInfo> getGroupInfoList() { + + GroupInfoCB cb = new GroupInfoCB(); + + // setup + + cb.query().setDeletedBy_IsNull(); + + cb.query().addOrderBy_GroupId_Asc(); + + return groupInfoBhv.selectList(cb); + + } + public GroupInfo getGroupInfo(String groupId) { GroupInfoCB cb = new GroupInfoCB(); Modified: userinfo/trunk/src/main/java/jp/sf/pal/userinfo/service/RoleInfoService.java =================================================================== --- userinfo/trunk/src/main/java/jp/sf/pal/userinfo/service/RoleInfoService.java 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/java/jp/sf/pal/userinfo/service/RoleInfoService.java 2008-11-07 03:32:26 UTC (rev 1300) @@ -50,6 +50,19 @@ return roleInfoList; } + public List<RoleInfo> getRoleInfoList() { + + RoleInfoCB cb = new RoleInfoCB(); + + // setup + + cb.query().setDeletedBy_IsNull(); + + cb.query().addOrderBy_RoleId_Asc(); + + return roleInfoBhv.selectList(cb); + } + public RoleInfo getRoleInfo(String roleId) { RoleInfoCB cb = new RoleInfoCB(); Modified: userinfo/trunk/src/main/resources/dbflute.dicon =================================================================== --- userinfo/trunk/src/main/resources/dbflute.dicon 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/resources/dbflute.dicon 2008-11-07 03:32:26 UTC (rev 1300) @@ -48,12 +48,24 @@ </component> <component name="groupInfoBhv" class="jp.sf.pal.userinfo.db.exbhv.GroupInfoBhv"/> + <!-- GROUP_MAPPING --> + <component name="groupMappingDao" class="jp.sf.pal.userinfo.db.exdao.GroupMappingDao"> + <aspect>dbflute.interceptor</aspect> + </component> + <component name="groupMappingBhv" class="jp.sf.pal.userinfo.db.exbhv.GroupMappingBhv"/> + <!-- ROLE_INFO --> <component name="roleInfoDao" class="jp.sf.pal.userinfo.db.exdao.RoleInfoDao"> <aspect>dbflute.interceptor</aspect> </component> <component name="roleInfoBhv" class="jp.sf.pal.userinfo.db.exbhv.RoleInfoBhv"/> + <!-- ROLE_MAPPING --> + <component name="roleMappingDao" class="jp.sf.pal.userinfo.db.exdao.RoleMappingDao"> + <aspect>dbflute.interceptor</aspect> + </component> + <component name="roleMappingBhv" class="jp.sf.pal.userinfo.db.exbhv.RoleMappingBhv"/> + <!-- USER_INFO --> <component name="userInfoDao" class="jp.sf.pal.userinfo.db.exdao.UserInfoDao"> <aspect>dbflute.interceptor</aspect> Modified: userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.1.log.db =================================================================== (Binary files differ) Modified: userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.data.db =================================================================== (Binary files differ) Modified: userinfo/trunk/src/main/webapp/WEB-INF/db/userinfo.index.db =================================================================== (Binary files differ) Modified: userinfo/trunk/src/main/webapp/WEB-INF/userinfo.xml =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/userinfo.xml 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/userinfo.xml 2008-11-07 03:32:26 UTC (rev 1300) @@ -1,3 +1,7 @@ <?xml version="1.0" encoding="UTF-8"?> <configuration> +<features> +<role>true</role> +<group>true</group> +</features> </configuration> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/config/index.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/config/index.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/config/index.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -10,24 +10,26 @@ <div class="form-table"> <s:form> <table> - <caption>設定情報</caption> + <caption>Configuration</caption> <tbody> <tr> - <th>午前勤務開始時間</th> - <td><html:text property="amStartTime" size="5"/></td> + <th>Role</th> + <td> + <html:select property="roleAvailable"> + <html:option value="true">Enabled</html:option> + <html:option value="false">Disabled</html:option> + </html:select> + </td> </tr> <tr> - <th>午前勤務終了時間</th> - <td><html:text property="amEndTime" size="5"/></td> + <th>Group</th> + <td> + <html:select property="groupAvailable"> + <html:option value="true">Enabled</html:option> + <html:option value="false">Disabled</html:option> + </html:select> + </td> </tr> - <tr> - <th>午後勤務終了時間</th> - <td><html:text property="pmStartTime" size="5"/></td> - </tr> - <tr> - <th>午後勤務終了時間</th> - <td><html:text property="pmEndTime" size="5"/></td> - </tr> </tbody> <tfoot> <tr> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/confirm.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/confirm.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/confirm.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -10,9 +10,11 @@ <div class="tab-nav"> <ul> <li class="first"></li> - <li class="selectable"><s:link href="/userInfo/">User</s:link></li> + <li class="selectable"><s:link href="/userInfo/" style="text-decoration: none;">User</s:link></li> +<c:if test="${roleAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/roleInfo/">Role</s:link></li> + <li class="selectable"><s:link href="/roleInfo/" style="text-decoration: none;">Role</s:link></li> +</c:if> <li class="spacer"></li> <li class="selected"><span>Group</span></li> <li class="last"></li> @@ -22,15 +24,14 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div> <s:form> <html:hidden property="mode"/> - <div class="form-table"> + <div class="form-table" style="margin-top:3px;"> <table style="width: 400px;"> <caption>Confirmation of Group Info</caption> <tbody> <tr> - <th>Group ID</th> + <th style="width: 120px;">Group ID</th> <td>${f:h(groupId)}<html:hidden property="groupId"/></td> </tr> <tr> @@ -81,7 +82,6 @@ </div> </s:form> </div> -</div> </body> </html> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/edit.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/edit.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/edit.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -10,9 +10,11 @@ <div class="tab-nav"> <ul> <li class="first"></li> - <li class="selectable"><s:link href="/userInfo/">User</s:link></li> + <li class="selectable"><s:link href="/userInfo/" style="text-decoration: none;">User</s:link></li> +<c:if test="${roleAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/roleInfo/">Role</s:link></li> + <li class="selectable"><s:link href="/roleInfo/" style="text-decoration: none;">Role</s:link></li> +</c:if> <li class="spacer"></li> <li class="selected"><span>Group</span></li> <li class="last"></li> @@ -22,15 +24,14 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div> <s:form> <html:hidden property="mode"/> - <div class="form-table"> + <div class="form-table" style="margin-top:3px;"> <table style="width: 400px;"> <caption>Group Detail</caption> <tbody> <tr> - <th>Group ID</th> + <th style="width: 120px;">Group ID</th> <td><html:text property="groupId" size="20"/></td> </tr> <tr> @@ -66,7 +67,6 @@ </div> </s:form> </div> -</div> </body> </html> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/error.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/error.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/error.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -9,9 +9,11 @@ <div class="tab-nav"> <ul> <li class="first"></li> - <li class="selectable"><s:link href="/userInfo/">User</s:link></li> + <li class="selectable"><s:link href="/userInfo/" style="text-decoration: none;">User</s:link></li> +<c:if test="${roleAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/roleInfo/">Role</s:link></li> + <li class="selectable"><s:link href="/roleInfo/" style="text-decoration: none;">Role</s:link></li> +</c:if> <li class="spacer"></li> <li class="selected"><span>Group</span></li> <li class="last"></li> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/index.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/index.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/groupInfo/index.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -10,9 +10,11 @@ <div class="tab-nav"> <ul> <li class="first"></li> - <li class="selectable"><s:link href="/userInfo/">User</s:link></li> + <li class="selectable"><s:link href="/userInfo/" style="text-decoration: none;">User</s:link></li> +<c:if test="${roleAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/roleInfo/">Role</s:link></li> + <li class="selectable"><s:link href="/roleInfo/" style="text-decoration: none;">Role</s:link></li> +</c:if> <li class="spacer"></li> <li class="selected"><span>Group</span></li> <li class="last"></li> @@ -22,7 +24,7 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div class="list-table"> +<div class="list-table" style="margin-top:3px;"> <div> <s:link href="createpage">Create New Group</s:link> </div> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/confirm.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/confirm.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/confirm.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -10,11 +10,13 @@ <div class="tab-nav"> <ul> <li class="first"></li> - <li class="selectable"><s:link href="/userInfo/">User</s:link></li> + <li class="selectable"><s:link href="/userInfo/" style="text-decoration: none;">User</s:link></li> <li class="spacer"></li> <li class="selected"><span>Role</span></li> +<c:if test="${groupAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/groupInfo/">Group</s:link></li> + <li class="selectable"><s:link href="/groupInfo/" style="text-decoration: none;">Group</s:link></li> +</c:if> <li class="last"></li> </ul> </div> @@ -22,15 +24,14 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div> <s:form> <html:hidden property="mode"/> <div class="form-table"> - <table style="width: 400px;"> + <table style="width: 400px;" style="margin-top:3px;"> <caption>Confirmation of Role Info</caption> <tbody> <tr> - <th>Role ID</th> + <th style="width: 120px;">Role ID</th> <td>${f:h(roleId)}<html:hidden property="roleId"/></td> </tr> <tr> @@ -81,7 +82,6 @@ </div> </s:form> </div> -</div> </body> </html> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/edit.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/edit.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/edit.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -10,11 +10,13 @@ <div class="tab-nav"> <ul> <li class="first"></li> - <li class="selectable"><s:link href="/userInfo/">User</s:link></li> + <li class="selectable"><s:link href="/userInfo/" style="text-decoration: none;">User</s:link></li> <li class="spacer"></li> <li class="selected"><span>Role</span></li> +<c:if test="${groupAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/groupInfo/">Group</s:link></li> + <li class="selectable"><s:link href="/groupInfo/" style="text-decoration: none;">Group</s:link></li> +</c:if> <li class="last"></li> </ul> </div> @@ -22,15 +24,14 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div> <s:form> <html:hidden property="mode"/> - <div class="form-table"> + <div class="form-table" style="margin-top:3px;"> <table style="width: 400px;"> <caption>Role Detail</caption> <tbody> <tr> - <th>Role ID</th> + <th style="width: 120px;">Role ID</th> <td><html:text property="roleId" size="20"/></td> </tr> <tr> @@ -66,7 +67,6 @@ </div> </s:form> </div> -</div> </body> </html> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/error.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/error.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/error.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -9,11 +9,13 @@ <div class="tab-nav"> <ul> <li class="first"></li> - <li class="selectable"><s:link href="/userInfo/">User</s:link></li> + <li class="selectable"><s:link href="/userInfo/" style="text-decoration: none;">User</s:link></li> <li class="spacer"></li> <li class="selected"><span>Role</span></li> +<c:if test="${groupAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/groupInfo/">Group</s:link></li> + <li class="selectable"><s:link href="/groupInfo/" style="text-decoration: none;">Group</s:link></li> +</c:if> <li class="last"></li> </ul> </div> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/index.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/index.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/roleInfo/index.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -10,11 +10,13 @@ <div class="tab-nav"> <ul> <li class="first"></li> - <li class="selectable"><s:link href="/userInfo/">User</s:link></li> + <li class="selectable"><s:link href="/userInfo/" style="text-decoration: none;">User</s:link></li> <li class="spacer"></li> <li class="selected"><span>Role</span></li> +<c:if test="${groupAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/groupInfo/">Group</s:link></li> + <li class="selectable"><s:link href="/groupInfo/" style="text-decoration: none;">Group</s:link></li> +</c:if> <li class="last"></li> </ul> </div> @@ -22,7 +24,7 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div class="list-table"> +<div class="list-table" style="margin-top:3px;"> <div> <s:link href="createpage">Create New Role</s:link> </div> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/confirm.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/confirm.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/confirm.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -11,10 +11,14 @@ <ul> <li class="first"></li> <li class="selected"><span>User</span></li> +<c:if test="${roleAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/roleInfo/">Role</s:link></li> + <li class="selectable"><s:link href="/roleInfo/" style="text-decoration: none;">Role</s:link></li> +</c:if> +<c:if test="${groupAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/groupInfo/">Group</s:link></li> + <li class="selectable"><s:link href="/groupInfo/" style="text-decoration: none;">Group</s:link></li> +</c:if> <li class="last"></li> </ul> </div> @@ -22,15 +26,14 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div> <s:form> <html:hidden property="mode"/> - <div class="form-table"> + <div class="form-table" style="margin-top:3px;"> <table style="width: 400px;"> <caption>Confirmation of User Info</caption> <tbody> <tr> - <th>User ID</th> + <th style="width: 120px;">User ID</th> <td>${f:h(userId)}<html:hidden property="userId"/></td> </tr> <tr> @@ -65,22 +68,30 @@ <th>Telephone Number</th> <td>${f:h(telephone)}<html:hidden property="telephone"/></td> </tr> +<c:if test="${roleAvailable}"> <tr> <th>Role</th> <td> - <!-- TODO: Pull-down --> -<c:if test="${isAvailable==''}">None</c:if> +<c:forEach var="r" varStatus="s" items="${roleInfoItems}"> + <c:if test="${roleId==r.roleId}">${f:h(r.name)}</c:if> +</c:forEach> +<c:if test="${roleId==''}">None</c:if> <html:hidden property="roleId"/> </td> </tr> +</c:if> +<c:if test="${groupAvailable}"> <tr> <th>Group</th> <td> - <!-- TODO: Pull-down --> -<c:if test="${isAvailable==''}">None</c:if> +<c:forEach var="g" varStatus="s" items="${groupInfoItems}"> + <c:if test="${groupId==g.groupId}">${f:h(g.name)}</c:if> +</c:forEach> +<c:if test="${groupId==''}">None</c:if> <html:hidden property="groupId"/> </td> </tr> +</c:if> </tbody> <tfoot> <tr> @@ -109,7 +120,6 @@ </div> </s:form> </div> -</div> </body> </html> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/edit.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/edit.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/edit.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -11,10 +11,14 @@ <ul> <li class="first"></li> <li class="selected"><span>User</span></li> +<c:if test="${roleAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/roleInfo/">Role</s:link></li> + <li class="selectable"><s:link href="/roleInfo/" style="text-decoration: none;">Role</s:link></li> +</c:if> +<c:if test="${groupAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/groupInfo/">Group</s:link></li> + <li class="selectable"><s:link href="/groupInfo/" style="text-decoration: none;">Group</s:link></li> +</c:if> <li class="last"></li> </ul> </div> @@ -22,15 +26,14 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div> <s:form> <html:hidden property="mode"/> - <div class="form-table"> + <div class="form-table" style="margin-top:3px;"> <table style="width: 400px;"> <caption>User Detail</caption> <tbody> <tr> - <th>User ID</th> + <th style="width: 120px;">User ID</th> <td><html:text property="userId" size="20"/></td> </tr> <tr> @@ -65,24 +68,32 @@ <th>Telephone Number</th> <td><html:text property="telephone" size="20"/></td> </tr> +<c:if test="${roleAvailable}"> <tr> - <th>Role</th> + <th>Default Role</th> <td> - <!-- TODO: Pull-down --> <html:select property="roleId"> <option value="">None</option> + <c:forEach var="r" varStatus="s" items="${roleInfoItems}"> + <html:option value="${f:h(r.roleId)}">${f:h(r.name)}</html:option> + </c:forEach> </html:select> </td> </tr> +</c:if> +<c:if test="${groupAvailable}"> <tr> - <th>Group</th> + <th>Default Group</th> <td> - <!-- TODO: Pull-down --> <html:select property="groupId"> <option value="">None</option> + <c:forEach var="g" varStatus="s" items="${groupInfoItems}"> + <html:option value="${f:h(g.groupId)}">${f:h(g.name)}</html:option> + </c:forEach> </html:select> </td> </tr> +</c:if> </tbody> <tfoot> <tr> @@ -96,7 +107,6 @@ </div> </s:form> </div> -</div> </body> </html> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/error.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/error.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/error.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -10,10 +10,14 @@ <ul> <li class="first"></li> <li class="selected"><span>User</span></li> +<c:if test="${roleAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/roleInfo/">Role</s:link></li> + <li class="selectable"><s:link href="/roleInfo/" style="text-decoration: none;">Role</s:link></li> +</c:if> +<c:if test="${groupAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/groupInfo/">Group</s:link></li> + <li class="selectable"><s:link href="/groupInfo/" style="text-decoration: none;">Group</s:link></li> +</c:if> <li class="last"></li> </ul> </div> Modified: userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/index.jsp =================================================================== --- userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/index.jsp 2008-11-07 00:42:13 UTC (rev 1299) +++ userinfo/trunk/src/main/webapp/WEB-INF/view/userInfo/index.jsp 2008-11-07 03:32:26 UTC (rev 1300) @@ -11,10 +11,14 @@ <ul> <li class="first"></li> <li class="selected"><span>User</span></li> +<c:if test="${roleAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/roleInfo/">Role</s:link></li> + <li class="selectable"><s:link href="/roleInfo/" style="text-decoration: none;">Role</s:link></li> +</c:if> +<c:if test="${groupAvailable}"> <li class="spacer"></li> - <li class="selectable"><s:link href="/groupInfo/">Group</s:link></li> + <li class="selectable"><s:link href="/groupInfo/" style="text-decoration: none;">Group</s:link></li> +</c:if> <li class="last"></li> </ul> </div> @@ -22,7 +26,7 @@ <div><html:messages id="msg" message="true"><bean:write name="msg" ignore="true"/></html:messages><html:errors/></div> -<div class="list-table"> +<div class="list-table" style="margin-top:3px;"> <div> <s:link href="createpage">Create New User</s:link> </div>