CN115981657A - Code generation method and device, electronic equipment and readable medium - Google Patents

Abstract

The invention provides a code generation method, a code generation device, electronic equipment and a readable medium. The method comprises the following steps: acquiring a database table from a database according to preconfigured database link information; generating a data model according to the database table; and generating a code according to the data model and a preset code template. According to the scheme of the invention, the database table of the code to be generated can be converted into the data model, and the code is generated by using the preset code template, so that much energy of developers is saved, manual errors are reduced, the developers do not need to waste excessive energy on the related operation of the database, and the code generation efficiency is improved.

Description

Code generation method and device, electronic equipment and readable medium

Technical Field

The present invention relates to the field of computer technologies, and in particular, to a code generation method and apparatus, an electronic device, and a readable medium.

Background

In the software development process, various code generation tools are widely applied to increase the stability of a system, reduce the development and maintenance cost of software and improve the development efficiency. In the process of writing codes, repetitive work is often involved, repeated processing of a large number of identical codes is tedious manual labor, and the process of copying and pasting cannot ensure the uniformity and normalization of the codes and the correctness of the codes in the copying process.

In the prior art, in the code generation process, a user needs to select repeated contents for many times, even corresponding instructions need to be input through a keyboard, the code generation process is complicated, and the efficiency is low.

Therefore, there is a need for a way to improve the efficiency of code generation.

Disclosure of Invention

The embodiment of the invention provides a code generation method, a code generation device, electronic equipment and a readable medium, which can improve the code generation efficiency.

In a first aspect, an embodiment of the present invention provides a code generation method, including:

acquiring a database table from a database according to preconfigured database link information;

generating a data model according to the database table;

and generating a code according to the data model and a preset code template.

Optionally, each row information of the database table is a group of row data, and each column information is metadata of the row data;

correspondingly, the generating a data model according to the database table includes:

determining the metadata corresponding to each group of line data;

and filling the metadata into column information of corresponding row data to obtain the data model.

Optionally, the metadata includes at least one keyword, and the keyword includes identification information, a primary key, a size, a type, and a name.

Optionally, each code template corresponds to one kind of the keyword;

correspondingly, each code template is set in the following way;

determining a fixed field of a target keyword corresponding to a current code template;

determining a variable field of the target keyword and a position of the variable field in the fixed field;

and setting the current code template according to the fixed field and the variable field.

Optionally, the generating a code according to the data model and a preset code template includes:

determining a keyword corresponding to each row information of the data model;

determining a code template corresponding to each line information according to the key word corresponding to each line information;

filling the row data corresponding to each row information into a variable field in the code template to obtain a corresponding row code;

and obtaining the code according to the line code.

Optionally, the method further includes:

determining the service type of the data table;

determining a service fixed template corresponding to the service type;

and adding the service fixed template into the code.

Optionally, the method further includes:

determining a translation type for the code;

converting the code into a format of the translation type.

In a second aspect, an embodiment of the present invention provides a code generation apparatus, including:

the database table acquisition unit is used for acquiring a database table from a database according to the pre-configured database link information;

the data model generating unit is used for generating a data model according to the database table;

and the processing unit is used for generating codes according to the data model and a preset code template.

In a third aspect, an embodiment of the present invention provides a code generation apparatus, including: at least one memory and at least one processor;

the at least one memory to store a machine readable program;

the at least one processor is configured to invoke the machine-readable program to perform the method of any of the above embodiments.

In a fourth aspect, embodiments of the present invention provide a computer-readable medium having stored thereon computer instructions, which, when executed by a processor, cause the processor to perform the method of any one of the above embodiments.

The embodiment of the invention provides a code generation method, a code generation device, electronic equipment and a readable medium, wherein a database table of a code to be generated is acquired from a database through pre-configured database link information, a data model is generated according to the database table, and the code is generated according to the data model and a preset code template.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.

FIG. 1 is a flow chart of a method for generating code according to an embodiment of the present invention;

FIG. 2 is a flowchart of a code template setting method according to an embodiment of the present invention;

fig. 3 is a schematic structural diagram of a code generation apparatus according to an embodiment of the present invention;

