WO2019029155A1

WO2019029155A1 - Data comparison method and device, computer device and storage medium

Info

Publication number: WO2019029155A1
Application number: PCT/CN2018/077482
Authority: WO
Inventors: 陈志辉; 褚红丹
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-08-08
Filing date: 2018-02-28
Publication date: 2019-02-14
Also published as: CN107688618A; CN107688618B

Abstract

The present application relates to a data comparison method, comprising: acquiring a first database name and a first file name, and grabbing a first file from a first database according to the first database name and the first file name; acquiring a second database name and a second file name, and grabbing a second file from a second database according to the second database name and the second file name; acquiring configuration information comprising a field name to be compared in the first file and a field name to be compared in the second file; and comparing data in the first file and the second file according to the field name to be compared in the first file and the field name to be compared in the second file, and outputting a comparison result.

Description

Data comparison method, device, computer device and storage medium

This application claims the priority of the Chinese Patent Application filed on August 8, 2017, the Chinese Patent Application No. 2017106705122, entitled "Data Comparison Method, Apparatus, Computer Equipment, and Storage Medium", the entire contents of which are incorporated by reference. In this application.

Technical field

The present application relates to the field of computer technology, and in particular, to a data comparison method, apparatus, computer device, and storage medium.

Background technique

In the database development process, it is usually necessary to compare the data in the database. For example, through data comparison to verify whether the contents of the data table have changed after the database script is handed over, or whether the two databases are synchronized into consistent content after the database version is synchronized.

In traditional data comparison methods, data comparison tools such as Compare Beyond (a file comparison tool) can be used to compare large amounts of data. However, these data comparison tools have limited data sources, and can only compare the data in Excel (an office software) table, but can not directly grab data in the database for comparison. Therefore, how to directly compare the data in different databases becomes a technical problem that needs to be solved.

Summary of the invention

In accordance with various embodiments disclosed herein, a data comparison method, apparatus, computer device, and storage medium are provided.

A data comparison method that includes:

Obtaining a first database name and a first file name, and fetching the first file in the first database according to the first database name and the first file name;

Obtaining a second database name and a second file name, and fetching the second file in the second database according to the second database name and the second file name;

Obtaining configuration information, where the configuration information includes a field name to be compared in the first file and a field name to be compared in the second file; and

And comparing the data in the first file and the second file according to the field name to be compared in the first file and the field name to be compared in the second file, and outputting the comparison result.

A data comparison device comprising:

a file capture module, configured to acquire a first database name and a first file name, and fetch the first file in the first database according to the first database name and the first file name; obtain the second database name and the second file name, according to The second database name and the second file name fetch the second file in the second database; and

a comparison module, configured to obtain configuration information, where the configuration information includes a field name to be compared in the first file and a field name to be compared in the second file; according to the field name to be compared in the first file, and the second The field names to be compared in the file compare the data in the first file and the second file, and output a comparison result.

A computer device comprising a memory and one or more processors having stored therein computer readable instructions, the computer readable instructions being executable by the processor to cause the one or more processors to execute The following steps:

One or more computer readable non-volatile storage media storing computer readable instructions, when executed by one or more processors, cause one or more processors to perform the steps of:

Details of one or more embodiments of the present application are set forth in the accompanying drawings and description below. Other features, objects, and advantages of the invention will be apparent from the description and appended claims.

DRAWINGS

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the prior art description will be briefly described below. Obviously, the drawings in the following description are only It is a certain embodiment of the present application, and other drawings can be obtained according to the drawings without any creative work for those skilled in the art.

1 is a flow chart of a data comparison method in an embodiment;

2 is a schematic diagram of a comparison page in one embodiment;

3 is a schematic structural diagram of a data comparison device in an embodiment;

4 is a schematic structural diagram of a computer device in an embodiment;

FIG. 5 is a diagram of an application scenario in an embodiment.

Detailed ways

In order to make the objects, technical solutions, and advantages of the present application more comprehensible, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting.

It will be understood that the terms "first", "second" and the like, as used herein, may be used to describe various elements, but these elements are not limited by these terms. These terms are only used to distinguish one element from another. For example, a first client may be referred to as a second client, and similarly, a second client may be referred to as a first client, without departing from the scope of the present application. Both the first client and the second client are clients, but they are not the same client.

