CN113434734A

CN113434734A - Method, device, equipment and storage medium for generating file and reading file

Info

Publication number: CN113434734A
Application number: CN202110693406.2A
Authority: CN
Inventors: 季景瑜
Original assignee: Weikun Shanghai Technology Service Co Ltd
Current assignee: Weikun Shanghai Technology Service Co Ltd
Priority date: 2021-06-22
Filing date: 2021-06-22
Publication date: 2021-09-24

Abstract

The application is applicable to the technical field of data processing, and provides a method, a device, equipment and a storage medium for generating a file and reading the file. The method comprises the following steps: acquiring an XML configuration file corresponding to a file to be processed; analyzing the XML configuration file to obtain file elements corresponding to the file to be processed; analyzing the file to be processed by using a template engine to obtain variable information; and correspondingly filling the variable information in the file header list and the file content list to generate a database file corresponding to the file to be processed. The method can generate the database file by analyzing the XML configuration file and the template engine without acquiring the original character string corresponding to each piece of data in the file to be processed, and the method for generating the database file can realize the purpose of quickly writing the file to be processed into the database without coding a large number of codes, thereby greatly improving the efficiency of generating the file, accelerating the development speed and reducing the economic cost.

Description

Method, device, equipment and storage medium for generating file and reading file

Technical Field

The present application belongs to the field of information processing technologies, and in particular, to a method, an apparatus, a device, and a storage medium for generating a file and reading a file.

Background

In the prior art, when a database document is generated, an original character string corresponding to each piece of data in a file is usually obtained, and the file is generated in an original character string splicing manner. Similarly, when reading a file in the database, the original character string corresponding to each piece of data in the file also needs to be read. The mode of generating and reading the file is easy to generate the conditions of dislocation, the number of file columns not conforming to the expectation and the like, the file is difficult to verify, the generated or read file is easy to make mistakes, and the accuracy rate is low. And a large amount of codes need to be written, the code quality is poor, the economic cost is high, and the efficiency of generating a file or reading the file is low.

Disclosure of Invention

In view of this, embodiments of the present application provide a method, an apparatus, a device, and a storage medium for generating a file and reading a file, so as to solve the problems that, in the existing manner of generating a database document and reading a file in a database, the generated or read file is prone to error, has low accuracy, needs to write a large number of codes, has poor code quality, is high in economic cost, and has low file generation or file reading efficiency.

A first aspect of an embodiment of the present application provides a method for generating a file, where the method includes:

acquiring an XML configuration file corresponding to a file to be processed;

analyzing the XML configuration file to obtain file elements corresponding to the file to be processed, wherein the file elements comprise a file header list and a file content list;

analyzing the file to be processed by using a template engine to obtain variable information, wherein the variable information comprises: file header information corresponding to the file header list and file content information corresponding to the file content list;

and correspondingly filling the variable information in the file header list and the file content list to generate a database file corresponding to the file to be processed.

Optionally, the obtaining of the XML configuration file corresponding to the file to be processed includes:

acquiring a file type of the file to be processed, wherein the file type comprises a service type to which a service corresponding to the file to be processed belongs and an operation type corresponding to the service;

and determining the XML configuration file according to the file type.

Optionally, after the variable information is correspondingly filled in the file header list and the file content list and a database file corresponding to the file to be processed is generated, the method further includes:

acquiring a first checker chain corresponding to the file type, wherein the first checker chain comprises a plurality of checkers, the first checker chain is used for comparing a first parameter in the database file with a second parameter in the file to be processed, and the first parameter corresponds to the second parameter;

verifying the database file based on the first verifier chain to obtain a first verification result;

and modifying the database file based on the first verification result.

Optionally, the analyzing the file to be processed by using a template engine to obtain variable information includes:

acquiring information stored in a preset form in the file to be processed;

analyzing the information stored in the preset form based on the template engine to obtain the file header information;

traversing each piece of data in the file to be processed based on the template engine and a preset query statement to obtain the file content information;

correspondingly filling the variable information in the file header list and the file content list to generate a database file corresponding to the file to be processed, including:

and correspondingly filling the file header information in the file header list, and correspondingly filling the file content information in the file content list to generate the database file.

A second aspect of an embodiment of the present application provides a method for reading a file, including:

acquiring an XML reading configuration file corresponding to a database file;

analyzing the XML reading configuration file to obtain a file reading element corresponding to the database file, wherein the file reading element comprises a file header reading list and a file content reading list;

analyzing the database file by utilizing a reading template engine and the file reading element;

and storing the file header information and the file content information obtained by analysis into a preset database, and generating a read file corresponding to the database file.

Optionally, the method further comprises: in the process of analyzing the database file, verifying the file header information and the file content information obtained by analyzing through a preset second verifier chain to obtain a second verification result, wherein the second verifier chain is used for comparing a third parameter in the database file with a fourth parameter in the read file, and the third parameter corresponds to the fourth parameter;

and correcting the read file according to the second check result.

