Development method, system and equipment based on customized page and low code

Abstract

The invention relates to the technical field of software system development, and particularly discloses a development method, system and equipment based on customized pages and low codes, the method comprises the following steps: establishing a temporary table and an auxiliary table which have the same data structure as a database table corresponding to a preset low-code platform component; temporarily storing data generated when the user performs low-code platform component operation in the customized page through the temporary table; and when the data is confirmed to be valid, writing the data in the temporary table into the auxiliary table for storage, and using the data in the temporary table for data echoing of the corresponding low-code platform component on the customized page. And on the basis of meeting a certain condition or system configuration, writing the data in the secondary table into an actual database table corresponding to the low-code platform component. In this way, the component function of the low-code platform can be reused in customized page development, and meanwhile data isolation and synchronization of the same low-code platform component in two different use scenes of the customized page and the low-code page are achieved through system configuration.

Description

Technical Field

[0001] The present invention relates to the technical field of software system development, and particularly to a development method, system and device based on customized pages and low-code. Background Art

[0002] A low-code platform is a development platform that can quickly build application programs without a large amount of code writing. Through visual interfaces, dragging components, and configuring parameters, etc., its core function is to provide visual data application building capabilities. Through a visual way, custom applications are built based on business scenarios to achieve the rapid construction of business scenarios. Specifically in terms of technical ideas, when building an application, a bottom-up idea that conforms to general logical thinking can be adopted, that is, three major steps: database table construction - view presentation - page building. First, create a database table for storing data; then, based on the field definitions of the table and the association relationships between them, build views guided by actual applications; then present pages based on the views. When the application is rendered, a method from the outside to the inside can be adopted, that is, first enter the unified entry component of the page, then query the layout information and render all layout blocks; inside each layout block, query and render the configured container groups; inside the container groups, query and render the views configured therein. It brings new modes and methods to application program development, and it has significant advantages in aspects such as rapid development, cost reduction, and increased business participation.

[0003] A customized page refers to a specific code writing method that is opposite to low-code and does not have the generality of low-code, and is also called high-code. In actual applications, when the development solution of a customized page applies the capabilities of a low-code platform, it cannot achieve data independence in terms of time or space, and cannot establish all master and slave table data and their associations during a single creation process. Summary of the Invention

[0004] In view of this, the purpose of the present invention is to provide a development method, device and device based on customized pages and low-code, so as to overcome the problems that the current development solution of customized pages cannot achieve data independence in terms of time or space, and cannot establish all master and slave table data and their associations during a single creation process when applying the capabilities of a low-code platform.

[0005] To achieve the above purpose, the present invention adopts the following technical solutions:

[0006] In the first aspect, an embodiment of the present application provides a development method based on customized pages and low-code, including:

[0007] Establish a temporary table and a copy table with the same database table data structure as that corresponding to the preset low-code platform components;

[0008] Temporarily save the data generated when the user operates on the low-code platform components in the customized page through the temporary table;

[0009] When it is confirmed that the data is valid, write the data in the temporary table into the copy table for storage, and based on the conditions or system configuration, write the data in the copy table into the actual database table corresponding to the low-code platform component.

[0010] Further, in some embodiments of the present application, the temporarily saving the data generated when the user operates on the customized page through the temporary table includes:

[0011] When the user creates or edits business data through the customized page, perform data interaction through the temporary table and save the business data, where the business data includes a main record corresponding to the customized page and associated sub-records corresponding to the low-code platform components; wherein, the main record is associated with one or more of the associated sub-records.

[0012] Further, in some embodiments of the present application, after temporarily saving the data generated when the user operates on the customized page through the temporary table, it further includes:

[0013] Receive a user instruction. If the user instruction is a confirmation instruction, write the data in the temporary table into the copy table for storage; if the user instruction is a cancellation instruction, discard the data in the temporary table.

[0014] Further, in some embodiments of the present application, it further includes: writing the data in the copy table into the temporary table and displaying the data through the temporary table for the user to edit.

[0015] Further, in some embodiments of the present application, it further includes:

[0016] When creating business data, set pre-IDs for the main record and the associated sub-records respectively, save the pre-IDs in the temporary table, and perform association operations based on the pre-IDs;

[0017] When writing the data in the temporary table into the copy table for storage, replace the pre-IDs with real IDs.

[0018] Further, in some embodiments of the present application, it further includes: directly writing the data in the temporary table into the actual database table corresponding to the low-code platform component based on the preset conditions or system configuration.

[0019] In a second aspect, an embodiment of the present application provides a development system based on a customized page and low code, including:

