[Erp5-dev] Analytic unit test report system

[Łukasz Nowak]

Hello,

I tried to have some kind of fast analytic system to understand what
has changed in what unit test. Attached set of scripts might help to
choose best revision compare them.


= fetch_mbox.sh =

It will generate full_erp5_report_mbox.txt, which might be used by
erp5-report-analitics.py

= table-erp5analitics.sql =

Declaration of MySQL table, for which erp5-report-analitics.py will
generate inserts.

= erp5-report-analitics.py =

Generates inserts to MySQL table from mbox file type provided on
command line.

Default invocation.

Create mysql database (eg. erp5analyze), invoke:
cat table-erp5analitics.sql | mysql erp5analyze

Fetch all tests mbox by fetch_mbox.sh or fetch only interesing file
(do not forget to decompress it).

Fill database:

python erp5-report-analitics.py full_erp5_report_mbox.txt | \
mysql erp5analyze

Check database:

mysql erp5analyze
mysql> select * FROM erp5analitics WHERE revision=17204;

To get full report about revision 17204.

I hope that such tool might be able to track down what has happened on
which revision - as for me reading erp5-report archives and comparing
them by hand is not nice :)

Regards,
Luke
--
?ukasz Nowak R&D Ventis http://www.ventis.com.pl/
tel: [phone] fax: [phone]
``Use the Source, Luke...'' I am only craftsman.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: erp5-report-analitics.py
Type: text/x-python
Size: 824 bytes
Desc: not available
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20071030/e200fedb/attachment.py>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: table-erp5analitics.sql
Type: text/x-sql
Size: 277 bytes
Desc: not available
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20071030/e200fedb/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fetch_mbox.sh
Type: application/x-shellscript
Size: 352 bytes
Desc: not available
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20071030/e200fedb/attachment-0001.bin>

[Łukasz Nowak]

Hello,

On 2007-10-30, 13:55:32
?ukasz Nowak <lukasz.nowak at ventis.com.pl> wrote:

(...)

Post by Łukasz Nowak
= erp5-report-analitics.py =
Generates inserts to MySQL table from mbox file type provided on
command line.

(...)

There was bug in fetching test name. Attached corrected version.

Regards,
Luke
--
?ukasz Nowak R&D Ventis http://www.ventis.com.pl/
tel: [phone] fax: [phone]
``Use the Source, Luke...'' I am only craftsman.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: erp5-report-analitics.py
Type: text/x-python
Size: 817 bytes
Desc: not available
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20071030/dbf85c6c/attachment.py>