Return-Path: 
 <ant-dev-return-13263-apmail-jakarta-ant-dev-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-ant-dev-archive@jakarta.apache.org
Received: (qmail 55651 invoked by uid 500); 27 Apr 2001 18:08:39 -0000
Mailing-List: contact ant-dev-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ant-dev@jakarta.apache.org
list-help: <mailto:ant-dev-help@jakarta.apache.org>
list-unsubscribe: <mailto:ant-dev-unsubscribe@jakarta.apache.org>
list-post: <mailto:ant-dev@jakarta.apache.org>
Delivered-To: mailing list ant-dev@jakarta.apache.org
Delivered-To: moderator for ant-dev@jakarta.apache.org
Received: (qmail 37314 invoked from network); 25 Apr 2001 19:33:57 -0000
From: "Michael McCallum" <michael@spinsoftware.com>
To: ant-dev@jakarta.apache.org
Date: Thu, 26 Apr 2001 07:33:21 +1200
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: SQLExec and Properties
Reply-to: michael@spinsoftware.com
Message-ID: <3AE7CF41.2504.5510D0A1@localhost>
Priority: normal
In-reply-to: <01D447283D29D4119D5C0001023D580C2B612F@JOECOOL>
X-mailer: Pegasus Mail for Win32 (v3.12c)
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

If anyone is interested in including the filterset patch i made earlier I have adapted sqlexec to 
use the fitlerset to replace all tokens.

I have also extended the filterset to allow abitrary tokens so you can do the &&value. or 
&foo_bar. or %anything_you_want_really% including ${foo_bar} token replaces on scripts that 
you run from sql plus. 

Found this very useful as you can run scripts and test them and edit them and then put them all 
together with a build script.


On 25 Apr 2001, at 10:22, Dave King wrote:

> I'm just wondering about adding property substitution to SQL used in the SQL
> task.   I've made the changes and I'm wondering if anyone else would find
> this helpful.  Being paranoid about not breaking some obscure script that
> uses ${} in the sql, I added a replaceproperties attribute.  Here's what we
> are using it for.
> 
> 	<target name="create-db">
> 		<sql
> 			driver="${jdbc.driver}"
> 			url="${jdbc.url}"
> 			userid="${admin.id}"
> 			password="${admin.password}"
> 			replaceproperties="true"
> 		>
> 			IF NOT EXISTS (SELECT name FROM sysdatabases WHERE
> name = 'ant_test')
> 			CREATE DATABASE ant_test
> 			ON 
> 			( NAME = ant_test_dat,
> 				FILENAME = '${mssql.data.dir}\ant_test.mdf'
> ,
> 				SIZE = 2MB ,
> 				MAXSIZE = 20MB )
> 			LOG ON
> 			( NAME = 'ant_test_log',
> 				FILENAME =
> '${mssql.log.dir}\ant_test_Log.LDF' ,
> 				SIZE = 5MB ,
> 				MAXSIZE = 5MB 
> 			);
> 		</sql>
> 	</target>
> 
> If this is of interest I can post a diff and the code, but I'm not set up to
> produce a patch.
> 
> -Peace
> Dave