CN115438050B - Hierarchical low-code development platform - Google Patents

Abstract

The invention discloses a hierarchical low-code development platform, which comprises a module management unit, a menu item management unit and a general query management unit, wherein: the module management unit is used for providing a design function of the module, wherein the module comprises a function module and a form module, and also provides a function of designing a data structure for the form module, provides a development control, designs an interface function for the form module and the function module in a dragging mode based on the development control, and simultaneously supports a function of self-defining a script; the menu item management unit is used for supporting the design of menu items and configuring the basic information, the data source SQL, the operation types of the menu items and the associated assembly of the menu items; the general query management unit is used for displaying the designed menu items and the designed form module through the record list. The platform can reduce the complexity of the system, realize the requirements of different upper and lower levels and realize low coding.

Description

Hierarchical low-code development platform

Technical Field

The invention relates to the technical field of industrial enterprise data processing, in particular to a hierarchical low-code development platform.

Background

In the conventional informatization system, a user provides requirements, and a software development company carries out requirement arrangement, detailed design, coding development and deployment. The overall development time period is long, the user often expresses the requirements insufficiently, the system needs to be adjusted and run-in for a long time after the system is developed, and the adjustment run-in time period is also long. Even after running-in, many functions can not be adjusted due to design reasons, so that the user experience is poor.

For an organization needing to develop an information system, generally, the organization structure of the upper and lower levels is provided, such as a group company, a government agency and the like, and the lower level is often a supplement for the requirement of the upper level, and the supplement of different lower levels is different. In the prior art, an information system needs to meet the requirement, two methods are generally adopted, one method is to develop and deploy different systems at an upper level and each lower level, and data are synchronized through a data exchange technology; one is that the superior develops different modules with each subordinate, and generates the data needed by the superior by means of data integration; both methods have the disadvantages of high development cost and untimely data synchronization.

When a project team adopts a traditional informatization system development method to execute different multi-level system development tasks, a large amount of codes are often written, so that the workload of developers is undoubtedly increased, the development period is long, and the development efficiency is low.

Disclosure of Invention

The invention provides a hierarchical low-code development platform which can assist a user in module design and module classification, realize low coding of most functions when an application system is developed, reduce the development complexity of the application system and save the development time of the application system.

A hierarchical low code development platform comprising: module management unit, menu item management unit and general inquiry management unit, wherein:

the module management unit is used for providing a design function of the module, wherein the module comprises a function module and a form module, and also provides a function of designing a data structure for the form module, provides a development control, designs an interface function for the form module and the function module in a dragging mode based on the development control, and simultaneously supports a function of self-defining a script;

the menu item management unit is used for supporting the design of menu items and configuring the basic information, data source SQL, menu item operation types and the related assembly of the menu items;

the general query management unit is used for displaying the designed menu items and the designed form module through the record list.

The module management unit provided by the invention provides a design function and a script custom function of a module data structure for a user, assists the user to complete the design function of a module interface by adopting a dragging mode through a development control, and assists the user to complete module design through the functions; the menu item management unit provided by the invention supports the design of menu items and configures the basic information, the data source SQL, the menu item operation types and the associated assembly of the menu items, so that a user can conveniently configure the self-defined menu items and the menu item operation types for the module. The design functions of the module data structure, the design functions of the module interface, the design functions of the menu items and other functions are embedded into the low layer of the development platform in a prefabrication mode, and codeless functions of most functions are achieved, so that the application system containing the form module and the function module is designed directly by configuring parameters, and the complexity of developing the application system is greatly reduced. The provided script custom function can meet the design requirement of specific functions, so that the development complexity of the application system is reduced, and the development range of the special functions of the application system is expanded.

In the embodiment of the invention, aiming at the design function of the module, the configuration function of the module parameter is also provided, and the module parameter comprises a module name, an attribution type, a module type and a category; the attribution type is used for limiting attribution departments of the modules and realizing authority classification of the modules, the module types comprise form modules and function modules, and the categories are used for custom classification of the modules and are convenient for classification management of the modules.

The invention provides a configuration function of module parameters for a user, the user can complete the design of the module through the autonomous configuration of the module parameters and complete the internal hierarchical definition of the module through the attribution type to realize the different requirements of the upper and lower levels, thereby completing the design and the internal hierarchical definition of the module without compiling codes and improving the efficiency of designing the module.

