db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r478802 [1/3] - in /db/derby/code/trunk/tools/testing/reporting: ./ Failures/ TEMPLATES/ scripts/ scripts/gnuplot/
Date Fri, 24 Nov 2006 08:35:06 GMT
Author: kahatlen
Date: Fri Nov 24 00:35:04 2006
New Revision: 478802

URL: http://svn.apache.org/viewvc?view=rev&rev=478802
Log:
DERBY-812: Scripts to publish Derby test results

Contributed by Ole Solberg.

Added:
    db/derby/code/trunk/tools/testing/reporting/
    db/derby/code/trunk/tools/testing/reporting/Failures/
    db/derby/code/trunk/tools/testing/reporting/Failures/JIRA_description.txt   (with props)
    db/derby/code/trunk/tools/testing/reporting/TEMPLATES/
    db/derby/code/trunk/tools/testing/reporting/TEMPLATES/env.sh   (with props)
    db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.html   (with props)
    db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.shtml   (with props)
    db/derby/code/trunk/tools/testing/reporting/TEMPLATES/testenv.sh   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/
    db/derby/code/trunk/tools/testing/reporting/scripts/README.1   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/README.2   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/TODO   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/buildDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/calcJarFootprint   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/calcPercent   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/cpu_mem   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFiles   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFilesOnePlatform   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/cronCurrentTestInfoDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/cronMkAllPlotDataAndPlots   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/cronMkDerbyTestIndex_all   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateAllTestInfoDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateBuildTestDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-cpu_mem   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-system   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/doplot   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/doplot_all   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/env   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/fromSeconds   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/getBaselineTime   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/gnuplot/
    db/derby/code/trunk/tools/testing/reporting/scripts/gnuplot/duration.gp   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/gnuplot/duration_all.gp   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/initDERBYDIR   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/linux-cpu_mem   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/linux-system   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkAllDerbyTestInfo   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkAllDerbyTestInfo.public   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkAllPlotDataAndPlots   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkDerbyTestIndex   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkDerbyTestIndex_all   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkGNUplot   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkGNUplot.recent   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkGNUplot_last20   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkJIRArefs   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkJIRArefs.current   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkPercentForTimeListVsBaseline   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkSandBoxSummary   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/mkUpdateInfo   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/platformsDurPrcnt   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/platformsFailCount   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/runAllTests   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/scp_dummy   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/solaris-cpu_mem   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/solaris-system   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/startDerbyTests   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/svnDiffToRev   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/svnLogRevs   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/svnLogRevs.new   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/system   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/testDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/testHistoriesDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/testPlatformsDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/testSummariesDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/textMail   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/toSeconds   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/updateBuildTestDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/updateDerby   (with props)
    db/derby/code/trunk/tools/testing/reporting/scripts/vsTimeBase   (with props)

Added: db/derby/code/trunk/tools/testing/reporting/Failures/JIRA_description.txt
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/Failures/JIRA_description.txt?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/Failures/JIRA_description.txt (added)
+++ db/derby/code/trunk/tools/testing/reporting/Failures/JIRA_description.txt Fri Nov 24 00:35:04 2006
@@ -0,0 +1,153 @@
+# This is a VERY rough filter!:
+# Comment out (#) closed issues to avoid masking new failures in the same test. 
+# Or append Status: Closed as in 986?Closed, ...?Resolved...
+#JIRA  SUITE_TEST                                    DESCRIPTION
+#? 1059   compatibility:serverVM-1.6_serverTrunk_clientVM-1.3_clientDB2JCC java.lang.StackOverflowError
+#? 1059   compatibility:serverVM-1.6_serverTrunk_clientVM-1.4_clientDB2JCC java.net.ConnectException
+#? 1059   compatibility:serverVM-1.6_serverTrunk_clientVM-1.5_clientDB2JCC java.net.ConnectException
+#? 1059   compatibility:serverVM-1.6_serverTrunk_clientVM-1.6_clientDB2JCC java.net.ConnectException
+1061   compatibility:embedded_VM-1.6                 
+1042   store/OnlineBackupTest3.java
+# 1022?Closed   lang/syscat.sql
+# 324?Closed    store/aes.sql                                 Closed, but not merged to 10.1
+990    store/access.sql
+989?Intermittent:_'ran_out_of_time'    unit/daemonService.unit
+# incorrect? 1430?'SQLSTATE(null):_SQL_Exception:_unrecognized_sql_type'_vs_'IC' jdbcapi/parameterMapping.java
+1430?jdbcPM:ERROR_58009 jdbcapi/parameterMapping.java
+# 957                      jdbcapi/parameterMapping.java          (Was 988) Dup of 987,986,957? (en_US vs no_NO)
+# 957?Fixed?               jdbcapi/blobclob4BLOB.java                    (Was 987) Any rel. to 575? (en_US vs no_NO)
+1691              jdbcapi/blobclob4BLOB.java
+# 575?Resolved    jdbcapi/blobclob4BLOB.java
+957?Fixed?             jdbcapi/statementJdbc20.java                  Dup in 987. (en_US vs no_NO)
+# 986?Closed    jdbcapi/statementJdbc20.java                  Closed: Dup of 957 (en_US vs no_NO)
+# 985?Closed  i18n/urlLocale.sql                            Closed, dup of 834
+# 917?Resolved    largedata/LobLimits.java                      Resolved
+980?InterruptedException               derbynet/testSecMec.java                      Seen once? 
+1751?FIXED:ShutdownException               derbynet/testSecMec.java                      Seen once? 
+NEW:IA?InvalidAlgorithmParameterException derbynet/testSecMec.java                      Seen once?
+# 978?Closed    jdbcapi/dbMetaDataJdbc30.java                 Closed
+977    jdbcapi/xaSimplePositive.sql
+# 976?Resolved    jdbcapi/resultsetJdbc30.java                Resolved
+973    store/OnlineBackupTest1.java                intermittent
+967    lang/autoincrement.sql                      intermittent
+NEW:AI?'should_see_0vs20'  lang/autoincrement.sql 
+788?Closed    store/encryptionKey.sql                     Closed, but not merged to 10.1
+# 956?Resolved                             stress/stress.multi
+1750?...timed_out_trying_to_kill_all_testers  stress/stress.multi
+1870?FatalException:_X0Y67:_Cannot_issue_rollback...  stress/stress.mult
+# 937?FIXED:'Nested_Loop'_vs_'Hash'                     lang/wisconsin.java
+1801?Instability_in_wisconsin_test                     lang/wisconsin.java
+# 1625?FIXED:IJ_ERROR:_Unable_to_establish_connection   lang/wisconsin.java
+1649?SQL_CURLH000C7_vs_C                               lang/wisconsin.java
+# 937?FIXED:'Nested_Loop'_vs_'Hash'                     lang/wisconsin.sql
+# 800?Closed    lang/ConcurrentImplicitCreateSchema.java    intermittent, Closed
+273?Resolved    derbynet/dataSourcePermissions_net.java     intermittent, Resolved
+NEW?DRDA_NPE    derbynet/dataSourcePermissions_net.java     'org.apache.derby.iapi.services.context.ShutdownException: Exception in thread "DRDAConnThread_3" java.lang.NullPointerException'
+# 846           derbynet/dataSourcePermissions_net.java     r399351: Check in missing updated master file
+803?ShutdownException derbynet/DerbyNetAutoStart.java             intermittent "org.apache.derby.iapi.services.context.ShutdownException:"
+NEW?dnDNASnc derbynet/DerbyNetAutoStart.java 'org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM = database2; diagnostic msg = No current connection.'
+NEW?NPE derbynet/DerbyNetAutoStart.java NullPointerException
+# 1399?FIXED:ConnectException(port_1527_vs_31415)  derbynet/DerbyNetAutoStart.java   "Could not access database through the network server."
+830?Failed_to_start_database_'jar:(ina.jar)db7'    lang/dcl.sql
+# 317?Closed                                    tools/ieptests.sql
+NEW:SE?SQL_Exception:_'Table/View'_vs_'Table'    tools/ieptests.sql
+516?  jdbcapi/CompatibilityTest.java
+1351  lang/forupdate.sql                      SQL_CURLH000C3/SQL_CURLH000C1 sequence
+1303   derbynet/SuicideOfStreaming.java           
+NEW:PR?Project-Restrict_ResultSet_(13)vs(15)     lang/predicatePushdown.sql
+937?FIXED:'Nested_Loop'_vs_'Hash'                lang/predicatePushdown.sql
+NEW:EX?ERROR_XBCX0:_Exception_from_Cryptography_provider. store/encryptDatabaseTest1.sql 
+417    store/Beetle6038.java
+# 1438?FIXED:'java.sql.SQLException'_vs_'SQL_Exception'   jdbcapi/checkDataSource.java
+# 1438?FIXED:'java.sql.SQLException'_vs_'SQL_Exception'   jdbcapi/checkDataSource30.java
+1757 jdbcapi/checkDataSource.java
+1757 jdbcapi/checkDataSource30.java
+1817 jdbcapi/checkDataSource.java        'Race condition in network server's thread pool'
+1817 jdbcapi/checkDataSource30.java      'Race condition in network server's thread pool'
+1379?JDK1.6_Autoloading_of_JDBC_drivers      nist/schema1.sql
+NEW:MO?derbyrunjartest/runtool_output_gets_mixed tools/derbyrunjartest.java
+834?FIXED i18n/urlLocale.sql
+# 834?FIXED derbynet/sysinfo.java                Test_Env1:_'Current_Locale_:__[English/United_States_[en_US]]'_vs_'[norsk/Norge_[no_NO]]'
+1832?dnUacp  derbynet/sysinfo.java 'Unable to analyze class path: access denied (java.util.PropertyPermission java.class.path read)'
+# 834?FIXED derbynet/sysinfo_withproperties.java Test_Env2:_'Current_Locale_:__[English/United_States_[en_US]]'_vs_'[norsk/Norge_[no_NO]]'
+1832?dnUacp  derbynet/sysinfo_withproperties.java 'Unable to analyze class path: access denied (java.util.PropertyPermission java.class.path read)'
+645?FIXED derbynet/sysinfo.java 
+?Jvm_failure:_SIGSEGV lang/refActions1.sql' "delete from db2test.emp where dno in (select ..where e5.dno in (select..where db2test.emp.name.....where db2test.emp.mgrname = 'JOHN')))));"
+1374?PROTOCOL_Data_Stream_Syntax_Error serverVM-1.3_server10.1.2.0_clientVM-1.3_clientTrunk
+1374?PROTOCOL_Data_Stream_Syntax_Error serverVM-1.3_server10.0.2.1_clientVM-1.3_clientDB2JCC
+1444?Test_Env.:_'Possible_Reason_-_Test_could_not_find_the_location_of_jar_files...' upgradeTests/Upgrade_10_1_10_2.java
+# 1375?CLOSED:Need_master_update? upgradeTests/Upgrade_10_1_10_2.java
+# NEW:UT?caseVersionCheck_fails  upgradeTests/Upgrade_10_1_10_2.java
+NEW:CR?Connection_refused                jdbcapi/testRelative.java
+NEW:NC?No_current_connection             junitTests/derbyNet/CompatibilityTest.java
+734?Test_output_intermixed            lang/closed.java
+952?Network_Server_did_not_start     derbynet/NSinSameJVM.java                   XP only
+1432?Warning:_UnknkownHostException:   derbynet/NSinSameJVM.java
+INFRA?Forgot_to_turn_off_firewall? derbynet/NSinSameJVM.java
+1380?Interface_changes_introduced_in_Mustang_b86 jdbc4/ClosedObjectTest.junit
+1380?Interface_changes_introduced_in_Mustang_b86 jdbc4/ResultSetTest.junit
+1380?Interface_changes_introduced_in_Mustang_b86 jdbc4/UnsupportedVetter.junit
+1380?Interface_changes_introduced_in_Mustang_b86 jdbc4/VerifySignatures.junit
+1571?FIXED                                                derbynet/testProperties.java
+1694                                                derbynet/testProperties.java
+NEW:CR1?java.net.SocketException:_Connection_reset  derbynet/testProperties.java
+NEW:CR2?java.net.SocketException:_Connection_reset  derbynet/DerbyNetNewServer.java
+NEW:SURQueryMixTest jdbcapi/SURQueryMixTest.junit
+NEW:InvTransSt lang/procedure.java
+TEST:native2ascii i18n/JapanCodeConversion.sql
+# 1455?CLOSED:Active_Sessions:_1_vs_2 derbynet/runtimeinfo.java
+1626                          store/TransactionTable.sql
+TEMP?r423132_fixed_by_r423348 # Very special case: '#' was used in a .runall file.
+1640?FIXED                          jdbcapi/XATest.java         Instability in XATest
+NEW:JSF?XBM0W_org.apache.derby.impl.io.JarStorageFactory store/encryptionKey_jar.sql "ERROR XBM0W: An exception was thrown while creating an instance of class class org.apache.derby.impl.io.JarStorageFactory registered for identifier jar."
+1585?X0X95_'CREATE_TRIGGER'_cannot_be_performed   lang/procedureInTrigger.sql "ERROR X0X95: Operation 'CREATE TRIGGER' cannot be performed on object 'T1' because there is an open ResultSet dependent on that object."
+1705?Invalid_attribute_syntax jdbcapi/dataSourceReference.java
+NEW:TQO?Expected_fix_in_JDK1.6_b98                  jdbc4/TestQueryObject.java
+1746?upgrade_tests_should_start_using_10.1.3_released_builds upgradeTests/Upgrade_10_1_10_2.java ""
+1430?jdbcSUR:ERROR_58009      jdbcapi/SURTest_ij.sql
+1789?derby.system.durability=test_mode_seems_to_be_broken         store/TestDurabilityProperty.java
+1800?FIXED:Unexpected_SQL_state._expected:<22001>_but_was:<58009> jdbc4/_Suite.junit
+1813?jdbc4/_Suite.junit:Fix_hard-coded_JDBC_4.0_type_constants jdbc4/_Suite.junit
+1874?largeDataTests/LobLimits_master_needs_update? largedata/LobLimits.java
+1629?see:1729FIXED lang/grantRevokeDDL2.sql 'New master file for JDK 6 needed.'
+1834?FIXED:gRDDL2:[user_] lang/grantRevokeDDL2.sql 'WARNING 01006: Privilege not revoked from [user ]USER2.'
+1910?OoME jdbcapi/_Suite.junit OutOfMemoryError
+#
+# New in 10.2.1.2 testing:
+1430?dnBC derbynet/badConnection.java
+1430?dnca derbynet/callable.java
+1430?dncSM derbynet/checkSecMgr.java
+1430?dncsPS derbynet/csPrepStmt.java
+1430?dndtn derbynet/dblook_test_net.java
+1430?dneU derbynet/executeUpdate.java
+1883?i18nmL    i18n/messageLocale.sql 'I18N tests fail on Linux/JVM 1.4.2 when derbyclient.jar is the first element of the classpath'
+1883?i18nintES i18n/iepnegativetests_ES.sql 'I18N tests fail on Linux/JVM 1.4.2 when derbyclient.jar is the first element of the classpath'
+1883?i18nuL    i18n/urlLocale.sql 'I18N tests fail on Linux/JVM 1.4.2 when derbyclient.jar is the first element of the classpath'
+# 10.2.1.3
+1869?TIMESTAMPDIFF lang/timestampArith.java
+1871 derbynet/testSecMec.java 'testSecMec failing with what looks like just a error message change diff'
+# 10.2.1.6
+NEW:noJDBC4? lang/releaseCompileLocks.sql
+NEW:noJDBC4? jdbcapi/dbMetaDataJdbc30.java
+NEW:noJDBC4? jdbc4/TestConnectionMethods.java
+NEW:noJDBC4? jdbc4/TestQueryObject.java
+NEW:noJDBC4? jdbc4/TestPreparedStatementMethods.java
+NEW:noJDBC4? jdbc4/TestResultSetMethods.java
+NEW:noJDBC4? jdbc4/AutoloadBooting.junit
+NEW:noJDBC4? jdbc4/AutoloadTest.junit
+NEW:noJDBC4? jdbc4/VerifySignatures.junit
+NEW:noJDBC4? jdbc4/_Suite.junit
+NEW:noJDBC4? derbynet/checkSecMgr.java
+NEW:noJDBC4? lang/procedure.java
+NEW:noJDBC4? tools/importExport.java
+NEW:noJDBC4? tools/ieptests.sql
+NEW:noJDBC4? jdbc4/TestJDBC40Exception.java
+NEW:noJDBC4? jdbc4/TestDbMetaData.java
+937?FIXED:'Nested_Loop'_vs_'Hash' lang/subquery.sql
+2063?ACE_junit.properties_read derbynet/ShutDownDBWhenNSShutsDownTest.junit java.security.AccessControlException: access denied (java.io.FilePermission /home/os136789/junit.properties read)
+2056 junitTests/derbyNet/CompatibilityTest.java
+2038 lang/closed.java
+2038 lang/releaseCompileLocks.sql
+####################################
+# JUnit tests
+2048 views(...functionTests.tests.lang.LangScripts)

