CN109522295B - Automatic database object constructing and deploying method and device - Google Patents
Automatic database object constructing and deploying method and device Download PDFInfo
- Publication number
- CN109522295B CN109522295B CN201811365703.9A CN201811365703A CN109522295B CN 109522295 B CN109522295 B CN 109522295B CN 201811365703 A CN201811365703 A CN 201811365703A CN 109522295 B CN109522295 B CN 109522295B
- Authority
- CN
- China
- Prior art keywords
- file
- source code
- installation
- code file
- database object
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/61—Installation
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application provides a method and a device for automatically constructing and deploying a database object, wherein the method comprises the steps of obtaining at least one source code file which is not tested currently from a source code server; extracting each database object in at least one source code file to generate an object deletion file; generating a file for installation according to the deleted file, the at least one source code file and the execution sequence of each source code file in the at least one source code file; the method and the device have the advantages that the resource files are sent to the test library server, the test library server is triggered to automatically execute the installation process according to the resource files, the automatic installation result of the database object is obtained, the resource files comprise the modes of deleting the files, installing the files and at least one source code file, automatic construction and deployment of the database object are achieved, compared with the mode of manually constructing and deploying the database object of the source code file, the method and the device improve the construction and deployment efficiency of the database object and save labor cost.
Description
Technical Field
The invention relates to the technical field of database object construction and deployment, in particular to a method and a device for automatically constructing and deploying a database object.
Background
Continuous integration: one software development practice is that team development members often integrate their work by integrating each member at least once a day, meaning that multiple integrations may occur each day. Each integration requires the construction and deployment of database objects to verify the correctness of the source code files developed by the development members, thereby discovering integration errors as early as possible.
At present, the database object in the source code file is constructed and deployed manually, and the construction and deployment method generally has the problems of time and labor waste, easy error, and long construction and deployment period. Especially, with the increase of a large number of source code files, the way of manually constructing and deploying the database objects of the source code files cannot meet the requirement of continuous integration at all.
In view of this, how to provide a method and a device for automatically constructing and deploying a database object to improve the efficiency of constructing and deploying the database object and save labor cost is an urgent problem to be solved.
Disclosure of Invention
In view of this, the present invention provides a method and an apparatus for automatically constructing and deploying a database object, so as to improve the efficiency of constructing and deploying the database object and save labor cost.
The technical scheme is as follows:
a database object automatic construction and deployment method comprises the following steps:
obtaining at least one source code file from a source code server, wherein the at least one source code file comprises each source code file which is not tested currently in the source code server;
extracting each database object in the at least one source code file to generate an object deletion file, wherein the object deletion file comprises a statement for deleting each database object in a local database;
generating an installation file according to the object deletion file, at least one source code file and the execution sequence of each source code file in the at least one source code file, wherein the installation file is used for representing the execution sequence between the object deletion file and each source code file;
sending a resource file to a test library server, triggering the test library server to automatically execute an installation process according to the resource file, and obtaining an automatic installation result of a database object, wherein the resource file comprises the deleted file, an installation file and at least one source code file.
Preferably, before extracting each database object in the at least one source code file to generate an object deletion file, the method further includes:
determining each source code file which does not meet preset file name naming specifications in the at least one source code file;
and acquiring the source code files carrying the same user name identifier from the determined source code files, and sending the file list information of the source code files carrying the same user name identifier to the user indicated by the user name identifier.
Preferably, the method further comprises the following steps:
and receiving the modification operation of the user on the file name of the source code file in the at least one source code file indicated by the file list information, and modifying the file name of the source code file.
Preferably, before generating the installation file according to the object deletion file, the at least one source code file, and the execution order of each source code file in the at least one source code file, the method further includes:
and when the encoding format of the source code file in the at least one source code file is not a preset encoding format, converting the encoding format of the source code file into the preset encoding format.
Preferably, the generating an installation file according to the object deletion file, the at least one source code file, and the execution sequence of each source code file in the at least one source code file includes:
determining an execution sequence of each source code file in the at least one source code file based on a data operation type indicated by a file name of the source code file;
and generating an installation file according to the execution sequence of the preset object deletion file relative to the source code file and the execution sequence of each source code file in the at least one source code file.
Preferably, the sending the resource file to the test library server, and triggering the test library server to automatically execute the installation process according to the resource file to obtain the automatic installation result of the database object includes:
and sending the deleted file, the installed file and at least one source code file to a test library server, triggering the test library file to execute the deleted file and the at least one source code file according to the execution sequence indicated by the installed file, and obtaining an automatic installation result of the database object, wherein the resource file comprises the deleted file, the installed file and the at least one source code file.
Preferably, the automatic installation result of the database object includes an installation log for characterizing an installation process of the resource file, and the method further includes:
analyzing the installation log to obtain installation error information in the installation log;
and sending the installation error information to a user indicated by a user name identifier carried by a source code file which causes the installation error information.
Preferably, the method further comprises the following steps:
acquiring preset error grade information of the installation error information, and associating the error grade information with the installation error information;
the sending the installation error information to the user indicated by the user name identifier carried in the source code file causing the installation error information comprises: and sending the installation error information associated with the error grade information to a user indicated by a user name identifier carried by a source code file causing the installation error information.
An automatic database object constructing and deploying device comprises:
a source code file obtaining unit, configured to obtain at least one source code file from a source code server, where the at least one source code file includes each source code file that is not currently tested in the source code server;
a database object extracting unit, configured to extract each database object in the at least one source code file to generate an object deletion file, where the object deletion file includes a statement for deleting each database object in a local database;
the installation file generation unit is used for generating an installation file according to the object deletion file, at least one source code file and the execution sequence of each source code file in the at least one source code file, wherein the installation file is used for representing the execution sequence between the object deletion file and each source code file;
and the database object automatic deployment unit is used for sending a resource file to a test library server, triggering the test library server to automatically execute an installation process according to the resource file, and obtaining an automatic installation result of the database object, wherein the resource file comprises the deleted file, an installation file and at least one source code file.
Preferably, the automatic installation result of the database object includes an installation log for characterizing an installation process of the resource file, and the apparatus further includes:
the installation log analyzing unit is used for analyzing the installation log and acquiring installation error information in the installation log;
and the installation error information prompting unit is used for sending the installation error information to a user indicated by a user name identifier carried by a source code file which causes the generation of the installation error information.
The embodiment of the application provides a method and a device for automatically constructing and deploying a database object, wherein the method comprises the steps of obtaining at least one source code file which is not tested currently from a source code server; extracting each database object in at least one source code file to generate an object deletion file; generating a file for installation according to the deleted file, the at least one source code file and the execution sequence of each source code file in the at least one source code file; the method and the device have the advantages that the resource files are sent to the test library server, the test library server is triggered to automatically execute the installation process according to the resource files, the automatic installation result of the database object is obtained, the resource files comprise the modes of deleting the files, installing the files and at least one source code file, automatic construction and deployment of the database object are achieved, compared with the mode of manually constructing and deploying the database object of the source code file, the method and the device improve the construction and deployment efficiency of the database object and save labor cost.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a flowchart of a method for automatically constructing and deploying a database object according to an embodiment of the present disclosure;
fig. 2 is a flowchart of a method for generating an installation file according to an execution sequence of an object deletion file, at least one source code file, and each source code file in the at least one source code file according to an embodiment of the present application;
fig. 3 is a flowchart of another method for automatically constructing and deploying a database object according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an automatic database object constructing and deploying apparatus according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example (b):
fig. 1 is a flowchart of a method for automatically constructing and deploying a database object according to an embodiment of the present application.
As shown in fig. 1, the method includes:
s101, obtaining at least one source code file from a source code server, wherein the at least one source code file comprises all source code files which are not tested currently in the source code server;
s102, extracting each database object in at least one source code file to generate an object deletion file, wherein the object deletion file comprises a statement for deleting each database object in a local database;
in the embodiment of the application, for each source code file in at least one source code file, extracting each database object in the source code file; for each database object extracted from at least one source code file, generating a statement for deleting the database object in the local database, and correspondingly, forming an object deletion file by all the generated statements.
For example, 3 database objects are extracted from at least one source code file, which are respectively a database object 1, a database object 2 and a database object 3; generating statement 1 for deleting database object 1 in the local database, generating statement 2 for deleting database object 2 in the local database, and generating statement 3 for deleting database object 3 in the local database; and generating an object deletion file, wherein the object deletion file comprises a statement 1, a statement 2 and a statement 3.
S103, generating an installation file according to the object deletion file, the at least one source code file and the execution sequence of each source code file in the at least one source code file;
an embodiment of the present application provides a flowchart of a method for generating an installation file according to an execution sequence of an object deletion file, at least one source code file, and each source code file in the at least one source code file, and please refer to fig. 2 specifically. As shown in fig. 2, the method includes:
s201, determining an execution sequence of each source code file in at least one source code file based on a data operation type indicated by a file name of the source code file;
in the embodiment of the application, a file name naming specification is preset, and the file name naming specification is used for indicating that the prefix of the file name of the source code file is crt, ilter, ins, upd or del; when the prefix of the file name of the source code file is crt, indicating that the source code file is used for creating a database object (the data operation type indicated by the file name of the source code file is a creation type); when the prefix of the file name of the source code file is ilter, indicating that the source code file is used for modifying the field length of the database object (the data operation type indicated by the file name of the source code file is a first modification type); when the prefix of the file name of the source code file is ins, indicating that the source code file is used for adding data in the database object (the data operation type indicated by the file name of the source code file is an addition type); when the prefix of the file name of the source code file is upd, indicating that the source code file is used for modifying data in the database object (the data operation type indicated by the file name of the source code file is a second modification type); when the prefix of the file name of the source code file is del, the source code file is indicated to be used for deleting data in the database object (the data operation type indicated by the file name of the source code file is a deletion type).
The execution sequence of the source code file with the data operation type indicated by the file name as the creation type is earlier than that of the source code file with the data operation type indicated by the file name as the first modification type; the execution sequence of the source code file with the data operation type indicated by the file name as the first modification type is earlier than that of the source code file with the data operation type indicated by the file name as the addition type; the execution sequence of the source code file with the data operation type indicated by the file name as the increasing type is earlier than that of the source code file with the data operation type indicated by the file name as the second modification type; the execution sequence of the source code file of which the data operation type indicated by the file name is the second modification type is earlier than that of the source code file of which the data operation type indicated by the file name is the deletion type.
The execution sequence between two source code files with the same data operation type indicated by file names is not limited in the present application, for example, two source code files exist, which are respectively a source code file 1 and a source code file 2, and the data operation types indicated by the file names of the source code file 1 and the source code file 2 are the same, in the embodiment of the present application, the execution sequence of the source code file 1 may be set to be earlier than that of the source code file 2, and the execution sequence of the source code file 1 may also be set to be later than that of the source code file 2.
According to the embodiment of the application, the execution sequence of each source code file in at least one source code file can be determined based on the data operation type indicated by the file name of the source code file.
S202, generating an installation file according to the execution sequence of the preset object deletion file relative to the source code files and the execution sequence of each source code file in at least one source code file.
In this embodiment of the present application, the execution sequence of the preset object deletion file with respect to the source code file is that the execution sequence of the object deletion file is earlier than the execution sequence of the source code file. For example, if an object deletion file and at least one source code file are determined in the embodiment of the present application, the at least one source code file includes a source code file 1, a source code file 2, and a source code file 3; the execution sequence of each source code file in the at least one source code file is a source code file 2, a source code file 3 and a source code file 1; based on this, an installation file is generated which instructs to execute the object delete file first, execute the source code file 2, execute the source code file 3 again, and execute the source code file 1 again.
And S104, sending the resource files to the test library server, triggering the test library server to automatically execute an installation process according to the resource files to obtain an automatic installation result of the database object, wherein the resource files comprise a deleted file, an installed file and at least one source code file.
In the embodiment of the present application, the object deletion file is a DROP file, and the installation file is a SHELL installation file. The above is only the preferred expression form of the object deletion file and the installation file provided in the embodiment of the present application, and the inventor can set the expression form of the object deletion file and the installation file according to his own needs, which is not limited herein.
Further, in the method for automatically constructing and deploying the database object provided in the embodiment of the present application, before extracting each database object in at least one source code file to generate an object deletion file, the method further includes: determining each source code file which does not meet preset file name naming specifications in at least one source code file; and acquiring the source code files carrying the same user name identifier from the determined source code files, and sending the file list information of the source code files carrying the same user name identifier to the user indicated by the user name identifier.
In the embodiment of the application, when the file name naming specification is used for indicating that the prefix of the file name of the source code file is crt, ilter, ins, upd or del, the source code file with the file name prefix not being any one of crt, ilter, ins, upd and del is obtained from at least one source code file, and each obtained source code file is determined to be a source code file which does not meet the preset file name naming specification.
The source code file carries a user identifier of a user for providing the source code file for the source code server; if it is determined that 3 source code files do not meet the preset file naming specification from at least one source code file, and the 3 source code files are respectively a source code file 1, a source code file 2 and a source code file 3, if the user identifier carried by the source code file 1 is a user identifier 2, the user identifier carried by the source code file 2 is a user identifier 3, and the user identifier carried by the source code file 3 is a user identifier 2; two pieces of file list information are generated, namely file list information 1 (the file list information 1 indicates a source code file 1 and a source code file 3) and file list information 2 (the file list information 2 indicates a source code file 2); and sends the file list information 1 to the user indicated by the user identification 2 and sends the file list information 2 to the user indicated by the user identification 3.
Correspondingly, the method for automatically constructing and deploying the database object provided by the embodiment of the application can further include: and receiving the modification operation of the user on the file name of the source code file in at least one source code file indicated by the file list information, and modifying the file name of the source code file.
For example, receiving a modification operation of a user indicated by a user identifier 2 on file names of a source code file 1 and a source code file 2 indicated by file list information 1 stored in a source code server, and modifying the file name of the source code file 1 and the file name of the source code file 2 stored in the source code server, so that the file name of the source code file 1 stored in the source code server conforms to a preset file name specification, and the file name of the source code file 2 conforms to the preset file name specification; and receiving the modification operation of the user indicated by the user identifier 3 on the file name of the source code file 2 indicated by the file list information 2 stored in the source code server, and modifying the file name of the source code file 2 stored in the source code server so as to enable the file name of the source code file 2 stored in the source code server to accord with the preset file name specification.
Further, in the method for automatically constructing and deploying a database object provided in an embodiment of the present application, before generating an installation file according to an execution sequence of an object deletion file, at least one source code file, and each source code file in the at least one source code file, the method further includes: and when the encoding format of the source code file in the at least one source code file is not the preset encoding format, converting the encoding format of the source code file into the preset encoding format.
In the embodiment of the application, when the test library server is a UNIX server, the preset encoding format may be UTF-8 (without a BOM header); when the test library server is an AIX server, the predetermined encoding format may be a UNIX linefeed format. The above is only a preferred way of presetting the encoding format provided in the embodiment of the present application, and regarding the specific content of the presetting encoding format, the inventor can set the preset encoding format according to his own needs, which is not limited herein.
Fig. 3 is a flowchart of another method for automatically constructing and deploying a database object according to an embodiment of the present application.
As shown in fig. 3, the method includes:
s301, at least one source code file is obtained from a source code server, and the at least one source code file comprises all source code files which are not tested currently in the source code server;
s302, extracting each database object in at least one source code file to generate an object deletion file, wherein the object deletion file comprises a statement for deleting each database object in a local database;
s303, generating an installation file according to the object deletion file, the at least one source code file and the execution sequence of each source code file in the at least one source code file, wherein the installation file is used for representing the execution sequence between the object deletion file and each source code file;
s304, sending a deleted file, an installed file and at least one source code file to a test library server, triggering the test library file to execute the deleted file and the at least one source code file according to the execution sequence indicated by the installed file, and obtaining an automatic installation result of a database object, wherein the automatic installation result of the database object comprises an installation log used for representing the installation process of the resource file;
s305, analyzing the installation log to obtain installation error information in the installation log;
s306, sending the installation error information to the user indicated by the user name identification carried by the source code file which causes the installation error information.
Further, according to the automatic database object constructing and deploying method provided by the embodiment of the application, after the installation error information in the installation log is obtained, preset error level information corresponding to the installation error information can be obtained, and the obtained error level information is associated with the installation error information; accordingly, when the installation error information is sent to the user indicated by the user name identifier carried in the source code file causing the installation error information, the installation error information associated with the installation error level information can be sent to the user indicated by the user name identifier carried in the source code file causing the installation error information.
Fig. 4 is a schematic structural diagram of an automatic database object constructing and deploying apparatus according to an embodiment of the present application.
As shown in fig. 4, the apparatus includes:
a source code file obtaining unit 41, configured to obtain at least one source code file from a source code server, where the at least one source code file includes each source code file that is not currently tested in the source code server;
a database object extracting unit 42, configured to extract each database object in the at least one source code file to generate an object deletion file, where the object deletion file includes a statement for deleting each database object in the local database;
an installation file generating unit 43, configured to generate an installation file according to the object deletion file, the at least one source code file, and an execution order of each source code file in the at least one source code file, where the installation file is used to represent the execution order between the object deletion file and each source code file;
and the database object automatic deployment unit 44 is configured to send a resource file to the test library server, and trigger the test library server to automatically execute an installation process according to the resource file to obtain an automatic installation result of the database object, where the resource file includes a delete file, an installation file, and at least one source code file.
In this embodiment of the present application, the automatic installation result of the database object includes an installation log used for characterizing an installation process of the resource file, and the automatic database object constructing and deploying apparatus further includes: the installation log analysis unit is used for analyzing the installation log and acquiring installation error information in the installation log; and the installation error information prompting unit is used for sending the installation error information to the user indicated by the user name identifier carried by the source code file which causes the installation error information.
The embodiment of the application provides a method and a device for automatically constructing and deploying a database object, wherein the method comprises the steps of obtaining at least one source code file which is not tested currently from a source code server; extracting each database object in at least one source code file to generate an object deletion file; generating a file for installation according to the deleted file, the at least one source code file and the execution sequence of each source code file in the at least one source code file; the method and the device have the advantages that the resource files are sent to the test library server, the test library server is triggered to automatically execute the installation process according to the resource files, the automatic installation result of the database object is obtained, the resource files comprise the modes of deleting the files, installing the files and at least one source code file, automatic construction and deployment of the database object are achieved, compared with the mode of manually constructing and deploying the database object of the source code file, the method and the device improve the construction and deployment efficiency of the database object and save labor cost.
The above method and apparatus for automatically constructing and deploying a database object provided by the present invention are described in detail, and a specific example is applied in the description to explain the principle and implementation of the present invention, and the description of the above embodiment is only used to help understand the method and core idea of the present invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
It should be noted that, in the present specification, the embodiments are all described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments may be referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
It is further noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include or include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (9)
1. A method for automatically constructing and deploying database objects is characterized by comprising the following steps:
obtaining at least one source code file from a source code server, wherein the at least one source code file comprises each source code file which is not tested currently in the source code server;
extracting each database object in the at least one source code file to generate an object deletion file, wherein the object deletion file comprises a statement for deleting each database object in a local database;
determining an execution sequence of each source code file in the at least one source code file based on a data operation type indicated by a file name of the source code file;
generating an installation file according to the execution sequence of a preset object deletion file relative to the source code files and the execution sequence of each source code file in the at least one source code file, wherein the execution sequence of the preset object deletion file relative to the source code files is that the execution sequence of the object deletion file is earlier than that of the source code files; the installation file is used for representing the execution sequence between the object deletion file and each source code file;
sending a resource file to a test library server, triggering the test library server to automatically execute an installation process according to the resource file, and obtaining an automatic installation result of a database object, wherein the resource file comprises the deleted file, an installation file and at least one source code file.
2. The method of claim 1, wherein before extracting each database object in the at least one source code file generates an object deletion file, the method further comprises:
determining each source code file which does not meet preset file name naming specifications in the at least one source code file;
and acquiring the source code files carrying the same user name identifier from the determined source code files, and sending the file list information of the source code files carrying the same user name identifier to the user indicated by the user name identifier.
3. The method of claim 2, further comprising:
and receiving the modification operation of the user on the file name of the source code file in the at least one source code file indicated by the file list information, and modifying the file name of the source code file.
4. The method of claim 1, wherein the execution order of each of the at least one source code file is determined based on a data operation type indicated by a file name of the source code file; before generating an installation file according to an execution sequence of a preset object deletion file relative to a source code file and an execution sequence of each source code file in the at least one source code file, the method further comprises:
and when the encoding format of the source code file in the at least one source code file is not a preset encoding format, converting the encoding format of the source code file into the preset encoding format.
5. The method of claim 1, wherein sending the resource file to a test library server to trigger the test library server to automatically execute an installation process according to the resource file to obtain an automatic installation result of the database object comprises:
and sending the deleted file, the installed file and at least one source code file to a test library server, triggering the test library file to execute the deleted file and the at least one source code file according to the execution sequence indicated by the installed file, and obtaining an automatic installation result of the database object, wherein the resource file comprises the deleted file, the installed file and the at least one source code file.
6. The method of claim 5, wherein the database object automatic installation results comprise an installation log that characterizes an installation process of the resource file, the method further comprising:
analyzing the installation log to obtain installation error information in the installation log;
and sending the installation error information to a user indicated by a user name identifier carried by a source code file which causes the installation error information.
7. The method of claim 6, further comprising:
acquiring preset error grade information of the installation error information, and associating the error grade information with the installation error information;
the sending the installation error information to the user indicated by the user name identifier carried in the source code file causing the installation error information comprises: and sending the installation error information associated with the error grade information to a user indicated by a user name identifier carried by a source code file causing the installation error information.
8. An automatic database object constructing and deploying device is characterized by comprising:
a source code file obtaining unit, configured to obtain at least one source code file from a source code server, where the at least one source code file includes each source code file that is not currently tested in the source code server;
a database object extracting unit, configured to extract each database object in the at least one source code file to generate an object deletion file, where the object deletion file includes a statement for deleting each database object in a local database;
the installation file generating unit is used for determining the execution sequence of each source code file in the at least one source code file based on the data operation type indicated by the file name of the source code file; generating an installation file according to an execution sequence of a preset object deletion file relative to source code files and an execution sequence of each source code file in the at least one source code file, wherein the execution sequence of the preset object deletion file relative to the source code files is as follows: the execution sequence of the object deletion file is earlier than that of the source code file; the installation file is used for representing the execution sequence between the object deletion file and each source code file;
and the database object automatic deployment unit is used for sending a resource file to a test library server, triggering the test library server to automatically execute an installation process according to the resource file, and obtaining an automatic installation result of the database object, wherein the resource file comprises the deleted file, an installation file and at least one source code file.
9. The apparatus of claim 8, wherein the database object automatic installation result comprises an installation log for characterizing an installation process of the resource file, the apparatus further comprising:
the installation log analyzing unit is used for analyzing the installation log and acquiring installation error information in the installation log;
and the installation error information prompting unit is used for sending the installation error information to a user indicated by a user name identifier carried by a source code file which causes the generation of the installation error information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811365703.9A CN109522295B (en) | 2018-11-16 | 2018-11-16 | Automatic database object constructing and deploying method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811365703.9A CN109522295B (en) | 2018-11-16 | 2018-11-16 | Automatic database object constructing and deploying method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109522295A CN109522295A (en) | 2019-03-26 |
| CN109522295B true CN109522295B (en) | 2021-07-20 |
Family
ID=65778382
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811365703.9A Active CN109522295B (en) | 2018-11-16 | 2018-11-16 | Automatic database object constructing and deploying method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109522295B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489401B (en) * | 2019-08-26 | 2022-12-27 | 浪潮通用软件有限公司 | Method and device for deploying database objects |
| CN111782442B (en) * | 2020-06-23 | 2024-01-12 | 深圳威尔视觉传媒有限公司 | Device exception handling method, system, electronic device and storage medium |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101789886A (en) * | 2009-01-23 | 2010-07-28 | 中兴通讯股份有限公司 | Environment setup automation system of distribution type environment and method |
| CN104717233A (en) * | 2013-12-11 | 2015-06-17 | 中国电信股份有限公司 | Database deployment method and device |
| CN106445485A (en) * | 2016-03-28 | 2017-02-22 | 中国电力科学研究院 | Software version consistency detection system and detection method thereof |
| CN106991104A (en) * | 2016-01-21 | 2017-07-28 | 泰康保险集团股份有限公司 | Database script disposes device and database script dispositions method |
| CN107291437A (en) * | 2016-04-13 | 2017-10-24 | 上海思立微电子科技有限公司 | Issue bag version information production method, device and terminal |
| CN107357593A (en) * | 2017-08-24 | 2017-11-17 | 武汉斗鱼网络科技有限公司 | Source code file construction method, device, electric terminal and readable storage medium storing program for executing |
| CN107515766A (en) * | 2017-08-24 | 2017-12-26 | 北京锐安科技有限公司 | Generation method, deployment installation method and the device of database deployment file |
| CN107844301A (en) * | 2017-12-12 | 2018-03-27 | 苏州蜗牛数字科技股份有限公司 | A kind of Android application channel closes bag method and device |
| CN108090095A (en) * | 2016-11-23 | 2018-05-29 | 北京国双科技有限公司 | The method and apparatus that batch rebuilds database |
-
2018
- 2018-11-16 CN CN201811365703.9A patent/CN109522295B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101789886A (en) * | 2009-01-23 | 2010-07-28 | 中兴通讯股份有限公司 | Environment setup automation system of distribution type environment and method |
| CN104717233A (en) * | 2013-12-11 | 2015-06-17 | 中国电信股份有限公司 | Database deployment method and device |
| CN106991104A (en) * | 2016-01-21 | 2017-07-28 | 泰康保险集团股份有限公司 | Database script disposes device and database script dispositions method |
| CN106445485A (en) * | 2016-03-28 | 2017-02-22 | 中国电力科学研究院 | Software version consistency detection system and detection method thereof |
| CN107291437A (en) * | 2016-04-13 | 2017-10-24 | 上海思立微电子科技有限公司 | Issue bag version information production method, device and terminal |
| CN108090095A (en) * | 2016-11-23 | 2018-05-29 | 北京国双科技有限公司 | The method and apparatus that batch rebuilds database |
| CN107357593A (en) * | 2017-08-24 | 2017-11-17 | 武汉斗鱼网络科技有限公司 | Source code file construction method, device, electric terminal and readable storage medium storing program for executing |
| CN107515766A (en) * | 2017-08-24 | 2017-12-26 | 北京锐安科技有限公司 | Generation method, deployment installation method and the device of database deployment file |
| CN107844301A (en) * | 2017-12-12 | 2018-03-27 | 苏州蜗牛数字科技股份有限公司 | A kind of Android application channel closes bag method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109522295A (en) | 2019-03-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106921731B (en) | Vulnerability repair method and device | |
| CN109542844B (en) | Event log collection method and system, electronic equipment and storage medium | |
| CN111399873A (en) | Model updating method and device | |
| CN109522295B (en) | Automatic database object constructing and deploying method and device | |
| CN112241360B (en) | Test case generation method, device, equipment and storage medium | |
| CN108958753B (en) | Code packaging deployment method and device | |
| CN104572085A (en) | Method and device for analyzing application program | |
| CN110908670A (en) | Method and device for automatically publishing service | |
| CN108804315B (en) | Test method and device applied to dynamic development, electronic equipment and storage medium | |
| CN106776266B (en) | Configuration method of test tool and terminal equipment | |
| CN113448854A (en) | Regression testing method and device | |
| CN110928780B (en) | Code quality control method, device, computer equipment and storage medium | |
| CN104090948A (en) | Method, device and system for processing mass data of nuclear power station | |
| CN108255700B (en) | Test result generation method and device | |
| CN113918209B (en) | Method and device for generating upgrade list and readable storage medium | |
| CN108197090B (en) | Method and system for processing default value in file format conversion process | |
| CN105094787B (en) | Method and device for processing enterprise internet application | |
| CN111443920B (en) | Frame migration method and device | |
| CN109508203B (en) | Method, device and system for determining version consistency | |
| CN110244968B (en) | Charging station management system and method | |
| CN106547700B (en) | Program debugging method and device | |
| CN112685102B (en) | Gateway plug-in hot loading method, device, equipment and medium | |
| CN110489108B (en) | Method and device for automatically collecting reusable components | |
| CN111522748B (en) | Automatic test case generation method, device, server and storage medium | |
| CN110727601B (en) | Multi-platform program testing method and related device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |