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-3129) Create Demo code, showing how to create and use table functions.
Date Fri, 12 Oct 2007 21:44:50 GMT

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

Rick Hillegas updated DERBY-3129:

    Attachment: derby-3129-sampleTableFunctions-aa.diff

Attaching derby-3129-sampleTableFunctions-aa.diff. This contains
useful, sample table functions for

1) making a table out of a property file

2) making a table out of an XML file

3) making tables out of subversion logs, apache web server logs, and
JIRA reports.

In addition, this demo provides machinery for declaring and refreshing
paramaterized subscriptions to data from foreign SQL databases.

Touches the following files:


A      java/demo/vtis/java/org/apache/derbyDemo/vtis/core/VTITemplate.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/core/StringColumnVTI.java

Ancestor classes of most of the table functions in this demo. These
classes factor out most of the boilerplate code needed for table


A      java/demo/vtis/java/org/apache/derbyDemo/vtis/core/VTIHelper.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/example/VTIs.java

Machinery showing how Annotations help  abstract out some of the
routine chores of creating table functions.


A      java/demo/vtis/java/org/apache/derbyDemo/vtis/core/XmlVTI.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/core/XMLRow.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/example/ApacheServerLogVTI.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/example/DerbyJiraReportVTI.java

Machinery for making a table out of an XML file plus sample table
functions wrapping apache web server logs and JIRA reports.


A      java/demo/vtis/java/org/apache/derbyDemo/vtis/core/FlatFileVTI.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/example/SubversionLogVTI.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/example/PropertyFileVTI.java

Machinery for tabularizing a text file of records plus sample table
functions wrapping subversion logs and property files.


A      java/demo/vtis/java/org/apache/derbyDemo/vtis/core/QueryVTIHelper.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/core/QueryRow.java

Machinery for creating a table function out of a query against a
foreign database.


A      java/demo/vtis/java/org/apache/derbyDemo/vtis/snapshot/Subscription.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/snapshot/SnapshotQuery.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/snapshot/SubscriptionSignature.java
A      java/demo/vtis/java/org/apache/derbyDemo/vtis/example/WorldDBSnapshot.java

Machinery for declaring/refreshing parameterized subscriptions of
foreign data plus an example subscription to the MySQL sample "world"


A      java/demo/vtis/vtiDemo.sql
A      java/demo/vtis/data/svn_log.txt
A      java/demo/vtis/data/DerbyJiraReport.xml
A      java/demo/vtis/data/ApacheServerLog.xml
A      java/demo/vtis/README

Script, data, and instructions explaining how to build and use this
demo code.


M      java/demo/build.xml
M      build.xml

Build machinery.

> Create Demo code, showing how to create and use table functions.
> ----------------------------------------------------------------
>                 Key: DERBY-3129
>                 URL: https://issues.apache.org/jira/browse/DERBY-3129
>             Project: Derby
>          Issue Type: Improvement
>          Components: Demos/Scripts
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: derby-3129-sampleTableFunctions-aa.diff
> Create some useful, sample table functions.

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

View raw message