Data processing method and apparatus, and computer-readable storage medium

By acquiring and parsing multi-dimensional information from database change records, the problem of existing tools being unable to intuitively view version change records has been solved, enabling intuitive evaluation and efficient development of database change records.

CN116775651BActive Publication Date: 2026-02-10CHINA MERCHANTS BANK
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202310694410.X
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-06-12
Publication Date
2026-02-10
Estimated Expiration
2043-06-12

AI Technical Summary

Technical Problem

Existing database version control tools cannot intuitively and visually view version change records, which affects the efficiency of software version development.

Method used

By obtaining the database configuration and table structure information of the script to be changed, parsing the script content and Git commit information, identifying database change records from multiple dimensions, and storing them as an HTML file for easy and intuitive viewing.

Benefits of technology

It improves software version development efficiency, reduces manual workload, and enables intuitive evaluation of version change records.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116775651B_ABST
    Figure CN116775651B_ABST
Patent Text Reader

Abstract

The application discloses a data processing method and device and a computer readable storage medium, and the method comprises the following steps: determining a target management project in a to-be-managed project, and obtaining to-be-changed script information corresponding to the target management project; obtaining database configuration information corresponding to the to-be-changed script information, obtaining a table in a database corresponding to the to-be-changed script information based on the database configuration information, and obtaining table structure information corresponding to the table; obtaining script content corresponding to the to-be-changed script information, a database table name of an operation and Git submission information, determining a plurality of dimensional database change records corresponding to the to-be-changed script information, and deploying the database change records. According to the to-be-changed script information of the target management project, the database change records can be obtained, so that the database change records can be intuitively viewed, and the online version can be evaluated through the database change records before the version is put online, the artificial workload is reduced, and the development efficiency of the software version is improved.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data processing, and in particular to a data processing method, device and computer readable storage medium. BACKGROUND

[0002] In the software development process, as the business requirements change, the structure and data of the database will also change continuously, which may lead to unpredictable consequences such as data conflicts, data inconsistencies and the like. In view of these problems, some database version management tools such as Flyway, Liquibase and DBDeploy appear, which control the version changes of the database, and through the management of version control scripts in the database, the changes of the database can be tracked and deployed in different environments. At the same time, it can also automatically run the upgrade script when the application is started, to ensure that the structure and data of the database are consistent with the version of the application, and to facilitate the management of the structure and data changes of the database, so that the database changes are more controllable, safe and reliable.

[0003] The existing database version control tools only record the version change records and the change content of each version of the database, and the change content only exists in the source code, and the change version is stored in the database, so it is impossible to view the version change records through an intuitive visual page, and it is necessary to develop and view all the data tables of each database before going online to evaluate, which affects the software version development efficiency.

[0004] The above content is only used to assist in understanding the technical solutions of the present application and does not represent the acknowledgement of the above content as prior art. SUMMARY

[0005] The main purpose of the present application is to provide a data processing method, device and computer readable storage medium, which aims to solve the technical problem that the existing software version changes cannot view the version change records.

[0006] To achieve the above purpose, the present application provides a data processing method, which comprises the following steps:

[0007] Determine the target management project in the to-be-managed project, and obtain the to-be-changed script information corresponding to the target management project based on the Git remote address of the target management project;

[0008] Obtain the database configuration information corresponding to the to-be-changed script information, and obtain the table in the database corresponding to the to-be-changed script information and the table structure information corresponding to the table based on the database configuration information;

[0009] Obtain the script content corresponding to the to-be-changed script information, the database table name of the operation and the Git commit information;

[0010] Based on the table, table structure information, script content, database table name and Git commit information, determine the database change record of multiple dimensions corresponding to the to-be-changed script information, and deploy the database change record.

[0011] Further, the step of obtaining the database configuration information corresponding to the to-be-changed script information, and obtaining the table in the database corresponding to the to-be-changed script information and the table structure information corresponding to the table based on the database configuration information comprises:

[0012] Scanning the project configuration file corresponding to the target management project to obtain the database configuration information;

[0013] Parsing the database configuration information to obtain parsing information;

[0014] Obtaining the table in the database and the table structure information corresponding to the table based on the parsing information.

[0015] Further, the step of obtaining the table in the database and the table structure information corresponding to the table based on the parsing information comprises:

[0016] Connecting the database based on the database connection information in the parsing information;