Optionally, in the process of parsing the database file, after the file header information and the file content information obtained by parsing are checked through a preset second checker chain to obtain a second checking result, the method further includes:

and when the second check result shows that the file header information is inconsistent with the file header information in the read file, stopping analyzing the database file.

A third aspect of an embodiment of the present application provides an apparatus for generating a file, including:

the configuration file acquisition unit is used for acquiring an XML configuration file corresponding to the file to be processed;

the first analysis unit is used for analyzing the XML configuration file to obtain file elements corresponding to the file to be processed, wherein the file elements comprise a file header list and a file content list;

a second analyzing unit, configured to analyze the file to be processed by using a template engine to obtain variable information, where the variable information includes: file header information corresponding to the file header list and file content information corresponding to the file content list;

and the generating unit is used for correspondingly filling the variable information into the file header list and the file content list to generate a database file corresponding to the file to be processed.

A fourth aspect of the embodiments of the present application provides an apparatus for reading a file, including:

the acquisition unit is used for acquiring an XML reading configuration file corresponding to the database file;

the analysis unit is used for analyzing the XML reading configuration file to obtain a file reading element corresponding to the database file, wherein the file reading element comprises a file header reading list and a file content reading list;

the file analysis unit is used for analyzing the database file by utilizing a reading template engine and the file reading element;

and the storage unit is used for storing the file header information and the file content information obtained by analysis into a preset database and generating a read file corresponding to the database file.

A fifth aspect of embodiments of the present application provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor, when executing the computer program, implements the steps of the method for generating a file according to the first aspect or the method for reading a file according to the second aspect.

A sixth aspect of embodiments of the present application provides a computer-readable storage medium, which stores a computer program that, when executed by a processor, implements the steps of the method for generating a file according to the first aspect described above, or the steps of the method for reading a file according to the second aspect described above.

A seventh aspect of embodiments of the present application provides a computer program product, which, when run on a computer device, causes the computer device to perform the steps of the method for generating a file according to the first aspect; or performing the steps of the method for reading a file according to the second aspect.

The method, the device, the equipment and the storage medium for generating the file and reading the file have the following advantages that:

the application provides a method for generating a file, which can obtain file elements corresponding to a file to be processed at one time by analyzing an XML configuration file corresponding to the file to be processed; analyzing the file to be processed by using a template engine to obtain file header information corresponding to the file header list and file content information corresponding to the file content list; and correspondingly filling the file header information and the file content information in a file header list and a file content list included in the file elements to generate a database file corresponding to the file to be processed. The database file can be generated by analyzing the XML configuration file and the template engine without acquiring an original character string corresponding to each piece of data in the file to be processed, the mode of generating the database file is free from coding a large number of codes, the file to be processed is quickly written into the database, the file generating efficiency is greatly improved, the development speed is accelerated, and the economic cost is reduced.

The application also provides a method for reading a file, which comprises the following steps: acquiring an XML reading configuration file corresponding to a database file; analyzing the XML reading configuration file to obtain a file reading element corresponding to the database file, wherein the file reading element comprises a file header reading list and a file content reading list; analyzing the database file by utilizing a reading template engine and a file reading element; and storing the file header information and the file content information obtained by analysis into a preset database, and generating a read file corresponding to the database file. In the scheme, the XML reading configuration file corresponding to the database file is analyzed, and the file reading element corresponding to the database file can be obtained at one time, wherein the file reading element comprises a file header reading list and a file content reading list; and analyzing the database file by utilizing the reading template engine and the file reading element, storing the file header information and the file content information obtained by analysis into a preset database, and generating a reading file corresponding to the database file. The original character string corresponding to each piece of data in the database file does not need to be acquired, the read file can be generated by analyzing the XML read configuration file and reading the template engine, the file can be read from the database in the file reading mode without coding a large number of codes, the file reading efficiency is greatly improved, the development speed is accelerated, and the economic cost is reduced.

Drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive exercise.

FIG. 1 is a schematic flow chart diagram of a method of generating a file provided by an exemplary embodiment of the present application;

FIG. 2 is a flowchart illustrating an exemplary embodiment of the present application in detail for step S101 of a method for generating a file;

FIG. 3 is a flowchart illustrating an exemplary embodiment of the present application in detail step S103 of a method for generating a file;

FIG. 4 is a schematic flow chart diagram of a method for generating a file according to yet another embodiment of the present invention;

FIG. 5 is a schematic flow chart diagram of a method for reading a file as provided by an exemplary embodiment of the present application;

FIG. 6 is a schematic diagram of an apparatus for generating a document according to an embodiment of the present application;

FIG. 7 is a schematic diagram of an apparatus for reading a document according to an embodiment of the present application;

fig. 8 is a schematic diagram of a computer device according to another embodiment of the present application.

Detailed Description

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

In the description of the embodiments of the present application, "/" means "or" unless otherwise specified, for example, a/B may mean a or B; "and/or" herein is merely an association describing an associated object, and means that there may be three relationships, e.g., a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone. In addition, in the description of the embodiments of the present application, "a plurality" means two or more than two.

