Reuse of statement in an other statement

[Régis BRULEY]

Hi,

It's my first post in this mail-list ... so hi everybody.

I writing this mail, because I don't know if it's possible to reuse some previous statements in an other statement ? ...

Let me explain myself :

I have a class UniverseFilter which is mapped. Every thing works.
I have an class UniverseDefinition which contains a list of UniverseFilter.

I get every UniverseFilter in my object with a resultMap like this :

<resultMaps>
    <resultMap id="UniverseDefinitionMap" class="UniverseDefinition" groupBy="IdRessource">
      <result column="id_universedef" property="IdUniverseDefinition" />
      <result column="id_ressource" property="IdRessource" />
      <result column="dateval" property="Date" />
      <result column="generatortype" property="GeneratorType" />
      <result column="filterorder" property="FilterOrder" />

      <result column="id_universedef" property="FilterList" select="UniverseFilterSelectByIdUnivRef" />
[...]

Every works well for the select statements.


But, i'd like to make an insert statement, and reuse the insert statement i made for the class UniverseFilter.

    <insert id="UniverseDefinitionInsert" parameterClass="UniverseDefinition" resultClass="int">
      insert into dbo.r_universedef (id_universedef, id_ressource, dateval, generatortype, filterorder)
      values (#IdUniverseDefinition:int#, #IdRessource:int#, #Date:DATETIME#, #GeneratorType:int#, #FilterOrder:VARCHAR# );
     
      <dynamic prepend="">
       <isGreaterThan prepend="" property="FilterList.Count" compareValue="0">
          <iterate prepend="" open="" close="" property="FilterList" conjunction="; ">
           
                       REUSE OF STATEMENT "INSERT_UNIVERSEFILTER" ... with paramater FilterList[] (typed UniverseFilter)

          </iterate>
        </isGreaterThan>
      </dynamic>
    </insert>

Is it possible ?

Thanks

Régis



NB: iBatis is really great !
NB2: sorry, i'm french and my english is suffering ...

[Michael McCurrey-3]

You can, but not directly in how you have it.

IBatis includes a feature called fragements.  In your map file, put your *core* sql in a statement such as
    <sql id="Fragment">
      insert something
    </sql>

Then down in your real insert statement reference it as such:
    <insert id="test">
      <include refid="Fragment"></include>
    </insert>

Does this help?

On Fri, Jul 10, 2009 at 8:19 AM, Régis BRULEY <regis@...> wrote:

Hi,

It's my first post in this mail-list ... so hi everybody.

I writing this mail, because I don't know if it's possible to reuse some previous statements in an other statement ? ...

Let me explain myself :

I have a class UniverseFilter which is mapped. Every thing works.
I have an class UniverseDefinition which contains a list of UniverseFilter.

I get every UniverseFilter in my object with a resultMap like this :

<resultMaps>
    <resultMap id="UniverseDefinitionMap" class="UniverseDefinition" groupBy="IdRessource">
      <result column="id_universedef" property="IdUniverseDefinition" />
      <result column="id_ressource" property="IdRessource" />
      <result column="dateval" property="Date" />
      <result column="generatortype" property="GeneratorType" />
      <result column="filterorder" property="FilterOrder" />

      <result column="id_universedef" property="FilterList" select="UniverseFilterSelectByIdUnivRef" />
[...]

Every works well for the select statements.


But, i'd like to make an insert statement, and reuse the insert statement i made for the class UniverseFilter.

    <insert id="UniverseDefinitionInsert" parameterClass="UniverseDefinition" resultClass="int">
      insert into dbo.r_universedef (id_universedef, id_ressource, dateval, generatortype, filterorder)
      values (#IdUniverseDefinition:int#, #IdRessource:int#, #Date:DATETIME#, #GeneratorType:int#, #FilterOrder:VARCHAR# );
     
      <dynamic prepend="">
       <isGreaterThan prepend="" property="FilterList.Count" compareValue="0">
          <iterate prepend="" open="" close="" property="FilterList" conjunction="; ">
           
                       REUSE OF STATEMENT "INSERT_UNIVERSEFILTER" ... with paramater FilterList[] (typed UniverseFilter)

          </iterate>
        </isGreaterThan>
      </dynamic>
    </insert>

Is it possible ?

Thanks

Régis



NB: iBatis is really great !
NB2: sorry, i'm french and my english is suffering ...

--
Michael J. McCurrey
Read with me at http://www.mccurrey.com
http://chaoticmindramblings.blogspot.com/