In the embodiment of the present invention, a function of configuring data structure parameters is further provided for a function of designing a data structure, where the data structure parameters include: the method comprises the steps of field name, primary key or not, non-null or not, data type, data length, index, real type and attribution code, wherein the attribution code is used for determining the operation authority of a table and/or a field in the data structure, and the parameter is configured by a configuration function based on the parameter of the data structure to design the data structure.

The invention provides a plurality of configuration parameters for designing the data structure for the user, the user can independently complete the design of the data structure through the selection of the configuration parameters and complete the internal hierarchical definition of the data structure through the attribution code to realize the requirements of different upper and lower levels, thereby completing the design and the internal hierarchical definition of the data structure without compiling the code and improving the design efficiency of the user on the data structure.

In the embodiment of the present invention, the provided development control includes a layout control, a general control, and a data control, wherein: the layout control comprises a panel and a folding panel; the universal control comprises text, icons and buttons; the data control comprises an entry frame and a selection frame; the interface design of the form module and the function module is completed through the development control; configuration functionality is also provided for developing control property parameters, wherein the property parameters include: and the box model parameters, the font size, the flex layout and the event mapping are automatically configured based on the configuration function for developing the control attribute parameters.

The invention provides a plurality of development controls for a user, wherein the user can complete interface layout through the layout controls, the user can design a text box and a list box for design pull-down selection for the input content through the data controls, the user can design texts and pictures presented on the interface through the universal controls and control buttons for calling script functions, and the development controls enable the user to efficiently design the interface without compiling codes, thereby improving the design efficiency of the interface.

The invention also provides a plurality of attribute parameters for designing and developing the control for the user, and the user can design and develop the control by itself without writing codes through the attribute parameters, thereby improving the efficiency of designing and developing the control by the user.

In the embodiment of the invention, when the provided development control is not enough to support the interface design of the function module and the form module, the design of the user-defined control is realized by supporting the function design script information of the user-defined script, and the interface design is completed by the user-defined control.

When the functions of the provided data structure and the development control are not enough to support the interface design, the invention also provides the user with the function of the custom script to design the script information so as to realize the design of the custom control and meet the design requirement of the interface.

In the embodiment of the invention, the basic information of the menu item comprises a name, a label, a category, a supported module, a department name, a department code and a membership role; the data source SQL of the menu item provides functions of setting a database, a form in the database and a main key, and the configuration of the data source SQL is realized by selecting the database and the form in the database and setting the main key.

The invention provides a plurality of menu item configuration parameters for designing the menu items for the user, the user can independently complete the design of the menu items by selecting the menu item configuration parameters and complete the internal hierarchical definition of the menu items by department codes, and further can complete the design and the internal hierarchical definition of the menu items without editing codes, thereby improving the efficiency of designing the menu items by the user.

In the embodiment of the invention, when the menu item operation type is configured, the menu item operation type is defined, the menu item operation type is bound for each record in the record list, meanwhile, the menu item operation type contained in the unbound record is also set, the bound menu item operation type is associated with each record, and the unbound menu item operation type is associated with the whole record list. And configuring attribute information of each menu item operation type, wherein the attribute information comprises a name corresponding to the menu item operation type, an associated menu item and an associated main key.

In the embodiment of the invention, the operation types of the menu items comprise operations of adding, deleting, modifying and checking, wherein the operations of deleting, modifying and checking are associated and assembled to each record in the record list, and the operation of adding is assembled to the whole record list; the menu item operation types also comprise self-defined menu item operation types, including data export, cross summarization, batch deletion and batch replacement operations, and the menu item operation types are associated and assembled to the whole record list to realize the whole operation of the record list; for each of the types of operation of the menu items,

by customizing the menu item operation types and performing the associated assembly of the record list for the menu item operation types, the management efficiency of the user on the menu items and the modules is improved.

In the embodiment of the present invention, the module management unit, the menu item management unit, and the general query management unit are loaded in a front end unit container, and the front end unit container also loads a user management unit, a role management unit, and a department management unit; the system comprises a user management unit, a role management unit, a department management unit and a module, wherein the user management unit is used for providing a function of designing users, the role management unit is used for providing a function of designing roles, the department management unit is used for providing a function of designing departments, a plurality of users belong to one department, the users have different roles, the roles are distributed with a plurality of menu items, and the menu items can perform menu item operation on the same module;

the platform further comprises a back-end server and a database connector; the back-end server is used for receiving back-end requests caused by interactive interfaces formed by all management units in the front-end unit container, and then completing the operation of the form module or directly realizing the function of the function module through data called from the database connector;

