CN107480046A - A kind of automated testing method, device and computer-processing equipment - Google Patents

A kind of automated testing method, device and computer-processing equipment Download PDF

Info

Publication number
CN107480046A
CN107480046A CN201710564933.7A CN201710564933A CN107480046A CN 107480046 A CN107480046 A CN 107480046A CN 201710564933 A CN201710564933 A CN 201710564933A CN 107480046 A CN107480046 A CN 107480046A
Authority
CN
China
Prior art keywords
defect
sql statement
software
test
tested
Prior art date
Application number
CN201710564933.7A
Other languages
Chinese (zh)
Inventor
顾静雯
Original Assignee
上海斐讯数据通信技术有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 上海斐讯数据通信技术有限公司 filed Critical 上海斐讯数据通信技术有限公司
Priority to CN201710564933.7A priority Critical patent/CN107480046A/en
Publication of CN107480046A publication Critical patent/CN107480046A/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/362Software debugging
    • G06F11/366Software debugging using diagnostics
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3688Test management for test execution, e.g. scheduling of test suites

Abstract

The invention discloses a kind of a kind of the step of being used for and verifying the automated testing method, device and computer-processing equipment, wherein method of testing of defect and regression test to include:The SQL statement for the test case for obtaining defect is collected, and each SQL statement is stored in network cloud database;After defect is repaired in installation, the software to be tested of issue is updated;Treat test software and perform the SQL statement being stored in network data base, check test result;According to test result, determine whether software to be tested solves the defects of SQL statement corresponds to.By means of the invention it is possible to which the defects of substituting part manual checking work and the regression test of New function development phase, will be greatly reduced the cost in the stages such as system testing, maintenance upgrade, testing efficiency is improved.

Description

A kind of automated testing method, device and computer-processing equipment

Technical field

The present invention relates to software test field, is used to verify that the automation of defect and regression test is surveyed more particularly to a kind of Method for testing, device and a kind of computer-processing equipment.

Background technology

In software development process, defect possesses the life cycle of itself.Comprising it is newly-built, assign, test, confirm, delay, Each states such as refusal, closing, it is ensured that the standardization of software process.It wherein can be developed to be set to after defect is repaired and solve State to be tested certainly, then tester can be according to the reproduction step of defect again reduction process.When checking, the problem can not Current defect is considered as when reproduction to be repaired, and can handle shutoff operation.

In addition, software regression testing refers to after have modified old code, re-start test and do not introduced newly with confirming to change Mistake or cause other codes produce mistake.A part of the regression test as software life-cycle, whole soft Occupy very big workload proportion in part test process, each stage of software development can all carry out multiple regression test.Gradually To enter in being developed with iteratively faster, the continuous issue of redaction makes the more frequent of regression test progress, and in Extreme Programming method In, even more require all to carry out regression test several times daily.Therefore, returned by selecting correct regression testing policy to improve The efficiency and validity of test are highly significant.

It is regular less because the defects of being caused in the implementation process of New function by code is various, the craft repeated It is the method taken in current most of Software Testing Project to carry out defect checking and regression test.Use automated test tool To be tested, although not needing manual intervention, there is more limitation.It is general be only applicable to function safeguard, stability compared with Good soft project, to implement regression test and Acceptance Test.

The content of the invention

The present invention solves the technical problem of provide a kind of automatic test for being used to verify defect and regression test Method, apparatus and a kind of computer-processing equipment, the defects of part being substituted manual, verify work and New function development phase Regression test, will be greatly reduced the cost in the stages such as system testing, maintenance upgrade, improve testing efficiency.

To solve technical problem, one aspect of the present invention is:There is provided a kind of for verifying defect and recurrence The automated testing method of test, include the step of this method:The SQL statement for the test case for obtaining defect is collected, and will be every One SQL statement is stored in network cloud database;After defect is repaired in installation, the software to be tested of issue is updated;To be tested soft Part performs the SQL statement being stored in network data base, checks test result;According to test result, determine that software to be tested is It is no to solve the defects of SQL statement corresponds to.

To solve technical problem, one aspect of the present invention is:A kind of computer-processing equipment is provided, including Processor and computer-readable recording medium, processor obtains the computer program on computer-readable recording medium, and performs The step of preceding solution.

To solve technical problem, one aspect of the present invention is:There is provided a kind of for verifying defect and recurrence The automatic test device of test, including:From the side, the SQL statement for the test case for obtaining defect is collected for performing, and The step of each SQL statement is stored in network cloud database;Module is installed, after performing installation reparation defect, renewal The step of software to be tested of issue;Test module, treat test software execution for execution and be stored in network data base SQL statement, the step of checking test result;Object module, for performing according to test result, determine whether software to be tested solves The step of the defects of SQL statement of having determined corresponds to.

