[
http://jira.codehaus.org/browse/MSQL-30?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=207601#action_207601
]
Gérald Quintana commented on MSQL-30:
-------------------------------------
To say differently: "I needed something to report information stored in
database".
It's like Project information report but showing information stored in
database. The snapshot shows "create, update, delete", it's not intended for
that use, I only want to do some "select" and show the result with other
Project reports.
> SQL Report in Maven Site
> ------------------------
>
> Key: MSQL-30
> URL: http://jira.codehaus.org/browse/MSQL-30
> Project: Maven 2.x SQL Plugin
> Issue Type: New Feature
> Affects Versions: 1.3
> Reporter: Gérald Quintana
> Attachments: sql-maven-plugin.zip, sql-report.diff, sql-report.png
>
>
> I needed something to do some database checking from my CI server. So
> I imagined executing some SQL commands and displaying the results with
> the Maven Site system: in a word do "select ... from ..." query and
> display the result set in HTML. I checked out the SQL plugin from SVN
> did some modifications and here it is: I am able to display SQL output
> in Maven Site. You'll find my prototype attached along with a sample
> project (src/test/resources/test-project) and a snapshot.
>
> Basically, here is what I did:
> 1) I splitted SqlExecMojo into 3 pieces:
> - The Mojo (Maven plugin + configuration)
> - The engine (SQL execution)
> - The rendering (output file)
> 2) I developped a new Mojo
> - The Report (Maven report + configuration)
> - The engine (same as above)
> - The rendering (Doxia Sink)
>
> The code needs polishing (Unit testing, JavaDoc, I18n, more
> configuration...), but it works.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