the database connector comprises various database drivers, and data are called from the database through the data drivers and are output to a back-end server, wherein the database drivers comprise sqlite3, postgresql, mysql, human KingbaseES, oracle, dameng, hua Gauss or Ali RDS database drivers.

And bearing all the management units designed by the user in the front-end unit container, loading the corresponding management units when receiving the user right, and presenting an interactive interface to the user, so that the user can conveniently operate in the corresponding management units. The invention completes part of operations of the module in the back-end server based on the back-end request, thereby increasing the operation safety of the module. The function of calling data from different databases according to the requirements of customers is realized by a plurality of database drivers in the database connector.

In the embodiment of the invention, the database connector is also used for converting the data structure of the form module into a virtual table when the physical table structure of the database is updated; each database driver receives the virtual table, and the virtual table describes the table structure by adopting the data types supported by each database, so that the migration among different databases can be realized.

When the physical table structure of the database is updated, the database connector can convert the form module into the virtual table, each database driver receives the virtual table, and the virtual table adopts the data types supported by each database to describe the table structure, so that a large amount of codes do not need to be compiled when the database is transplanted, and the efficiency of database transplantation is improved.

Drawings

FIG. 1 is a schematic structural diagram of a hierarchical low-code development platform according to an embodiment of the present invention;

FIG. 2 is an interface diagram of a design data structure provided by an embodiment of the present invention;

FIG. 3 is an interface diagram of a design interface provided by an embodiment of the present invention;

FIG. 4 is a diagram of a configuration interface for basic information of menu items provided by an embodiment of the present invention;

FIG. 5 is a configuration interface diagram of a data source SQL of menu items according to an embodiment of the present invention;

FIG. 6 is a configuration interface diagram of menu item operation types of menu items provided by an embodiment of the present invention;

FIG. 7 is an interface diagram of a general query management unit according to an embodiment of the present invention;

FIG. 8 is an interface diagram of a multi-field filter definition according to an embodiment of the present invention;

FIG. 9 is an interface diagram of a display column definition provided by an embodiment of the invention;

FIG. 10 is a schematic structural view of a front end unit container according to an embodiment of the present invention;

FIG. 11 is a diagram illustrating relationships among departments, users, roles, menu items, and modules according to an embodiment of the present invention;

FIG. 12 is a block diagram of a hierarchical low-code development platform according to another embodiment of the present invention;

fig. 13 is a flowchart of a back-end server according to an embodiment of the present invention;

FIG. 14 is a block flow diagram of a database connector provided by an embodiment of the present invention;

FIG. 15 is a block diagram of a process for updating a physical table structure of a database by a database connector according to an embodiment of the present invention.

Detailed Description

In order to make the objects, technical solutions and technical effects of the present invention more apparent, the present invention is further described in detail below with reference to the accompanying drawings.

As shown in fig. 1, the hierarchical low-code development platform provided by the present invention includes a module management unit, a menu item management unit, and a general query management unit. The module management unit provides a design function of the module for a user, configures the module parameters to complete the module design through a configuration function of the module parameters provided by the design function, and the module parameters comprise: module name, attribution type, module type, and category; the attribution type is used for limiting attribution departments of the modules and realizing authority classification of the modules, the module types comprise form modules and function modules, the categories are used for custom classification of the modules, classification management of the modules is facilitated, and when the number of the modules is large, the modules are conveniently searched by the classification management.

When module parameters are configured, a designed module is limited to be a form module or a function module by selecting a form or a function, wherein the form module is a module with a data structure and an interface, a platform automatically creates a corresponding database physical table according to the data structure and automatically completes the operations of addition, deletion and modification, the platform corresponds to a business entity and is used for storing information, and the data structure of the form module is constrained to be a structure with one master and multiple slaves. The function module is a module without a data structure and only an interface, does not have a corresponding database table, and is generally used for executing a specific function.

The module management unit also provides the functionality to design data structures, design interfaces, and custom scripts for the module. After the module parameters are configured, data structures and interfaces are designed for the module through the functions. The function of the design data structure provided by the module management unit is limited to the function of providing the form module service, that is, providing the design data structure only for the form module, as shown in fig. 2, in which a configuration function of data structure parameters is provided, wherein the data structure parameters include: the field name, whether the key is primary or not, whether the key is non-null or not, the data type, the data length, the index, the real type and the home code, and the data structure parameter is configured by the configuration function based on the data structure parameter to design the data structure. The field name is used for defining a data structure name, the real type is a specific data type in a used database, such as a json type of postgresql, and the attribution code is used for determining the operation authority of a user on a table and/or a field in the data structure, specifically including operation authority of viewing, modifying or deleting and the like; subordinate departments may view tables and fields defined by the superior department, but may not modify or delete, and may not view data structures designed by the same level and subordinate departments.

The function of the design interface provided by the module management unit can serve the form module and the function module, namely, the function of providing the design interface for the form module and the function module is provided, in the function, a development control is provided for a user, and the function of designing the interface for the form module and the function module in a dragging mode based on the development control is provided. The development control comprises a layout control, a general control and a data control, wherein the layout control comprises a panel and a folding panel; the universal control comprises text, icons and buttons; the data control comprises an input frame and a selection frame; and designing the interface is completed through the development controls.

As shown in fig. 3, a user designs an interface through development controls in a control toolbox, the user can perform interface layout through a panel, and the rectangular area where the panel is blank can accommodate other controls, including the panel itself; a user adds folding and unfolding action bars on the basis of a panel by folding the panel, the panel is a common panel when unfolded, an action column is formed when folded, the specific content of the panel is hidden, and an accordion-type panel group is generally formed by a plurality of folding panels; the input box provides a text box for inputting contents, and a user can input the contents of texts, numerical values and date and time into the text box; the selection frame is a list frame selected by pull-down; a user presents a required picture through a picture control; a user calls a script function by clicking a button control; a user presents a section of text through the text control, and can design fonts, colors and alignment modes.

The middle of the design interface is a design area, the right side of the design interface is a property setting area of the selected development control, configuration parameters are provided for the configuration function of the control property of the selected development control through the property setting area, and the configuration parameters comprise: name, class, box model parameters, font size, flex layout, primary axis arrangement distribution, cross axis arrangement distribution, event mapping, and theme background color. A user sets the width and the length of a control content area through box model parameters, and designs the flex direction, the altitude, the main shaft arrangement distribution and the crossed shaft arrangement distribution of a control interface through flex layout. The user can drag the development control of the left toolbox to the design area to complete interface design; each development control comprises an attributive department, when different users open the module, whether the control is displayed or not can be controlled according to the department code, namely, only the development controls designed at the current level and the upper level are displayed, and the development controls designed at other level departments and lower levels are not displayed.

The function of the custom script supported by the module management unit is limited to that when the provided development control is not enough to support interface design, the script information is designed through the function of the custom script to realize the design of the custom control, and then the interface design is completed.

The design script comprises a front-end script and a back-end script, wherein the front-end script adopts javascript grammar and is used for executing interface-related operations in a front-end environment. The back-end script runs in a script engine of a back-end server, adopts javascript grammar and mainly executes relevant operations of a database. And each designed script is provided with an attribution type, when the control is loaded, the control scripts of the current level and the upper level are loaded based on the attribution type for displaying and editing, and the scripts of the same level and the lower level are not loaded.

In an embodiment, the hierarchical low-code development platform comprises a menu item management unit for supporting the design of menu items and configuring basic information, data source SQL, operation types of the menu items and associated assemblies of the operation types.

As shown in fig. 4, when configuring basic information of a menu item, the basic information includes a configuration name, a tag, a category, a supported module, a department name, a department code, a membership role, and the like, where the category is used to design a position of the menu item in a main menu, the department code is used to determine a home of the menu item, and a lower level can use menu items of a current level and an upper level, and the design of the menu item is completed through these parameters.

As shown in fig. 5, the data source SQL of the menu item provides functions of setting the database and the form and the main key in the database, when the data source SQL of the menu item is configured, the database and the form in the database are selected and the main key is set to implement configuration of the data SQL, data managed in the record list is limited in this way, and after the configured data SQL is successfully verified, data can be queried from the database and presented in the form of the record list.

As shown in fig. 6, when configuring the menu item operation type, the menu item operation type is defined, and at the same time, the menu item operation type is bound for each record in the record list, and at the same time, the menu item operation type included in the unbound record is also set, the bound menu item operation type is assembled in association with each record, and the unbound menu item operation type is assembled in association with the entire record list. And configuring attribute information of each menu item operation type, wherein the attribute information specifically comprises a name corresponding to the menu item operation type, an associated menu item, an associated main key and the like.

In the embodiment, the operation types of the menu items include basic operations such as adding, deleting, modifying, and viewing operations, wherein the deleting, modifying, and viewing operations are associated and assembled to each record in the record list, and the adding operation is assembled to the whole record list, that is, the operation of adding a new record in the record list is realized. The menu item operation types also comprise self-defined menu item operation types, which can comprise operations of data export, cross summarization, batch deletion, batch replacement and the like, and the menu item operation types are generally associated and assembled to the whole record list to realize the whole operation of the record list. It should also be noted that these custom menu item operation types are typically associated with a record list that fits into the menu item. These custom menu item operation types are not assembled for the record list of function modules.