It is different from prior art, wraps the step of the automated testing method for being used to verify defect and regression test of the invention Include:The SQL statement for the test case for obtaining defect is collected, and each SQL statement is stored in network cloud database;Installation is repaiied After multiple defect, the software to be tested of issue is updated;Treat test software and perform the SQL statement being stored in network data base, look into See test result;According to test result, determine whether software to be tested solves the defects of SQL statement corresponds to.By the present invention, The defects of part being substituted manual, verifies work and the regression test of New function development phase, will be greatly reduced system testing, The cost in the stages such as maintenance upgrade, improve testing efficiency.

Brief description of the drawings

Fig. 1 is the schematic flow sheet of the automated testing method provided by the present invention for checking defect and regression test.

Embodiment

Many details are elaborated in the following description in order to fully understand the present invention.But the present invention can be with Much it is different from other manner described here to implement, those skilled in the art can be in the situation without prejudice to intension of the present invention Under do similar popularization, therefore the present invention is not limited to the specific embodiments disclosed below.

Secondly, the present invention is described in detail using schematic diagram, when the embodiment of the present invention is described in detail, for purposes of illustration only, institute It is example to state schematic diagram, and it should not limit the scope of protection of the invention herein.

Refering to Fig. 1, Fig. 1 is a kind of automated testing method for being used to verify defect and regression test provided by the invention Schematic flow sheet.The defects of this method is applied to carry out by SQL statement inquiring and authenticating function point the tables of data of server end Checking and regression test process, it is by inputting SQL statement into tables of data, to perform the defects of involved by method of the invention When insertion, inquiry or modification operation, appearance different with expected results and formation.If the later stage by improving software, holds again Result is identical with expection when row equally operates, then it is assumed that the defect has been overcome.The step of this method, includes:

S110:The SQL statement for the test case for obtaining defect is collected, and each SQL statement is stored in network high in the clouds number According to storehouse.

In software test procedure, tester writes test case first, then performs and writes for software to be tested Test case, and check whether implementing result identical with the expected results in test case.It is determined that expected results correctly close On the premise of logic, then it can assert after performing the test case defect occur.In the present invention, go out during collection test software SQL statement corresponding to the test case performed during existing defect, and each SQL statement being collected into is stored in network cloud service In device.The SQL statement of storage may be directed to same tables of data or the different pieces of information table of software to be tested.

In embodiment, software to be tested is set as a kind of data that can obtain client, then will be collected To data analyzed and show software of the form to user.For the test of this software, typically system is being determined Framework, after the content of each tables of data, functional test can be by being directly viewable the number clients received from server end Check whether data are correctly analyzed and show according to whether correctly, and in server end.In this example, the service of the software 3 tables of data are shared in device, wherein the data that 2 (T1, T2) record client reports, in addition 1 (T3) record statement analysis Data.Wherein, T1 tables include attribute:Mac、Time、Event;

T2 tables include attribute:Mac、Brand;

T3 tables include attribute:Mac、Brand、UsedTime.

Mistake is calculated in defective record in testing, UsedTime accounting when Event preserves some value in T3 tables. Understand defect occur when being and the operation of inserted value is performed into table 1, now record and collect the SQL for the test case that defect occurs Sentence, and be saved into network cloud database.

In addition, the defects of being directed to software discovery, except SQL statement corresponding to record, the manifestation mode of the defect should be also preserved, As in above-mentioned embodiment, the manifestation mode of defect is that UsedTime when Event preserves some value in T3 tables can be calculated Mistake.Further, regression test table is established for each defect, the list item is in corresponding SQL statement every time in different editions When being performed on software, implementing result, and version number corresponding to record are recorded.During actual test, after finding defect, generally Need to perform same operation on multiple versions after finding the software version of defect, check whether to occur identical or different The defects of, do not occur the defects of identical or different after being performed on the software version in predetermined number of times, then assert the defect quilt Solve.Meanwhile in the present embodiment, also stored for finding corresponding tables of data during defect in network cloud server, as before When stating in software to the insertion data of table 1, mistake is calculated in table 3, then is also stored table 1 and table 3 simultaneously, with finding that this is lacked Sunken SQL statement packing preserves, and forms packet.

A defect list to be tested is also saving in network cloud database, is enumerated in defect list to be tested to be tested All defect, mark test result in the defect list to be tested after the completion of test.

After the completion of test, SQL statement corresponding to whole defects is saved in network cloud database, into step S120。