In an embodiment, as shown in FIG. 1 , a data comparison method is provided. The method is applied to the terminal as an example for description, and specifically includes the following steps:

Step 102: Acquire a first database name and a first file name, and fetch the first file in the first database according to the first database name and the first file name.

Step 104: Obtain a second database name and a second file name, and fetch the second file in the second database according to the second database name and the second file name.

Step 106: Acquire configuration information, where the configuration information includes a field name to be compared in the first file and a field name to be compared in the second file.

Step 108: Compare the data in the first file and the second file according to the field name to be compared in the first file and the field name to be compared in the second file, and output a comparison result.

A data comparison application is running on the terminal. The application can compare files in different databases. The database includes Sql Server database, Oracle database and MySql database. Multiple files are included in the database. Different databases can be deployed on different servers. The file can be a data table, a package (a file in an Oracle database), or a text.

The terminal can display the configuration page through the application. The user can enter configuration information in the configuration page through the terminal. The configuration information includes basic information of the file to be compared, including the file name to be compared, the name of the field to be compared, and the like. The files to be compared may be files from different databases or files from the same database. For the sake of brevity, the two files to be compared may be referred to as a first file and a second file, respectively. The database corresponding to the first file is referred to as a first database, and the database corresponding to the second file is referred to as a second database. The configuration information may include all field names of the first file and the second file, and may also include partial field names. The server may include a first server and a second server. The first database is deployed on the first server, and the second database is deployed on the second server.

The terminal can display the comparison page through the application. Different files can be compared in the comparison page. The comparison page is shown in Figure 2. The user can input the first database name, the first database connection string, the first file name, the second database name, the second database connection string, the second file name, and the like in the comparison page by using the terminal. The first database name and the second database name may be the same. If the first database name and the second database name are different, the first file name and the second file name may be the same. The user clicks the "View Data" control after the first file name on the comparison page, and the application responds to the control, and the first file is captured in the first database according to the first database connection string. Taking the first database as an Oracle database, the application can use Ado.Net (a set of object-oriented libraries for interacting with the data source), call the database connection object to connect to the Oracle database, and use Ado (ActiveX Data Control). Objects, including: Oracle Command (database command object), Oracle Data Adapter (data adapter object) and Oracle Data Reader (a data object, only allow read-only, forward-looking view of the data stored in it), etc. The first file in the first database is crawled. After the user clicks the "View Data" control after the second file name on the comparison page, the application responds to the control, and the second file is captured in the second database according to the second database connection string.

After the terminal captures the first file and the second file through the application, the data of the first file and the data of the second file are respectively read, and the read data is added to the comparison page for display. The user clicks the "Start" control on the comparison page, and the application responds to the control, and invokes the configuration information. According to the field name to be compared in the first file in the configuration information and the field name to be compared in the second file, the page will be compared. The data of the first file displayed is compared with the data of the second file. If the field name to be compared in the first file in the configuration file and the field name to be compared in the second file are all field names, the terminal compares all the data in the first file and the second file by using the application. For example, the first field in the first file is compared with the first field in the second file from the first line, the second field in the first file and the second field in the second file are from the first line. Compare line by line, and so on, until all fields are compared.

If the field name to be compared in the first file in the configuration file and the field name to be compared in the second file are partial field names, the terminal compares the data to be compared in the first file and the second file by using the application program. . For example, the first field in the first file and the second field in the second file are compared line by line from the first line, and the second field in the first file and the third field in the second file start from the first line. Compare line by line until all generations of comparison fields are compared. After the comparison is completed, the comparison result is output. The comparison results can include all data, or only inconsistent data. In order to facilitate the user to understand the comparison result, the comparison result may only display the inconsistent data in the first file and the second file.

Further, all or part of the data migrated from the first file may be included in the second file. Or the first file includes all or part of the data migrated from the second file. When comparing two files in which data migration occurs, the field names to be compared in the configuration information may be the field name before migration and the field name after migration. The field name before migration and the field name after migration can be the same or different. Migration rules are also included in the configuration information. According to the migration rule, the field name before migration and the corresponding migrated field name, and the field value before migration and the corresponding migrated field value can be found. When a large amount of data is migrated from one file to another, comparing the data before and after the migration in the above manner can quickly and effectively know whether the data migration is accurate or not.