When setting the menu item operation types of bound and unbound, the method is realized by selecting the visibility of fields, the automatic filling option and the filling value of each field, wherein the visibility of the fields comprises visible, invisible or read-only; the auto-fill options for each field include fill on open or fill on save; the filling value refers to a global variable in a macro replacement mode, and the global variable is a current user name, a current department code, a system date or a unique number.

In an embodiment, the general query management unit displays the menu items of the associated assemblies through a record list. The data query is carried out on the basis of a data source SQL designed by a menu item management unit and associated menu items, specifically, a record list corresponding to data is displayed on an interface in a macro replacement mode on the basis of the data source, the record list comprises a plurality of data records, and each data record comprises a plurality of fields, so that the query of a user is facilitated. The data source SQL statement supports a macro replacement function, the macro can be defined in a mode of { { variable } }, and the macro is automatically replaced to a value corresponding to a global variable according to a variable name during running, so that a corresponding record list is displayed on a universal query management unit interface. As shown in fig. 7, the general query management unit includes two associated menu item functions, one is a menu item associated to a record, the menu item includes operations of deleting, modifying, and viewing bound to the record, and is displayed on the right side of each record, as shown in a menu item 1 in fig. 7, and a user can delete, modify, and view each record through the menu item associated to the record. The other is a menu item not associated with a record, that is, a menu item associated with the entire record list, where the menu item includes a plurality of menu item operation types bound for the entire record list, and is presented below the interface as a general function bar, as shown in fig. 7, where the general function bar associated with the record list enables a user to import a new record into the record list, or perform operations such as export or batch replacement on batch records in the record list. The paging operation is provided in the lower right of fig. 7, and paging is performed by a backend server.

The general query management unit provides a filtering function for single fields in the record list, and operators for filtering comprise equal, unequal, greater than, less than, prefix, containing, in the list, empty, non-empty, length equal or regular. And the user realizes the filtering of the single field in the record list through a filtering operator.

The universal query management unit also provides the user with a multi-condition definition function for adding or transforming conditional logical relationships and operators on selected single fields. The multi-condition defined interface is shown in fig. 8, the multi-field is added with a condition logic relationship on the basis of a single field, and a user can generate a new condition by dragging the field from the left side of the interface to the existing condition of the right area in a graphical mode and has a logic and relationship with a target condition. Clicking the logical ' sum ' or ' word, the logical relation can be switched; the underlying high-level conditions can directly modify condition definitions, which refer to the where part of SQL, i.e. script definitions, such as: the field 1= '123' and the field 2> =0, the definition of the high-level condition can automatically keep consistent with the definition of the graphic condition of the interface, and the modifying party can automatically synchronize the other party.

The general query management unit also provides a display column definition function for the summary display field to the user. The interface for displaying column definition is shown in fig. 9, which defines visible columns, and when the number of fields is large, the user can display the fields through the function summary; on the title of each display column, the sort order can be clicked and switched.

The menu items related to the query result, such as the menu items related to records, such as modification, deletion, viewing and the like, and the menu items related to the query result, such as the data import menu item, the batch deletion menu item or the newly added form menu item, are integrated into the universal query management unit, so that the codeless operation of the user on the query result is realized.

The record list includes data structure modification time, interface modification time and script modification time in addition to the related menu items.

As shown in fig. 10, the module management unit, the menu item management unit, and the general query management unit provided above are carried in a front end unit container, and the front end unit container also carries a department management unit, a user management unit, and a role management unit.

The department management unit is used for providing a function of designing departments and is a key for realizing classification, the departments are in a single tree-shaped structure, the departments comprise department names, department codes and department levels, classification is realized through prefixes and department levels of the department codes, prefixes of lower-level department codes are upper-level department codes, and lower-level department levels are higher-level department levels plus 1. The root department is represented by the code r and the department level 0, and the codes of all the lower departments of the root department begin with the code r. The department code is used as an attribute for designing the module, so that a user can design a data structure, develop the attribution type of the control and the script, and when different users open the module, the corresponding data structure, design interface and script are displayed according to the attribution department corresponding to the attribution type of the user.

