Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and device for verifying script file

A script file and verification method technology, applied in the database field, can solve the problems of low efficiency of the verification process, time and effort of testers, etc.

Active Publication Date: 2012-06-06
青岛金蝶软件科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method of manually finding the wrong script file and the developer of the wrong file will inevitably consume a lot of time and energy of the tester, and then it will not be able to be processed quickly and effectively, especially when the database script file fails to pass the verification. When the number of saved script files is large, it will consume a lot of time and energy of testers, which will eventually lead to low work efficiency in the entire verification process

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for verifying script file
  • Method and device for verifying script file
  • Method and device for verifying script file

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0024] see figure 1 , which is a flowchart of an embodiment of a script file verification method of the present invention, the method includes the following steps:

[0025] Step 101: Obtain the version modification information of the script file in the database to be verified from the version management tool, and execute the script file in the database to be verified to obtain the execution result information of the wrong script file, the version modification information includes at least modification A person's account number and a script file path, and the execution result information includes at least the script file path and the execution result;

[0026] Wherein, said obtaining the version modification information of the script file in the database to be verified from the version management tool includes: downloading the script file in the database to be verified from the version management tool; according to the log format in the version management tool, parsing The log...

Embodiment 2

[0046] The following takes a specific application scenario as an example to describe the verification process of the script file in detail. see figure 2 , which is a flowchart of another embodiment of a script file verification method of the present invention. In this embodiment, SVN is selected as the version management tool, and JDBC is selected as the third-party tool. And, for the convenience of describing the verification process of script files, in this embodiment, the number of script files in a project is simplified to 10, and these 10 script files are maintained in a database, and are managed by SVN, and this database serves as A database to be verified, the process of verifying the script file in the database to be verified includes the following steps:

[0047] Step 201: respectively read 10 script files in the database to be verified from the version management tool SVN, and obtain log files generated when the 10 script files are downloaded;

[0048] Among them,...

Embodiment 3

[0069] Corresponding to the above method for verifying a script file, an embodiment of the present invention also provides a device for verifying a script file. see image 3 , which is a structural diagram of an embodiment of an apparatus for verifying script files in the present invention, the apparatus includes a verification unit 301 and a matching unit 302 . The internal structure and connection relationship of the device will be further introduced below in conjunction with the working principle of the device.

[0070] The verification unit 301 is used to obtain the version modification information of the script file in the database to be verified from the version management tool, and execute the script file in the database to be verified to obtain the execution result information of the wrong script file, and the version modification information At least including the account number of the modifying person and the path of the script file, and the execution result informa...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention discloses a method and a device for verifying a script file. The method comprises the following steps: acquiring edition modification information of a script file in a database to be verified from an edition management tool, and executing the script file of the database to be verified to acquire execution result information of an error script file, wherein the edition modification information at least comprises a modifier account number and a script file path, and the execution result information at least comprises the script file path and an execution result; and matching the edition modification information with the execution result information of the error script file to acquire the modifier account number of the error script file to ensure that a developer denoted by the modifier account number of the error script file modifies the corresponding error script file. The method and the device can improve the working efficiency of the whole verificationprocess when the script file is verified.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a script file verification method and device. Background technique [0002] During the development of database application software, it is usually necessary for multiple developers to work together to complete the entire project. Among them, after each developer completes their respective tasks, they submit script files to the database respectively. After all the script files of a project are stored in the database, verification is also required. Wherein, the verification process is to actually execute all script files once, and once there is a script file that fails to execute, all script files in the database fail the verification. [0003] In the prior art, if a script file in a database fails to pass the verification, the relevant tester needs to manually open all the script files in the database one by one, and then find the wrong script in the database that failed to ex...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F11/36G06F17/30
Inventor 刘继平
Owner 青岛金蝶软件科技有限公司