Further, if the data of the first file and the data of the second file are both more, the terminal may perform batch reading or page reading on the first file and the second file, respectively. Add the read data to the comparison page for comparison. Further, in the comparison process, the progress bar can also be displayed in the comparison page, thereby displaying the progress of the data comparison, thereby facilitating the user to know the progress of the data comparison in time.

In this embodiment, the first file may be captured in the first database by using the first database name and the first file name, and the second file may be captured in the second database by using the second database name and the second file. The data in the first file and the second file are compared according to the field name to be compared in the first file in the configuration information and the field name to be compared in the second file, thereby outputting the comparison result. Since the first file and the second file can be directly captured from the unused database, the data of the first file and the second file can be effectively compared according to the configuration information. This makes it possible to directly compare data in different databases.

It should be understood that although the various steps in the flowchart of FIG. 1 are sequentially displayed as indicated by the arrows, these steps are not necessarily performed in the order indicated by the arrows. Except as explicitly stated herein, the execution of these steps is not strictly limited, and may be performed in other sequences. Moreover, at least some of the steps in FIG. 1 may include a plurality of sub-steps or stages, which are not necessarily performed at the same time, but may be executed at different times, and the order of execution thereof is not necessarily This may be performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of the other steps.

In an embodiment, the method further includes: if there is no configuration information, obtaining a field name to be compared in the first file and a field name to be compared in the second file; respectively, in the first file according to the field name to be compared Querying the first field to be compared and querying the second field to be compared in the second file; and arranging the first field and the second field in a first preset order; performing the first field and the second field after the arrangement Contrast, output comparison results.

If the user is not configured in the configuration page, you can also enter a query statement or import a query file by comparing the pages. The query statement or the query file may include a file name to be compared and a field name to be compared. If only the file name to be compared is included, it means that all fields of the file to be compared need to be compared. If both the file name to be compared and the field name to be compared are included, it means that some fields of the file to be compared need to be compared.

Specifically, the user can use the terminal to input a query statement or a query file corresponding to the first file and a query statement or a query file corresponding to the second file in the comparison page. The terminal obtains the field name to be compared in the first file and the field name to be compared in the second file according to the query statement or the query file, and queries the first field to be compared in the first file according to the field name to be compared. And querying the second field to be compared with the second file. The first field to be compared includes the field name to be compared and the corresponding field value, which may be a field to be compared, or may be a plurality of fields to be compared.

The application arranges the first field and the second field that are queried according to the first preset order, so as to ensure that the query result of the first file is consistent with the query result of the second file, thereby ensuring the accuracy of the data comparison. The terminal compares the arranged first field and the second field through the application, and outputs the comparison result.

In this embodiment, if the configuration information is not input in the configuration page, the field name to be compared in the comparison file may be queried by inputting a query statement or importing a query file to obtain data to be compared. This makes the data comparison method more flexible, and it is convenient for users to choose a comparison method that is more in line with their own usage habits.

In an embodiment, the method further includes: obtaining a table structure corresponding to the first file and a table structure corresponding to the second file; comparing the table structure corresponding to the first file with the table structure corresponding to the second file; outputting the first The file is inconsistent with the second file.

In this embodiment, the first file may be a data table, and the second file may also be a data table. The table structure of the first file includes a plurality of fields, and the table structure of the second file also includes a plurality of fields. When the first file and the second file are compared according to the configuration information or the query statement, the table structures of the first file and the second file may be separately compared.

Specifically, the comparison page may also include a control "query table structure". The user can click the control "query table structure" in the comparison page through the terminal, and the application responds to the control to separately query the table structure corresponding to the first file and the table structure corresponding to the second file. The terminal compares the table structure of the first comparison file and the table structure of the second file through the application, and outputs a field inconsistent between the first file and the second file.

By comparing the fields and table structures of the first file and the second file respectively, it is helpful for the user to fully understand the difference between the two data tables of the same file name in different databases. Thus, after the database version is synchronized, it is convenient for the user to know whether the table structure between different databases is synchronized to a consistent content.

