Re: [Sdcc-user] Regression test results database

[Borut R. <bor...@gm...>]

Dear sdcc users an developers,

probably nobody noticed that I added the "Regression Tests" item to the 
left-hand menu on sdcc web page ;-)
The http://sdcc.sourceforge.net/regtests.php page is still not finished. 
Tihs is my TODO list:
- Regression Tests Diffs:
   - colorize the columns from different builds / ports / targets
   - colorize the rows where results are different
   - on rows where results are different: colorize the cells with max 
and min values
- Regression Tests Database, Download full regression test results 
database<http://sdcc.sourceforge.net/download_regtests_db.php> in CSV 
format:
   - download the full database in compressed format (probably bzip2)

Borut

On 05/22/2011 06:14 PM, Borut Ražem wrote:
> First step is already implemented: the regression test results 
> database can be downloaded from the sdcc snapshots page at 
> http://sdcc.sourceforge.net/snap.php . See "Download regression test 
> results database 
> <http://sdcc.sourceforge.net/download_regtests_db.php> in CSV format."
>
> Borut
>
> On 05/22/2011 04:03 PM, Borut Ražem wrote:
>> Dear sdcc developers and users,
>>
>> the sdcc regression test results are from now on stored in a database 
>> at sourceforge. Actually everything is stored in a single table:
>>
>>
>>   regtest_results
>>
>> Table comments: regression test results
>>
>> Field 	Type 	Null 	Default 	Comments 	MIME
>> platform 	varchar(64)	No 			
>> target 	varchar(64)	No 			
>> build_number 	int(11)	No 			
>> date 	date	No 	0000-00-00 		
>> regtest_name 	varchar(255)	No 			
>> failures 	int(11)	No 			
>> tests 	int(11)	No 			
>> cases 	int(11)	No 			
>> bytes 	int(11)	No 			
>> ticks 	int(11)	No 			
>> time 	timestamp	No 	CURRENT_TIMESTAMP 		
>>
>>
>>     Indexes: Documentation
>>     <http://dev.mysql.com/doc/refman/optimizing-database-structure.html>
>>
>> Keyname 	Type 	Unique 	Packed 	Field 	Cardinality 	Collation 	Null 
>> Comment
>> PRIMARY 	BTREE 	Yes 	No 	platform 	0 	A 	
>> 	
>> target 	0 	A 	
>> build_number 	0 	A 	
>> date 	401 	A 	
>>
>>
>>
>> Now we need some WEB GUI to access the database. This can be done in 
>> steps:
>>
>>    1. complete table download in CSV format
>>    2. table download in CSV format, depending on criteria (platform,
>>       target, build_number, date, regtest_name)
>>    3. displaying regtest results, depending on criteria (platform,
>>       target, build_number, date, regtest_name)
>>    4. displaying differences between two regression test results
>>       (build_number, date), depending on criteria (platform, target,
>>       regtest_name)
>>
>> Is there a volunteer who would like to implement it?
>> If you are interested, send me a mail and I'll give you all 
>> additional info you need.
>>
>> Best regards,
>> Borut
>