commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksei Kovura (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DBUTILS-120) Add loading from SQL file to QueryLoader
Date Thu, 11 Sep 2014 17:08:34 GMT

    [ 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)

Mime
View raw message