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 ka...@apache.org on 2006/11/24 09:35:06 UTC
svn commit: r478802 [1/3] - in /db/derby/code/trunk/tools/testing/reporting:
./ Failures/ TEMPLATES/ scripts/ scripts/gnuplot/
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 = *