CN112256544A - Early warning method and device for software problems - Google Patents

Abstract

The purpose of the present invention is to provide an early warning method and equipment for software problems, and to provide a method of using software to regularly connect to a software problem processing server, generate excel tables, calculate deductions, and send emails, which can be applied to installing windows and linux operating system on a general-purpose computer. The method includes: running a program regularly, collecting information in a bug processing server, recording relevant information, automatically assessing personnel according to a specified scoring rule, and automatically sending emails to remind problem software that can be overdue. The method proposed by the invention can effectively improve the problem handling efficiency, reduce the manpower input for early warning, and improve the functions of early warning and evaluation with less cost.

Description

Early warning method and equipment for software problems

technical field

The invention relates to the field of computers, in particular to a method and device for early warning of software problems.

Background technique

In the prior art solution, VB is used as the development language, and Microsoft's subsequent support for this development language is reduced, and the continued development and use may be limited. The existing solution involves manual operation, which increases the probability of errors and consumes manpower. Therefore, the cycle of early warning and assessment is relatively long, and early warning and statistics cannot be carried out every day.

SUMMARY OF THE INVENTION

An object of the present invention is to provide a method and device for early warning and assessment of software problems.

According to one aspect of the present invention, there is provided an early warning method for software problems, the method comprising:

Run the python program regularly through the timing task software.

The python program sends a query instruction to the jira software for the problem processing status of the mobile phone software with the problem attribute, and the jira software returns the current problem processing status of the problematic mobile phone software to the python program based on the query instruction, and the python program will The acquired data is compared with the previous problem processing status of the mobile phone software that has been saved, so as to determine whether the processing of the mobile phone software in question is overdue. If it is overdue, the python program will obtain the overdue status and keep the properties of the mobile software as problems;

The python program sends warning information to the corresponding responsible person based on the overdue days in the overdue result;

The python program is based on the preset overdue deduction rules, the attribute is the overdue result of the mobile phone software, if the attribute is still a problem, the mobile phone software will deduct points from the corresponding responsible person, and send the deduction result to the corresponding responsible person people.

Further, in the above method, the python program saves the query results obtained from Jira in an excel document for subsequent comparison and use. If it is overdue, the python program obtains the overdue state and keeps the properties of the mobile phone software as having problems, including:

The python program writes the overdue results of the mobile phone software whose attributes are still in question into an excel sheet.

Further, in the above method, after the python program sends warning information to the corresponding responsible person based on the number of overdue days in the overdue result, it also includes:

Write the warning information into the excel sheet.

Further, in the above method, the early warning information includes:

Issue Key, Issue Overview, Responsible Person Name, Issue ID, Date of the Day, and Responsible Person Account Number.

Further, in the above method, after the deduction result is sent to the corresponding responsible person, the method further includes:

Write the deduction result into the excel sheet.

According to another aspect of the present invention, an early warning device for software problems is also provided, wherein the device includes:

The problem query module is used for the python program to send a query command to the jira software for the problem processing status of the mobile phone software with problems, and the jira software returns the current problem processing status of the mobile phone software with problems based on the query command to the jira software. The python program compares the acquired data with the previous problem processing status of the mobile phone software that has been saved to determine whether the processing of the mobile phone software in question is overdue. If it is overdue, the python program will obtain the overdue status and keep the properties of the mobile software as problems;

The early warning module is used for the python program to send early warning information to the corresponding responsible person based on the number of overdue days in the overdue result;

The module for calculating points deduction is used for the python program to deduct points for the mobile phone software based on the preset overdue point deduction rules, the attribute is a problem with the mobile phone software, and the mobile phone software for the attribute is still a problem. The deduction result is sent to the corresponding responsible person.

Further, in the above-mentioned device, the calculation point deduction module and the problem query module are shown, which are used by the python program to write the overdue result of the mobile phone software whose attribute is still in question into an excel sheet. .

Further, in the above device, the early warning module is configured to write the early warning information into the excel sheet.

Further, in the above-mentioned device, the early warning information includes: the problem Key, the problem overview, the name of the person in charge, the ID of the problem, the date of the day, and the account number of the person in charge.