S120:After defect is repaired in installation, the software to be tested of issue is updated.

Previous step is treated after test software tested, and obtains whole defects of the software, and find to perform during defect SQL statement.Defect is submitted into research staff to modify.Personnel yet-to-be developed change whole defects, issue the new edition of the software After this, by the software installation of the redaction.

S130:Treat test software and perform the SQL statement being stored in network data base, check test result.

After the successfully software to be tested of redaction is installed, network cloud server is monitoring that new version software is mounted to It is automatic to perform SQL statement corresponding to the test case being stored in server after work(.SQL statement in for test case, Contained in the sentence and perform purpose, perform the information such as object.Server by corresponding SQL statement point to corresponding to tables of data, Perform corresponding operating.By taking the software illustrated in step S110 as an example, the Event attributes continued into table 1 preserve setting value, and really Determining the UsedTime in table 3, whether mistake is calculated in accounting.After the completion of execution, test result is recorded in corresponding regression test table, The version number of the software version of current test software is recorded in regression test table simultaneously.

S140:According to test result, determine whether software to be tested solves the defects of SQL statement corresponds to.

After the completion of corresponding SQL statement is performed all collections the defects of, according to the regression test table of each SQL statement Determine whether the defect has been solved.Specifically, SQL statement corresponding to if the test case of defect is found by performing, does not go out Existing defect, it is determined that software to be tested solves the defects of SQL statement corresponds to.The defects of corresponding to software in step S110, If insert Event values in table 1 again, do not result in UsedTime in table 3 and calculate mistake, while result of calculation and expected phase Together, then it can confirm that the defect has been solved.Similarly, after SQL statement corresponding to all defect is performed in respective table, as a result It is identical with expection, then illustrate that all defect is solved.

, there is defect, then judges whether defect is new in SQL statement corresponding to if the test case of defect is found by performing The defects of appearance.The defects of corresponding to software in step S110, if when inserting Event values in table 1 again, occur in table 3 UsedTime calculates the situation of mistake, or when there are other different from expection situations, the reason for needing decision problem to occur, really The defects of whether being calmly new.During if emerging defect, by the manifestation mode of emerging defect record and with SQL statement pair It should be held in database.Tested again after the software installation of redaction.

Further, the corresponding packet of the defects of passing through is tested in the software upper returning being currently installed on, remains in clothes Preserved on business device, after the software of follow-up redaction is reached the standard grade, continue to test the defect in redaction, if after There is not the defect on continuous multiple versions, then delete packet corresponding to the defect.

It is different from prior art, wraps the step of the automated testing method for being used to verify defect and regression test of the invention Include:The SQL statement for the test case for obtaining defect is collected, and each SQL statement is stored in network cloud database;Installation is repaiied After multiple defect, the software to be tested of issue is updated;Treat test software and perform the SQL statement being stored in network data base, look into See test result;According to test result, determine whether software to be tested solves the defects of SQL statement corresponds to.By the present invention, The defects of part being substituted manual, verifies work and the regression test of New function development phase, will be greatly reduced system testing, The cost in the stages such as maintenance upgrade, improve testing efficiency.

The invention provides a kind of computer-processing equipment, including processor and the side for being stored with execution preceding solution The computer-readable recording medium of the computer program of method step, processor is by performing the meter on computer-readable recording medium Calculation machine program, the step of realizing preceding solution method.

Specifically, the computer-processing equipment includes a kind of automatic test for being used to verify defect and regression test Device, the device include:Memory module, installation module, test module and object module.

Wherein, memory module is used to perform the SQL statement for collecting the test case for obtaining defect, and by each SQL statement The step of being stored in network cloud database.

SQL statement corresponding to the test case performed when there is defect during memory module collection test software, and will The each SQL statement being collected into is stored in network cloud server.The SQL statement of storage may be directed to the same of software to be tested One tables of data or different pieces of information table.

In addition, the defects of being directed to software discovery, except SQL statement corresponding to record, the manifestation mode of the defect should be also preserved, As in above-mentioned embodiment, the manifestation mode of defect is that UsedTime when Event preserves some value in T3 tables can be calculated Mistake.Further, regression test table is established for each defect, the list item is in corresponding SQL statement every time in different editions When being performed on software, implementing result, and version number corresponding to record are recorded.During actual test, after finding defect, generally Need to perform same operation on multiple versions after finding the software version of defect, check whether to occur identical or different The defects of, do not occur the defects of identical or different after being performed on the software version in predetermined number of times, then assert the defect quilt Solve.Meanwhile in the present embodiment, also stored for finding corresponding tables of data during defect in network cloud server, as before When stating in software to the insertion data of table 1, mistake is calculated in table 3, then is also stored table 1 and table 3 simultaneously, with finding that this is lacked Sunken SQL statement packing preserves, and forms packet.

Memory module also saving a defect list to be tested, and to be tested all lack is enumerated in defect list to be tested Fall into, test result is marked in the defect list to be tested after the completion of test.

Module is installed to be used to performing after installation repairs defect, the step of updating the software to be tested of issue.

Treat after test software tested, obtain whole defects of the software, and find the SQL languages performed during defect Sentence.Defect is submitted into research staff to modify.Personnel yet-to-be developed change whole defects, after the redaction for issuing the software, peace The die-filling piece of software installation by the redaction.

Test module, which is used to perform, treats the SQL statement that test software execution is stored in network data base, checks test As a result the step of.

Test module controls the automatic test for performing and being stored in server after monitoring that new version software is installed successfully SQL statement corresponding to use-case.SQL statement in for test case, contain in the sentence and perform purpose, perform object etc. Information.Server by corresponding SQL statement point to corresponding to tables of data, perform corresponding operating.

Whether object module is used to perform according to test result, determine software to be tested to solve corresponding to SQL statement and lack Sunken step.

After the completion of corresponding SQL statement is performed all collections the defects of, according to the regression test table of each SQL statement Determine whether the defect has been solved.Specifically, SQL statement corresponding to if the test case of defect is found by performing, does not go out Existing defect, it is determined that software to be tested solves the defects of SQL statement corresponds to.

, there is defect, then judges whether defect is new in SQL statement corresponding to if the test case of defect is found by performing The defects of appearance.

Although the present invention is disclosed as above with preferred embodiment, it is not for limiting the present invention, any this area Technical staff without departing from the spirit and scope of the present invention, may be by the methods and technical content of the announcement to this hair Bright technical scheme makes possible variation and modification, therefore, every content without departing from technical solution of the present invention, according to the present invention Any simple modifications, equivalents, and modifications made to above example of technical spirit, belong to technical solution of the present invention Protection domain.

Claims (10)

  1. A kind of 1. automated testing method, it is characterised in that including:
    The SQL statement for the test case for obtaining defect is collected, and each SQL statement is stored in network cloud database;
    After defect is repaired in installation, the software to be tested of issue is updated;
    The SQL statement being stored in network data base is performed to the software to be tested, checks test result;
    According to test result, determine whether the software to be tested solves the defects of SQL statement corresponds to.
  2. 2. automated testing method according to claim 1, it is characterised in that be stored in by each SQL statement In the step of network cloud database, including step:
    The defects of all versions test gained before collecting the software to be tested, record finds the SQL statement of defect, and described The manifestation mode of defect;
    Regression test table is established for each defect, SQL corresponding to the defect is at least recorded in the regression test table Implementation status of the sentence when follow-up each version performs, and the corresponding software version performed.
  3. 3. automated testing method according to claim 2, it is characterised in that returned being established for each defect After the step of testing table, including step:
    If after SQL statement corresponding to the defect performs on the software version of predetermined number of times, implementing result is correct result, Then delete the SQL statement of the test case of the corresponding defect stored in the network cloud database, and the corresponding recurrence Test table.
  4. 4. automated testing method according to claim 1, it is characterised in that the network cloud database also stored for It was found that corresponding tables of data during defect, and by the tables of data and find that the SQL statement of defect is integrated into packet and preserved.
  5. 5. automated testing method according to claim 4, it is characterised in that storage is being performed to the software to be tested The SQL statement in network data base, in the step of checking test result, including step:
    Monitor whether the software installation to be tested success of renewal;
    When monitoring that needing test software installs successfully, the SQL statement is performed by the software to be tested;
    The version information of test result and the software to be tested is recorded in regression test table corresponding to the SQL statement.
  6. 6. automated testing method according to claim 5, it is characterised in that it is determined that whether the software to be tested solves In the step of the defects of SQL statement of having determined corresponds to, including step:
    The software to be tested, does not occur defect, it is determined that in SQL statement corresponding to if the test case of defect is found by performing Solves the defects of SQL statement corresponds to;
    , there is defect, then judges whether the defect is new in SQL statement corresponding to if the test case of defect is found by performing The defects of appearance.
  7. 7. automated testing method according to claim 6, it is characterised in that if the defect is emerging defect When, by the manifestation mode of emerging defect record and corresponding with the SQL statement it is held in database.
  8. 8. automated testing method according to claim 1, it is characterised in that also preserved in the network cloud database One defect list to be tested, all defect to be tested is enumerated in the defect list to be tested, in institute after the completion of test State in defect list to be tested and mark test result.
  9. 9. a kind of computer-processing equipment, including processor and computer-readable recording medium, it is characterised in that the processor The computer program on the computer-readable recording medium is obtained, and performs the step such as any methods describeds of claim 1-8 Suddenly.
  10. A kind of 10. automatic test device, it is characterised in that including:
    Memory module, the SQL statement for the test case for obtaining defect is collected for performing, and each SQL statement is stored In the network cloud database the step of;
    Module is installed, for after performing and installing and repair defect, the step of updating the software to be tested of issue;
    Test module, the SQL statement being stored in network data base is performed to the software to be tested for performing, checked The step of test result;
    Object module, for performing according to test result, it is corresponding to determine whether the software to be tested solves the SQL statement The defects of the step of.
CN201710564933.7A 2017-07-12 2017-07-12 A kind of automated testing method, device and computer-processing equipment CN107480046A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710564933.7A CN107480046A (en) 2017-07-12 2017-07-12 A kind of automated testing method, device and computer-processing equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710564933.7A CN107480046A (en) 2017-07-12 2017-07-12 A kind of automated testing method, device and computer-processing equipment

Publications (1)

Publication Number Publication Date
CN107480046A true CN107480046A (en) 2017-12-15

Family

ID=60596548

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710564933.7A CN107480046A (en) 2017-07-12 2017-07-12 A kind of automated testing method, device and computer-processing equipment

Country Status (1)

Country Link
CN (1) CN107480046A (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7010546B1 (en) * 2000-09-20 2006-03-07 Parasoft Corporation Method and system for testing data sources and database oriented software applications
CN103699385A (en) * 2013-12-23 2014-04-02 国云科技股份有限公司 Continuous code integration method
CN104407971A (en) * 2014-11-18 2015-03-11 中国电子科技集团公司第十研究所 Method for automatically testing embedded software
US9111030B1 (en) * 2008-10-03 2015-08-18 Federal Home Loan Mortgage Corporation Systems and methods for testing a software application
CN105930257A (en) * 2015-10-12 2016-09-07 中国银联股份有限公司 Method and apparatus for determining target test cases

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7010546B1 (en) * 2000-09-20 2006-03-07 Parasoft Corporation Method and system for testing data sources and database oriented software applications
US9111030B1 (en) * 2008-10-03 2015-08-18 Federal Home Loan Mortgage Corporation Systems and methods for testing a software application
CN103699385A (en) * 2013-12-23 2014-04-02 国云科技股份有限公司 Continuous code integration method
CN104407971A (en) * 2014-11-18 2015-03-11 中国电子科技集团公司第十研究所 Method for automatically testing embedded software
CN105930257A (en) * 2015-10-12 2016-09-07 中国银联股份有限公司 Method and apparatus for determining target test cases

Similar Documents

Publication Publication Date Title
US9507697B2 (en) Completing functional testing
US7418453B2 (en) Updating a data warehouse schema based on changes in an observation model
CN1763720A (en) Model based diagnosis and repair for event logs
US20030088810A1 (en) Methods and apparatus for determining software component sizes associated with errors
CN101377759B (en) Automatic interface test system
CN102804147A (en) Code inspection executing system for performing a code inspection of ABAP source codes
US8589884B2 (en) Method and system for identifying regression test cases for a software
US7757125B2 (en) Defect resolution methodology and data defects quality/risk metric model extension
US20150095892A1 (en) Systems and methods for evaluating a change pertaining to a service or machine
US20080155343A1 (en) Method, System and Computer Program for Testing Software Applications Based on Multiple Data Sources
US20100280990A1 (en) Etl for process data warehouse
US9619373B2 (en) Method and apparatus to semantically connect independent build and test processes
CN102323945B (en) SQL (Structured Query Language)-based database management method and device
CN100347682C (en) Automatic detection building method
Golfarelli et al. A comprehensive approach to data warehouse testing
JP5232146B2 (en) Methods and configurations for automated testing and characterization data analysis
US20070011541A1 (en) Methods and systems for identifying intermittent errors in a distributed code development environment
JP2008134705A (en) Data processing method and data analysis device
US20110016368A1 (en) System and Method for Automated Configuration Control, Audit Verification and Process Analytics
US8869111B2 (en) Method and system for generating test cases for a software application
CN102650996A (en) Method and device for determining data mapping relationship between database tables
CN103999047A (en) Fix delivery system
US7870169B2 (en) Method for enabling traceability and recovery from errors during migration of software applications
CN102436494B (en) Device and method for optimizing execution plan and based on practice testing
KR101032819B1 (en) Manufacturing prediction server

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination