You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Iwao AVE! (JIRA)" <ib...@incubator.apache.org> on 2009/01/24 15:54:59 UTC
[jira] Created: (IBATIS-577) Ibator: Define column list as 'sql'
fragment for better reusability.
Ibator: Define column list as 'sql' fragment for better reusability.
--------------------------------------------------------------------
Key: IBATIS-577
URL: https://issues.apache.org/jira/browse/IBATIS-577
Project: iBatis for Java
Issue Type: Improvement
Components: Tools
Reporter: Iwao AVE!
Priority: Minor
So, it would look like...
<sql id="ibatorgenerated_columnsWithBLOBs">
column_a, column_b, column_c
</sql>
<select id="ibatorgenerated_selectByExample" parameterClass="xxx" resultMap="ibatorgenerated_BaseResultMap">
select
<include refid="table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
from table_name
...
Then, when I add a new custom query, I can write as follows.
<resultMap id="custom_resultMap" ...>
<result property="table_name" resultMap="table_name.ibatorgenerated_BaseResultMap" />
<result property="another_table_name" resultMap="another_table_name.ibatorgenerated_BaseResultMap" />
</resultMap>
<select id="custom_selectByExample" ...>
select
<include refid="table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
,
<include refid="another_table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
from table_name
left join another_table_name on ....
...
</select>
This would save us from modifying sqlmap manually when a new column is added to a table, for example.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (IBATIS-577) Ibator: Define column list as 'sql'
fragment for better reusability.
Posted by "Jeff Butler (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATIS-577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Butler closed IBATIS-577.
------------------------------
Resolution: Fixed
Fixed in SVN.
Thanks for the idea!
> Ibator: Define column list as 'sql' fragment for better reusability.
> --------------------------------------------------------------------
>
> Key: IBATIS-577
> URL: https://issues.apache.org/jira/browse/IBATIS-577
> Project: iBatis for Java
> Issue Type: Improvement
> Components: Tools
> Reporter: Iwao AVE!
> Assignee: Jeff Butler
> Priority: Minor
> Attachments: IBATIS-577.patch
>
>
> So, it would look like...
> <sql id="ibatorgenerated_columnsWithBLOBs">
> column_a, column_b, column_c
> </sql>
> <select id="ibatorgenerated_selectByExample" parameterClass="xxx" resultMap="ibatorgenerated_BaseResultMap">
> select
> <include refid="table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
> from table_name
> ...
> Then, when I add a new custom query, I can write as follows.
> <resultMap id="custom_resultMap" ...>
> <result property="table_name" resultMap="table_name.ibatorgenerated_BaseResultMap" />
> <result property="another_table_name" resultMap="another_table_name.ibatorgenerated_BaseResultMap" />
> </resultMap>
> <select id="custom_selectByExample" ...>
> select
> <include refid="table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
> ,
> <include refid="another_table_name.ibatorgenerated_ColumnsWithoutBLOBs" />
> from table_name
> left join another_table_name on ....
> ...
> </select>
> This would save us from modifying sqlmap manually when a new column is added to a table, for example.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.