In an embodiment, the first file includes a plurality of packages, and the second file includes a plurality of packages. The method further includes: if the configuration information includes the package name to be compared and the corresponding owner, according to the package name to be compared and the corresponding genus The master obtains two packets to be compared in the first database and the second database respectively, and compares the two packets to be compared; if the configuration information does not include the package name to be compared and the corresponding owner, the first database is Multiple packages in the package and/or multiple packages in the second database are compared separately.

In this embodiment, the first database and the second database may both be Oracle databases. An Oracle database can include multiple packages. The package can be used to classify functions or stored procedures. The package has a header and a body. A function and a stored procedure are defined in the header, and the body is used to implement the functions and stored procedures defined in the header.

Each package has a corresponding package name and owner. The first file may include a plurality of packages, and the second file may also include a plurality of packages. If the package name to be compared and the corresponding owner are entered in the configuration information, the terminal can obtain the corresponding two packages to be compared through the application, and compare the two packages. This gives the content difference between the two specified packages. Therefore, after the database script is handed over, it is convenient to verify whether the package has changed.

If the to-be-compared package name and the corresponding owner are not included in the configuration information, the terminal may acquire, by the application, multiple packets in the first database, and multiple packages in the second database, and multiple packets in the first database. Compare with multiple packages in the second database. Wherein, multiple packages in the first database can be compared, and multiple packages in the second database can be compared, and multiple packages in the first database and multiple packages in the second database are further Can be compared. Therefore, after the database script is handed over, it is convenient to know whether the package changes between different owners. It is also possible to facilitate the user to know whether the packets between different databases are synchronized to the same content after the database version is synchronized.

In an embodiment, the first file includes the interface parameter of the current version, and the second file includes the interface parameter of the previous version, the method further includes: converting the interface parameter of the current version to the first interface parameter of the Json format; The plurality of parameter data of the interface parameter are sorted according to the second preset order; the interface parameter of the previous version is converted into the second interface parameter of the Json format; and the plurality of parameter data of the second interface parameter are sorted according to the second preset order; The sorted first interface parameter is compared with the second interface parameter, and the parameter data in which the current version is inconsistent with the previous version is output.

In this embodiment, the first file may record the interface parameters of the current version of the database. The second file can record the interface parameters of a version on the database. Multiple interface data is included in the interface parameters. The interface data can be recorded in the form of a data table or in the form of text. Due to the poor readability of interface parameters, it is not convenient to compare directly through the application.

In order to know which parameter data has been modified between the current version of the database and the previous version, the terminal can convert the interface parameters through the application. Specifically, the terminal obtains the interface parameter of the current version in the first file by using the application, and converts the interface parameter of the current version into the first interface parameter of the Json format. The first interface parameter includes a plurality of parameter data, and the plurality of parameter data are displayed line by line and are sorted in a second preset order. The terminal obtains the interface parameter of the previous version in the second file through the application, and converts the interface parameter of the previous version into the second interface parameter of the Json format. The second interface parameter includes a plurality of parameter data, and the plurality of parameter data are displayed line by line and sorted in a second preset order. The application compares the first interface parameter with the second interface parameter line by line, and outputs parameter data in which the current version is inconsistent with the previous version. Since the order of the first interface parameter and the plurality of parameter data in the second interface parameter are consistent, it is easy to know the parameter data of the two by comparison. This makes it easy for the user to know which parameter data in the interface data between different versions of the database has been modified.

In one embodiment, as shown in FIG. 3, a data comparison apparatus is provided, including: a file capture module 302 and a comparison module 304, wherein:

The file fetching module 302 is configured to obtain a first database name and a first file name, and fetch the first file in the first database according to the first database name and the first file name; and obtain the second database name and the second file name, according to the first The second database name and the second file name fetch the second file in the second database.

The comparison module 304 is configured to obtain configuration information, where the configuration information includes a field name to be compared in the first file, and a field name to be compared in the second file; according to the field name to be compared in the first file and the second file The field names to be compared are compared with the data in the first file and the second file, and the comparison result is output.

