A method and device for generating database structure difference report

Abstract

The present invention provides a method and device for generating a database structure difference report, the method comprising: determining the connectivity of a first database and a second database; generating a database structure difference report of the first database and the second database according to the connectivity of the first database and the second database and a preset comparison strategy. The solution of the present invention solves the problem that two environment databases cannot be connected at the same time, which is convenient for the project team to troubleshoot problems and perform design archiving at the same time.

Description

Technical Field

[0001] The present invention relates to the technical field of database processing, and in particular to a method and device for generating a database structure difference report. Background Art

[0002] Database difference comparison tools are currently generally based on database clients, that is, they are generally window-based graphical operation tools (such as Navicat), which have many defects:

[0003] Graphical operations require many steps. Generally, you need to manually select the database and then the table. You cannot directly compare the entire database, nor can you configure the table to fill in the expression matching mode.

[0004] The operation process is rather cumbersome, and graphical operations are required each time. It is not possible to generate a report by clicking an executable file.

[0005] The most critical problem is that different databases and different environments are isolated by network, which makes it impossible to make effective comparisons. If different database environments (especially production environments) are accessed at the same time, security issues arise. Summary of the invention

[0006] The technical problem to be solved by the present invention is to provide a method and device for generating a database structure difference report, which solves the problem that two environmental databases cannot be connected at the same time in real business scenarios, facilitates the project team to troubleshoot problems and archive designs at the same time.

[0007] In order to solve the above technical problems, the technical solution of the present invention is as follows:

[0008] A method for generating a database structure difference report, comprising:

[0009] Determining connectivity between the first database and the second database;

[0010] A database structure difference report of the first database and the second database is generated according to the connectivity between the first database and the second database and a preset comparison strategy.

[0011] Optionally, determining connectivity between the first database and the second database includes:

[0012] Acquire first connection information configured for the first database and second connection information configured for the second database;

[0013] The connectivity of the first database is tested according to the first connection information, and the connectivity of the second database is tested according to the second connection information.

[0014] Optionally, generating a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy includes:

[0015] If the first database is connected and the second database is not connected, generating a first database structure file of the first database;

[0016] The first database structure file is compared with a pre-generated second database structure file of a second database to generate a database structure difference report between the first database and the second database.

[0017] Optionally, generating a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy includes:

[0018] If the first database is connected and the second database is connected, a first database structure file of the first database and a second database structure file of the second database are generated;

[0019] The first database structure file is compared with the second database structure file to generate a database structure difference report between the first database and the second database.

[0020] Optionally, generating a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy includes:

[0021] If the first database is not connected and the second database is not connected, obtaining a pre-generated first database structure file of the first database and a pre-generated second database structure file of the second database;

[0022] The first database structure file is compared with the second database structure file to generate a database structure difference report between the first database and the second database.

[0023] Optionally, the method for generating a database structure difference report further includes:

[0024] If the first database is converted from a disconnected state to a connected state, a new first database structure file of the first database is generated, and the new first database structure file of the first database is used to overwrite the original first database structure file.

[0025] Optionally, the database structure difference report includes at least one of the following:

[0026] The database table, the name of the object in the database table, information on whether the corresponding object exists in the first database, information on whether the corresponding object exists in the second database, and field difference information corresponding to the object.

[0027] Optionally, the first database is at least one of the following: dev, test, uat, prod;

[0028] The second database is at least one of the following: dev, test, uat, and prod.

[0029] Optionally, the first database structure file is a file of .schema file structure;

[0030] The first database structure file is a file with a .schema file structure.

[0031] An embodiment of the present invention further provides a database structure difference report generating device, characterized in that it includes:

[0032] A determination module, used to determine the connectivity between the first database and the second database;

[0033] A generating module is used to generate a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy.

[0034] The above solution of the present invention includes at least the following beneficial effects:

[0035] The above solution of the present invention determines the connectivity between the first database and the second database; generates a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy. This solves the problem that two environment databases cannot be connected at the same time in real business scenarios, making it easier for the project team to troubleshoot problems and archive designs at the same time. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 It is a schematic diagram of the flow of the method for generating a database structure difference report of the present invention;

[0037] Figure 2 It is a schematic diagram of the processing flow of the database structure difference report generation method of the present invention when the two database environments are UAT and PROD respectively;