In the following, the terms "first", "second" are used for descriptive purposes only and are not to be understood as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of that feature. In the description of the present embodiment, "a plurality" means two or more unless otherwise specified.

In the prior art, when a database document is generated, an original character string corresponding to each piece of data in a file is usually obtained, and the original character strings are spliced to generate the database document. The file generating and reading modes are easy to generate dislocation, the number of file columns actually generated is not consistent with the expected number, and the like, so that the generated database file or the read file is easy to make mistakes and has low accuracy. And a large amount of codes need to be written, the code quality is poor, the economic cost is high, and the efficiency of generating database files and reading files is low.

Moreover, file verification is lacking in the prior art. Files are important data interacted with a partner, file verification is lacked for generated database files and read files in the prior art, if the files are abnormal, huge loss is brought to the partner, and a large amount of manpower and economy are wasted when the abnormal files are repaired.

In view of this, the present application provides a method for generating a file, including obtaining an XML configuration file corresponding to a file to be processed; analyzing the XML configuration file to obtain file elements corresponding to the file to be processed, wherein the file elements comprise a file header list and a file content list; analyzing the file to be processed by using a template engine to obtain variable information, wherein the variable information comprises: file header information corresponding to the file header list and file content information corresponding to the file content list; and correspondingly filling the variable information in the file header list and the file content list to generate a database file corresponding to the file to be processed.

In the scheme, the XML configuration file corresponding to the file to be processed is analyzed, and the file elements corresponding to the file to be processed can be obtained at one time; analyzing the file to be processed by using a template engine to obtain file header information corresponding to the file header list and file content information corresponding to the file content list; and correspondingly filling the file header information and the file content information in a file header list and a file content list included in the file elements to generate a database file corresponding to the file to be processed. The database file can be generated by analyzing the XML configuration file and the template engine without acquiring an original character string corresponding to each piece of data in the file to be processed, the mode of generating the database file is free from coding a large number of codes, the file to be processed is quickly written into the database, the file generating efficiency is greatly improved, the development speed is accelerated, and the economic cost is reduced.

The application also provides a method for reading a file, which comprises the following steps: acquiring an XML reading configuration file corresponding to a database file; analyzing the XML reading configuration file to obtain a file reading element corresponding to the database file, wherein the file reading element comprises a file header reading list and a file content reading list; analyzing the database file by utilizing a reading template engine and a file reading element; and storing the file header information and the file content information obtained by analysis into a preset database, and generating a read file corresponding to the database file.

In the scheme, the XML reading configuration file corresponding to the database file is analyzed, and the file reading element corresponding to the database file can be obtained at one time, wherein the file reading element comprises a file header reading list and a file content reading list; and analyzing the database file by utilizing the reading template engine and the file reading element, storing the file header information and the file content information obtained by analysis into a preset database, and generating a reading file corresponding to the database file. The original character string corresponding to each piece of data in the database file does not need to be acquired, the read file can be generated by analyzing the XML read configuration file and reading the template engine, the file can be read from the database in the file reading mode without coding a large number of codes, the file reading efficiency is greatly improved, the development speed is accelerated, and the economic cost is reduced.

Referring to fig. 1, fig. 1 is a schematic flow chart of a method for generating a file according to an exemplary embodiment of the present application. The execution subject of the method for generating a file provided by the present application is a computer device, and the computer device includes, but is not limited to, a Domain Name Server (DNS), an independent Server, a distributed Server, a Server cluster or a cloud Server, and the like. The computer device may further include a mobile terminal such as a smart phone, a tablet computer, a Personal Digital Assistant (PDA), a desktop computer, and the like. The method for generating a file as shown in fig. 1 may include S101 to S104, and the specific implementation principle of each step is as follows.

S101: and acquiring an XML configuration file corresponding to the file to be processed.

Extensible markup language, a subset of standard generalized markup language, XML for short. Is a markup language for marking electronic documents to be structured. Extensible markup languages are commonly used to store data. The XML configuration file may include a file header list corresponding to the file to be processed, a file content list corresponding to the file to be processed, a file type corresponding to the file to be processed, and identification information corresponding to the file to be processed. It will be understood that an XML configuration file consists of a stack of code in which a list of headers, a list of contents of the file, a file type, identification information, etc. are contained. The XML configuration file may also include some necessary code segments in the programming process, such as code defining classes, defining objects, etc.

In this embodiment, the XML configuration files corresponding to different files to be processed are configured in advance according to their respective corresponding file types and stored in the database. XML configuration files corresponding to different types of files to be processed are different. In the actual implementation process, the XML configuration file corresponding to the file to be processed is obtained from the database.

Referring to fig. 2, fig. 2 is a flowchart illustrating in detail a step S101 of a method for generating a file according to an exemplary embodiment of the present application; in some possible implementations of the present application, S101 may include S1011 to S1012, which are as follows:

s1011: and acquiring the file type of the file to be processed, wherein the file type comprises the service type of the service corresponding to the file to be processed and the operation type corresponding to the service.

