LOGIN
התחברות או הרשמה
Avatar
להמשך הרשמה ידנית – לחץ על כפתור ההרשמה, להרשמה/כניסה מהירה בעזרת חשבון רשת חברתית – לחץ על הלוגו בכותרת

אפס סיסמה - שכחתי את שם המשתמש

שם משתמש
סיסמה
זכור אותי

he icon   en icon

בכדי להוסיף פוסט בבלוג יש להרשם או להתחבר - ההרשמה/כניסה מתבצעת מכותרת האתר.

כיצד לפתח מערכת שליחת דוחות אוטומטית ל Bugzilla

נכתב על ידי 
חמישי, 03 אוקטובר 2013 06:33
דרגו כתבה זו
(2 הצבעות)

 

 

 

 

 

How to develop you own Bugzilla report server

 

As part of Q.A manager tasks you are required to send various reports on your project quality.

If doing it the right way these reports can give you a lot of information on you projects for example:

Which module has the most critical bugs, how may bugs you team produces, what is the reopen bugs rate , bugs trends and a lot of other KPI which can give your managers information how to improve the quality of your projects.

There is a lot of knowledge in the Bugzilla Data base and you as a Team leader should use it to reflect this in formation correctly.

Several months ago I was asked to setup an automatic solution for generating Bugzilla reports based on several KPIs which our managers defined.

After searching the web I could not find a simple solution which suite our needs (at least not a simple one).

All of you probably familiar with a simple program called “excel” J.

Wouldn’t it be nice to get every day an excel report to you mail which reflect your products status, trends etc..

So…. Let’s start.

Bugzilla is using MySql DB, you can download mysql connector

http://dev.mysql.com/downloads/connector/odbc/5.1.html

And set up an ODBC connection

http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-examples-tools-with-wordexcel.html

(you will need the correct privileges for connecting directly to the Bugzilla DB like username , password and port, ask you IT guys for that)

Now that you have the connection you can easily import data from Bugzilla DB to your excel file, perform all kind of calculations, generate graphs and use all of excel features as you like.

I have setup a windows schedule task for rendering the excel file on a daily bases and sending it to several managers.

Now I had to deal with another problem, our managers liked it so much that they started to ask me for additional reports which were very hard or even impossible to extract form Bugzilla the way the DB structure is.

So to overcome this I have setup additional MySql DB which saves snapshots from the original Bugzilla DB (it is very simple to install MySql DB , generate tables using HeidiSQL client).

You can export MySql queries from the original Bugzilla DB and import it to you snapshots DB.

Once again generate your reports from the snapshots DB.

All of the reports can be on the same excel file connecting to both MySql DB (see example)

I am sure that there are other ways achieving this task but I needed a free simple and flexible solution which everyone knows. 

Enjoy

 

 

 

 

שונה לאחרונה ב שישי, 04 אוקטובר 2013 11:31

חובה להיות משתמש רשום במערכת בכדי להגיב - ההרשמה/כניסה בכותרת האתר

חדשות מעולם הבדיקות

  • Humidifier For Home Heater

    Humidifier For Home Heater humidifier for home heater humidifier for sq ft. . . . . . . . . . . . . . .

    25.05.2019 | 11:08 קרא עוד...
  • ATA Meetup #22 - Bangalore - Amazing experience

    ATA Meetup #22 - Bangalore - Amazing experience Reached super earlyThe session was supposed to start at 9 AM and I reached by 7.45 AM. I did not want to be late. Due to weekend's minimalistic traffic and super driver, I surprised myself and I thought I can just enter and wait in the hall. The security asked me the contact person name and I told him that there is a meetup by Agile Testing Alliance - did not help. I called up Aditya Garg and somehow the security got convinced that I can at least pass the main barricade and sit on the makeshift park seats.It was nice to experience fresh air, have fruits and dive into an interesting book called "The Practicing Mind" by Thomas M. Sterner. The Practicing Mind I remembered the discussions with Shrini Kulkarni about consciousness, mind, awareness as I read the book. Around 8.40 AM, Thrivikram and Venkata P from HCL welcomed and escorted me to the induction hall where we had the meetup. The conversation between them and the security folks was an interesting one making me think of the process adherence vs value addition. Learning for me: Know the contact person in advance and keep them informed about surprises in plan. HCL ServicesThe first session was by HCL management represented by Prashantha M who highlighted the various services offered by HCL, the case studies and the learning. There were few really good questions by the audience who wanted to know more details about the insights shared to them.My tip: Knowing[…]

    25.05.2019 | 11:55 קרא עוד...
  • Performance testing (benchmarking) Java code with JMH

    Performance testing (benchmarking) Java code with JMH Contents:1) Introduction2) Is it easy?3) Common pitfalls4) Setup5) How to configure JMH?6) Configuration options7) Configuration - predefining state8) Demo9) Results10) Further reading1. IntroductionAs test engineers when we approach performance testing we usually only think about final end-to-end application verification with tools such as JMeter, Locust or Gatling. We know that such tests should run on a separate environment with conditions resembling production as close as possible. Unfortunately in some cases (especially with monolithic architecture) dedicated performance testing environment is hard to get. What to do in such cases? Should we test on common test environment? Or should we test on production? Or maybe we should change our approach to performance testing?  Each option has advantages and disadvantages.Today I'd like to describe low-level performance testing (often called benchmarking) of Java code. It does not require a separate environment. It can be executed directly from your IDE (although that's not recommended) or from the command line. Measuring the performance of critical pieces of code is essential for everyone who creates applications, frameworks, and tools. Testers are co-creators so it's also our responsibility. 2) Is it easy?Benchmarking correctly is hard. There are multiple optimizations implemented on the JVM/OS/hardware side which make it challenging. In order to measure right, you need to understand how to avoid those optimizations because they may not happen in the real production system. Thankfully, there is a tool which helps you mitigate those issues called JMH (Java Microbenchmark Harness). It was created for building, running, and analyzing nano/micro/milli/macro benchmarks written in Java[…]

    25.05.2019 | 8:10 קרא עוד...

טיפים

  • צור מפת חשיבה – Mind Map
    צור מפת חשיבה – Mind Map  צור מפת חשיבה – Mind Map MM - מאפשרת לנו להציג רעיונות בצורה גרפית מרוכזת, ולתאר קשרים בין הפרמטרים השונים המשפיעים על הנושא. כאשר יתרונותיה על עץ בדיקות הנן בעיקר ביכולת להוסיף אייקונים וצבעים המשפרים את…
    קרא עוד...
  • אל תשאירו Bug validation לסוף הגירסה - טפלו מוקדם ככול האפשר
    אל תשאירו Bug validation לסוף הגירסה - טפלו מוקדם ככול האפשר אל תשאירו Bug validation לסוף הגירסה - טפלו מוקדם ככול האפשר, אח"כ הם מצטברים ולא נותר זמן לטפל. באגים נוהגים להתקבץ - גם במקרה הפחות נפוץ שהבאג אכן טופל עם כל ההשפעות שציינתם :-), דיי סביר…
    קרא עוד...
לרשימה המלאה >>