db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Weerasiri (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4557) Make it possible to parameterize ij scripts.
Date Sat, 20 Feb 2010 14:34:27 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12836176#action_12836176

Denis Weerasiri commented on DERBY-4557:

I'm new to derby. But I guess we can filter and substitute those $ parameters in org.apache.derby.tools.ij#runScript
 method. Is it OK?

> Make it possible to parameterize ij scripts.
> --------------------------------------------
>                 Key: DERBY-4557
>                 URL: https://issues.apache.org/jira/browse/DERBY-4557
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>            Reporter: Rick Hillegas
> It would be nice to be able to parameterize ij scripts. At a high level, this would be
akin to the $N parameters which you pass on the command line to Unix shell scripts. I think
it would be easiest to understand if parameter substitution happened before the script was
handed to the ij parser.
> It would be nice to write something like the following:
> connect 'jdbc:derby:$1;user=$2;password=$3';
> insert into $4( a ) values ( $5 );
> or something like this:
> connect 'jdbc:derby:${dbname};user=${user};password=${password}';
> insert into ${tableName} values ( ${intValue} );

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message