The file types corresponding to different files to be processed may be the same or different. For example, for financial documents, the service corresponding to the document to be processed is fund transaction, and the type of the service is fund type; the operation type corresponding to the fund transaction may be purchase requisition confirmation or redemption confirmation, etc. The business corresponding to the file to be processed is stock exchange, and the type of the business is the type of the stock; the operation type corresponding to the stock transaction can be purchase requisition confirmation or redemption confirmation, etc. The service corresponding to the file to be processed is insurance transaction, and the service type is insurance type; the operation type corresponding to the insurance transaction can be purchase insurance and the like. The description is given for illustrative purposes only and is not intended to be limiting.

Illustratively, the pending file may include a plurality of pieces of data. For example, for financial data, the service corresponding to the document to be processed is a fund transaction, the type of the service is a fund type, and the operation type corresponding to the fund transaction is subscription confirmation. One piece of data in the file to be processed may be:

fund code | fund name | product code | fund state | total amount of fund | fund scale | aggregate net value of fund unit | operation type | CJ5003| mixed combination of Changjiang river heaven and Lung | CJ5003|0|0| 1.0615|20170209|0| 3| purchase confirmation

The description is given for illustrative purposes only and is not intended to be limiting.

S1012: an XML configuration file is determined based on the file type.

Different XML configuration files are configured in advance according to different file types. Because the service type and the operation type included in each file type are different, the XML configuration files corresponding to the files to be processed are different.

Illustratively, the XML configuration files corresponding to different file types are configured in advance and stored in the database in an associated mode. For example, in the process of configuring an XML configuration file in advance, different file types are defined by using an XML language, and information such as a file header and file content corresponding to each file type is defined. And storing each configured XML configuration file and the corresponding file type in a database in an associated mode. In this example, after the file type (service type and operation type) of the file to be processed is obtained, an XML configuration file matching both the service type and the operation type is searched in the database. The description is given for illustrative purposes only and is not intended to be limiting.

In the above manner, different XML configuration files are configured for different types of files to be processed, so that file elements corresponding to the files to be configured can be conveniently and accurately analyzed subsequently, and an accurate database file is generated based on the file elements, thereby indirectly improving the accuracy of generating the database file.

S102: and analyzing the XML configuration file to obtain file elements corresponding to the file to be processed, wherein the file elements comprise a file header list and a file content list.

Because the XML configuration file is pre-configured with information such as file header, file content and the like corresponding to each file type. Analyzing the XML configuration file based on a preset method to obtain file elements corresponding to the file to be processed, wherein the file elements can comprise a file header list, a file content list, a file source to be processed, SQL query statements corresponding to the file to be processed and the like.

Analyzing the XML configuration file based on a preset method, specifically, searching a file header list and a file content list in the XML configuration file through a preset code. For example, an XML configuration file (only part of code is shown) corresponding to a certain file to be processed is:

<file:header-configs>

<file:header-config>

<file:content>

@ { exProdCode } | @ { fundName } | product code | @ { fundStatus } | total number of funds | fund scale | @ { totalpUnitScript } | @ { unitPrice } | @ { alone } | @ { bendatfitDay } | net value type | fund conversion state | regular rating state | transescrow state | @ { notcheFlag } | @ { benefirtTimhouse } absolute { internetraPervestand } | @ { internationSerenday } | @ { datutdeday }

<file:content>

Illustratively, in configuring an XML configuration file, one would typically use a < file: header-configurations > … … < file: header-configurations > profile header list and a < file: content > … … < file: content > profile content list.

Correspondingly, specific contents in the code of < file: header-configurations > … … < file: header-configurations > are searched in the XML configuration file, and a file header list corresponding to the file to be processed can be obtained. Specific contents in the code of < file: content > … … < file: content > are searched in the XML configuration file, and a file content list corresponding to the file to be processed can be obtained.

The file content list corresponding to the file to be processed is as follows:

@ { exProdCode } | @ { fundName } | product code | @ { fundStatus } | @ { fundStatus } | total number of funds | fund scale | @ { totalpUnitScript } | @ { unitPrice } | @ { unitPrime } | @ { bendatfitDaty } | net value type | fund conversion state | regular quota state | @ { notcheFlag } | @ { benefilterTenthouse } | @ { internetraTetensterSevenday } | @ { datuupptdeday }.

S103: analyzing the file to be processed by using a template engine to obtain variable information, wherein the variable information comprises: the file header information corresponding to the file header list and the file content information corresponding to the file content list.

A template engine, specifically herein a template engine for Web development, is created to separate the user interface from the business data (content), which can generate documents in a specific format. The template engine in this embodiment can separate the variable information in the file to be processed. In this embodiment, different template engines are set in advance for files to be processed of different file types, and the template engines corresponding to the file types are associated and stored in the database.

Illustratively, a template engine matched with the file type corresponding to the file to be processed is searched in a database. For example, the file type corresponding to the file to be processed includes a service type and an operation type, where the service type is a fund type and the operation type is subscription confirmation. A template engine is looked up in the database that matches both the fund type and the procurement confirmation.

