CN116166234A

CN116166234A - Method for realizing complex logic arrangement of form-driven low-code system

Info

Publication number: CN116166234A
Application number: CN202310159198.7A
Authority: CN
Inventors: 商茎正
Original assignee: Xiamen Best Material Digital Technology Co ltd
Current assignee: Xiamen Best Material Digital Technology Co ltd
Priority date: 2023-02-24
Filing date: 2023-02-24
Publication date: 2023-05-26

Abstract

The invention relates to the technical field of software development, in particular to a method for realizing complex logic arrangement of a form-driven low-code system, which comprises triggering events, an incoming context, logic arrangement processes and result returns, wherein the events are triggered by various links of form submission, custom buttons, data selection, process starting approval and ending and system condition event triggering, the context comprises trigger event types, form data corresponding to triggering and system current information, the logic arrangement process is a visual component simulation program language writing process, a single or multiple database addition and deletion change, variable assignment and calculation, circulation, branching, external calling and other logic arrangement component combination are configured according to service scenes, and the process is arranged according to service sequences. The form type low-code system utilizes the characteristic that the form type low-code system is driven by a form, has great logic processing flexibility based on a formulated SQL component, and can process abundant and complex logic operations.

Description

Method for realizing complex logic arrangement of form-driven low-code system

Technical Field

The invention relates to the technical field of software development, in particular to a method for realizing complex logic arrangement of a form driving type low-code system.

Background

Low code is a development platform that can quickly generate applications without encoding (0 code) or with a small amount of code. By means of visualization, developers with different experience levels can create web pages and mobile applications through a graphical user interface using drag components and model driven logic.