[0038] Figure 3 It is a schematic diagram of the module structure of the database structure difference report generating device according to an embodiment of the present invention. DETAILED DESCRIPTION

[0039] The exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although the exemplary embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided to enable a more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0040] like Figure 1 As shown, an embodiment of the present invention provides a method for generating a database structure difference report, which is characterized by comprising:

[0041] Step 11, determining connectivity between the first database and the second database;

[0042] Step 12: Generate a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy.

[0043] This embodiment can generate a corresponding database structure difference report based on the connectivity of the database and the preset comparison strategy, and further use the structure file to perform difference comparison, which solves the problem that two environment databases cannot be connected at the same time in real business scenarios, making it easier for the project team to troubleshoot problems and archive designs at the same time.

[0044] In an optional embodiment of the present invention, step 11 may include:

[0045] First connection information configured for a first database and second connection information configured for a second database are obtained; connectivity of the first database is tested according to the first connection information and connectivity of the second database is tested according to the second connection information.

[0046] Here, the first database is at least one of the following: dev, test, uat, prod; the second database is at least one of the following: dev, test, uat, prod.

[0047] In an optional embodiment of the present invention, for the database structure difference report in step 12, optionally, the database structure difference report includes at least one of the following:

[0048] The database table, the name of the object in the database table, information on whether the corresponding object exists in the first database, information on whether the corresponding object exists in the second database, and field difference information corresponding to the object.

[0049] In an optional embodiment of the present invention, the database structure difference report is shown in Table 1:

[0050]

[0051]

[0052] Table 1

[0053] Here, the types of the first database structure file and the second database structure file are, optionally, that the first database structure file is a file of .schema file structure; the first database structure file is a file of .schema file structure.

[0054] In an optional embodiment of the present invention, Figure 2 As shown in the figure, the two database environments are UAT (User Acceptance Test) and PROD (Production). The database structure difference report is generated through the following process:

[0055] Configure the connection information of the two databases and set the comparison mode to offline or online. In offline mode, all schema files are generated first.

[0056] When performing execution comparison, the following situations may occur, including:

[0057] Case 1: If the first database is connected and the second database is not connected, a first database structure file of the first database is generated; the first database structure file is compared with a pre-generated second database structure file of the second database, and a database structure difference report of the first database and the second database is generated;

[0058] Here, in an optional embodiment of the present invention,

[0059] Assume that the database environment of the first database is UAT and the database environment of the second database is PROD. The databases in the UAT environment are connected, but the databases in the PROD environment are not connected. Generate a database structure file in the UAT environment, compare the database structure file in the UAT environment with the pre-generated database structure file in the PROD environment, and generate a database structure difference report between the database in the UAT environment and the database in the PROD environment.

[0060] Assume that the database environment of the first database is PROD and the database environment of the second database is UAT. The databases in the PROD environment are connected, but the databases in the UAT environment are not connected. Generate a database structure file in the PROD environment, compare the database structure file in the PROD environment with the pre-generated database structure file in the UAT environment, and generate a database structure difference report between the database in the PROD environment and the database in the UAT environment.

[0061] Case 2: A comparison strategy is used to generate a database structure difference report between the first database and the second database, including: if the first database is connected and the second database is connected, generating a first database structure file for the first database and generating a second database structure file for the second database; comparing the first database structure file with the second database structure file to generate a database structure difference report between the first database and the second database;

[0062] Here, in an optional embodiment of the present invention, the database environment of the first database is UAT, and the database environment of the second database is PROD. The databases are connected under the UAT environment, and the databases are connected under the PROD environment, and a database structure file under the UAT environment is generated for the database under the UAT environment, and a database structure file under the PROD environment is generated for the database under the PROD environment; the database structure file under the UAT environment is compared with the database structure file under the PROD environment, and a database structure difference report between the database under the UAT environment and the database under the PROD environment is generated;

[0063] When the database environment of the first database is PROD and the database environment of the second database is UAT, the method is the same as above.

[0064] Case 3: If the first database is not connected and the second database is not connected, obtain a pre-generated first database structure file of the first database and a pre-generated second database structure file of the second database; compare the first database structure file with the second database structure file to generate a database structure difference report between the first database and the second database;