The variable information refers to data which can be changed when business operation is performed in each piece of data contained in the file to be processed. The variable information may include header information corresponding to the header list and file content information corresponding to the file content list.

For example, the fund code | fund name | product code | fund state | fund total number of fund | fund scale | accumulated fund unit net value | operation type | modified date | CJ5003| mixed combination of heaven and earth in changjiang | CJ5003|0|0| 1.0615|20170209|0|0|3| purchase requisition | may change the data such as the fund state, accumulated fund unit net value, and fund net value as long as the user performs the purchase requisition confirmation operation. It is understood that data such as the status of the fund (confirmation of purchase), the net value of fund unit (1.0615), and the date of modification are variable information of the data.

Referring to fig. 3, fig. 3 is a flowchart illustrating in detail step S103 of a method for generating a file according to an exemplary embodiment of the present application; in some possible implementations of the present application, S103 may include S1031 to S1033, which are as follows:

s1031: and acquiring information stored in a preset form in the file to be processed.

The preset form may be a distributed storage form, for example, the preset form may be a key-value (k-v) form. Illustratively, the data which is needed to generate the file header information finally in the files to be processed provided by the partner is stored in a k-v form. In the implementation process, the information stored in the file to be processed in a k-v form is acquired. For example, a storage form corresponding to all information in the file to be processed is obtained, and the information stored in the k-v form is extracted.

S1032: and analyzing the information stored in a preset form based on the template engine to obtain file header information.

Illustratively, since data which finally needs to generate the file header information in the file to be processed is stored in a k-v form, the template engine analyzes the information stored in the preset form, and the file header information can be directly obtained. The template engine is also expressed in the form of codes, and the template engine is operated to analyze the information stored in the preset form to obtain the file header information corresponding to the file to be processed. The file header information may also include the total row number of data in the file to be processed, and for the file to be processed of finance, the file header information may also include the total transaction amount, the total transaction number and other information.

S1033: and traversing each piece of data in the file to be processed based on the template engine and a preset query statement to obtain file content information.

The preset query statement is used for querying each piece of data containing transaction content in the file to be processed. The preset Query statement may include a Structured Query Language (SQL) statement.

Illustratively, each piece of data is queried through the query statement, the data is input into a template engine, and the template engine analyzes the file content information in the piece of data. And traversing each piece of data, namely performing the same processing on each piece of data in the file to be processed, so as to obtain file content information corresponding to each piece of data. For example, the file content information corresponding to a certain piece of data may include fund status, net value of cumulative fund units, net value of fund units, and the like. The description is given for illustrative purposes only and is not intended to be limiting.

In the above manner, the template engine can accurately analyze the file header information and the file content information corresponding to the file to be processed.

S104: and correspondingly filling the variable information in the file header list and the file content list to generate a database file corresponding to the file to be processed.

Illustratively, the file header information obtained by analysis is correspondingly filled in the file header list, the file content information obtained by analysis is correspondingly filled in the file content list, and after all the variable information is filled, the generated file is the database file corresponding to the file to be processed.

For example, in the data of @ { exprodCode } | @ { fundName } | product code | @ { fundStatus } | total number of funds | fund scale | @ { totaltnip } | @ { unitPrice } | @ { unit price } | net value type | fund conversion state | periodic quota state | transhosting state | all have @ need of filling variable information, the file content information obtained by analysis is filled in the corresponding file content list. The description is given for illustrative purposes only and is not intended to be limiting.

Referring to fig. 4, fig. 4 is a schematic flowchart of a method for generating a file according to another embodiment of the present invention. The difference between the present embodiment and the embodiment corresponding to fig. 1 is S205 to S207, and S201 to S204 in the present embodiment are completely the same as S101 to S104 in the previous embodiment, and reference is specifically made to the related description of S101 to S104 in the previous embodiment, which is not repeated herein. S205-S207 are specifically as follows:

s205: the method comprises the steps of obtaining a first checker chain corresponding to a file type, wherein the first checker chain comprises a plurality of checkers, the first checker chain is used for comparing a first parameter in a database file with a second parameter in a file to be processed, and the first parameter corresponds to the second parameter.

In order to further ensure the accuracy of the generated database file, the database file can be verified through a preset verifier chain. The first chain of checkers comprises a plurality of different checkers, each checker checking a different content. Different verifiers are arranged in advance according to different file types and contents to be verified, and then the verifiers are connected through preset codes to form a first verifier chain and stored in a database.

And searching a first checker chain matched with the file type corresponding to the file to be processed in the database. The first checker chain is used for comparing a first parameter in the database file with a second parameter in the file to be processed, and the first parameter corresponds to the second parameter. For example, the first parameter may be the number of data lines recorded in a file header of a file to be processed, and the second parameter corresponds to the actual number of data lines in the database file; the first parameter can be the total transaction amount in the file to be processed, and the second parameter is the total transaction amount in the database file correspondingly; the first parameter may be a total transaction count in the file to be processed, and the second parameter corresponds to the total transaction count in the database file.