[0020] A generation module for establishing a temporary table and a copy table with the same database table data structure as that corresponding to a preset low-code platform component;

[0021] A recording module for temporarily saving, through the temporary table, data generated when a user operates on a low-code platform component in a customized page;

[0022] A writing module, when it is confirmed that the data is valid, for writing the data in the temporary table into the copy table for storage, and on the basis of meeting conditions or system configurations, writing the data in the copy table into the actual database table corresponding to the low-code platform component.

[0023] In a third aspect, an embodiment of the present application provides a development device based on a customized page and low code, including a processor and a memory, where the processor is connected to the memory:

[0024] Wherein, the processor is used to call and execute a program stored in the memory;

[0025] The memory is used to store the program, and the program is at least used to execute the development method based on a customized page and low code as described above.

[0026] The present invention relates to the technical field of software system development, and specifically discloses a development method, system and device based on a customized page and low code. The method includes establishing a temporary table and a copy table with the same database table data structure as that corresponding to a preset low-code platform component; temporarily saving, through the temporary table, data generated when a user operates on a low-code platform component in a customized page; when it is confirmed that the data is valid, writing the data in the temporary table into the copy table for storage and used for data echo of the corresponding low-code platform component on the customized page. On the basis of meeting certain conditions or system configurations, writing the data in the copy table into the actual database table corresponding to the low-code platform component. In this way, the component function of the low-code platform can be reused in customized page development, and at the same time, data isolation and synchronization of the same low-code platform component in two different usage scenarios of the customized page and the low-code page can be realized through system configuration. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required for use in the description of the embodiments or the prior art. Obviously, the following drawings are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0028] Figure 1 It is a schematic flowchart of the development method based on a customized page and low code provided by an embodiment of the present invention.

[0029] Figure 2 It is a schematic diagram of creating contract data on a low-code platform in the development method based on a customized page and low code provided by an embodiment of the present invention.

[0030] Figure 3 It is a schematic diagram of initiating contract editing on a low-code platform in the development method based on a customized page and low code provided by an embodiment of the present invention.

[0031] Figure 4 It is a schematic diagram of the completion of contract editing on a low-code platform in the development method based on a customized page and low code provided by an embodiment of the present invention.

[0032] Figure 5 It is a schematic diagram of creating a project and a contract in the development method based on a customized page and low code provided by an embodiment of the present invention.

[0033] Figure 6 It is a schematic diagram of project editing in the development method based on a customized page and low code provided by an embodiment of the present invention.

[0034] Figure 7 It is a schematic diagram of the pre-data mechanism in the development method based on a customized page and low code provided by an embodiment of the present invention.

[0035] Figure 8 It is a schematic diagram of the structure of a development system based on a customized page and low code provided by an embodiment of the present invention.

[0036] Figure 9 It is a schematic diagram of the structure of a development device based on a customized page and low code provided by an embodiment of the present invention. Detailed implementation manners

[0037] To make the objectives, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be described in detail below. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. All other implementation manners obtained by those of ordinary skill in the art without making creative efforts based on the embodiments of the present invention fall within the scope protected by the present invention.

[0038] Application overview:

[0039] When customizing the capabilities of a low-code platform for page functions, the data of the low-code platform created or modified is directly and real-time stored in the low-code platform. However, this is not always as expected. In some cases, users may expect that all processed data will be written into the low-code platform at a certain future time, and the data of the high-code and low-code platforms will remain independent before this time (i.e., data independence within a certain time range); and not write to the low-code platform, keeping the high-code and low-code data stored completely independently (simply understood as data independence within a spatial range).

[0040] Figure 1 FIG. is a schematic flowchart of a development method based on a custom page and a low-code platform provided by an embodiment of the present invention. Please refer to Figure 1 , this embodiment may include the following steps:

[0041] S101. Establish a temporary table and a copy table with the same database table data structure corresponding to a preset low-code platform component.

[0042] S102. Temporarily save the data generated when the user operates on the low-code platform component in the custom page through the temporary table.

[0043] S103. When it is confirmed that the data is valid, write the data in the temporary table into the copy table for storage, and based on meeting conditions or system configurations, write the data in the copy table into the actual database table corresponding to the low-code platform component.

[0044] In practical applications, there are main records in the database table of the custom page, and there are database table sub-records in the low-code platform that can be associated with the main records. For example, the main record can be a project, and the corresponding associated sub-record is a contract. The main record can be a class, and the corresponding associated sub-record is a student.

[0045] In this application, it is possible to reuse the component functions of the low-code platform in custom page development. During the creation process of the main record business data, the sub-record business data needs to be created and associated at the same time. Among them, one main record can be associated with one or more sub-records. The data created during this process does not enter the low-code platform. After the data is created, an approval process is carried out. Only after the approval is passed or based on meeting certain conditions and system configurations, the data is finally written into the low-code platform.

[0046] Specifically, in this application, the database tables existing in the low-code platform itself are referred to as source tables. When developing based on a customized page and low-code, a temporary table and a copy table with the same data structure as the source table are established. During the user operation, the three tables store and transfer data according to the corresponding situations. Among them, the purpose of the temporary table is to save the temporary data during the operation of the customized page, and the purpose of the copy table is to save the data after the operation is confirmed and write this data into the source table of the low-code platform when the conditions are met.

[0047] Specifically, in this application, on the one hand, the low-code front-end components corresponding to the copy table can be independently applied to the customized page to save the customized page data without affecting the low-code data; on the other hand, the low-code data can be written based on the copy table through system configuration or conditions. For the temporary table, the data of the low-code front-end components can be temporarily stored in the customized page scenario through the temporary table. In actual applications, the back-end storage repository table can be automatically switched by judging the application scenario of the low-code components (which will be introduced in detail for each scenario later).

[0048] The present invention provides a development method based on a customized page and low-code. By establishing a temporary table and a copy table with the same data structure as the database table corresponding to the preset low-code platform components; temporarily saving the data generated when the user operates the low-code platform components in the customized page through the temporary table; when the data is confirmed to be valid, writing the data in the temporary table into the copy table for storage and using it for data echo of the corresponding low-code platform components on the customized page. On the basis of meeting certain conditions or system configuration, writing the data in the copy table into the actual database table corresponding to the low-code platform components. In this way, the component functions of the low-code platform can be reused in the customized page development, and at the same time, data isolation and synchronization of the same low-code platform components in two different usage scenarios of the customized page and the low-code page can be achieved through system configuration.

[0049] It can be understood that in the development method based on a customized page and low-code provided in this application, conventional development can be carried out through the low-code platform, that is, sub-records can be independently maintained in the low-code platform (it can be understood that in this application, the data in the low-code platform is called sub-records relative to the data corresponding to the customized page, that is, the main record, and its essence is the actual database table of the low-code platform). Taking project data as the main record and contract data as the associated sub-records as an example, the following is a detailed introduction, specifically as Figures 2 - 4 shown:

[0050] Figure 2 is a schematic diagram of the low-code platform creating contract data in the development method based on a customized page and low-code provided by an embodiment of the present invention, as Figure 2As shown, in the present application, for the scenario of creating contract data on a low-code platform, the data of the low-code platform can be directly written into the source table.

[0051] Figure 3 It is a schematic diagram of the low-code platform initiating contract editing in the development method based on a customized page and low-code provided by an embodiment of the present invention. As Figure 3 shown, in the present application, for the scenario of the low-code platform initiating contract editing, after clicking the edit button in the operation, a pop-up window will appear for data echo. At this time, the echoed data is directly read from the source table.

[0052] Figure 4 It is a schematic diagram of the low-code platform completing contract editing in the development method based on a customized page and low-code provided by an embodiment of the present invention. As Figure 4 shown, in the present application, for the scenario of the low-code platform completing contract editing, after clicking the OK button in the data editing pop-up window in the operation, the data is written into the source table again to overwrite the original data.

[0053] On this basis, operations related to the customized page can be performed. Figure 5 It is a schematic diagram of creating a project and a contract in the development method based on a customized page and low-code provided by an embodiment of the present invention.

[0054] Specifically, during the process of project creation or editing, all interactions related to the contract data of the low-code platform are carried out with the temporary table. When the project creation or editing is completed (including associating the contract), the data in the temporary table is written into the copy table; on the basis of meeting certain conditions or system configurations, after the project is approved, the data is written from the copy table into the source table. It should be noted that in the present application, multiple options can be set in the customized page at this stage to obtain user instructions, such as save, OK, and cancel. As Figure 5 shown, in practical applications, if the user clicks save, a temporary table is generated. When receiving the user's confirmation instruction (that is, confirming that the data is valid), the data in the temporary table is written into the copy table for storage; if the confirmation instruction is not received finally, but the cancel instruction is received, the data in the temporary table will be discarded.

[0055] Furthermore, in some embodiments of the present application, it further includes writing the data in the copy table into the temporary table and displaying the data through the temporary table for the user to edit.