fig. 4 is a schematic structural diagram of an electronic device implementing the code generation method according to the embodiment of the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer and more complete, the technical solutions in the embodiments of the present invention will be described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention, and based on the embodiments of the present invention, all other embodiments obtained by a person of ordinary skill in the art without creative efforts belong to the scope of the present invention.

Fig. 1 is a flowchart of a code generation method according to an embodiment of the present invention, and as shown in fig. 1, the method may include the following steps:

and S110, acquiring a database table from the database according to the preset database link information.

Wherein the database table characterizes a base configuration of a table in the database. In one possible implementation, the database table may include, but is not limited to, field information and metadata of tables in the database, the field information including at least one of a field name, a field type, and a field attribute of each table field in the table, and the metadata including at least one of a table name and a primary foreign key relationship of the table. The database may be any type of database such as oracle, mysql, sqlserver, and the like, and the embodiment of the present disclosure is not limited thereto.

The database connection information is related information required for downloading a database table, is mainly described by data of the database configuration 1, and may include a database name, a database type, a user name, a password, a name of a server, and the like.

And S120, generating a data model according to the database table.

The data model is used for describing the requirement information in the system, has high abstraction, is a basic model of a code automatic generation framework, converts a database table into a data model under the framework, and can generate codes quickly.

And S130, generating a code according to the data model and a preset code template.

The code template is created by pre-written sample codes or selected sample codes, and comprises fixed contents and contents used for filling according to data in the data model. In the code generation process, repeated and fixed codes do not need to be written manually and repeatedly based on the code template, and the codes can be obtained by filling the data in the data model into the code template, so that the generated codes are guaranteed to have normalization and accuracy, and the code generation efficiency is effectively improved.

The embodiment of the invention provides a code generation method, a code generation device, electronic equipment and a readable medium, wherein a database table of a code to be generated is acquired from a database through pre-configured database link information, a data model is generated according to the database table, and the code is generated according to the data model and a preset code template.

In the embodiment of the invention, each row information of the database table is a group of row data, and each column information is metadata of the row data;

correspondingly, the generating a data model according to the database table includes:

determining the metadata corresponding to each group of line data;

and filling the metadata into column information of corresponding row data to obtain the data model.

Each row of the database table corresponds to a group of row data, the row data in the database table are configured to describe the content of the database, and the row data in each row of the database table are used to describe the data included in the row. The metadata describes the relevant attributes of the line data.

In an embodiment of the present invention, the metadata includes at least one keyword, and the keyword includes whether the keyword is identification information, a primary key, a size, a type, and a name.

The database table and the attempted structure are mainly described by table and view generation metadata in the database, and are described in column information, for example, whether m columns of information are primary keys or not is determined, if n rows of data are primary keys, m × n elements of the database table are marked by the metadata, and the row of data is identified as the primary keys.

In the embodiment of the invention, each code template corresponds to one type of the keyword;

fig. 2 is a flowchart of a method for setting a code template according to an embodiment of the present invention, and as shown in fig. 2, the method includes:

and S210, determining a fixed field of the target keyword corresponding to the current code template.

S220, determining the variable field of the target keyword and the position of the variable field in the fixed field.

And S230, setting the current code template according to the fixed field and the variable field.

Before the code template is constructed, keywords and meanings thereof should be defined first, so that the definition of the code template ensures that styles of the code template are kept consistent, and the unified management of the code template is provided.

The code template is actually an abstract code format designer, and only needs to construct a code template for a certain type and provide a program code, so that a plurality of specific types can be generated, and the programming efficiency is effectively improved. Code templates describe only class program compilation and do not create program code for a class template but can generate specific classes and their objects through instantiation of the class template.

And determining a variable field corresponding to the difference content replacement identification in the code generation template, filling in the variable field to generate a code according to the processed code template, so that in the code generation process, filling and replacing the difference content based on the code template can realize automatic generation of the code.

The fixed field and the variable field can be distinguished by extracting the difference content and the common content from the sample code, wherein the variable field refers to the field needing to be changed and adjusted in the process of generating the code, and the fixed field refers to some common content needing not to be changed in the process of generating the code. Specifically, the target sample code may be processed by a Velocity template engine, and certainly, the sample code may also be processed by a Freemarker template engine or other custom template engines), and the code template is created based on the difference content and the common content, thereby ensuring the creation efficiency of the code template.