S206: and verifying the database file based on the first verifier chain to obtain a first verification result.

Illustratively, the first checker chain may include a checker 1 and a checker 2, where the checker 1 is configured to check consistency between the number of data lines recorded by the file header in the file to be processed and the actual number of data lines in the database file; the checker 2 is used for the consistency of the total transaction amount in the file to be processed and the total transaction amount in the database file. The method comprises the steps that a database file is verified based on a verifier 1, and a first verification result is obtained, wherein the first verification result comprises that the number of data lines recorded by a file header in a file to be processed is consistent with the actual number of data lines in the database file, or the number of data lines recorded by the file header in the file to be processed is inconsistent with the actual number of data lines in the database file. Similarly, the database file is verified based on the verifier 2 to obtain a second verification result, wherein the second verification result comprises that the total transaction amount in the file to be processed is consistent with the total transaction amount in the database file, or the total transaction amount in the file to be processed is inconsistent with the total transaction amount in the database file.

S207: and modifying the database file based on the first verification result.

And when the first verification result is that the first parameter is inconsistent with the second parameter, correcting the database file. For example, when the first verification result is that the number of data lines recorded in the header of the file to be processed is not consistent with the actual number of data lines in the database file (the number of data lines recorded in the header of the file to be processed is 100, and the actual number of data lines in the database file is 90), which data are missed in the database file is detected, and the missed data are completely supplemented. Or, the files to be processed are subjected to the processing in S201 to S204 again, and a new database file is generated. And re-checking the new database file in the S206 mode until the checking results are consistent. The description is given for illustrative purposes only and is not intended to be limiting.

In the mode, the database file and the file to be processed are verified through the verifier chain, so that the accuracy of the generated database file can be ensured, and the loss of a partner due to the database file error is avoided.

Referring to fig. 5, fig. 5 is a schematic flowchart of a method for reading a file according to an exemplary embodiment of the present application. The method for reading a file as shown in fig. 5 may include steps S301 to S304, and the specific implementation principle of each step is as follows:

s301: and acquiring an XML reading configuration file corresponding to the database file.

And acquiring the corresponding XML reading configuration file in the database file. The XML read configuration file is similar to the XML configuration file in S101, except that the XML configuration file is used to assist in generating the database file, and the XML read configuration file is used to assist in reading the file. The nature of the XML read configuration file is the same as the XML configuration file, and is also expressed in the form of code. The XML read configuration file may include a header read list, a file content read list, a data source, a database entity class, a distributed check SQL statement, and the like.

S302: and analyzing the XML reading configuration file to obtain a file reading element corresponding to the database file, wherein the file reading element comprises a file header reading list and a file content reading list.

Information such as a file header reading list and a file content reading list corresponding to the database file is configured in the XML reading configuration file. The XML reading configuration file is analyzed based on a preset method, so that file reading elements corresponding to the database file can be obtained, and the file reading elements can comprise a file header reading list, a file content reading list, a data source, database entity classes, distributed check SQL statements and the like.

The way of parsing the XML read configuration file is similar to the method of parsing the XML configuration file in S102, and is only briefly described here. Illustratively, a file header reading list and a file content reading list are searched in the XML reading configuration file through preset codes. For example, the specific content in the code of < file: header-configurations > … … < file: header-configurations > is searched in the XML reading configuration file, so as to obtain the file header reading list corresponding to the database file. Similarly, the specific content in the code of < file: content > … … < file: content > is searched in the XML reading configuration file, and the file content reading list corresponding to the database file can be obtained.

S303: and analyzing the database file by utilizing the reading template engine and the file reading element.

In this embodiment, different reading template engines are set in advance for database files of different file types, and the reading template engines corresponding to the file types are associated and stored in the database. Illustratively, a read template engine is looked up in the database that matches the file type corresponding to the database file. The file type corresponding to the database file is similar to the file type corresponding to the file to be processed, and the file type also comprises the service type to which the service corresponding to the database file belongs and the operation type corresponding to the service.

And analyzing the database file by using a reading template engine to obtain file header information corresponding to the file header reading list in the file elements and file content information corresponding to the file content reading list in the file elements. Specifically, a reading template engine is used for analyzing code segments corresponding to a file header reading list in the database file to obtain file header information. And analyzing the code segment corresponding to the file content reading list in the database file to obtain file content information. The description is given for illustrative purposes only and is not intended to be limiting.

S304: and storing the file header information and the file content information obtained by analysis into a preset database, and generating a read file corresponding to the database file.

Illustratively, the file header information obtained by analysis is correspondingly filled in a file header reading list, the file content information obtained by analysis is correspondingly filled in a file content reading list, after all the information is filled, the generated file is stored in a preset database, and at this moment, the generated file is the read file corresponding to the database file. The description is given for illustrative purposes only and is not intended to be limiting.

