OSDN Git Service

Access対応中
authortaktos9 <taktos9@136db618-7844-41ca-8ac1-fb3fd040db1d>
Tue, 14 Oct 2008 11:30:46 +0000 (11:30 +0000)
committertaktos9 <taktos9@136db618-7844-41ca-8ac1-fb3fd040db1d>
Tue, 14 Oct 2008 11:30:46 +0000 (11:30 +0000)
git-svn-id: http://svn.sourceforge.jp/svnroot/ea2ddl/trunk/ea2ddl@17 136db618-7844-41ca-8ac1-fb3fd040db1d

ea2ddl-dao/pom.xml
ea2ddl-dao/src/main/java/jp/sourceforge/ea2ddl/dao/bsbhv/BsTConnectorBhv.java
ea2ddl-dao/src/main/resources/jp/sourceforge/ea2ddl/dao/exbhv/TConnectorBhv_selectForeignKeys.sql [new file with mode: 0644]

index e5c53aa..5eb6857 100644 (file)
@@ -10,7 +10,6 @@
        <groupId>jp.sourceforge.ea2ddl</groupId>
        <artifactId>ea2ddl-dao</artifactId>
        <name>ea2ddl-dao</name>
-       <version>0.0.1-SNAPSHOT</version>
        <url>http://ea2ddl.sourceforge.jp/</url>
 
        <dependencies>