The current form type low code platform processes logic through existing components, by means of logic processing component programming, scripting language (Javascript, python, or self-developed scripting language) or development language (java. C#, etc.).

The low code configuration or small number of encodings creates an information management system, whether the data or information is stored in a relational database system, and whether the data is subject to various processing, manipulation, and external presentation.

Defects:

(1) The existing components (logic components) with logic processing capability can only be suitable for the existing narrow business logic and have no abundant variability;

(2) The arrangement of different logic components results in a richer expansion of logic processing power, but is still limited to combinations of existing power

(3) The universal script language can process complex business logic, but has the disadvantages of high writing difficulty, complexity, difficulty in learning and low integration level.

Therefore, a method for implementing complex logic arrangement for a form-driven low-code system is proposed for the above-described problems.

Disclosure of Invention

The present invention is directed to a method for implementing complex logic arrangement in a form-driven low-code system, so as to solve the above-mentioned problems in the prior art.

In order to achieve the above purpose, the present invention provides the following technical solutions:

a method for implementing complex logic orchestration in a form-driven low-code system, comprising the steps of:

s1, triggering events, wherein the events are triggered by form submission, custom buttons, links of data selection, process start approval and end and system condition events;

s2, inputting a context, wherein the context comprises a trigger event type, form data corresponding to triggering and current system information;

s3, a logic arrangement process, namely simulating a programming language writing process by a visual component, configuring single or multiple databases according to service scenes to add and delete changes, variable assignment and calculation, circulation, branching, external calling, calling other logic arrangement component combinations and arranging the processes according to service sequences;

s4, returning the result and returning the operation result.

In the logic arrangement process, the intermediate form is used as a calculation intermediate, and the SQL formulated by the collection is used for carrying out relational database operation, and the specific steps are as follows:

s11, inputting context form data, and inputting related form data related to the context;

s12, preprocessing the context form data and storing the context form data in one or more intermediate forms;

s13, performing one-step or multi-step relational database operation on the intermediate form and the context form or other forms;

s14, temporarily storing the operation result of the relational database in the intermediate form;

s15, deleting the middle form data;

s16, returning the processing result to the calling party.

Preferably, in step S12, the data is processed as necessary or the data for selecting the appropriate row or column is stored in one or more intermediate forms created in advance.

Preferably, in step S13, the formulated SQL component is used to write SQL, and performs database aggregation operation, relational operation and function operation with the context form or other service forms, and the operations are performed in one step or multiple steps; the set operation comprises the operations of a cone, an intersection, a difference and a Cartesian product; the relation operation comprises selection, projection and connection operation; the function operation comprises case and ifnull concrete relation database enriching function library.

Preferably, in step S15, the data temporarily stored in the intermediate form is synchronized to the related form, and the database adding, deleting and modifying operation is performed.

Compared with the prior art, the invention has the beneficial effects that:

1. the form type low-code system utilizes the characteristic that the form type low-code system is driven by a form, has great logic processing flexibility based on a formulated SQL component, and can process abundant and complex logic operation;

2. the formulated SQL component possesses good security boundaries.

Drawings

FIG. 1 is a schematic diagram of a trigger run logic orchestration process according to the present invention;

FIG. 2 is a schematic diagram of the complex logic process of formulating SQL in conjunction with intermediate forms in the present invention.

Detailed Description

The present invention will be further described in detail below with reference to the drawings and examples in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.

In order to better understand the above technical solutions, the following detailed description will be given with reference to the accompanying drawings and the specific embodiments.

Examples:

referring to fig. 1, the present embodiment provides a technical solution:

s4, returning the result and returning the operation result.

s12, preprocessing the context form data and storing the context form data in one or more intermediate forms, and carrying out necessary processing on the data or selecting proper row or column data to store the data in one or more pre-created intermediate forms;

s13, performing one-step or multi-step relational database operation on the intermediate form and the context form or other forms, writing SQL by using a formulated SQL component, and performing database set operation, relational operation and function operation on the intermediate form and the context form or other service forms, wherein the one-step or multi-step operation is performed; the set operation comprises the operations of a cone, an intersection, a difference and a Cartesian product; the relation operation comprises selection, projection and connection operation; the function operation comprises case, ifnull concrete relation database enriching function library;

s15, deleting the data of the intermediate form, synchronizing the data temporarily stored in the intermediate form into the related form, and performing database adding, deleting and modifying operation;

s16, returning the processing result to the calling party.

Embodiments of the present invention will be described in further detail below with reference to the attached drawings:

referring to fig. 1, the present invention creates a method based on custom SQL statements, formulas and intermediate forms to implement complex logic and control invasiveness of custom SQL in a form type low code system, in which the present invention is based on custom SQL, formulas execute and intermediate forms, and in a form type low code system, events are triggered by manual operations or systems to trigger execution of event driven (logic arrangement), events are triggered by form submission, custom buttons, data selection, process start approval end links, system condition events, etc., as shown in the following table:

in the logic arrangement process, because limited components and single functions are adopted, complex operation, particularly set operation and relation operation, cannot be flexibly processed according to a program language, and the block is a strong item of a relation database;

in the form driving type low-code system, an intermediate form can be used as a calculation intermediate, and the formulated SQL (or self-written SQL) is assembled to perform relational database operation, and the specific steps are as follows:

although embodiments of the present invention have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and alterations can be made therein without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.

Claims

1. A method for implementing complex logic orchestration in a form-driven low-code system, comprising: the method comprises the following steps:

s4, returning the result and returning the operation result.

2. The method for implementing complex logic orchestration in a form-driven low-code system according to claim 1, wherein: in the logic arrangement process, the intermediate form is used as a calculation intermediate, and the SQL formulated by the collection is used for carrying out relational database operation, and the specific steps are as follows:

s15, deleting the middle form data;

s16, returning the processing result to the calling party.

3. The method for implementing complex logic orchestration in a form-driven low-code system according to claim 2, wherein: in step S12, the data is processed as necessary or the appropriate row or column is selected and stored in one or more intermediate forms created in advance.

4. The method for implementing complex logic orchestration in a form-driven low-code system according to claim 2, wherein: in step S13, writing SQL by using a formulated SQL component, and carrying out database collection operation, relation operation and function operation with a context form or other service forms, wherein the operations are carried out in one step or multiple steps; the set operation comprises the operations of a cone, an intersection, a difference and a Cartesian product; the relation operation comprises selection, projection and connection operation; the function operation comprises case and ifnull concrete relation database enriching function library.

5. The method for implementing complex logic orchestration in a form-driven low-code system according to claim 1, wherein: in step S15, the data temporarily stored in the intermediate form is synchronized to the related form, and the database adding, deleting and modifying operation is performed.