[0065] Here, in an optional embodiment of the present invention, the database environment of the first database is UAT, and the database environment of the second database is PROD. The databases are not connected in the UAT environment, and the databases are not connected in the PROD environment. The database structure file of the UAT environment of the pre-generated database and the database structure file of the PROD environment of the pre-generated database in the PROD environment are obtained; the database structure file of the UAT environment is compared with the database structure file of the PROD environment, and a database structure difference report of the database in the UAT environment and the database in the PROD environment is generated;

[0066] When the database environment of the first database is PROD and the database environment of the second database is UAT, the method is the same as above.

[0067] In an optional embodiment of the present invention, the method for generating a database structure difference report may further include:

[0068] If the first database is converted from a disconnected state to a connected state, a new first database structure file of the first database is generated, and the new first database structure file of the first database is used to overwrite the original first database structure file.

[0069] The above-mentioned embodiments of the present invention support online and offline modes of the database, and the core is to support offline mode, which is not available in such tools at present. In addition, the embodiments of the present invention will automatically detect the connection status of the database. Once the connection is possible, the structure file will be regenerated and the local file will be overwritten to keep the structure file up to date. When it is detected that the database connection is not available, it will first detect whether the structure file already exists locally and use the structure file for comparison. Therefore, the database structure comparison in the scenario where two databases are connected at the same time can be realized.

[0070] like Figure 3 As shown, the embodiment of the present invention further provides a database structure difference report generating device 30, which is applied to a network device, and the device 30 includes:

[0071] A determination module 31, used to determine connectivity between the first database and the second database;

[0072] The generating module 32 is used to generate a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy.

[0073] Optionally, determining connectivity between the first database and the second database includes:

[0074] Acquire first connection information configured for the first database and second connection information configured for the second database;

[0075] The connectivity of the first database is tested according to the first connection information, and the connectivity of the second database is tested according to the second connection information.

[0076] Optionally, generating a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy includes:

[0077] If the first database is connected and the second database is not connected, generating a first database structure file of the first database;

[0078] The first database structure file is compared with a pre-generated second database structure file of a second database to generate a database structure difference report between the first database and the second database.

[0079] Optionally, generating a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy includes:

[0080] If the first database is connected and the second database is connected, a first database structure file of the first database and a second database structure file of the second database are generated;

[0081] The first database structure file is compared with the second database structure file to generate a database structure difference report between the first database and the second database.

[0082] Optionally, generating a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy includes:

[0083] If the first database is not connected and the second database is not connected, obtaining a pre-generated first database structure file of the first database and a pre-generated second database structure file of the second database;

[0084] The first database structure file is compared with the second database structure file to generate a database structure difference report between the first database and the second database.

[0085] Optionally, generating a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy further includes:

[0086] If the first database is converted from a disconnected state to a connected state, a new first database structure file of the first database is generated, and the new first database structure file of the first database is used to overwrite the original first database structure file.

[0087] Optionally, the database structure difference report includes at least one of the following: a database table, the name of an object in the database table, information on whether the corresponding object exists in the first database, information on whether the corresponding object exists in the second database, and field difference information corresponding to the object.

[0088] Optionally, the first database is at least one of the following: dev, test, uat, prod; the second database is at least one of the following: dev, test, uat, prod.

[0089] Optionally, the first database structure file is a file with a .schema file structure; the first database structure file is a file with a .schema file structure.

[0090] It should be noted that the device is a device corresponding to the above method embodiment, and all implementations in the above embodiment are applicable to the embodiment of the device and can achieve the same technical effect. The device can also further include a generating module 32 for processing the information provided by the two databases of the determining module 31.

[0091] The embodiment of the present invention further provides a processor-readable storage medium, wherein the processor-readable storage medium stores processor-executable instructions, wherein the processor-executable instructions are used to cause the processor to execute the method described above. All implementations in the above method embodiment are applicable to this embodiment and can achieve the same technical effect.

[0092] Those skilled in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0093] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0094] In the embodiments provided by the present invention, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0095] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0096] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0097] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard disks, ROM, RAM, magnetic disks, or optical disks.

