Method for assisting low-code platform to generate complete project database table and corresponding page form based on large model technology

Abstract

The invention discloses a method for assisting a low-code platform to generate a complete project database table and a corresponding page form based on a large model technology, and belongs to the technical field of low-code development. The method comprises a demand analysis module, a large model processing module, a database table generation module, a form configuration module and a verification optimization module. The demand analysis module extracts user demand information, the large model processing module generates a database table and a form draft, the follow-up module converts the draft into an executable script and a page component, and the verification optimization module ensures the consistency of the executable script and the page component. Manual operation is reduced through automatic processing, the development efficiency and accuracy are improved, and the method is suitable for rapid generation of database tables and forms of various items.

Description

Technical Field

[0001] This invention relates to the field of low-code development technology, and in particular to a method for generating complete project database tables and corresponding page forms on a low-code platform based on large model technology. Background Technology

[0002] Existing low-code platforms typically require users to manually configure database field types and form component properties when generating database tables and page forms, a cumbersome and inefficient process. Furthermore, the consistency between the database table structure and the page forms requires manual verification, which can easily lead to field mismatches and increase the error rate in project development. At the same time, for users lacking specialized knowledge, it is difficult to quickly generate database tables and forms that meet project requirements, limiting the widespread adoption of low-code platforms. Summary of the Invention

[0003] To overcome the problems of cumbersome operations, low efficiency, and poor consistency in generating database tables and page forms in existing low-code platforms, this invention provides a method based on large model technology to assist low-code platforms in generating complete project database tables and corresponding page forms.

[0004] A method for generating complete project database tables and corresponding page forms on a low-code platform based on large model technology includes a requirements parsing module, a large model processing module, a database table generation module, a form configuration module, and a validation optimization module. The requirements parsing module extracts project requirements input by the user; the large model processing module receives the information output by the requirements parsing module and generates a draft database table structure and draft form fields; the database table generation module converts the draft database table structure into an executable database script; the form configuration module generates page form components based on the draft form fields; and the validation optimization module performs consistency checks on the generated database tables and page forms and outputs optimization suggestions.

[0005] The requirement parsing module includes a natural language processing unit and a requirement classification unit. The natural language processing unit performs word segmentation and semantic recognition on the text input by the user, and the requirement classification unit classifies the recognized information into entity information, field attribute information, and form interaction information.

[0006] The large model processing module has a built-in project type feature library, which contains typical database table structures and form configuration templates for e-commerce, government affairs, and education.

[0007] The beneficial effects of this invention are: by automatically processing user requirements and generating database tables and page forms through large model technology, manual operations are reduced and development efficiency is improved; the verification and optimization module ensures the consistency of database tables and forms, reducing the error rate; the built-in project type feature library can assist in generating structures that conform to industry standards, and even non-professional users can quickly complete the configuration, improving the usability of the low-code platform. Attached Figure Description

[0008] Figure 1 is a schematic diagram of the module structure of the present invention; Figure 2 is a schematic diagram of the workflow of the present invention; Figure 3 is a schematic diagram of the working logic of the verification and optimization module.

[0009] In the diagram: 1 - Requirements parsing module, 11 - Natural language processing unit, 12 - Requirements classification unit, 2 - Large model processing module, 3 - Database table generation module, 4 - Form configuration module, 5 - Validation optimization module, 6 - Historical project storage module. Detailed Implementation

[0010] The technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention.

[0011] Referring to Figures 1-3, a method for generating complete project database tables and corresponding page forms on a low-code platform based on large model technology includes a requirement parsing module 1, a large model processing module 2, a database table generation module 3, a form configuration module 4, and a validation optimization module 5, as well as a historical project storage module 6.

[0012] The requirement parsing module 1 includes a natural language processing unit 11 and a requirement classification unit 12. The natural language processing unit 11 performs word segmentation and semantic recognition on the project requirement text input by the user. For example, it parses "Create a user table containing username, mobile phone number and registration time, and the form must have input boxes and date pickers" into the entity "user table", the fields "username, mobile phone number, registration time", and the form components "input boxes, date pickers". The requirement classification unit 12 classifies this information into entity information, field attribute information, and form interaction information.

[0013] The large model processing module 2 receives the classification information output by the requirement parsing module 1, and combines it with the built-in project type feature library (containing typical structures in e-commerce, government affairs, and education fields) to generate a draft database table structure (including field names, data types, and constraints) and a draft form field (including component types and validation rules).

[0014] The database table generation module 3 supports three database types: MySQL, Oracle, and PostgreSQL. It converts the table structure draft into the corresponding SQL script, such as generating statements like "CREATE TABLE user (id INT PRIMARY KEY,username VARCHAR (50) NOT NULL)".

[0015] Form configuration module 4 generates page form components based on the form field draft, including input boxes (supporting 1-500 character length adjustment), drop-down selectors, date pickers, and checkboxes, and configures the display name and associated fields of the components.

[0016] The validation optimization module 5 checks the consistency between the database table and the form through field name matching validation, data type matching validation, and constraint condition matching validation. For example, if "phone number" in the database table is of type INT while the form component is a text input box, it will output the optimization suggestion "It is recommended to set the form input box type to numeric".

[0017] The historical project storage module 6 can store the database table structure and form configuration information of no less than 1,000 historical projects for reference and model training in subsequent projects.

[0018] Working principle: After the user inputs project requirements, the requirements parsing module 1 processes and classifies the requirements; the large model processing module 2 generates a draft based on the classification information and feature library; the database table generation module 3 and the form configuration module 4 convert the draft into an executable script and page components, respectively; the validation and optimization module 5 performs consistency checks and outputs suggestions; finally, the results can be stored in the historical project storage module 6.

Claims

1. A method for generating complete project database tables and corresponding page forms on a low-code platform based on large model technology, characterized in that: It includes a requirements parsing module, a large model processing module, a database table generation module, a form configuration module, and a validation optimization module. The requirements parsing module is used to extract project requirements information input by the user. The large model processing module receives the information output by the requirements parsing module and generates a draft database table structure and a draft form field. The database table generation module converts the draft database table structure into an executable database script. The form configuration module generates page form components based on the draft form field. The validation optimization module performs consistency checks on the generated database tables and page forms and outputs optimization suggestions.

2. The method according to claim 1, characterized in that: The requirement parsing module includes a natural language processing unit and a requirement classification unit. The natural language processing unit performs word segmentation and semantic recognition on the text input by the user, and the requirement classification unit classifies the recognized information into entity information, field attribute information, and form interaction information.

3. The method according to claim 1, characterized in that: The large model processing module has a built-in project type feature library, which contains typical database table structures and form configuration templates for e-commerce, government affairs, and education.

4. The method according to claim 1, characterized in that: The database table generation module supports script generation for three database types: MySQL, Oracle, and PostgreSQL.

5. The method according to claim 1, characterized in that: The page form components generated by the form configuration module include input boxes, drop-down selectors, date pickers, and checkboxes.

6. The method according to claim 5, characterized in that: The input box supports configuration of a maximum character length limit, which can be adjusted between 1 and 500.

7. The method according to claim 1, characterized in that: The consistency verification of the verification optimization module includes field name matching verification, data type matching verification, and constraint condition matching verification.

8. The method according to claim 1, characterized in that: It also includes a historical project storage module, which is used to store the generated database table structure and page form configuration information.

9. The method according to claim 8, characterized in that: The historical project storage module can store no less than 1,000 historical projects.

10. The method according to claim 1, characterized in that: The information extraction accuracy of the demand analysis module is no less than 90%.

Images