Further, in the above device, the calculation point deduction module is configured to write the deduction result into the excel sheet.

Compared with the prior art, the present invention provides a method of using software to regularly connect to a software problem (bug) processing server, generate an excel form, calculate deductions, and send emails, which can be applied to the general installation of windows and linux operating systems. on the computer. The method includes: running a program regularly, collecting information in a bug processing server, recording relevant information, automatically assessing personnel according to a specified scoring rule, and automatically sending emails to remind problem software that can be overdue. The method proposed by the invention can effectively improve the problem handling efficiency, reduce the manpower input for early warning, and improve the functions of early warning and evaluation with less cost.

Description of drawings

Other features, objects and advantages of the present invention will become more apparent by reading the detailed description of non-limiting embodiments made with reference to the following drawings:

1 shows a flowchart of a method for early warning of software problems according to an embodiment of the present invention;

FIG. 2 shows a flowchart of a problem query module according to an embodiment of the present invention;

3 shows a flow chart of a point deduction calculation module according to an embodiment of the present invention;

Fig. 4 shows the main flow chart of the mail sending module of an embodiment of the present invention;

FIG. 5 shows a flow chart of the organization of email sending content according to an embodiment of the present invention.

The same or similar reference numbers in the drawings represent the same or similar parts.

Detailed ways

The present invention will be described in further detail below with reference to the accompanying drawings.

In a typical configuration of the present application, the terminal, the device serving the network, and the trusted party each include one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

Memory may include non-persistent memory in computer readable media, random access memory (RAM) and/or non-volatile memory in the form of, for example, read only memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.

Computer-readable media includes both persistent and non-permanent, removable and non-removable media, and storage of information may be implemented by any method or technology. Information may be computer readable instructions, data structures, modules of programs, or other data. Examples of computer storage media include, but are not limited to, phase-change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read only memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), Flash Memory or other memory technology, Compact Disc Read Only Memory (CD-ROM), Digital Versatile Disc (DVD) or other optical storage, Magnetic tape cartridges, magnetic tape disk storage or other magnetic storage devices or any other non-transmission medium that can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, excludes non-transitory computer-readable media, such as modulated data signals and carrier waves.

As shown in FIG. 1 , the present invention provides an early warning method for software problems, the method includes:

Step S1, the python program sends to the jira software a query instruction for the problem processing status of the mobile phone software with problems, and the jira software returns the current problem processing status of the mobile phone software with problems to the python program based on the query instructions, The python program compares the acquired data with the previous problem processing status of the mobile phone software that has been saved to determine whether the processing of the mobile phone software in question is overdue. If it is overdue, the python program will obtain the overdue status and keep the properties of the mobile software as problems;

Here, you can use the python library and regularly connect to the software problem (bug) processing server through the Jira defect tracking software to query whether there is a problem with the software, get the query result and write it into an excel table;

Step S2, the python program sends early warning information to the corresponding responsible person based on the overdue days in the overdue result;

Step S3, the python program deducts points from the corresponding responsible person for the mobile phone software based on the preset overdue point deduction rules and the attribute is a problem with the mobile phone software, and sends the deduction result to the mobile phone software if the attribute is still a problem. the corresponding responsible person.

Specifically, the problems found in the mobile phone software testing can be entered into jira, the relevant problem areas can be set, and then the SPM (software project manager) and leader (group leader) can be assigned to the relevant software developers to solve the corresponding problems. After setting the problem processing status (such as resolved), the tester will test according to the problem processing status to confirm whether the problem of the mobile phone software still exists. question).

The present invention can query the processing status of mobile phone problems, and will filter out the close (attribute is no problem) when querying, because jira has a maximum number limit for each query, and there are many problems of close, so there is no query. The status of the issue that was closed. After accepting the current problem processing status of the mobile phone software with these attributes as problems, you can compare it with the previous problem processing status to confirm whether the problem processing has expired, whether it has been reopened, etc. Conform to the points deduction rules and whether to reopen, the corresponding points will be deducted.