[0098] In addition, it should be noted that in the apparatus and method of the present invention, it is obvious that each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present invention. Moreover, the steps of performing the above-mentioned series of processing can naturally be performed in chronological order according to the order of description, but it is not necessary to perform them in chronological order, and some steps can be performed in parallel or independently of each other. For those of ordinary skill in the art, it is understood that all or any steps or components of the method and apparatus of the present invention can be implemented in any computing device (including processors, storage media, etc.) or a network of computing devices in hardware, firmware, software or a combination thereof, which can be achieved by those of ordinary skill in the art using their basic programming skills after reading the description of the present invention.

[0099] Therefore, the purpose of the present invention can also be achieved by running a program or a group of programs on any computing device. The computing device can be a well-known general device. Therefore, the purpose of the present invention can also be achieved by simply providing a program product containing a program code that implements the method or device. That is to say, such a program product also constitutes the present invention, and the storage medium storing such a program product also constitutes the present invention. Obviously, the storage medium can be any well-known storage medium or any storage medium developed in the future. It should also be pointed out that in the device and method of the present invention, it is obvious that each component or each step can be decomposed and / or recombined. These decompositions and / or recombinations should be regarded as equivalent schemes of the present invention. In addition, the steps of performing the above-mentioned series of processing can naturally be performed in chronological order according to the order of description, but it is not necessary to perform them in chronological order. Some steps can be performed in parallel or independently of each other.

[0100] The above is a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A method for generating a database structure difference report, characterized in that: include: Determining connectivity between the first database and the second database; Generate a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy; Wherein, determining the connectivity between the first database and the second database includes: Acquire first connection information configured for the first database and second connection information configured for the second database; Testing the connectivity of the first database according to the first connection information and testing the connectivity of the second database according to the second connection information; According to the connectivity between the first database and the second database and a preset comparison strategy, a database structure difference report between the first database and the second database is generated, including: If the first database is connected and the second database is not connected, a first database structure file of the first database is generated; the first database structure file is compared with the pre-generated second database structure file of the second database, and a database structure difference report of the first database and the second database is generated; specifically, the database environment of the first database is user acceptance test UAT, the database environment of the second database is production PROD, the databases in the UAT environment are connected, and the databases in the PROD environment are not connected, a database structure file in the UAT environment is generated, and the database structure file in the UAT environment is compared with the pre-generated database structure file in the PROD environment of the database in the PROD environment, and a database structure difference report of the database in the UAT environment and the database in the PROD environment is generated; or, the database environment of the first database is production PROD, the database environment of the second database is user acceptance test UAT, the databases in the PROD environment are connected, and the databases in the UAT environment are not connected, a database structure file in the PROD environment is generated, and the database structure file in the PROD environment is compared with the pre-generated database structure file in the UAT environment of the database in the UAT environment, and a database structure difference report of the database in the PROD environment and the database in the UAT environment is generated; If the first database is connected and the second database is connected, a first database structure file of the first database and a second database structure file of the second database are generated; the first database structure file is compared with the second database structure file to generate a database structure difference report of the first database and the second database; specifically, assuming that the database environment of the first database is UAT and the database environment of the second database is PROD, the databases are connected under the UAT environment and the databases are connected under the PROD environment, a database structure file under the UAT environment of the database under the UAT environment is generated, and a database structure file under the PROD environment of the database under the PROD environment is generated; the database structure file under the UAT environment is compared with the database structure file under the PROD environment to generate a database structure difference report of the database under the UAT environment and the database under the PROD environment; or, in the case where the database environment of the first database is PROD and the database environment of the second database is UAT, the method is the same as the case where the databases are connected under the UAT environment and the databases are connected under the PROD environment; If the first database is not connected and the second database is not connected, obtain a pre-generated first database structure file of the first database and a pre-generated second database structure file of the second database; compare the first database structure file with the second database structure file to generate a database structure difference report of the first database and the second database; specifically, assuming that the database environment of the first database is UAT and the database environment of the second database is PROD, the databases are not connected under the UAT environment and the databases are not connected under the PROD environment, obtain a pre-generated database structure file under the UAT environment of the database under the UAT environment and a pre-generated database structure file under the PROD environment of the database under the PROD environment; compare the database structure file under the UAT environment with the database structure file under the PROD environment to generate a database structure difference report of the database under the UAT environment and the database under the PROD environment; or, in the case where the database environment of the first database is PROD and the database environment of the second database is UAT, the method is the same as the case where the databases are not connected under the UAT environment and the databases are not connected under the PROD environment; If the first database is converted from a disconnected state to a connected state, a new first database structure file of the first database is generated, and the new first database structure file of the first database is used to overwrite the original first database structure file; The first database structure file is a file of .schema file structure; The second database structure file is a file with a .schema file structure.

