WO2021042532A1

WO2021042532A1 - Database information analysis method and apparatus, computer apparatus, and storage medium

Info

Publication number: WO2021042532A1
Application number: PCT/CN2019/117416
Authority: WO
Inventors: 王保军
Original assignee: 平安科技（深圳）有限公司
Priority date: 2019-09-05
Filing date: 2019-11-12
Publication date: 2021-03-11
Also published as: CN110737642B; CN110737642A

Abstract

A database information analysis method and apparatus, a computer apparatus, and a storage medium. The method comprises: obtaining an SQL file of a software project; extracting all the first data columns in the SQL file and a first database table where the first data columns are located; inquiring all the second data columns in a database connected with the software project and a second database table where the second data columns are located; outputting a database table that exists in the first database table but does not exist in the second database table; outputting a data column that exists in the first data columns but does not exist in the second data columns, and/or outputting the first data column of which the first database table is inconsistent with the second database table where the second data columns are located; generating a table structure file of the database; and correcting the SQL file according to the table structure file. The present invention can analyze and correct the database information of the software project.

Description

Database information analysis method, device, computer device and storage medium

This application claims to be submitted to the Chinese Patent Office on September 5, 2019. The application number is 201910839266.8. The application titled "Database Information Analysis Method, Device, Computer Device and Storage Medium" is the priority of the Chinese patent application, the entire content of which is incorporated by reference In this application.

Technical field

This application relates to the field of information analysis technology, and in particular to a database information analysis method, device, computer device, and non-volatile readable storage medium.

Background technique

In the process of software project migration or reconstruction, there may be a problem that the database information used by the software project is inconsistent with the actual database information of the database. In order to avoid software project running errors due to inconsistent database information, the database information of the software project needs to be analyzed and corrected.

Summary of the invention

In view of the above, it is necessary to propose a database information analysis method, device, computer device and non-volatile readable storage medium, which can analyze and modify the database information of the software project.

A first aspect of the present application provides a database information analysis method, the method includes: obtaining a SQL file of a software project; extracting all first data columns in the SQL file and a first database where the first data columns are located Table; query all the second data columns in the database connected to the software project and the second database table where the second data column is located; determine whether the first database table is included in the second database table; if If the first database table is not included in the second database table, output the database tables that exist in the first database table but not in the second database table; determine whether the first data column contains In the second data column, and determine whether the first database table where the first data column is located is consistent with the second database table where the second data column is located; if the first data column is not included in the In the second data column, and/or the first database table in which the first data column is located is inconsistent with the second database table in which the second data column is located, then the output exists in the first data column and the A data column that does not exist in the second data column, and/or a first data column that is inconsistent between the first database table where the output is located and the second database table where the second data column is located; if the first database table does not contain In the second database table, or the first data column is not included in the second data column, or the first database table where the first data column is located and the first database table where the second data column is located 2. If the database tables are inconsistent, a table structure file of the database is generated; the SQL file is corrected according to the table structure file.

The second aspect of the present application provides a database information analysis device, the device includes: an acquisition module for acquiring SQL files of a software project; an extraction module for extracting all first data columns and all data in the SQL file The first database table where the first data column is located; a query module for querying all the second data columns in the database connected to the software project and the second database table where the second data column is located; first judgment module , Used to determine whether the first database table is included in the second database table; a first output module, used to output the first database table if the first database table is not included in the second database table A database table that exists in the first database table but does not exist in the second database table; a second judgment module for judging whether the first data column is included in the second data column, and judging the first data column Whether the first database table where a data column is located is consistent with the second database table where the second data column is located; the second output module is configured to, if the first data column is not included in the second data column, And/or the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, then the output exists in the first data column but not in the second data column The first database table where the output is located is inconsistent with the second database table where the second data column is located; the generating module is used to if the first database table is not included in the In the second database table, or the first data column is not included in the second data column, or the first database table where the first data column is located and the second database where the second data column is located If the tables are inconsistent, a table structure file of the database is generated; a correction module is used to correct the SQL file according to the table structure file.

A third aspect of the present application provides a computer device, the computer device includes a processor, and the processor is configured to implement the database information analysis method when executing computer-readable instructions stored in a memory.

A fourth aspect of the present application provides a non-volatile readable storage medium having computer readable instructions stored thereon, and when the computer readable instructions are executed by a processor, the database information analysis method is implemented.

This application realizes the analysis and correction of the database information of the software project.

Description of the drawings