index cf85612..ed788aa 100644 (file)
-package jp.sourceforge.ea2ddl.dao.bsbhv;\r
-\r
-\r
-import java.util.List;\r
-\r
-import jp.sourceforge.ea2ddl.dao.allcommon.*;\r
-import jp.sourceforge.ea2ddl.dao.allcommon.bhv.setup.ValueLabelSetupper;\r
-import jp.sourceforge.ea2ddl.dao.allcommon.cbean.ConditionBean;\r
-import jp.sourceforge.ea2ddl.dao.allcommon.cbean.ListResultBean;\r
-import jp.sourceforge.ea2ddl.dao.allcommon.cbean.PagingHandler;\r
-import jp.sourceforge.ea2ddl.dao.allcommon.cbean.PagingInvoker;\r
-import jp.sourceforge.ea2ddl.dao.allcommon.cbean.PagingBean;\r
-import jp.sourceforge.ea2ddl.dao.allcommon.cbean.PagingResultBean;\r
-import jp.sourceforge.ea2ddl.dao.allcommon.dbmeta.DBMeta;\r
-import jp.sourceforge.ea2ddl.dao.exdao.*;\r
-import jp.sourceforge.ea2ddl.dao.exentity.*;\r
-import jp.sourceforge.ea2ddl.dao.bsentity.dbmeta.*;\r
-import jp.sourceforge.ea2ddl.dao.cbean.*;\r
-\r
-\r
-/**\r
- * The behavior of t_connector.\r
- * <pre>\r
- * [primary-key]\r
- *     \r
- * \r
- * [column]\r
- *     Connector_ID, Name, Direction, Notes, Connector_Type, SubType, SourceCard, SourceAccess, SourceElement, DestCard, DestAccess, DestElement, SourceRole, SourceRoleType, SourceRoleNote, SourceContainment, SourceIsAggregate, SourceIsOrdered, SourceQualifier, DestRole, DestRoleType, DestRoleNote, DestContainment, DestIsAggregate, DestIsOrdered, DestQualifier, Start_Object_ID, End_Object_ID, Top_Start_Label, Top_Mid_Label, Top_End_Label, Btm_Start_Label, Btm_Mid_Label, Btm_End_Label, Start_Edge, End_Edge, PtStartX, PtStartY, PtEndX, PtEndY, SeqNo, HeadStyle, LineStyle, RouteStyle, IsBold, LineColor, Stereotype, VirtualInheritance, LinkAccess, PDATA1, PDATA2, PDATA3, PDATA4, PDATA5, DiagramID, ea_guid, SourceConstraint, DestConstraint, SourceIsNavigable, DestIsNavigable, IsRoot, IsLeaf, IsSpec, SourceChangeable, DestChangeable, SourceTS, DestTS, StateFlags, ActionFlags, IsSignal, IsStimulus, DispatchAction, Target2, StyleEx, SourceStereotype, DestStereotype, SourceStyle, DestStyle, EventFlags\r
- * \r
- * [sequence]\r
- *     \r
- * \r
- * [identity]\r
- *     \r
- * \r
- * [version-no]\r
- *     \r
- * \r
- * [foreign-table]\r
- *     \r
- * \r
- * [referrer-table]\r
- *     \r
- * \r
- * [foreign-property]\r
- *     \r
- * \r
- * [referrer-property]\r
- *     \r
- * </pre>\r
- * @author DBFlute(AutoGenerator)\r
- */\r
-public abstract class BsTConnectorBhv extends jp.sourceforge.ea2ddl.dao.allcommon.bhv.AbstractBehaviorReadable {\r
-\r
-    // ===================================================================================\r
-    //                                                                          Definition\r
-    //                                                                          ==========\r
-    /*df:BehaviorQueryPathBegin*/\r
-    /*df:BehaviorQueryPathEnd*/\r
-\r
-    // ===================================================================================\r
-    //                                                                           Attribute\r
-    //                                                                           =========\r
-    protected TConnectorDao _dao;\r
-\r
-    // ===================================================================================\r
-    //                                                                          Table name\r
-    //                                                                          ==========\r
-    /** @return The name on database of table. (NotNull) */\r
-    public String getTableDbName() { return "t_connector"; }\r
-\r
-    // ===================================================================================\r
-    //                                                                              DBMeta\r
-    //                                                                              ======\r
-    /** @return The meta data of the database. (NotNull) */\r
-    public DBMeta getDBMeta() { return TConnectorDbm.getInstance(); }\r
-\r
-    /** @return The meta data of the database as my table type. (NotNull) */\r
-    public TConnectorDbm getMyDBMeta() { return TConnectorDbm.getInstance(); }\r
-\r
-    // ===================================================================================\r
-    //                                                                        Dao Accessor\r
-    //                                                                        ============\r
-    public TConnectorDao getMyDao() { return _dao; }\r
-    public void setMyDao(TConnectorDao dao) { assertObjectNotNull("dao", dao); _dao = dao; }\r
-    public DaoReadable getDaoReadable() { return getMyDao(); }\r
-\r
-    // ===================================================================================\r
-    //                                                                        New Instance\r
-    //                                                                        ============\r
-    public Entity newEntity() { return newMyEntity(); }\r
-    public ConditionBean newConditionBean() { return newMyConditionBean(); }\r
-    public TConnector newMyEntity() { return new TConnector(); }\r
-    public TConnectorCB newMyConditionBean() { return new TConnectorCB(); }\r
-\r
-    // ===================================================================================\r
-    //                                                                        Count Select\r
-    //                                                                        ============\r
-    /**\r
-     * Select the count of the condition-bean. {IgnorePagingCondition}\r
-     * @param cb The condition-bean of TConnector. (NotNull)\r
-     * @return The selected count.\r
-     */\r
-    public int selectCount(TConnectorCB cb) {\r
-        assertConditionBeanNotNull(cb);\r
-        return delegateSelectCount(cb);\r
-    }\r
-\r
-    // ===================================================================================\r
-    //                                                                       Entity Select\r
-    //                                                                       =============\r
-    /**\r
-     * Select the entity by the condition-bean.\r
-     * @param cb The condition-bean of TConnector. (NotNull)\r
-     * @return The selected entity. (Nullalble)\r
-     * @exception jp.sourceforge.ea2ddl.dao.allcommon.exception.EntityDuplicatedException When the entity has been duplicated.\r
-     */\r
-    public TConnector selectEntity(final TConnectorCB cb) {\r
-        return helpSelectEntityInternally(cb, new InternalSelectEntityCallback<TConnector, TConnectorCB>() {\r
-            public List<TConnector> callbackSelectList(TConnectorCB cb) { return selectList(cb); } });\r
-    }\r
-\r
-    /**\r
-     * Select the entity by the condition-bean with deleted check.\r
-     * @param cb The condition-bean of TConnector. (NotNull)\r
-     * @return The selected entity. (NotNull)\r
-     * @exception jp.sourceforge.ea2ddl.dao.allcommon.exception.EntityAlreadyDeletedException When the entity has already been deleted.\r
-     * @exception jp.sourceforge.ea2ddl.dao.allcommon.exception.EntityDuplicatedException When the entity has been duplicated.\r
-     */\r
-    public TConnector selectEntityWithDeletedCheck(final TConnectorCB cb) {\r
-        return helpSelectEntityWithDeletedCheckInternally(cb, new InternalSelectEntityWithDeletedCheckCallback<TConnector, TConnectorCB>() {\r
-            public List<TConnector> callbackSelectList(TConnectorCB cb) { return selectList(cb); } });\r
-    }\r
-\r
-\r
-    // ===================================================================================\r
-    //                                                                         List Select\r
-    //                                                                         ===========\r
-    /**\r
-     * Select the list as result-bean.\r
-     * @param cb The condition-bean of TConnector. (NotNull)\r
-     * @return The result-bean of selected list. (NotNull)\r
-     */\r
-    public ListResultBean<TConnector> selectList(TConnectorCB cb) {\r
-        assertConditionBeanNotNull(cb);\r
-        return new jp.sourceforge.ea2ddl.dao.allcommon.cbean.ResultBeanBuilder<TConnector>(getTableDbName()).buildListResultBean(cb, delegateSelectList(cb));\r
-    }\r
-\r
-    // ===================================================================================\r
-    //                                                                         Page Select\r
-    //                                                                         ===========\r
-    /**\r
-     * Select the page as result-bean.\r
-     * @param cb The condition-bean of TConnector. (NotNull)\r
-     * @return The result-bean of selected page. (NotNull)\r
-     */\r
-    public PagingResultBean<TConnector> selectPage(final TConnectorCB cb) {\r
-        assertConditionBeanNotNull(cb);\r
-        final PagingInvoker<TConnector> invoker = new PagingInvoker<TConnector>(getTableDbName());\r
-        final PagingHandler<TConnector> handler = new PagingHandler<TConnector>() {\r
-            public PagingBean getPagingBean() { return cb; }\r
-            public int count() { return selectCount(cb); }\r
-            public List<TConnector> paging() { return selectList(cb); }\r
-        };\r
-        return invoker.invokePaging(handler);\r
-    }\r
-\r
-    // ===================================================================================\r
-    //                                                                      Various Select\r
-    //                                                                      ==============\r
-    /**\r
-     * Select the list of value-label.\r
-     * @param cb The condition-bean of TConnector. (NotNull)\r
-     * @param valueLabelSetupper The setupper of value-label. (NotNull)\r
-     * @return The list of value-label. (NotNull)\r
-     */\r
-    public List<java.util.Map<String, Object>> selectValueLabelList(TConnectorCB cb, ValueLabelSetupper<TConnector> valueLabelSetupper) {\r
-        return createValueLabelList(selectList(cb), valueLabelSetupper);\r
-    }\r
-\r
-\r
-\r
-    // ===================================================================================\r
-    //                                                                     Pullout Foreign\r
-    //                                                                     ===============\r
-  \r
-    // ===================================================================================\r
-    //                                                                     Delegate Method\r
-    //                                                                     ===============\r
-    // -----------------------------------------------------\r
-    //                                                Select\r
-    //                                                ------\r
-    protected int delegateSelectCount(TConnectorCB cb) { assertConditionBeanNotNull(cb); return getMyDao().selectCount(cb); }\r
-    protected List<TConnector> delegateSelectList(TConnectorCB cb) { assertConditionBeanNotNull(cb); return getMyDao().selectList(cb); }\r
-\r
-    // ===================================================================================\r
-    //                                                                Optimistic Lock Info\r
-    //                                                                ====================\r
-    @Override\r
-    protected boolean hasVersionNoValue(Entity entity) {\r
-        return false;\r
-    }\r
-\r
-    @Override\r
-    protected boolean hasUpdateDateValue(Entity entity) {\r
-        return false;\r
-    }\r
-\r
-    // ===================================================================================\r
-    //                                                                              Helper\r
-    //                                                                              ======\r
-    protected TConnector downcast(Entity entity) {\r
-        return helpDowncastInternally(entity, TConnector.class);\r
-    }\r
-}\r
+package jp.sourceforge.ea2ddl.dao.bsbhv;
+
+
+import java.util.List;
+
+import jp.sourceforge.ea2ddl.dao.allcommon.*;
+import jp.sourceforge.ea2ddl.dao.allcommon.bhv.setup.ValueLabelSetupper;
+import jp.sourceforge.ea2ddl.dao.allcommon.cbean.ConditionBean;
+import jp.sourceforge.ea2ddl.dao.allcommon.cbean.ListResultBean;
+import jp.sourceforge.ea2ddl.dao.allcommon.cbean.PagingHandler;
+import jp.sourceforge.ea2ddl.dao.allcommon.cbean.PagingInvoker;
+import jp.sourceforge.ea2ddl.dao.allcommon.cbean.PagingBean;
+import jp.sourceforge.ea2ddl.dao.allcommon.cbean.PagingResultBean;
+import jp.sourceforge.ea2ddl.dao.allcommon.dbmeta.DBMeta;
+import jp.sourceforge.ea2ddl.dao.exdao.*;
+import jp.sourceforge.ea2ddl.dao.exentity.*;
+import jp.sourceforge.ea2ddl.dao.bsentity.dbmeta.*;
+import jp.sourceforge.ea2ddl.dao.cbean.*;
+
+
+/**
+ * The behavior of t_connector.
+ * <pre>
+ * [primary-key]
+ *     
+ * 
+ * [column]
+ *     Connector_ID, Name, Direction, Notes, Connector_Type, SubType, SourceCard, SourceAccess, SourceElement, DestCard, DestAccess, DestElement, SourceRole, SourceRoleType, SourceRoleNote, SourceContainment, SourceIsAggregate, SourceIsOrdered, SourceQualifier, DestRole, DestRoleType, DestRoleNote, DestContainment, DestIsAggregate, DestIsOrdered, DestQualifier, Start_Object_ID, End_Object_ID, Top_Start_Label, Top_Mid_Label, Top_End_Label, Btm_Start_Label, Btm_Mid_Label, Btm_End_Label, Start_Edge, End_Edge, PtStartX, PtStartY, PtEndX, PtEndY, SeqNo, HeadStyle, LineStyle, RouteStyle, IsBold, LineColor, Stereotype, VirtualInheritance, LinkAccess, PDATA1, PDATA2, PDATA3, PDATA4, PDATA5, DiagramID, ea_guid, SourceConstraint, DestConstraint, SourceIsNavigable, DestIsNavigable, IsRoot, IsLeaf, IsSpec, SourceChangeable, DestChangeable, SourceTS, DestTS, StateFlags, ActionFlags, IsSignal, IsStimulus, DispatchAction, Target2, StyleEx, SourceStereotype, DestStereotype, SourceStyle, DestStyle, EventFlags
+ * 
+ * [sequence]
+ *     
+ * 
+ * [identity]
+ *     
+ * 
+ * [version-no]
+ *     
+ * 
+ * [foreign-table]
+ *     
+ * 
+ * [referrer-table]
+ *     
+ * 
+ * [foreign-property]
+ *     
+ * 
+ * [referrer-property]
+ *     
+ * </pre>
+ * @author DBFlute(AutoGenerator)
+ */
+public abstract class BsTConnectorBhv extends jp.sourceforge.ea2ddl.dao.allcommon.bhv.AbstractBehaviorReadable {
+
+    // ===================================================================================
+    //                                                                          Definition
+    //                                                                          ==========
+    /*df:BehaviorQueryPathBegin*/
+    public static final String PATH_selectForeignKeys = "selectForeignKeys";
+    /*df:BehaviorQueryPathEnd*/
+
+    // ===================================================================================
+    //                                                                           Attribute
+    //                                                                           =========
+    protected TConnectorDao _dao;
+
+    // ===================================================================================
+    //                                                                          Table name
+    //                                                                          ==========
+    /** @return The name on database of table. (NotNull) */
+    public String getTableDbName() { return "t_connector"; }
+
+    // ===================================================================================
+    //                                                                              DBMeta
+    //                                                                              ======
+    /** @return The meta data of the database. (NotNull) */
+    public DBMeta getDBMeta() { return TConnectorDbm.getInstance(); }
+
+    /** @return The meta data of the database as my table type. (NotNull) */
+    public TConnectorDbm getMyDBMeta() { return TConnectorDbm.getInstance(); }
+
+    // ===================================================================================
+    //                                                                        Dao Accessor
+    //                                                                        ============
+    public TConnectorDao getMyDao() { return _dao; }
+    public void setMyDao(TConnectorDao dao) { assertObjectNotNull("dao", dao); _dao = dao; }
+    public DaoReadable getDaoReadable() { return getMyDao(); }
+
+    // ===================================================================================
+    //                                                                        New Instance
+    //                                                                        ============
+    public Entity newEntity() { return newMyEntity(); }
+    public ConditionBean newConditionBean() { return newMyConditionBean(); }
+    public TConnector newMyEntity() { return new TConnector(); }
+    public TConnectorCB newMyConditionBean() { return new TConnectorCB(); }
+
+    // ===================================================================================
+    //                                                                        Count Select
+    //                                                                        ============
+    /**
+     * Select the count of the condition-bean. {IgnorePagingCondition}
+     * @param cb The condition-bean of TConnector. (NotNull)
+     * @return The selected count.
+     */
+    public int selectCount(TConnectorCB cb) {
+        assertConditionBeanNotNull(cb);
+        return delegateSelectCount(cb);
+    }
+
+    // ===================================================================================
+    //                                                                       Entity Select
+    //                                                                       =============
+    /**
+     * Select the entity by the condition-bean.
+     * @param cb The condition-bean of TConnector. (NotNull)
+     * @return The selected entity. (Nullalble)
+     * @exception jp.sourceforge.ea2ddl.dao.allcommon.exception.EntityDuplicatedException When the entity has been duplicated.
+     */
+    public TConnector selectEntity(final TConnectorCB cb) {
+        return helpSelectEntityInternally(cb, new InternalSelectEntityCallback<TConnector, TConnectorCB>() {
+            public List<TConnector> callbackSelectList(TConnectorCB cb) { return selectList(cb); } });
+    }
+
+    /**
+     * Select the entity by the condition-bean with deleted check.
+     * @param cb The condition-bean of TConnector. (NotNull)
+     * @return The selected entity. (NotNull)
+     * @exception jp.sourceforge.ea2ddl.dao.allcommon.exception.EntityAlreadyDeletedException When the entity has already been deleted.
+     * @exception jp.sourceforge.ea2ddl.dao.allcommon.exception.EntityDuplicatedException When the entity has been duplicated.
+     */
+    public TConnector selectEntityWithDeletedCheck(final TConnectorCB cb) {
+        return helpSelectEntityWithDeletedCheckInternally(cb, new InternalSelectEntityWithDeletedCheckCallback<TConnector, TConnectorCB>() {
+            public List<TConnector> callbackSelectList(TConnectorCB cb) { return selectList(cb); } });
+    }
+
+
+    // ===================================================================================
+    //                                                                         List Select
+    //                                                                         ===========
+    /**
+     * Select the list as result-bean.
+     * @param cb The condition-bean of TConnector. (NotNull)
+     * @return The result-bean of selected list. (NotNull)
+     */
+    public ListResultBean<TConnector> selectList(TConnectorCB cb) {
+        assertConditionBeanNotNull(cb);
+        return new jp.sourceforge.ea2ddl.dao.allcommon.cbean.ResultBeanBuilder<TConnector>(getTableDbName()).buildListResultBean(cb, delegateSelectList(cb));
+    }
+
+    // ===================================================================================
+    //                                                                         Page Select
+    //                                                                         ===========
+    /**
+     * Select the page as result-bean.
+     * @param cb The condition-bean of TConnector. (NotNull)
+     * @return The result-bean of selected page. (NotNull)
+     */
+    public PagingResultBean<TConnector> selectPage(final TConnectorCB cb) {
+        assertConditionBeanNotNull(cb);
+        final PagingInvoker<TConnector> invoker = new PagingInvoker<TConnector>(getTableDbName());
+        final PagingHandler<TConnector> handler = new PagingHandler<TConnector>() {
+            public PagingBean getPagingBean() { return cb; }
+            public int count() { return selectCount(cb); }
+            public List<TConnector> paging() { return selectList(cb); }
+        };
+        return invoker.invokePaging(handler);
+    }
+
+    // ===================================================================================
+    //                                                                      Various Select
+    //                                                                      ==============
+    /**
+     * Select the list of value-label.
+     * @param cb The condition-bean of TConnector. (NotNull)
+     * @param valueLabelSetupper The setupper of value-label. (NotNull)
+     * @return The list of value-label. (NotNull)
+     */
+    public List<java.util.Map<String, Object>> selectValueLabelList(TConnectorCB cb, ValueLabelSetupper<TConnector> valueLabelSetupper) {
+        return createValueLabelList(selectList(cb), valueLabelSetupper);
+    }
+
+
+
+    // ===================================================================================
+    //                                                                     Pullout Foreign
+    //                                                                     ===============
+  
+    // ===================================================================================
+    //                                                                     Delegate Method
+    //                                                                     ===============
+    // -----------------------------------------------------
+    //                                                Select
+    //                                                ------
+    protected int delegateSelectCount(TConnectorCB cb) { assertConditionBeanNotNull(cb); return getMyDao().selectCount(cb); }
+    protected List<TConnector> delegateSelectList(TConnectorCB cb) { assertConditionBeanNotNull(cb); return getMyDao().selectList(cb); }
+
+    // ===================================================================================
+    //                                                                Optimistic Lock Info
+    //                                                                ====================
+    @Override
+    protected boolean hasVersionNoValue(Entity entity) {
+        return false;
+    }
+
+    @Override
+    protected boolean hasUpdateDateValue(Entity entity) {
+        return false;
+    }
+
+    // ===================================================================================
+    //                                                                              Helper
+    //                                                                              ======
+    protected TConnector downcast(Entity entity) {
+        return helpDowncastInternally(entity, TConnector.class);
+    }
+}
diff --git a/ea2ddl-dao/src/main/resources/jp/sourceforge/ea2ddl/dao/exbhv/TConnectorBhv_selectForeignKeys.sql b/ea2ddl-dao/src/main/resources/jp/sourceforge/ea2ddl/dao/exbhv/TConnectorBhv_selectForeignKeys.sql
new file mode 100644 (file)
index 0000000..4333ce1
--- /dev/null
@@ -0,0 +1,16 @@
+SELECT\r
+    CON.Connector_ID, CON.Start_Object_ID, START_OBJ.Name, OPE_SRC.Name\r
+  , CON.End_Object_ID, END_OBJ.Name, OPE_DST.Name, PARAM_SRC.Name\r
+  , PARAM_DST.Name\r
+  -- , PARAM_DST.Object_ID\r
+FROM\r
+    (T_OPERATIONPARAMS AS PARAM_SRC\r
+INNER JOIN ((((T_CONNECTOR AS CON\r
+INNER JOIN T_OBJECT AS START_OBJ          ON CON.Start_Object_ID = START_OBJ.Object_ID)\r
+INNER JOIN T_OBJECT AS END_OBJ            ON CON.End_Object_ID = END_OBJ.Object_ID)\r
+INNER JOIN T_OPERATION AS OPE_SRC         ON CON.SourceRole = OPE_SRC.Name)\r
+INNER JOIN T_OPERATION AS OPE_DST         ON CON.DestRole = OPE_DST.Name) ON PARAM_SRC.OperationID = OPE_SRC.OperationID)\r
+INNER JOIN T_OPERATIONPARAMS AS PARAM_DST ON OPE_DST.OperationID = PARAM_DST.OperationID\r
+where\r
+    CON.Start_Object_ID = /*objectId*/31\r
+-- ForeignKey
\ No newline at end of file