You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by km...@apache.org on 2009/01/13 17:48:07 UTC

svn commit: r734177 - in /db/derby/code/trunk/java: build/org/apache/derbyBuild/JiraConnector.java demo/vtis/java/org/apache/derbyDemo/vtis/core/XmlVTI.java demo/vtis/java/org/apache/derbyDemo/vtis/example/VTIs.java

Author: kmarsden
Date: Tue Jan 13 08:47:30 2009
New Revision: 734177

URL: http://svn.apache.org/viewvc?rev=734177&view=rev
Log:
DERBY-4014 Update Derby Jira Report XML VTI to access more fields
- Add more fields to Jira VTI
- Add all option to JiraConnector to get full issue export.
- Change XMLVTI to separate multiple items with spaces.


Modified:
    db/derby/code/trunk/java/build/org/apache/derbyBuild/JiraConnector.java
    db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/core/XmlVTI.java
    db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/example/VTIs.java

Modified: db/derby/code/trunk/java/build/org/apache/derbyBuild/JiraConnector.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/build/org/apache/derbyBuild/JiraConnector.java?rev=734177&r1=734176&r2=734177&view=diff
==============================================================================
--- db/derby/code/trunk/java/build/org/apache/derbyBuild/JiraConnector.java (original)
+++ db/derby/code/trunk/java/build/org/apache/derbyBuild/JiraConnector.java Tue Jan 13 08:47:30 2009
@@ -41,7 +41,9 @@
 	// filenames of files to be created.
 	static String fixedBugsListFileName="fixedBugsList.xml";
 	static String releaseNotesListFileName="ReleaseNotesList.xml";
+	static String allJiraListFileName="all_JIRA_ISSUES.xml";
 
+    
 	public static String jira_releaseNotesSource =
 		"http://issues.apache.org/jira/secure/IssueNavigator.jspa?view=rss" +
 		"&pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=50" +
@@ -54,6 +56,8 @@
 		"fixVersion=10.3.0.0&sorter/field=issuekey&sorter/order=DESC&" +
 		"tempMax=1000&reset=true&decorator=none";
 
+	public static String jira_allBugsSource= "http://issues.apache.org/jira/secure/IssueNavigator.jspa?view=rss&pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none";
+
 	// other urls to some cute jira reports in xml.
 	// all 
 	//  (warning: avoid using this - it's tough on apache infrastructure.
@@ -67,8 +71,13 @@
 
 	public static void main(String[] args) {
 		try{
-			refreshJiraIssues(fixedBugsListFileName, jira_fixedBugsSource);
-			refreshJiraIssues(releaseNotesListFileName, jira_releaseNotesSource);
+			if (args.length > 0 && args[0].equals("all"))
+				// don't use this too often it is hard on Apache infrastructure.
+				refreshJiraIssues(allJiraListFileName, jira_allBugsSource);
+			else {
+				refreshJiraIssues(fixedBugsListFileName, jira_fixedBugsSource);
+				refreshJiraIssues(releaseNotesListFileName, jira_releaseNotesSource);
+			}
 		}catch(IOException ex){
 			ex.printStackTrace();
 		}catch(Exception exe){

Modified: db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/core/XmlVTI.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/core/XmlVTI.java?rev=734177&r1=734176&r2=734177&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/core/XmlVTI.java (original)
+++ db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/core/XmlVTI.java Tue Jan 13 08:47:30 2009
@@ -331,7 +331,9 @@
                     for ( int j = 0; j < childCount; j++ )
                     {
                         Element     child = (Element) children.item( j );
-                    
+                        // separate values with spaces.
+                        if (j != 0)
+                            buffer.append(" ");
                         buffer.append( squeezeText( child ) );
                     }
                     contents = buffer.toString();

Modified: db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/example/VTIs.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/example/VTIs.java?rev=734177&r1=734176&r2=734177&view=diff
==============================================================================
--- db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/example/VTIs.java (original)
+++ db/derby/code/trunk/java/demo/vtis/java/org/apache/derbyDemo/vtis/example/VTIs.java Tue Jan 13 08:47:30 2009
@@ -94,8 +94,8 @@
     @XMLRow
         (
          rowTag = "item",
-         childTags = { "key", "type", "priority", "status", "component", "title" },
-         childTypes = { "varchar(12)", "varchar(10)", "varchar(10)", "varchar(10)", "varchar(50)", "varchar(200)" },
+         childTags = { "key", "type", "priority", "status", "component", "title", "reporter", "assignee", "resolution", "created", "updated", "votes", "version", "fixVersion" },
+         childTypes = { "varchar(12)", "varchar(10)", "varchar(10)", "varchar(10)", "varchar(50)", "varchar(200)", "varchar(50)", "varchar(50)", "varchar(20)", "varchar(50)", "varchar(50)", "integer", "varchar(200)", "varchar(200)" },
          vtiClassName = "org.apache.derbyDemo.vtis.core.XmlVTI"
          )
     public  static  ResultSet   apacheVanillaJiraReport( String xmlResource ) throws SQLException