Fig. 1 is a flowchart of a method for analyzing database information provided by an embodiment of the present application.

Figure 2 is a structural diagram of a database information analysis device provided by an embodiment of the present application.

Fig. 3 is a schematic diagram of a computer device provided by an embodiment of the present application.

detailed description

Preferably, the database information analysis method of the present application is applied to one or more computer devices. The computer device is a device that can automatically perform numerical calculation and/or information processing in accordance with pre-set or stored instructions. Its hardware includes, but is not limited to, a microprocessor and an application specific integrated circuit (ASIC) , Programmable Gate Array (Field-Programmable Gate Array, FPGA), Digital Processor (Digital Signal Processor, DSP), embedded equipment, etc.

The computer device may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The computer device can interact with the user through a keyboard, a mouse, a remote control, a touch panel, or a voice control device.

Example one

FIG. 1 is a flowchart of a method for analyzing database information provided in Embodiment 1 of the present application. The database information analysis method is used to analyze and modify the database information of the software project.

As shown in Figure 1, the database information analysis method includes:

101. Obtain the SQL (Structured Query Language) file of the software project.

SQL is a database query and programming language used to access data in the database, query, update and manage the database.

A SQL file configuration interface can be generated, the software project path set by the user in the SQL file configuration interface can be received, and the SQL file can be obtained according to the software project path. For example, the software project path may be D:\eclipse\workspaces.

In a specific embodiment, the obtaining the SQL file according to the software project path may include: traversing all files of the software project under the software project path, and obtaining the files from all the files of the software project. SQL file. All files of the software project under the software project path can be traversed recursively. Each folder of the software project may contain subfolders and/or files; if the folder contains subfolders, continue to traverse; if the folder contains files, it is determined whether the file is an SQL file; If the file is a SQL file, save the SQL file.

The SQL file may be an XML (Extensible Markup Language, Extensible Markup Language) file. The SQL file may include SQL statements. For example, the SQL file is testMapper.xml, and the file includes SQL statements. SQL statements are statements used to operate on the database.

102. Extract all the first data columns in the SQL file and the first database table where the first data columns are located.

The target code can be searched according to the tags in the SQL file; the first data column and the first database table can be extracted according to the keywords in the target code.

The target code may include SQL statements, stored procedures, triggers, and so on. The SQL statement is used to perform operations such as adding, deleting, modifying, and querying database tables/data columns.

For example, the SQL file may include the code "<select id="select_allstudent" result_class="Student">select name from tbl_student where id=#id#</select>". The tag is <select id="select_allstudent"result_class="Student"></select>, the target code is "select name from tbl_student where id=#id#", and the keywords in the target code are "select", " from", "where". "Name" and "id" are the first data columns, and "tbl_student" is the first database table where the first data columns "name" and "id" are located.

The first list may be generated according to the first data column and the first database table.

In addition to the first database table and the first data column, the first list may also include field information such as database, database user name, stored procedure, and trigger.

The first list may be generated in a preset order. For example, the first list is generated according to the first alphabetical order of the first data column or the first database table.

103. Query all the second data columns in the database connected to the software project and the second database table where the second data columns are located.

In a specific embodiment, all the second data columns in the database connected to the software project and the second database table where the data columns are located can be queried in the following manner: obtain the data source information of the software project; according to the data The source information establishes a connection with the database; an SQL query statement is executed to query all the second data columns in the database and the second database table where the data columns are located.

The data source information is the configuration information for creating the database connection, and may include a database user name, a database login password, a link string, a driver class, and the like. For example, the database user name is represented as "username", the database login password is represented as "password", the driver class is represented as "oracle.jdbc.driver.OracleDriver", and the link string is represented as "jdbc:oracle:thin:@127.0.0.1: DEV".

A second list may be generated according to the second data column and the second database table.

In addition to the second data column and the second database table, the second list may also include field information such as database, database user name, stored procedure, and trigger.

The second list may be generated in a preset order. For example, the second list is generated according to the first alphabetical order of the second data column or the second database table.

104. Determine whether the first database table is included in the second database table.

The inclusion of the first database table in the second database table means that each database table in the first database table is included in the second database table.

For example, if the first database table includes Table1, Table2, Table3, and Table4, and the second database table includes Table1, Table2, Table3, Table4, and Table5, the first database table is included in the second database table. .

For another example, if the first database table includes Table1, Table2, Table3, Table4, and Table5, and the second database table includes Table1, Table2, Table3, Table4, and Table5, then the first database table is included in the second Database table.

