CN109254988A - Report automatic test approach, device, computer storage medium and equipment - Google Patents
Report automatic test approach, device, computer storage medium and equipment Download PDFInfo
- Publication number
- CN109254988A CN109254988A CN201810880377.9A CN201810880377A CN109254988A CN 109254988 A CN109254988 A CN 109254988A CN 201810880377 A CN201810880377 A CN 201810880377A CN 109254988 A CN109254988 A CN 109254988A
- Authority
- CN
- China
- Prior art keywords
- report
- index
- file
- source data
- test
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3684—Test management for test design, e.g. generating new test cases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
Abstract
The present invention provides a kind of report automatic test approach, device, computer storage medium and equipment, this method comprises: extracting each index for including in preset report form formula specification document；It generates the corresponding source data file of each index at random according to testing requirement, and source data file is reported into report server, so that report server generates according to testing requirement and source data file the report file of each index；The end value of each index is calculated separately using the calculation formula of each index according to source data file, and report test file is generated according to the end value of each index；The report file that report server generates is obtained, accuracy test is carried out according to report file of the report test file to acquisition.The present invention solve manual testing not comprehensively, low efficiency, it is at high cost, test errors rate is high the problems such as, effectively increase report test accuracy rate and testing efficiency, can preferably ensure the stability and accuracy of product.
Description
Technical field
The present invention relates to the field of test technology more particularly to a kind of report automatic test approach, device, computer storage Jie
Matter and equipment.
Background technique
Report needs the data of statistical report with formats such as table, charts exactly come Dynamically Announce.To company report
Speech, is the basis of business administration performance.And in the communications industry, whether 2G, 3G, 4G or the 5G epoch come up to us, report
Table be all can not defect a part, communication report include cutting off rate, data speed of download, percent of call completed etc..
Nowadays network Development is swift and violent, and voice service and data service are communications industry main businesses, report business it is important
Property be also more and more obvious, the accuracy of report directly affects operator, however report form index is mostly disorderly and complicated, the report of different systems
Table index one shares thousands of multiple, and not comprehensive there is only testing if manually tested one by one, man efficiency is low, cost
High problem, and it is bigger a possibility that test errors, it is difficult to realize the accurate test of report.
Therefore, how the accuracy of convenient and efficient time saving and energy saving testing journal sheet is asked at the emphasis that tester pays close attention to
Topic.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind
State report automatic test approach, device, computer storage medium and the equipment of problem.
The first aspect of the present invention provides a kind of report automatic test approach, comprising:
Extract each index for including in preset report form formula specification document；
It generates the corresponding source data file of each index at random according to testing requirement, and the source data file is reported into report
List server, so that the report server generates according to the testing requirement and the source data file report of each index
File；
The end value of each index, and root are calculated separately using the calculation formula of each index according to the source data file
Report test file is generated according to the end value of each index；
The report file that the report server generates is obtained, according to the report test file to the report file of acquisition
Carry out accuracy test.
Optionally, each index for including in report form formula specification document is extracted, comprising:
Python interface is configured, the python interface is used to read the index classification in the report form formula specification document
With the index name in each index classification including index；
The each index for including in the report form formula specification document is extracted based on the python interface.
It is optionally, described to generate the corresponding source data file of each index at random according to testing requirement, comprising:
Testing requirement file is obtained, includes the device identification and report form type of network element in the testing requirement file；
The corresponding source data template of the network element is searched according to the device identification；
The corresponding source data file of each index of generating random number using the source data template and currently generated.
Optionally, the report file for obtaining the report server and generating, comprising:
Matched sql query statement is generated according to testing requirement, it is corresponding from report server using the sql query statement
Database in extract the report file.
The second aspect of the present invention provides a kind of report automatic testing equipment, comprising:
Extraction module, for extracting each index for including in preset report form formula specification document；
Generation module, for generating the corresponding source data file of each index at random according to testing requirement, and by the source
Data file reports report server, so that the report server is generated according to the testing requirement and the source data file
The report file of each index；
Computing module, for calculating separately each index using the calculation formula of each index according to the source data file
End value, and according to the end value of each index generate report test file；
Test module, the report file generated for obtaining the report server, according to the report test file pair
The report file of acquisition carries out accuracy test.
Optionally, the extraction module, comprising:
Configuration unit, for configuring python interface, the python interface is for reading the report form formula specification text
It include the index name of index in index classification and each index classification in shelves；
Extraction unit, for extracting each finger for including in the report form formula specification document based on the python interface
Mark.
Optionally, the generation module, comprising:
Acquiring unit includes the device identification of network element for obtaining testing requirement file, in the testing requirement file with
And report form type；
Searching unit, for searching the corresponding source data template of the network element according to the device identification；
Generation unit, each index of generating random number for using the source data template and currently generating are corresponding
Source data file.
Optionally, the test module is specifically used for generating matched sql query statement according to testing requirement, utilizes institute
It states sql query statement and extracts the report file from the corresponding database of report server.
In addition, it is stored thereon with computer program the present invention also provides a kind of computer readable storage medium, the program
The step of report automatic test approach as described in relation to the first aspect is realized when being executed by processor.
In addition, the present invention also provides a kind of equipment, including memory, processor and storage on a memory and can located
The computer program run on reason device realizes that report is tested automatically as described in relation to the first aspect when the processor executes described program
The step of method.
Report automatic test approach, device, computer storage medium and equipment provided in an embodiment of the present invention, using random
The truthful data of the source data file analog network equipment of generation reports report server, passes through the report generated to report server
List file is compared with the report test file that local computing obtains, and realizes the accuracy test of report.The present invention solves
Manual testing not comprehensively, low efficiency, it is at high cost, test errors rate is high the problems such as, effectively increase report test accuracy rate and
Testing efficiency can preferably ensure the stability and accuracy of product.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 is the flow diagram of report automatic test approach provided in an embodiment of the present invention；
Fig. 2 is the structural schematic diagram of report automatic testing equipment provided in an embodiment of the present invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
Those skilled in the art of the present technique are appreciated that unless otherwise defined, all terms used herein (including technology art
Language and scientific term), there is meaning identical with the general understanding of those of ordinary skill in fields of the present invention.Should also
Understand, those terms such as defined in the general dictionary, it should be understood that have in the context of the prior art
The consistent meaning of meaning, and unless otherwise will not be explained in an idealized or overly formal meaning by specific definitions.
In order to solve, manual testing's report accuracy is existing in the process to test not comprehensive, inefficiency, at high cost, test
The problems such as error rate is high, the invention proposes a kind of report automated testing methods based on robotframework platform.Make
For a kind of example, invention will be illustrated so that the report in communication equipment is tested as an example.All standard base stations of communications industry, such as
The standard of this test method tested K PI index can be used in GSM, TD-SCDMA, WCDMA, TD-LTE, FDD-LTE, BBU, EPC etc.
True property.
Fig. 1 diagrammatically illustrates the flow chart of the report automatic test approach of the embodiment of the present invention.Referring to Fig.1, of the invention
The report automatic test approach of embodiment specifically includes the following steps:
S11, each index for including in preset report form formula specification document is extracted.
In the present embodiment, each index for including in report form formula specification document is extracted, can specifically pass through following steps reality
Existing: configuration python interface is called for robotframework；The python interface is for reading the report form formula specification
It include the index name of index in index classification and each index classification in document；Based on described in python interface extraction
The each index for including in report form formula specification document.Wherein, the present embodiment middle finger is designated as the KPI index of communication equipment.
Wherein, report form formula specification document is as test specification, include each index for including in report to be tested with
And the corresponding calculation formula of each index.Further, it after extracting each index in report form formula specification document, goes back
It include: that report displayed page is opened by the library Selenium in robotframework platform, to obtain the parameter tree of report,
Realize that the parameter of KPI index is mating according to the parameter tree of report for subsequent.Parameter is mating, is to verify report and show
Index classification and index name should all be consistent with report form formula specification document.The matched specific implementation process of parameter is to use
The classification that python interface is read searches in parameter tree and classifies with the presence or absence of this, and so on, then lookup pair in corresponding classification
The index name answered.
Wherein, Robot Framework is the Function Test Automation frame that a python writes.Have it is good can
Scalability supports crucial word drive, can test a plurality of types of clients or interface simultaneously, can carry out distributed testing
It executes.
S12, the corresponding source data file of each index is generated at random according to testing requirement, and will be on the source data file
Report server is reported, so that the report server generates each index according to the testing requirement and the source data file
Report file.
In the present embodiment, need in robotframework top layer input test demand file, testing requirement file
Device identification and report form type including network element etc., such as network element+hour+period.Report form type includes small Times, day
Report, weekly etc..If it is small Times, then 4 source data files in this period are automatically generated.Because there are two the numbers of hour
According to can then calculate day report.So then automatically generating 8 source data files for day report.
Wherein, it generates the corresponding source data file of each index at random according to testing requirement, can specifically pass through following steps
It realizes: obtaining testing requirement file；The corresponding source data template of the network element is searched according to the device identification；Utilize the source
Data template and the corresponding source data file of each index of the generating random number currently generated.
Specifically, the corresponding XML template of different network elements equipment is different, XML template can from GSM, TD-SCDMA, WCDMA,
The equipment such as TD-LTE, FDD-LTE, BBU, EPC side obtains, and unlimited customized type is applied widely.It can be modified according to testing requirement
The filename and content of XML template generate four source data files if a hour, there are four source data files at this time,
And random number is inserted into each source data file, test scene is generated at random.The source data file of generation is uploaded into report at this time
It on list server, by the parsing of server, is put in storage after server successfully resolved, is finally presented in report interface.
S13, the end value for calculating separately each index using the calculation formula of each index according to the source data file,
And report test file is generated according to the end value of each index.
When according to generating random number source data file, it is also necessary to random number is recorded in execl with corresponding index,
For calculating the end value of each index using the calculation formula of each index according to the random number in source data file, and according to
The end value of each index generates report test file.
S14, the report file that the report server generates is obtained, according to the report test file to the report of acquisition
File carries out accuracy test, and ultimately generates test result.
Specifically, matched sql query statement can be generated according to testing requirement, using the sql query statement from report
The report file is extracted in the corresponding database of list server, to realize obtaining for the report file generated to report server
It takes.Specifically, report server can be logged on by sshlibrary, sql sentence is combined to search report according to testing requirement
The report messages of the network element, are then introduced into execl in the corresponding database of server, locally downloading.
Report automatic test approach provided in an embodiment of the present invention solves communications industry KPI index mostly and calculates complexity,
Artificial detection is such as used, not only error rate is high and the problems such as spending working hour more.The present invention is based on robotframework platforms to open
The automatic test KPI tool of hair not only can be with simple operations web, number using the distinctive advantage of robotframework itself
According to library, python interface may call upon, aspect is developed with regard to script, transplantability is high, and development difficulty is low, just test aspect, not only
Improve accuracy rate, also greatly reduce cost of labor, test it is not comprehensive the problems such as, preferably ensure product stability and
Accuracy.
In embodiments of the present invention, the generation of report test file and the extraction of server database report file can be determined
Shi Zhihang, if inquiring small Times, next time integral point is executed, if inquiry day report, daily morning execute, if inquiry
Weekly, then morning next Sunday executes, and so on.
The present invention is divided into two parts, a part is used to by robotframework input test demand
Robotframework is calculated automatically, and another part is exported for being put in storage after successfully resolved of uploading onto the server by database
It is that report program calculates to compare as a result, then passing through the two, show that report program calculates the accuracy of KPI, it is accurate to improve
Cost of labor greatly reduces in rate.
Report provided by the invention is tested automatically, and implementation is simple, and code for code compatibility is good, transplantability is high, is convenient for the later period
Continuous integrating.Intelligible, this method is not only applicable in communication equipment, and any associated report business, statistics calculate industry
Business or the mating business of parameter, consider such test mode.
For embodiment of the method, for simple description, therefore, it is stated as a series of action combinations, but this field
Technical staff should be aware of, and embodiment of that present invention are not limited by the describe sequence of actions, because implementing according to the present invention
Example, some steps may be performed in other sequences or simultaneously.Secondly, those skilled in the art should also know that, specification
Described in embodiment belong to preferred embodiment, the actions involved are not necessarily necessary for embodiments of the present invention.
Fig. 2 diagrammatically illustrates the structural schematic diagram of the report automatic testing equipment of the embodiment of the present invention.Referring to Fig. 2, originally
The report automatic testing equipment of inventive embodiments specifically includes extraction module 201, generation module 202, computing module 203 and surveys
Die trial block 204, in which:
Extraction module 201, for extracting each index for including in preset report form formula specification document；
Generation module 202, for generating the corresponding source data file of each index at random according to testing requirement, and will be described
Source data file reports report server, so that the report server is raw according to the testing requirement and the source data file
At the report file of each index；
Computing module 203, it is each for being calculated separately according to the source data file using the calculation formula of each index
The end value of index, and report test file is generated according to the end value of each index；
Test module 204, the report file generated for obtaining the report server, according to the report test file
Accuracy test is carried out to the report file of acquisition.
In the embodiment of the present invention, the extraction module 201, including configuration unit and extraction unit, in which:
Configuration unit, for configuring python interface, the python interface is for reading the report form formula specification text
It include the index name of index in index classification and each index classification in shelves；
Extraction unit, for extracting each finger for including in the report form formula specification document based on the python interface
Mark.
In the embodiment of the present invention, the generation module 202, including acquiring unit, searching unit, generation unit, in which:
Acquiring unit includes the device identification of network element for obtaining testing requirement file, in the testing requirement file with
And report form type；
Searching unit, for searching the corresponding source data template of the network element according to the device identification；
Generation unit, each index of generating random number for using the source data template and currently generating are corresponding
Source data file.
Further, the test module 204 is specifically used for generating matched sql query statement, benefit according to testing requirement
The report file is extracted from the corresponding database of report server with the sql query statement.
For device embodiment, since it is basically similar to the method embodiment, related so being described relatively simple
Place illustrates referring to the part of embodiment of the method.
The apparatus embodiments described above are merely exemplary, wherein described, unit can as illustrated by the separation member
It is physically separated with being or may not be, component shown as a unit may or may not be physics list
Member, it can it is in one place, or may be distributed over multiple network units.It can be selected according to the actual needs
In some or all of the modules achieve the purpose of the solution of this embodiment.Those of ordinary skill in the art are not paying creativeness
Labour in the case where, it can understand and implement.
Report automatic test approach provided in an embodiment of the present invention, device utilize the source data file simulation generated at random
The truthful data of the network equipment reports report server, is obtained by the report file and local computing that generate to report server
Report test file be compared, realize report accuracy test.The present invention solve manual testing not comprehensively, efficiency
Low, at high cost, the problems such as test errors rate is high, effectively increases the accuracy rate and testing efficiency of report test, can be better
Ensure the stability and accuracy of product.
In addition, it is stored thereon with computer program the embodiment of the invention also provides a kind of computer readable storage medium,
The program realizes the step of any embodiment the method as above when being executed by processor.
In the present embodiment, if module/unit that above-mentioned report automatic testing equipment integrates is with the shape of SFU software functional unit
Formula realize and when sold or used as an independent product, can store in a computer readable storage medium.It is based on
Such understanding, the present invention realize above-described embodiment method in all or part of the process, can also by computer program come
Relevant hardware is instructed to complete, the computer program can be stored in a computer readable storage medium, the computer
Program is when being executed by processor, it can be achieved that the step of above-mentioned each embodiment of the method.Wherein, the computer program includes meter
Calculation machine program code, the computer program code can be source code form, object identification code form, executable file or certain
Intermediate form etc..The computer-readable medium may include: can carry the computer program code any entity or
Device, recording medium, USB flash disk, mobile hard disk, magnetic disk, CD, computer storage, read-only memory (ROM, Read-Only
Memory), random access memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software
Distribution medium etc..It should be noted that the content that the computer-readable medium includes can be according to making laws in jurisdiction
Requirement with patent practice carries out increase and decrease appropriate, such as in certain jurisdictions, according to legislation and patent practice, computer
Readable medium does not include electric carrier signal and telecommunication signal.
Equipment provided in an embodiment of the present invention, including memory, processor and storage are on a memory and can be in processor
The computer program of upper operation, the processor realize above-mentioned each report automatic test approach when executing the computer program
The each index for including in step in embodiment, such as S11 shown in FIG. 1, the preset report form formula specification document of extraction.
S12, it generates the corresponding source data file of each index at random according to testing requirement, and reports report to take the source data file
Be engaged in device, for the report server according to the testing requirement and the source data file generate each index report text
Part.S13, the end value for calculating separately each index using the calculation formula of each index according to the source data file, and root
Report test file is generated according to the end value of each index.S14, the report file that the report server generates is obtained, according to
The report test file carries out accuracy test to the report file of acquisition.Alternatively, the processor executes the computer
The function of each module/unit in above-mentioned each report automatic testing equipment embodiment, such as extraction mould shown in Fig. 2 are realized when program
Block 201, generation module 202, computing module 203 and test module 204.
Illustratively, the computer program can be divided into one or more module/units, one or more
A module/unit is stored in the memory, and is executed by the processor, to complete the present invention.It is one or more
A module/unit can be the series of computation machine program instruction section that can complete specific function, and the instruction segment is for describing institute
State implementation procedure of the computer program in corresponding report automatic testing equipment.
The equipment may include, but be not limited only to, processor, memory.It will be understood by those skilled in the art that described set
The standby restriction not constituted to equipment, may include more or fewer components, perhaps combine certain components or different portions
Part, such as the equipment can also include input-output equipment, network access equipment, bus etc..
The processor can be central processing unit (Central Processing Unit, CPU), can also be it
His general processor, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng the processor is the control centre of the equipment, utilizes the various pieces of various interfaces and connection whole equipment.
The memory can be used for storing the computer program and/or module, and the processor is by operation or executes
Computer program in the memory and/or module are stored, and calls the data being stored in memory, described in realization
The various functions of equipment.The memory can mainly include storing program area and storage data area, wherein storing program area can deposit
Application program (such as sound-playing function, image player function etc.) needed for storing up operating system, at least one function etc.；Storage
Data field, which can be stored, uses created data (such as audio data, phone directory etc.) etc. according to mobile phone.In addition, memory can
It can also include nonvolatile memory, such as hard disk, memory, plug-in type hard disk, intelligence to include high-speed random access memory
Energy storage card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card, flash card (Flash
Card), at least one disk memory, flush memory device or other volatile solid-state parts.
In embodiments of the present invention, it should be understood that disclosed device and method, it can be real by another way
It is existing.For example, the apparatus embodiments described above are merely exemplary, for example, the division of the unit or unit, only
A kind of logical function partition, there may be another division manner in actual implementation, for example, multiple units or components can combine or
Person is desirably integrated into another system, or some features can be ignored or not executed.Another point, shown or discussed is mutual
Between coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or communication link of equipment or unit
It connects, can be electrical or other forms.
It will be appreciated by those of skill in the art that although some embodiments in this include included in other embodiments
Certain features rather than other feature, but the combination of the feature of different embodiments means to be within the scope of the present invention simultaneously
And form different embodiments.For example, in the following claims, the one of any of embodiment claimed all may be used
Come in a manner of in any combination using.
Finally, it should be noted that the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although
Present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that: it still may be used
To modify the technical solutions described in the foregoing embodiments or equivalent replacement of some of the technical features；
And these are modified or replaceed, technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution spirit and
Range.
Claims (10)
1. a kind of report automatic test approach characterized by comprising
Extract each index for including in preset report form formula specification document；
It generates the corresponding source data file of each index at random according to testing requirement, and reports report to take the source data file
Be engaged in device, for the report server according to the testing requirement and the source data file generate each index report text
Part；
The end value of each index is calculated separately using the calculation formula of each index according to the source data file, and according to each
The end value of a index generates report test file；
The report file that the report server generates is obtained, is carried out according to report file of the report test file to acquisition
Accuracy test.
2. the method according to claim 1, wherein extracting each finger for including in report form formula specification document
Mark, comprising:
Configure python interface, the python interface is used to read index classification in the report form formula specification document and every
It include the index name of index in one index classification；
The each index for including in the report form formula specification document is extracted based on the python interface.
3. the method according to claim 1, wherein described generate each index correspondence according to testing requirement at random
Source data file, comprising:
Testing requirement file is obtained, includes the device identification and report form type of network element in the testing requirement file；
The corresponding source data template of the network element is searched according to the device identification；
The corresponding source data file of each index of generating random number using the source data template and currently generated.
4. according to the method described in claim 3, it is characterized in that, the report text for obtaining the report server and generating
Part, comprising:
Matched sql query statement is generated according to testing requirement, using the sql query statement from the corresponding number of report server
According to extracting the report file in library.
5. a kind of report automatic testing equipment characterized by comprising
Extraction module, for extracting each index for including in preset report form formula specification document；
Generation module, for generating the corresponding source data file of each index at random according to testing requirement, and by the source data
File reports report server, so that the report server is each according to the testing requirement and source data file generation
The report file of index；
Computing module, for calculating separately the knot of each index using the calculation formula of each index according to the source data file
Fruit value, and report test file is generated according to the end value of each index；
Test module, the report file generated for obtaining the report server, according to the report test file to acquisition
Report file carry out accuracy test.
6. device according to claim 5, which is characterized in that the extraction module, comprising:
Configuration unit, for configuring python interface, the python interface is for reading in the report form formula specification document
Index classification and each index classification in include index index name；
Extraction unit, for extracting each index for including in the report form formula specification document based on the python interface.
7. device according to claim 5, which is characterized in that the generation module, comprising:
Acquiring unit includes device identification and the report of network element for obtaining testing requirement file, in the testing requirement file
Table type；
Searching unit, for searching the corresponding source data template of the network element according to the device identification；
Generation unit, the corresponding source number of each index of generating random number for using the source data template and currently generating
According to file.
8. device according to claim 7, which is characterized in that the test module is specifically used for raw according to testing requirement
At matched sql query statement, the report is extracted from the corresponding database of report server using the sql query statement
File.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
It is realized when row such as the step of any one of claim 1-4 the method.
10. a kind of equipment including memory, processor and stores the computer journey that can be run on a memory and on a processor
Sequence, which is characterized in that the processor is realized when executing described program such as the step of any one of claim 1-4 the method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810880377.9A CN109254988A (en) | 2018-08-03 | 2018-08-03 | Report automatic test approach, device, computer storage medium and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810880377.9A CN109254988A (en) | 2018-08-03 | 2018-08-03 | Report automatic test approach, device, computer storage medium and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109254988A true CN109254988A (en) | 2019-01-22 |
Family
ID=65049689
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810880377.9A Pending CN109254988A (en) | 2018-08-03 | 2018-08-03 | Report automatic test approach, device, computer storage medium and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109254988A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110377524A (en) * | 2019-07-25 | 2019-10-25 | 中国工商银行股份有限公司 | Test method, device, system and the medium of reporting system |
| CN110737689A (en) * | 2019-10-10 | 2020-01-31 | 广东省科技基础条件平台中心 | Data standard conformance detection method, device, system and storage medium |
| CN111831534A (en) * | 2019-04-15 | 2020-10-27 | 西安京迅递供应链科技有限公司 | Method and device for verifying accuracy of datagram table |
| CN112001617A (en) * | 2020-08-14 | 2020-11-27 | 苏州浪潮智能科技有限公司 | Report generation progress method, device, equipment and readable storage medium |
| CN114328214A (en) * | 2021-12-27 | 2022-04-12 | 深圳市六度人和科技有限公司 | Method and device for improving efficiency of interface test case of report software and computer equipment |
| WO2022095736A1 (en) * | 2020-11-05 | 2022-05-12 | 深圳壹账通智能科技有限公司 | Report testing method and apparatus, computer device, and computer-readable storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103838672A (en) * | 2014-03-04 | 2014-06-04 | 中国工商银行股份有限公司 | Automated testing method and device for all-purpose financial statements |
| US20150254174A1 (en) * | 2014-03-04 | 2015-09-10 | International Business Machines Corporation | Regression testing of sql execution plans for sql statements |
| CN105468524A (en) * | 2015-11-25 | 2016-04-06 | 上海斐讯数据通信技术有限公司 | Automatic test method and system of WEB interface |
| CN105975452A (en) * | 2016-05-12 | 2016-09-28 | 中国电子科技集团公司第四十研究所 | Test form integrating method and system based on mapping configuration file and index template |
| CN107273286A (en) * | 2017-06-02 | 2017-10-20 | 携程计算机技术（上海）有限公司 | For the scene automatic test platform and method of task application |
| CN107992428A (en) * | 2018-01-03 | 2018-05-04 | 成都能通科技有限公司 | The automatic test platform that a kind of Python is realized |
-
2018
- 2018-08-03 CN CN201810880377.9A patent/CN109254988A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103838672A (en) * | 2014-03-04 | 2014-06-04 | 中国工商银行股份有限公司 | Automated testing method and device for all-purpose financial statements |
| US20150254174A1 (en) * | 2014-03-04 | 2015-09-10 | International Business Machines Corporation | Regression testing of sql execution plans for sql statements |
| CN105468524A (en) * | 2015-11-25 | 2016-04-06 | 上海斐讯数据通信技术有限公司 | Automatic test method and system of WEB interface |
| CN105975452A (en) * | 2016-05-12 | 2016-09-28 | 中国电子科技集团公司第四十研究所 | Test form integrating method and system based on mapping configuration file and index template |
| CN107273286A (en) * | 2017-06-02 | 2017-10-20 | 携程计算机技术（上海）有限公司 | For the scene automatic test platform and method of task application |
| CN107992428A (en) * | 2018-01-03 | 2018-05-04 | 成都能通科技有限公司 | The automatic test platform that a kind of Python is realized |
Non-Patent Citations (1)
| Title |
|---|
| 张宏飞: "利用 VBA 实现探测器测试报表的自动生成", 《福建电脑》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111831534A (en) * | 2019-04-15 | 2020-10-27 | 西安京迅递供应链科技有限公司 | Method and device for verifying accuracy of datagram table |
| CN110377524A (en) * | 2019-07-25 | 2019-10-25 | 中国工商银行股份有限公司 | Test method, device, system and the medium of reporting system |
| CN110737689A (en) * | 2019-10-10 | 2020-01-31 | 广东省科技基础条件平台中心 | Data standard conformance detection method, device, system and storage medium |
| CN112001617A (en) * | 2020-08-14 | 2020-11-27 | 苏州浪潮智能科技有限公司 | Report generation progress method, device, equipment and readable storage medium |
| CN112001617B (en) * | 2020-08-14 | 2022-06-03 | 苏州浪潮智能科技有限公司 | Report generation progress method, device, equipment and readable storage medium |
| WO2022095736A1 (en) * | 2020-11-05 | 2022-05-12 | 深圳壹账通智能科技有限公司 | Report testing method and apparatus, computer device, and computer-readable storage medium |
| CN114328214A (en) * | 2021-12-27 | 2022-04-12 | 深圳市六度人和科技有限公司 | Method and device for improving efficiency of interface test case of report software and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109254988A (en) | Report automatic test approach, device, computer storage medium and equipment | |
| US20200012888A1 (en) | Image annotating method and electronic device | |
| CN106874134B (en) | Work order type processing method, device and system | |
| CN109344170B (en) | Stream data processing method, system, electronic device and readable storage medium | |
| CN108495192A (en) | Page editing processing method and processing device | |
| CN111652468A (en) | Business process generation method and device, storage medium and computer equipment | |
| CN105405221A (en) | Method and device for automated test | |
| CN112990455A (en) | Network model issuing method and device, storage medium and electronic equipment | |
| CN107329765A (en) | Program file processing method and processing device | |
| CN111061696A (en) | Method and device for analyzing transaction message log | |
| CN110851511A (en) | Data synchronization method and device | |
| CN110472298B (en) | Method, device, equipment and storage medium for constructing electric power market model | |
| CN109617944A (en) | WEB parameter management method, device, computer storage medium and equipment | |
| CN112015870A (en) | Data uploading method and device | |
| CN111611391B (en) | Method, device, equipment and storage medium for classifying conversation | |
| CN112767933B (en) | Voice interaction method, device, equipment and medium of highway maintenance management system | |
| CN107798556A (en) | For updating method, equipment and the storage medium of situation record | |
| CN109543122B (en) | Content synchronization method, device, storage medium and electronic device | |
| CN110555077A (en) | automatic question bank synchronization method and device | |
| CN111652122A (en) | Configuration method and device of vision system | |
| CN109522210A (en) | Interface testing parameters analysis method, device, electronic device and storage medium | |
| CN115018182B (en) | Planning management method, device, storage medium and system of communication circuit | |
| CN112926736B (en) | Deep learning technology tool chain system | |
| CN111324706B (en) | Labeling method and device and electronic equipment | |
| CN107517113B (en) | Equipment information acquisition method and device |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200123 Address after: 510663 Guangzhou Science City, Guangdong Shenzhou Road, No. 10 Applicant after: COMBA TELECOM SYSTEMS (CHINA) Ltd. Address before: 510663 Shenzhou Road 10, Guangzhou Science City, Guangdong, Guangzhou Applicant before: COMBA TELECOM SYSTEMS (CHINA) Ltd. Applicant before: COMBA TELECOM SYSTEMS (GUANGZHOU) Ltd. Applicant before: COMBA TELECOM TECHNOLOGY (GUANGZHOU) Ltd. Applicant before: TIANJIN COMBA TELECOM SYSTEMS Ltd. |
|
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 510663 Shenzhou Road 10, Science City, Guangdong, Guangzhou Applicant after: Jingxin Network System Co.,Ltd. Address before: 510663 Shenzhou Road 10, Science City, Guangdong, Guangzhou Applicant before: COMBA TELECOM SYSTEMS (CHINA) Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190122 |