CN109543160A - Inspection method, check device, storage medium and the processor of numerical tabular - Google Patents
Inspection method, check device, storage medium and the processor of numerical tabular Download PDFInfo
- Publication number
- CN109543160A CN109543160A CN201811407958.7A CN201811407958A CN109543160A CN 109543160 A CN109543160 A CN 109543160A CN 201811407958 A CN201811407958 A CN 201811407958A CN 109543160 A CN109543160 A CN 109543160A
- Authority
- CN
- China
- Prior art keywords
- numerical tabular
- numerical
- rule
- type
- mentioned
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
- Stored Programmes (AREA)
Abstract
This application provides a kind of inspection method of numerical tabular, check device, storage medium and processor, which includes: to obtain the table information of numerical tabular to be checked；The type of numerical tabular is determined according to table information；According to corresponding first rule of the type of numerical tabular, logarithm table is checked, and outgoing inspection result, wherein corresponding first rule of different types of numerical tabular is is pre-configured with.Inspection method in obtain the table information of numerical tabular to be checked first, the type of the numerical tabular is then determined according to table information, finally according to corresponding first rule of the type, logarithm table is checked, and outgoing inspection result.The inspection method is checked according to the corresponding automatic logarithm table of first rule, checks that efficiency is higher, and check that accuracy rate is higher.
Description
Technical field
This application involves field of computer technology, in particular to a kind of inspection method of numerical tabular, check device,
Storage medium and processor.
Background technique
As development of games Requirement Iteration is frequent, under the mode that development rate is getting faster, planning change demand quite frequency
It is numerous, wherein just including the change of logarithm table, numerical tabular includes various types of excel table, is write using different
Format defines different type, such as having filled in for prize table, monster table, experience table, AI table table respective fills in format, journey
Numerical tabular is converted to program file using different table tools of leading according to form types by sequence.Just since demand change takes place frequently, table
Lattice change number increases, and plans to fill in a form the case where mistake is filled out, failed to fill in, filling out more can often occur, in order to avoid the mistake of table
The normal iteration of entire game is influenced, it is necessary to the inspection of table.
Currently, newly-built, the change of logarithm table, planning general way is the old numerical tabular of duplication, renames table name, and
The attribute for modifying numerical tabular on this basis will replicate some old mistakes due to this operation, currently, checking these mistakes
Method accidentally includes: that can confirm mistake by artificial eye；It can also test in gaming, problem is determined by Novel presentation；
Tool, discovery local anomaly change can also be compared by diff；It can also be checked just for certain type list.
All there is various defects for these above-mentioned methods: for the mode of manual confirmation, the degree of inspection compared with
Low, manual confirmation can have fault, and excel table has the operation of many hiding ranks, and artificial eye can't see hide items
Cause to malfunction, accuracy rate is lower, and the attribute item of numerical tabular is more, and manual confirmation can be dazzled, and the efficiency of inspection is lower；?
This method is tested in game, is found the problem by Novel presentation, and efficiency is lower, because numerical attribute is more, is difficult to pass through sense
Official experiences the unreasonable of discovery each single item numerical value, and the accuracy rate of inspection is lower；Tool is compared by diff, can be found in numerical tabular
Some numerical value change of part, but all numerical terms of whole numerical tabular can not be integrally held, the accuracy rate of inspection is lower；It is right
In the method checked just for certain type list, since numerical tabular type is more, just for certain type of table look-up, inspection
It looks into inadequate system comprehensively and automates, without the interface of good visual inspection result, the numerical tabular to report an error, which needs to assign, to be surveyed
Examination personnel follow-up.
Disclosed information above is used only to reinforce the background technique to technology described herein in the background section
Understanding may include therefore certain information in background technique, these information are to those skilled in the art and not formed
The home known prior art.
Summary of the invention
The main purpose of the application is to provide inspection method, check device, storage medium and the processing of a kind of numerical tabular
Device, to solve the problems, such as that the method efficiency in the prior art for checking numerical tabular is lower and accuracy is lower.
To achieve the goals above, according to the one aspect of the application, a kind of inspection method of numerical tabular is provided, the inspection
Checking method includes: the table information for obtaining numerical tabular to be checked；The type of above-mentioned numerical tabular is determined according to above-mentioned table information；According to
Corresponding first rule of the type of above-mentioned numerical tabular, checks above-mentioned numerical tabular, and outgoing inspection result, wherein different
Corresponding above-mentioned first rule of the above-mentioned numerical tabular of type is to be pre-configured with.
Further, above-mentioned table information includes: the number of numerical tabular, the table name of numerical tabular, the path of numerical tabular, numerical tabular
The path for leading table tool and/or numerical tabular generation code file path, wherein the number of above-mentioned numerical tabular is above-mentioned number
It is worth the serial number of table, the path of above-mentioned numerical tabular is the storing path of above-mentioned numerical tabular, and the table tool of leading of above-mentioned numerical tabular is that will count
Value table is converted into the wscript.exe of code file, and the path of the generation code file of above-mentioned numerical tabular is above-mentioned numerical tabular through above-mentioned
Lead the code of table tool change generation.
Further, the process that the type of above-mentioned numerical tabular is determined according to above-mentioned table information includes: to record above-mentioned table information
Enter into analytical table；Above-mentioned analytical table is analyzed, determines the type of above-mentioned numerical tabular.
Further, it is analyzed to above-mentioned analytical table, after the type for determining above-mentioned numerical tabular, according to above-mentioned table information
Determine the process of the type of above-mentioned numerical tabular further include: the type of above-mentioned table information and above-mentioned numerical tabular is stored in database
In, and timing updates above-mentioned database, stores in the above-mentioned database of above-mentioned first rule used when implementing above-mentioned inspection
Corresponding first rule of the type of above-mentioned numerical tabular.
Further, after exporting above-mentioned inspection result, above-mentioned inspection method further include: above-mentioned first is not met to inspection
The numerical value of rule is checked again for according to Second Rule, to determine it is above-mentioned whether the numerical value for not meeting above-mentioned first rule meets
Second Rule, if so, ignoring the numerical value for not meeting above-mentioned first rule, alternatively, the numerical value that above-mentioned first rule will not met
Predetermined persons are showed, to determine whether to ignore the numerical value for not meeting above-mentioned first rule.
According to the another aspect of the application, a kind of check device of numerical tabular is provided, above-mentioned check device includes: to obtain
Unit, for obtaining the table information of numerical tabular to be checked；Type determining units, for determining above-mentioned number according to above-mentioned table information
It is worth the type of table；Inspection unit examines above-mentioned numerical tabular for corresponding first rule of type according to above-mentioned numerical tabular
It looks into, and outgoing inspection result, wherein corresponding above-mentioned first rule of different types of above-mentioned numerical tabular is is pre-configured with.
Further, the above-mentioned type determination unit includes: recording module, and being used for will be in above-mentioned table data input analytical table；
Determining module determines the type of above-mentioned numerical tabular for analyzing above-mentioned analytical table.
According to the application's in another aspect, providing a kind of inspection method of numerical tabular, which includes: that transmission is looked into
Table instruction；Receive the inspection result obtained according to above-mentioned table-look-up instruction inspection numerical tabular, wherein according to above-mentioned table-look-up instruction inspection
Numerical tabular obtain inspection result process include: server-side obtained according to above-mentioned table-look-up instruction numerical tabular to be checked table letter
Breath；Above-mentioned server-side determines the type of above-mentioned numerical tabular according to above-mentioned table information；Above-mentioned server-side is according to the class of above-mentioned numerical tabular
Corresponding first rule of type, checks above-mentioned numerical tabular, and outgoing inspection result, wherein different types of above-mentioned numerical value
Corresponding above-mentioned first rule of table is to be pre-configured with.
According to the another aspect of the application, a kind of storage medium is provided, above-mentioned storage medium includes the program of storage,
In, equipment above procedure controls above-mentioned storage medium when running where executes any above-mentioned inspection method.
According to the another aspect of the application, a kind of processor is provided, above-mentioned processor is for running program, above procedure
Any above-mentioned inspection method is executed when operation.
Using the technical solution of the application, the table information of numerical tabular to be checked is obtained in above-mentioned inspection method first,
Then the type of the numerical tabular is determined according to table information, finally according to corresponding first rule of the type, logarithm table is examined
It looks into, and outgoing inspection result.The inspection method checked according to the automatic logarithm table of corresponding first rule, check efficiency compared with
Height, and check that accuracy rate is higher.
Detailed description of the invention
The accompanying drawings constituting a part of this application is used to provide further understanding of the present application, and the application's shows
Meaning property embodiment and its explanation are not constituted an undue limitation on the present application for explaining the application.In the accompanying drawings:
Fig. 1 shows the flow diagram of the embodiment of the inspection method of the numerical tabular according to the application；
Fig. 2 shows the structural block diagrams according to the embodiment of the check device of the numerical tabular of the application；
Fig. 3 shows a kind of flow diagram of the inspection method of the numerical tabular of embodiment of the application.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
The model that the present invention protects all should belong in member's every other embodiment obtained without making creative work
It encloses.
It should be noted that description and claims of this specification and term " first " in above-mentioned attached drawing, "
Two " etc. be to be used to distinguish similar objects, without being used to describe a particular order or precedence order.It should be understood that using in this way
Data be interchangeable under appropriate circumstances, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " includes " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, for example, the process, method, system, product or equipment for containing a series of steps or units are not necessarily limited to
Step or unit those of is clearly listed, but may include be not clearly listed or for these process, methods, product
Or other step or units that equipment is intrinsic.
As background technique is introduced, the method efficiency in the prior art for checking numerical tabular is lower and accuracy compared with
Low, as above in order to solve the problems, such as, present applicant proposes a kind of inspection method of numerical tabular, check device, storage medium and places
Manage device.
According to embodiments of the present invention, a kind of embodiment of the method for the inspection method of numerical tabular is provided, it should be noted that
Step shown in the flowchart of the accompanying drawings can execute in a computer system such as a set of computer executable instructions, and
It, in some cases, can be to be different from sequence execution institute herein and although logical order is shown in flow charts
The step of showing or describing.
Fig. 1 is the inspection method of numerical tabular according to an embodiment of the present invention, as shown in Figure 1, this method comprises the following steps:
Step S102 obtains the table information of numerical tabular to be checked；
Step S104 determines the type of above-mentioned numerical tabular according to above-mentioned table information；
Step S106 checks above-mentioned numerical tabular, and defeated according to corresponding first rule of the type of above-mentioned numerical tabular
Inspection result out, wherein corresponding first rule of different type is to be pre-configured with.
The table information for obtaining numerical tabular to be checked in above-mentioned inspection method first, then determines the number according to table information
It is worth the type of table, finally according to corresponding first rule of the type, logarithm table is checked, and outgoing inspection result.The inspection
Checking method is checked according to the corresponding automatic logarithm table of first rule, checks that efficiency is higher, and check that accuracy rate is higher.
The very multi-chart information of numerical tabular can determine its corresponding type, such as the number of corresponding numerical tabular, table
Title and/or the type of table etc., the difference of the table information of numerical tabular subsequent to determine corresponding numerical value according to table information
The mode of the type of table is different, when table information includes the type of numerical tabular, can directly determine the type of the numerical tabular, work as table
When not including type information in information, the type of numerical tabular can be determined according to table information indirect.Accordingly, in order to more square
Just the type of above-mentioned numerical tabular is quickly determined, in a kind of embodiment of the application, above-mentioned table information includes: the volume of numerical tabular
Number, the path of the table name of numerical tabular, numerical tabular, the path for leading table tool of numerical tabular and/or numerical tabular generation code file
Path, wherein the number of above-mentioned numerical tabular is the serial number of above-mentioned numerical tabular, and the path of above-mentioned numerical tabular is above-mentioned numerical tabular
Storing path, the path of the generation code file of above-mentioned numerical tabular are above-mentioned numerical tabular through the above-mentioned generation for leading the generation of table tool change
Code.Above-mentioned path refers both to storing path.
Certainly, the table information in the application is not limited to above-mentioned content, can also include that other can determine numerical value
The information of the type of table, the table information with appropriate content can be arranged in those skilled in the art according to the actual situation, thus root
The type of above-mentioned numerical tabular is determined according to table information.
In order to facilitate the type of the multiple numerical tabulars of determination, in a kind of specific embodiment of the application, believed according to above-mentioned table
Breath determine the process of the type of above-mentioned numerical tabular include: by above-mentioned table data input into analytical table；Above-mentioned analytical table is carried out
Analysis, determines the type of above-mentioned numerical tabular.
In order to facilitate the above-mentioned table information of calling, and guarantee that the table information called is newest information, one kind of the application
It in embodiment, analyzes to above-mentioned allocation list, after the type for determining above-mentioned numerical tabular, is determined according to above-mentioned table information above-mentioned
The process of the type of numerical tabular further include: in the database by above-mentioned table information and the storage of the type of above-mentioned numerical tabular, and timing
Above-mentioned database is updated, above-mentioned first rule used is the above-mentioned numerical tabular stored in above-mentioned database when implementing above-mentioned inspection
Type it is corresponding first rule.
Certainly, above-mentioned table information and the type of numerical tabular can be not preserved in database, as long as timing is to above-mentioned point
Analysis table is updated, and can also be accurately obtained the latest news of table information.
In some special application scenarios, some parameters in numerical tabular are set as specific numerical value, which may
Above-mentioned first rule is not met, but the numerical value is to meet some special demands, needs to ignore in the detection method and this is not inconsistent
It closes, therefore, in this case, after exporting above-mentioned inspection result, above-mentioned inspection method further include: inspection is not met above-mentioned
The numerical value of first rule is checked again for according to Second Rule, to determine whether the numerical value for not meeting above-mentioned first rule meets
Above-mentioned Second Rule ignores the numerical value for not meeting above-mentioned first rule if meeting Second Rule；Alternatively, will not meet above-mentioned
The numerical value of first rule shows predetermined persons to carry out, to determine whether to ignore the numerical value for not meeting above-mentioned first rule.Due to
The setting of special numerical value is generally that project staff sets, so generally being advised according to planning demand to not meeting above-mentioned first
Numerical value then is reaffirmed.
For more convenient subsequent inspection, in a kind of embodiment of the application, to the number for not meeting above-mentioned first rule
Whether value, which meets above-mentioned Second Rule, is confirmed or is checked, and ignore do not meet it is above-mentioned first rule numerical value after, above-mentioned inspection
Checking method further include: by it is ignoring and do not meet it is above-mentioned first rule numerical value save, during subsequent examination, work as number
After value does not meet the first rule, then judge the numerical value whether the values match with preservation, i.e., whether in these numerical value of preservation
One it is equal, if equal with one of those, this mistake will not be quoted again, reach the mesh that special rules can be handled flexibly
's.
Typically embodiments, provides a kind of check devices of numerical tabular for the another kind of the application, as shown in Fig. 2, on
Stating check device includes:
Acquiring unit 10, for obtaining the table information of numerical tabular to be checked；
Type determining units 20, for determining the type of above-mentioned numerical tabular according to above-mentioned table information；
Inspection unit 30 examines above-mentioned numerical tabular for corresponding first rule of type according to above-mentioned numerical tabular
It looks into, and outgoing inspection result, wherein corresponding above-mentioned first rule of different types of above-mentioned numerical tabular is is pre-configured with.
In above-mentioned check device, the table information of numerical tabular to be checked, type determining units are obtained by acquiring unit
The type of the numerical tabular is determined according to table information, inspection unit is examined according to corresponding first rule of the type, logarithm table
It looks into, and outgoing inspection result.The check device checked according to the automatic logarithm table of corresponding first rule, check efficiency compared with
Height, and check that accuracy rate is higher.
In a kind of specific embodiment, above-mentioned check device further includes Rulemaking unit, which is used for
Corresponding first rule is formulated according to the type of above-mentioned numerical tabular.Certainly, on can not also including in the check device of the application
The first rule that other other than check device unit is formulated can be stored in inspection unit by the Rulemaking unit stated,
For checking.
In order to facilitate the type of the multiple numerical tabulars of determination, in a kind of specific embodiment of the application, the above-mentioned type is determined
Unit includes recording module and determining module, and above-mentioned recording module is used for will be in above-mentioned table data input allocation list；Above-mentioned determination
Module analyzes above-mentioned allocation list, determines the type of above-mentioned numerical tabular.
In order to facilitate the above-mentioned table information of calling, and guarantee that the table information called is newest information, one kind of the application
In embodiment, the above-mentioned type determination unit further includes memory module, and above-mentioned memory module is for storing above-mentioned table information and above-mentioned
The type of numerical tabular is stored in memory module, and the timing of above-mentioned memory module updates, and above-mentioned inspection unit is used upper when checking
State corresponding first rule of type that the first rule is the above-mentioned numerical tabular stored in above-mentioned memory module.
In some special application scenarios, some parameters in numerical tabular are set as specific numerical value, which may
Above-mentioned first rule is not met, but the numerical value is to meet some special demands, needs to ignore in the detection method and this is not inconsistent
It closes, therefore, in this case, above-mentioned check device further includes error check unit, and above-mentioned error check unit is used for basis
The numerical value that planning requirement checking does not meet above-mentioned first rule is checked again for, when the numerical value symbol for not meeting above-mentioned first rule
It closes when stating planning demand, ignores the numerical value for not meeting above-mentioned first rule.
In the typical embodiment of another of the application, a kind of inspection method is provided, which includes:
Send table-look-up instruction；
Receive the inspection result obtained according to above-mentioned table-look-up instruction inspection numerical tabular, wherein examine according to above-mentioned table-look-up instruction
It looks into numerical tabular and obtains the process of inspection result and include:
Server-side obtains the table information of numerical tabular to be checked according to above-mentioned table-look-up instruction；
Server-side determines the type of above-mentioned numerical tabular according to above-mentioned table information；
Server-side checks above-mentioned numerical tabular, and export according to corresponding first rule of type of above-mentioned numerical tabular
Inspection result, wherein corresponding above-mentioned first rule of different types of above-mentioned numerical tabular is is pre-configured with.
In above-mentioned inspection method, table-look-up instruction is first sent, then receives the inspection obtained according to the inspection instruction checking
As a result, in specific checking process, first according to the table information for checking instruction acquisition numerical tabular to be checked, then according to table information
Determine the type of the numerical tabular, finally according to corresponding first rule of the type, logarithm table is checked, obtains checking knot
Fruit.The inspection method is checked according to the corresponding automatic logarithm table of first rule, checks that efficiency is higher, and check accuracy rate
It is higher.
In the typical embodiment of another of the application, a kind of storage medium is provided, above-mentioned storage medium includes depositing
The program of storage, wherein equipment above procedure controls above-mentioned storage medium when running where executes any above-mentioned inspection method.
In the typical embodiment of another of the application, a kind of processor is provided, above-mentioned processor is for running journey
Sequence, above procedure execute any above-mentioned inspection method when running.
In order to enable those skilled in the art can clearly understand the technical solution of the application, below with reference to tool
The embodiment of body illustrates the technical solution and technical effect of the application.
As shown in figure 3, the inspection method specifically includes:
The information of S201, the numerical tabular that needs are checked are inserted in analytical table.
Analytical table uses excel table storage, and the number of numerical tabular is inserted in analytical table, name, type, path, leads table
The path (numerical tabular being converted into the wscript.exe of code file) of tool, the path for generating code file, all tables
Analytical table is inserted, does unit with row, the table information of the corresponding numerical tabular of every row uploads to the warehouse SVN after preservation.It is later new
Increase, delete, the content of modification analytical table, needing the above- mentioned information that timely update, and save and upload to the warehouse SVN.
S202, the analytical table that timing analysis S201 is obtained determine the type of numerical tabular.
Download newest analytical table from SVN using scripted code, and analytical table read by row, the table name filled out in table,
Type leads the information preservations such as table tool in first database, and the information that first database saves, which is that institute is in need, to be examined
Numerical tabular table information, can periodically be updated, execute within timing script every 30 minutes primary.
S203, first database have updated what be new, after the type for determining numerical tabular, formulate different general rules,
I.e. first rule.
General rule file is created with excel, excel includes multiple worksheets, and different worksheets fills in different type
General rule, such as the first worksheet fills in the article filtering rule of prize table, and the second worksheet fills in the category of fight numerical tabular
Property range etc., after editor saves, upload to the warehouse SVN.
S204, general rule production finish, and read all the elements of above-mentioned first database, then according to different types of
Table executes different types of general rule to check that table is looked into.
The full table look-up script of starting once a day, and inspection result is passed through personnel in mail transmission group；Alternatively, user
The operation of single table, multilist or full table look-up is carried out in web page, and single table, multilist inspection, can be with by the name of search numerical tabular
The information such as type, path corresponding to the table name and the table name, root are retrieved in the first database above-mentioned from step S202
Corresponding type selects corresponding general rule to be checked accordingly, and inspection result is passed through personnel in mail transmission group.
S205 does not meet general rule to certain, but meet the number of planning demand according to the inspection result of S204 step
Value, needs to carry out particularization processing, this entry that reports an error is assigned to responsible tester, responsible tester and planning are true
Particular filter can be carried out after recognizing.
And this is filtered information and is written in the second database, when checking again for changing table, it can read the second database
Content, inspection result find there are in the second database, then will not quote this mistake again, reaching special rules can flexibly locate
The purpose of reason.
S206, after inspection result is by becoming privileged, the remaining entry that reports an error all is to belong to really to report an error, really reporting an error
As a result log file is written, web terminal carries out entry displaying, by web terminal web page operation, assign follow-up by reading log file
Personnel's processing, and robot prompting is given, tester carries out entry information to feed back to the people that fills in a form in the form of Bug Tracking
Modification again checks table after the people that fills in a form modification, to carry out confirmation processing to inspection result.
Above-mentioned inspection method may be implemented:
According to the information characteristics of analysis analytical table, the automatic classification marker of numerical tabular to be checked, hand when reducing inspection
Dynamic input checking type is locked, and the operation of input error is also reduced；
Classification general rule, the corresponding different types of numerical tabular to be checked of matching, and the inspection rule of general rule can
Editor, for table responsible person from edit, increase newly or alteration ruler, such as modify numerical value examination scope, reach user of service and
Developer's separation, and general rule is edited in the case where not needing developer；
The number of daily numerical tabular modification is various, and more new content is difficult to discover, the automatic full table look-up arranged once a day,
Full table look-up is carried out to the table changed daily, and gives Zu Nei QA team inspection result mail, achievees the purpose that monitor daily；
Meet the expected particular values of planning to some, but exceed the range of general rule, manual confirmation can be carried out and ignored,
It is no longer reported by mistake after ignoring, reaches the ability for accommodating particular values, the use that makes to table look-up is more flexible；
User retrieves numerical tabular to be checked according to use demand, carries out single table, multilist or full table look-up, such as on weekly duty
Raw user, carries out full table look-up when safeguarding node, most comprehensively to monitor numerical tabular, is such as responsible for the use of playing method content alone
Family can carry out multilist inspection, check there is user function to the relevant numerical tabular of playing method is related to；
Inspection result and processing result shown by web terminal, is assigned to people to result entry and is responsible for, processing result into
The simple and clear displaying of row, is beneficial to the supervision and processing to result.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
In the above embodiment of the invention, it all emphasizes particularly on different fields to the description of each embodiment, does not have in some embodiment
The part of detailed description, reference can be made to the related descriptions of other embodiments.
In several embodiments provided herein, it should be understood that disclosed technology contents can pass through others
Mode is realized.Wherein, the apparatus embodiments described above are merely exemplary, such as the division of said units, Ke Yiwei
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 unit or module
It connects, can be electrical or other forms.
Above-mentioned unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
On unit.It can some or all of the units may be selected to achieve the purpose of the solution of this embodiment according to the actual needs.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If above-mentioned integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, technical solution of the present invention is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can for personal computer, server or network equipment etc.) execute each embodiment above method of the present invention whole or
Part steps.And storage medium above-mentioned includes: that USB flash disk, read-only memory (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), mobile hard disk, magnetic or disk etc. be various to can store program code
Medium.
Above-mentioned above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (10)
1. a kind of inspection method of numerical tabular, which is characterized in that the inspection method includes:
Obtain the table information of numerical tabular to be checked；
The type of the numerical tabular is determined according to the table information；
According to the type of the numerical tabular it is corresponding first rule, the numerical tabular is checked, and outgoing inspection as a result, its
In, corresponding first rule of the different types of numerical tabular is is pre-configured with.
2. inspection method according to claim 1, which is characterized in that the table information includes: the number of numerical tabular, numerical value
The table name of table, the path of numerical tabular, the path for leading table tool of numerical tabular and/or numerical tabular generation code file path,
Wherein, the number of the numerical tabular is the serial number of the numerical tabular, and the path of the numerical tabular is the preservation road of the numerical tabular
The table tool of leading of diameter, the numerical tabular is the wscript.exe for converting numerical tabular to code file, the generation generation of the numerical tabular
Code file is the code that the generation of table tool change is led described in numerical tabular warp.
3. inspection method according to claim 1, which is characterized in that determine the class of the numerical tabular according to the table information
The process of type includes:
By the table data input into analytical table；
The analytical table is analyzed, determines the type of the numerical tabular.
4. inspection method according to claim 3, which is characterized in that analyzed to the analytical table, described in determination
After the type of numerical tabular, the process of the type of the numerical tabular is determined according to the table information further include:
In the database by the table information and the storage of the type of the numerical tabular, and timing updates the database,
First rule used is that the type of the numerical tabular stored in the database is corresponding when implementing the inspection
First rule.
5. inspection method according to claim 1, which is characterized in that after exporting the inspection result, the reviewing party
Method further include:
The numerical value for not meeting first rule to inspection is checked again for according to Second Rule, does not meet described the to determine
Whether the numerical value of one rule meets the Second Rule, if so, ignore the numerical value for not meeting first rule, alternatively,
The numerical value for not meeting first rule is showed into predetermined persons, does not meet first rule to determine whether to ignore
Numerical value.
6. a kind of check device of numerical tabular, which is characterized in that the check device includes:
Acquiring unit, for obtaining the table information of numerical tabular to be checked；
Type determining units, for determining the type of the numerical tabular according to the table information；
Inspection unit checks the numerical tabular, and defeated for corresponding first rule of type according to the numerical tabular
Inspection result out, wherein corresponding first rule of the different types of numerical tabular is is pre-configured with.
7. check device according to claim 6, which is characterized in that the type determining units include:
Recording module, being used for will be in the table data input analytical table；
Determining module determines the type of the numerical tabular for analyzing the analytical table.
8. a kind of inspection method of numerical tabular, which is characterized in that the inspection method includes:
Send table-look-up instruction；
Receive the inspection result obtained according to table-look-up instruction inspection numerical tabular, wherein check number according to the table-look-up instruction
The process that value table obtains inspection result includes:
Server-side obtains the table information of numerical tabular to be checked according to the table-look-up instruction；
The server-side determines the type of the numerical tabular according to the table information；
The server-side checks the numerical tabular, and export according to corresponding first rule of type of the numerical tabular
Inspection result, wherein corresponding first rule of the different types of numerical tabular is is pre-configured with.
9. a kind of storage medium, which is characterized in that the storage medium includes the program of storage, wherein when described program is run
Inspection method described in any one of equipment perform claim requirement 1 to 5 where controlling the storage medium.
10. a kind of processor, which is characterized in that the processor is for running program, and perform claim is wanted when described program is run
Inspection method described in asking any one of 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811407958.7A CN109543160B (en) | 2018-11-23 | 2018-11-23 | Checking method, checking device, storage medium and processor for numerical value table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811407958.7A CN109543160B (en) | 2018-11-23 | 2018-11-23 | Checking method, checking device, storage medium and processor for numerical value table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109543160A true CN109543160A (en) | 2019-03-29 |
| CN109543160B CN109543160B (en) | 2023-08-25 |
Family
ID=65849465
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811407958.7A Active CN109543160B (en) | 2018-11-23 | 2018-11-23 | Checking method, checking device, storage medium and processor for numerical value table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109543160B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111773728A (en) * | 2020-07-09 | 2020-10-16 | 网易（杭州）网络有限公司 | Data table testing method, device, equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101241491A (en) * | 2007-02-05 | 2008-08-13 | 中兴通讯股份有限公司 | Method and system for checking data |
| CN104391934A (en) * | 2014-11-21 | 2015-03-04 | 深圳市银雁金融配套服务有限公司 | Data calibration method and device |
| CN104636483A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Data monitoring method |
| CN107357902A (en) * | 2017-07-14 | 2017-11-17 | 电子科技大学 | A kind of tables of data categorizing system and method based on correlation rule |
| CN108197114A (en) * | 2018-01-19 | 2018-06-22 | 腾讯科技（深圳）有限公司 | Detection method, device, storage medium and the electronic device of list data |
-
2018
- 2018-11-23 CN CN201811407958.7A patent/CN109543160B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101241491A (en) * | 2007-02-05 | 2008-08-13 | 中兴通讯股份有限公司 | Method and system for checking data |
| CN104391934A (en) * | 2014-11-21 | 2015-03-04 | 深圳市银雁金融配套服务有限公司 | Data calibration method and device |
| CN104636483A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Data monitoring method |
| CN107357902A (en) * | 2017-07-14 | 2017-11-17 | 电子科技大学 | A kind of tables of data categorizing system and method based on correlation rule |
| CN108197114A (en) * | 2018-01-19 | 2018-06-22 | 腾讯科技（深圳）有限公司 | Detection method, device, storage medium and the electronic device of list data |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111773728A (en) * | 2020-07-09 | 2020-10-16 | 网易（杭州）网络有限公司 | Data table testing method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109543160B (en) | 2023-08-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP2778929B1 (en) | Test script generation system | |
| CN105580032B (en) | For reducing instable method and system when upgrading software | |
| US7809669B2 (en) | Rule processing system for determining a result response | |
| US8732107B2 (en) | Method and system for capturing business rules for automated decision procession | |
| CN108108297A (en) | The method and apparatus of automatic test | |
| US10460617B2 (en) | Testing system | |
| US20110209042A1 (en) | Information Technology Standard Inventory Utility | |
| CN106648859A (en) | Task scheduling method and device | |
| CN109254912A (en) | A kind of method and device of automatic test | |
| CN110569298A (en) | data docking and visualization method and system | |
| CN109948996A (en) | Approval process visual presentation method, device and computer equipment, storage medium | |
| CN106201837A (en) | A kind of daily record parsing method and system of integrated hardware platform | |
| CN106681808A (en) | Task scheduling method and device | |
| CN109656615A (en) | A method of permission early warning is carried out based on code method significance level | |
| CN106815433A (en) | The method for replacing via automatically according to rule setting | |
| US8539479B2 (en) | System and method for application function consolidation | |
| CN109543160A (en) | Inspection method, check device, storage medium and the processor of numerical tabular | |
| CN107291616A (en) | A kind of online generating platform of project report | |
| CN107870863A (en) | A kind of distributed automatization method of testing based on XML | |
| CN109947639A (en) | ESB automatic interface testing method and storage medium | |
| CN109919762A (en) | Reporting method, device, equipment and the storage medium of customer information | |
| CN108415824A (en) | Attendance data test method, terminal, equipment and computer readable storage medium | |
| CN115437663A (en) | Upgrade strategy updating method and device, electronic equipment, storage medium and vehicle | |
| CN110163374B (en) | Fault diagnosis reasoning system based on Word general configuration | |
| US20080195453A1 (en) | Organisational Representational System |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |