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