The role management unit is used for providing a role design function, the user management unit is used for providing a user design function, the relationship among roles, users, menu items and modules is that different menu items are allocated to the roles, the users have different roles, further, the corresponding menu items are selected through the different roles, and the same menu items are combined to complete the function setting of the development platform, as shown in fig. 11, n users belong to one department, the users have n roles, the roles have n menu items, and the n menu items perform form operation on the same module.

As shown in fig. 12, the hierarchical low-code development platform provided by the present invention further comprises a back-end server and a database connector, wherein:

the front end unit container generates a main menu by reading the user authority data, loads a corresponding management unit through the routing information of the main menu, presents an interactive interface, and a back end request initiated by the interactive interface is forwarded to a back end server by the front end unit container.

The back-end server provides web service, session state keeping, cache service, authority authentication service, module script running engine and log service for the whole platform, and supports operating systems such as windows, linux and national bid-winning kylin. As shown in fig. 13, in the back-end server, for the back-end request initiated by the interactive interface of each module, authority authentication is performed first, and each front-end request is accompanied by a menu item name, and the information of the current login user is obtained from Session, and further a menu item list that can be operated by the user is obtained, so that authority authentication is completed, and the user is prevented from being unauthorized.

And calling the module definition according to the module name in the menu item if the authority requirement is met, automatically completing the operations of adding, deleting, changing and checking according to the operation type of the menu item in the menu item if the authority requirement is met, calling the script definition of the current level and the upper level of the function module if the function module is the function module, executing the method in the script according to the method name and the parameters transmitted from the front end, and finally returning the execution result.

The database connector is adapted to different databases and adopts a registered database driving mode. The database driver needs to realize the functions of updating the table structure, reading the table data, adding, deleting, modifying the table data and the like. The database connector comprises various database drivers, and the designed module definition data is called from the database through the data drivers and is output to the back-end server, wherein the database drivers comprise the drivers of the databases such as sqlite3, postgresql, mysql, kingbaseES, oracle, dameng, hua Gauss and Ali RDS. The user may also provide additional database drivers in a coded manner.

As shown in fig. 14, the process of registering the database driver is to maintain a database driver list internally, where the list stores the name of the driver and the specific driver; the platform provides a registration function and an initialization event, all drivers need to monitor the initialization event and call the registration function in the event to perform driver registration, and the registration function adds a driver name and specific drivers to a driver list; the configuration file of the platform defines parameters for connecting the database, wherein the parameters comprise drive names, when the platform is initialized, an initialization event is triggered first to complete all drive registration, then the configuration file link drive is read, a specific drive is searched according to the drive name, and then the drive is connected to the database.

As shown in fig. 15, when the data structure is to update the physical table structure of the database, the data structure is organized into a virtual table number, each virtual table has a table name and a field information array, the field information has a name, a type, a length, whether a primary key is present, and whether the field information is not empty, then the update table structure functions of the drivers are called one by one, each driver receives the virtual table internally, determines whether the table exists, and generates a create table statement, if the table does not exist, compares the field information with the physical table field, generates an add field list, a delete field list, or a modify field list, generates an alter table statement according to the list, and executes the generated statement, and adjusts the table structure of the database. Because the virtual table adopts the data types supported by all the databases to describe the table structure, the migration between different databases can be realized.

The data structure is converted into a virtual table array, when a new data structure is introduced, the data structure is converted into the virtual table array, each driver receives the virtual table, and the virtual table adopts the data types supported by all the databases to describe the table structure, so that the efficient transplantation among the databases can be realized, and a large amount of code compiling in the transplantation process is avoided.

In the hierarchical low-code development platform provided in the above embodiment, based on the data structure design function, the interface design function, and the script customization function provided by the module management unit, the user is assisted to complete module design and hierarchical definition inside the module to implement different requirements of upper and lower levels, meanwhile, the menu item is designed based on the menu item management unit, and the designed menu item and form module are managed in the general query management unit by the record list, and the user, role, and department management units are also prefabricated, so that most of functions can be implemented without coding, the development complexity of the application system is reduced, a few of more complex functions are implemented, low coding is implemented by configuring or writing scripts, and various development requirements are met.

Example 1

For example, if a provincial and municipal networked unit data acquisition system is developed, the provincial level requires social credit codes, detailed names, detailed addresses and division codes of acquisition units of various cities, the city 1 needs to supplement the business income of the acquisition units, the city 2 needs to supplement the development area codes of the acquisition units, and the city 1, the city 1 and the city 2 are different index sets. The steps performed by the development platform are as follows:

1. designing a department 1, wherein the department code is rs, the department name is province, and the department level is 1; designing a department 2, wherein the department code is rs1, the department name is prefecture 1, and the department level is 2; design department 3, code is "rs2", department name is "city 2", department level is "2".