For another example, if the first database table includes Table1, Table2, Table3, Table4, and Table5, and the second database table includes Table1, Table2, Table3, and Table4, then the first database table is not included in the second database. Table.

It may be determined whether the first database table is included in the second database table according to the first list and the second list.

The COMPARE method may be used to compare the first database table in the first list with the second database table in the second list to determine whether the first database table is consistent with the second database table. If the first database table is consistent with the second database table, it is determined that the first database table is included in the second database table.

105. If the first database table is not included in the second database table, output a database table that exists in the first database table but does not exist in the second database table.

The database table that exists in the first database table but does not exist in the second database table represents a database table that is incorrectly used by the software project.

For example, the first database table includes Table1, Table2, Table3, Table4, and Table5, the second database table includes Table1, Table2, Table3, and Table4, and the first database table is not included in the second database table. , Output the database table Table5 that exists in the first database table but does not exist in the second database table.

If the first database table is not included in the second database table, a database table error prompt or a database table error notification can be sent. The database table error prompt can be issued by voice or text. The notification of the database table error can be sent to the preset contact by means of email, short message, WeChat, etc.

Optionally, in this embodiment, it is also possible to determine whether the second database table is included in the first database table; if the second database table is not included in the first database table, output all A database table that exists in the second database table but does not exist in the first database table.

The database tables that exist in the second database table but not in the first database table represent database tables that are not used by the software project. Outputting the database tables existing in the second database table but not in the first database table can remind the user to confirm whether the database table information is incorrect.

106. Determine whether the first data column is included in the second data column, and determine whether the first database table where the first data column is located is consistent with the second database table where the second data column is located.

The inclusion of the first data column in the second data column means that each data column in the first data column is included in the second data column.

For example, if the first data column includes Line1, Line2, Line3, Line4, and the second data column includes Line1, Line2, Line3, Line4, Line5, then the first data column is included in the second data column .

For another example, if the first data column includes Line1, Line2, Line3, Line4, Line5, and the second data column includes Line1, Line2, Line3, Line4, then the first data column is not included in the second data column. Column.

It may be determined whether the first data column is included in the second data column according to the first list and the second list.

The COMPARE method may be used to compare the first data column in the first list with the second data column in the second list to determine whether the first data column is consistent with the second data column. If the first data row is consistent with the second data row, it is determined that the first data row is included in the second data row.

The first database table where the first data column is located is consistent with the second database table where the second data column is located means that the first database table where each first data column is located is the same as the first database table where the second data column is located. The two database tables are consistent.

For example, the first data column includes Line1, Line2, Line3, Line4, the first database table where the first data column Line1 is located is Table1, the first database table where the first data column Line2 is located is Table2, and the first data column Line3 is The first database table is Table3, the first database table where the first data column Line4 is located is Table4, the second data column includes Line1, Line2, Line3, Line4, Line5, and the second database where the second data column Line1 is located The table is Table1, the second database table where the second data column Line2 is located is Table2, the second database table where the second data column Line3 is located is Table3, and the second database table where the second data column Line4 is located is Table4, then the second database table where the second data column Line4 is located is Table4. The first database table where a data column is located is consistent with the second database table where the second data column is located.

For another example, the first data column includes Line1, Line2, Line3, Line4, the first database table where the first data column Line1 is located is Table1, the first database table where the first data column Line2 is located is Table2, and the first data column is The first database table where Line3 is located is Table3, the first database table where the first data column Line4 is located is Table4; the second data column includes Line1, Line2, Line3, Line4, Line5, and the second data column Line1 is located in the second The database table is Table1, the second database table where the second data column Line2 is located is Table1, the second database table where the second data column Line3 is located is Table1, and the second database table where the second data column Line4 is located is Table4, then The first database table where the first data column is located is inconsistent with the second database table where the second data column is located.

It is possible to determine whether the first data column is included in the second data column according to the first list and the second list, and to determine whether the first database table in which the first data column is located is the same as the first data column. The second database table where the second data column is located is the same.

107. If the first data column is not included in the second data column, and/or the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, Then output data columns that exist in the first data column but do not exist in the second data column, and/or the first database table where the output is located is inconsistent with the second database table where the second data column is located. One data column.

For example, the first data column includes Line1, Line2, Line3, Line4, Line5, the second data column includes Line1, Line2, Line3, Line4, and the first data column is not included in the second data column. , Output the data row Line5 that exists in the first data row but does not exist in the second data row.

