ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 28681] - [PATCH] Xml output for the SQL task
Date Wed, 05 May 2004 15:40:50 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=28681>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=28681

[PATCH] Xml output for the SQL task





------- Additional Comments From nicolaken@apache.org  2004-05-05 15:40 -------
> To me, we should just map ResultSet object into XML.
> ResultSets are an iterative version of a table, and we should just
> be able to express that in XML.

This seems quite similar to a resultset in xml to me:

<sqlresults>
    <row><cell header="A">one</cell><cell header="B">1</cell></row>
    <row><cell header="A">two</cell><cell header="B">2</cell></row>
    <row><cell header="A">one</cell><cell header="B">11</cell></row>
</sqlresults>

> I do not understand why we need to do grouping here,

Then tell me how you would do it instead.

> and how do you
> know the grouping is on "A" on your example. Are you parsing the SQL
> or is this available as metadata from the resultset.

It's the first column name, I get it from the metadata (@see the code).

> I do not like all this nested things to be assummed just be the position of 
> the column or something some heuristic that will not work for the next guy 
> that tries to use the feature.

The nesting follows the column numbers. A nesting level of 1 groups by the first
column. It seems easy enough to understand, as it's what Excel or any other
spreadsheet does when you ask for grouping. 

How would you do it instead?

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org


Mime
View raw message