[0017] Obtaining the table in the database and the table structure information corresponding to the table based on the username and password in the parsing information.

[0018] Further, the step of obtaining the script content corresponding to the to-be-changed script information, the database table name and the Git commit information comprises:

[0019] Parsing the to-be-changed script information to obtain the script content and the database table name;

[0020] Based on the commit record corresponding to the to-be-changed script information, obtaining the Git commit information.

[0021] Further, the Git commit information comprises the committer information, the commit note information, the committer mailbox and the commit CommitId corresponding to the to-be-changed script information.

[0022] Further, the step of determining the database change record of multiple dimensions corresponding to the to-be-changed script information based on the table, table structure information, script content, database table name and Git commit information, and deploying the database change record comprises:

[0023] The table, table structure information, script content, database table name and Git commit information are classified and arranged to obtain database change records in multiple dimensions, wherein the dimensions include a data table, an online version and a database;

[0024] The database change records are deployed.

[0025] Further, the step of deploying the database change records comprises:

[0026] The database change records are stored into a text file in a preset format;

[0027] The text file is converted into an Html format file, and the Html format file is deployed.

[0028] Further, the step of determining a target management project in the to-be-managed projects comprises:

[0029] The target management project in the to-be-managed projects is determined at a time; or,

[0030] A management project in the to-be-managed projects that has script update is taken as the target management project.

[0031] In addition, to achieve the above object, the present application further provides a data processing device, which comprises:

[0032] A memory, a processor and a data processing program stored in the memory and executable on the processor, wherein the data processing program, when executed by the processor, implements the steps of the foregoing data processing method.

[0033] In addition, to achieve the above object, the present application further provides a computer readable storage medium, wherein the readable storage medium stores a data processing program, and the data processing program, when executed by a processor, implements the steps of the foregoing data processing method.

[0034] The application determines a target management project in a to-be-managed project, and obtains to-be-changed script information corresponding to the to-be-managed project based on a Git remote address of the target management project; then, database configuration information corresponding to the to-be-changed script information is obtained, and based on the database configuration information, a table in a database corresponding to the to-be-changed script information and table structure information corresponding to the table are obtained; then, script content corresponding to the to-be-changed script information, an operated database table name, and Git commit information are obtained; then, based on the table, the table structure information, the script content, the database table name, and the Git commit information, a plurality of dimensions of database change records corresponding to the to-be-changed script information are determined, and the database change records are deployed, so that the database change records can be obtained according to to-be-changed script information of a target management project, the database change records can be intuitively viewed, and the online version can be evaluated through the database change records before the version is online, so that the artificial workload is reduced and the development efficiency of the software version is improved. BRIEF DESCRIPTION OF DRAWINGS

[0035] Figure 1 is a structural schematic diagram of a data processing device in a hardware running environment related to an embodiment scheme of the application.

[0036] Figure 2 is a flowchart of a data processing method according to a first embodiment of the application.

[0037] The implementation, functional features and advantages of the application will be further described with reference to the embodiments and the accompanying drawings. DETAILED DESCRIPTION

[0038] It should be understood that the specific embodiments described herein are merely intended to explain the application, and are not intended to limit the application.

[0039] As shown in Figure 1 , the hardware running environment related to the embodiment scheme of the application includes a data processing device. Figure 1 is a structural schematic diagram of a data processing device in a hardware running environment related to an embodiment scheme of the application.

[0040] The data processing device according to the embodiment of the application can be a PC, or a smart phone, a tablet computer, an e-book reader, an MP3 (Moving Picture Experts Group Audio Layer III) player, an MP4 (Moving Picture Experts Group Audio Layer IV) player, a portable computer, or other movable terminal devices with a display function.

[0041] As shown in Figure 1As shown, the data processing apparatus can include a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, and a communication bus 1002. The communication bus 1002 is used to realize the connection communication between the components. The user interface 1003 can include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 can also include a standard wired interface, a wireless interface. The network interface 1004 can optionally include a standard wired interface, a wireless interface (such as a WI-FI interface). The memory 1005 can be a high-speed RAM memory, or a stable memory (non-volatile memory) such as a disk memory. The memory 1005 can also be an independent storage device from the aforementioned processor 1001.

