Return-Path: 
 <user-return-34880-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 86189 invoked by uid 500); 21 Jul 2003 10:17:18 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Subscribe: <mailto:user-subscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 86157 invoked from network); 21 Jul 2003 10:17:13 -0000
Received: from s-97-26.dsl.cleardatavoice.com (HELO gridnode.com)
 (202.83.97.26)
  by daedalus.apache.org with SMTP; 21 Jul 2003 10:17:13 -0000
Received: from daniel ([192.168.213.146])
	by gridnode.com (8.11.6p2/8.9.3) with SMTP id h6LAQ3E32461
	for <user@ant.apache.org>; Mon, 21 Jul 2003 18:26:04 +0800
Reply-To: <daniel.joshua@gridnode.com>
From: "Daniel Joshua" <daniel.joshua@gridnode.com>
To: "'Ant Users List'" <user@ant.apache.org>
Subject: RE: Bug with property/propertyfile ? (Solved)
Date: Mon, 21 Jul 2003 18:17:54 +0800
Message-ID: <019a01c34f71$5ad54190$92d5a8c0@sgxdev.gridnode.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
In-Reply-To: <02ad01c34d26$1ad887c0$92d5a8c0@sgxdev.gridnode.com>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

I figured out my problem ealier today.

All I did was to remove the [inheritall="true"] from the <foreach> task and
pass in the appropriate <param>s,
then the <property file="${db.file}"/> was able to get the updated value on
each call.

Thanks for reminding me that properties are immutable.


Regards,
Daniel


-----Original Message-----
From: Daniel Joshua [mailto:daniel.joshua@gridnode.com]
Sent: Friday, 18 July, 2003 8:14 PM
To: 'Ant Users List'
Subject: Bug with property/propertyfile ?


Hi all,

I am not really sure if this is a bug actually.

I used <propertyfile> to write to a file, and then read from that file using
<property file="">,
and write again, then read again, etc.

However, after writing to the file and reading from it,
the value that is read is still the original value sometimes, and not the
recently written one.




Here's my scenario:

I am using ant (with ant-contrib) to build and application and the below is
a snippet of how I try to execute
sql files to setup my database. New sql files are often added, and only the
new ones should be executed.
So I store the filenames of the sql files I have executed to exclude them
from the fileset.





  <!-- initialise the database -->
  <target name="init.db">
    <echo message="[${layer.module}] Executing target: init.db"/>
    <property name="db.file" value="${app.home}/env/db.properties"/>
    <property name="db.file.key"
value="sqlscripts.excluded.${layer.module}"/>
  </target>





  <!-- setting up the database tables -->
  <target name="create.module.db.tables">
    <echo message="[${layer.module}] Executing target:
create.module.db.tables"/>
    <antcall target="process.sqlscripts">
      <param name="includes" value="create-tables.sql"/>
    </antcall>
  </target>





  <!-- populate the database -->
  <target name="populate.module.db.tables">
    <echo message="[${layer.module}] Executing target:
populate.module.db.tables"/>
    <antcall target="process.sqlscripts">
      <param name="includes"
value="insert-metainfo.sql,create-default.sql"/>
    </antcall>
  </target>





  <!-- patch the database -->
  <target name="patch.module.db.tables">
    <echo message="[${layer.module}] Executing target:
patch.module.db.tables"/>
    <antcall target="process.sqlscripts">
      <param name="includes" value="patch*.sql"/>
    </antcall>
  </target>





  <!-- processing sql scripts -->
  <target name="process.sqlscripts">
    <!-- retrieve previously excluded sqlscripts -->
    <property file="${db.file}"/>
    <propertycopy name="excludes"
                  from="${db.file.key}"
                  silent="true"/>

    <!-- fileset of sqlscripts to execute -->
    <property name="dbscript.dir" value="${sqlscripts.dir}/${db.name}"/>
    <fileset id="db.sqlscripts.fileset"
             dir="${dbscript.dir}"
             includes="${includes}"
             excludes="${excludes}"/>

    <if>
      <!-- ... -->
      <then>
        <!-- execute sqlscripts -->
        <apply executable="${layer.dir}/dbscript.bat">
          <arg value="${db.exec.cmd}"/>
          <fileset refid="db.sqlscripts.fileset"/>
        </apply>
      </then>
    </if>

    <!-- record all processed sqlscripts -->
    <trycatch>
      <try>
        <foreach target="record.sqlscript"
                 param="sqlscript.file"
                 inheritall="true">
          <path>
            <fileset refid="db.sqlscripts.fileset"/>
          </path>
        </foreach>
      </try>
      <catch>
        <!-- ignore error caused by empty fileset -->
      </catch>
    </trycatch>
  </target>





  <target name="record.sqlscript">
    <!-- get filename of sqlscript -->
    <basename property="sqlscript.filename" file="${sqlscript.file}"/>
    <echo message="[${layer.module}] Executing target: record.sqlscript for
${sqlscript.filename}"/>

    <!-- retrieve previously excluded sqlscripts -->
    <property file="${db.file}"/>
    <propertycopy name="sqlscripts.excluded"
                  from="${db.file.key}"
                  silent="true"/>

<echo message=" [DEBUG] sqlscripts.excluded ==> ${sqlscripts.excluded}"/>

    <!-- append previously excluded sqlscripts -->
    <if>
      <isset property="sqlscripts.excluded"/>
      <then>
        <property name="sqlscripts.excluded.filenames"
value="${sqlscripts.excluded},${sqlscript.filename}"/>
      </then>
      <else>
        <property name="sqlscripts.excluded.filenames"
value="${sqlscript.filename}"/>
      </else>
    </if>

    <!-- update file -->
    <propertyfile file="${db.file}">
      <entry  key="sqlscripts.excluded.${layer.module}"
value="${sqlscripts.excluded.filenames}"/>
    </propertyfile>
  </target>


Regards,
Daniel


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org