In an embodiment, the comparison module 304 is further configured to: if the configuration information does not exist, obtain the field name to be compared in the first file and the field name to be compared in the second file; respectively, according to the field name to be compared Querying the first field to be compared and querying the second field to be compared in the second file; and arranging the first field and the second field in a first preset order; arranging the first field and the second field Compare and output the comparison results.

In an embodiment, the first file includes a data table, and the second file includes a data table, and the comparison module 304 is further configured to obtain a table structure corresponding to the first file and a table structure corresponding to the second file; The structure is compared with the table structure corresponding to the second file; the fields in which the first file is inconsistent with the second file are output.

In an embodiment, the first file includes a plurality of packages, and the second file includes a plurality of packages. The comparison module 304 is further configured to: if the configuration information includes the package name to be compared and the corresponding owner, according to the package name to be compared and the corresponding The owner obtains two packages to be compared in the first database and the second database, and compares the two packages to be compared; if the configuration information does not include the package name to be compared and the corresponding owner, the first will be Multiple packages in the database and/or multiple packages in the second database are compared separately.

In an embodiment, the first file includes the interface parameter of the current version, the second file includes the interface parameter of the previous version, and the comparison module 304 is further configured to convert the interface parameter of the current version into the first interface parameter of the Json format; The plurality of parameter data of an interface parameter are sorted according to a second preset order; the interface parameter of the previous version is converted into the second interface parameter of the Json format; and the plurality of parameter data of the second interface parameter are sorted according to the second preset order; Comparing the sorted first interface parameter with the second interface parameter, and outputting parameter data in which the current version is inconsistent with the previous version.

In one embodiment, a computer device is provided, the computer device comprising the terminal mentioned in the above embodiments. As shown in FIG. 4, the computer device includes a processor, a memory, and a network interface connected by a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium, an internal memory. The non-volatile storage medium of the computer device stores an operating system and computer readable instructions, and the non-volatile storage medium can be a computer-readable non-volatile storage medium. The computer readable instructions are executed by the processor to implement a data comparison method. The internal memory of the computer device provides an environment for the operation of an operating system and computer readable instructions in a non-volatile storage medium. The network interface of the computer device is used for communicating with an external server through a network connection, for example, capturing a file to be compared in a database in the server. When the processor executes the computer readable instructions, the following steps may be performed: acquiring the first database name and the first file name, and fetching the first file in the first database according to the first database name and the first file name; acquiring the second database name and the second file a file name, the second file is captured in the second database according to the second database name and the second file name; obtaining configuration information, where the configuration information includes a field name to be compared in the first file, and a field to be compared in the second file Name; compare the data in the first file and the second file according to the field name to be compared in the first file and the field name to be compared in the second file, and output the comparison result.

It will be understood by those skilled in the art that the structure shown in FIG. 4 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation of the computer device to which the solution of the present application is applied. The specific computer device may It includes more or fewer components than those shown in the figures, or some components are combined, or have different component arrangements.

In one embodiment, as shown in FIG. 5, an application scenario is provided. The computer device 502 is connected to the first server 504 via a network, and the computer device 504 is connected to the second server 506 via a network. A first database is deployed on the first server 504 and a second database is deployed on the second server 506. A data comparison application is run in computer device 504. The computer device 504 can display a comparison page through the application. The first page name and the first file name and the second database name and the second file name input by the user are included in the comparison page. The computer device 504 accesses the first server 504 with the data comparison application to read the data of the first file in the first database, and the computer device 504 accesses the second server 506 with the data comparison application to read the second file in the second database. The data. Computer device 504 adds the read data to the comparison page for presentation. The computer device 504 invokes the configuration information by using the data comparison application, and compares the data of the first file and the second file displayed in the page according to the field name to be compared in the first file in the configuration information and the field name to be compared in the second file. The data is compared and the comparison results are output on the comparison page. This makes it possible to directly compare data in different databases.

In one embodiment, the processor also performs the following steps when executing the computer readable instructions:

If the configuration information does not exist, obtain the field name to be compared in the first file and the field name to be compared in the second file;

Querying, according to the field name to be compared, the first field to be compared in the first file and the second field to be compared in the second file;

Arranging the first field and the second field in a first predetermined order; and

The aligned first field and the second field are compared to output a comparison result.