[0042] Optionally, the data processing apparatus can also include a camera, an RF (Radio Frequency, radio frequency) circuit, a sensor, an audio circuit, a WiFi module, and the like. Among them, the sensor is, for example, a light sensor, a motion sensor, and other sensors. Of course, the data processing apparatus can also be configured with a gyroscope, a barometer, a hygrometer, a thermometer, an infrared sensor, and other sensors, which will not be described here.

[0043] Those skilled in the art can understand that Figure 1 The terminal structure shown in the figure does not constitute a limitation on the data processing apparatus, and can include more or fewer components than the figure, or combine certain components, or different component arrangements.

[0044] As Figure 1 As shown, the memory 1005 as a computer storage medium can include an operating system, a network communication module, a user interface module, and a data processing program.

[0045] In Figure 1 In the data processing apparatus shown, the network interface 1004 is mainly used to connect the background server and communicate data with the background server; the user interface 1003 is mainly used to connect the client (user end) and communicate data with the client; and the processor 1001 can be used to call the data processing program stored in the memory 1005.

[0046] In this embodiment, the data processing apparatus includes a memory 1005, a processor 1001, and a data processing program stored in the memory 1005 and executable on the processor 1001, wherein when the processor 1001 calls the data processing program stored in the memory 1005, the following operations are performed:

[0047] determine a target management project in the to-be-managed projects, and acquire to-be-changed script information corresponding to the target management project based on a Git remote address of the target management project;

[0048] acquire database configuration information corresponding to the to-be-changed script information, and acquire a table in a database corresponding to the to-be-changed script information and table structure information corresponding to the table based on the database configuration information;

[0049] acquire script content corresponding to the to-be-changed script information, a database table name of an operation, and Git commit information;

[0050] determine a plurality of dimensional database change records corresponding to the to-be-changed script information based on the table, the table structure information, the script content, the database table name, and the Git commit information, and deploy the database change records.

[0051] Further, the processor 1001 can invoke a data processing program stored in the memory 1005, and further perform the following operations:

[0052] scan a project configuration file corresponding to the target management project to obtain the database configuration information;

[0053] parse the database configuration information to obtain parsing information;

[0054] acquire the table in the database and the table structure information corresponding to the table based on the parsing information.

[0055] Further, the processor 1001 can invoke a data processing program stored in the memory 1005, and further perform the following operations:

[0056] connect the database based on database connection information in the parsing information;

[0057] acquire the table in the database and the table structure information corresponding to the table based on a username and a password in the parsing information.

[0058] Further, the processor 1001 can invoke a data processing program stored in the memory 1005, and further perform the following operations:

[0059] parse the to-be-changed script information to obtain the script content and the database table name;

[0060] acquire the Git commit information based on commit records corresponding to the to-be-changed script information.

[0061] Further, the processor 1001 can invoke a data processing program stored in the memory 1005, and further perform the following operations:

[0062] The table, table structure information, script content, database table name and Git commit information are classified and arranged to obtain database change records in multiple dimensions, wherein the dimensions include a data table, an online version and a database.

[0063] The database change records are deployed.

[0064] Further, the processor 1001 can call the data processing program stored in the memory 1005, and further perform the following operations:

[0065] The database change records are stored into a text file in a preset format;

[0066] The text file is converted into an Html format file, and the Html format file is deployed.

[0067] Further, the processor 1001 can call the data processing program stored in the memory 1005, and further perform the following operations:

[0068] The target management item in the to-be-managed item is determined in a time manner; or,

[0069] The management item with script update in the to-be-managed item is taken as the target management item.

[0070] The application further provides a data processing method, referring to Figure 2 , Figure 2 The flowchart of the first embodiment of the data processing method is shown.

[0071] In this embodiment, the data processing method comprises the following steps:

[0072] In step S101, the target management item in the to-be-managed item is determined, and the to-be-changed script information corresponding to the target management item is obtained based on the Git remote address of the target management item.

[0073] In this embodiment, the to-be-managed item comprises management items of multiple online software, and for each online software, the scripts related to the online version of the software are uniformly placed in a directory, and the directory name is determined according to the development mode. If the project is developed in a branch, the directory is directly created according to the branch name, and if the project is developed in master, the directory is created according to the configured name. Meanwhile, the Git (version control) remote address of the to-be-managed item is configured on the server.