Early warning is such a mechanism. For example, a problem needs to determine a time to solve it. If it exceeds this time, it will be overdue, and 1 point will be deducted every 7 days. If it is overdue for 3 days, an email reminder will be sent. It does not mean that points must be deducted. Send email alerts, first alert, and deduct points at the time of deduction. The alerts and deductions will be combined together and sent to the corresponding person. Current deduction rules:

a1.Reopen question deducts 1 point at a time;

a2. For a new question without a completion date set, 1 point will be deducted every 7 days, and the warning will start from the 3rd day;

a3. If a question exceeds the set time (the set completion date), 1 point will be deducted every 7 days, and the warning will start from the 3rd day overdue;

An early warning means that points are about to be deducted and points have not been deducted yet. As a reminder, it will trigger the sending of an email; of course, the deduction of points will also trigger the sending of an email. The early warning and the deduction are sent together. If points are deducted, no email will be sent. If someone B has a point deduction without warning, an email will be sent, if someone C has an early warning but no point deduction, an email will be sent, and if someone D has an early warning and a point deduction, an email will be sent.

The email will also indicate the points that have been deducted in the current cycle (such as this month) and the corresponding reasons, and the listed questions will be linked.

Herein, the present invention provides a method of using software to regularly connect to a software bug (bug) processing server, generate an excel sheet, calculate deductions, and send emails, which can be applied to general-purpose computers with Windows and Linux operating systems installed. The method includes: running a program regularly, collecting information in a bug processing server, recording relevant information, automatically assessing personnel according to a specified scoring rule, and automatically sending emails to remind problem software that can be overdue. The method proposed by the invention can effectively improve the problem handling efficiency, reduce the manpower input for early warning, and improve the functions of early warning and evaluation with less cost.

The present invention relates to Jeckins, Jira, Excel, Outlook, Python and related python libraries: jira library, openpyxl, smtplib and the like. in,

Jenkins is an open source software project. It is a continuous integration tool developed based on Java. It is used to monitor continuous repetitive work. It aims to provide an open and easy-to-use software platform that makes continuous software integration possible. It has windows and linux. version, here it can be used to run tasks regularly and repeatedly, plus the python plugin and pythonwrapper plugin plugins can run python scripts.

JIRA is a project and transaction tracking tool produced by Atlassian. It is widely used in defect tracking, customer service, requirements collection, process approval, task tracking, project tracking and agile management. It is used here for defect tracking.

Excel is a spreadsheet software written by Microsoft for computers using the Windows and Apple Macintosh operating systems, where it is used to edit data. Outlook is one of the components of the Microsoft Office software suite. It expands the functions of Outlook express that comes with Windows. Outlook has many functions. You can use it to send and receive emails, manage contact information, keep a diary, arrange schedules, and assign task, which is used here to send emails.

Python is a cross-platform computer programming language and an object-oriented, dynamically typed language. It was originally designed for writing automation scripts (shells). With the continuous updating of versions and the addition of new language features, more and more It is used for the development of independent and large-scale projects. It is easy to use, has many libraries, and can communicate with many existing software, such as openpyxl for processing excel files, smtplib for processing mail, and the jira library provided by Jira for Python. It makes it easy to use python to combine a variety of existing software to complete relatively large projects. If a new unified software is produced, the difficulty and workload are very large. Here is the use of python to build and complete the task of automatic early warning assessment.

Use Jira defect tracking software to manage and control bugs. Its columns mainly include projects, versions, modules, testers and email addresses, handlers and email addresses, and can change handlers and issue status: open, processed, closed, Re-opening, etc., can collect statistics on problems, inquire about problems, and send email notifications when changes are made. Jira provides filters that can filter out those that meet certain conditions, such as open to current time greater than a certain time value.

The invention uses the python language as the development language, and the Python library is very rich. Using the python library can easily realize the automatic generation of excel, the automatic sending of emails, and the automatic acquisition of data from jira. These advantages make the method more convenient to realize, and Python The language is currently the preferred language for programming and development, and has a very good prospect. The scheme of the present invention can realize fully automatic operation, does not need to copy and paste, reduces the probability of error, reduces manpower expenditure, can carry out daily early warning and statistical assessment, and the early warning and statistical assessment are together, and the status of all involved problems is recorded, The reason for the deduction can be easily inquired. Early warnings and deductions are for individuals, and the team leader deducts points, prompting the team leader to supervise and remind. The program developed by using the method runs on an ordinary computer, and can run on both Windows and Ubuntu operating systems, and has good versatility. After the automatic operation every night, an email reminder will be sent and the team leader will be copied. The relevant personnel can view the email corresponding to their own problem during the day. If the reminder is not required, it will not be sent. When you see a related problem, you can directly click the link to deal with it, which greatly improves the efficiency of problem handling.

As shown in FIG. 1 , the present invention uses Jeckins to add a python plug-in to set timings to run three large python modules in sequence: a question query module, a point deduction module, and an email sending module.

As shown in Figure 2, the search range setting table in Figure 2 is included in the Excel table of "Project Personnel Mailbox", and there are three main pages:

Project name, single column, you can fill in the name of the project involved;

Personnel mailbox: three columns, namely personnel account number, name, and email address;

Team Leader Email: Three columns are the Team Leader's account number, name, and email address;

The issue query module reads the project name and personnel account and automatically generates a filter and sends it to Jira, and Jira returns the corresponding issue information. The start time of the issue needs to be corrected, and it can be judged by querying the information of the relevant issue on the previous day. If it is transferred from someone else to someone's name, the start time will start again; the issue start time of the reopen is also reset to the time of the day. The updated data is written into the "Overdue Problem Record" excel sheet, which contains 1 page, and the columns are:

Issue Key, Issue Overview, Responsible Person Name, Project Name, Version, Module, Category, ID, Time of the Day, Start Time, Expected Completion Time, Update Time, Issue Status, and Account Number of the Responsible Person.

In an embodiment of the software problem early warning method of the present invention, in step S2, the python program performs corresponding early warning and/or point deduction processing on the corresponding responsible person of the software whose query result is a problem, and obtains the early warning and/or point deduction processing The results are written to said excel sheet, including:

Based on the preset project name, team name, team leader name, module name and deduction weight, the python program performs corresponding early warning and/or deduction processing for the corresponding person in charge of the software when the query result is a problem, and obtains early warning and / or deduction of processing results and write to the excel sheet.

As shown in Figure 3, the deduction setting table includes 5 columns, namely: project name, team name, team leader name, module name, deduction weight,

By default, each module of the ALL project is filled with the name of the team leader, and then special projects and modules are added later to override the default.

The first page of the points deduction table in the excel sheet can deduct points for the team leader, including 3 columns: the team leader's name, the accumulated score of the team leader, and the team leader's point deduction on the day.

The second page of the deduction table in the excel sheet can be the deduction statistics for the responsible person, including columns: account number of the responsible person, name of the responsible person, accumulated re-opening points, accumulated unwritten estimated completion time deduction, accumulated estimated completion time Overdue points deduction, accumulated update time overdue, total accumulated points deduction, of course re-opening points deduction, no estimated completion time deduction on the day, overdue deduction for the estimated completion time of the day, deduction for overdue update time for the day, and accumulation of deductions for the day.

The third page of the points deduction table in the excel sheet can be a detailed point deduction table, including columns: question key, question overview, person in charge, question ID, current time, account number of the person in charge, re-opening the point deduction, and no prediction. Completion time deduction, estimated completion time overdue deduction, update time overdue, problem status, unwritten estimated completion time overdue days, estimated completion time overdue days, update time overdue days, project name, module, team leader name, deduction weight , Team leader deductions.

In the calculation of the deduction rules for the responsible person, 1 point is deducted from reopening, and 1 point is deducted every 7 days if the estimated completion time is not written, the estimated completion time is overdue, and the update time is overdue.

In an embodiment of the method for early warning of software problems of the present invention, step S1, if the expiration date is exceeded, after the python program keeps the attributes of the mobile phone software as having problems, the method further includes:

The python program writes the overdue results of the mobile phone software whose attributes are still in question into an excel sheet.

As shown in Figure 4, the "Point Deduction" table is an excel document generated by the point deduction calculation module, and the "Problem Status Table of the Day" refers to the table of all problem statuses generated by the query module, as an attachment to the email sent to the responsible person for the convenience of responsibility People check. "Project Personnel Mailbox" is the same as that used by the query module. When sending an email, check the email addresses of the person in charge and the team leader according to this form. The "Points Deduction" form is sent as an attachment to all team leaders. Cc the required people with every message you send.

In an embodiment of the method for early warning of software problems of the present invention, the query result sent by mail includes:

Issue Key, Issue Overview, Responsible Person Name, Issue ID, Date of the Day, and Responsible Person Account Number.

As shown in Figure 5, first add a prompt for the responsible person, and then according to the list (the expected completion date is not written on the day, the expected completion date is overdue, the day's expected completion date is overdue, the day's question is not updated, the day's question is reopened, and the point is deducted. Points will be deducted if the estimated completion date is not written, points will be deducted if the estimated completion date is overdue, and points will be deducted if the question is not updated on the same day. If the question is not updated on the same day and the overdue time is greater than 7 days, points will be deducted when the question is reopened on the day, the estimated completion date is not written on the same day, and the overdue deduction is greater than 0) to add a reminder. A list of language and related questions: Question Key (including link), Question Summary, Responsible Person Name, Question ID, Date of the Day, Responsible Person Account Number, (one item in the list name). If all the query results are unnecessary, no email will be sent.

In an embodiment of the early warning method for software problems of the present invention, in step S2, the python program, based on the number of days overdue in the overdue result, after sending the early warning information to the corresponding responsible person, further includes:

Write the warning information into the excel sheet.

In an embodiment of the method for early warning of software problems of the present invention, step S3, after sending the deduction result to the corresponding responsible person, the method further includes:

Write the deduction result into the excel sheet.

According to another aspect of the present invention, an early warning device for software problems is also provided, wherein the device includes:

The problem query module is used for the python program to send a query command to the jira software for the problem processing status of the mobile phone software with problems, and the jira software returns the current problem processing status of the mobile phone software with problems based on the query command to the jira software. python program, the python program compares the acquired data with the previous problem processing status of the mobile phone software to determine whether the processing of the mobile phone software in question has expired. there is a problem;

The early warning module is used for the python program to send early warning information to the corresponding responsible person based on the number of overdue days in the overdue result;

The module for calculating points deduction is used for the python program to deduct points for the mobile phone software based on the preset overdue point deduction rules, the attribute is a problem with the mobile phone software, and the mobile phone software for the attribute is still a problem. The deduction result is sent to the corresponding responsible person.

Further, in the above-mentioned device, the calculation point deduction module and the problem query module are shown, which are used by the python program to write the overdue result of the mobile phone software whose attribute is still in question into an excel sheet. .

Further, in the above device, the early warning module is configured to write the early warning information into the excel sheet.

Further, in the above-mentioned device, the early warning information includes: the problem Key, the problem overview, the name of the person in charge, the ID of the problem, the date of the day, and the account number of the person in charge.

Further, in the above device, the calculation point deduction module is configured to write the deduction result into the excel sheet.

For details of each device embodiment of the present invention, reference may be made to the corresponding part of each method embodiment, and details are not repeated here.

Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

It should be noted that the present invention may be implemented in software and/or a combination of software and hardware, eg, an application specific integrated circuit (ASIC), a general purpose computer, or any other similar hardware device. In one embodiment, the software program of the present invention may be executed by a processor to implement the steps or functions described above. Likewise, the software program of the present invention (including associated data structures) may be stored in a computer-readable recording medium such as RAM memory, magnetic or optical drives or floppy disks and the like. In addition, some of the steps or functions of the present invention may be implemented in hardware, eg, as circuits that cooperate with a processor to perform the various steps or functions.

In addition, a part of the present invention can be applied as a computer program product, such as computer program instructions, which when executed by a computer, through the operation of the computer, can invoke or provide methods and/or technical solutions according to the present invention. Rather, program instructions for invoking the method of the present invention may be stored in fixed or removable recording media, and/or transmitted via data streams in broadcast or other signal-bearing media, and/or stored in accordance with the in the working memory of the computer device on which the program instructions are executed. Here, an embodiment according to the present invention includes an apparatus including a memory for storing computer program instructions and a processor for executing the program instructions, wherein, when the computer program instructions are executed by the processor, a trigger is The apparatus operates based on the aforementioned methods and/or technical solutions according to various embodiments of the present invention.

It will be apparent to those skilled in the art that the present invention is not limited to the details of the above-described exemplary embodiments, but that the present invention may be embodied in other specific forms without departing from the spirit or essential characteristics of the invention. Therefore, the embodiments are to be regarded in all respects as illustrative and not restrictive, and the scope of the invention is to be defined by the appended claims rather than the foregoing description, which are therefore intended to fall within the scope of the claims. All changes within the meaning and range of the equivalents of , are included in the present invention. Any reference signs in the claims shall not be construed as limiting the involved claim. Furthermore, it is clear that the word "comprising" does not exclude other elements or steps and the singular does not exclude the plural. Several units or means recited in the device claims can also be implemented by one unit or means by means of software or hardware. The terms first, second, etc. are used to denote names and do not denote any particular order.

Claims (10)

1. A software problem early warning method comprises the following steps:

the method comprises the steps that a python program sends a query instruction of a problem processing state of mobile phone software with a problem attribute to the jira software, the jira software returns the current problem processing state of the mobile phone software with the problem to the python program based on the query instruction, the python program compares acquired data with the previous problem processing state of the mobile phone software to judge whether the processing of the mobile phone software with the problem is overdue or not, if the processing is overdue, the python program acquires the overdue state and keeps the attribute of the mobile phone software still in the problem state;

the python program sends early warning information to corresponding responsible persons based on the number of days of the expiration in the expiration result;

the python program deducts the corresponding responsible person from the mobile phone software for the attribute which is still the problem based on the preset overdue deduction rule and the overdue result of the mobile phone software for the problem of the attribute, and sends the deduction result to the corresponding responsible person.

2. The method as claimed in claim 1, wherein if the mobile phone software is overdue, the python program acquires the overdue status and keeps the attribute of the mobile phone software still in question, further comprising:

the python program writes the overdue result of the mobile phone software with the attribute still being in problem into an excel table.

3. The method as claimed in claim 1, wherein the python program further comprises, after sending the warning information to the corresponding responsible person based on the number of overdue days in the overdue result:

and writing the early warning information into the excel table.

4. The method of claim 1, wherein the early warning information comprises:

question Key, question summary, responsible person name, question ID, day date, and responsible person account number.

5. The method of claim 1, wherein after sending the deduction result to the corresponding responsible person, further comprising:

and writing the deduction result into the excel table.

6. An early warning device of a software problem, wherein the device comprises:

the problem query module is used for sending a query instruction of the problem processing state of the mobile phone software with the problem attribute to the jira software by the python program, the jira software returns the current problem processing state of the mobile phone software with the problem to the python program based on the query instruction, the python program compares the acquired data with the previous problem processing state of the mobile phone software to judge whether the processing of the mobile phone software with the problem is overdue or not, if the processing is overdue, the python program acquires the overdue state and keeps the attribute of the mobile phone software still in the problem state;

the early warning module is used for sending early warning information to the corresponding responsible person by the python program based on the number of days of the expiration in the expiration result;

and the calculation deduction module is used for the python program to deduct corresponding responsible persons from the mobile phone software when the attribute is still in question based on the preset overdue deduction rule and the overdue result of the mobile phone software when the attribute is in question, and send the deduction result to the corresponding responsible persons.

7. The device as claimed in claim 6, wherein the calculation deduction module and the problem inquiry module are used for writing the overdue result of the mobile phone software with the attribute still being the problem into an excel table by the python program.

8. The device of claim 6, wherein the pre-alarm module is configured to write the pre-alarm information into the excel table.

9. The device of claim 6, wherein the early warning information comprises: question Key, question summary, responsible person name, question ID, day date, and responsible person account number.

10. The apparatus according to claim 6, wherein the calculation deduction module is configured to write the deduction result into the excel table.

Images