In one embodiment, the first file includes a data table, the second file includes a data table, and the processor performs the following steps when executing the computer readable instructions:

Obtaining a table structure corresponding to the first file and a table structure corresponding to the second file;

Comparing the table structure corresponding to the first file with the table structure corresponding to the second file;

Outputs a field that is inconsistent between the first file and the second file.

In one embodiment, the first file includes a plurality of packages, the second file includes a plurality of packages, and the processor further performs the following steps when executing the computer readable instructions:

If the configuration information includes the package name to be compared and the corresponding owner, the two packages to be compared are obtained in the first database and the second database according to the package name to be compared and the corresponding owner, and the two packages to be compared are compared. Compare; and

If the package name to be compared and the corresponding owner are not included in the configuration information, the multiple packets in the first database and/or the multiple packets in the second database are separately compared.

In one embodiment, the first file includes the current version of the interface parameter, and the second file includes the interface parameter of the previous version. When the processor executes the computer readable instructions, the processor further performs the following steps: converting the current version of the interface parameter to the Json format The first interface parameter; the plurality of parameter data of the first interface parameter are sorted in a second preset order;

Converting the interface parameter of the previous version to the second interface parameter of the Json format; and the plurality of parameter data of the second interface parameter are sorted according to the second preset order;

Comparing the sorted first interface parameter with the second interface parameter, and outputting parameter data in which the current version is inconsistent with the previous version.

In one embodiment, there is provided one or more computer readable non-volatile storage media having computer readable instructions, when executed by one or more processors, causing one or more processors Perform the following steps:

The data in the first file and the second file are compared according to the field name to be compared in the first file and the field name to be compared in the second file, and the comparison result is output.

Comparing the table structure corresponding to the first file with the table structure corresponding to the second file; and

In one embodiment, the first file includes an interface parameter of the current version, and the second file includes interface parameters of the previous version, and the computer readable instructions are further executed by the processor to perform the following steps:

Converting the current version of the interface parameter to the first interface parameter in the Json format; the plurality of parameter data of the first interface parameter are sorted according to the second preset order;

In one embodiment, one or more computer readable non-volatile storage media storing computer readable instructions are provided, the computer readable instructions being executed by one or more processors such that one or more The steps in the various method embodiments described above are implemented when the processor is executed.

One of ordinary skill in the art can understand that all or part of the process of implementing the above embodiments can be completed by computer readable instructions, which can be stored in a non-volatile computer. The readable storage medium, which when executed, may include the flow of an embodiment of the methods as described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), or the like.

The technical features of the above-described embodiments may be arbitrarily combined. For the sake of brevity of description, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction between the combinations of these technical features, All should be considered as the scope of this manual.

The above-mentioned embodiments are merely illustrative of several embodiments of the present application, and the description thereof is more specific and detailed, but is not to be construed as limiting the scope of the invention. It should be noted that a number of variations and modifications may be made by those skilled in the art without departing from the spirit and scope of the present application. Therefore, the scope of the invention should be determined by the appended claims.

Claims

A data comparison method that includes:

Obtaining a first database name and a first file name, and fetching the first file in the first database according to the first database name and the first file name;

Obtaining a second database name and a second file name, and fetching the second file in the second database according to the second database name and the second file name;

Obtaining configuration information, where the configuration information includes a field name to be compared in the first file and a field name to be compared in the second file; and

And comparing the data in the first file and the second file according to the field name to be compared in the first file and the field name to be compared in the second file, and outputting the comparison result.
The method of claim 1 further comprising:

If the configuration information does not exist, obtaining a field name to be compared in the first file and a field name to be compared in the second file;

Querying, according to the field name to be compared, the first field to be compared in the first file and the second field to be compared in the second file;

Arranging the first field and the second field in a first predetermined order; and

The aligned first field and the second field are compared to output a comparison result.
The method according to claim 1, wherein the first file comprises a data table, the second file comprises a data table, and the method further comprises:

Obtaining a table structure corresponding to the first file and a table structure corresponding to the second file;

Comparing the table structure corresponding to the first file with the table structure corresponding to the second file; and