Propchange: db/derby/code/trunk/tools/testing/reporting/Failures/JIRA_description.txt
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/tools/testing/reporting/TEMPLATES/env.sh
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/TEMPLATES/env.sh?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/TEMPLATES/env.sh (added)
+++ db/derby/code/trunk/tools/testing/reporting/TEMPLATES/env.sh Fri Nov 24 00:35:04 2006
@@ -0,0 +1,20 @@
+# Place in ${SANDBOX} (Above ${derby_source}, i.e. trunk, 10.2, 10.1 ....)
+# Modify to fit your environment
+#
+export TOPDIR=${HOME}/testingReportingScripts/outerWorld
+export TESTSET=testset
+export SANDBOX=sandbox
+export DERBYDIR=${TOPDIR}/${TESTSET}/${SANDBOX}
+export PUBLISHDIR=public_html/public/Apache/outerWorld/${TESTSET}/${SANDBOX}
+export ANT_HOME=/usr/local/share/java/apache-ant-1.6.2 
+export PATH=${ANT_HOME}/bin:/usr/local/java/jdk/bin/:$PATH
+export JAVA_HOME=/usr/local/java/jdk1.4
+export BRANCH_DIR=trunk
+#                 10.1
+#                 10.2
+#                 10.3
+#                 etc.
+export derby_source=${DERBYDIR}/${BRANCH_DIR}
+#
+export TOOLDIR=${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts
+export TEMPLATEDIR=${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/TEMPLATES

Propchange: db/derby/code/trunk/tools/testing/reporting/TEMPLATES/env.sh
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.html
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.html?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.html (added)
+++ db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.html Fri Nov 24 00:35:04 2006
@@ -0,0 +1,96 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
+<HTML>
+<HEAD>
+	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-1">
+	<TITLE>Apache Derby: Open Source Java Database - Regression Test Results</TITLE>
+	<META NAME="GENERATOR" CONTENT="StarOffice 7  (Linux)">
+	<META NAME="AUTHOR" CONTENT="Ole Solberg">
+	<META NAME="CREATED" CONTENT="20050624;15135900">
+	<META NAME="CHANGEDBY" CONTENT="Ole Solberg">
+	<META NAME="CHANGED" CONTENT="20060128;14015200">
+
+        <META NAME="DESCRIPTION" CONTENT="Apache Derby: Open Source Java Database - Regression Test Results">
+        <META NAME="KEYWORDS" CONTENT="open source database, open source, opensource, database, java, java database, test, testing, regression test, regression testing">
+</HEAD>
+<BODY LANG="en-US" DIR="LTR">
+<!-- Apache Derby: Open Source Java Database - Regression Test Results -->
+
+<title>Apache Derby Open Source Database, Regression Test Results</title>
+</head>
+<body>
+<table style="text-align: left; width: 100%;" border="0" cellspacing="0" cellpadding="0">
+  <tbody>
+    <tr>
+
+      <td style="vertical-align: bottom;"><font face="Albany, sans-serif" size="+3"><i>
+        <a href="http://db.apache.org/derby" target="_top">Apache <b>Derby</b>
+        </a></i></font> is an open source, 100% Java SQL Database.
+      </td>
+      <!--
+      <td style="vertical-align: top; text-align: right;"><i>Web space sponsored by</i>
+        <a href="http://www.sponsor.domain/">
+          <img alt="Sponsor Name" style="border: 0px solid"
+          src="http://www.sponsor.domain/files/logo.gif"><font size="+2"><b>Sponsor Name</b></font>
+        </a>
+      </td>
+      -->
+    </tr>
+  </tbody>
+</table>
+<HR>
+
+<B><FONT FACE="Albany, sans-serif"><FONT SIZE="+2">Apache Derby Test Results</FONT>
+ [<A HREF="http://db.apache.org/derby/derby_tests.html">More!</b></A>]</B></FONT>
+
+<BR><I>Who we are - long variant.</I>
+<P STYLE="font-style: normal">
+</P>
+
+
+<H2>Development trunk</H2>
+
+<H3 STYLE="margin-left: 0.79in">Testset A: e.g. Daily regression test - Derby built off trunk and <br>tested in "sandboxes" per JVM (1.4, 1.5, 1.6), where each "sandbox" represents tests on several OS(and HW) platforms.</H3>
+
+<!-- --> Select <b>Limited:</b> <!-- -->
+<P STYLE="margin-left: 1.58in; font-style: normal">
+<A HREF="sandbox/testing/Limited/">sandbox</A>
+<br>
+<A HREF="sandboxN/testing/Limited/">sandboxN</A>
+<br>
+<A HREF="sandboxM/testing/Limited/">sandboxM</A>
+</P>
+
+<!--  --> or <b>Full:</b> <!-- -->
+
+<P STYLE="margin-left: 1.58in; font-style: normal">
+<A HREF="sandbox/testing/Full/">sandbox</A><br>
+<A HREF="sandboxN/testing/Full/">sandboxN</A><br>
+<A HREF="sandboxM/testing/Full/">sandboxM</A>,
+</P>
+<!--  --> <!-- -->
+
+<H3 STYLE="margin-left: 0.79in">Testset B: e.g. "tinderbox" regression test - Derby built off trunk and <br>tested in a smaller set of "sandboxes" per JVM (1.4, 1.5, 1.6), where each "sandbox" represents tests on (a smaller) set of OS(and HW) platforms.</H3>
+
+<H2>Branches</H2>
+
+<H3 STYLE="margin-left: 0.79in">10.2 Branch</H3>
+
+<H3 STYLE="margin-left: 0.79in">10.1 Branch</H3>
+
+<H3 STYLE="margin-left: 0.79in">10.0 Branch</H3>
+
+
+
+<HR>
+<!--
+<i>Web space sponsored by</i>
+<a href="http://www.thresher.com/">
+  <img align="top" alt="Thresher Consulting" style="border: 0px solid" 
+  src="http://www.thresher.com/files/logo.gif"><font size="+1"><b>Thresher Consulting</b></font>
+</a>
+-->
+
+<!-- Apache Derby: Open Source Java Database - Regression Test Results -->
+
+</BODY>
+</HTML>

Propchange: db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.shtml
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.shtml?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.shtml (added)
+++ db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.shtml Fri Nov 24 00:35:04 2006
@@ -0,0 +1,100 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
+<HTML>
+<HEAD>
+	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-1">
+	<TITLE>Apache Derby: Open Source Java Database - Regression Test Results</TITLE>
+	<META NAME="GENERATOR" CONTENT="StarOffice 7  (Linux)">
+	<META NAME="AUTHOR" CONTENT="Ole Solberg">
+	<META NAME="CREATED" CONTENT="20050624;15135900">
+	<META NAME="CHANGEDBY" CONTENT="Ole Solberg">
+	<META NAME="CHANGED" CONTENT="20060128;14015200">
+
+        <META NAME="DESCRIPTION" CONTENT="Apache Derby: Open Source Java Database - Regression Test Results">
+        <META NAME="KEYWORDS" CONTENT="open source database, open source, opensource, database, java, java database, test, testing, regression test, regression testing">
+</HEAD>
+<BODY LANG="en-US" DIR="LTR">
+<!-- Apache Derby: Open Source Java Database - Regression Test Results -->
+
+<title>Apache Derby Open Source Database, Regression Test Results</title>
+</head>
+<body>
+<table style="text-align: left; width: 100%;" border="0" cellspacing="0" cellpadding="0">
+  <tbody>
+    <tr>
+
+      <td style="vertical-align: bottom;"><font face="Albany, sans-serif" size="+3"><i>
+        <a href="http://db.apache.org/derby" target="_top">Apache <b>Derby</b>
+        </a></i></font> is an open source, 100% Java SQL Database.
+      </td>
+      <!--
+      <td style="vertical-align: top; text-align: right;"><i>Web space sponsored by</i>
+        <a href="http://www.sponsor.domain/">
+          <img alt="Sponsor Name" style="border: 0px solid"
+          src="http://www.sponsor.domain/files/logo.gif"><font size="+2"><b>Sponsor Name</b></font>
+        </a>
+      </td>
+      -->
+    </tr>
+  </tbody>
+</table>
+<HR>
+
+<B><FONT FACE="Albany, sans-serif"><FONT SIZE="+2">Apache Derby Test Results</FONT>
+ [<A HREF="http://db.apache.org/derby/derby_tests.html">More!</b></A>]</B></FONT>
+
+<BR><I>Who we are - long variant.</I>
+<P STYLE="font-style: normal">
+</P>
+
+
+<H2>Development trunk</H2>
+
+<H3 STYLE="margin-left: 0.79in">Testset A: e.g. Daily regression test - Derby built off trunk and <br>tested in "sandboxes" per JVM (1.4, 1.5, 1.6), where each "sandbox" represents tests on several OS(and HW) platforms.</H3>
+
+<!-- --> Select <b>Limited:</b> <!-- -->
+<P STYLE="margin-left: 1.58in; font-style: normal">
+<A HREF="sandbox/testing/Limited/">sandbox</A>
+<!--#include virtual="./sandbox/summary.txt"-->
+<br>
+<A HREF="sandboxN/testing/Limited/">sandboxN</A>
+<br>
+<A HREF="sandboxM/testing/Limited/">sandboxM</A>
+</P>
+
+<!--  --> or <b>Full:</b> <!-- -->
+
+<P STYLE="margin-left: 1.58in; font-style: normal">
+<A HREF="sandbox/testing/Full/">sandbox</A>
+<!--#include virtual="./sandbox/summary-full.txt"-->
+<br>
+<A HREF="sandboxN/testing/Full/">sandboxN</A>
+<br>
+<A HREF="sandboxM/testing/Full/">sandboxM</A>
+</P>
+<!--  --> <!-- -->
+
+<H3 STYLE="margin-left: 0.79in">Testset B: e.g. "tinderbox" regression test - Derby built off trunk and <br>tested in a smaller set of "sandboxes" per JVM (1.4, 1.5, 1.6), where each "sandbox" represents tests on (a smaller) set of OS(and HW) platforms.</H3>
+
+<H2>Branches</H2>
+
+<H3 STYLE="margin-left: 0.79in">10.2 Branch</H3>
+
+<H3 STYLE="margin-left: 0.79in">10.1 Branch</H3>
+
+<H3 STYLE="margin-left: 0.79in">10.0 Branch</H3>
+
+
+
+<HR>
+<!--
+<i>Web space sponsored by</i>
+<a href="http://www.thresher.com/">
+  <img align="top" alt="Thresher Consulting" style="border: 0px solid" 
+  src="http://www.thresher.com/files/logo.gif"><font size="+1"><b>Thresher Consulting</b></font>
+</a>
+-->
+
+<!-- Apache Derby: Open Source Java Database - Regression Test Results -->
+
+</BODY>
+</HTML>

Propchange: db/derby/code/trunk/tools/testing/reporting/TEMPLATES/index.shtml
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/tools/testing/reporting/TEMPLATES/testenv.sh
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/TEMPLATES/testenv.sh?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/TEMPLATES/testenv.sh (added)
+++ db/derby/code/trunk/tools/testing/reporting/TEMPLATES/testenv.sh Fri Nov 24 00:35:04 2006
@@ -0,0 +1,39 @@
+# Place in ${SANDBOX} (Above ${derby_source}, i.e. trunk, 10.2, 10.1 ....)
+# Modify to fit your environment
+#
+# Assumes . ./env.sh was first done:
+
+DB2JCCDIR=${DERBYDIR}/db2jcc # Might be somewhere else ....
+
+export ROOT=${derby_source}
+
+JARDIR=$ROOT/jars/insane # Change if you use sane
+DBTOOLDIR=$ROOT/tools/java
+ORO=$DBTOOLDIR/jakarta-oro-2.0.8.jar
+JUNIT=$DBTOOLDIR/junit.jar
+
+DERBY=$JARDIR/derby.jar
+DERBYTOOLS=$JARDIR/derbytools.jar
+DERBYNET=$JARDIR/derbynet.jar
+DERBYCLIENT=$JARDIR/derbyclient.jar
+DB2JCC=$DB2JCCDIR/lib/db2jcc.jar:$DB2JCCDIR/lib/db2jcc_license_c.jar
+DERBYTESTING=$JARDIR/derbyTesting.jar
+DERBYRUN=$JARDIR/derbyrun.jar
+
+LOCALES=$JARDIR/derbyLocale_de_DE.jar:\
+$JARDIR/derbyLocale_es.jar:\
+$JARDIR/derbyLocale_fr.jar:\
+$JARDIR/derbyLocale_it.jar:\
+$JARDIR/derbyLocale_ja_JP.jar:\
+$JARDIR/derbyLocale_ko_KR.jar:\
+$JARDIR/derbyLocale_pt_BR.jar:\
+$JARDIR/derbyLocale_zh_CN.jar:\
+$JARDIR/derbyLocale_zh_TW.jar
+ 
+export CLASSPATH=$DERBY:$DERBYCLIENT:$DERBYTOOLS:$DERBYNET:$DB2JCC:$DERBYTESTING:$DERBYRUN:$ORO:$JUNIT:$LOCALES
+
+# At least needed on SunOs/x86:
+export LC_CTYPE=en_US
+
+# Where the Derby tests are executed:
+export TESTEXECUTIONDIR="/export/home/tmp/${USER}/derby_exec_${TESTSET}_${SANDBOX_}${BRANCH_DIR}"

Propchange: db/derby/code/trunk/tools/testing/reporting/TEMPLATES/testenv.sh
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/tools/testing/reporting/scripts/README.1
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/README.1?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/README.1 (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/README.1 Fri Nov 24 00:35:04 2006
@@ -0,0 +1,345 @@
+Short Story:
+**************************************************************************
+ 1. Create top level directory structure - See APPENDIX 1.
+ 2. Checkout Derby to ${DERBYDIR} - preferably NOT the very latest version
+    since we want to use ${TOOLDIR}/updateDerby to create version info for reports.
+ 2. Copy and modify env.sh, testenv.sh from tools/testing/reporting/TEMPLATES/ to ${DERBYDIR}.
+    Copy and modify index.html, index.shtml from tools/testing/reporting/TEMPLATES/ to ${DERBYDIR}/../
+ 3. ${TOOLDIR}/initDERBYDIR
+ 4. ${TOOLDIR}/updateDerby [revision]
+ 5. ${TOOLDIR}/buildDerby "[MKBUILDZIP]" [antpropertyFile]
+ 6. Create ${DERBYDIR}/testing/builds/baseline.size from ${DERBYDIR}/testing/builds/<revision>.size
+ 7. Edit ${DERBYDIR}/testing/testhostlist
+ 8. ${TOOLDIR}/testDerby ${DERBYDIR}/testing/testhostlist
+ 8. touch ${DERBYDIR}/testing/testlog/${PLATFORM}/externallyVisible for platforms that should be 
+    visible in public reports.
+ 9. ${TOOLDIR}/createBaselineFiles <revision>
+10. ${TOOLDIR}/mkAllDerbyTestInfo
+    Optional: ${TOOLDIR}/mkAllDerbyTestInfo.public
+    Optional: ${TOOLDIR}/mkAllPlotDataAndPlots [INIT] # Use INIT when new baselines created.
+
+After having established the sandbox and report structure you will normally do
+4., 5., 8. and 10. 
+${TOOLDIR}/updateBuildTestDerby  "[MKBUILDZIP]" "[revision]" [antpropertyfile] executes 4, 5 and 8.
+
+
+
+
+
+
+
+Long Story
+****************************************************************************
+The scripts assume Derby is checked out to
+a directory ${DERBYDIR} 
+such that we will have e.g.
+ DERBYDIR=${HOME}/Apache/Derby
+ BRANCH_DIR=trunk
+ derby_source=${DERBYDIR}/${BRANCH_DIR}
+or
+ DERBYDIR=${HOME}/Apache/Derby-10.1
+ BRANCH_DIR=10.1
+ derby_source=${DERBYDIR}/${BRANCH_DIR}
+
+
+The directory structure I have below ${DERBYDIR} is shown in APPENDIX 1..
+
+
+In ${DERBYDIR}/ I have env.sh and testenv.sh which is sourced to 
+set up the environment for update and build(env.sh) and testing(testenv.sh).
+Templates which can be copied to ${DERBYDIR}/ and modified to suite your
+environment are found in ${derby_source}/tools/testing/reporting/TEMPLATES/.
+
+
+
+The scripts are in TOOLDIR=${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts
+Templates for env.sh and testenv.sh are in 
+   TEMPLATEDIR=${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/TEMPLATES
+
+
+
+Main scripts
+************
+
+1. ${TOOLDIR}/updateDerby [revision] (Do '. ./env.sh' first)
+   ==================================
+   cd's to 'derby_source=${DERBYDIR}/${BRANCH_DIR}' as defined
+   in env.sh.
+   Does 'svn update'.
+   Creates/adds to testing/revisionlist. 
+   Creates testing/UpdateInfo/<revision>.txt
+   Updates status files(updateOK, update.out) in UpdateLog.
+   Creates directory UpdateLog/<revision>/ with status info.
+   used in test reports.
+
+
+2. ${TOOLDIR}/buildDerby "[MKBUILDZIP]" "[antpropertyFile]" (Do '. ./env.sh' first)
+   =================================
+   cd's to 'derby_source=${DERBYDIR}/${BRANCH_DIR}' as defined
+   in env.sh.
+   If UpdateLog/updateOK was not created because svn update in 1.
+   was not done, build is not attempted.
+   
+   If build is successful BuildLog/buildOK is created. Creates
+   BuildLog/<revision>/ with info used in test reports.
+
+   After the first successful build you should copy ${DERBYDIR}/testing/builds/<revision>.size
+   to ${DERBYDIR}/testing/builds/baseline.size and edit it to the format for the 
+   baseline.size file shown in this example: # FIXME: create a script...
+# 474376
+# My.first.build
+derby.jar 2257078
+derbynet.jar 186619
+derbyclient.jar 375758
+derbytools.jar 157327
+derbyrun.jar 11771
+derbyTesting.jar 5563839
+
+   Or you might want to use data for some other build...
+
+
+3. ${TOOLDIR}/testDerby ${HOSTLISTFILE} (Do . ./testenv.sh first)
+   ====================================
+   Will exit if UpdateLog/updateOK is not found.
+   ${HOSTLISTFILE} (Usually ${DERBYDIR}/testing/testhostlist) must 
+   contain the list of machines where tests should be run.
+   Assumes ${DERBYDIR} is accessible on all hosts.
+   Uses rsh (or ssh if you choose so) to connect to the hosts
+   and run "${TOOLDIR}/startDerbyTests ${DERBYDIR}.
+   If you just want to run the tests on the build host, remove 
+   the loop over machines and run startDerbyTests locally.
+   
+   ${TOOLDIR}/startDerbyTests executes 
+   ${TOOLDIR}/runAllTests using ${DERBYDIR}/testing/testlist which
+   lists the Derby testsuites to be run (one testsuite name per line).
+   
+   Tests are executed in TESTEXECUTIONDIR: e.g.
+   TESTEXECUTIONDIR="/export/home/tmp/${USER}/testingDerby<platform>/"
+   defined in testenv.sh.
+
+   Test results are reported in ${DERBYDIR}/testing/testlog/<platform>/. 
+   ${DERBYDIR}/testing/testlog/ MUST exist.
+   A zip file containing the ${DERBYDIR}/testing/testlog/<platform>/ is # FIXME FIXME
+   also included in ${DERBYDIR}/testing/testlog/<platform>/. Files
+   matching exceptions listed in ${DERBYDIR}/testing/ExcludeFromZip
+   are NOT included. I use the following exception:
+   
+      **.dat
+      **.ctrl
+      **Tester*.out
+
+
+
+ ${TOOLDIR}/updateBuildTestDerby  "[MKBUILDZIP]" "[revision]" [antpropertyfile] 
+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ executes 1, 2 and 3.
+
+
+4. Creating web presentations
+   ==========================
+
+   Important: cd to ${DERBYDIR} and do '. ./env.sh'.
+
+   Execute '${TOOLDIR}/createBaselineFiles <revision>' to
+   create a baseline for testsuite execution times for all platforms.
+   Or '${TOOLDIR}/createBaselineFilesOnePlatform <revision> <platform>'
+   to create a baseline for one specific platform. (<platform>/Directory name as found in
+   ${DERBYDIR}/testing/testlog/).
+
+   To make data for a platform publicly visible do
+   'touch ${DERBYDIR}/testing/testlog/${PLATFORM}/externallyVisible'.
+
+   The web pages are created by the scripts (check for parameters!)
+   ${TOOLDIR}/testSummariesDerby <revision> [details] :
+          builds a page for platforms/testsuites.
+   ${TOOLDIR}/mkAllDerbyTestInfo
+   ${TOOLDIR}/mkAllDerbyTestInfo.public :
+          builds pages for current, previous and 2 newest numbered revisions :
+                                 ${TOOLDIR}/testSummariesDerby ${LATESTREVISION}
+                                 ${TOOLDIR}/testSummariesDerby ${PREVIOUSREVISION}
+                                 ${TOOLDIR}/testSummariesDerby current
+                                 ${TOOLDIR}/testSummariesDerby previous
+          builds pages for revisions/testsuites :
+                                 (${TOOLDIR}/testHistoriesDerby)
+          builds pages for platforms/revisions :
+                                 (${TOOLDIR}/testPlatformsDerby)
+          builds top level presentation page :
+                                 (${TOOLDIR}/mkDerbyTestIndex)
+
+   'mkAllDerbyTestInfo' and 'mkAllDerbyTestInfo.public' creates index/top level pages for a 
+   limited number of tests over revisions. To create a complete index over *all*
+   tests where test results have been collected do
+   '${TOOLDIR}/mkDerbyTestIndex_all details' and '${TOOLDIR}/mkDerbyTestIndex_all'.
+   The index/top level pages contain a link to these labeled "See full history here!".
+
+
+   With the parameter 'details', pages are created in ${DERBYDIR}/testing/Full/,
+   without the parameter 'details', pages are created in ${DERBYDIR}/testing/Limited/.
+
+
+4.1 Creating test suite duration plots
+    ++++++++++++++++++++++++++++++++++
+    
+   Duration plots are only visible on "Full" pages. Do
+   '${TOOLDIR}/mkAllPlotDataAndPlots [INIT]', using 'INIT' the first time and
+   after baseline files have been modified.
+   NB. Requires gnuplot!
+   
+
+4.2 Adding new platforms
+    ++++++++++++++++++++
+   Assuming test runs have been completed for the new platforms:
+  
+4.2.1 Create baseline files
+      ---------------------
+   'cd ${DERBYDIR};. ./env.sh;. ./testenv.sh'.
+   For each of the newly added platforms do
+   '${TOOLDIR}/createBaselineFilesOnePlatform ${REVISION} ${PLATFORM}'.
+   Remember to do '${TOOLDIR}/mkAllPlotDataAndPlots INIT' to reestablish 
+   all plots using the new baseline.
+
+4.2.2 Present results on "Limited" pages
+      --------------------------
+   To show results for the newly added platforms in "Limited" pages create
+   the file externallyVisible in 
+   ${DERBYDIR}/testing/testlog/${PLATFORM}/.
+   E.g. 'touch ${DERBYDIR}/testing/testlog/${PLATFORM}/externallyVisible'.
+
+
+4.3 Adding revision specific Notes to index pages
+    +++++++++++++++++++++++++++++++++++++++++++++
+
+    If you want to display notes on a revision add a <revision number>.txt file
+    to ${DERBYDIR}/testing/Notes/.
+    HTML formatting is accepted.
+    The note is also displayed in the 'testSummary-<revision number>.html' file.
+
+
+==============================
+
+   OBSERVE: All commands sending mail for update, build and test status are 
+   commented out and must be explicitly enabled!
+
+
+
+-----------------------------------------------------------------------------
+#####################
+   OBSERVE: All commands using scp or ssh to copy or manipulate information
+   on the external publishing web host are commented out and must be explicitly
+    enabled!
+
+   FIXME: Will be removed alltogether: Use e.g. 'rsync' instead for publishing.
+
+#####################
+
+
+
+
+-----------------------------------------------------------------------------
+
+APPENDIX 1.
+==========
+${DERBYDIR} structure:
+
+BuildLog/
+    ...
+    474376/
+    ...
+    474695/
+        buildDetails
+        buildInfo
+        buildInfo.err
+        info
+        localChanges
+        sysinfo.err
+        sysinfo.txt
+    buildOK
+    currentSysInfo.txt
+    lastBuildInfo
+
+FailReports/
+    ...
+    474376.html
+    ...
+    474695.html
+
+Failures -> trunk/tools/testing/reporting/Failures
+
+TestRunLogs/
+    hostA.err
+    hostA.log
+    ....
+    hostN.err
+    nostN.log
+
+UpdateInfo/
+    ...
+    474376.txt
+    ...
+    474695.txt
+    LatestUpdateRevision.txt
+
+UpdateLog/
+    ...
+    474376/
+    ...
+    474695/
+        UpdateTime
+        status-u.err
+        status-u.out
+        svn--version
+        update.err
+        update.out
+
+    update.out
+    updateOK
+
+builds/
+    ...
+    474376.size
+    ...
+    474695.size
+    baseline.size
+
+env.sh
+summary-full.txt
+summary.txt
+testenv.sh
+
+testing/
+    ExcludeFromZip
+    Full/
+    Limited/
+    Notes/
+    ReadyToStartOnCygWin
+    UpdateInfo -> ../UpdateInfo
+    builds -> ../builds
+    revisionlist
+    showtestlist -> testlist
+    testhostlist
+    testlist
+
+    testlog/
+        ...
+        Linux-2.6.9-34.ELsmp_x86_64-x86_64/
+        SunOS-5.10_i86pc-i386/
+        SunOS-5.10_sun4u-sparc/
+            ...
+            474664.zip
+            474695-cpu_mem
+            474695-system
+            474695.csv
+            474695.javainfo
+            474695.txt
+            ...
+            baseline.csv
+            current.csv
+            externallyVisible
+            previous.csv
+            suiteStart.txt
+
+        ...
+
+trunk/ # or 10.1 or ....
+    ...
+    ...

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/README.1
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/tools/testing/reporting/scripts/README.2
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/README.2?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/README.2 (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/README.2 Fri Nov 24 00:35:04 2006
@@ -0,0 +1,96 @@
+1. General
+**********
+These scripts are based on a directory structure where
+
+TESTEXECUTIONDIR (defined in the testenv.sh) specifies where
+tests are executed, and thus where Derby logs and db-files etc. are
+initially placed, and
+
+DERBYDIR (defined in env.sh) specifies where we place dirs and files
+keeping info on update, build and final test reports.
+
+In our environment we execute tests (via rsh/ssh) on a set of hosts
+listed in HOSTLISTFILE(defined in env).
+
+The list of Derby svn revisions we have tested are kept in
+REVISIONLIST(defined in env).
+
+'env' is a "definition" script which is sourced by most other scripts.
+All scripts must also be told where 'env' and other scripts are found:
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+
+
+
+2.Update, build, test.
+*********************
+I use a script 'updateBuildTestDerby' to initiate the full update,
+build, test sequence.
+
+First we define the Derby update and build environement by sourcing
+'env.sh' which we have in ${DERBYDIR}.
+'testenv.sh' defines the Derby test environment.
+${DERBYDIR}.) 
+
+
+2.1. ${TOOLDIR}/updateDerby
+---------------------------
+NB! assumes 'derby_source' is defined. (In our case that would
+actually be ${DERBYDIR}/trunk.)
+
+'updateDerby' creates update status files in ${UPDATELOGDIR}.
+If the update was successful ${REVISIONLIST} is updated and
+${UPDATELOGDIR}/updateOK is created to flag succesful update.
+
+The script may also send mail to inform of the update status
+(${TOOLDIR}/textMail). 
+
+
+2.2. ${TOOLDIR}/buildDerby
+--------------------------
+NB! assumes 'derby_source' is defined. 
+
+If ${UPDATELOGDIR}/updateOK exists we will build Derby.
+
+We do 'ant clobber', 'ant all' and 'ant buildjars'.
+
+'buildDerby' creates build status files in ${BUIDLOGDIR}.
+${BUILDLOGDIR}/builOK is created to flag succesful build.
+
+The script may also send mail to inform of the build
+status(${TOOLDIR}/textMail).
+
+
+2.3. Run tests
+--------------
+${TOOLDIR}/testDerby ${HOSTLISTFILE} uses rsh/ssh to call
+${TOOLDIR}/startDerbyTests on all test hosts in ${HOSTLISTFILE}.
+(In our env. I haven't been able to automatically do this via rsh to
+CYGWIN hosts yet ....)
+
+${TOOLDIR}/startDerbyTests essentially calls ${TOOLDIR}/runAllTests
+which is the main script for running tests and collecting initial test
+results.
+
+${TOOLDIR}/runAllTests takes 
+1) a file listing Derby test suites to be run and 
+2) the full path to where test results are put.
+
+${TOOLDIR}/runAllTests creates the following files which are used by
+the scripts creating the web presentation:
+SUITESLOG="${TESTLOG_PLATF_DIR}/${REVISION}.csv"
+JAVAINFO="${TESTLOG_PLATF_DIR}/${REVISION}.javainfo"
+CURRSUITESLOG="${TESTLOG_PLATF_DIR}/current.csv"
+PREVSUITESLOG="${TESTLOG_PLATF_DIR}/previous.csv"
+LOG="${TESTLOG_PLATF_DIR}/${REVISION}.txt"
+The *.csv files are essentially a summary from the Derby test harness
+${suite}_report.txt files.
+
+When the test suites run on a platform is finished the script may send mail
+to inform of the result. (${TOOLDIR}/textMail). 
+
+
+The *.csv files are a simple textual summary of the test results per
+platform tested. These are actually what I started out with before
+adding the web presentation.
+
+

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/README.2
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/tools/testing/reporting/scripts/TODO
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/TODO?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/TODO (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/TODO Fri Nov 24 00:35:04 2006
@@ -0,0 +1,14 @@
+1. A large number of the scripts expect builds and UpdateInfo to exist in ${DERBYDIR}/testing/. 
+   A better location is ${DERBYDIR}/. 
+   Fix the relevant scripts to use ${DERBYDIR}/builds and ${DERBYDIR}/UpdateInfo.
+   (Currently handled using symlinks....)
+
+2. Merge production of Full and Limited reports. No need to have Limited at all?
+
+3. "Exception handling" in the scripts should be better....
+
+4. Convert the scripts to Ant! (and Java...)
+
+5. Use some standardized mechanism to format the report pages: E.g. XSLT, XPATH...
+
+6. Keep revision, build and test data in a (Derby) database.

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/TODO
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/code/trunk/tools/testing/reporting/scripts/buildDerby
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/buildDerby?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/buildDerby (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/buildDerby Fri Nov 24 00:35:04 2006
@@ -0,0 +1,272 @@
+#!/bin/bash
+# ${TOOLDIR}/buildDerby [MKBUILDZIP] [ANTPROPFILE]
+#
+# if "ZipJars"..:
+MKBUILDZIP=$1
+#
+ANTPROPFILE=$2
+
+# You might want to modify:
+# NOT USED ANY MORE. MYWORKSTATION=atum02.norway.sun.com
+
+# You should NOT need to modify anything below.
+# derby_source must be defined.
+# NB: Assumes . ./env.sh is done to set JAVA_HOME etc. correctly.
+#---------------------------------------------
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+SRCDIR=${derby_source}
+
+if [ ! -e ${SRCDIR} ]
+then
+    echo "${SRCDIR} does not exist."
+    exit
+fi
+
+# GETHOSTNAME="host"
+GETHOSTNAME="echo"
+
+rm -f ${BUILDLOGDIR}/buildOK
+
+SANDBOX=`basename ${DERBYDIR}`
+
+UPDATELOGDIR=${DERBYDIR}/UpdateLog
+if [ ! -e ${UPDATELOGDIR}/updateOK ]
+then
+  echo "Derby was NOT updated:"
+  echo "  ${UPDATELOGDIR}/updateOK does not exist."
+  ### UNCOMMENT TO SEND MAIL. ${TOOLDIR}/textMail "${SANDBOX} was NOT updated" "${MAILTOINT}" "${UPDATELOGDIR}/update.out"
+  exit
+fi
+
+BUILDID=`date +%Y-%m-%d_%H-%M-%S`
+STARTTIME=`date +%Y-%m-%d" "%H:%M:%S`
+BUILDLOGDIRCUR=${BUILDLOGDIR}/${BUILDID}
+mkdir -p ${BUILDLOGDIRCUR}
+if [ ! -e ${BUILDLOGDIRCUR} ]
+then
+    echo "${BUILDLOGDIRCUR} does not exist."
+    exit
+fi
+
+BUILDINFO=${BUILDLOGDIRCUR}/info
+PUBLISHBUILDINFO=${BUILDLOGDIRCUR}/buildInfo
+BUILDDETAILS=${BUILDLOGDIRCUR}/buildDetails
+BUILDHOSTINFO=`uname -srpi`
+BUILDHOST=`uname -n`
+BUILDHOST=`${GETHOSTNAME} ${BUILDHOST} | awk '{print $1}'`
+cd ${SRCDIR}
+
+REVISION=`svn info | grep '^Revision:'`
+REVISION=`echo ${REVISION} | gawk '{ print $2 }'`
+REPOSITORY=`svn info | grep '^URL:'`
+
+echo "Built on ${BUILDHOSTINFO}[${BUILDHOST}] at ${STARTTIME}" \
+                                                  > ${BUILDINFO}
+echo "Using Revision: ${REVISION} from ${REPOSITORY}"      >> ${BUILDINFO}
+echo "ANT_HOME:  ${ANT_HOME}"                    >> ${BUILDINFO}
+echo "JAVA_HOME: ${JAVA_HOME}"                   >> ${BUILDINFO}
+
+# Build information for publishing along with build jars:
+echo "Build information:"                    >  ${PUBLISHBUILDINFO}
+echo "OS: ${BUILDHOSTINFO}"                  >> ${PUBLISHBUILDINFO}
+echo "JAVA_HOME: ${JAVA_HOME}"               >> ${PUBLISHBUILDINFO}
+echo "JDK: ${JAVA_HOME}/bin/java -version :" >> ${PUBLISHBUILDINFO}
+${JAVA_HOME}/bin/java -version               >> ${PUBLISHBUILDINFO} 2>${PUBLISHBUILDINFO}.err 
+cat ${PUBLISHBUILDINFO}.err                  >> ${PUBLISHBUILDINFO}
+
+# ssh ${MYWORKSTATION} "cd ${SRCDIR}; svn status" > ${BUILDLOGDIRCUR}/localChanges
+svn status > ${BUILDLOGDIRCUR}/localChanges
+
+echo "-------------------- ant" > ${BUILDDETAILS}
+# Set ant property file if NOT given as second param.
+if [ "${ANTPROPFILE}" == "" ]
+then
+  ANTPROPFILE=${HOME}/ant.properties
+fi
+echo "${ANTPROPFILE}:"  >> ${BUILDDETAILS}
+cat ${ANTPROPFILE} >> ${BUILDDETAILS}
+
+echo " Build details in: ${BUILDDETAILS}"
+echo "-------------------- ant clobber" \
+                     >> ${BUILDDETAILS} && \
+ant -propertyfile ${ANTPROPFILE} clobber          >> ${BUILDDETAILS} 2>> ${BUILDDETAILS} && \
+echo ""              >> ${BUILDDETAILS} && \
+echo "-------------------- ant all" \
+                     >> ${BUILDDETAILS} && \
+ant -propertyfile ${ANTPROPFILE} all              >> ${BUILDDETAILS} 2>> ${BUILDDETAILS} && \
+echo ""              >> ${BUILDDETAILS} && \
+echo "-------------------- ant buildjars" \
+                     >> ${BUILDDETAILS} && \
+ant -propertyfile ${ANTPROPFILE} buildjars        >> ${BUILDDETAILS} 2>> ${BUILDDETAILS}
+
+ENDTIME=`date +%Y-%m-%d" "%H:%M:%S`
+echo "[Build ended ${ENDTIME},"   >> ${BUILDINFO}
+echo "     started ${STARTTIME}]" >> ${BUILDINFO}
+rm -f ${BUILDLOGDIR}/lastBuildInfo
+cp ${BUILDINFO} ${BUILDLOGDIR}/lastBuildInfo
+grep "rrors " ${BUILDDETAILS} >> ${BUILDLOGDIR}/lastBuildInfo
+grep "BUILD" ${BUILDDETAILS} >> ${BUILDLOGDIR}/lastBuildInfo
+
+BUILDS="${DERBYDIR}/testing/builds"
+# Flag that building went OK:
+if [ -e ${BUILDLOGDIR}/${BUILDID}/buildDetails ]
+then
+  if [ "`grep "BUILD SUCCESSFUL" ${BUILDLOGDIR}/${BUILDID}/buildDetails | wc -l | gawk '{ print $1 }'`" == "3" ] && \
+     [ "`grep "BUILD FAILED"     ${BUILDLOGDIR}/${BUILDID}/buildDetails | wc -l | gawk '{ print $1 }'`" == "0" ]
+  then
+    echo "touch ${BUILDLOGDIR}/buildOK"
+    touch ${BUILDLOGDIR}/buildOK
+
+    # We're in ${SRCDIR}
+    ${TOOLDIR}/calcJarFootprint > ${BUILDS}/${REVISION}.size
+    chmod go+r ${BUILDS}/${REVISION}.size
+    # Publish externally:
+    SRC="${BUILDS}/${REVISION}.size"
+    DST="${PUBLISHDIR}/builds/${REVISION}.size"
+    echo "**** OBS! ${SCPUT} ${SRC} ${PUBLISHUSER}@${PUBLISHSITE}:${DST}"
+    ${SCPUT} ${SRC} ${PUBLISHUSER}@${PUBLISHSITE}:${DST}
+    
+    SUBJECT="Derby build OK - ${REVISION} ${SANDBOX}"
+
+    SHOWBUILDERRORS=""
+    if [ "`grep "errors" ${BUILDLOGDIR}/${BUILDID}/buildDetails | grep "\[javac\]" | wc -l | gawk '{ print $1 }'`" != "0" ]
+    then
+        SUBJECT="WARNING! There were build ERRORs! - ${REVISION} ${SANDBOX}"
+        SHOWBUILDERRORS="${BUILDLOGDIR}/${BUILDID}/buildDetails"
+        echo "touch ${BUILDLOGDIR}/buildERRORS"
+        touch ${BUILDLOGDIR}/buildERRORS
+
+        cp ${BUILDLOGDIR}/${BUILDID}/buildDetails ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails
+
+        SEDSCR="'s:${DERBYDIR}/::'"
+        SEDCMD="sed -e ${SEDSCR} ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails "
+        echo ${SEDCMD} > sedCmd$$
+        . ./sedCmd$$ \
+                   > ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails.txt
+        rm sedCmd$$
+
+        rm ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails
+        chmod go+r ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails.txt
+    fi
+
+    # Do an execution check, and get the sysinfo for use in test reports.
+    java -cp ${SRCDIR}/classes org.apache.derby.tools.sysinfo > ${BUILDLOGDIR}/${BUILDID}/sysinfo.txt 2> ${BUILDLOGDIR}/${BUILDID}/sysinfo.err
+    cp ${BUILDLOGDIR}/${BUILDID}/sysinfo.txt ${BUILDLOGDIR}/currentSysInfo.txt
+
+    # Include ${DERBYDIR}/testing/UpdateInfo/${REVISION}.txt (created by updateDerby) in mails 
+    # REVISION=`echo ${REVISION} | gawk '{ print $2 }'`
+    REVUPDATE="${DERBYDIR}/testing/UpdateInfo/${REVISION}.txt"
+    ### UNCOMMENT TO SEND MAIL. ${TOOLDIR}/textMail "${SUBJECT}" "${MAILTOINT}" "${BUILDLOGDIR}/lastBuildInfo ${BUILDLOGDIR}/${BUILDID}/sysinfo.txt ${SHOWBUILDERRORS} ${REVUPDATE}"
+    ### UNCOMMENT TO SEND MAIL.  ${TOOLDIR}/textMail "${SUBJECT}" "${MAILTOEXT}" "${BUILDLOGDIR}/lastBuildInfo ${BUILDLOGDIR}/${BUILDID}/sysinfo.txt ${SHOWBUILDERRORS} ${REVUPDATE}"
+    mv ${BUILDLOGDIR}/${BUILDID} ${BUILDLOGDIR}/${REVISION}
+    # Observe that e.g. PUBLISHBUILDINFO will no longer be valid: correct def.:
+    PUBLISHBUILDINFO="${BUILDLOGDIR}/${REVISION}/buildInfo"
+
+  if [ "${MKBUILDZIP}" == "ZipJars" ]
+  then
+    # Zip the jars
+    echo "${DERBYDIR}/BuildLog/${REVISION}/sysinfo.txt"
+    ls -al ${DERBYDIR}/BuildLog/${REVISION}
+    DERBYVERSION=`grep "/classes] " ${DERBYDIR}/BuildLog/${REVISION}/sysinfo.txt | gawk -F] '{ print $2 }' | gawk '{ print $1$2 }'`
+    cd ${SRCDIR}/jars/insane/
+    ZIPPEDJARS="Derby${DERBYVERSION}_${BUILDID}-SVN${REVISION}.zip"
+    # Copy COPYRIGHT, LICENSE, NOTICE to ${SRCDIR}/jars/insane/ (current dir.) to show them on outermost level in .zip file
+    cp ${SRCDIR}/jars/insane/lists/META-INF/COPYRIGHT ./COPYRIGHT
+    cp ${SRCDIR}/jars/insane/lists/META-INF/LICENSE   ./LICENSE
+    cp ${SRCDIR}/jars/insane/lists/META-INF/NOTICE    ./NOTICE 
+    chmod a+r COPYRIGHT LICENSE NOTICE 
+    echo "zip -r -q -9  ${BUILDS}/${ZIPPEDJARS} ."
+    zip -r -q -9  ${BUILDS}/${ZIPPEDJARS} .
+    chmod a+r ${BUILDS}/${ZIPPEDJARS}
+    # Transfer the .zip file to ISP:
+    SRC="${BUILDS}/${ZIPPEDJARS}"
+    DST="${PUBLISHDIR}/builds/${ZIPPEDJARS}"
+    ## echo "**** OBS! ${SCPUT} ${SRC} ${PUBLISHUSER}@${PUBLISHSITE}:${DST}"
+    ## ${SCPUT} ${SRC} ${PUBLISHUSER}@${PUBLISHSITE}:${DST}
+
+    # Handle the html page describing builds
+    cd ${BUILDS}
+
+    # Copy COPYRIGHT, LICENSE, NOTICE to builds dir(here):
+    cp ${SRCDIR}/jars/insane/lists/META-INF/COPYRIGHT ./COPYRIGHT
+    cp ${SRCDIR}/jars/insane/lists/META-INF/LICENSE   ./LICENSE
+    cp ${SRCDIR}/jars/insane/lists/META-INF/NOTICE    ./NOTICE 
+    chmod a+r COPYRIGHT LICENSE NOTICE 
+    cp ${PUBLISHBUILDINFO} ./buildInfo${REVISION}
+    chmod a+r buildInfo${REVISION}
+    # Ditto to ISP:
+    ## ${SCPUT} COPYRIGHT ${PUBLISHUSER}@${PUBLISHSITE}:${PUBLISHDIR}/builds/COPYRIGHT
+    ## ${SCPUT} LICENSE   ${PUBLISHUSER}@${PUBLISHSITE}:${PUBLISHDIR}/builds/LICENSE
+    ## ${SCPUT} NOTICE    ${PUBLISHUSER}@${PUBLISHSITE}:${PUBLISHDIR}/builds/NOTICE
+    ## ${SCPUT} buildInfo${REVISION} ${PUBLISHUSER}@${PUBLISHSITE}:${PUBLISHDIR}/builds/buildInfo${REVISION}
+
+    echo "<TR>" > this.txt
+    # Build date & time
+    echo "<TD>${STARTTIME}</TD>" >> this.txt
+    # SVN revision
+    echo "<TD>${REVISION}</TD>" >> this.txt
+    # Build info.
+    BUILDREF="<TD><a href=\"buildInfo${REVISION}\">Build OK</a></TD>"
+    if [ -e ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails.txt ]
+    then
+      BUILDREF="<TD><A HREF=\"../UpdateInfo/${REVISION}-buildDetails.txt\"><font color=\"red\"><b>Build errors</b></font></A></TD>" 
+    fi
+    echo ${BUILDREF} >> this.txt
+    # Test results
+    RESULTREF="<TD><A HREF=\"../Present/testSummary-${REVISION}.html\">Test results</A></TD>"
+                              # Present is a link to Limited(public) or Full(local)
+    echo ${RESULTREF} >> this.txt
+    # zip
+    echo "<TD><A HREF=\"${ZIPPEDJARS}\">${ZIPPEDJARS}</A></TD>" >> this.txt
+    # tar.gz
+    echo "<TD>tar.gz</TD>" >> this.txt
+    echo "</TR>" >> this.txt
+    # NB. 8-eight lines are added per build.
+    # Never present more than last 11 builds so use following 'head -((11-1)*8)' = 'head -80'
+    # NB. Manually clean old zipped jar files locally AND remote.
+    # cp buildlist.txt old_buildlist.txt
+    head -80 buildlist.txt > old_buildlist.txt
+    cat this.txt old_buildlist.txt > buildlist.txt
+    cat top.txt buildlist.txt bottom.txt > index.html
+    cat top_ext.txt buildlist.txt bottom_ext.txt > index_ext.html
+    chmod a+r index.html index_ext.html
+    # Transfer the index_ext.html file to ISP:
+    SRC="index_ext.html"
+    DST="${PUBLISHDIR}/builds/index.html"
+    # echo "**** OBS! ${SCPUT} ${SRC} ${PUBLISHUSER}@${PUBLISHSITE}:${DST}"
+    # ${SCPUT} ${SRC} ${PUBLISHUSER}@${PUBLISHSITE}:${DST}
+  fi #  if [ "${MKBUILDZIP}" == "BuildZippedJars" ]
+    exit
+  fi # if [ "`grep "BUILD FAILED" ${BUILDLOGDIR}/${BUILDID}/buildDetails | wc -l | gawk '{ print $1 }'`" = "0" ]
+
+    ########################################
+    # Buid was not successful, tell it...
+    # PARTLY DUPLICATED FROM ABOVE...
+    ## SHOWBUILDERRORS=""
+    ## if [ "`grep "errors" ${BUILDLOGDIR}/${BUILDID}/buildDetails | grep "\[javac\]" | wc -l | gawk '{ print $1 }'`" != "0" ]
+    ## then
+        SUBJECT="WARNING! There were build ERRORs! - ${REVISION} ${SANDBOX}"
+        ## SHOWBUILDERRORS="${BUILDLOGDIR}/${BUILDID}/buildDetails"
+        echo "touch ${BUILDLOGDIR}/buildERRORS"
+        touch ${BUILDLOGDIR}/buildERRORS
+
+        cp ${BUILDLOGDIR}/${BUILDID}/buildDetails ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails
+
+        SEDSCR="'s:${DERBYDIR}/::'"
+        SEDCMD="sed -e ${SEDSCR} ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails "
+        echo ${SEDCMD} > sedCmd$$
+        . ./sedCmd$$ \
+                   > ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails.txt
+        rm sedCmd$$
+
+        rm ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails
+        chmod go+r ${DERBYDIR}/testing/UpdateInfo/${REVISION}-buildDetails.txt
+    ## fi
+    ########################################
+
+fi
+
+### UNCOMMENT TO SEND MAIL. ${TOOLDIR}/textMail "${SANDBOX} build failed" "${MAILTOINT}" "${BUILDLOGDIR}/lastBuildInfo ${BUILDLOGDIR}/${BUILDID}/buildDetails"
+### UNCOMMENT TO SEND MAIL. # ${TOOLDIR}/textMail "${SANDBOX} build failed" "${MAILTOEXT}" "${BUILDLOGDIR}/lastBuildInfo ${BUILDLOGDIR}/${BUILDID}/buildDetails"

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/buildDerby
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/buildDerby
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/calcJarFootprint
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/calcJarFootprint?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/calcJarFootprint (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/calcJarFootprint Fri Nov 24 00:35:04 2006
@@ -0,0 +1,62 @@
+#!/bin/bash
+# $0 [jardir]. No jardir: uses ${SRCDIR}/jars/insane
+JARDIR=$1
+# You should NOT need to modify anything below.
+# derby_source must be defined.
+# NB: Assumes . ./env.sh is done to set DERBYDIR etc. correctly.
+#---------------------------------------------
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+SRCDIR=${derby_source}
+
+if [ "${DERBYDIR}" == "" ]
+then
+  echo "DERBYDIR is not defined"
+  exit
+fi
+if [ ! -e ${DERBYDIR} ]
+then
+  echo "${DERBYDIR} does not exist."
+  exit
+fi
+
+if [ "${JARDIR}" == "" ]
+then
+  if [ ! -e ${SRCDIR} ]
+  then
+    echo "${SRCDIR} does not exist."
+    exit
+  fi
+  JARDIR=${SRCDIR}/jars/insane
+fi
+cd ${JARDIR}
+BASEREV=`head -1 ${DERBYDIR}/testing/builds/baseline.size | gawk '{ print $2 }'`
+echo "Baseline ${BASEREV}"
+JARS="derby.jar derbynet.jar derbyclient.jar derbytools.jar derbyrun.jar derbyTesting.jar"
+
+OS=`uname -s | gawk -F_ '{ print $1 }'`
+
+for JAR in ${JARS}
+do
+  SIZE=0
+  PERCENT=0
+  if [ -e ${JAR} ]
+  then
+    # DU=`du -sk ${JAR}`
+    # SIZE=`echo ${DU} | gawk '{ print $1 }'`
+    # NAME=`echo ${DU} | gawk '{ print $2 }'`
+    DU=`ls -l ${JAR}`
+    if [ "${OS}" = "SunOS" ]
+    then
+      SIZE=`echo ${DU} | gawk '{ print $4 }'`
+    else
+      SIZE=`echo ${DU} | gawk '{ print $5 }'`
+    fi
+    NAME=${JAR}
+    BASESIZE=`grep ${JAR} ${DERBYDIR}/testing/builds/baseline.size | gawk '{ print $2 }'`
+    PERCENT=`${TOOLDIR}/calcPercent ${SIZE} ${BASESIZE}`
+  fi
+  echo "${NAME} ${SIZE} ${PERCENT}%"
+done
+

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/calcJarFootprint
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/calcJarFootprint
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/calcPercent
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/calcPercent?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/calcPercent (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/calcPercent Fri Nov 24 00:35:04 2006
@@ -0,0 +1,25 @@
+#!/bin/bash
+#
+DIVIDEND=$1
+DIVISOR=$2
+# echo "${currSeconds} / ${baseLineSeconds}"
+let " Percent = ${DIVIDEND}*10000 / ${DIVISOR} "
+let " Decimal = ${Percent} % 100 "
+let " Percent = ${Percent} / 100 "
+# [...]PPP.DD
+if [ "${Decimal}" = "0" ]
+then
+  Decimal="00"
+elif [ ${Decimal} -le 9 ]
+then
+  Decimal="0${Decimal}"
+fi
+if [ ${Percent} -le 9 ]
+then
+  Percent="  ${Percent}"
+elif [ ${Percent} -le 99 ]
+then
+  Percent=" ${Percent}"
+fi
+echo "${Percent}.${Decimal}"
+# echo -e "${Percent}.${Decimal}\tx"

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/calcPercent
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/calcPercent
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/cpu_mem
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/cpu_mem?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/cpu_mem (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/cpu_mem Fri Nov 24 00:35:04 2006
@@ -0,0 +1,24 @@
+#!/bin/bash
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+
+# Temporary patch until gawk is available on techra28/nevada:
+PATH=${PATH}:/usr/local/bin:/usr/sbin
+
+OS=`uname -s | gawk -F_ '{ print $1 }'`
+FULLOS=`uname`
+
+if [ "${OS}" = "SunOS" ]
+then
+   ${TOOLDIR}/solaris-cpu_mem
+elif [ "${OS}" = "Linux" ]
+then
+  ${TOOLDIR}/linux-cpu_mem
+elif [ "${OS}" = "CYGWIN" ]
+then 
+  ${TOOLDIR}/cygwin-cpu_mem
+elif [ "${FULLOS}" = "HP-UX" ]
+then
+  uname -m
+else
+  echo "Haven't yet figured out how to get CPU and MEM info for ${OS}"
+fi

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cpu_mem
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cpu_mem
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFiles
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFiles?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFiles (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFiles Fri Nov 24 00:35:04 2006
@@ -0,0 +1,44 @@
+#!/bin/bash
+REVISION=$1
+
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+# We have one catalog per platform
+if [ ! -e ${TESTLOGDIR} ]
+then
+  echo "${TESTLOGDIR} does not exist"
+  exit
+fi
+
+# Get the list of testsuite we are running:
+TESTLISTFILE="${DERBYDIR}/testing/testlist"
+SUITES=`gawk '{ print $1 }' ${TESTLISTFILE} | grep -v "^#"`
+
+# Get the set of platforms
+cd ${TESTLOGDIR}
+PLATFORMS=`ls`
+
+for PLATFORM in ${PLATFORMS}
+do
+  echo ""
+  echo ${PLATFORM}
+  # Create one file per platform
+  BASELINEFILE="${PLATFORM}/baseline.csv"
+  echo "# ${REVISION}" > ${BASELINEFILE}
+
+  for SUITE in ${SUITES}
+  do
+    # DEBUG 
+echo "SUITE: ${SUITE}"
+    if [ "${SUITE}" == "exit" ]
+    then
+      exit
+    fi
+    TIME=`grep "^${SUITE} " ${PLATFORM}/${REVISION}.csv | gawk '{ sub("\r$", ""); print }' | gawk '{ print $6 }'`
+                                                        # removes DOS endofline
+    SECONDS=`${TOOLDIR}/toSeconds ${TIME}`
+    echo "${SUITE} ${TIME} ${SECONDS}" >> ${BASELINEFILE}
+  done # SUITES
+
+done # PLATFORMS

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFiles
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFiles
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFilesOnePlatform
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFilesOnePlatform?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFilesOnePlatform (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFilesOnePlatform Fri Nov 24 00:35:04 2006
@@ -0,0 +1,59 @@
+#!/bin/bash
+REVISION=$1
+PLATFORM=$2
+
+if [ "${REVISION}" == "" ]
+then
+  echo "Usage: $0 <revision> <platform>"
+  exit
+fi
+if [ "${PLATFORM}" == "" ]
+then
+  echo "Usage: $0 ${REVISION} <platform>"
+  exit
+fi
+
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+# We have one catalog per platform
+if [ ! -e ${TESTLOGDIR} ]
+then
+  echo "${TESTLOGDIR} does not exist"
+  exit
+fi
+
+# Get the list of testsuite we are running:
+TESTLISTFILE="${DERBYDIR}/testing/testlist"
+SUITES=`gawk '{ print $1 }' ${TESTLISTFILE} | grep -v "^#"`
+
+# Get the set of platforms
+cd ${TESTLOGDIR}
+echo "Available tested platforms:"
+ls 
+# We have one catalog per platform
+if [ ! -e ${PLATFORM} ]
+then
+  echo "${PLATFORM} does not exist"
+  exit
+fi
+
+  echo ""
+  echo ${PLATFORM}
+  # Create one file per platform
+  BASELINEFILE="${PLATFORM}/baseline.csv"
+  # if [ ! -e ${BASELINEFILE} ]
+  # then
+  #   echo "Could not find ${BASELINEFILE}"
+  #   exit
+  # fi
+  echo "# ${REVISION}" > ${BASELINEFILE}
+
+  for SUITE in ${SUITES}
+  do
+    TIME=`grep "^${SUITE} " ${PLATFORM}/${REVISION}.csv | gawk '{ sub("\r$", ""); print }' | gawk '{ print $6 }'`
+                                                        # removes DOS endofline
+    SECONDS=`${TOOLDIR}/toSeconds ${TIME}`
+    echo "${SUITE} ${TIME} ${SECONDS}" >> ${BASELINEFILE}
+  done # SUITES
+

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFilesOnePlatform
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/createBaselineFilesOnePlatform
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/cronCurrentTestInfoDerby
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/cronCurrentTestInfoDerby?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/cronCurrentTestInfoDerby (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/cronCurrentTestInfoDerby Fri Nov 24 00:35:04 2006
@@ -0,0 +1,31 @@
+#!/bin/bash
+echo "THIS IS SITE SPECIFIC! FIX!"
+exit
+
+export USER="derbytester"
+export HOME="/home/${USER}"
+export DERBYDIR="${HOME}/Apache/Derby/trunk_JDK15"
+
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+echo "*********************" > ${HOME}/cron/testSummariesDerby.log
+echo "*********************" >> ${HOME}/cron/testSummariesDerby.err
+/bin/date >> ${HOME}/cron/testSummariesDerby.log
+/bin/date >> ${HOME}/cron/testSummariesDerby.err
+
+. ${HOME}/.bashrc >> ${HOME}/cron/testSummariesDerby.log 2>${HOME}/cron/testSummariesDerby.err
+. ${DERBYDIR}/env.sh >> ${HOME}/cron/testSummariesDerby.log 2>${HOME}/cron/testSummariesDerby.err
+
+
+# Internal:
+${TOOLDIR}/testSummariesDerby current details >> ${HOME}/cron/testSummariesDerby.log 2>>${HOME}/cron/testSummariesDerby.err
+
+# For publishing:
+${TOOLDIR}/testSummariesDerby current >> ${HOME}/cron/testSummariesDerby.log 2>>${HOME}/cron/testSummariesDerby.err
+
+
+/bin/date >> ${HOME}/cron/testSummariesDerby.log
+/bin/date >> ${HOME}/cron/testSummariesDerby.err
+echo "---------------------" >> ${HOME}/cron/testSummariesDerby.log
+echo "---------------------" >> ${HOME}/cron/testSummariesDerby.err

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronCurrentTestInfoDerby
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronCurrentTestInfoDerby
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/cronMkAllPlotDataAndPlots
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/cronMkAllPlotDataAndPlots?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/cronMkAllPlotDataAndPlots (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/cronMkAllPlotDataAndPlots Fri Nov 24 00:35:04 2006
@@ -0,0 +1,47 @@
+#!/bin/bash
+echo "THIS IS SITE SPECIFIC! FIX!"
+exit
+
+export USER="derbytester"
+export HOME="/home/${USER}"
+
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+/bin/echo "-------------------------------------------------" > ${HOME}/cron/MkAllPlotDataAndPlots.log
+/bin/echo "-------------------------------------------------" > ${HOME}/cron/MkAllPlotDataAndPlots.err
+/bin/echo -n "${HOST} " >> ${HOME}/cron/MkAllPlotDataAndPlots.log
+/bin/date >> ${HOME}/cron/MkAllPlotDataAndPlots.log
+/bin/date >> ${HOME}/cron/MkAllPlotDataAndPlots.err
+
+. ${HOME}/.bashrc >> ${HOME}/cron/MkAllPlotDataAndPlots.log 2>>${HOME}/cron/MkAllPlotDataAndPlots.err
+
+#----------
+# Built with JDK 1.5
+export DERBYDIR="${HOME}/Apache/Derby/trunk_JDK15"
+cd ${DERBYDIR}
+${TOOLDIR}/mkAllPlotDataAndPlots     >> ${HOME}/cron/MkAllPlotDataAndPlots.log 2>>${HOME}/cron/MkAllPlotDataAndPlots.err
+
+#----------
+# Built with JDK 1.5
+export DERBYDIR="${HOME}/Apache/Derby/tinderbox_trunk_JDK15"
+cd ${DERBYDIR}
+${TOOLDIR}/mkAllPlotDataAndPlots     >> ${HOME}/cron/MkAllPlotDataAndPlots.log 2>>${HOME}/cron/MkAllPlotDataAndPlots.err
+
+#----------
+# Built with JDK 1.5
+export DERBYDIR="${HOME}/Apache/Derby/10.1_JDK15"
+cd ${DERBYDIR}
+${TOOLDIR}/mkAllPlotDataAndPlots     >> ${HOME}/cron/MkAllPlotDataAndPlots.log 2>>${HOME}/cron/MkAllPlotDataAndPlots.err
+
+#----------
+# Built with JDK 1.6
+export DERBYDIR="${HOME}/Apache/Derby/trunk_JDK16"
+cd ${DERBYDIR}
+${TOOLDIR}/mkAllPlotDataAndPlots     >> ${HOME}/cron/MkAllPlotDataAndPlots.log 2>>${HOME}/cron/MkAllPlotDataAndPlots.err
+
+
+/bin/echo "-------------------------------------------------" >> ${HOME}/cron/MkAllPlotDataAndPlots.log
+/bin/echo "-------------------------------------------------" >> ${HOME}/cron/MkAllPlotDataAndPlots.err
+/bin/date >> ${HOME}/cron/MkAllPlotDataAndPlots.log
+/bin/date >> ${HOME}/cron/MkAllPlotDataAndPlots.err

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronMkAllPlotDataAndPlots
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronMkAllPlotDataAndPlots
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/cronMkDerbyTestIndex_all
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/cronMkDerbyTestIndex_all?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/cronMkDerbyTestIndex_all (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/cronMkDerbyTestIndex_all Fri Nov 24 00:35:04 2006
@@ -0,0 +1,56 @@
+#!/bin/bash
+echo "THIS IS SITE SPECIFIC! FIX!"
+exit
+
+export USER="derbytester"
+export HOME="/home/${USER}"
+
+JOB=mkDerbyTestIndex_all
+
+echo "----------------------------------------------------" > ${HOME}/cron/${JOB}.log
+echo "----------------------------------------------------" > ${HOME}/cron/${JOB}.err
+/bin/date >> ${HOME}/cron/${JOB}.log
+/bin/date >> ${HOME}/cron/${JOB}.err
+
+. ${HOME}/.bashrc >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+
+
+export DERBYDIR="${HOME}/Apache/Derby/trunk_JDK15"
+echo "${DERBYDIR} ----------------------------------" >> ${HOME}/cron/${JOB}.log
+. ${DERBYDIR}/env.sh >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+. ${TOOLDIR}/env
+${TOOLDIR}/${JOB} details >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+${TOOLDIR}/${JOB}         >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+
+export DERBYDIR="${HOME}/Apache/Derby/tinderbox_trunk_JDK15"
+echo "${DERBYDIR} ----------------------------------" >> ${HOME}/cron/${JOB}.log
+. ${DERBYDIR}/env.sh >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+. ${TOOLDIR}/env
+${TOOLDIR}/${JOB} details >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+${TOOLDIR}/${JOB}         >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+
+export DERBYDIR="${HOME}/Apache/Derby/10.1_JDK15"
+echo "${DERBYDIR} ----------------------------------" >> ${HOME}/cron/${JOB}.log
+. ${DERBYDIR}/env.sh >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+. ${TOOLDIR}/env
+${TOOLDIR}/${JOB} details >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+${TOOLDIR}/${JOB}         >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+
+export DERBYDIR="${HOME}/Apache/Derby/trunk_JDK16"
+echo "${DERBYDIR} ----------------------------------" >> ${HOME}/cron/${JOB}.log
+. ${DERBYDIR}/env.sh >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+. ${TOOLDIR}/env
+${TOOLDIR}/${JOB} details >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+${TOOLDIR}/${JOB}         >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+
+export DERBYDIR="${HOME}/Apache/Derby/tinderbox_10.1_JDK15"
+echo "${DERBYDIR} ----------------------------------" >> ${HOME}/cron/${JOB}.log
+. ${DERBYDIR}/env.sh >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+. ${TOOLDIR}/env
+${TOOLDIR}/${JOB} details >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+${TOOLDIR}/${JOB}         >> ${HOME}/cron/${JOB}.log 2>>${HOME}/cron/${JOB}.err
+
+
+/bin/date >> ${HOME}/cron/${JOB}.log
+/bin/date >> ${HOME}/cron/${JOB}.err

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronMkDerbyTestIndex_all
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronMkDerbyTestIndex_all
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateAllTestInfoDerby
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateAllTestInfoDerby?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateAllTestInfoDerby (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateAllTestInfoDerby Fri Nov 24 00:35:04 2006
@@ -0,0 +1,23 @@
+#!/bin/bash
+echo "THIS IS SITE SPECIFIC! FIX!"
+exit
+
+export USER="derbytester"
+export HOME="/home/${USER}"
+export DERBYDIR="${HOME}/Apache/Derby/trunk_JDK15"
+
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+/bin/date > ${HOME}/cron/mkAllDerbyTestInfo.log
+/bin/date > ${HOME}/cron/mkAllDerbyTestInfo.err
+
+. ${HOME}/.bashrc >> ${HOME}/cron/mkAllDerbyTestInfo.log 2>>${HOME}/cron/mkAllDerbyTestInfo.err
+. ${DERBYDIR}/env.sh >> ${HOME}/cron/mkAllDerbyTestInfo.log 2>>${HOME}/cron/mkAllDerbyTestInfo.err
+
+# Internal:
+${TOOLDIR}/mkAllDerbyTestInfo details >> ${HOME}/cron/mkAllDerbyTestInfo.log 2>>${HOME}/cron/mkAllDerbyTestInfo.err
+
+# For publishing:
+${TOOLDIR}/mkAllDerbyTestInfo.public  >> ${HOME}/cron/mkAllDerbyTestInfo.log 2>>${HOME}/cron/mkAllDerbyTestInfo.err
+

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateAllTestInfoDerby
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateAllTestInfoDerby
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateBuildTestDerby
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateBuildTestDerby?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateBuildTestDerby (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateBuildTestDerby Fri Nov 24 00:35:04 2006
@@ -0,0 +1,21 @@
+#!/bin/bash
+echo "THIS IS SITE SPECIFIC! FIX!"
+exit
+
+export USER="testderby"
+export HOME="/home/${USER}"
+export DERBYDIR="${HOME}/Apache/Derbytrunk_JDK15"
+
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+/bin/echo "-------------------------------------------------" > ${HOME}/cron/updateBuildTestDerby.log
+/bin/echo "-------------------------------------------------" > ${HOME}/cron/updateBuildTestDerby.err
+/bin/date >> ${HOME}/cron/updateBuildTestDerby.log
+/bin/date >> ${HOME}/cron/updateBuildTestDerby.err
+
+. ${HOME}/.bashrc >> ${HOME}/cron/updateBuildTestDerby.log 2>>${HOME}/cron/updateBuildTestDerby.err
+
+${TOOLDIR}/updateBuildTestDerby "ZipJars"      >> ${HOME}/cron/updateBuildTestDerby.log 2>>${HOME}/cron/updateBuildTestDerby.err
+
+${TOOLDIR}/testSummariesDerby previous details >> ${HOME}/cron/updateBuildTestDerby.log 2>>${HOME}/cron/updateBuildTestDerby.err

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateBuildTestDerby
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cronUpdateBuildTestDerby
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-cpu_mem
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-cpu_mem?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-cpu_mem (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-cpu_mem Fri Nov 24 00:35:04 2006
@@ -0,0 +1,15 @@
+#!/bin/bash
+# NB Assuming all CPUs are identical....
+SYSINF="sysinf$$"
+systeminfo > ${SYSINF}
+NUMBER=`grep "Processor" ${SYSINF} | gawk '{ print $2 }'`
+MODEL=`grep "System Model:" ${SYSINF} | gawk '{ print $3" "$4 }'`
+MODEL2=`grep 'Mhz' ${SYSINF} | gawk '{ print $2" "$3" "$4" "$5" "$6" "$7" "$8" "$9 }'`
+FREQ=`grep 'Mhz' ${SYSINF} | gawk '{ print $10 }'`
+CACHE=`grep "Virtual Memory: Max Size" ${SYSINF} | gawk '{ print $5" "$6 }'`
+
+MEMTOTAL=`grep "Total Physical Memory:" ${SYSINF} | gawk '{ print $4 }'`
+MEMFREE=`grep "Available Physical Memory" ${SYSINF} | gawk '{ print $4" "$5 }'`
+
+echo "${NUMBER} X [${MODEL} ${MODEL2}]: ${FREQ} MHz, ${CACHE} cache. ${MEMTOTAL} Total Memory."
+rm ${SYSINF}

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-cpu_mem
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-cpu_mem
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-system
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-system?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-system (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-system Fri Nov 24 00:35:04 2006
@@ -0,0 +1,11 @@
+#!/bin/bash
+SYSINF="sysinf$$"
+systeminfo > ${SYSINF}
+# OSNAME=`grep "^OS Name:" ${SYSINF} | sed -e 's/OS Name://'`
+# OSVERSION=`grep "^OS Version:" ${SYSINF} | sed -e 's/OS Version://'`
+OSNAME=`grep "^OS Name:" ${SYSINF} | gawk '{ print $3" "$4" "$5" "$6 }'`
+OSVERSION=`grep "^OS Version:" ${SYSINF} |  gawk '{ print $3" "$4" "$5" "$6" "$7" "$8 }'`
+echo "${OSNAME} - ${OSVERSION}"
+rm ${SYSINF}
+
+uname -srvo

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-system
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/cygwin-system
------------------------------------------------------------------------------
    svn:executable = *

Added: db/derby/code/trunk/tools/testing/reporting/scripts/doplot
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/tools/testing/reporting/scripts/doplot?view=auto&rev=478802
==============================================================================
--- db/derby/code/trunk/tools/testing/reporting/scripts/doplot (added)
+++ db/derby/code/trunk/tools/testing/reporting/scripts/doplot Fri Nov 24 00:35:04 2006
@@ -0,0 +1,31 @@
+#!/bin/bash
+TOOLDIR="${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts"
+. ${TOOLDIR}/env
+
+VAR=$1
+# Only accepts _last20
+
+GNUPLOT=/usr/local/bin/gnuplot
+
+# Get the list of testsuite we are running:
+TESTLISTFILE="${DERBYDIR}/testing/testlist"
+SUITES=`gawk '{ print $1 }' ${TESTLISTFILE} | grep -v "^#"`
+
+# Get the set of platforms
+cd ${DERBYDIR}/testing/Full/plot
+PLATFORMS=`ls ${DERBYDIR}/testing/testlog/`
+echo ${PLATFORMS}
+for  PLATFORM in ${PLATFORMS}
+do
+  echo "${PLATFORM}"
+  mkdir -p ${PLATFORM}
+  cd ${PLATFORM}
+  for SUITE in ${SUITES}
+  do
+    cp ${SUITE}${VAR}.data data.dat
+    $GNUPLOT < ${TOOLDIR}/gnuplot/duration.gp
+    mv plot.png ${SUITE}${VAR}.png
+    chmod go+r  ${SUITE}${VAR}.png
+  done
+  cd ../
+done

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/doplot
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: db/derby/code/trunk/tools/testing/reporting/scripts/doplot
------------------------------------------------------------------------------
    svn:executable = *



Mime
View raw message