[0074] The server can determine a target management project in the to-be-managed projects in real time or at a timing, after determining the target management project, obtain a Git remote address of the target management project, obtain to-be-changed script information corresponding to the to-be-managed project through the Git remote address, and specifically, the to-be-changed script information is the latest script code, that is, script code stored after the last time the to-be-changed script information of the target management project is obtained.

[0075] Further, in a possible implementation, the step S101 comprises:

[0076] Step S1011, determining a target management project in the to-be-managed projects at a timing; or,

[0077] Step S1012, taking a management project with script update in the to-be-managed projects as the target management project.

[0078] In the embodiment, the target management project in the to-be-managed projects can be determined at a timing, for example, for multiple management projects in the to-be-managed projects, the order of each management project is set, the target management project in the to-be-managed projects is determined at a timing according to the order, and then the to-be-changed script information corresponding to the target management project is obtained based on the Git remote address of the target management project. If the to-be-changed script information is not obtained, that is, there is no version update in the target management project currently, the process is ended.

[0079] Alternatively, when there is script update in multiple management projects in the to-be-managed projects, the server obtains script update information of the management project. At this time, the management project with script update in the to-be-managed projects is taken as the target management project, and then the to-be-changed script information corresponding to the target management project is obtained based on the Git remote address of the target management project.

[0080] Step S102, obtaining database configuration information corresponding to the to-be-changed script information, and obtaining a table in a database corresponding to the to-be-changed script information and table structure information corresponding to the table based on the database configuration information;

[0081] In the embodiment, when the to-be-changed script information is obtained, the database configuration information corresponding to the to-be-changed script information is obtained, and the table in the database corresponding to the to-be-changed script information and the table structure information corresponding to the table are obtained based on the database configuration information. For example, the database URL, that is, the database connection information, corresponding to the to-be-changed script information is obtained through the database configuration information, and the table in the database and the table structure information corresponding to the table are obtained in the corresponding database through the database connection information.

[0082] Step S103, obtaining script content corresponding to the to-be-changed script information, a database table name of operation, and Git submission information;

[0083] In this embodiment, when the to-be-changed script information is obtained, the script content corresponding to the to-be-changed script information, the database table name of the operation, and the Git commit information are obtained. Specifically, each SQL script of the to-be-changed script information is parsed to obtain the SQL script content (script content) and the database table name of the operation, and the Git commit information is obtained based on the commit record of each SQL script.

[0084] In step S104, based on the table, the table structure information, the script content, the database table name, and the Git commit information, the database change record of multiple dimensions corresponding to the to-be-changed script information is determined, and the database change record is deployed.

[0085] In this embodiment, after obtaining the table, the table structure information, the script content, the database table name, and the Git commit information, based on the table, the table structure information, the script content, the database table name, and the Git commit information, the database change record of multiple dimensions corresponding to the to-be-changed script information is determined. Specifically, the table, the table structure information, the script content, the database table name, and the Git commit information are classified and arranged to be processed in the dimensions of the data table, the online version, and the database, to obtain the multi-dimensional structured database change record, and the database change record (version change record) is deployed, that is, the database change record is deployed on the server, so as to view the database change record.

[0086] The data processing method provided in this embodiment includes the following steps: determining a target management project in a to-be-managed project, and obtaining to-be-changed script information corresponding to the to-be-managed project based on a Git remote address of the target management project; then obtaining database configuration information corresponding to the to-be-changed script information, and obtaining a table in a database corresponding to the to-be-changed script information and table structure information corresponding to the table based on the database configuration information; then obtaining script content corresponding to the to-be-changed script information, a database table name of an operation, and Git commit information; and then determining a database change record of multiple dimensions corresponding to the to-be-changed script information based on the table, the table structure information, the script content, the database table name, and the Git commit information, and deploying the database change record. The database change record can be obtained according to the to-be-changed script information of the target management project, so as to intuitively view the database change record, and the online version can be evaluated through the database change record before the version is online, thereby reducing the manual workload and improving the development efficiency of the software version.

[0087] Based on the first embodiment, a second embodiment of the data processing method of the present application is provided. In this embodiment, step S102 includes:

[0088] In step S201, the project configuration file corresponding to the target management project is scanned to obtain the database configuration information.

[0089] In step S202, the database configuration information is parsed to obtain parsing information.

[0090] In step S203, the table in the database and the table structure information corresponding to the table are obtained based on the parsing information.