For another example, the first data column includes Line1, Line2, Line3, Line4, the first database table where the first data column Line1 is located is Table1, the first database table where the first data column Line2 is located is Table2, and the first data column is The first database table where Line3 is located is Table3, the first database table where the first data column Line4 is located is Table4, the second data column includes Line1, Line2, Line3, Line4, Line5, and the second data column Line1 is located in the second The database table is Table1, the second database table where the second data column Line2 is located is Table1, the second database table where the second data column Line3 is located is Table1, and the second database table where the second data column Line4 is located is Table4. The first database table where a data column is located is not consistent with the second database table where the second data column is located, and the first data column where the first database table where the second data column is located is inconsistent with the second database table where the second data column is located is output. Line2, Line3.

If the first data column is not included in the second data column, and/or the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, you can issue Data column error prompt or send data column error notification. The data string error prompt can be issued by voice or text. The notification of the data column error can be sent to the preset contact by means of email, SMS, WeChat, etc.

It should be noted that the order of 104, 105 and 106, 107 can be interchanged. In the foregoing embodiment, the database table is judged first. In other embodiments, the data column may be judged first.

108. If the first database table is not included in the second database table, or the first data column is not included in the second data column, or the first database where the first data column is located If the table is inconsistent with the second database table where the second data column is located, a table structure file of the database is generated.

The table structure file of the database indicates all the database tables and database columns contained in the database, and the correspondence between the database columns and the database tables.

In a specific embodiment, the method is applied to Java, and generating the table structure file of the database may include:

1. Read the database script of the database, and parse the database script into the corresponding java entity class.

The java entity class is a concept widely used in JAVA software development. The java entity class is a class containing Set and Get methods, and can usually be associated with a database.

The database script is generated when the database and the database tables in the database are created.

The database script may contain one or more data tables. Parsing the database script into the corresponding java entity class means parsing and packaging the database script into the java entity class corresponding to the one or more data tables. Specifically, the database tables contained in the database script can be identified, and the data information contained in each database table can be parsed and packaged into a corresponding java entity class. In other words, each java entity class corresponds to a data table in the database script, and one or more corresponding java entity classes can be obtained by parsing one database script.

The database script can be exported through a set tool (such as PowerDesigner).

The database script can be exported according to the received database command.

2. Generate the table structure file according to the java entity class.

The style of the table structure file can be set according to actual needs. For example, set the styles of multiple data table titles (including fonts, display positions, etc.), and multiple table structure styles (including table size, fill color, data display format, etc.).

In a specific embodiment, the table structure file may include database tables, table remarks, data columns, data column remarks, data column types, and so on. For example, in the table structure file, "tableName" is used for database table, "tableComment" is used for table comment, "columName" is used for data column, "columComment" is used for data column comment, and "columType" is used for data column. Types of.

In this embodiment, if the database script contains multiple data tables, multiple corresponding java entity classes can be obtained. Therefore, the corresponding table structure file generated according to the java entity class corresponding to the database script also contains multiple data table structures.

109. Correct the SQL file according to the table structure file.

Modifying the SQL file according to the table structure file means modifying the database tables that exist in the first database table but not in the second database table in the SQL file, and/or modifying the SQL file Data columns that exist in the first data column but not in the second data column, and/or modify the first database table where the SQL file is located and the second database table where the second data column is located Inconsistent first data column.

For a database table that exists in the first database table but does not exist in the second database table, or a data column that exists in the first data column but does not exist in the second data column, it may be based on the table The structure file searches for a replacement database table for a database table that exists in the first database table but does not exist in the second database table, and searches for data that exists in the first data column but does not exist in the second data column The replacement database column of the column, the replacement database table replaces the database table that exists in the first database table in the SQL file but does not exist in the second database table, and the replacement database column replaces the SQL A data column that exists in the first data column but does not exist in the second data column in the file. The replacement database table and the replacement database column may be determined according to the table remarks, data column remarks, data column type, etc. in the table structure file.

For a first data column that is inconsistent with the first database table in which the second data column is located, the second data table corresponding to the inconsistent first data column may be searched according to the table structure file, The second data table corresponding to the inconsistent first data column is substituted for the first data table in the SQL file where the inconsistent first data column is located.

The database information analysis method of the first embodiment obtains the SQL file of the software project; extracts all the first data columns in the SQL file and the first database table where the first data columns are located; and queries the database connected to the software project All the second data columns and the second database table where the data columns are located; determine whether the first database table is included in the second database table; if the first database table is not included in the second database table In the database table, output the database tables that exist in the first database table but not in the second database table; determine whether the first data column is included in the second data column, and determine whether the Whether the first database table where the first data column is located is consistent with the second database table where the second data column is located; if the first data column is not included in the second data column, and/or the first data column is If the first database table where a data column is located is inconsistent with the second database table where the second data column is located, output data columns that exist in the first data column but not in the second data column, and/ Or output a first data column that is inconsistent with the second database table where the second data column is located; if the first database table is not included in the second database table, or the first database table is If a data column is not included in the second data column, or the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, then the table structure of the database is generated File; revise the SQL file according to the table structure file. The embodiment analyzes the database information of the software project. When the database information used by the software project is inconsistent with the actual database information of the database, the database information of the software project is corrected, thereby reducing the inconsistency between the database information used by the software project and the actual database information of the database. The risk of improving software quality.

Example two

Fig. 2 is a structural diagram of a database information analysis device provided in the second embodiment of the present application. The database information analysis device 20 is applied to a computer device, and is used to analyze and correct the database information of the software project.

As shown in FIG. 2, the database information analysis device 20 may include an acquisition module 201, an extraction module 202, a query module 203, a first judgment module 204, a first output module 205, a second judgment module 206, and a second output module 207 , The generation module 208, the correction module 209.

The obtaining module 201 is used to obtain SQL (Structured Query Language, structured query language) files of the software project.

In a specific embodiment, the obtaining the SQL file according to the software project path may include: traversing all files of the software project under the software project path, and obtaining the files from all the files of the software project. SQL file. All files of the software project under the software project path can be traversed recursively. Each folder of the software project may contain subfolders and/or files; if the folder contains subfolders, continue to traverse; if the folder contains files, determine whether the file is an SQL file; If the file is a SQL file, save the SQL file.

The extraction module 202 is configured to extract all the first data columns in the SQL file and the first database table where the first data columns are located.

For example, the SQL file may include the code "<select id="select_allstudent"result_class="Student">select name from tbl_student where id=#id#</select>". The tag is <select id="select_allstudent"result_class="Student"></select>, the target code is "select name from tbl_student where id=#id#", and the keywords in the target code are "select", " from", "where". "Name" and "id" are the first data columns, and "tbl_student" is the first database table where the first data columns "name" and "id" are located.

The query module 203 is configured to query all the second data columns in the database connected to the software project and the second database table where the second data columns are located.

The data source information is the configuration information for creating a database connection, and may include a database user name, a database login password, a link string, a driver category, and the like. For example, the database user name is represented as "username", the database login password is represented as "password", the driver class is represented as "oracle.jdbc.driver.OracleDriver", and the link string is represented as "jdbc:oracle:thin:@127.0.0.1: DEV".

The first judgment module 204 is configured to judge whether the first database table is included in the second database table.

The first output module 205 is configured to output a database table that exists in the first database table but does not exist in the second database table if the first database table is not included in the second database table.

The second determining module 206 is configured to determine whether the first data column is included in the second data column, and whether the first database table in which the first data column is located is the same as the one in which the second data column is located. The second database table is consistent.

The second output module 207 is configured to: if the first data column is not included in the second data column, and/or the first database table where the first data column is located and the second data column are located If the second database table is inconsistent, output data columns that exist in the first data column but not in the second data column, and/or the first database table where the output is located and the second data column where the second data column is located are output. Second, the first data column inconsistent in the database table.

It should be noted that the order of the

aforementioned modules

204 and 205 and the

modules

206 and 207 can be interchanged. In the foregoing embodiment, the database table is judged first. In other embodiments, the data column may be judged first.

The generating module 208 is configured to: if the first database table is not included in the second database table, or the first data column is not included in the second data column, or the first data column is located If the first database table of is inconsistent with the second database table where the second data column is located, a table structure file of the database is generated.

The database script can be exported through a set tool (such as PowerDesigner).

The database script can be exported according to the received database command.

2. Generate the table structure file according to the java entity class.

The style of the table structure file can be set according to actual needs. For example, set the style of multiple data table headings (including font, display position, etc.), and the style of multiple table structure (including table size, fill color, data display format, etc.).

The correction module 209 is configured to correct the SQL file according to the table structure file.

The database information analysis device 20 of the second embodiment obtains the SQL file of the software project; extracts all the first data columns in the SQL file and the first database table where the first data column is located; queries the database connected to the software project All the second data columns in the data column and the second database table where the data column is located; determine whether the first database table is included in the second database table; if the first database table is not included in the first database table In the second database table, output the database tables that exist in the first database table but not in the second database table; determine whether the first data column is included in the second data column, and determine all Whether the first database table where the first data column is located is consistent with the second database table where the second data column is located; if the first data column is not included in the second data column, and/or the If the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, output data columns that exist in the first data column but not in the second data column, and /Or the first data column where the first database table where the output is located is inconsistent with the second database table where the second data column is located; if the first database table is not included in the second database table, or the If the first data column is not included in the second data column, or the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, then the database table is generated Structure file; revise the SQL file according to the table structure file. The second embodiment analyzes the database information of the software project. When the database information used by the software project is inconsistent with the actual database information of the database, the database information of the software project is corrected, thereby reducing the inconsistency between the database information used by the software project and the actual database information of the database. The risk of improving software quality.

Example three

This embodiment provides a non-volatile readable storage medium having computer readable instructions stored on the non-volatile readable storage medium, and when the computer readable instructions are executed by a processor, the above embodiment of the database information analysis method is implemented The steps in FIG. 1, for example, 101-109 shown in FIG. 1; or, when the computer-readable instruction is executed by a processor, the function of each module in the foregoing apparatus embodiment is realized, for example, modules 201-209 in FIG.

Example four

FIG. 3 is a schematic diagram of a computer device provided in Embodiment 4 of this application. The computer device 30 includes a memory 301, a processor 302, and computer-readable instructions 303 stored in the memory 301 and running on the processor 302, such as a database information analysis program. When the processor 302 executes the computer-readable instruction 303, the steps in the embodiment of the database information analysis method described above are implemented, for example, 101-109 shown in FIG. 1. Alternatively, the computer-readable instruction realizes the functions of the modules in the foregoing device embodiment when executed by the processor, for example, the modules 201-209 in FIG. 2.

Exemplarily, the computer-readable instruction 303 may be divided into one or more modules, and the one or more modules are stored in the memory 301 and executed by the processor 302 to complete the method . For example, the computer-readable instruction 303 can be divided into the acquisition module 201, the extraction module 202, the query module 203, the first judgment module 204, the first output module 205, the second judgment module 206, and the second output in FIG. The module 207, the generating module 208, and the correcting module 209, refer to the second embodiment for the specific functions of each module.

The computer device 30 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. Those skilled in the art can understand that the schematic diagram 3 is only an example of the computer device 30 and does not constitute a limitation on the computer device 30. It may include more or less components than those shown in the figure, or combine certain components, or be different. For example, the computer device 30 may also include input and output devices, network access devices, buses, and so on.

The so-called processor 302 may be a central processing unit (Central Processing Unit, CPU), other general processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), Field-Programmable Gate Array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. The general-purpose processor can be a microprocessor or the processor 302 can also be any conventional processor, etc. The processor 302 is the control center of the computer device 30, which uses various interfaces and lines to connect the entire computer device 30. Various parts.

The memory 301 may be used to store the computer-readable instructions 303, and the processor 302 executes or executes the computer-readable instructions or modules stored in the memory 301 and calls the data stored in the memory 301 to implement Various functions of the computer device 30. The memory 301 may mainly include a storage program area and a storage data area, where the storage program area may store an operating system, an application program required by at least one function (such as a sound playback function, an image playback function, etc.); the storage data area may Data (such as audio data) created in accordance with the use of the computer device 30 is stored. In addition, the memory 301 may include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a Secure Digital (SD) card, a flash memory card (Flash Card), At least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device.

If the integrated module of the computer device 30 is implemented in the form of a software function module and sold or used as an independent product, it can be stored in a non-volatile readable storage medium. Based on this understanding, this application implements all or part of the processes in the above-mentioned embodiments and methods, and can also be completed by instructing relevant hardware through computer-readable instructions. The computer-readable instructions may be stored in a non-volatile memory. In the storage medium, when the computer-readable instructions are executed by the processor, the steps of the foregoing method embodiments can be implemented. Wherein, the computer-readable instructions may be in the form of source code, object code, executable file, or some intermediate forms. The non-volatile readable storage medium may include: any entity or device capable of carrying the computer readable instructions, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, read-only memory (ROM, Read-Only Memory).