Specifically, in the embodiment of the present invention, the generating a code according to the data model and a preset code template includes:

determining a keyword corresponding to each row information of the data model;

determining a code template corresponding to each line information according to the key word corresponding to each line information;

filling the line data corresponding to each line information into a variable field in the code template to obtain a corresponding line code;

and obtaining the code according to the line code.

The method comprises the steps of obtaining row information of a user, wherein each keyword corresponds to a preset code template, and the keywords corresponding to the row information identify the templates needed to be used by the row of data. In the technical scheme, when the variable field corresponding to the different content replacement identifier is determined, the correct code template can be selected according to the keyword, so that the content filling is further ensured to be correct, and a precondition guarantee is provided for the automatic generation of a subsequent code.

Specifically, the keywords may include: class name, one or more attributes of a class, type of attribute, name of attribute, package name, reference to a single class file, set of references to multiple class files, table name of database, primary key type, column name in database, attribute data type in table, etc.

In an embodiment of the present invention, the method further comprises the steps of:

determining the service type of the data table;

determining a service fixed template corresponding to the service type;

and adding the business fixed template into the code.

The service type may represent a service scenario, such as java, corresponding to the data table when the data table is converted into the code, and in the corresponding service type, the code needs to include some fixed formats of the service type, such as a fixed prefix or a fixed suffix, so that on the basis of generating the code, a service fixed template including the fixed format of the service type is added to the code to meet the requirements of different service scenarios. The specific address, business fixed template, can be set according to the name and path of the included ORM component, solution, the system's namespace, and the development tools and their versions.

In an embodiment of the present invention, the method further includes the steps of:

determining a translation type for the code;

converting the code into a format of the translation type.

Wherein the generation of the code may be implemented by a code generation engine. The code generation engine is a stand-alone application program which occupies a core position in the whole code generation framework. The code generation engine generates codes according to different inter-code templates on the basis of a data model of the management information system, so that basic operations such as data query modification, deletion and addition are completed. In addition, transcoding can be said to be different transition types, thereby accommodating more usage scenarios.

Fig. 3 is a schematic structural diagram of a code generating apparatus according to an embodiment of the present invention, and as shown in fig. 3, the apparatus includes:

a database table obtaining unit 310, configured to obtain a database table from a database according to preconfigured database link information;

a data model generating unit 320, configured to generate a data model according to the database table;

and the processing unit 330 is configured to generate a code according to the data model and a preset code template.

Optionally, each row information of the database table is a group of row data, and each column information is metadata of the row data;

accordingly, the data model generating unit 320 is configured to perform:

determining the metadata corresponding to each group of line data;

and filling the metadata into column information of corresponding row data to obtain the data model.

Optionally, the metadata includes at least one keyword, and the keyword includes identification information, a primary key, a size, a type, and a name.

Optionally, each code template corresponds to one of the keywords;

correspondingly, as shown in fig. 3, the apparatus further includes: a code template setting unit 340;

a code template setting unit 340 for setting a code template by;

determining a fixed field of a target keyword corresponding to a current code template;

determining a variable field of the target keyword and a position of the variable field in the fixed field;

and setting the current code template according to the fixed field and the variable field.

Optionally, the processing unit 330 is configured to perform:

determining a keyword corresponding to each row information of the data model;

determining a code template corresponding to each line information according to the key word corresponding to each line information;

filling the row data corresponding to each row information into a variable field in the code template to obtain a corresponding row code;

and obtaining the code according to the line code.

Optionally, the processing unit 330 is further configured to perform:

determining the service type of the data table;

determining a service fixed template corresponding to the service type;

and adding the business fixed template into the code.

Optionally, the processing unit 330 is further configured to perform:

determining a translation type for the code;

converting the code into a format of the translation type.

It is to be understood that the illustrated structure of the embodiment of the present invention does not specifically limit the code generation apparatus. In other embodiments of the invention, the code-generating means may comprise more or fewer components than shown, or some components may be combined, some components may be split, or a different arrangement of components. The illustrated components may be implemented in hardware, software, or a combination of software and hardware.