2. The design module, the name is "unit table", the type is "form", the data structure is a main table:

design field "social credit code", type "character string", length "300", department code "rs";

fields "detailed name", type "string", length "300", department code "rs";

a field "detailed address", a type "character string", a length "300", a department code "rs";

the field "zone code", type "string", length "12", department code "rs";

the field "department code", type "string", length "20", department code "rs";

fields "revenue", type "value", department code "rs1";

a field "development area code", a type "character string", a length "12", a department code "rs2";

dragging an interface of the design module, dragging in a text, taking values of a social credit code, a department code rs, dragging in an input box, a binding field social credit code and a department code rs; dragging in text, taking values of 'detailed name', department code 'rs', dragging in input box, binding field 'detailed name code', department code 'rs'; dragging in a text, taking a value of 'detailed address', a department code 'rs', dragging in an entry box, a binding field 'detailed address', and a department code 'rs'; dragging in a text, taking values of 'division code', department code 'rs', dragging in an entry box, binding field 'division code', department code 'rs'; dragging in a text, taking the value of 'business income', a department code 'rs 1', dragging in an entry box, a binding field 'business income', a department code 'rs 1'; dragging in a text, taking values of 'development area code', department code 'rs 2', dragging in an entry box, binding fields of 'development area code' and 'rs 2';

3. designing a new menu item of the form, designing a name 'new unit', classifying 'unit management', a department code 'rs', and a module 'unit table', calling parameters to be filled in: the menu item operation type is 'newly added', the field is 'department code', the filling mode is 'automatic filling when opening', the value is '{ { current department code } }', and the visibility is 'read only'; designing and modifying menu items, wherein the names are 'modifying units', the category 'unit management', the department code 'rs', the module 'unit table', calling parameters to fill: the menu item operates type "modify", field "department code", visibility "read only"; designing and deleting menu items, wherein the names are 'deleting units', the categories 'unit management', the department codes 'rs', the modules 'unit tables', calling parameters to fill: menu item operation type "delete"; designing a view menu item, wherein the name is 'view unit', the category 'unit management', the department code 'rs', the module 'unit table', calling parameters to fill: the menu item operates the type "View".

4. Designing a data management menu item, wherein the name is 'unit management', the category 'unit management', a department code 'rs', a module 'unit table', calling parameters to fill: the data source SQL statement is: "select from single table where zoning code like { { current department code } } | '%'", the zoning code is used for hierarchical data management; the association menu item 'newly added unit', association record 'no'; the associated menu item "modified unit", the associated record "yes"; the associated menu item "delete unit", the associated record "yes";

5. the role is designed, the name is 'unit management', and the department code is 'rs'.

6. Designing a user, namely 'provincial user', belonging code 'rs', and having a role 'unit management'; a design user, a name of 'city 1 user', an attribution code 'rs 1', and a role of 'unit management'; the design user, the name "city 2 user", the home code "rs2", has the role "unit management".

After the development is finished, logging in a provincial user, inquiring all units in a menu item managed by the unit, opening a unit record, and seeing values of social credit codes, detailed names, detailed addresses, division codes and department code fields; logging in a 'user in city 1', inquiring that a department code is an rs1 unit in menu items of unit management, opening a unit record, and seeing values of a social credit code, a detailed name, a detailed address, a division code, a department code and a business income field; logging in a 'user in the city 2', inquiring that a department code is a unit of rs2 in a menu item of unit management, opening a unit record, and seeing values of a social credit code, a detailed name, a detailed address, a division code, a department code and a development area code field;

the development platform of the invention can realize agile development, greatly shorten the development period, and does not need to be compiled, published and deployed again in all development operations. The development platform automatically completes all database structure adjustment and code compiling work. And basically, codes do not need to be written, and self-service development of users can be realized.

Claims (8)

1. A hierarchical low code development platform, comprising: module management unit, menu item management unit and general inquiry management unit, wherein:

the module management unit is used for providing a design function of the module, wherein the module comprises a function module and a form module, and also provides a function of designing a data structure for the form module, provides a development control, designs an interface function for the form module and the function module in a dragging mode based on the development control, and simultaneously supports a function of self-defining a script;

the menu item management unit is used for supporting the design of menu items and configuring the basic information, the data source SQL, the menu item operation types and the associated assembly of the menu items;