Outputs a field that is inconsistent between the first file and the second file.
The method according to claim 1, wherein the first file comprises a plurality of packages, the second file comprises a plurality of packages, and the method further comprises:

If the configuration information includes the package name to be compared and the corresponding owner, the two packages to be compared are obtained in the first database and the second database according to the package name to be compared and the corresponding owner, and the two to be compared are compared. Comparison of packages; and

If the package name to be compared and the corresponding owner are not included in the configuration information, compare multiple packets in the first database and/or multiple packets in the second database.
The method according to claim 1, wherein the first file includes an interface parameter of a current version, and the second file includes an interface parameter of a previous version, the method further comprising:

Converting the current version of the interface parameter into a first interface parameter in the Json format; the plurality of parameter data of the first interface parameter are sorted in a second preset order;

Converting the interface parameter of the previous version to a second interface parameter of the Json format; the plurality of parameter data of the second interface parameter are sorted according to a second preset order; and

Comparing the sorted first interface parameter with the second interface parameter, and outputting parameter data in which the current version is inconsistent with the previous version.
A data comparison device, characterized in that the device comprises:

a file capture module, configured to acquire a first database name and a first file name, and fetch the first file in the first database according to the first database name and the first file name; obtain the second database name and the second file name, according to The second database name and the second file name fetch the second file in the second database; and

a comparison module, configured to obtain configuration information, where the configuration information includes a field name to be compared in the first file, and a field name to be compared in the second file; according to the field name to be compared in the first file, and The field names to be compared in the two files compare the data in the first file and the second file, and output the comparison result.
The device according to claim 6, wherein the comparison module is further configured to: if the configuration information does not exist, obtain a field name to be compared in the first file and a field name to be compared in the second file; Querying, according to the field name to be compared, the first field to be compared in the first file and the second field to be compared in the second file; and performing the first field and the second field in the first preset order Arrange; compare the first field and the second field after the arrangement, and output the comparison result.
The device according to claim 6 or 7, wherein the first file comprises a data table, the second file comprises a data table, and the comparison module is further configured to obtain a table structure corresponding to the first file and a table structure corresponding to the second file; comparing the table structure corresponding to the first file with the table structure corresponding to the second file; and outputting a field inconsistent between the first file and the second file.
The device according to claim 6, wherein the first file comprises a plurality of packages, the second file comprises a plurality of packages, and the comparison module is further configured to: if the configuration information includes a package to be compared And the corresponding owner, according to the package name to be compared and the corresponding owner respectively, obtain two packages to be compared in the first database and the second database, and compare the two packages to be compared; and if the configuration The information to be compared with the corresponding owner is not included in the information, and the plurality of packages in the first database and/or the plurality of packages in the second database are separately compared.
The apparatus according to claim 6, wherein the first file includes an interface parameter of a current version, the second file includes an interface parameter of a previous version, and the comparison module is further configured to use the current version. Converting the interface parameter to the first interface parameter in the Json format; the plurality of parameter data of the first interface parameter are sorted in a second preset order; converting the interface parameter of the previous version to the second interface parameter in the Json format The plurality of parameter data of the second interface parameter are sorted in a second preset order; and the sorted first interface parameter is compared with the second interface parameter, and the parameter data in which the current version is inconsistent with the previous version is output.
A computer device comprising a memory and one or more processors having stored therein computer readable instructions, the computer readable instructions being executable by the processor to cause the one or more processors to execute The following steps:

Obtaining a first database name and a first file name, and fetching the first file in the first database according to the first database name and the first file name;

Obtaining a second database name and a second file name, and fetching the second file in the second database according to the second database name and the second file name;

Obtaining configuration information, where the configuration information includes a field name to be compared in the first file and a field name to be compared in the second file; and

And comparing the data in the first file and the second file according to the field name to be compared in the first file and the field name to be compared in the second file, and outputting the comparison result.
The computer apparatus according to claim 11, wherein said computer readable instructions are executed by said processor such that said one or more processors further perform the following steps:

If the configuration information does not exist, obtaining a field name to be compared in the first file and a field name to be compared in the second file;

Querying, according to the field name to be compared, the first field to be compared in the first file and the second field to be compared in the second file;

Arranging the first field and the second field in a first predetermined order; and