For the information interaction, execution process and other contents between the units in the above device, the specific contents may refer to the description in the embodiment of the method of the present invention because the same conception is based on, and are not described herein again.

The code generation device can generate a corresponding whole set of codes according to actual needs, the development efficiency of the system is improved, the operation is simple and rapid, the software output efficiency of an enterprise can be improved, engineers can pay more attention to business logic, and a larger social value is created instead of spending time in repeated and simple work.

FIG. 4 shows a schematic block diagram of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device may also represent various forms of mobile devices, such as personal digital assistants, cellular phones, smart phones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.

As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory communicatively connected to the at least one processor 11, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, and the like, wherein the memory stores a computer program executable by the at least one processor, and the processor 11 can perform various suitable actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from a storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data necessary for the operation of the electronic apparatus 10 may also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.

A number of components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, or the like; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network such as the internet and/or various telecommunication networks.

The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various dedicated Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, a Digital Signal Processor (DSP), and any suitable processor, controller, microcontroller, and so forth. The processor 11 performs the various methods and processes described above, such as the code generation method.

In some embodiments, the code generation method may be implemented as a computer program tangibly embodied in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the code generation method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the code generation method by any other suitable means (e.g. by means of firmware).

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuitry, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), system on a chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs that are executable and/or interpretable on a programmable system including at least one programmable processor, which may be special or general purpose, receiving data and instructions from, and transmitting data and instructions to, a storage system, at least one input device, and at least one output device.

A computer program for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be performed. A computer program can execute entirely on a machine, partly on a machine, as a stand-alone software package partly on a machine and partly on a remote machine or entirely on a remote machine or server.

In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) by which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic, speech, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a back-end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back-end, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.

The computing system may include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical host and VPS service are overcome.

It should be understood that various forms of the flows shown above, reordering, adding or deleting steps, may be used. For example, the steps described in the present invention may be executed in parallel, sequentially, or in different orders, and are not limited herein as long as the desired results of the technical solution of the present invention can be achieved.

The above-described embodiments should not be construed as limiting the scope of the invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made in accordance with design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (10)

1. A code generation method, comprising:

acquiring a database table from a database according to preconfigured database link information;

generating a data model according to the database table;

and generating a code according to the data model and a preset code template.

2. The method of claim 1, wherein each row information of the database table is a set of row data, and each column information is metadata of the row data;

correspondingly, the generating a data model according to the database table includes:

determining the metadata corresponding to each group of line data;

and filling the metadata into column information of corresponding row data to obtain the data model.

3. The method of claim 2, wherein the metadata comprises at least one keyword, and wherein the keyword comprises one of an identification information, a primary key, a size, a type, and a name.

4. The method of claim 3, wherein each of said code templates corresponds to one of said keywords;

correspondingly, each code template is set in the following way;

determining a fixed field of a target keyword corresponding to a current code template;

determining a variable field of the target keyword and a position of the variable field in the fixed field;

and setting the current code template according to the fixed field and the variable field.

5. The method of claim 4, wherein generating a code according to the data model and a preset code template comprises:

determining a keyword corresponding to each row information of the data model;

determining a code template corresponding to each line information according to the key word corresponding to each line information;

filling the row data corresponding to each row information into a variable field in the code template to obtain a corresponding row code;

and obtaining the code according to the line code.

6. The method of claim 1, further comprising:

determining the service type of the data table;

determining a service fixed template corresponding to the service type;

and adding the service fixed template into the code.

7. The method of claim 1, further comprising:

determining a translation type for the code;

converting the code into a format of the translation type.

8. A code generation apparatus, comprising:

the database table acquisition unit is used for acquiring a database table from a database according to the preset database link information;

the data model generating unit is used for generating a data model according to the database table;

and the processing unit is used for generating codes according to the data model and a preset code template.

9. A code generation apparatus, comprising: at least one memory and at least one processor;

the at least one memory to store a machine readable program;

the at least one processor, configured to invoke the machine readable program to perform the method of any of claims 1 to 7.

10. A computer readable medium having stored thereon computer instructions which, when executed by a processor, cause the processor to perform the method of any of claims 1 to 7.

Images