CN115437638A - Interface changing method, device, equipment, medium and program product - Google Patents

Interface changing method, device, equipment, medium and program product Download PDF

Info

Publication number
CN115437638A
CN115437638A CN202210868661.0A CN202210868661A CN115437638A CN 115437638 A CN115437638 A CN 115437638A CN 202210868661 A CN202210868661 A CN 202210868661A CN 115437638 A CN115437638 A CN 115437638A
Authority
CN
China
Prior art keywords
change
list
data
interface
data dictionary
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202210868661.0A
Other languages
Chinese (zh)
Inventor
匡亚明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bank of China Financial Technology Co Ltd
Original Assignee
Bank of China Financial Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Bank of China Financial Technology Co Ltd filed Critical Bank of China Financial Technology Co Ltd
Priority to CN202210868661.0A priority Critical patent/CN115437638A/en
Publication of CN115437638A publication Critical patent/CN115437638A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/40—Transformation of program code
    • G06F8/41—Compilation
    • G06F8/42—Syntactic analysis
    • G06F8/427—Parsing
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10—File systems; File servers
    • G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/40—Transformation of program code
    • G06F8/41—Compilation
    • G06F8/44—Encoding
    • G06F8/447—Target code generation

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Software Systems (AREA)
  • Human Computer Interaction (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides an interface changing method, device, equipment, medium and program product, comprising: acquiring a data dictionary and a change requirement table issued at the upstream, analyzing the data dictionary and the change requirement table, and acquiring an analyzed data dictionary List set and an analyzed change requirement List List; verifying the List of the change requirements respectively based on the data dictionary List set and the preset database, and removing invalid change data in the List of the change requirements after the verification is passed to obtain verified valid change data; the effective change data are recorded into the preset sql file based on the preset code file to obtain a target sql file, and interface change is carried out according to the target sql file, so that the interface change method provided by the invention reduces repeated labor of personnel, reduces the time cost process of manual operation, avoids errors caused by the manual operation, and further improves the interface change efficiency.

Description

Interface changing method, device, equipment, medium and program product
Technical Field
The present invention relates to the field of computer communications technologies, and in particular, to an interface changing method, apparatus, device, medium, and program product.
Background
As a downstream interface platform, an interface change document issued by an upstream can be frequently received, and the downstream needs to develop various interface changes such as new form connection, field length change, range change and the like according to the cooperation of the document. Such development is often a batch, highly repetitive, frequent job.
However, in the existing scheme, the operation labor cost is very high, the number of fields of a newly accessed table is different from dozens to hundreds, each field needs table building statements, and repeated input is needed in SQL statement configuration, so that manual processing is time-consuming and labor-consuming, input is easy to miss, and the error rate is high.
Disclosure of Invention
The invention provides an interface changing method, an interface changing device, equipment, a medium and a program product, which are used for overcoming the defects of high time cost and high error rate caused by manually configuring interface parameters according to an interface changing document in the prior art, realizing the time cost process of reducing manual operation, avoiding errors generated by the manual operation and further improving the interface changing efficiency.
The invention provides an interface changing method, which comprises the following steps:
acquiring a data dictionary and a change requirement table issued at the upstream, analyzing the data dictionary and the change requirement table, and acquiring an analyzed data dictionary List set and an analyzed change requirement List List;
verifying the List of the change requirements respectively based on the data dictionary List set and a preset database, and removing invalid change data in the List of the change requirements after verification is passed to obtain verified valid change data;
and recording the effective change data into a preset sql file to obtain a target sql file, and changing an interface according to the target sql file.
According to an interface changing method provided by the present invention, the checking the List of change requirements based on the data dictionary List set and the preset database respectively comprises:
checking whether the data dictionary List set comprises the changed data in the change requirement List List or not;
and checking whether the preset database comprises a change interface in the List of the change requirements or not.
According to an interface changing method provided by the present invention, after the checking the List of change requirements based on the data dictionary List set and the preset database, respectively, the method further includes:
generating a first check log corresponding to the change demand List List and the data dictionary List set;
and generating a second check log corresponding to the change demand List List and the preset database.
According to an interface changing method provided by the present invention, after the invalid change data in the change requirement List is removed after the verification is passed, the method further includes:
and under the condition that the change demand List List is a change demand List List of a change interface, querying a preset database to perform nested circular sequencing verification on the field sequence in the change demand List List.
According to an interface change method provided by the invention, the acquiring of the data dictionary and the change requirement table issued upstream comprises the following steps:
generating a first download path corresponding to the data dictionary and a second download path corresponding to the change demand table based on a preset configuration file;
and acquiring a data dictionary issued at the upstream based on the first download path, and acquiring the data dictionary issued at the upstream based on the second download path.
According to the interface changing method provided by the present invention, the recording the effective change data into a preset sql file to obtain a target sql file further includes:
executing the effective change data to obtain at least one sql change statement;
and recording the sql change statement into a preset sql file to obtain a target sql file.
The present invention also provides an interface changing apparatus, comprising:
the analysis unit is used for acquiring a data dictionary and a change requirement table issued upstream, analyzing the data dictionary and the change requirement table and acquiring an analyzed data dictionary List set and an analyzed change requirement List List;
the verification unit is used for verifying the List of the change requirements respectively based on the data dictionary List set and a preset database, and removing invalid change data in the List of the change requirements after verification is passed to obtain verified valid change data;
and the changing unit is used for recording the effective changed data into a preset sql file to obtain a target sql file, and changing an interface according to the target sql file.
The present invention also provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements any of the above interface changing methods when executing the program.
The present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements an interface changing method as described in any of the above.
The present invention also provides a computer program product comprising a computer program which, when executed by a processor, implements any of the interface changing methods described above.
According to the interface changing method, the device, the equipment, the medium and the program product, the data dictionary and the change requirement table issued upstream are obtained, the data dictionary and the change requirement table are analyzed, and the analyzed data dictionary List set and the analyzed change requirement List List are obtained; verifying the List of the change requirements respectively based on the data dictionary List set and the preset database, and removing invalid change data in the List of the change requirements after the verification is passed to obtain verified valid change data; the effective change data is recorded into the preset sql file based on the preset code file to obtain a target sql file, and the interface change is carried out according to the target sql file, so that the interface change method provided by the invention reduces the repeated labor of personnel, realizes the time cost process of manual operation, avoids the error caused by the manual operation, and further improves the interface change efficiency.
Drawings
In order to more clearly illustrate the technical solutions of the present invention or the prior art, the drawings needed for the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a flow chart of an interface modification method according to the present invention;
FIG. 2 is a schematic structural diagram of an interface modification apparatus according to the present invention;
fig. 3 is a schematic structural diagram of an electronic device provided in the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the present invention is mainly applied to interface development and change in a data set market associated with an interface platform. A data mart, also called a data market, is a repository that collects data from manipulated and other data sources that serve a particular group of professionals. Data is, in scope, extracted from an enterprise-wide database, a data warehouse, or a more specialized data warehouse.
In the operation and maintenance process of the data mart, the interface platform can frequently receive an interface change document issued upstream, for example, the interface change document for the original interface change, the interface change document for the newly added interface is applied according to the requirement, and the like, so that the interface of the data mart needs to be frequently changed.
In the existing scheme, a user needs to manually download related interface change documents, such as a data dictionary and a change requirement table, from an interface platform, and manually develop various interface changes according to the cooperation of the data dictionary and the change requirement table by the user, however, the operation repeatability is high, and the error rate is high.
An interface modification method of the present invention is described below with reference to fig. 1.
Fig. 1 is a schematic flow chart of an interface changing method provided by the present invention, as shown in fig. 1, the method includes:
step 100, acquiring a data dictionary and a change requirement table issued upstream, analyzing the data dictionary and the change requirement table, and acquiring an analyzed data dictionary List set and an analyzed change requirement List List;
where a data dictionary is a record that can access, record database and application metadata. The change request table is a table in which the interface to be changed and the interface change information related thereto are recorded. In other words, the change requirement table refers to an interface change document in a table form, and the data dictionary is a set recording descriptions of data objects and their related interface items in the interface change document.
In this embodiment, when the data dictionary and the change requirement table issued upstream are obtained, a first download path corresponding to the data dictionary and a second download path corresponding to the change requirement table may be generated based on the preset configuration file, and then the data dictionary issued upstream is obtained based on the first download path and the data dictionary issued upstream is obtained based on the second download path.
It should be noted that the preset configuration file in this embodiment is a yaml configuration file configured in advance by a user, where a path for generating the slq file, domestic and overseas information of an interface, a name of a newly added interface, a name of a changed interface, a data dictionary path, and a path of a change requirement table are recorded in the yaml configuration file.
In practical application, a user only needs to configure relevant configuration information in the yaml configuration file in advance, and then trigger the interface change program, and the interface change program automatically executes corresponding interface change flow steps based on the relevant configuration information configured in the yaml configuration file.
In addition, in the present application, a built-in method for dynamically loading the relevant dynamic loading class and function by using import is also needed, so that the processing flows such as interface change verification and the like are automatically performed by the built-in method for dynamically loading the relevant dynamic loading class and function by import, for example:
import com.szz.dao.impl.GbaseDaoImpl；
import com.szz.dao.impl.OracleDaoImpl；
import com.szz.excelread.ReadExcel；
import com.szz.utility.CheckTable；
import com.szz.utility.FileAbout；
import org.slf4j.Logger；
import org.slf4j.LoggerFactory
in addition, in this embodiment, the data dictionary and the change requirement table are analyzed by calling an easy excel open source tool. Specifically, the easy excel adopts a line-by-line analysis mode, and after the easy excel analyzes the data dictionary, a corresponding list set related to the interface information is returned.
And 200, verifying the List of the change requirements respectively based on the data dictionary List set and a preset database, and removing invalid change data in the List of the change requirements after the verification is passed to obtain verified valid change data.
In the invention, the interface tasks are divided into interface addition and interface change. The new increase of the interface refers to the addition of an interface which does not exist in the current data mart or an interface which does not exist in one database in the data mart. The interface change refers to the operation of changing other interface object information such as a new field and the like on the original existing interface.
In this step, the interface task can be identified by reading key information extracted from the change requirement table, such as key information including table name, field name of the table, table type, and table comment, as shown in the following code file:
HashMap<String,AlterTableConfig>mapA＝mapAlter.get(key)；
if ("() change literal name in data item) { mapa.put (" change chinese name ""); }
if ("(-) change maximum data length)") | | application type. Matches ("(-) change small bit length) (")) { mapa.put ("(change field length"); }
if (applied type. Matches ("(. One.) change data item english name)") { mapa.put ("change field name", alterTableConfig); }
if (applicable type. Matches ("(. One) () change data type)") { mapa.put ("change field type"); }
if (applied type. Matches ("(. One.)) mapa. Put (" change if primary key ", alterTableConfig); }
if ("() change increment/full ()) { mapa.put (" change increment full ", alterTableConfig); }
if ("() additional data item ())) { mapa.put (" additional data item ""); }
if ("() delete data item)") { mapa.put ("delete data item"); }
In this step, a double-layer map set is established, the key is the table name + the field is the first layer map, the value is the second layer map, wherein the key is the change type, including: changing the Chinese name of the data item, changing the English name of the data item, changing the maximum length of data, changing the data type, changing whether a primary key is used or not, and value is changed information, so that the interface task and related change information thereof can be analyzed through the information in the double-layer map set. And then after the interface tasks are read and identified by the key information, executing corresponding verification operation under each interface task.
It should be noted that the invalid change data in this embodiment refers to data that affects the automatic interface change, such as repeatedly executed change data and incomplete change data, and is not described in detail here.
Further, after the invalid change data in the change requirement List is removed after the verification is passed, the method further includes:
and under the condition that the change demand List List is a change demand List List of a change interface, inquiring a preset database to perform nested cyclic sequencing check on the field sequence in the change demand List List.
In this step, because the field order affects the change result of the interface change, in this embodiment, the field order in the data dictionary needs to be sequentially compared with the field order in the configuration table of the existing interface, specifically, the nested loop ordering comparison is performed by querying the database to read out the field order in the configuration table of the existing interface. In addition, the processing procedure of the nested loop sequencing comparison in the embodiment is consistent with that in the prior art, for example, the sequence of a newly added field needs to be judged, and if the newly added field is newly added at the end, the newly added field is directly added, and details are not repeated here.
And 300, recording the effective change data into a preset sql file to obtain a target sql file, and changing an interface according to the target sql file.
In this step, a path for generating the sql file needs to be read from the preset configuration file, and then the effective change data is recorded into the preset sql file according to the read path for generating the sql file, so as to automatically generate the target sql file.
Specifically, in this embodiment, the effective change data is executed first to obtain at least one sql change statement, and then the sql change statement is recorded in a preset sql file to obtain a target sql file. As shown in the following code file:
if(stringBuilders.size()＝＝2)
{FileAbout fileAbout＝new FileAbout()；
for(StringBuilder stringBuilder:stringBuilders)
{fileAbout.fileWrite(filePath,"\\gbase\\pub_rdm_ddl.sql",stringBuild er.toString())；}
info (key + "SQL statement for changing Chinese name is changed successfully normally"); catch (Exception e) { e.printstacktrace ();
error (key + "deal _1 changes SQL statement failure of Chinese name", e); }
The interface changing method provided by the invention obtains the data dictionary and the change requirement List issued upstream, analyzes the data dictionary and the change requirement List, and obtains the analyzed data dictionary List set and the analyzed change requirement List; verifying the List of the change requirements respectively based on the data dictionary List set and the preset database, and removing invalid change data in the List of the change requirements after the verification is passed to obtain verified valid change data; the effective change data are recorded into the preset sql file based on the preset code file to obtain a target sql file, and interface change is carried out according to the target sql file, so that the interface change method provided by the invention reduces repeated labor of personnel, reduces the time cost process of manual operation, avoids errors caused by the manual operation, and further improves the interface change efficiency.
Based on the above embodiments, the verifying the change requirement List based on the data dictionary List set and the preset database respectively includes:
checking whether the data dictionary List set comprises the changed data in the change requirement List List or not;
and checking whether the preset database comprises a change interface in the List of the change requirements or not.
In the step, whether the data dictionary comprises a newly added interface is checked according to an interface configured by a preset configuration file, and whether the interface exists is checked by checking a preset database.
Specifically, the change data includes a change field name, a change increment total, a change item, a newly added data item, and the like. In addition, in the embodiment, relevant change interface information is inquired in the database by changing the field Chinese comment table, the field and the change content.
Further, after the checking the List of change requirements based on the set of data dictionaries lists and a preset database, respectively, the method further includes:
generating a first check log corresponding to the change demand List List and the data dictionary List set;
and generating a second check log corresponding to the change demand List List and the preset database.
In this step, the check Log includes the check object and the check result related to the check object, specifically, in this embodiment, the Log information is controlled to be transmitted by using Log4j, for example: lse if (column. Size () > 1)
Error (key + "failure of verification of Chinese comments in changed field, there are multiple fields in database"); }
else { logger. Error (key + ' Chinese comment check failed in changed field, database this field can't be found ')
Therefore, the interface changing method provided by the invention can obtain the related automatic changing result through the verification log, and is convenient for a user to adjust the changing contents in the data dictionary and the changing demand table in time based on the verification log.
The following describes the interface changing device provided by the present invention, and the interface changing device described below and the interface changing method described above can be referred to correspondingly.
Referring to fig. 2, fig. 2 is a schematic structural diagram of an interface changing apparatus provided in the present invention, and as shown in fig. 2, the interface changing apparatus includes: the analysis unit 210 is configured to obtain a data dictionary and a change requirement table issued upstream, analyze the data dictionary and the change requirement table, and obtain an analyzed data dictionary List set and an analyzed change requirement List; the checking unit 220 is configured to check the List of change requirements based on the data dictionary List set and a preset database, and remove invalid change data in the List of change requirements after the check is passed, so as to obtain valid change data after the check; and a changing unit 230, configured to record the valid changed data into a preset sql file, obtain a target sql file, and perform interface change according to the target sql file.
Further, the checking unit 220 is further configured to check whether the data dictionary List set includes the change data in the change requirement List; and checking whether the preset database comprises a change interface in the List of the change requirements or not.
Further, the checking unit 220 is further configured to generate a first check log in which the List of change requirements corresponds to the List set of data dictionaries; and generating a second check log corresponding to the change demand List List and the preset database.
Further, the changing unit 230 is further configured to, when the change requirement List is a change requirement List of the change interface, query a preset database to perform nested circular sequencing check on a sequence of fields in the change requirement List.
Further, the parsing unit 210 is further configured to generate a first download path corresponding to the data dictionary and a second download path corresponding to the change requirement table based on a preset configuration file; and acquiring a data dictionary issued at the upstream based on the first download path, and acquiring the data dictionary issued at the upstream based on the second download path.
Further, the changing unit 230 is further configured to execute the valid changed data to obtain at least one sql change statement; and recording the sql change statement into a preset sql file to obtain a target sql file.
The invention provides an interface change device, which is used for acquiring a data dictionary and a change requirement table issued upstream, analyzing the data dictionary and the change requirement table and acquiring an analyzed data dictionary List set and a change requirement List List; verifying the List of the change requirements respectively based on the data dictionary List set and the preset database, and removing invalid change data in the List of the change requirements after the verification is passed to obtain verified valid change data; the effective change data is recorded into the preset sql file based on the preset code file to obtain a target sql file, and the interface change is carried out according to the target sql file, so that the interface change method provided by the invention reduces the repeated labor of personnel, realizes the time cost process of manual operation, avoids the error caused by the manual operation, and further improves the interface change efficiency.
Fig. 3 illustrates a physical structure diagram of an electronic device, which may include, as shown in fig. 3: a processor (processor) 310, a communication Interface (communication Interface) 320, a memory (memory) 330 and a communication bus 340, wherein the processor 310, the communication Interface 320 and the memory 330 communicate with each other via the communication bus 340. The processor 310 may call logic instructions in the memory 330 to perform an interface change method comprising: acquiring a data dictionary and a change requirement table issued at the upstream, analyzing the data dictionary and the change requirement table, and acquiring an analyzed data dictionary List set and an analyzed change requirement List List; verifying the List of the change requirements respectively based on the data dictionary List set and a preset database, and removing invalid change data in the List of the change requirements after verification is passed to obtain verified valid change data; and recording the effective change data into a preset sql file to obtain a target sql file, and changing an interface according to the target sql file.
In addition, the logic instructions in the memory 330 may be implemented in the form of software functional units and stored in a computer readable storage medium when the software functional units are sold or used as independent products. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, and various media capable of storing program codes.
In another aspect, the present invention also provides a computer program product, the computer program product including a computer program, the computer program being storable on a non-transitory computer-readable storage medium, the computer program being capable of executing, when executed by a processor, the interface changing method provided by the above methods, the method including: acquiring a data dictionary and a change requirement table issued at the upstream, analyzing the data dictionary and the change requirement table, and acquiring an analyzed data dictionary List set and an analyzed change requirement List List; checking the List of the change requirements respectively based on the data dictionary List set and a preset database, and removing invalid change data in the List of the change requirements after the checking is passed to obtain checked valid change data; and recording the effective change data into a preset sql file to obtain a target sql file, and changing an interface according to the target sql file.
In yet another aspect, the present invention also provides a non-transitory computer-readable storage medium having stored thereon a computer program, which when executed by a processor, implements a method for performing the interface change provided by the above methods, the method comprising: acquiring a data dictionary and a change requirement table issued at the upstream, analyzing the data dictionary and the change requirement table, and acquiring an analyzed data dictionary List set and an analyzed change requirement List List; checking the List of the change requirements respectively based on the data dictionary List set and a preset database, and removing invalid change data in the List of the change requirements after the checking is passed to obtain checked valid change data; and recording the effective change data into a preset sql file to obtain a target sql file, and changing an interface according to the target sql file.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. Based on the understanding, the above technical solutions substantially or otherwise contributing to the prior art may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method according to the various embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, and not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims (10)

1. An interface changing method, comprising:
acquiring a data dictionary and a change requirement table issued at the upstream, analyzing the data dictionary and the change requirement table, and acquiring an analyzed data dictionary List set and an analyzed change requirement List List;
verifying the List of the change requirements respectively based on the data dictionary List set and a preset database, and removing invalid change data in the List of the change requirements after verification is passed to obtain verified valid change data;
and recording the effective change data into a preset sql file to obtain a target sql file, and changing an interface according to the target sql file.
2. The method of claim 1, wherein the checking the List of change requirements based on the set of data dictionary lists and a predetermined database, respectively, comprises:
checking whether the data dictionary List set comprises the changed data in the change requirement List List or not;
and checking whether the preset database comprises a change interface in the List of the change requirements or not.
3. The interface change method according to claim 2, wherein after the checking the change requirement List based on the data dictionary List set and a predetermined database, respectively, further comprises:
generating a first check log corresponding to the change demand List List and the data dictionary List set;
and generating a second check log corresponding to the change demand List List and the preset database.
4. The interface change method according to claim 1, wherein after the checking passes and the removing of invalid change data in the change requirement List, the method further comprises:
and under the condition that the change demand List List is a change demand List List of a change interface, querying a preset database to perform nested circular sequencing verification on the field sequence in the change demand List List.
5. The interface changing method according to any one of claims 1 to 4, wherein the acquiring the data dictionary and the change requirement table issued upstream includes:
generating a first download path corresponding to the data dictionary and a second download path corresponding to the change demand table based on a preset configuration file;
and acquiring a data dictionary issued at the upstream based on the first download path, and acquiring the data dictionary issued at the upstream based on the second download path.
6. The interface changing method according to any one of claims 1 to 4, wherein the recording the valid change data into a preset sql file to obtain a target sql file further comprises:
executing the effective change data to obtain at least one sql change statement;
and recording the sql change statement into a preset sql file to obtain a target sql file.
7. An interface changing apparatus, comprising:
the analysis unit is used for acquiring a data dictionary and a change requirement table issued upstream, analyzing the data dictionary and the change requirement table and acquiring an analyzed data dictionary List set and an analyzed change requirement List List;
the checking unit is used for checking the List of the change requirements respectively based on the data dictionary List set and a preset database, and removing invalid change data in the List of the change requirements after the checking is passed to obtain checked valid change data;
and the changing unit is used for recording the effective changed data into a preset sql file to obtain a target sql file, and changing an interface according to the target sql file.
8. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the interface changing method according to any one of claims 1 to 6 when executing the program.
9. A non-transitory computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the interface changing method according to any one of claims 1 to 6.
10. A computer program product comprising a computer program, wherein the computer program, when executed by a processor, implements the interface changing method according to any one of claims 1 to 6.
CN202210868661.0A 2022-07-22 2022-07-22 Interface changing method, device, equipment, medium and program product Pending CN115437638A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210868661.0A CN115437638A (en) 2022-07-22 2022-07-22 Interface changing method, device, equipment, medium and program product

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210868661.0A CN115437638A (en) 2022-07-22 2022-07-22 Interface changing method, device, equipment, medium and program product

Publications (1)

Publication Number Publication Date
CN115437638A true CN115437638A (en) 2022-12-06

Family

ID=84240935

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210868661.0A Pending CN115437638A (en) 2022-07-22 2022-07-22 Interface changing method, device, equipment, medium and program product

Country Status (1)

Country Link
CN (1) CN115437638A (en)

Similar Documents

Publication Publication Date Title
CN111522816B (en) Data processing method, device, terminal and medium based on database engine
CN102073640B (en) Method, system and server for testing structured query language (SQL) statements
US20140310231A1 (en) System and method for automating data warehousing processes
US8904352B2 (en) Systems and methods for processing source code during debugging operations
CN111563051B (en) Crawler-based data verification method and device, computer equipment and storage medium
CN110795455A (en) Dependency relationship analysis method, electronic device, computer device and readable storage medium
KR20150042877A (en) Managing record format information
CN110427188B (en) Configuration method, device, equipment and storage medium of single-test assertion program
CN110543356A (en) abnormal task detection method, device and equipment and computer storage medium
US9706005B2 (en) Providing automatable units for infrastructure support
CN110704475A (en) Method and system for comparing ETL loading table structures
CN114461644A (en) Data acquisition method and device, electronic equipment and storage medium
CN113326247A (en) Cloud data migration method and device and electronic equipment
CN112328631A (en) Production fault analysis method and device, electronic equipment and storage medium
CN111611276A (en) Data query method, device and storage medium
CN111831536A (en) Automatic testing method and device
WO2021262283A1 (en) Reduced processing loads via selective validation specifications
CN112540925A (en) New characteristic compatibility detection system and method, electronic device and readable storage medium
CN115437638A (en) Interface changing method, device, equipment, medium and program product
CN107273293B (en) Big data system performance test method and device and electronic equipment
CN108536577B (en) Program code information processing method and device
CN116069628A (en) Intelligent-treatment software automatic regression testing method, system and equipment
CN113138974B (en) Method and device for detecting database compliance
CN115357625A (en) Structured data comparison method and device, electronic equipment and storage medium
CN111209765B (en) Method and device for identifying material bar code and terminal equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination