Return-Path: 
 <user-return-60996-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 73291 invoked from network); 8 Jun 2007 17:40:55 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 8 Jun 2007 17:40:55 -0000
Received: (qmail 79056 invoked by uid 500); 8 Jun 2007 17:40:50 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 78981 invoked by uid 500); 8 Jun 2007 17:40:49 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@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 78969 invoked by uid 99); 8 Jun 2007 17:40:49 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Jun 2007 10:40:49 -0700
X-ASF-Spam-Status: No, hits=0.9 required=10.0
	tests=FORGED_YAHOO_RCVD,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Jun 2007 10:40:44 -0700
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1HwiRk-0008Cv-4r
	for user@ant.apache.org; Fri, 08 Jun 2007 10:40:24 -0700
Message-ID: <11030923.post@talk.nabble.com>
Date: Fri, 8 Jun 2007 10:40:23 -0700 (PDT)
From: caleysoldman <tampa_dba@yahoo.com>
To: user@ant.apache.org
Subject: Re: can filesets be stored in a properties file?
In-Reply-To: <973549.23798.qm@web55115.mail.re4.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: tampa_dba@yahoo.com
References: <11028955.post@talk.nabble.com>
 <973549.23798.qm@web55115.mail.re4.yahoo.com>
X-Virus-Checked: Checked by ClamAV on apache.org


hi matt, thanks for your reply...here you are ant folx:

my requirement is to produce sql using ant. i am enjoined not to use
velocity, groovy, or anything but ant. 

as such, what i am trying to replicate is shell script logic because those
are my marching orders. i mention this because i'm sure real application
developers will object to this egregious misuse of ant... 

:arguing:

regardless, what i did was create a working build ...all i really need to
understand is how to move the fileset to an external file that will then be
used based on the DBMS property which value is passed at the command line.
thanks in advance for your help ant folx!

<?xml version="1.0" ?>

<!-- #######################################################################
-->
<!-- Project Line               -->
<!-- #######################################################################
-->
<project default="createTableSQL">

 <taskdef resource="net/sf/antcontrib/antcontrib.properties"/>
 <taskdef resource="customtasks.properties"/>
 <typedef resource="customtypes.properties"/>

 <property file="${basedir}/generic.properties" />
 <property name="DBMS" value="NOT_SET" />

<!-- ############################################################# -->
<!-- Target to loop through the files -->
<!-- ############################################################# -->
 <target name="createTableSQL" depends="commandline">

 <echo>
  Producing SQL for DBMS ${DBMS}
 </echo>

<!-- ############################################################# -->
<!-- Outer for loop for the typical tables -->
<!-- ############################################################# -->
  <for param="tabfiles">
   <fileset refid="typicalTableSQL"/>
   <sequential>
    <processfile file="@{tabfiles}"/>

<!-- ############################################################# -->
<!-- Nested for loop for the typical storage -->
<!-- ############################################################# -->
     <for param="storage">
      <fileset refid="typicalTabStorage"/>
       <sequential>
        <processfile file="@{storage}"/>
       </sequential>
     </for>

   </sequential>
  </for>

 </target>

<!-- ############################################################# -->
<!-- MACRO to process the files -->
<!-- ############################################################# -->
 <macrodef name="processfile">
  <attribute name="file"/>
   <sequential>
    <echo>Process @{file}</echo>
     <concat destfile="test.txt" append="true">
      <fileset file="@{file}"/>
       <filterchain>
        <expandproperties/>
       </filterchain>
     </concat>
   </sequential>
 </macrodef>

<!-- ############################################################## -->
<!-- Validate Command Line Args -->
<!-- ############################################################## -->
 <target name="commandline">
  <if>
   <equals arg1="ora" arg2="${DBMS}" />
    <then>
     <property file="${basedir}/${DBMS}.properties" />
    </then>
  <elseif>
   <equals arg1="db2" arg2="${DBMS}" />
    <then>
     <property file="${basedir}/${DBMS}.properties" />
    </then>
  </elseif>
  <else>
   <fail>
    ERROR: Missing Command Line Property Varialbe DBMS: ${DBMS}.
   </fail>
  </else>
  </if>
 </target>

<!-- ############################################################# -->
<!-- Fileset for typical tables -->
<!-- ############################################################# -->
 <fileset
  id="typicalTableSQL"
  dir="sql_def/tables" >
  <include name="**/*.tmplt"/>
  <exclude name="a.tmplt"/>
  <exclude name="b.tmplt"/>
  <exclude name="${EXCLUDE01}.tmplt"/>
 </fileset>

<!-- ############################################################# -->
<!-- Fileset for typical table storage -->
<!-- ############################################################# -->
 <fileset
  id="typicalTabStorage"
  dir="sql_def/storage" >
  <include name="${DBMS}_typtab_storage.tmplt"/>
 </fileset>

</project>



-- 
View this message in context: http://www.nabble.com/can-filesets-be-stored-in-a-properties-file--tf3890587.html#a11030923
Sent from the Ant - Users mailing list archive at Nabble.com.


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