[0056] Specifically, Figure 6 It is a schematic diagram of project editing in the development method based on a customized page and low-code provided by an embodiment of the present invention. As Figure 6As shown in the figure, in the development method based on a customized page and low-code provided by the embodiments of the present application, a user can initiate overall editing of a project and related contracts on the customized page. When the conditions are not met or the system is configured, such as before passing the review, when initiating overall editing of a project and related contracts on the customized page, relevant data in the copy table can be written into a temporary table as the interaction basis for subsequent operations and used for data echo of corresponding low-code platform components on the customized page. Among them, this scenario operationally corresponds to the process in which after the user clicks on project editing, a project editing pop-up window pops up and data is echoed.

[0057] In addition, in some other embodiments of the present application, system settings can also be made according to actual needs so that when preset conditions are met, the data in the temporary table can be directly written into the actual database table corresponding to the low-code platform component.

[0058] Furthermore, in some implementations of the present application, it also includes: when creating a main record and associated sub-records on the customized page, a pre-ID can be set for them. Taking a project and a contract as an example, when creating a project on the customized page, pre-IDs are set for the project and the corresponding contract respectively, and the pre-IDs are saved in the temporary table, and association operations are performed based on the pre-IDs; when writing the data in the temporary table into the copy table for storage, the pre-IDs are replaced with real IDs.

[0059] In practical applications, when the customized page function uses the capabilities of the low-code platform, it is impossible to establish the data of all master and slave tables (i.e., main records and sub-records) and their associations during a single creation process. During a single creation process, when creating the data of all master and slave tables simultaneously, for this problem, the data can be cached locally (if it is a web page, the principle is the same, and it can be cached in the browser memory). When the user clicks on create and confirm, all the data is created simultaneously and the corresponding management relationships are established. However, when there is a large amount of master and slave table data or the relationships are complex, this approach has the problem that all data cannot be correctly created and is easily lost when a data error occurs.

[0060] In view of the above problems, in some other embodiments of the present application, a pre-data mechanism can be used to solve them.

[0061] Specifically, Figure 7 is a schematic diagram of the pre-data mechanism in the development method based on a customized page and low-code provided by the embodiments of the present invention, as Figure 7As shown, when the customized page function uses the capabilities of the low-code platform, specifically when initiating the creation of customized page data, a pre-ID is preset for the customized page data, that is, the pre-ID is set, and when initiating the creation of low-code data, a pre-ID is preset for the low-code data, that is, the pre-ID is set; among them, each data operation of the low-code carries these two pre-IDs to generate an association relationship and directly writes it into the database (at this time, the data is stored in the temporary table); when all data creation is completed and the user clicks the final confirmation, when migrating the data from the temporary table to the copy table, the preset association relationship is replaced with the real association relationship, that is, the pre-ID is replaced with the real ID.

[0062] Based on the same inventive concept, the present application also provides a development system based on a customized page and low-code for implementing the above method embodiments. Figure 8 It is a schematic structural diagram of the development system based on a customized page and low-code provided by an embodiment of the present invention, as Figure 8 shown, the system includes:

[0063] A generation module 11 for establishing a temporary table and a copy table with the same database table data structure corresponding to the preset low-code platform components; a recording module 12 for temporarily saving the data generated when the user operates the low-code platform components in the customized page through the temporary table; a writing module 13 for writing the data in the temporary table into the copy table for storage when it is confirmed that the data is valid, and writing the data in the copy table into the actual database table corresponding to the low-code platform components on the basis of meeting the conditions or system configuration.

[0064] Regarding the system in the above embodiments, the specific manners in which each module performs operations have been described in detail in the embodiments related to the method, and will not be elaborated in detail here.

[0065] The present invention also provides a development device based on a customized page and low-code for implementing the above method embodiments. Figure 9 It is a schematic structural diagram of the development device based on a customized page and low-code provided by an embodiment of the present invention, as Figure 9 shown, the development device based on a customized page and low-code in this embodiment includes a processor 21 and a memory 22, and the processor 21 is connected to the memory 22. Among them, the processor 21 is used to call and execute the program stored in the memory 22; the memory 22 is used to store the program, and this program is at least used to execute the development method based on a customized page and low-code in the above embodiments.

[0066] The specific implementation schemes of the development device based on a customized page and low-code provided by the embodiments of the present application can refer to the implementation manners of the development method based on a customized page and low-code in any of the above embodiments, and will not be elaborated here.

[0067] It is understandable that the same or similar parts in the above embodiments can be referred to each other, and for the content not described in detail in some embodiments, reference can be made to the same or similar content in other embodiments.

[0068] It should be noted that in the description of the present invention, terms such as "first" and "second" are only used for descriptive purposes and cannot be construed as indicating or implying relative importance. In addition, in the description of the present invention, unless otherwise specified, the meaning of "a plurality of" refers to at least two.

