db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4883) Create a table function which turns an html table into a dbms table
Date Tue, 02 Nov 2010 21:15:07 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Rick Hillegas updated DERBY-4883:

    Attachment: z.sql

Attaching a couple files:

1) HtmlTableVTI.java - This is a table function which reads an html file and makes a ResultSet
out of the last html table which it finds in the file.

2) FirstVersion.java - This is a function which takes a string of Derby version ids and extracts
the earliest version id. Technically, this has nothing to do with this JIRA, but it's part
of the test case which I put together to debug this.

3) regressionReport.html - Again, not technically part of this JIRA. This is an html report
produced from the "Derby regressions" filter by selecting the "Excel(current field)" view.
I had to scrub the report a bit to get it to pass the xml parser used by HtmlTableVTI.

4) z.sql - This is a script which declares the above  functions and runs them against the
regression report to produce a list of previous releases and the number of regressions they

Here is the output from running the final query in the script:

ij> select a, count( a ) b
from ( select firstVersion( col11 ) a from regressions where firstVersion( col11 ) is not
null ) t
group by a
order by b;
A                   |B          
--------------------------------            |1             |1             |1             |1             |1             |1             |1             |2             |2             |2             |3             |4             |6             |8             |8             |8             |8             |9             |12            |13            |33            |53         

22 rows selected

> Create a table function which turns an html table into a dbms table
> -------------------------------------------------------------------
>                 Key: DERBY-4883
>                 URL: https://issues.apache.org/jira/browse/DERBY-4883
>             Project: Derby
>          Issue Type: Improvement
>          Components: Demos/Scripts
>            Reporter: Rick Hillegas
>         Attachments: FirstVersion.java, HtmlTableVTI.java, regressionReport.html, z.sql
> This could be a generally useful tool to have in one's kit.

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

View raw message