The aligned first field and the second field are compared to output a comparison result.
The computer apparatus according to claim 11, wherein said first file comprises a data table, said second file comprising a data table, said computer readable instructions being executed by said processor such that said one Or multiple processors perform the following steps:

Obtaining a table structure corresponding to the first file and a table structure corresponding to the second file;

Comparing the table structure corresponding to the first file with the table structure corresponding to the second file; and

Outputs a field that is inconsistent between the first file and the second file.
A computer apparatus according to any one of claims 11 to 13, wherein said first file comprises a plurality of packages, said second file comprises a plurality of packages, said computer readable instructions being said processor When executed, the one or more processors are further configured to perform the following steps:

If the configuration information includes the package name to be compared and the corresponding owner, the two packages to be compared are obtained in the first database and the second database according to the package name to be compared and the corresponding owner, and the two to be compared are compared. Comparison of packages; and

If the package name to be compared and the corresponding owner are not included in the configuration information, compare multiple packets in the first database and/or multiple packets in the second database.
The computer device according to claim 14, wherein said first file comprises an interface parameter of a current version, said second file comprises an interface parameter of a previous version, said computer readable instructions being said processor When executed, the one or more processors are further configured to perform the following steps:

Converting the current version of the interface parameter into a first interface parameter in the Json format; the plurality of parameter data of the first interface parameter are sorted in a second preset order;

Converting the interface parameter of the previous version to a second interface parameter of the Json format; the plurality of parameter data of the second interface parameter are sorted according to a second preset order; and

Comparing the sorted first interface parameter with the second interface parameter, and outputting parameter data in which the current version is inconsistent with the previous version.
One or more computer readable non-volatile storage media storing computer readable instructions, when executed by one or more processors, cause one or more processors to perform the steps of:

Obtaining a first database name and a first file name, and fetching the first file in the first database according to the first database name and the first file name;

Obtaining a second database name and a second file name, and fetching the second file in the second database according to the second database name and the second file name;

Obtaining configuration information, where the configuration information includes a field name to be compared in the first file and a field name to be compared in the second file; and

And comparing the data in the first file and the second file according to the field name to be compared in the first file and the field name to be compared in the second file, and outputting the comparison result.
The storage medium of claim 16 wherein the computer readable instructions are executed by one or more processors such that the one or more processors further perform the steps of:

If the configuration information does not exist, obtaining a field name to be compared in the first file and a field name to be compared in the second file;

Querying, according to the field name to be compared, the first field to be compared in the first file and the second field to be compared in the second file;

Arranging the first field and the second field in a first predetermined order; and

The aligned first field and the second field are compared to output a comparison result.
The storage medium of claim 16 wherein said first file comprises a data table, said second file comprising a data table, said computer readable instructions being executed by one or more processors to cause one or more The processors also perform the following steps:

Obtaining a table structure corresponding to the first file and a table structure corresponding to the second file;

Comparing the table structure corresponding to the first file with the table structure corresponding to the second file; and

Outputs a field that is inconsistent between the first file and the second file.
A storage medium according to any one of claims 16 to 18, wherein the first file comprises a plurality of packages, the second file comprises a plurality of packages, and the computer readable instructions are executed by one or more processors When executed, one or more processors also perform the following steps:

If the configuration information includes the package name to be compared and the corresponding owner, the two packages to be compared are obtained in the first database and the second database according to the package name to be compared and the corresponding owner, and the two to be compared are compared. Comparison of packages; and

If the package name to be compared and the corresponding owner are not included in the configuration information, compare multiple packets in the first database and/or multiple packets in the second database.
The storage medium of claim 19, wherein the first file comprises an interface parameter of a current version, the second file comprises interface parameters of a previous version, and the computer readable instructions are by one or more processors When executed, one or more processors also perform the following steps:

Converting the current version of the interface parameter into a first interface parameter in the Json format; the plurality of parameter data of the first interface parameter are sorted in a second preset order;

Converting the interface parameter of the previous version to a second interface parameter of the Json format; the plurality of parameter data of the second interface parameter are sorted according to a second preset order; and

Comparing the sorted first interface parameter with the second interface parameter, and outputting parameter data in which the current version is inconsistent with the previous version.