[ 
https://issues.apache.org/jira/browse/DBUTILS-120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14130304#comment-14130304
 ] 

Aleksei Kovura commented on DBUTILS-120:
----------------------------------------

Lines that begin with double (not triple) dash are filtered out (see regexps). 
Can you elaborate on clashes? I would be glad to improve the filtering.
Seems to me that triple dash and colon would make better delimeters, because 
it's visually easier to scan for query name in that than in something that 
contains other strings  ("Query" in your example).

> Add loading from SQL file to QueryLoader
> ----------------------------------------
>
>                 Key: DBUTILS-120
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-120
>             Project: Commons DbUtils
>          Issue Type: Improvement
>            Reporter: Aleksei Kovura
>              Labels: patch
>         Attachments: dbutilsQueryLoader.diff
>
>
> I propose sql file in the following format:
> ---queryName1:
> SELECT * FROM "APP"."TABLE1";
> ---queryName2:
> SELECT column1, column2 FROM "APP"."TABLE2" WHERE column1=?;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to