CN109308285A - Database script management method, device, computer equipment and storage medium - Google Patents
Database script management method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109308285A CN109308285A CN201811183800.6A CN201811183800A CN109308285A CN 109308285 A CN109308285 A CN 109308285A CN 201811183800 A CN201811183800 A CN 201811183800A CN 109308285 A CN109308285 A CN 109308285A
- Authority
- CN
- China
- Prior art keywords
- script
- target
- script file
- file
- original
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000013515 script Methods 0.000 title claims abstract description 734
- 238000007726 management method Methods 0.000 title claims abstract description 46
- 238000012550 audit Methods 0.000 claims abstract description 99
- 238000012795 verification Methods 0.000 claims abstract description 75
- 238000012937 correction Methods 0.000 claims description 47
- 238000012986 modification Methods 0.000 claims description 43
- 230000004048 modification Effects 0.000 claims description 43
- 238000004590 computer program Methods 0.000 claims description 17
- 230000005540 biological transmission Effects 0.000 claims description 13
- 238000012545 processing Methods 0.000 claims description 13
- 230000006835 compression Effects 0.000 claims description 7
- 238000007906 compression Methods 0.000 claims description 7
- 238000007689 inspection Methods 0.000 claims description 5
- 238000000034 method Methods 0.000 abstract description 15
- 230000015572 biosynthetic process Effects 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 18
- 238000010200 validation analysis Methods 0.000 description 14
- 238000012360 testing method Methods 0.000 description 9
- 238000013475 authorization Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 4
- 238000012552 review Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000010485 coping Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/08—Network architectures or network communication protocols for network security for authentication of entities
- H04L63/0815—Network architectures or network communication protocols for network security for authentication of entities providing single-sign-on or federations
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L63/00—Network architectures or network communication protocols for network security
- H04L63/08—Network architectures or network communication protocols for network security for authentication of entities
- H04L63/083—Network architectures or network communication protocols for network security for authentication of entities using passwords
Abstract
The invention discloses a kind of database script management method, device, computer equipment and storage mediums, this method comprises: carrying out regular verification to original basic information using table rule is built, obtain effective essential information；Script Core Generator is called, original script file corresponding with effective essential information, the corresponding script name of each original script file are generated；Script downloading request is obtained, is downloaded based on script and requests the target script name carried from original script file, download target script file corresponding with target script name；Target script file is sent to database audits platform, obtains the script specification audit report corresponding with target script file that database audits platform returns；Script specification audit report is sent to the corresponding client of login account, saves the time of artificial deployment script file, the probability to go wrong during artificial deployment script is reduced, improves the formation efficiency of script file.
Description
Technical field
The present invention relates to computer development fields more particularly to a kind of database script management method, device, computer to set
Standby and storage medium.
Background technique
Developer generally pre-defines corresponding tables of data in project development, and during being developed,
The operations such as increase, deletion or the modification of field, and the corresponding index of creation are carried out in tables of data, finally according to corresponding data
Table arrangement is corresponding to build table statement, generates database script and is deployed to use in other environment (such as test environment).But mesh
For preceding developer when disposing database script, by the corresponding database script of each tables of data of manual sorting, time-consuming, and
And it is easy to appear mistake.Also, if the script name of database script and the format of the script name of test Environment Definition are not inconsistent,
When being disposed after being published to test environment according to script name, system, which will do it, to report an error, and needs to transfer again after modifying
Deployment, treatment process is more troublesome, expends the time.When current manual disposes database script, artificial detection database script is needed
Target script name with test Environment Definition target script name format whether be consistent, time-consuming for detection process, low efficiency
And it is easy error.
Summary of the invention
The embodiment of the present invention provides a kind of database script management method, device, computer equipment and storage medium, with solution
Certainly manually time-consuming for deployment database script, is easy to appear the problem of mistake.
A kind of database script management method, comprising:
The logging request that client is sent is obtained, carries login account and login password in the logging request；
The login account and the login password are verified, if being verified, obtain script request to create, institute
State the original basic information that script request to create includes tables of data；
Regular verification is carried out to the original basic information using table rule is built, obtains effective essential information；
Script Core Generator is called, original script file corresponding with the effective essential information is generated；
Script downloading request is obtained, requests the target script name carried from original script file based on script downloading
In, download target script file corresponding with the target script name；
The target script file is sent to database audits platform, obtain that the database audits platform returns with
The corresponding script specification audit report of the target script file；
The script specification audit report is sent to the corresponding client of the login account.
A kind of database script managing device, comprising:
Logging request obtains module, for obtaining the logging request of client transmission, carries and steps in the logging request
Record account and login password；
Script request to create obtains module, for verifying to the login account and the login password, if verifying
Pass through, then obtain script request to create, the script request to create includes the original basic information of tables of data；
Regular correction verification module, for obtaining effective using table rule is built to the regular verification of original basic information progress
Essential information；
Original script file acquisition module generates corresponding with effective essential information for calling script Core Generator
Original script file, the corresponding script name of each original script file；
Target script file obtains module, for obtaining script downloading request, downloads what request carried based on the script
Target script name downloads target script file corresponding with the target script name from original script file；
Target script file auditing module is obtained for the target script file to be sent to database audits platform
The script specification audit report corresponding with the target script file that the database audits platform returns；
Normalized checking report processing module, it is corresponding for the script specification audit report to be sent to the login account
Client.
A kind of database script management method, the following step executed including the corresponding second server of database audits platform
It is rapid:
The target script file that first server is sent is obtained, the target script file is based on, use is pre-stored
Script verification rule carries out regular verification to the target script file；
If the target script file does not meet script verification rule, to the target script for not meeting script verification rule
File carries out intelligent correction；
The successful specification script sentence of error correction and the unsuccessful script sentence lack of standardization of error correction are obtained, the specification foot is based on
This sentence and the script sentence lack of standardization obtain effective script file, and generate script rule based on the script sentence lack of standardization
Model audit report；
Effective script file and the script specification audit report are sent to the first server.
A kind of database script managing device, comprising:
Database audits platform auditing module, for obtaining the target script file of first server transmission, based on described
Target script file carries out regular verification to the target script file using pre-stored script verification rule；
Intelligent correction module, if script verification rule is not met for the target script file, to not meeting script
The target script file of verification rule carries out intelligent correction；
Result treatment module, for obtaining the successful specification script sentence of error correction and the unsuccessful script language lack of standardization of error correction
Sentence obtains effective script file based on the specification script sentence and the script sentence lack of standardization, and based on described lack of standardization
Script sentence generates script specification audit report；
Data transmission blocks, for effective script file and the script specification audit report to be sent to described
One server.
A kind of computer equipment, including memory, processor and storage are in the memory and can be in the processing
The computer program run on device, the processor realize above-mentioned database script management method when executing the computer program
The step of.
A kind of computer readable storage medium, the computer-readable recording medium storage have computer program, the meter
The step of calculation machine program realizes above-mentioned database script management method when being executed by processor.
Above-mentioned database script management method, device, computer equipment and storage medium, by login account and login
Password is verified, and determines the safety of developer's identity, after login account and login password authentication are verified, exploitation
Personnel can send script request to create in client, and server is after obtaining script request to create, using building table rule to foot
The original basic information for the tables of data that this request to create carries carries out regular verification, improves the effect for being subsequently generated original script file
Rate.After carrying out regular verification, script Core Generator is called to handle the effective essential information for building table rule is met, obtained
Original script file saves the time of artificial deployment script file, reduces what artificial deployment script went wrong in the process
Probability.After generating original script file, the script sentence to original script file is needed to verify, for uniform auditing mark
Standard improves review efficiency, and the target script file for needing to download is sent to database audits platform, obtains database and examines
The script specification audit report that core platform returns, and normalized checking report is sent to the corresponding client of login account, make
Obtaining developer can modify to the script sentence for not meeting specification according to the script specification audit report, improve exploit person
The working efficiency of member's modification target script file.
Detailed description of the invention
In order to illustrate the technical solution of the embodiments of the present invention more clearly, below by institute in the description to the embodiment of the present invention
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the invention
Example, for those of ordinary skill in the art, without any creative labor, can also be according to these attached drawings
Obtain other attached drawings.
Fig. 1 is an application scenario diagram of database script management method in one embodiment of the invention；
Fig. 2 is a flow chart of database script management method in one embodiment of the invention；
Fig. 3 is a specific flow chart of step S30 in Fig. 2；
Fig. 4 is a specific flow chart of step S50 in Fig. 2；
Fig. 5 is another flow chart of database script management method in one embodiment of the invention；
Fig. 6 is a schematic diagram of database script managing device in one embodiment of the invention；
Fig. 7 is another schematic diagram of database script managing device in one embodiment of the invention；
Fig. 8 is a schematic diagram of computer equipment in one embodiment of the invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
Database script management method provided in an embodiment of the present invention is applied in script automatic management platform, the script
Automatic management platform can realize creation script, the audit functions such as script and Manage Scripts.Wherein, the function of creating script refers to
In project development process, developer carries out field by script automatic management platform, to the tables of data being related in project
The operation such as increase, deletion or modification when create the function of corresponding database script.The function of audit script refers in life
After database script, database script can be sent to database audits by script automatic management platform by developer
Platform, the corresponding server of data base administration audit platform audits database script, and auditing result is sent to foot
This manages the corresponding server of platform automatically, to know in database script with the presence or absence of the function of mistake.The function of Manage Scripts
It can refer to that developer is by the script automatic management platform, to vicious data after the completion of database script audit
After library script is modified, function that the database script that there is no problem is managed.Database script management method can answer
In the application environment of such as Fig. 1, wherein client refers to the corresponding client of script automatic management platform, and server includes
The corresponding first server of automatic management platform and the corresponding second server of data base administration audit platform.Wherein, client
End can be, but not limited to various personal computers, laptop, smart phone, tablet computer and portable wearable device.
Server can be realized with the server cluster of the either multiple server compositions of independent server.
In one embodiment, it as shown in Fig. 2, providing a kind of database script management method, applies in Fig. 1 in this way
First server for be illustrated, including first server execute following steps:
S10: the logging request that client is sent is obtained, carries login account and login password in logging request.
Specifically, developer is when entering script automatic management platform, script automatic management platform corresponding the
One server needs to verify the identity of developer, and therefore, developer needs first to input stepping on for oneself in client
Account and login password are recorded, and executes transmission operation, the logging request for carrying login account and login password is sent to pair
The first server answered, so that first server obtains the logging request that client is sent.
S20: verifying login account and login password, if being verified, obtains script request to create, script wound
Build the original basic information that request includes tables of data.
Wherein, script request to create refers to the request for triggering first server creation script.Specifically, first server
After obtaining the login account and login password that client is sent, login account and login password are verified, it is close when logging in
Code matches with log-in password corresponding with the login account pre-stored in first server, then is verified.To stepping on
Record account and login password are verified, the safety of identity when ensure that developer's logon script automatic management platform.
After being verified, client can show the interface of script creation to developer, and developer is in creation script
Interface on input relevant information, and " script creation " this button is clicked, to trigger script request to create.In the present embodiment
Relevant information refers to the original basic information that developer fills at the interface that script creates.The original basic information refers to developer
Fill in the information in tables of data, including but not limited to script name, table abbreviation, table note, table founder and Biao type.Its
In, table note is used to describe the founder of tables of data, creation time, the modification annotation informations such as people and modification time.Table type refers to
The corresponding type of database of tables of data, the type of database include oracle and two kinds of Mysql.Developer can be according to reality
Situation selects corresponding type of database.Developer clicks " script wound after having filled in the original basic information of tables of data
Build " this button, that is, it can trigger the script request to create that client is sent to first server, so that first server acquisition pair
The script request to create answered includes the original basic information about tables of data that developer fills in the script request to create.
S30: regular verification is carried out to original basic information using table rule is built, obtains effective essential information.
Wherein, it builds table rule and refers to whether verification original basic information meets the rule for building table requirement.Specifically, original is being obtained
After beginning essential information, first server can be using pre-stored table rule of building to the regular school of essential information progress in tables of data
It tests, the original basic information for building table rule will be met and save as effective essential information.It is not met if existing in original basic information
Build the original basic information of table rule, then send original basic information be not inconsistent build jointly table rule modification prompt information give log in account
Number corresponding client, reminds corresponding developer to modify to the original basic information for building table rule jointly is not inconsistent.Exploitation
Personnel get modification prompt information after, in the corresponding web interface of client to be not inconsistent in tables of data build jointly table rule
Original basic information is modified and is saved, when modified original basic information, which all meets, builds table rule, after the modification
Original basic information as effective essential information.Regular verification is carried out to original basic information using table rule is built, ensure that
Filling in for original basic information is to meet to build table rule, and subsequent step is allowed to be successfully generated original script file.
S40: calling script Core Generator, generates original script file corresponding with effective essential information.
Specifically, after getting effective essential information of tables of data, first server can call script Core Generator pair
The effectively essential information such as script name, table abbreviation, table note, table founder and Biao type is handled, and is generated corresponding original
Script file.The script Core Generator refers to that developer automatically generates script text according to what effective essential information of tables of data was write
The tool of part.It include but is not limited to build table statement, index sentence, build synonymous word in script Core Generator in the present embodiment
Sentence, table authorization sentence and rollback sentence.For the ease of identifying that script file, each script file carry corresponding script name
Claim and script file type.Correspondingly, which includes but is not limited to build table script file, synonym script text
Part, authorization script file, index script file and rollback script file.Using script Core Generator can automatically generate with effectively
The corresponding original script file of essential information, saves the time of artificial deployment script file, effectively reduces artificial deployment foot
Format is inconsistent during this document occurs so as to cause the situation for mistake occur.
S50: obtaining script downloading request, requests the target script name carried from original script file based on script downloading
In, download target script file corresponding with target script name.
After script file generates, need to examine script file or applied, at this time, it may be necessary to which developer first downloads
Corresponding target script file.Wherein, script downloading request refers to that client is sent to first server, for asking for Download Script
It asks.It include at least one target script name in each script downloading request in the present embodiment.Wherein, target script name refers to
The title for the script file that developer needs to download.Target script file refers to script text corresponding with target script name
Part.
Specifically, developer sends script downloading request to corresponding first server, first server in client
After getting script downloading request, the target script name that request carries can be downloaded according to script and selected from original script file
Take target script file corresponding with target script name.The mode of this automatic acquisition target script file, can effectively mention
High review efficiency.
S60: being sent to database audits platform for target script file, obtains database audits platform returns and target
The corresponding script specification audit report of script file.
Wherein, database audits platform refers to the platform for auditing the data in target script file.Specifically, it is obtaining
After target script file, developer can select the operation of audit, first server meeting in the corresponding operation interface of client
After getting the request of the operation, by target script file by pre-set audit interface, target script file is sent out
Give corresponding database audits platform.Wherein, audit interface refers to being used for and the progress information friendship of database audits platform for setting
Mutual interface.
For database audits platform after getting target script file, the corresponding second server of database audits platform is logical
It crosses pre-stored script verification rule and regular verification is carried out to target script file, and generate corresponding script specification inspection report
It accuses, script specification audit report is then sent to script automatic management platform.Wherein, script specification audit report refers to data
Audit the report that regular verification is carried out to target script file that platform is sent in library.The script specification audit report includes lack of standardization
Script sentence reason lack of standardization corresponding with its.
In the present embodiment, target script file is sent to the audit of database audits platform, is realized to target script text
The uniform auditing of part is handled, so that auditing standards are more unitized.
S70: script specification audit report is sent to the corresponding client of login account.
It specifically, can be by script specification audit report by holding after first server obtains script specification audit report
The login account of hair personnel's logon script automatic management platform, is sent to corresponding client, allows developer's root
It modifies according to the script specification audit report to the script sentence for not meeting specification, improves working efficiency.
Step S10- step S70 determines the peace of developer's identity by verifying to login account and login password
Quan Xing, after login account and login password authentication are verified, developer can send script request to create in client,
First server is after obtaining script request to create, using the original base for building the tables of data that table rule carries script request to create
This information carries out regular verification, improves the efficiency for being subsequently generated original script file.After carrying out regular verification, call script raw
It handles at tool the effective essential information for building table rule is met, obtains original script file, save artificial deployment foot
The time of this document reduces the probability to go wrong during artificial deployment script.After generating original script file, need
The script sentence of original script file is verified, for uniform auditing standard, review efficiency is improved, needs to download
Target script file be sent to database audits platform, obtain the script specification audit report that database audits platform returns,
And normalized checking report is sent to the corresponding client of login account, developer is examined according to the script specification
It looks into report to modify to the script sentence for not meeting specification, improves the working efficiency that developer modifies target script file.
In one embodiment, as shown in figure 3, step S30, carries out regular school to original basic information using table rule is built
It tests, obtains effective essential information, specifically comprise the following steps:
S31: regular verification is carried out to original basic information using table rule is built.
Specifically, first server is after obtaining original basic information, will use build table rule to original basic information into
Line discipline verification, checks whether original basic information meets the requirement for building table rule.In the present embodiment build table rule include but
It is not limited to following rule: (1) cannot include storage (storage) option.(2) cannot include nologging (non-logging mode)
Option.Nologging will affect database calamity it is standby and restore.(3) it must be provided with the initrans (number of transactions) of table (table)
Parameter is 6, is waited to avoid the lock caused when carrying out frequent updating operation to table for distribution transaction slot.(4) note in table
Record db_block_size (database block size) of the length no more than the database of all fields.(5) field must define
Correct data type.(6) do not allow in table using Long (long) this type field；Lob (big data can be used
Object data type) data type field, but in Oracle 11g (database software), it is necessary to use secure file (text
Part encryption).(7) table and field must have comment (annotation) this Chinese annotation.(8) log sheet and interim off-balancesheet are removed, it is other
In newly-built table, it is necessary to have data creation people, creation time, modification people and modification time this 4 fields.(9) on all external keys all
Index must be created.(10) in addition under global interim table and logtmp (log temporary file) developer the interim table of business and
Other than log sheet, other tables have to build major key.(11) unique index must be first created when creating major key, then is created based on the index
Build major key.(12) major key field must cannot be null value.
S32: if original basic information, which meets, builds table rule, original basic information is saved as into effective essential information.
Specifically, if original basic information, which meets, builds table rule, then it represents that filling in for original basic information meets setting
It is required that this meets and builds the original basic information of table rule and save as effective essential information, to be subsequently generated original script file
Data source is provided.
S33: it if original basic information, which is not inconsistent, builds table rule jointly, is given birth to based on original basic information and corresponding table rule of building
At modification prompt information, modification prompt information is sent to the corresponding client of login account, client is obtained and is mentioned based on modification
Show the modification essential information that information returns, using modification essential information as original basic information, repeats regular using table is built
The step of rule verification is carried out to original basic information.
Specifically, if original basic information, which is not inconsistent, builds table rule jointly, then it represents that the filling in not meeting of original basic information sets
The requirement set.First server can generate modification prompt information based on original basic information and corresponding table rule of building, and then will
Modification prompt information is sent to the corresponding client of login account, and developer is after obtaining modification prompt information, in client
It modifies on the interface of corresponding creation script to not being inconsistent the original basic information for building table rule jointly, and clicks " script modification "
This button will modify essential information and be sent to first server.In order to further ensure modifying the correctness of essential information,
First server carries out again modification essential information using table rule is built after obtaining the modification essential information that client is sent
Verification.If modification essential information, which meets, builds table rule, modification essential information is saved as into effective essential information.If modification is basic
Information, which is not inconsistent, builds table rule jointly, then repeats step S33.
Step S31- step S33 carries out regular verification to original basic information using table rule is built, will meet and build table rule
Original basic information save as effective essential information, the corresponding modification prompt of the original basic information of building table rule jointly will be inconsistent
Information is sent to the corresponding client of login account, so that developer is not in time to being inconsistent the original basic information for building table rule jointly
It modifies, to improve the acquisition efficiency of effective essential information, and guarantees that all effective essential informations meet and preset build table
Rule, to improve the formation efficiency of original script file；Moreover, to generate original script text according to effective essential information
When part, the problem of leading to database script deployment process error because of format issues can effectively avoid.
In one embodiment, script Core Generator includes at least one script generated statement, and the script in the present embodiment is raw
Include the script generated statement of two kinds of type of database of oracle and Mysql at sentence, in step S40, script is called to generate work
Tool generates at least one original script file corresponding with effective essential information, specifically comprises the following steps: that script is called to generate
At least one script generated statement in tool, is respectively handled effective essential information, is obtained and is generated language with each script
The corresponding original script file of sentence.
Script Core Generator includes the script generated statement of two kinds of type of database of oracle and Mysql in the present embodiment.
The script generated statement of every kind of type of database all respectively includes but is not limited to build table statement, indexes sentence, builds synonymous word
Sentence, table authorization sentence and rollback sentence.
Specifically, first server calls script Core Generator, so that the script Core Generator is according to building table statement, build rope
Speech sentence builds synonym sentence, table authorization sentence and rollback sentence respectively to the progress script generation processing of effective essential information
Operation, generation is corresponding to build table original script file, synonym original script file, authorizes original script file, index original
Script file and rollback original script file.Using the script generated statement in script Core Generator, respectively to effectively basic letter
Breath is handled, and obtains original script file corresponding with each script generated statement, it is original to effectively reduce manual compiling
The error rate of script file improves the efficiency of original script file generated.
In one embodiment, due to including building table original script file, synonym original script text in original script file
The different types of original script text of part, authorization original script file, index original script file and rollback original script file etc.
Part, developer is in the script file that downloading needs, it is also necessary to the file for needing the script file downloaded is filled in client
Type.Therefore, the script downloading request in the present embodiment further includes script file type, as shown in figure 4, being based in step S50
The target script name that script downloading request carries downloads target foot corresponding with target script name from original script file
This document specifically comprises the following steps:
S51: if only including a kind of script file type in script downloading request, the mesh that request carries is downloaded based on script
Script name and script file type are marked from original script file, is downloaded corresponding with target script name and script file type
Target script file.
Wherein, the script file type in script downloading request refers to the type for the script file that developer needs to download.
Script file type in the present embodiment includes building table original script file, synonym original script file, authorization original script
The different script file type of file, index original script file and rollback original script file etc..
Specifically, the original script file that developer needs to download in client selection, clicks the operation of downloading, client
Script can be downloaded request and be sent to corresponding first server by end.It include target script name and foot in script downloading request
This document type, target script name refer to that the title of the script file of developer's selection, script file type refer to developer
The type for the script file that the needs of selection are downloaded.It should be noted that developer can choose one or more kinds of script texts
Part type.What it is when developer's selection is a kind of script file type, and corresponding script downloading request only includes a kind of script text
Part type；What it is when developer's selection is a variety of script file types, and corresponding script downloading request includes a variety of script files
Type.
If only including a kind of script file type in the script downloading request obtained, first server will be based under script
The target script name and script file type for carrying request carrying are from original script file, downloading and target script name and foot
The corresponding target script file of this document type.Downloading request target script file by script facilitates developer to grasp
Make.
S52: if including at least two script file types in script downloading request, download what request carried based on script
Target script name and script file type obtain and target script name and script file type pair from original script file
The target script file answered, and automatic compression processing is carried out to target script file, obtain and downloads target script file is corresponding
Compressed package.
If including at least two script file types in script downloading request, the target that request carries is downloaded based on script
Script name and script file type obtain corresponding with target script name and script file type from original script file
Then at least two target script files carry out automatic compression processing at least two target script files, generate and target foot
The compressed package is sent to the client where developer by the corresponding compressed package of this title, first server.
Further, if developer does not select script file type, then it represents that developer wants downloading target foot
The corresponding all original script files of this title, first server can download the target script name in request according to script, will
The target script name is corresponding to build table original script file, synonym original script file, authorization original script file, index
Original script file and rollback original script file carry out compression processing, form compressed package, and the compressed package is sent to exploitation
The corresponding client of personnel, realizes the function of batch Download Script file, avoids the occurrence of the script file having when independent downloading
It downloads successfully, some downloadings are unsuccessful to be happened.
Step S51- step S52 is directly downloaded if downloading is a target script file, if downloading is at least
At least two target script files are then first carried out compression processing and form compressed package then downloading by two target script files, can
To realize that batch is downloaded, download efficiency is improved.
It in one embodiment, include that script modifies prompt information in script specification audit report, in step S70, by script
After the step of normalized checking report is sent to login account corresponding client, database script management method further include: obtain
The specification script sentence based on script modification prompt information modification that client is sent is taken, and specification script sentence is stored to right
In the effective script file answered.
Specifically, after script specification audit report is sent to the corresponding client of login account by first server,
Developer modifies the information in tables of data according to script specification audit report on the client, on the basis of effective script file
It is upper to generate new specification script sentence, form new effective script file.
In one embodiment, after obtaining target script file, it is also necessary to target script file are sent to database and examined
Core platform is audited, as shown in figure 5, database script management method further includes the corresponding second service of database audits platform
The following steps that device executes:
S61: obtaining the target script file that first server is sent, and is based on target script file, and use is pre-stored
Script verification rule carries out regular verification to target script file.
Specifically, after obtaining target script file, target script file can be sent to database and examined by first server
Core platform, the corresponding second server of database audits platform is by pre-stored script verification rule to target script file
Carry out regular verification.Wherein, whether script verification rule refers to pre-stored standardizes the rule verified for script.This reality
Applying the script verification rule in example includes the script name that normative verification is carried out to the target script name of target script file
Verification rule and the script sentence specification validation rule that normative verification is carried out to the script sentence in target script file.
Further, database audits platform, can be first using script name verification rule after getting target script file
Then the target script name of target script file is verified.Such as preset script name verification rule are as follows: serial number _ exploit person
Member's name _ type (table) _ operation (building table) _ cbits_table_data_move (table name) _ founder .sql.Use the script name
Verification rule is claimed to carry out regular verification to the target script name of target script file.Regular school is being carried out to target script name
After testing, reuses script sentence specification validation rule and regular verification is carried out to the script sentence in target script file.
S62: if target script file does not meet script verification rule, to the target script for not meeting script verification rule
File carries out intelligent correction.
The function of intelligent correction is provided in script sentence specification validation rule in the present embodiment.Using script sentence
During specification validation rule verifies, if intelligence can be used to the script sentence for not meeting script sentence specification validation rule
Error correction then carries out intelligent correction to the script sentence for not meeting script sentence specification validation rule.Such as script sentence specification
Require " table founder " that lowercase, when there is capitalization in " table founder ", script language must be used in verification rule
Intelligent correction function in sentence specification validation rule can carry out intelligent correction to the capitalization in script, and capitalization is modified
At corresponding lowercase.
S63: the successful specification script sentence of error correction and the unsuccessful script sentence lack of standardization of error correction are obtained, specification foot is based on
This sentence and script sentence lack of standardization obtain effective script file, and generate script specification inspection report based on script sentence lack of standardization
It accuses.
Specifically, after carrying out intelligent correction to target script file using intelligent correction function, in target script file
Some script sentences lack of standardization can complete intelligent correction, become specification script sentence；Some script sentences lack of standardization cannot
Complete intelligent correction, however it remains nonstandard place.The successful specification script sentence of error correction is checked in order to facilitate developer
With the unsuccessful script sentence lack of standardization of error correction, second server can be unsuccessful by the successful specification script sentence of error correction and error correction
Script sentence lack of standardization form corresponding effective script file, and the script language that script sentence specification validation rule will not met
Sentence is recorded in script specification audit report.Wherein, the target script file after effective script file fingering row intelligent correction.
Such as one script sentence specification validation rule setting be for index script file in, an address name is final
The user data of acquisition is only one, and the index in the index script file of creation is address name, but since address name is deposited
The case where bearing the same name, when searching user data using the index (address name) in index script file, it may get
A plurality of data corresponding with the address name.At this point, according to the script sentence specification validation rule of setting to index script file
Regular verification is carried out, an address name may obtain corresponding a plurality of data, it is made to be unsatisfactory for the script sentence specification validation
Rule.Also, the function for the intelligent correction being arranged in script sentence specification validation rule cannot carry out intelligent correction to the problem,
At this point, the script sentence for not meeting preset script sentence verification rule will be recorded in script specification audit report, by it
Labeled as script sentence lack of standardization.In order to facilitate developer to the script lack of standardization for not meeting script sentence specification validation rule
Sentence is modified, and further includes the description of contents for not meeting script sentence specification validation rule in script specification audit report.
S64: effective script file and script specification audit report are sent to first server.
It, will after the corresponding second server of database audits platform obtains effective script file and script specification audit report
Effective script file and corresponding script specification audit report send jointly to first server.
Further, first server obtains the effective script file and corresponding script rule that database audits platform returns
Model audit report, and effective script file and corresponding script specification audit report are sent to the corresponding client of login account
End prompts developer to be modified according to script specification audit report to related content on the basis of effective script file,
So that modified script sentence meets corresponding script verification rule.Such as in tables of data by index modification be address name and
Identification card number generates new index script file based on modified index on the basis of effective script file, improves script
The efficiency of file generated saves the time that developer oneself writes script.
Step S61- step S64, by obtaining the effective script file and script specification inspection that database audits platform returns
Report is looked into, so that developer modifies to effective script file according to script specification audit report, script is improved and generates effect
Rate simplifies treatment process.
Database script management method provided in an embodiment of the present invention, by testing login account and login password
Card, determines the safety of developer's identity, after login account and login password authentication pass through, developer can be in client
End sends script request to create, and first server is after obtaining script request to create, using building table rule to script request to create
The original basic information of the tables of data of carrying carries out regular verification, will meet the original basic information for building table rule and saves as effectively
Essential information, not being inconsistent the corresponding modification prompt information of original basic information for building table rule jointly, to be sent to login account corresponding
Client improves the efficiency for being subsequently generated original script file.After carrying out regular verification, call in script Core Generator extremely
A few script generated statement, is handled the effective essential information for building table rule is met, and obtains original script file, is saved
Time of artificial deployment script file reduces the probability to go wrong during artificial deployment script.Generating original foot
After this document, the script sentence to original script file is needed to verify, for uniform auditing standard, improves review efficiency,
If the when at least two target script files of downloading, under first then target script file being carried out compression processing formation compressed package
It carries, the target script file downloaded is sent to database audits platform, have the return of database audits platform when obtaining
Script specification audit report, and normalized checking report is sent to the corresponding client of login account, so that developer can
To be modified according to the script specification audit report to the script sentence for not meeting specification, improves script sentence and modify efficiency.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
In one embodiment, a kind of database script managing device is provided, the database script managing device and above-mentioned reality
Database script management method in example is applied to correspond.As shown in fig. 6, the database script managing device is specially first service
Device, including logging request obtains module 10, script request to create obtains module 20, regular correction verification module 30, original script file
Obtain module 40, target script file obtains module 50, target script file auditing module 60 and normalized checking report handle mould
Block 70.Detailed description are as follows for each functional module:
Logging request obtains module 10, for obtaining the logging request of client transmission, carries login in logging request
Account and login password.
Script request to create obtains module 20, for being verified to login account and login password, if being verified,
Script request to create is obtained, script request to create includes the original basic information of tables of data.
Regular correction verification module 30, for obtaining effective base using table rule is built to the regular verification of original basic information progress
This information.
Original script file acquisition module 40 generates corresponding with effective essential information for calling script Core Generator
Original script file.
Target script file obtains module 50, for obtaining script downloading request, downloads the mesh that request carries based on script
Script name is marked from original script file, downloads target script file corresponding with target script name.
Target script file auditing module 60 obtains number for target script file to be sent to database audits platform
The script specification audit report corresponding with target script file returned according to library audit platform.
Normalized checking report processing module 70, for script specification audit report to be sent to the corresponding client of login account
End.
Further, regular correction verification module includes regular verification unit, first effective essential information acquiring unit and second
Effective information acquiring unit.
Regular verification unit builds table rule to the regular verification of original basic information progress for using.
First effective essential information acquiring unit builds table rule if meeting for original basic information, will be original basic
Information preservation is effective essential information.
Second effective information acquiring unit builds table rule jointly if not being inconsistent for original basic information, based on original basic
Information and corresponding table rule of building generate modification prompt information, and modification prompt information is sent to the corresponding client of login account
End obtains the modification essential information that client is returned based on modification prompt information, using modification essential information as original basic letter
Breath repeats to use and builds the step of table rule carries out rule verification to original basic information.
Further, original script file acquisition module 40 is also used to call at least one script in script Core Generator
Generated statement is respectively handled effective essential information, obtains original script text corresponding with each script generated statement
Part.
Further, it includes first object script file acquiring unit and the second target that target script file, which obtains module 50,
Script file acquiring unit.
First object script file acquiring unit, if for only including a kind of script file type in script downloading request,
The target script name for requesting to carry and script file type are then downloaded from original script file based on script, downloading and target
Script name and the corresponding target script file of script file type.
Second target script file acquiring unit, if for including at least two script file classes in script downloading request
Type, then based on script download request carry target script name and script file type from original script file, obtain with
Target script name and the corresponding target script file of script file type, and target script file is carried out at automatic compression
Reason, obtains and downloads the corresponding compressed package of target script file.
Further, after normalized checking report processing module 70, database script managing device is also used to obtain client
The specification script sentence based on script modification prompt information modification that end is sent, and the storage of specification script sentence is had to corresponding
It imitates in script file.
In one embodiment, a kind of database script managing device is provided, the database script managing device and above-mentioned reality
Database script management method in example is applied to correspond.As shown in fig. 7, the database script managing device is specially that database is examined
The corresponding second server of core platform, including database audits platform auditing module 61, intelligent correction module 62, result treatment mould
Block 63 and data transmission blocks 64.
Database audits platform auditing module 61 is based on mesh for obtaining the target script file of first server transmission
Script file is marked, regular verification is carried out to target script file using pre-stored script verification rule.
Intelligent correction module 62, if script verification rule is not met for target script file, to not meeting script school
The target script file for testing rule carries out intelligent correction.
Result treatment module 63, for obtaining the successful specification script sentence of error correction and the unsuccessful script lack of standardization of error correction
Sentence obtains effective script file based on specification script sentence and script sentence lack of standardization, and raw based on script sentence lack of standardization
At script specification audit report.
Data transmission blocks 64, for effective script file and script specification audit report to be sent to first server.
Specific restriction about database script managing device may refer to above for database script management method
Restriction, details are not described herein.Modules in above-mentioned database script managing device can be fully or partially through software, hard
Part and combinations thereof is realized.Above-mentioned each module can be embedded in the form of hardware or independently of in the processor in computer equipment,
It can also be stored in a software form in the memory in computer equipment, execute the above modules in order to which processor calls
Corresponding operation.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 8.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The database of the machine equipment data that script management method in library is related to for storing data.The network interface of the computer equipment is used
It is communicated in passing through network connection with external terminal.To realize a kind of database script when the computer program is executed by processor
Management method.
In one embodiment, a kind of computer equipment is provided, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, processor realize above-mentioned database script manager when executing computer program
The step of method, step S10 to step S70 or Fig. 3 as shown in Figure 2 to step shown in fig. 5.Alternatively, processor executes meter
Realize that the function of each module/unit of above-mentioned database script managing device, logging request as shown in FIG. 6 obtain when calculation machine program
Modulus block 10, script request to create obtain module 20, regular correction verification module 30, original script file acquisition module 40, target foot
This document obtains module 50, target script file auditing module 60 and normalized checking report processing module 70 or shown in Fig. 7
Database audits platform auditing module 61, intelligent correction module 62, result treatment module 63 and data transmission blocks 64.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program realizes the step of above-mentioned database script management method, step S10 as shown in Figure 2 to step when being executed by processor
S70 or Fig. 3 is to step shown in fig. 5.Alternatively, realizing above-mentioned database script pipe when computer program is executed by processor
The function of each module/unit of device is managed, logging request as shown in FIG. 6 obtains module 10, script request to create obtains module
20, regular correction verification module 30, original script file acquisition module 40, target script file obtain module 50, target script file
Auditing module 60 and normalized checking report processing module 70 or database audits platform auditing module 61 shown in Fig. 7, intelligence
Correction module 62, result treatment module 63 and data transmission blocks 64.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function
Can unit, module division progress for example, in practical application, can according to need and by above-mentioned function distribution by different
Functional unit, module are completed, i.e., the internal structure of described device is divided into different functional unit or module, more than completing
The all or part of function of description.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although referring to aforementioned reality
Applying example, invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features；And these are modified
Or replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of database script management method, which is characterized in that the following steps executed including first server:
The logging request that client is sent is obtained, carries login account and login password in the logging request；
The login account and the login password are verified, if being verified, obtain script request to create, the foot
This request to create includes the original basic information of tables of data；
Regular verification is carried out to the original basic information using table rule is built, obtains effective essential information；
Script Core Generator is called, original script file corresponding with the effective essential information is generated；
Script downloading request is obtained, is downloaded based on the script and requests the target script name carried from original script file,
Download target script file corresponding with the target script name；
The target script file is sent to database audits platform, obtain that the database audits platform returns with it is described
The corresponding script specification audit report of target script file；
The script specification audit report is sent to the corresponding client of the login account.
2. database script management method as described in claim 1, which is characterized in that described use builds table rule to the original
Beginning essential information carries out regular verification, obtains effective essential information, comprising:
Regular verification is carried out to the original basic information using table rule is built；
If it is regular that the original basic information meets the table of building, the original basic information is saved as into effectively basic letter
Breath；
If the original basic information do not meet it is described build table rule, based on the original basic information and corresponding described build
Table rule generates modification prompt information, and the modification prompt information is sent to the corresponding client of the login account, obtains
The modification essential information that the client is returned based on the modification prompt information, using the modification essential information as original base
This information repeats described use and builds the step of table rule carries out rule verification to the original basic information.
3. database script management method as described in claim 1, which is characterized in that the script Core Generator includes at least
One script generated statement；
The calling script Core Generator generates at least one original script file corresponding with effective essential information, packet
It includes:
At least one script generated statement in script Core Generator is called, effective essential information is handled respectively,
Obtain original script file corresponding with each script generated statement.
4. database script management method as described in claim 1, which is characterized in that the script downloading request further includes foot
This document type；
The target script name for downloading request carrying based on the script is downloaded and the target from original script file
The corresponding target script file of script name, comprising:
If only including a kind of script file type in the script downloading request, the mesh that request carries is downloaded based on the script
Script name and the script file type are marked from the original script file, downloading and the target script name and described
The corresponding target script file of script file type；
If including at least two script file types in the script downloading request, download what request carried based on the script
Target script name and the script file type obtain and the target script name and institute from the original script file
The corresponding at least two targets script file of script file type is stated, and the target script file is carried out at automatic compression
Reason, obtains and downloads the corresponding compressed package of the target script file.
5. database script management method according to any one of claims 1-4, which is characterized in that the script specification inspection
It include that script modifies prompt information in report；
It is described after the described the step of script specification audit report is sent to the login account corresponding client
Database script management method further include:
The specification script sentence based on script modification prompt information modification that client is sent is obtained, and by the specification foot
This sentence is stored into corresponding effective script file.
6. a kind of database script management method, which is characterized in that held including the corresponding second server of database audits platform
Capable following steps:
The target script file that first server is sent is obtained, the target script file is based on, using pre-stored script
Verification rule carries out regular verification to the target script file；
If the target script file does not meet script verification rule, to the target script file for not meeting script verification rule
Carry out intelligent correction；
The successful specification script sentence of error correction and the unsuccessful script sentence lack of standardization of error correction are obtained, the specification script language is based on
Sentence and the script sentence lack of standardization obtain effective script file, and generate script specification inspection based on the script sentence lack of standardization
Look into report；
Effective script file and the script specification audit report are sent to the first server.
7. a kind of database script managing device characterized by comprising
Logging request obtains module, for obtaining the logging request of client transmission, carries login account in the logging request
Number and login password；
Script request to create obtains module, for being verified to the login account and the login password, if being verified,
Script request to create is then obtained, the script request to create includes the original basic information of tables of data；
Regular correction verification module, for obtaining effectively basic using table rule is built to the regular verification of original basic information progress
Information；
Original script file acquisition module generates original corresponding with the effective essential information for calling script Core Generator
Beginning script file target script file obtains module, for obtaining script downloading request, is carried based on script downloading request
Target script name from original script file, download corresponding with target script name target script file；
Target script file auditing module, for the target script file to be sent to database audits platform, described in acquisition
The script specification audit report corresponding with the target script file that database audits platform returns；
Normalized checking report processing module, for the script specification audit report to be sent to the corresponding visitor of the login account
Family end.
8. a kind of database script managing device characterized by comprising
Database audits platform auditing module is based on the target for obtaining the target script file of first server transmission
Script file carries out regular verification to the target script file using pre-stored script verification rule；
Intelligent correction module verifies if not meeting script verification rule for the target script file to script is not met
The target script file of rule carries out intelligent correction；
Result treatment module, for obtaining the successful specification script sentence of error correction and the unsuccessful script sentence lack of standardization of error correction,
Effective script file is obtained based on the specification script sentence and the script sentence lack of standardization, and is based on the script lack of standardization
Sentence generates script specification audit report；
Data transmission blocks, for effective script file and the script specification audit report to be sent to first clothes
Business device.
9. a kind of computer equipment, including memory, processor and storage are in the memory and can be in the processor
The computer program of upper operation, which is characterized in that the processor realized when executing the computer program as claim 1 to
The step of any one of 6 database script management method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In realization database script management method as described in any one of claim 1 to 6 when the computer program is executed by processor
The step of.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811183800.6A CN109308285A (en) | 2018-10-11 | 2018-10-11 | Database script management method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811183800.6A CN109308285A (en) | 2018-10-11 | 2018-10-11 | Database script management method, device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109308285A true CN109308285A (en) | 2019-02-05 |
Family
ID=65225434
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811183800.6A Pending CN109308285A (en) | 2018-10-11 | 2018-10-11 | Database script management method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109308285A (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110162755A (en) * | 2019-04-12 | 2019-08-23 | 平安普惠企业管理有限公司 | A kind of management method and equipment of product promotion script |
| CN110377583A (en) * | 2019-06-17 | 2019-10-25 | 平安普惠企业管理有限公司 | Database script executes method, apparatus, computer equipment and storage medium |
| CN110471665A (en) * | 2019-06-28 | 2019-11-19 | 平安科技（深圳）有限公司 | Script file method of calibration, device, server and storage medium |
| CN110750444A (en) * | 2019-09-10 | 2020-02-04 | 中国平安财产保险股份有限公司 | Application program handover method, application program handover device, computer device and storage medium |
| CN111104155A (en) * | 2019-11-29 | 2020-05-05 | 北京浪潮数据技术有限公司 | Database script management platform and method, electronic equipment and storage medium |
| CN111651429A (en) * | 2020-05-26 | 2020-09-11 | 中国平安财产保险股份有限公司 | Big data scheduling parameter management method and device and distributed platform |
| CN111694991A (en) * | 2019-03-13 | 2020-09-22 | 上海了子文化体育发展有限公司 | Data transmission method based on DDEX protocol |
| CN111737349A (en) * | 2020-06-18 | 2020-10-02 | 中国银行股份有限公司 | Data consistency checking method and device |
| CN112256672A (en) * | 2020-10-22 | 2021-01-22 | 中国联合网络通信集团有限公司 | Database change approval method and device |
| CN112395591A (en) * | 2020-11-17 | 2021-02-23 | 陕西上讯信息技术有限公司 | Encryption method and system |
| CN112416361A (en) * | 2020-12-03 | 2021-02-26 | 平安普惠企业管理有限公司 | Structured query language script examination method and related equipment |
| CN112579101A (en) * | 2020-12-21 | 2021-03-30 | 广州博冠信息科技有限公司 | Task script control method and device, electronic equipment and storage medium |
| CN112632012A (en) * | 2021-01-08 | 2021-04-09 | 中国农业银行股份有限公司 | Script saving method, system and related equipment |
| CN112818342A (en) * | 2021-02-24 | 2021-05-18 | 江苏保旺达软件技术有限公司 | Script auditing method, device, equipment and storage medium |
| CN113138974A (en) * | 2021-04-23 | 2021-07-20 | 建信金融科技有限责任公司 | Database compliance detection method and device |
| CN113591147A (en) * | 2021-07-30 | 2021-11-02 | 平安普惠企业管理有限公司 | Data extraction method and device, computer equipment and storage medium |
| CN114745368A (en) * | 2022-03-31 | 2022-07-12 | 广州极飞科技股份有限公司 | File downloading method and device, computer equipment and computer readable storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7003765B1 (en) * | 2001-12-12 | 2006-02-21 | Oracle International Corporation | Computer-based pre-execution analysis and verification utility for shell scripts |
| KR20110019508A (en) * | 2009-08-20 | 2011-02-28 | 대진대학교 산학협력단 | A test and history management system for mobile station applications using test libraries and the method thereof |
| CN102789415A (en) * | 2011-04-13 | 2012-11-21 | 埃森哲环球服务有限公司 | Modular script designer for next generation testing system |
| CN103678485A (en) * | 2013-12-26 | 2014-03-26 | 中国运载火箭技术研究院 | Virtual experiment process node driving and movable packaging system |
| CN106775978A (en) * | 2016-12-12 | 2017-05-31 | 北京匡恩网络科技有限责任公司 | Script call method and instruction debugging apparatus |
-
2018
- 2018-10-11 CN CN201811183800.6A patent/CN109308285A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7003765B1 (en) * | 2001-12-12 | 2006-02-21 | Oracle International Corporation | Computer-based pre-execution analysis and verification utility for shell scripts |
| KR20110019508A (en) * | 2009-08-20 | 2011-02-28 | 대진대학교 산학협력단 | A test and history management system for mobile station applications using test libraries and the method thereof |
| CN102789415A (en) * | 2011-04-13 | 2012-11-21 | 埃森哲环球服务有限公司 | Modular script designer for next generation testing system |
| CN103678485A (en) * | 2013-12-26 | 2014-03-26 | 中国运载火箭技术研究院 | Virtual experiment process node driving and movable packaging system |
| CN106775978A (en) * | 2016-12-12 | 2017-05-31 | 北京匡恩网络科技有限责任公司 | Script call method and instruction debugging apparatus |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111694991A (en) * | 2019-03-13 | 2020-09-22 | 上海了子文化体育发展有限公司 | Data transmission method based on DDEX protocol |
| CN110162755A (en) * | 2019-04-12 | 2019-08-23 | 平安普惠企业管理有限公司 | A kind of management method and equipment of product promotion script |
| CN110377583A (en) * | 2019-06-17 | 2019-10-25 | 平安普惠企业管理有限公司 | Database script executes method, apparatus, computer equipment and storage medium |
| CN110471665A (en) * | 2019-06-28 | 2019-11-19 | 平安科技（深圳）有限公司 | Script file method of calibration, device, server and storage medium |
| CN110750444A (en) * | 2019-09-10 | 2020-02-04 | 中国平安财产保险股份有限公司 | Application program handover method, application program handover device, computer device and storage medium |
| CN111104155A (en) * | 2019-11-29 | 2020-05-05 | 北京浪潮数据技术有限公司 | Database script management platform and method, electronic equipment and storage medium |
| CN111651429A (en) * | 2020-05-26 | 2020-09-11 | 中国平安财产保险股份有限公司 | Big data scheduling parameter management method and device and distributed platform |
| CN111651429B (en) * | 2020-05-26 | 2023-10-24 | 中国平安财产保险股份有限公司 | Big data scheduling parameter management method, device and distributed platform |
| CN111737349A (en) * | 2020-06-18 | 2020-10-02 | 中国银行股份有限公司 | Data consistency checking method and device |
| CN111737349B (en) * | 2020-06-18 | 2023-09-19 | 中国银行股份有限公司 | Data consistency verification method and device |
| CN112256672A (en) * | 2020-10-22 | 2021-01-22 | 中国联合网络通信集团有限公司 | Database change approval method and device |
| CN112256672B (en) * | 2020-10-22 | 2023-05-30 | 中国联合网络通信集团有限公司 | Database change approval method and device |
| CN112395591A (en) * | 2020-11-17 | 2021-02-23 | 陕西上讯信息技术有限公司 | Encryption method and system |
| CN112416361A (en) * | 2020-12-03 | 2021-02-26 | 平安普惠企业管理有限公司 | Structured query language script examination method and related equipment |
| CN112579101A (en) * | 2020-12-21 | 2021-03-30 | 广州博冠信息科技有限公司 | Task script control method and device, electronic equipment and storage medium |
| CN112632012A (en) * | 2021-01-08 | 2021-04-09 | 中国农业银行股份有限公司 | Script saving method, system and related equipment |
| CN112818342A (en) * | 2021-02-24 | 2021-05-18 | 江苏保旺达软件技术有限公司 | Script auditing method, device, equipment and storage medium |
| CN112818342B (en) * | 2021-02-24 | 2024-03-12 | 江苏保旺达软件技术有限公司 | Script auditing method, device, equipment and storage medium |
| CN113138974A (en) * | 2021-04-23 | 2021-07-20 | 建信金融科技有限责任公司 | Database compliance detection method and device |
| CN113138974B (en) * | 2021-04-23 | 2023-08-22 | 建信金融科技有限责任公司 | Method and device for detecting database compliance |
| CN113591147A (en) * | 2021-07-30 | 2021-11-02 | 平安普惠企业管理有限公司 | Data extraction method and device, computer equipment and storage medium |
| CN114745368A (en) * | 2022-03-31 | 2022-07-12 | 广州极飞科技股份有限公司 | File downloading method and device, computer equipment and computer readable storage medium |
| CN114745368B (en) * | 2022-03-31 | 2024-04-09 | 广州极飞科技股份有限公司 | File downloading method, device, computer equipment and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109308285A (en) | Database script management method, device, computer equipment and storage medium | |
| CN109344642B (en) | Interface rule checking method, device, computer equipment and storage medium | |
| CN109032611A (en) | Script dispositions method, device, computer equipment and storage medium | |
| CN110297813A (en) | Data migration method, device, computer equipment and storage medium | |
| CN110727954B (en) | Data authorization desensitization automation method, device and storage medium | |
| CN109032824A (en) | Database method of calibration, device, computer equipment and storage medium | |
| CN108959076A (en) | A kind of API on-line debugging method | |
| US10305962B1 (en) | Unit testing clients of web services | |
| CA3131079A1 (en) | Test case generation method and device, computer equipment and storage medium | |
| CN110941630A (en) | Database operation and maintenance method, device and system | |
| CN110309099A (en) | Interface managerial method, device, equipment and computer readable storage medium | |
| CN110083384B (en) | Application programming interface creating method and device | |
| CN110287102A (en) | Core data detection processing method, apparatus, computer equipment and storage medium | |
| CN113448862B (en) | Software version testing method and device and computer equipment | |
| CN112860778A (en) | Database management method, device, equipment and medium for desktop application program | |
| CN112631686A (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN112328482A (en) | Test method and device based on script template, computer equipment and storage medium | |
| CN110865975A (en) | Method and device for managing document, electronic equipment and storage medium | |
| Di Pierro | web2py | |
| CN109242561A (en) | Prize drawing model building method, sweepstake management method, device and calculating equipment | |
| CN112561690A (en) | Method, system, equipment and storage medium for testing credit card staging service interface | |
| CN112685077A (en) | Data modification method, system, computer device and computer readable storage medium | |
| CN112015715A (en) | Industrial Internet data management service testing method and system | |
| CN113112270B (en) | Data organization method based on block chain | |
| CN109101232A (en) | A kind of method, apparatus of product development, computer equipment and storage medium |
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 |