[0091] In this embodiment, when the to-be-changed script information is obtained, the database configuration information corresponding to the to-be-changed script information is obtained. Specifically, the server scans the project configuration file corresponding to the target management project to obtain the database configuration information.

[0092] In this embodiment, after the database configuration information is obtained, the database configuration information is parsed to obtain parsing information. The parsing information can include the database URL, the username, and the password of each environment corresponding to the to-be-changed script information.

[0093] In this embodiment, after the parsing information is obtained, the table in the database and the table structure information corresponding to the table are obtained based on the parsing information. Further, in a possible implementation manner, the step S203 includes:

[0094] In step S2031, the database is connected based on the database connection information in the parsing information.

[0095] In step S2032, the table in the database and the table structure information corresponding to the table are obtained based on the username and the password in the parsing information.

[0096] In this embodiment, after the parsing information is obtained, the database connection information (database URL) in the parsing information is obtained, and the database is connected based on the database connection information.

[0097] Then, the username and the password in the parsing information are obtained, and the table in the database and the table structure information corresponding to the table are obtained based on the username and the password in the parsing information. If the password in the parsing information is an encrypted password, the encrypted password is decrypted according to an encryption algorithm and a key to obtain the password, and then the table in the database and the table structure information corresponding to the table are obtained based on the username and the password.

[0098] The data processing method provided in the embodiment can accurately obtain the table in the database corresponding to the to-be-changed script information and the table structure information corresponding to the table through the database configuration information, thereby improving the accuracy of the database change record, obtaining the database change record according to the to-be-changed script information of the target management project, facilitating intuitive viewing of the database change record, and further evaluating the online version through the database change record before the version goes online, reducing the manual workload, and improving the development efficiency of the software version.

[0099] Based on the first embodiment, a third embodiment of the data processing method is provided.

[0100] In step S301, the to-be-changed script information is parsed to obtain the script content and the database table name.

[0101] In step S302, the Git commit information is obtained based on the commit record corresponding to the to-be-changed script information.

[0102] In the embodiment, when the to-be-changed script information is obtained, the to-be-changed script information is parsed to obtain the script content and the database table name. Specifically, the server can parse each SQL script in the to-be-changed script information to obtain the SQL script content (script content) and the database table name of the operation.

[0103] Then, the server obtains the Git commit information based on the commit record corresponding to the to-be-changed script information. Specifically, the server first obtains the commit record corresponding to the to-be-changed script information, which includes the commit record of each SQL script in the to-be-changed script information. For example, the commit record corresponding to the to-be-changed script information can be obtained through Git Log, and the Git commit information is obtained based on the commit record. The Git commit information includes the Git commit information of each SQL script in the to-be-changed script information.

[0104] The Git commit information includes the committer information, the commit note information, the committer mailbox, and the commit CommitId corresponding to the to-be-changed script information.

[0105] The data processing method provided in the embodiment can accurately obtain the Git submission information, the script content and the database table name through the analysis on the to-be-changed script information, and then improve the accuracy of the database change record. The database change record can be obtained according to the to-be-changed script information of the target management project, so that the database change record can be intuitively viewed, and the online version can be evaluated through the database change record before the version is online, thereby reducing the manual workload and improving the development efficiency of the software version.

[0106] Based on the first embodiment, a fourth embodiment of the data processing method is provided. In the fourth embodiment, step S104 includes:

[0107] In step S401, the table, the table structure information, the script content, the database table name and the Git submission information are classified and arranged to obtain a plurality of dimensional database change records, wherein the dimensions include a data table, an online version and a database.

[0108] In step S402, the database change record is deployed.

[0109] In the embodiment, after the table, the table structure information, the script content, the database table name and the Git submission information are obtained, the table, the table structure information, the script content, the database table name and the Git submission information are classified and arranged in the dimensions of the data table, the online version and the database to obtain a multi-dimensional structured database change record, and the database change record (version change record) is deployed, that is, the database change record is deployed on a server so as to view the database change record.

[0110] Further, in a possible implementation, step S402 includes:

[0111] In step S4021, the database change record is stored in a text file in a preset format.

[0112] In step S4023, the text file is converted into an Html format file, and the Html format file is deployed.

[0113] In the embodiment, after the database change record is obtained, the database change record is stored in a text file in a preset format, for example, the database change record is stored in a text file in a MarkDown format.