[0069] Any process or method description shown in the flowchart or described in other ways herein can be understood to represent a module, segment, or part of code including one or more executable instructions for implementing a specific logical function or process. The scope of the preferred embodiments of the present invention includes additional implementations, where the functions can be executed in a substantially simultaneous manner or in a reverse order according to the functions involved, rather than in the order shown or discussed, which should be understood by those skilled in the technical field of the embodiments of the present invention.

[0070] It should be understood that each part of the present invention can be implemented by hardware, software, firmware, or a combination thereof. In the above embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, any one or a combination of the following well-known technologies in the art can be used: discrete logic circuits with logic gate circuits for implementing logical functions on data signals, application-specific integrated circuits with appropriate combinational logic gate circuits, programmable gate arrays (PGAs), field-programmable gate arrays (FPGAs), etc.

[0071] Those of ordinary skill in the technical field of the present invention can understand that all or part of the steps carried by the methods of the above embodiments can be completed by instructing relevant hardware through a program, and the program can be stored in a computer-readable storage medium. When the program is executed, it includes one or a combination of the steps of the method embodiments.

[0072] In addition, each functional unit in various embodiments of the present invention can be integrated into a processing module, or each unit can exist physically alone, or two or more units can be integrated into a module. The above integrated module can be implemented in the form of hardware or in the form of a software functional module. When the above integrated module is implemented in the form of a software functional module and sold or used as an independent product, it can also be stored in a computer-readable storage medium.

[0073] The above-mentioned storage medium can be a read-only memory, a magnetic disk, an optical disc, etc.

[0074] In the description of this specification, the descriptions referring to terms such as "one embodiment", "some embodiments", "examples", "specific examples", or "some examples" etc. mean that the specific features, structures, materials, or characteristics described in connection with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials, or characteristics described may be combined in a suitable manner in any one or more embodiments or examples.

[0075] Although the embodiments of the present invention have been shown and described above, it can be understood that the above embodiments are exemplary and should not be construed as limiting the present invention. Those of ordinary skill in the art can make changes, modifications, substitutions, and variations to the above embodiments within the scope of the present invention.

Claims

1. A development method based on customized pages and low code, characterized in that: include: Create temporary tables and replica tables with the same data structure as the database tables corresponding to the preset low-code platform components; The temporary table is used to temporarily store the data generated when the user operates the low-code platform component in the customized page; When the data is confirmed to be valid, the data in the temporary table is written into the replica table for storage, and based on the conditions or system configuration, the data in the replica table is written into the actual database table corresponding to the low-code platform component.

2. The development method based on customized pages and low code according to claim 1 is characterized in that: The temporary table temporarily stores the data generated when the user performs a customized page operation, including: When a user creates or edits business data through the customized page, data interaction is performed through the temporary table and the business data is saved, wherein the business data includes a main record corresponding to the customized page and associated sub-records corresponding to the low-code platform component; wherein the main record is associated with one or more associated sub-records.

3. The development method based on customized pages and low code according to claim 2 is characterized in that: After temporarily saving the data generated when the user performs the customized page operation through the temporary table, the method further includes: A user instruction is received. If the user instruction is a confirmation instruction, the data in the temporary table is written into the replica table for storage; if the user instruction is a cancellation instruction, the data in the temporary table is discarded.

4. The development method based on customized pages and low code according to claim 3 is characterized in that: Also includes: The data in the copy table is written into the temporary table, and the data is displayed through the temporary table for user editing.

5. The development method based on customized pages and low code according to claim 4 is characterized in that: Also includes: When creating business data, pre-IDs are set for the main record and the associated sub-record respectively, and the pre-IDs are saved in the temporary table, and an association operation is performed based on the pre-IDs; When the data in the temporary table is written into the replica table for storage, the pre-ID is replaced with the real ID.

6. A development system based on customized pages and low code, characterized in that: include: A generation module for establishing a temporary table and a replica table having the same data structure as a database table corresponding to a preset low-code platform component; A recording module, used to temporarily save, through the temporary table, the data generated when the user operates the low-code platform components in the customized page; The writing module is used to write the data in the temporary table into the replica table for storage when the data is confirmed to be valid, and to write the data in the replica table into the actual database table corresponding to the low-code platform component based on the conditions or system configuration.

7. A development device based on custom pages and low code, characterized in that, The invention comprises a processor and a memory, wherein the processor is connected to the memory: Wherein, the processor is used to call and execute the program stored in the memory; The memory is used to store the program, and the program is at least used to execute the customized page and low-code development method described in any one of claims 1-5.

Images