the universal query management unit is used for displaying designed menu items and form modules through a record list; the universal query management unit also provides a multi-condition definition function, and the multi-condition definition function is used for adding or transforming conditional logic relations and operators on the selected single fields; the general query unit also provides a filtering function for single fields in the record list, and operators for filtering comprise prefix, inclusion, list, null, non-null and length equal to or regular;

for the function of designing the data structure, a configuration function of data structure parameters is also provided, wherein the data structure parameters include: the method comprises the following steps of field name, primary key judgment, non-null judgment, data type, data length, index, real type and home code, wherein the home code is used for determining the operation authority of a table and/or a field in the data structure, and the data structure is designed by self-configuring parameters based on the configuration function of the parameters of the data structure;

when the data structure needs to update the physical table structure of the database, the data structure is converted into virtual tables, each virtual table has a table name and a field information array, the field information has a name, a type and a length, whether a main key exists or not and whether the field information is not empty or not, then the updating table structure function of the drive is called one by one, the virtual tables are received in each drive, whether the tables exist or not is judged, if the tables do not exist, a create table statement is not generated, if the tables exist, the field information is compared with the physical table fields, a field adding list, a field deleting list or a field modifying list is generated, finally, an alter table statement is generated according to the lists, and finally the generated statement is executed, and the table structure of the database is adjusted.

2. The hierarchical low code development platform according to claim 1, further providing configuration functionality for module parameters for design functionality of a module, the module parameters comprising: module name, attribution type, module type, and category; the attribution type is used for limiting attribution departments of the modules and realizing authority classification of the modules, the module types comprise form modules and function modules, and the categories are used for custom classification of the modules and are convenient for classification management of the modules.

3. The hierarchical low code development platform of claim 1, wherein the development controls provided comprise a layout control, a generic control, and a data control, wherein: the layout control comprises a panel and a folding panel; the universal control comprises text, icons and buttons; the data control comprises an input frame and a selection frame; the interface design of the form module and the function module is completed through the development control;

configuration functionality is also provided for developing control property parameters, wherein the property parameters include: and the box model parameters, the font size, the flex layout and the event mapping are automatically configured based on the configuration function for developing the control attribute parameters.

4. The hierarchical low-code development platform according to claim 1, wherein when the provided development controls are insufficient to support the interface design of the function module and the form module, the design of the custom controls is realized by supporting the function design script information of the custom scripts, and the interface design is completed by the custom controls.

5. The hierarchical low code development platform according to claim 1, wherein the basic information of the menu items comprises: name, label, category, module supported, department name, department code, and affiliate role;

the data source SQL of the menu item provides functions of setting a database, a form in the database and a main key, and the configuration of the data SQL is realized by selecting the database and the form in the database and setting the main key.

6. The hierarchical low-code development platform according to claim 1, wherein when configuring the menu item operation types, the menu item operation types are defined, the menu item operation types are bound for each record in the record list, and the menu item operation types included in unbound records are also set, the bound menu item operation types are assembled in association with each record, and the unbound menu item operation types are assembled in association with the whole record list;

and configuring attribute information of each menu item operation type, wherein the attribute information comprises a name corresponding to the menu item operation type, an associated menu item and an associated main key.

7. The hierarchical low-code development platform according to claim 1, wherein the menu item operation types include add, delete, modify, view operations, wherein the delete, modify, view operations are associated and assembled to each record in the record list, and the add operation is assembled to the entire record list;

the menu item operation types also comprise self-defined menu item operation types, including data export, cross summarization, batch deletion and batch replacement operation, and the menu item operation types are associated and assembled to the whole record list to realize the whole operation of the record list.

8. The hierarchical low code development platform of claim 1, wherein the module management unit, the menu item management unit, and the general query management unit are hosted in a front end unit container that also hosts a user management unit, a role management unit, and a department management unit; the system comprises a user management unit, a role management unit, a department management unit and a module, wherein the user management unit is used for providing a function of designing users, the role management unit is used for providing a function of designing roles, the department management unit is used for providing a function of designing departments, a plurality of users belong to one department, the users have different roles, the roles are distributed with a plurality of menu items, and the menu items can perform menu item operation on the same module;

the platform further comprises a back-end server and a database connector; the back-end server is used for receiving back-end requests caused by interactive interfaces formed by all management units in the front-end unit container, and then completing the operation of the form module or directly realizing the function of the function module through data called from the database connector;

the database connector comprises various database drivers, and data are called from the database through the data drivers and are output to a back-end server, wherein the database drivers comprise sqlite3, postgresql, mysql, human KingbaseES, oracle, dameng, hua Gauss or Ali RDS database drivers.

Images