[0114] In this embodiment, after obtaining the text file, the text file is converted into an HTML file and deployed. Specifically, a conversion tool is used to convert the Markdown text file into an HTML file and deploy the HTML file on the server so that the database change record can be viewed intuitively and visually through a webpage.

[0115] The data processing method proposed in this embodiment classifies and organizes the tables, table structure information, script content, database table names, and Git commit information to obtain database change records in multiple dimensions, including data tables, online versions, and databases. These database change records are then deployed to facilitate intuitive and visual viewing via a webpage. This allows for the evaluation of the online version before its release, reducing manual workload and improving software development efficiency.

[0116] Furthermore, embodiments of the present invention also propose a computer-readable storage medium storing a data processing program, which, when executed by the processor, implements the steps of the data processing method described above.

[0117] It should be noted that, in this document, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or system. Unless otherwise specified, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or system that includes that element.

[0118] The sequence numbers of the above embodiments of the present invention are for descriptive purposes only and do not represent the superiority or inferiority of the embodiments.

[0119] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) as described above, and includes several instructions to cause a terminal device (which may be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in the various embodiments of the present invention.

[0120] The above are merely preferred embodiments of the present invention and do not limit the scope of the patent. Any equivalent structural or procedural transformations made based on the description and drawings of the present invention, or direct or indirect applications in other related technical fields, are similarly included within the scope of patent protection of the present invention.

Claims

1. A data processing method, characterized in that, The data processing method includes the following steps: Identify the target management project in the project to be managed, and obtain the script information to be changed corresponding to the target management project based on the Git remote address of the target management project; Obtain the database configuration information corresponding to the script information to be changed, and obtain the table in the database corresponding to the script information to be changed and the table structure information corresponding to the table based on the database configuration information; Obtain the script content, database table name, and Git commit information corresponding to the script information to be changed; The steps of obtaining the script content, database table name, and Git commit information corresponding to the script information to be changed include: The script information to be modified is parsed to obtain the script content and database table names; Based on the commit record corresponding to the script information to be changed, the Git commit information is obtained, wherein the Git commit information includes the committer information, commit notes, committer email, and commitId corresponding to the script information to be changed; Based on the table, table structure information, script content, database table name, and Git commit information, determine the database change records for multiple dimensions corresponding to the script information to be changed, and deploy the database change records. The step of determining multiple dimensions of database change records corresponding to the script information to be changed based on the table, table structure information, script content, database table name, and Git commit information, and deploying the database change records, includes: The tables, table structure information, script content, database table names, and Git commit information are categorized and organized to obtain database change records in multiple dimensions, including data tables, online versions, and databases. Deploy the database change records; The step of deploying the database change records includes: The database change records are stored in a text file with a preset format; Convert the text file to HTML format and deploy the HTML file.

2. The data processing method as described in claim 1, characterized in that, The steps of obtaining the database configuration information corresponding to the script information to be modified, and obtaining the table in the database corresponding to the script information to be modified and the table structure information corresponding to the table based on the database configuration information, include: Scan the project configuration file corresponding to the target management project to obtain the database configuration information; Parse the database configuration information to obtain parsing information; Based on the parsed information, obtain the tables in the database and the table structure information corresponding to the tables.

3. The data processing method as described in claim 2, characterized in that, The step of obtaining the tables in the database and the table structure information corresponding to the tables based on the parsed information includes: Connect to the database based on the database connection information in the parsed information; Based on the username and password in the parsed information, the tables in the database and the corresponding table structure information are obtained.

4. The data processing method according to any one of claims 1 to 3, characterized in that, The steps for determining the target management projects in the projects to be managed include: Periodically determine the target management items among the projects to be managed; or, The management project that has script updates among the projects to be managed is designated as the target management project.

5. A data processing apparatus, characterized in that, The data processing apparatus includes: a memory, a processor, and a data processing program stored in the memory and executable on the processor, wherein when the data processing program is executed by the processor, it implements the steps of the data processing method as described in any one of claims 1 to 4.

6. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a data processing program, which, when executed by a processor, implements the steps of the data processing method as described in any one of claims 1 to 4.

Citation Information

Patent Citations

  • Method and device for generating database change file

    CN108491218A

  • Data lake updating processing method and device, storage medium and electronic device

    CN113934706A