Optionally, in a possible implementation manner, in the process of parsing the database file, the file header information and the file content information obtained by parsing are checked through a preset second checker chain to obtain a second check result, where the second checker chain is used to compare a third parameter in the database file with a fourth parameter in the read file, and the third parameter corresponds to the fourth parameter; and correcting the read file according to the second check result.

Illustratively, the second chain of checkers includes a plurality of different checkers, each checker checking for a different content. Different verifiers are arranged in advance according to different file types and contents to be verified, and then the verifiers are connected through preset codes to form a second verifier chain and stored in a database.

And searching the second checker chain matched with the file type corresponding to the database file in the database. The second checker chain is used for comparing a third parameter in the database file with a fourth parameter in the read file, wherein the third parameter corresponds to the fourth parameter. For example, the third parameter may be the number of data lines recorded in a file header in a database file, and the fourth parameter corresponds to the actual number of data lines in a read file; the third parameter may be a total amount of transactions in the database file, and the fourth parameter corresponds to a total amount of transactions in the read file.

Illustratively, a second chain of verifiers is employed to verify the correctness of the read file. For example, the second checker chain may include checker a, checker B, and checker C. The checker A is used for checking the consistency of the number of data lines recorded by a file header in the database file and the actual number of data lines in the read file, the checker B is used for checking the consistency of the total transaction amount in the database file and the total transaction amount in the read file, and the checker C is used for checking whether the read file is complete. And when any check result is inconsistent, recording the check result and reading the file again. And verifying the newly read files again until the verification results are consistent. The description is given for illustrative purposes only and is not intended to be limiting.

In the above manner, the database file and the read file are verified through the second verifier chain, so that the accuracy of reading the file can be ensured.

Optionally, in a possible implementation manner, in the process of parsing the database file, the file header information and the file content information obtained by parsing are checked through a preset second checker chain, and after a second check result is obtained, when the second check result is that the file header information is inconsistent with the file header information in the read file, parsing of the database file is stopped. In this embodiment, the file is read and verified at the same time, and when the header information of the file is inconsistent with the header information of the file read, the database file is stopped from being analyzed, so that loss can be stopped in time, and the wrong file is prevented from being read continuously. For example, in the process of analyzing the database file, if the data line number currently recorded at the file header in the database file is detected to be inconsistent with the actual data line number in the read file, the analysis of the database file is stopped in time, a problem can be checked where the database file is currently located, and then the analysis is performed, so that the analysis is prevented from being continued on the basis of errors, and the loss is reduced.

Optionally, in a possible implementation manner, if the file to be read belongs to multiple data sources, during the process of reading the file, the number of data pieces in the currently read file may be checked by using a preconfigured distributed check SQL statement, and whether the number of data pieces is consistent with the number of data pieces that have been actually read. And if the two are inconsistent, suspending reading the file and reminding the staff of intervention treatment. The description is given for illustrative purposes only and is not intended to be limiting.

Referring to fig. 6, fig. 6 is a schematic diagram of an apparatus for generating a file according to an embodiment of the present application. The device comprises units for performing the steps in the embodiments corresponding to fig. 1, 2, 3, 4. Please refer to the related descriptions in the embodiments corresponding to fig. 1, fig. 2, fig. 3, and fig. 4, respectively. For convenience of explanation, only the portions related to the present embodiment are shown. Referring to fig. 6, the apparatus includes:

a configuration file obtaining unit 410, configured to obtain an XML configuration file corresponding to a file to be processed;

a first parsing unit 420, configured to parse the XML configuration file to obtain a file element corresponding to the to-be-processed file, where the file element includes a file header list and a file content list;

a second parsing unit 430, configured to parse the file to be processed by using a template engine to obtain variable information, where the variable information includes: file header information corresponding to the file header list and file content information corresponding to the file content list;

the generating unit 440 is configured to correspondingly fill the variable information in the file header list and the file content list, and generate a database file corresponding to the file to be processed.

Optionally, the configuration file obtaining unit is specifically configured to:

and determining the XML configuration file according to the file type.

Optionally, the apparatus further comprises:

the first checking unit is used for acquiring a first checker chain corresponding to the file type, wherein the first checker chain comprises a plurality of checkers, the first checker chain is used for comparing a first parameter in the database file with a second parameter in the file to be processed, and the first parameter corresponds to the second parameter;

the second checking unit is used for checking the database file based on the first checker chain to obtain a first checking result;

and the correcting unit is used for correcting the database file based on the first checking result.

Optionally, the second parsing unit is specifically configured to:

acquiring information stored in a preset form in the file to be processed;

the generating unit is specifically configured to: and correspondingly filling the file header information in the file header list, and correspondingly filling the file content information in the file content list to generate the database file.

Referring to fig. 7, fig. 7 is a schematic view illustrating an apparatus for reading a document according to an embodiment of the present disclosure. The apparatus comprises means for performing the steps of the corresponding embodiment of fig. 5. Please refer to fig. 5 for a corresponding embodiment. For convenience of explanation, only the portions related to the present embodiment are shown. Referring to fig. 7, the apparatus includes:

an obtaining unit 510, configured to obtain an XML reading configuration file corresponding to the database file;

the parsing unit 520 is configured to parse the XML reading configuration file to obtain a file reading element corresponding to the database file, where the file reading element includes a file header reading list and a file content reading list;

a document parsing unit 530 for parsing the database document using a reading template engine and the document reading element;

the storage unit 540 is configured to store the file header information and the file content information obtained through analysis in a preset database, and generate a read file corresponding to the database file.

Optionally, the apparatus for reading a file further includes:

the verification unit is used for verifying the file header information and the file content information obtained by analysis through a preset second verifier chain in the process of analyzing the database file to obtain a second verification result, the second verifier chain is used for comparing a third parameter in the database file with a fourth parameter in the read file, and the third parameter corresponds to the fourth parameter;

and the read file correcting unit is used for correcting the read file according to the second check result.

Optionally, the apparatus for reading a file further includes:

and the processing unit is used for stopping analyzing the database file when the second check result indicates that the file header information is inconsistent with the file header information in the read file.

Referring to fig. 8, fig. 8 is a schematic diagram of a computer device according to another embodiment of the present application. As shown in fig. 8, the computer device 6 of this embodiment includes: a processor 60, a memory 61, and computer instructions 62 stored in the memory 61 and executable on the processor 60. The processor 60, when executing the computer instructions 62, implements the steps in the above-described method embodiments for generating a file, or implements the steps in the above-described method embodiments for reading a file. Such as S101 to S104 shown in fig. 1, and S301 to S304 shown in fig. 5. Alternatively, the processor 60, when executing the computer instructions 62, implements the functions of the units in the embodiments, such as the functions of the units 410 to 440 shown in fig. 6 and the functions of the units 510 to 540 shown in fig. 7.

Illustratively, the computer instructions 62 may be divided into one or more units that are stored in the memory 61 and executed by the processor 60 to accomplish the present application. The one or more elements may be a series of computer instruction segments capable of performing specific functions that describe the execution of the computer instructions 62 in the computer device 6. For example, the computer instructions 62 may be divided into a configuration file acquisition unit, a first parsing unit, a second parsing unit, and a generation unit, or divided into an acquisition unit, a parsing unit, a file parsing unit, and a storage unit, each of which functions as described above.

The computer device may include, but is not limited to, a processor 60, a memory 61. Those skilled in the art will appreciate that fig. 8 is merely an example of a computer device 6 and is not intended to be limiting and may include more or fewer components than those shown, or some of the components may be combined, or different components, e.g., the computer device may also include input output devices, network access devices, buses, etc.

The Processor 60 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The memory 61 may be an internal storage unit of the computer device, such as a hard disk or a memory of the computer device. The memory 61 may also be an external storage terminal of the computer device, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the computer device. Further, the memory 61 may also include both an internal storage unit and an external storage terminal of the computer device. The memory 61 is used for storing the computer instructions and other programs and data required by the terminal. The memory 61 may also be used to temporarily store data that has been output or is to be output.

The embodiments of the present application further provide a computer storage medium, where the computer storage medium may be non-volatile or volatile, and the computer storage medium stores a computer program, and the computer program, when executed by a processor, implements the steps in the foregoing method embodiments for generating a file, or implements the steps in the foregoing method embodiments for reading a file.

The embodiment of the present application further provides a computer program product, which, when running on a computer device, causes the computer device to execute the steps of the above method for generating a file; or to perform the steps of the method of reading a file described above.

The above-mentioned embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should 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; such modifications and substitutions do not cause the essential features of the corresponding technical solutions to depart from the spirit scope of the technical solutions of the embodiments of the present application, and are intended to be included within the scope of the present application.

Claims

1. A method of generating a file, comprising:

acquiring an XML configuration file corresponding to a file to be processed;

2. The method of claim 1, wherein the obtaining the XML configuration file corresponding to the file to be processed comprises:

and determining the XML configuration file according to the file type.

3. The method according to claim 2, wherein after the variable information is correspondingly filled in the file header list and the file content list, and a database file corresponding to the file to be processed is generated, the method further comprises:

and modifying the database file based on the first verification result.

4. The method of claim 1, wherein the parsing the document to be processed using a template engine to obtain variable information comprises:

acquiring information stored in a preset form in the file to be processed;

5. A method of reading a file, comprising:

acquiring an XML reading configuration file corresponding to a database file;

6. The method of claim 5, wherein the method further comprises: in the process of analyzing the database file, verifying the file header information and the file content information obtained by analyzing through a preset second verifier chain to obtain a second verification result, wherein the second verifier chain is used for comparing a third parameter in the database file with a fourth parameter in the read file, and the third parameter corresponds to the fourth parameter;

and correcting the read file according to the second check result.

7. An apparatus for generating a file, comprising:

8. An apparatus for reading a document, comprising:

9. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 4 or 5 to 6 when executing the computer program.

10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1 to 4 or 5 to 6.