In the several embodiments provided in this application, it should be understood that the disclosed system, device, and method may be implemented in other ways. For example, the device embodiments described above are only illustrative. For example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the application and not to limit them. Although the application has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the application can be Make modifications or equivalent replacements without departing from the spirit and scope of the technical solution of the present application.

Claims

A method for analyzing database information, characterized in that the method includes:

Obtain the SQL file of the software project;

Extracting all the first data columns in the SQL file and the first database table where the first data columns are located;

Querying all the second data columns in the database connected to the software project and the second database table where the second data columns are located;

Judging whether the first database table is included in the second database table;

If the first database table is not included in the second database table, output the database tables that exist in the first database table but do not exist in the second database table;

Determining whether the first data column is included in the second data column, and determining whether the first database table where the first data column is located is consistent with the second database table where the second data column is located;

If the first data column is not included in the second data column, and/or the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, then output A data column that exists in the first data column but does not exist in the second data column, and/or the first data in the first database table where the output is located is inconsistent with the second database table where the second data column is located Column

If the first database table is not included in the second database table, or the first data column is not included in the second data column, or the first database table in which the first data column is located and If the second database table where the second data column is located is inconsistent, a table structure file of the database is generated;

Modify the SQL file according to the table structure file.
The method according to claim 1, wherein said obtaining the SQL file of the software project comprises:

Generate a SQL file configuration interface, receive the software project path set by the user in the SQL file configuration interface, and obtain the SQL file according to the software project path.
8. The method according to claim 1, wherein said extracting all the first data columns in said SQL file and the first database table where said first data columns are located comprises:

Searching for the target code according to the tags in the SQL file;

The first data column and the first database table are extracted according to the keywords in the target code.
The method according to claim 1, wherein the querying all the second data columns in the database connected to the software project and the second database table where the second data columns are located comprises:

Acquiring data source information of the software project;

Establish a connection with the database according to the data source information;

The SQL query statement is executed to query all the second data columns in the database and the second database table where the data columns are located.
The method according to claim 1, wherein said generating a table structure file of said database comprises:

Read the database script of the database, and parse the database script into the corresponding java entity class;

The table structure file is generated according to the java entity class.
The method according to any one of claims 1-5, wherein the method further comprises:

It is determined whether the data format of the second database table is correct, and if the data format of the second database table is incorrect, a database format error prompt is issued.
7. The method of claim 6, wherein said determining whether the data format of the second database table is correct comprises:

Acquiring the data type and data length of the second data column in the second database table;

If the data type of the second data column is consistent with the preset data type and the data length of the second data column is consistent with the preset data length, the data format of the second database table is correct.
A database information analysis device, characterized in that the device includes:

Obtaining module, used to obtain the SQL file of the software project;

An extraction module for extracting all the first data columns in the SQL file and the first database table where the first data columns are located;

The query module is used to query all the second data columns in the database connected to the software project and the second database table where the second data columns are located;

The first judgment module is used to judge whether the first database table is included in the second database table;

A first output module, configured to output a database table that exists in the first database table but does not exist in the second database table if the first database table is not included in the second database table;

The second judgment module is configured to judge whether the first data column is included in the second data column, and whether the first database table where the first data column is located is the same as the first database table where the second data column is located. Two database tables are consistent;

The second output module is configured to, if the first data column is not included in the second data column, and/or the first database table where the first data column is located and the first database table where the second data column is located If the two database tables are inconsistent, output data columns that exist in the first data column but not in the second data column, and/or the first database table where the output is located and the second data column where the second data column is located are output. The first data column inconsistent in the database table;

A generating module, configured to: if the first database table is not included in the second database table, or the first data column is not included in the second data column, or the first data column is located If the first database table is inconsistent with the second database table where the second data column is located, a table structure file of the database is generated;

The correction module is used to correct the SQL file according to the table structure file.
A computer device, characterized in that the computer device includes a processor and a memory, and the processor is configured to execute computer-readable instructions stored in the memory to implement the following steps:

Obtain the SQL file of the software project;

Extracting all the first data columns in the SQL file and the first database table where the first data columns are located;

Querying all the second data columns in the database connected to the software project and the second database table where the second data columns are located;

Judging whether the first database table is included in the second database table;

If the first database table is not included in the second database table, output the database tables that exist in the first database table but do not exist in the second database table;

Determining whether the first data column is included in the second data column, and determining whether the first database table where the first data column is located is consistent with the second database table where the second data column is located;

If the first data column is not included in the second data column, and/or the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, then output A data column that exists in the first data column but does not exist in the second data column, and/or the first data in the first database table where the output is located is inconsistent with the second database table where the second data column is located Column

If the first database table is not included in the second database table, or the first data column is not included in the second data column, or the first database table in which the first data column is located and If the second database table where the second data column is located is inconsistent, a table structure file of the database is generated;

Modify the SQL file according to the table structure file.
9. The computer device according to claim 9, wherein when the processor executes the computer-readable instructions to implement the obtaining of the SQL file of the software project, the method comprises:

Generate a SQL file configuration interface, receive the software project path set by the user in the SQL file configuration interface, and obtain the SQL file according to the software project path.
The computer device of claim 9, wherein the processor executes the computer-readable instructions to implement the extraction of all the first data columns in the SQL file and the location where the first data columns are located. The first database table includes:

Searching for the target code according to the tags in the SQL file;

The first data column and the first database table are extracted according to the keywords in the target code.
The computer device of claim 9, wherein the processor executes the computer-readable instructions to implement the query for all the second data columns and the second data in the database connected to the software project When the second database table where the column is located, include:

Acquiring data source information of the software project;

Establish a connection with the database according to the data source information;

The SQL query statement is executed to query all the second data columns in the database and the second database table where the data columns are located.
9. The computer device according to claim 9, wherein when the processor executes the computer-readable instructions to implement the generation of the table structure file of the database, the method comprises:

Read the database script of the database, and parse the database script into the corresponding java entity class;

The table structure file is generated according to the java entity class.
The computer device according to any one of claims 9-13, wherein the processor further implements the following steps when executing the computer-readable instruction:

It is determined whether the data format of the second database table is correct, and if the data format of the second database table is incorrect, a database format error prompt is issued.
A non-volatile readable storage medium having computer readable instructions stored on the non-volatile readable storage medium, characterized in that, when the computer readable instructions are executed by a processor, the following steps are implemented:

Obtain the SQL file of the software project;

Extracting all the first data columns in the SQL file and the first database table where the first data columns are located;

Querying all the second data columns in the database connected to the software project and the second database table where the second data columns are located;

Judging whether the first database table is included in the second database table;

If the first database table is not included in the second database table, output the database tables that exist in the first database table but do not exist in the second database table;

Determining whether the first data column is included in the second data column, and determining whether the first database table where the first data column is located is consistent with the second database table where the second data column is located;

If the first data column is not included in the second data column, and/or the first database table where the first data column is located is inconsistent with the second database table where the second data column is located, then output A data column that exists in the first data column but does not exist in the second data column, and/or the first data in the first database table where the output is located is inconsistent with the second database table where the second data column is located Column

If the first database table is not included in the second database table, or the first data column is not included in the second data column, or the first database table in which the first data column is located and If the second database table where the second data column is located is inconsistent, a table structure file of the database is generated;

Modify the SQL file according to the table structure file.
15. The storage medium according to claim 15, wherein when the computer-readable instructions are executed by a processor to implement the obtaining of the SQL file of the software project, the method comprises:

Generate a SQL file configuration interface, receive the software project path set by the user in the SQL file configuration interface, and obtain the SQL file according to the software project path.
The storage medium of claim 15, wherein the computer-readable instructions are executed by a processor to implement the extraction of all the first data columns in the SQL file and the first data column where the first data columns are located. A database table includes:

Searching for the target code according to the tags in the SQL file;

The first data column and the first database table are extracted according to the keywords in the target code.
The storage medium according to claim 15, wherein the computer-readable instructions are executed by a processor to implement the query for all the second data columns and the second data columns in the database connected to the software project When the second database table is located, it includes:

Acquiring data source information of the software project;

Establish a connection with the database according to the data source information;

The SQL query statement is executed to query all the second data columns in the database and the second database table where the data columns are located.
15. The storage medium of claim 15, wherein when the computer-readable instructions are executed by a processor to realize the generation of the table structure file of the database, the method comprises:

Read the database script of the database, and parse the database script into the corresponding java entity class;

The table structure file is generated according to the java entity class.
18. The storage medium according to any one of claims 15-19, wherein the computer-readable instructions further implement the following steps when being executed by the processor:

It is determined whether the data format of the second database table is correct, and if the data format of the second database table is incorrect, a database format error prompt is issued.