CN104239583B - Database script issues the processing method and processing device of result - Google Patents
Database script issues the processing method and processing device of result Download PDFInfo
- Publication number
- CN104239583B CN104239583B CN201410542567.1A CN201410542567A CN104239583B CN 104239583 B CN104239583 B CN 104239583B CN 201410542567 A CN201410542567 A CN 201410542567A CN 104239583 B CN104239583 B CN 104239583B
- Authority
- CN
- China
- Prior art keywords
- file
- database script
- journal
- judging
- execution
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
- G06F11/3414—Workload generation, e.g. scripts, playback
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/1734—Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/448—Execution paradigms, e.g. implementations of programming paradigms
- G06F9/4482—Procedural
Abstract
The invention discloses the processing method and processing device that a kind of database script issues result.Wherein, this method includes：Obtain the execution journal of database script；The execution journal that database script is performed when making a mistake is merged, and generates journal file；By judging whether the content in journal file is that sky judges file to determine whether to generate；To judging that file carries out verification operation, judge whether database script issue succeeds according to verification operation.The present invention solves in the prior art that database script is performed when there is mistake in lasting issuing process, it is impossible to the result of normal display failure, the problem of causing every time to need manually to check implementing result after lasting issue.
Description
Technical field
The present invention relates to computer realm, in particular to a kind of database script issue result processing method and
Device.
Background technology
Lasting issue is a kind of method that fixed manual software is issued to process automation, can be with a key by the method
The carry out software issue of formula automation.Issue is generally comprised：The compiling of application program is disposed, the renewal of database script is performed,
Operation of automatic test cases etc..And automatic decision issue result, result is notified into related personnel by forms such as mails.
Hudson continues publishing tool as a kind of, it is possible to achieve the function of the progress software issue of automation.
During using Hudson persistently issue, if database script occurs when being performed in issuing process
Mistake, and other issue links are correct, issue result is shown as success.But it is actual now it is desirable that issue result should
For failure, display result is incorrect.The essence of this phenomenon be the error message that data store internal is performed be can not normal quilt
What Hudson was intercepted and captured, so the correct judgement of result according to this error message can not issue.It can be realized by this method
When database script performs appearance mistake in issuing process, issue result is automatically shown as the conclusion that correctly fails.
Existing solution is the publishing log that the execution journal of database script in issuing process is output to hudson
Middle display, the hand inspection publishing log after each issue, checks whether wrong in database script execution journal, if
Mistake then thinks this time issue failure, if being successfully without if.
The greatest problem that the method is present is, even if issue result is successfully to be also required to manually be checked to determine every time
As a result reliability.The display of the actual issue result that Hudson is provided every time has lost meaning, does not play a role, makes
Obtain operating efficiency low.
For when database script is performed in the presence of mistake in lasting issuing process in the prior art, it is impossible to which normal display is lost
The result lost, the problem of causing every time to need manually to check implementing result after lasting issue, is not yet proposed effective at present
Solution.
The content of the invention
The processing method and processing device of result is issued it is a primary object of the present invention to provide a kind of database script, to solve
When database script is performed in the presence of mistake in lasting issuing process in the prior art, it is impossible to the result of normal display failure, lead
The problem of causing every time to need manually to check implementing result after lasting issue.
To achieve these goals, one side according to embodiments of the present invention is issued there is provided a kind of database script
As a result processing method.This method includes：Obtain the execution journal of database script；When database script execution is made a mistake
Execution journal merge, generate journal file；Determine whether life by judging whether the content in journal file is sky
Into judging file；To judging that file carries out verification operation, judge whether database script issue succeeds according to verification operation.
To achieve these goals, another aspect according to embodiments of the present invention is issued there is provided a kind of database script
As a result processing unit, the device includes：Acquisition module, the execution journal for obtaining database script；First processing module,
Merged for database script to be performed to execution journal when making a mistake, generate journal file；Determining module, for leading to
Cross whether the content judged in journal file is empty, it is determined whether generation judges file；Authentication module, for judging that file enters
Row verification operation, judges whether database script issue succeeds according to verification operation.
According to inventive embodiments, by the execution journal for obtaining database script；Database script is performed and made a mistake
When execution journal merge, generate journal file；Determined whether by judging whether the content in journal file is sky
Generation judges file；To judging that file carries out verification operation, judge whether database script issue succeeds according to verification operation, solve
When prior art of having determined database script in lasting issuing process is performed in the presence of mistake, it is impossible to the result of normal display failure,
The problem of causing every time to need manually to check implementing result after lasting issue.Realize when database script performs presence
During mistake, automatic issue result is to be shown as unsuccessfully, it is not necessary to carry out the effect of hand inspection again.
Brief description of the drawings
The accompanying drawing for constituting the part of the application is used for providing a further understanding of the present invention, schematic reality of the invention
Apply example and its illustrate to be used to explain the present invention, do not constitute inappropriate limitation of the present invention.In the accompanying drawings：
Fig. 1 is the flow chart of the processing method of according to embodiments of the present invention one database script issue result；
Fig. 2 is the flow chart of the processing method of according to embodiments of the present invention one optional database script issue result；
Fig. 3 is the structural representation of the processing unit of according to embodiments of the present invention two database script issue result；With
And
Fig. 4 is the structural representation of the processing unit of according to embodiments of the present invention two optional database script issue results
Figure.
Embodiment
It should be noted that in the case where not conflicting, the feature in embodiment and embodiment in the application can phase
Mutually combination.Describe the present invention in detail below with reference to the accompanying drawings and in conjunction with the embodiments.
In order that those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention
Accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, rather than whole embodiments.Based on the embodiment in the present invention, ordinary skill people
The every other embodiment that member is obtained under the premise of creative work is not made, should all belong to the model that the present invention is protected
Enclose.
It should be noted that term " first " in description and claims of this specification and above-mentioned accompanying drawing, "
Two " etc. be for distinguishing similar object, without for describing specific order or precedence.It should be appreciated that so using
Data can exchange in the appropriate case, so as to embodiments of the invention described herein.In addition, term " comprising " and " tool
Have " and their any deformation, it is intended that covering is non-exclusive to be included, for example, containing series of steps or unit
Process, method, system, product or equipment are not necessarily limited to those steps clearly listed or unit, but may include without clear
It is listing to Chu or for the intrinsic other steps of these processes, method, product or equipment or unit.
Embodiment 1
The embodiments of the invention provide a kind of method that database script issues result.
Fig. 1 is the flow chart of the method for database script issue result according to embodiments of the present invention.As shown in figure 1, should
It is as follows that method includes step：
Step S101, obtains the execution journal of database script.
Specifically, in above-mentioned steps S101, the execution journal of database script is worked as in the process for performing database script
Middle generation.By the implementation procedure of direct monitoring data storehouse script, so as to obtain the execution journal produced in implementation procedure.
Step S103, the execution journal that database script is performed when making a mistake is merged, and generates journal file.
Specifically, in above-mentioned steps S103, to carry out unified judgement for the implementing result of these scripts, thus by this
Execution error log under a little catalogues is all uniformly output in a text.By above-mentioned independent each database script text
Part is merged, and generates journal file.
Step S105, by judging whether the content in journal file is that sky judges file to determine whether to generate.
Specifically, above-mentioned steps S105, by judging whether log file contents are empty, to determine whether that generation judges text
Part.If log file contents are sky, there is no mistake in database of descriptions script implementation procedure, script runs succeeded.If
Log file contents are not sky, then wrong in database of descriptions script implementation procedure to produce, script performs failure.
Step S107, to judge file carry out verification operation, according to verification operation judge database script issue whether into
Work(.
Specifically, above-mentioned steps S107, by judging that file carries out verification operation, judge verification operation success and
It is no, so as to judge whether database script file distribution succeeds.
Above-mentioned steps S101 to step S107, is carried out by the execution journal of the database script of multiple positions to execution
Merge, generate the journal file for carrying out unified judgement.In the case of judging that database script runs succeeded, generation judges
File, in the case of judging that database script performs failure, judgement file is not generated.Finally by the checking to judging file
Whether operation, succeed to judge that database script is performed.If being performed in database script and mistake occur, judgement file is not generated
In the case of.When performing verification operation, because in the absence of file is judged, just occurring when verification operation is performed
Mistake.The mistake occurred by verification operation, makes lasting publishing tool be judged as mistake to database script implementation procedure.
Among practical application, exemplified by lasting issue is carried out using Hudson and is built.By database in issuing process
The error log that script is performed is output in file " A.txt ", and daily record is output in file adds mode using content.Using this
During the mode of kind, no matter whether wrong daily record is exported in the process of implementation, this document " A.txt " can all be present.Difference is, when
When performing wrong, this document content is not sky；When performing without mistake, then this document content is sky.And then, judge
Whether " A.txt " file content is empty.If " A.txt " file content is sky, then it represents that do not had in database script implementation procedure
It is wrong, now newly-built " B.txt " file；If " A.txt " file content is not sky, exported in Hudson daily records
The related prompt message of a little mistakes, and do not create " B.txt " file.
Herein it should be strongly noted that Hudson continues publishing tool as one in itself, can only be to release tasks
No order, which is performed, to be judged, and database script performs correctness, and the process of database perform script can all continue, simply
The mistake occurred during can database script be performed is pointed out in the form of error log.But, Hudson persistently issues work
The content of the error log that can not be generated to database of tool itself judges.So we pass through the behaviour to judging file
Make, judge come the implementing result to database script in database.
Preferably, in the above embodiments of the present application, the operation day of database script is obtained in step S101 and step S103
Will, and by database script perform make a mistake when running log merge, generation journal file the step of include：
Step S1031, the executive process of monitoring data storehouse script.
Step S1033, obtains the execution journal for performing and being produced when database script execution makes a mistake.
Step S1035, journal file is generated by the content of database script execution journal in additional mode.
Specifically, above-mentioned steps S1031 is into step S1035, by the monitoring of the executive process to database script, directly
Obtain and take database script to perform execution journal when making a mistake.It is merged into generation one comprising in additional mode
There is the journal file of the content of running log.
Preferably, in the above embodiments of the present application, step 105 by judge the content in journal file whether be it is empty come
Determine whether database script runs successful step and include：
Step S1051, reads the content of journal file.
Step S1053, whether the content for judging journal file is empty.
When the judged result of journal file is space-time, replication log file generated judges file, by judging file
Whether operation, succeed so that validation database script is persistently issued；
When the judged result of journal file is not space-time, the judgement file for verification operation is not generated.
Specifically, above-mentioned steps S1051 is into step S1053, by reading the content of journal file, when journal file
Content is space-time, determines that database script is run successfully；When the content of journal file is not space-time, determine that database script is run
Failure.By in success generation judge file to mark and issue successful state.
Among practical application, the generating mode of file is judged, in addition to judging file with replication log file generated,
Judgement file can also be generated by other means.For example, directly creating shortcut, directly creating the blank text of various forms
Shelves etc..
Preferably, in the above embodiments of the present application, in step S107 to judging that file carries out verification operation, grasped according to checking
Make to judge database script issue whether succeed in the method for verification operation include：
Method A：By to judging file copy operation, judging that database script is performed and whether succeeding；Or,
Method B：By to judging that paper cut is operated, judging that database script is performed and whether succeeding；Or,
Method C：By to judging file open operation, judging that database script is performed and whether succeeding；Or,
Method D：By to judging file deletion action, judging that database script is performed and whether succeeding.
Specifically, above method A is into method D, by the duplication for judging file, shearing, opening, deletion action, coming
Judge whether the execution of database script succeeds.When database script runs succeeded, generation judges file.So to judging text
The operation such as duplication, shearing, opening, deletion of part will succeed.When database script performs failure, judgement file is not generated,
The operation such as duplication, shearing, opening, deletion to judging file will fail certainly.Pass through the aforesaid operations to judging file
Success or not, to judge the result of database script execution in database.Certainly, except replicating, shearing, open, delete these
Operation is outer, other modes of operation to judging file, can be used for judging the implementing result of database script.
Preferably, Fig. 2 is the stream of the processing method of according to embodiments of the present invention one optional database script issue result
Cheng Tu, as shown in Fig. 2 in the above embodiments of the present application, in step S105 by judging whether the content in journal file is empty
To determine whether that generation judges file, if the content in journal file is space-time, step also includes：
Step 1061, execution journal is preserved to presumptive area.
Step 1063, real time scan presumptive area.
Step 1065, according to whether there is execution journal in presumptive area, the execution failure cause of database script is judged.
Step 1067, according to failure cause is performed, announcement information is sent.
Specifically, above-mentioned steps S1061 is into step S1067, it will determine that file is preserved into presumptive area, by this
Presumptive area real time scan, to realize the real-time monitoring to database script operation result.To the execution journal in presumptive area
It is read out, is judged by log content performing failure cause.According to failure cause, send corresponding with failure cause
Announcement information.Announcement information can be sent by forms such as desktop pop-up mouthful, transmission mail, transmission short messages.
Embodiment 2
The embodiment of the present invention additionally provides the processing unit that a kind of database script issues result, as shown in figure 3, the device
It can include：Acquisition module 201, first processing module 203, determining module 205 and authentication module 207.
Wherein, acquisition module 201, the execution journal for obtaining database script.
Specifically, in above-mentioned acquisition module 201, the execution journal of database script is to perform the process of database script
Central generation.By the implementation procedure of direct monitoring data storehouse script, so as to obtain the execution journal produced in implementation procedure.
First processing module 203, merges for database script to be performed to execution journal when making a mistake, generates
Journal file.
Specifically, in above-mentioned first processing module 203, to carry out unified judgement, institute for the implementing result of these scripts
So that the execution error log under these catalogues is all uniformly output in a text.By above-mentioned each independent data
Storehouse script file is merged, and generates journal file.
Determining module 205, for by judging whether the content in journal file is empty, it is determined whether generation judges text
Part.
Specifically, above-mentioned determining module 205, by judging whether log file contents are empty, to determine whether that generation is sentenced
Disconnected file.If log file contents are sky, there is no mistake in database of descriptions script implementation procedure, script runs succeeded.
If log file contents are not sky, wrong in database of descriptions script implementation procedure to produce, script performs failure.
Authentication module 207, for judging that file carries out verification operation, judging that database script is issued according to verification operation
Whether succeed.
Specifically, above-mentioned authentication module 207, by judging that file carries out verification operation, judging the success of verification operation
Whether, so as to judge whether database script file distribution succeeds.
Above-mentioned acquisition module 201, first processing module 203, determining module 205 and authentication module 207, by execution
The execution journal of the database script of multiple positions is merged, and generates the journal file for carrying out unified judgement.Work as judgement
In the case that database script runs succeeded, generation judges file, in the case of judging that database script performs failure, does not give birth to
Into judging file.Finally by the verification operation to judging file, whether succeed to judge that database script is performed.If in number
Performed according to storehouse script and mistake occur, do not generated in the case of judging file.When performing verification operation, because literary in the absence of judging
Part, so mistake just occurs when verification operation is performed.The mistake occurred by verification operation, makes lasting publishing tool
Mistake is judged as to database script implementation procedure.
Among practical application, exemplified by lasting issue is carried out using Hudson and is built.By database in issuing process
The error log that script is performed is output in file " A.txt ", and daily record is output in file adds mode using content.Using this
During the mode of kind, no matter whether wrong daily record is exported in the process of implementation, this document " A.txt " can all be present.Difference is, when
When performing wrong, this document content is not sky；When performing without mistake, then this document content is sky.And then, judge
Whether " A.txt " file content is empty.If " A.txt " file content is sky, then it represents that do not had in database script implementation procedure
It is wrong, now newly-built " B.txt " file；If " A.txt " file content is not sky, exported in Hudson daily records
The related prompt message of a little mistakes, and do not create " B.txt " file.
Herein it should be strongly noted that Hudson continues publishing tool as one in itself, can only be to release tasks
No order, which is performed, to be judged, and database script performs correctness, and the process of database perform script can all continue, simply
The mistake occurred during can database script be performed is pointed out in the form of error log.But, Hudson persistently issues work
The content of the error log that can not be generated to database of tool itself judges.So we pass through the behaviour to judging file
Make, judge come the implementing result to database script in database.
Preferably, in the above embodiments of the present application, acquisition module 201 includes：Sub- monitoring module 2011 and sub-acquisition module
2013。
Wherein, sub- monitoring module 2011, the executive process for monitoring data storehouse script.
Sub-acquisition module 2013, the execution journal that database script is produced is performed for obtaining.
Specifically, above-mentioned sub- monitoring module 2011 and sub-acquisition module 2013, pass through the executive process to database script
Monitoring, directly obtain database script execution journal.So as to which it is merged into generation one comprising in additional mode
There is the journal file of the content of running log.
Preferably, in the above embodiments of the present application, determining module 205 includes：Sub- read module 2051 and subprocessing module
2053。
Wherein, sub- read module 2051, the content for reading journal file.
Subprocessing module 2053, for judging whether the content of journal file is empty.
When the judged result of journal file is space-time, replication log file generated judges file, by judging file
Whether operation, succeed so that validation database script is persistently issued.
When the judged result of journal file is not space-time, the judgement file for verification operation is not generated.
Specifically, above-mentioned sub- read module 2051 and subprocessing module 2053, by reading the content of journal file, the same day
The content of will file is space-time, determines that database script is run successfully；When the content of journal file is not space-time, database is determined
Script operation failure.By in success generation judge file to mark and issue successful state.
Among practical application, the generating mode of file is judged, in addition to judging file with replication log file generated,
Judgement file can also be generated by other means.For example, directly creating shortcut, directly creating the blank text of various forms
Shelves etc..
Preferably, in the above embodiments of the present application, authentication module 207 at least includes any one following submodule：The
One sub- judge module 2071, the second sub- judge module 2073, the 3rd sub- judge module 2077 of sub- judge module 2075 or the 4th.
Wherein, the first sub- judge module 2071, for by judging file copy operation, judging that database script is performed
Whether succeed；Or,
Second sub- judge module 2073, for by judging that paper cut is operated, whether judging database script execution
Success；Or,
3rd sub- judge module 2075, for by judging file open operation, whether judging database script execution
Success；Or,
4th sub- judge module 2077, for by judging file deletion action, whether judging database script execution
Success.
Specifically, above-mentioned first sub- judge module 2071, the second sub- judge module 2073, the 3rd sub- judge module 2075 or
4th sub- judge module 2077, by the duplication for judging file, shearing, opening, deletion action, to judge database script
Whether execution succeeds.When database script runs succeeded, generation judges file.So to judging the duplication of file, shearing, beating
The operation such as opening, delete will succeed.When database script perform failure when, judgement file is not generated, to judge file duplication,
The operations such as shearing, opening, deletion will fail certainly.By the success or not of the aforesaid operations to judging file, to judge number
The result performed according to database script in storehouse.Certainly, in addition to replicating, shearing, open, delete these operations, other are to judging
The mode of operation of file, can be used for judging the implementing result of database script.
Preferably, Fig. 4 is the knot of the processing unit of according to embodiments of the present invention two optional database script issue results
Structure schematic diagram, as shown in figure 4, in the above embodiments of the present application, device also includes：Replication module 2061, monitoring module 2063, sentence
Disconnected module 2065 and Second processing module 2067.
Wherein, replication module 2061, for execution journal to be copied into presumptive area.
Monitoring module 2063, for real time scan presumptive area.
Judge module 2065, for according to whether there is execution journal in presumptive area, judging the execution of database script
Failure cause.
Second processing module 2067, for according to failure cause is performed, sending announcement information.
Specifically, above-mentioned replication module 2061, monitoring module 2063, judge module 2065 and Second processing module 2067,
It will determine that file is preserved into presumptive area, by the presumptive area real time scan, being tied to realize to run database script
The real-time monitoring of fruit.Execution journal in presumptive area is read out, sentenced by log content to performing failure cause
It is disconnected.According to failure cause, announcement information corresponding with failure cause is sent.Announcement information can pass through desktop pop-up mouthful, transmission
The forms such as mail, transmission short message are sent.
Among practical application, exemplified by lasting issue is carried out using Hudson and is built.Because passing through Hudson, database
The error message and running log that inside is performed can not be intercepted and captured normally by Hudson, so can not be according to this error message
The correct judgement of issue result is carried out, so when persistently being issued using Hudson, according to judging whether file generates
Judge operation result.
Problem to be solved by this invention is：Lasting issue is carried out using Hudson to build, if data in issuing process
Storehouse script, which is performed, has mistake, and Hudson issue result is shown as success all the time, it is impossible to the normal issue knot for showing failure
The problem of fruit.The method described by using the present invention can make the display result issued automatically correct, when database script is held
When row has mistake, automatic issue result is to be shown as unsuccessfully, it is not necessary to carry out hand inspection again.
In actual applications, it can be realized according to following steps：
Step A, the error log that database script in issuing process is performed is output in file " A.txt ".
Because the database script to be performed in issuing process may have many parts, the script of these parts is mutually
Independent, it is present under different bibliographic structures, and unified judgement is carried out for the implementing result of these scripts, so will
Execution error log under these catalogues is all uniformly output in a file, is used Gu error log is output in file
Content adds mode.When in this way, no matter whether wrong daily record is exported in the process of implementation, the text to be output to
Part can all be present.Difference is, when wrong daily record, and this document content is not sky；When performing without mistake, then in this document
Hold for sky.
Whether step B, it is empty to judge " A.txt " file content.If " A.txt " file content is sky, then it represents that data
There is no mistake in the script implementation procedure of storehouse, now newly-built " B.txt " file；If " A.txt " file content is not sky,
With being intended in hudson daily records export a little information, and do not create " B.txt " file.
Step C, replicates " B.txt " file and arrives certain catalogue, thus judges whether database execution is wrong, and this is tied
Fruit is accurately notified to Hudson.In summary, can be released by step 1, no matter script perform whether wrong file " A.txt "
All exist, admittedly directly it can not be judged with " A.txt " file.
From step B, when perform script is without mistake, " B.txt " file is then present, and the operation for replicating this document can
Normally to run succeeded, returning result is correct, and the result that now Hudson is got is correct, and issue should be successfully；
When perform script is wrong, " B.txt " file is then not present, and replicates the operation of this document i.e. due to lacking source file, performs
It will fail, the result as exception error that now Hudson is got can return to issue failure.
It should be noted that：The file " A.txt " that Hudson can not be output to according to error log whether there is directly to enter
Row judges, can not judge file because even working as directly according to judging whether file " A.txt " is that sky is directly judged
" A.txt " is not sky, and now database script execution known to us malfunctions, but this result is can not to return to Hudson to be cut
Obtain and use, it is impossible to reach judge its issue result should for fail purpose.
It is actual to have used transition method in this scheme, by performing copy command, because the source file of duplication is not present
Cause copy command unsuccessfully to report an error, this error message returned into Hudson, judged using this error message intercepted,
Return to the correct result of issue failure.
The essence for the problem of present invention is solved is that Hudson is to be unable to identification database to perform error message, so this hair
The bright method taken is to be converted into this error message in Hudson issue flows by certain methods to recognize and capture
Abnormal information mode, utilize the abnormal information that captures after the conversion of these methods to carry out the judgement of issue result.
So by other scripts or implementation method, can reach this purpose should can be achieved.Solve hair
Cloth instrument provides the issue insecure problem of result, passes through the implementation of this programme, it is not necessary to carried out again after each issue artificial
Check, improve efficiency, release manpower.
It should be noted that for foregoing each method embodiment, in order to be briefly described, therefore it is all expressed as a series of
Combination of actions, but those skilled in the art should know, the present invention is not limited by described sequence of movement because
According to the present invention, some steps can be carried out sequentially or simultaneously using other.Secondly, those skilled in the art should also know
Know, embodiment described in this description belongs to preferred embodiment, involved action and module is not necessarily of the invention
It is necessary.
In the above-described embodiments, the description to each embodiment all emphasizes particularly on different fields, and does not have the portion being described in detail in some embodiment
Point, it may refer to the associated description of other embodiment.
, can be by another way in several embodiments provided herein, it should be understood that disclosed device
Realize.For example, device embodiment described above is only schematical, such as the division of described unit is only one kind
Division of logic function, can there is other dividing mode when actually realizing, such as multiple units or component can combine or can
To be integrated into another system, or some features can be ignored, or not perform.It is another, it is shown or discussed each other
Coupling direct-coupling or communication connection can be by some interfaces, the INDIRECT COUPLING or communication connection of device or unit,
Can be electrical or other forms.
The unit illustrated as separating component can be or may not be it is physically separate, it is aobvious as unit
The part shown can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple
On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs
's.
In addition, each functional unit in each embodiment of the invention can be integrated in a processing unit, can also
That unit is individually physically present, can also two or more units it is integrated in a unit.Above-mentioned integrated list
Member can both be realized in the form of hardware, it would however also be possible to employ the form of SFU software functional unit is realized.
If the integrated unit is realized using in the form of SFU software functional unit and as independent production marketing or used
When, it can be stored in a computer read/write memory medium.Understood based on such, technical scheme is substantially
The part contributed in other words to prior art or all or part of the technical scheme can be in the form of software products
Embody, the computer software product is stored in a storage medium, including some instructions are to cause a computer
Equipment (can be personal computer, mobile terminal, server or network equipment etc.) performs side described in each embodiment of the invention
The all or part of step of method.And foregoing storage medium includes：USB flash disk, read-only storage (ROM, Read-Only Memory),
Random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disc or CD etc. are various to be stored
The medium of program code.
The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.Within the spirit and principles of the invention, that is made any repaiies
Change, equivalent substitution, improvement etc., should be included in the scope of the protection.
Claims (8)
1. a kind of database script issues the processing method of result, work as applied to using the lasting issuing process for continuing publishing tool
In, it is characterised in that including：
Obtain the execution journal of database script；
The execution journal that the database script is performed when making a mistake is merged, and generates journal file；
By judging whether the content in the journal file is that sky judges file to determine whether to generate；
Verification operation is carried out to the judgement file, according to the verification operation judge the database script issue whether into
Work(；
Wherein, it is described to determine whether the step of generation judges file by judging whether the content in the journal file is sky
Including：
Read the content of the journal file；
Whether the content for judging the journal file is empty；
When the judged result of the journal file is space-time, replicates the journal file and generate the judgement file, by institute
The operation for judging file is stated, whether is succeeded so as to verify that the database script is persistently issued；
When the judged result of the journal file is not space-time, the judgement file for the verification operation is not generated.
2. according to the method described in claim 1, it is characterised in that obtain the execution journal of database script, and by the number
The execution journal performed according to storehouse script when making a mistake is merged, and the step of generating journal file includes：
Monitor the executive process of the database script；
Obtain the execution database script and produce the execution journal performed when making a mistake；
The content of the database script execution journal is generated into the journal file in additional mode.
3. according to the method described in claim 1, it is characterised in that verification operation is being carried out to the judgement file, according to institute
State during verification operation judges whether database script issue successful, the verification operation at least include it is following any one：
Whether succeeded by the judgement file copy operation, judging that the database script is performed；Or,
By being operated to the judgement paper cut, judge that the database script is performed and whether succeed；Or,
Whether succeeded by the judgement file open operation, judging that the database script is performed；Or,
By to the judgement file deletion action, judging that the database script is performed and whether succeeding.
4. according to the method described in claim 1, it is characterised in that when the judged result of the journal file is not space-time, institute
State by judging whether the content in the journal file is that sky also includes to determine whether to generate the step of judging file：
The execution journal is preserved to presumptive area；
Presumptive area described in real time scan；
According to whether there is the execution journal in the presumptive area, the execution failure cause of the database script is judged；
According to the execution failure cause, announcement information is sent.
5. a kind of database script issues the processing unit of result, it is characterised in that including：
Acquisition module, the execution journal for obtaining database script；
First processing module, merges for the database script to be performed to execution journal when making a mistake, generates day
Will file；
Determining module, for by judging whether the content in the journal file is empty, it is determined whether generation judges file；
Authentication module, for carrying out verification operation to the judgement file, the database pin is judged according to the verification operation
Whether this issue succeeds;
Wherein, the determining module includes：
Sub- read module, the content for reading the journal file；
Subprocessing module, for judging whether the content of the journal file is empty；
When the judged result of the journal file is space-time, replicates the journal file and generate the judgement file,
By the operation to the judgement file, whether succeed so as to verify that the database script is persistently issued；
When the judged result of the journal file is not space-time, the judgement file for the verification operation is not generated.
6. device according to claim 5, it is characterised in that the acquisition module includes：
Sub- monitoring module, the executive process for monitoring the database script；
Sub-acquisition module, the execution journal that the database script is produced is performed for obtaining.
7. device according to claim 5, it is characterised in that the authentication module at least includes any one following height
Module：
First sub- judge module, for by whether to the judgement file copy operation, judging the database script execution
Success；Or,
Second sub- judge module, for by being operated to the judgement paper cut, whether judging the database script execution
Success；Or,
3rd sub- judge module, for by whether to the judgement file open operation, judging the database script execution
Success；Or,
4th sub- judge module, for by the judgement file deletion action, whether judging the database script execution
Success.
8. device according to claim 5, it is characterised in that described device also includes：
Replication module, for the execution journal to be copied into presumptive area；
Monitoring module, for presumptive area described in real time scan；
Judge module, for according to whether there is the execution journal in the presumptive area, judging the database script
Perform failure cause；
Second processing module, for according to the execution failure cause, sending announcement information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410542567.1A CN104239583B (en) | 2014-10-14 | 2014-10-14 | Database script issues the processing method and processing device of result |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410542567.1A CN104239583B (en) | 2014-10-14 | 2014-10-14 | Database script issues the processing method and processing device of result |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104239583A CN104239583A (en) | 2014-12-24 |
| CN104239583B true CN104239583B (en) | 2017-08-01 |
Family
ID=52227642
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410542567.1A Active CN104239583B (en) | 2014-10-14 | 2014-10-14 | Database script issues the processing method and processing device of result |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104239583B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109271199B (en) * | 2018-09-11 | 2023-01-10 | 航天信息软件技术有限公司 | Method and system for database continuous integration and script file management |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102855255A (en) * | 2011-06-30 | 2013-01-02 | 北京新媒传信科技有限公司 | Content management and publish method and system |
| CN103763117A (en) * | 2011-12-31 | 2014-04-30 | 华茂云天科技(北京)有限公司 | Service and operation management system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090327465A1 (en) * | 2008-06-27 | 2009-12-31 | Microsoft Corporation | Distributed Configuration Orchestration for Network Client Management |
-
2014
- 2014-10-14 CN CN201410542567.1A patent/CN104239583B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102855255A (en) * | 2011-06-30 | 2013-01-02 | 北京新媒传信科技有限公司 | Content management and publish method and system |
| CN103763117A (en) * | 2011-12-31 | 2014-04-30 | 华茂云天科技(北京)有限公司 | Service and operation management system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104239583A (en) | 2014-12-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108459957A (en) | Test method, device, equipment and the storage medium of fund system test case | |
| CN103336742A (en) | Automation software black box testing system and method based on Android | |
| CN108614777A (en) | A kind of financial transaction test system and test method based on actual services | |
| CN109409892A (en) | Methods of risk assessment and system | |
| US8572563B2 (en) | User interfaces and software reuse in model based software systems | |
| CN107644256A (en) | A kind of method that diagnosis rule storehouse is formed based on machine learning mode | |
| CN106681854A (en) | Information checking method, device and system | |
| CN106294162A (en) | A kind of third party's component method for testing security based on data mining | |
| CN109947833A (en) | A kind of data quality management method based on B/S framework | |
| CN104239583B (en) | Database script issues the processing method and processing device of result | |
| CN110347976A (en) | Method, system, device and the storage medium of quick equipment leading out data model | |
| MacDonald et al. | Automating the software inspection process | |
| Aoyama et al. | Rebok manifest: Towards a requirements engineering body of knowledge | |
| US20230044288A1 (en) | Computer implemented system and method of enrichment of data for digital product definition in a heterogenous environment | |
| WO2019193479A1 (en) | Cognitive robotic system for test data management activities and method employed thereof | |
| Huang et al. | A method of bug report quality detection based on vector space model | |
| JP5176869B2 (en) | Test case generation program, test case generation apparatus, and test case generation method | |
| Kugler et al. | Testing scenario-based models | |
| CN106993222A (en) | The method and apparatus that visual automation tools are write based on android set top box | |
| Wrenn et al. | Reading Between the Lines: Student Help-Seeking for (Un) Specified Behaviors | |
| Xie et al. | Design and implementation of bank financial business automation testing framework based on QTP | |
| CN105389253A (en) | Method and system for simulating client to execute network element management based on multithreading technology | |
| Machado et al. | Automatic test-case generation | |
| KR102490732B1 (en) | Device for creating customized startup materials based on artificial intelligence | |
| CN110413669A (en) | A kind of data processing method based on ETL, device, terminal device and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Method and device for processing issued result of database script Effective date of registration: 20190531 Granted publication date: 20170801 Pledgee: Shenzhen Black Horse World Investment Consulting Co., Ltd. Pledgor: Beijing Guoshuang Technology Co.,Ltd. Registration number: 2019990000503 |
|
| CP02 | Change in the address of a patent holder | ||
| CP02 | Change in the address of a patent holder |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Patentee after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Patentee before: Beijing Guoshuang Technology Co.,Ltd. |