This page (revision-34) was last changed on 23-Apr-2022 17:06 by Harry Metske

This page was created on 23-Apr-2022 17:06 by Harry Metske

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
34 23-Apr-2022 17:06 32 KB Harry Metske to previous
33 23-Apr-2022 17:06 32 KB Harry Metske to previous | to last
32 23-Apr-2022 17:06 32 KB Harry Metske to previous | to last
31 23-Apr-2022 17:06 32 KB Harry Metske to previous | to last
30 23-Apr-2022 17:06 31 KB Harry Metske to previous | to last
29 23-Apr-2022 17:06 31 KB Harry Metske to previous | to last
28 23-Apr-2022 17:06 31 KB Harry Metske to previous | to last
27 23-Apr-2022 17:06 31 KB Harry Metske to previous | to last
26 23-Apr-2022 17:06 27 KB Harry Metske to previous | to last
25 23-Apr-2022 17:06 27 KB Harry Metske to previous | to last
24 23-Apr-2022 17:06 24 KB Harry Metske to previous | to last 3.0.0-svn-80
23 23-Apr-2022 17:06 19 KB Harry Metske to previous | to last
22 23-Apr-2022 17:06 19 KB Harry Metske to previous | to last
21 23-Apr-2022 17:06 17 KB Harry Metske to previous | to last

Page References

Incoming links Outgoing links
JSPWiki JUnit test performance management
JSPWiki JUnit test performance management

Version management

Difference between version and

At line 7 changed one line
tab content 1
* parse all these files, get the response times out
* store them in an SQL DB (JSPWikiPerfDB)
* table testcase DDL:
{{{
DROP TABLE IF EXISTS `testcaseresult`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `testcaseresult` (
`hostname` varchar(32) NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`classname` varchar(128) NOT NULL,
`name` varchar(128) NOT NULL,
`time` int(11) NOT NULL default '0',
PRIMARY KEY (`hostname`,`timestamp`,`classname`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
}}}
* table testcase example content :
{{{
mysql> select * from testcase;
+----------+---------------------+------------------------------+--------------------+------+
| hostname | timestamp | classname | name | time |
+----------+---------------------+------------------------------+--------------------+------+
| bismarck | 2009-02-14 18:03:35 | org.apache.wiki.TextUtilTest | testEncodeName_1 | 0 |
| bismarck | 2009-02-14 18:03:35 | org.apache.wiki.TextUtilTest | testEncodeName_2 | 6 |
| bismarck | 2009-02-14 18:03:35 | org.apache.wiki.TextUtilTest | testReplaceString1 | 1 |
+----------+---------------------+------------------------------+--------------------+------+
3 rows in set (0.01 sec)
}}}
* table testsuite DDL :
{{{
DROP TABLE IF EXISTS `testsuiteresult`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `testsuiteresult` (
`hostname` varchar(32) NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`name` varchar(128) NOT NULL,
`errors` int(11) NOT NULL default '0',
`tests` int(11) NOT NULL default '0',
`failures` int(11) NOT NULL default '0',
PRIMARY KEY (`hostname`,`timestamp`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
}}}
At line 57 added 2 lines
At line 288 removed 48 lines
* parse all these files, get the response times out
* store them in an SQL DB (JSPWikiPerfDB)
* table testcase DDL:
{{{
DROP TABLE IF EXISTS `testcase`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `testcase` (
`hostname` varchar(32) NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`classname` varchar(128) NOT NULL,
`name` varchar(128) NOT NULL,
`time` int(11) NOT NULL default '0',
PRIMARY KEY (`hostname`,`timestamp`,`classname`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
}}}
* table testcase example content :
{{{
mysql> select * from testcase;
+----------+---------------------+------------------------------+--------------------+------+
| hostname | timestamp | classname | name | time |
+----------+---------------------+------------------------------+--------------------+------+
| bismarck | 2009-02-14 18:03:35 | org.apache.wiki.TextUtilTest | testEncodeName_1 | 0 |
| bismarck | 2009-02-14 18:03:35 | org.apache.wiki.TextUtilTest | testEncodeName_2 | 6 |
| bismarck | 2009-02-14 18:03:35 | org.apache.wiki.TextUtilTest | testReplaceString1 | 1 |
+----------+---------------------+------------------------------+--------------------+------+
3 rows in set (0.01 sec)
}}}
* table testsuite DDL :
{{{
DROP TABLE IF EXISTS `testsuite`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `testsuite` (
`hostname` varchar(32) NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`name` varchar(128) NOT NULL,
`errors` int(11) NOT NULL default '0',
`tests` int(11) NOT NULL default '0',
`failures` int(11) NOT NULL default '0',
PRIMARY KEY (`hostname`,`timestamp`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
}}}
This page (revision-34) was last changed on 23-Apr-2022 17:06 by Harry MetskeTop