[
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
functions.
-------------
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"
database.
-------------
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: 10.4.0.0
> 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.