2. The method for generating a database structure difference report according to claim 1, characterized in that: The database structure difference report includes at least one of the following: The database table, the name of the object in the database table, information on whether the corresponding object exists in the first database, information on whether the corresponding object exists in the second database, and field difference information corresponding to the object.

3. The method for generating a database structure difference report according to claim 1, characterized in that: The first database is at least one of the following: dev, test, uat, prod; The second database is at least one of the following: dev, test, uat, and prod.

4. A database structure difference report generation device, characterized in that: include: A determination module, used to determine the connectivity between the first database and the second database; A generating module, configured to generate a database structure difference report between the first database and the second database according to the connectivity between the first database and the second database and a preset comparison strategy; Wherein, determining the connectivity between the first database and the second database includes: Acquire first connection information configured for the first database and second connection information configured for the second database; Testing the connectivity of the first database according to the first connection information and testing the connectivity of the second database according to the second connection information; According to the connectivity between the first database and the second database and a preset comparison strategy, a database structure difference report between the first database and the second database is generated, including: If the first database is connected and the second database is not connected, a first database structure file of the first database is generated; the first database structure file is compared with the pre-generated second database structure file of the second database, and a database structure difference report of the first database and the second database is generated; specifically, the database environment of the first database is user acceptance test UAT, the database environment of the second database is production PROD, the databases in the UAT environment are connected, and the databases in the PROD environment are not connected, a database structure file in the UAT environment is generated, and the database structure file in the UAT environment is compared with the pre-generated database structure file in the PROD environment of the database in the PROD environment, and a database structure difference report of the database in the UAT environment and the database in the PROD environment is generated; or, the database environment of the first database is production PROD, the database environment of the second database is user acceptance test UAT, the databases in the PROD environment are connected, and the databases in the UAT environment are not connected, a database structure file in the PROD environment is generated, and the database structure file in the PROD environment is compared with the pre-generated database structure file in the UAT environment of the database in the UAT environment, and a database structure difference report of the database in the PROD environment and the database in the UAT environment is generated; If the first database is connected and the second database is connected, a first database structure file of the first database and a second database structure file of the second database are generated; the first database structure file is compared with the second database structure file to generate a database structure difference report of the first database and the second database; specifically, assuming that the database environment of the first database is UAT and the database environment of the second database is PROD, the databases are connected under the UAT environment and the databases are connected under the PROD environment, a database structure file under the UAT environment of the database under the UAT environment is generated, and a database structure file under the PROD environment of the database under the PROD environment is generated; the database structure file under the UAT environment is compared with the database structure file under the PROD environment to generate a database structure difference report of the database under the UAT environment and the database under the PROD environment; or, in the case where the database environment of the first database is PROD and the database environment of the second database is UAT, the method is the same as the case where the databases are connected under the UAT environment and the databases are connected under the PROD environment; If the first database is not connected and the second database is not connected, obtain a pre-generated first database structure file of the first database and a pre-generated second database structure file of the second database; compare the first database structure file with the second database structure file to generate a database structure difference report of the first database and the second database; specifically, assuming that the database environment of the first database is UAT and the database environment of the second database is PROD, the databases are not connected under the UAT environment and the databases are not connected under the PROD environment, obtain a pre-generated database structure file under the UAT environment of the database under the UAT environment and a pre-generated database structure file under the PROD environment of the database under the PROD environment; compare the database structure file under the UAT environment with the database structure file under the PROD environment to generate a database structure difference report of the database under the UAT environment and the database under the PROD environment; or, in the case where the database environment of the first database is PROD and the database environment of the second database is UAT, the method is the same as the case where the databases are not connected under the UAT environment and the databases are not connected under the PROD environment; If the first database is converted from a disconnected state to a connected state, a new first database structure file of the first database is generated, and the new first database structure file of the first database is used to overwrite the original first database structure file; The first database structure file is a file of .schema file structure; The second database structure file is a file with a .schema file structure.

Images