CN115827670A - DSL-based view processing method, system, device and storage medium - Google Patents
DSL-based view processing method, system, device and storage medium Download PDFInfo
- Publication number
- CN115827670A CN115827670A CN202211570381.8A CN202211570381A CN115827670A CN 115827670 A CN115827670 A CN 115827670A CN 202211570381 A CN202211570381 A CN 202211570381A CN 115827670 A CN115827670 A CN 115827670A
- Authority
- CN
- China
- Prior art keywords
- data
- view
- dsl
- field
- rendering
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a view processing method, a system, equipment and a storage medium based on DSL, wherein the method comprises the following steps: constructing a DSL query statement according to view configuration information input by a user, and executing the DSL query statement to query database table data to obtain a data query result; wherein the view configuration information comprises field screening logic information and multi-field combination logic information; matching the data query result with a preselected view component to obtain a data dimension mapping relation; rendering a preselected view component according to the data dimension mapping relation, and displaying a view rendering result; the invention supports the user to edit and screen the logic by using natural language, and the back end automatically analyzes the sense-escape DSL query statement, thereby returning the data query result based on the DSL query statement, and automatically rendering the visual page, realizing the quick rendering of the view, and reducing the front-end development amount without the participation of developers.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a DSL-based view processing method, system, device, and storage medium.
Background
DSL (Domain specific Language) refers to a Domain-specific Language and is used to solve the problem that at the early stage of system construction (including hardware system and software system), the Language models of users and constructors are not consistent, which makes demand collection difficult. DSL is a specialized tool designed in the demand analysis phase to address the difficulty of understanding each other between demand descriptors and builders during the demand collection process. However, the conventional DSL is not conducive to fast data query by a user, and if the data needs to be paged, developers need to configure page effects in advance from data query to data display, and the developers are required to construct different query logic components, which results in a large development amount.
Disclosure of Invention
Embodiments of the present invention provide a DSL-based view processing method, system, device, and storage medium, which support a user to edit a screening logic in a natural language, can render a view quickly, do not require a developer to participate, and reduce the amount of front-end development.
In a first aspect, an embodiment of the present invention provides a DSL-based view processing method, including:
constructing a DSL query statement according to view configuration information input by a user, and executing the DSL query statement to query database table data to obtain a data query result; wherein the view configuration information comprises field screening logic information and multi-field combination logic information;
matching the data query result with a preselected view component to obtain a data dimension mapping relation;
and rendering the preselected view components according to the data dimension mapping relation, and displaying a view rendering result.
As an improvement of the above scheme, the matching the data query result with a preselected view component to obtain a data dimension mapping relationship includes:
analyzing a field structure of the data query result to obtain metadata information; wherein the metadata information includes a field type;
analyzing the attribute parameters of the selected view components; wherein the attribute parameters include a dimension field type;
and matching the metadata information with the attribute parameters to obtain a data dimension mapping relation.
As an improvement of the above, the DSL-based view processing method further includes:
responding to the user to select operation on the dimension field type of the current rendered view, and adjusting the corresponding view component; the dimension field type of the adjusted view component is different from that of the view component before adjustment;
the adjusted view component and the data query result are matched again, and the data dimension mapping relation is modified;
and rendering the modified view component according to the modified data dimension mapping relation, and displaying a view rendering result.
As an improvement of the above scheme, the constructing a DSL query statement according to the view configuration information input by the user includes:
carrying out keyword validity check on the field screening logic information and the multi-field combined logic information;
and when the keyword validity is verified, carrying out field splitting on the field screening logic information and the multi-field combined logic information, and converting the field screening logic obtained after splitting into a DSL query statement.
As an improvement of the above, the DSL-based view processing method further includes:
responding to the click operation of a user on any object in the current rendered view, and acquiring a data identifier corresponding to the object;
querying the data content of the object from the database table data according to the data identification;
and according to the metadata information and a pre-configured DSL statement of the pattern, adopting the inquired data content rendering field to fill in the pattern, obtaining a data detail page and displaying the data detail page on an interface where the current rendered view is positioned.
As an improvement of the above, the DSL-based view processing method further includes:
responding to modification operation of a user on the detailed data page, and acquiring modification content in the detailed data page and data identification of an object corresponding to the detailed data page;
constructing a DSL updating statement according to the data identification of the object corresponding to the data detail page;
and executing the DSL updating statement to perform data updating on the base table data.
In a second aspect, an embodiment of the present invention provides a DSL-based view processing system, including:
the data query module is used for constructing a DSL query statement according to the view configuration information input by a user, and executing the DSL query statement to query the base table data to obtain a data query result;
the data matching module is used for matching the data query result with a preselected view component to obtain a data dimension mapping relation;
and the view rendering module is used for rendering the preselected view components according to the data dimension mapping relation and displaying the view rendering result.
As an improvement of the above scheme, the data matching module includes:
the first field analysis unit is used for analyzing the field structure of the data query result to obtain metadata information; wherein the metadata information includes a field type;
the second field analysis unit is used for analyzing the attribute parameters of the selected view components; wherein the attribute parameters include a dimension field type;
and the field information matching unit is used for matching the metadata information with the attribute parameters to obtain a data dimension mapping relation.
In a third aspect, an embodiment of the present invention provides a DSL-based view processing apparatus, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, where the processor, when executing the computer program, implements the DSL-based view processing method according to any one of the first aspect.
In a fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, where the computer-readable storage medium includes a computer program stored therein, where the computer program, when running, controls an apparatus where the computer-readable storage medium is located to perform the DSL-based view processing method according to any one of the first aspect.
Compared with the prior art, the embodiment of the invention has the beneficial effects that: constructing a DSL inquiry statement based on view configuration information input by a user, wherein the view configuration information comprises field screening logic information and multi-field combination logic information, and executing the DSL inquiry statement to inquire base table data to obtain a data inquiry result; matching the data query result with a preselected view component to obtain a data dimension mapping relation; rendering a preselected view component according to the data dimension mapping relation, and displaying a view rendering result; the invention supports the user to edit and screen the logic by natural language, and the back end automatically analyzes the word sense escape DSL query statement, thereby returning the data query result based on the DSL query statement, and automatically rendering the visual page, realizing the quick rendering of the view, and reducing the front-end development amount without the participation of developers.
Drawings
In order to more clearly illustrate the technical solution of the present invention, the drawings occupied in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.
Fig. 1 is a flowchart of a DSL-based view processing method according to an embodiment of the present invention;
fig. 2 is a schematic diagram of a DSL-based view processing system according to an embodiment of the present invention;
fig. 3 is a schematic diagram of a DSL-based view processing apparatus according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Example one
Please refer to fig. 1, which is a flowchart of DSL-based view processing according to an embodiment of the present invention, where the method specifically includes:
s1: constructing a DSL query statement according to view configuration information input by a user, and executing the DSL query statement to query database table data to obtain a data query result; wherein the view configuration information comprises field screening logic information and multi-field combination logic information;
the field screening logic information and the multi-field combination logic information are data screening conditions input by a user on a user interface and are used for screening database table data. Wherein, the field screening logic information and the multi-field combination logic information comprise operation types, field names, operators, logic operators, conditional combination logic and the like. View data sets may be constructed from the field screening logical information and the multi-field combinatorial logical information.
The operation types comprise screening, hiding, sorting, freezing and grouping, the functions are all used for defining data contents in the view and configuring how the data sets are displayed, for example, sorting according to reimbursement amount, grouping and displaying according to reimbursement departments, freezing reimbursers in a first column, hiding and not displaying reimbursement invoices, not displaying approved data and the like, and different view display effects of different data sets can be indicated through different operation types. Operators, logical operators, and conditional combinatorial logic are used to construct the screening logic, e.g., operators include equals, greater, contains, etc. operations; logical operators include and, or, not, etc. operations; conditional combinatorial logic indicates the combination of multiple field filters.
The following examples are given: setting field screening logic information:
1. date of birth: the time ranges are as follows: 20220701-20220930;
2. keyword fingerprint: equal to any of the following values: 478943eff7d, f4135e12,.., 1820c012c;
3. and others: equal to any of the following values { }, { "uid": "" }, { "plate _ name": "science and technology" }, { "tertiary": APP "};
4. the year of birth: all records are recorded;
5. the content is as follows: condition search: XXX (keywords);
based on the set screening conditions, the self-defined multi-field combinational logic information is 1AND 2AND 3, at this time, DSL inquiry sentences can be constructed according to the birth date, the keyword fingerprints and other three screening logics to inquire and screen the database table data, and data inquiry results are returned in a json style.
S2: matching the data query result with a preselected view component to obtain a data dimension mapping relation;
illustratively, the system is preset with several view components, such as icon view type view components, including but not limited to line graphs, bar graphs, pie charts, scatter charts, K-line graphs, radar charts, box and whisker graphs, thermodynamic diagrams, relationship graphs, path graphs, tree graphs, rectangular tree graphs, asahi-day graphs, mulberry graphs, funnel graphs, and dashboards; view components of the type of kanban view, including but not limited to base forms, gantt charts, calendars, photo albums, kanban charts, forms, and list views. Furthermore, the attribute parameters of each view component can be preset by a system or can be set by a user in a self-defining way, and can be directly called for use when the data view is rendered and displayed, or can be used after the attribute parameters of the view components are adjusted. The attribute parameters comprise dimension field types of corresponding views, metadata corresponding to the dimension field types, assembling modes of different row and column data sets and the like.
Taking the gantt chart as an example, the dimension field types preset by the system are start and end time types, the metadata of the dimension field types are time types, the end time is larger than the start time, and the rest attribute parameters further comprise task bar colors and main objects (people, things and things). Taking the histogram as an example, the preset dimension field types of the system are: the vertical axis is the numeric field type, the horizontal axis is the text and non-empty field type, and the pillar color is blue.
S3: and rendering the preselected view components according to the data dimension mapping relation, and displaying the view rendering result.
Taking a fee reimbursement form as an example, assuming that a user needs to care about city distribution conditions with reimbursement amount larger than 200, the user sets field screening logic information and multi-field combination logic information on a user interface as 'reimbursement fee exceeding 200 yuan' and selects a view component as a pie chart, then the system converts the data screening conditions into DSL query statements and executes the DSL query statements, and then data contents meeting 'reimbursement fee exceeding 200 yuan', namely data query results, can be screened from the fee reimbursement form. And then carrying out field type matching on the data query result and the selected view component to obtain a data dimension mapping relation, and rendering and displaying the selected view component based on the data dimension mapping relation. In the embodiment of the invention, the page provides rich components, so that a user is supported to edit and screen logic by using a natural language, and the back end automatically analyzes the sense-escape DSL query statement, thereby returning a data query result based on the DSL query statement, automatically rendering a visual page, realizing quick rendering of a view, and reducing the front-end development amount without participation of developers; meanwhile, the user can quickly define the view and switch the view style.
In an optional embodiment, the matching the data query result with a preselected view component to obtain a data dimension mapping relationship includes:
analyzing a field structure of the data query result to obtain metadata information; wherein the metadata information includes a field type;
analyzing the attribute parameters of the selected view components; wherein the attribute parameters include a dimension field type;
and matching the metadata information with the attribute parameters to obtain a data dimension mapping relation.
In an optional embodiment, the DSL-based view processing method further comprises:
responding to the user to select operation on the dimension field type of the current rendered view, and adjusting the corresponding view component; the dimension field type of the adjusted view component is different from that of the view component before adjustment;
re-matching the adjusted view component with the data query result, and modifying the data dimension mapping relation;
and rendering the modified view component according to the modified data dimension mapping relation, and displaying a view rendering result.
It should be noted that the metadata information further includes information such as a field length, a data amount, and a word sense; the dimension field type indicates the field requirements of the view, and the attribute parameters also comprise a style configuration key attribute indicating other configurations of the view, such as column color of a histogram, task bar color of a Gantt chart. And automatically generating a data dimension mapping relation by matching the conformity of the dimension field type of the analyzed view component with the field type of the data query result. Taking the expense reimbursement statistical table and the view component displayed by target rendering as an example, the date field of the calendar map is matched with the reimbursement date field of the expense reimbursement statistical table, and then the date field of the calendar map is used for paving and displaying reimbursement date. The user can also reconstruct the DSL query statement and automatically render a data page according to the service requirement and the mapping field in the data dimension mapping relationship corresponding to the calendar graph, for example, the data page is displayed by switching "date field-reimbursement date" to "date field-reimbursement approval time". In the embodiment of the invention, the data dimension mapping relationship between the data and the view can be modified by adjusting the dimension field type of the view component, so that the dimension information displayed by the view is adjusted, and the problems of poor view solidification and interchangeability of the traditional BI tool and business system are solved.
In an alternative embodiment, the constructing the DSL query statement according to the view configuration information input by the user includes:
carrying out keyword validity check on the field screening logic information and the multi-field combined logic information;
and when the keyword validity is verified, carrying out field splitting on the field screening logic information and the multi-field combined logic information, and converting the field screening logic obtained after splitting into a DSL query statement.
In the embodiment of the invention, the keyword validity check mainly comprises the steps of judging whether the field screening logic information and the multi-field combined logic information have at least one of an operator, a logic operator and a condition combined operator, if yes, confirming that the keyword validity check passes, and otherwise, prompting a user to input the view configuration information again. And after the validity of the keyword is checked, splitting the field screening logic information and the multi-field combined logic information into a target field, a screening field, a summary field and the like. The target field indicates a non-hidden field configured in a page, namely a data column which can be displayed by a view; the screening field indicates the screening field selected in the page; the summary field indicates which field the statistics are based on. And then the split fields are used as field screening logic, then are transferred into Boolean query statements, and finally are resolved into a string of operational DSL query statements.
In an optional embodiment, the DSL-based view processing method further comprises:
responding to the click operation of a user on any object in the current rendered view, and acquiring a data identifier corresponding to the object;
querying the data content of the object from the database table data according to the data identification;
and according to the metadata information and a pre-configured DSL statement of the pattern, adopting the inquired data content rendering field to fill in the pattern, obtaining a data detail page and displaying the data detail page on an interface where the current rendered view is positioned.
In the embodiment of the invention, taking a pie chart as an example, sectors in the pie chart are cities, and the sector area is the proportion of the number of the cities, so that a user clicks one sector city in the pie chart to display all data lists under the city, clicks one piece of data in the list to display the detailed content of the piece of data. The data identification is the unique identification of a certain piece of data, and when a user inquires a detailed data page and modifies and edits the data, the data can be quickly found in the database based on the unique data identification.
In an optional embodiment, the DSL-based view processing method further comprises:
responding to modification operation of a user on the detailed data page, and acquiring modification content in the detailed data page and data identification of an object corresponding to the detailed data page;
constructing a DSL updating statement according to the data identification of the object corresponding to the data detail page;
and executing the DSL updating statement to perform data updating on the base table data.
In the embodiment of the invention, the data content can be directly modified in the data detail page, and the system automatically submits the modification of the database based on the modified content and the data identifier of the current data, and can also directly add or delete data. In the embodiment of the invention, developers are not needed to participate, the user can adjust the content and the style of the visual page and the related display components at any time, the page can directly edit data, DSL sentences are automatically converted, and data editing operation is carried out, so that the problem that the conventional visual page can not edit data is solved.
Compared with the prior art, the embodiment of the invention has the beneficial effects that: constructing a DSL inquiry statement based on view configuration information input by a user, wherein the view configuration information comprises field screening logic information and multi-field combination logic information, and executing the DSL inquiry statement to inquire base table data to obtain a data inquiry result; matching the data query result with a preselected view component to obtain a data dimension mapping relation; rendering a preselected view component according to the data dimension mapping relation, and displaying a view rendering result; the invention supports the user to edit and screen the logic by natural language, and the back end automatically analyzes the word sense escape DSL query statement, thereby returning the data query result based on the DSL query statement, and automatically rendering the visual page, realizing the quick rendering of the view, and reducing the front-end development amount without the participation of developers.
Example two
Referring to fig. 2, an embodiment of the present invention provides a DSL-based view processing system, including:
the data query module 1 is configured to construct a DSL query statement according to view configuration information input by a user, and execute the DSL query statement to query database table data to obtain a data query result;
the data matching module 2 is used for matching the data query result with a preselected view component to obtain a data dimension mapping relation;
and the view rendering module 3 is used for rendering the preselected view components according to the data dimension mapping relation and displaying the view rendering result.
In an alternative embodiment, the data matching module includes:
the first field analysis unit is used for analyzing the field structure of the data query result to obtain metadata information; wherein the metadata information includes a field type;
the second field analysis unit is used for analyzing the attribute parameters of the selected view components; wherein the attribute parameters include a dimension field type;
and the field information matching unit is used for matching the metadata information with the attribute parameters to obtain a data dimension mapping relation.
In an optional embodiment, the DSL-based view processing system further comprises:
the dimension field adjusting module is used for responding to the user selection operation on the dimension field type of the current rendered view and adjusting the corresponding view component; the dimension field type of the adjusted view component is different from that of the view component before adjustment;
the data dimension mapping relation adjusting module is used for re-matching the adjusted view component with the data query result and modifying the data dimension mapping relation;
and the view adjusting module is used for rendering the modified view component according to the modified data dimension mapping relation and displaying a view rendering result.
In an alternative embodiment, the data query module 1 comprises:
the checking unit is used for checking the validity of the keywords of the field screening logic information and the multi-field combined logic information;
and the DSL query statement conversion unit is used for carrying out field splitting on the field screening logic information and the multi-field combined logic information when the keyword validity is verified, and converting the field screening logic obtained after splitting into the DSL query statement.
In an optional embodiment, the DSL-based view processing system further comprises:
the data identifier acquisition module is used for responding to the click operation of a user on any object in the current rendered view and acquiring the data identifier corresponding to the object;
the query module is used for querying the data content of the object from the database table data according to the data identification;
and the data detail page rendering module is used for adopting the queried data content rendering field to fill in the style according to the metadata information and the pre-configured style DSL statement to obtain a data detail page and displaying the data detail page on the interface where the current rendered view is located.
In an optional embodiment, the DSL-based view processing system further comprises:
the modified data acquisition module is used for responding to modification operation of a user on the detailed data page and acquiring modified content in the detailed data page and a data identifier of an object corresponding to the detailed data page;
a DSL updating statement constructing module, configured to construct a DSL updating statement according to the data identifier of the object corresponding to the data detail page;
and the database updating module is used for executing the DSL updating statement to update the database table data.
It should be noted that the principle and technical effect of the DSL-based view processing system according to the embodiment of the present invention are the same as those of the first embodiment, and are not described herein again.
EXAMPLE III
Referring to fig. 3, a schematic diagram of a DSL-based view processing apparatus according to an embodiment of the present invention is shown. As shown in fig. 3, the DSL-based view processing apparatus includes: at least one processor 11, such as a CPU, at least one network interface 14 or other user interface 13, a memory 15, at least one communication bus 12, the communication bus 12 being used to enable connectivity communications between these components. The user interface 13 may optionally include a USB interface, and other standard interfaces, wired interfaces. The network interface 14 may optionally include a Wi-Fi interface as well as other wireless interfaces. The memory 15 may comprise a high-speed RAM memory, and may further comprise a non-volatile memory (non-volatile) such as at least one disk memory. The memory 15 may optionally comprise at least one memory device located remotely from the aforementioned processor 11.
In some embodiments, memory 15 stores the following elements, executable modules or data structures, or a subset thereof, or an expanded set thereof:
an operating system 151, which contains various system programs for implementing various basic services and for processing hardware-based tasks;
and (5) a procedure 152.
Specifically, the processor 11 is configured to call the program 152 stored in the memory 15 to execute the DSL-based view processing method according to the foregoing embodiment, such as steps S1 to S3 shown in fig. 1. Or, the processor implements the functions of the modules/units in the embodiments of the apparatuses when executing the computer program, for example, the data query module is configured to construct a DSL query statement according to view configuration information input by a user, and execute the DSL query statement to query database table data to obtain a data query result; the data matching module is used for matching the data query result with a preselected view component to obtain a data dimension mapping relation; and the view rendering module is used for rendering the preselected view components according to the data dimension mapping relation and displaying the view rendering result.
Illustratively, the computer program may be partitioned into one or more modules/units that are stored in the memory and executed by the processor to implement the invention. The one or more modules/units may be a series of computer program instruction segments capable of performing certain functions, which are used to describe the execution of the computer program in the DSL-based view processing apparatus.
The DSL-based view processing device may be a desktop computer, a notebook, a palm top computer, a cloud server, or other computing device. The DSL-based view processing apparatus may include, but is not limited to, a processor, a memory. It will be appreciated by those skilled in the art that the schematic diagram is merely an example of a DSL-based view processing apparatus and does not constitute a limitation of DSL-based view processing apparatus and may include more or fewer components than those shown, or some components may be combined, or different components.
The Processor 11 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. The general purpose processor may be a microprocessor or the processor may be any conventional processor or the like, and the processor 11 is a control center of the DSL-based view processing apparatus, and various interfaces and lines are used to connect various parts of the entire DSL-based view processing apparatus.
The memory 15 may be used to store the computer programs and/or modules, and the processor 11 implements various functions of the DSL-based view processing apparatus by running or executing the computer programs and/or modules stored in the memory and invoking data stored in the memory. The memory 15 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, a phonebook, etc.) created according to the use of the cellular phone, and the like. Further, the memory 15 may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
Wherein the DSL-based view processing apparatus integrated module/unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, can be stored in a computer-readable storage medium. Based on such understanding, all or part of the flow of the method according to the embodiments of the present invention may also be implemented by a computer program, which may be stored in a computer-readable storage medium, and when the computer program is executed by a processor, the steps of the method embodiments described above may be implemented. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, read-Only Memory (ROM), random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution medium, and the like.
Example four
The embodiment of the present invention provides a computer-readable storage medium, which includes a computer program stored therein, where when the computer program runs, a device where the computer-readable storage medium is located is controlled to execute the DSL-based view processing method according to any one of the embodiments.
It should be noted that the above-described device embodiments are merely illustrative, where the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. In addition, in the drawings of the embodiment of the apparatus provided by the present invention, the connection relationship between the modules indicates that there is a communication connection between them, and may be specifically implemented as one or more communication buses or signal lines. One of ordinary skill in the art can understand and implement it without inventive effort.
While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention.
Claims (10)
1. A DSL-based view processing method, comprising:
constructing a DSL query statement according to view configuration information input by a user, and executing the DSL query statement to query database table data to obtain a data query result; wherein the view configuration information comprises field screening logic information and multi-field combination logic information;
matching the data query result with a preselected view component to obtain a data dimension mapping relation;
and rendering the preselected view components according to the data dimension mapping relation, and displaying the view rendering result.
2. The DSL-based view processing method of claim 1 wherein said matching said data query result to a preselected view component to obtain a data dimension mapping comprises:
analyzing a field structure of the data query result to obtain metadata information; wherein the metadata information includes a field type;
analyzing the attribute parameters of the selected view components; wherein the attribute parameters include a dimension field type;
and matching the metadata information with the attribute parameters to obtain a data dimension mapping relation.
3. The DSL-based view processing method of claim 1 further comprising:
responding to the user to select operation on the dimension field type of the current rendered view, and adjusting the corresponding view component; the dimension field type of the adjusted view component is different from that of the view component before adjustment;
the adjusted view component and the data query result are matched again, and the data dimension mapping relation is modified;
and rendering the modified view component according to the modified data dimension mapping relation, and displaying a view rendering result.
4. The DSL-based view processing method of claim 1 wherein said constructing DSL query statements in accordance with user-entered view configuration information comprises:
carrying out keyword validity check on the field screening logic information and the multi-field combined logic information;
and when the keyword validity is verified, carrying out field splitting on the field screening logic information and the multi-field combined logic information, and converting the field screening logic obtained after splitting into a DSL query statement.
5. The DSL-based view processing method of claim 2, further comprising:
responding to the click operation of a user on any object in the current rendered view, and acquiring a data identifier corresponding to the object;
querying the data content of the object from the database table data according to the data identification;
and according to the metadata information and a pre-configured DSL statement of the pattern, adopting the inquired data content rendering field to fill in the pattern, obtaining a data detail page and displaying the data detail page on an interface where the current rendered view is positioned.
6. The DSL-based view processing method of claim 5 further comprising:
responding to modification operation of a user on the data detail page, and acquiring modification content in the data detail page and a data identifier of an object corresponding to the data detail page;
constructing a DSL updating statement according to the data identification of the object corresponding to the data detail page;
and executing the DSL updating statement to perform data updating on the base table data.
7. A DSL-based view processing system, comprising:
the data query module is used for constructing a DSL query statement according to the view configuration information input by a user, and executing the DSL query statement to query the base table data to obtain a data query result;
the data matching module is used for matching the data query result with a preselected view component to obtain a data dimension mapping relation;
and the view rendering module is used for rendering the preselected view component according to the data dimension mapping relation and displaying a view rendering result.
8. The DSL-based view processing system of claim 7 wherein the data matching module comprises:
the first field analysis unit is used for analyzing the field structure of the data query result to obtain metadata information; wherein the metadata information includes a field type;
the second field analysis unit is used for analyzing the attribute parameters of the selected view component; wherein the attribute parameters include a dimension field type;
and the field information matching unit is used for matching the metadata information with the attribute parameters to obtain a data dimension mapping relation.
9. A DSL-based view processing apparatus comprising a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor, the processor implementing the DSL-based view processing method of any of claims 1 to 6 when executing the computer program.
10. A computer-readable storage medium, comprising a computer program stored thereon, wherein the computer program, when executed, controls an apparatus in which the computer-readable storage medium is located to perform the DSL-based view processing method according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211570381.8A CN115827670A (en) | 2022-12-08 | 2022-12-08 | DSL-based view processing method, system, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211570381.8A CN115827670A (en) | 2022-12-08 | 2022-12-08 | DSL-based view processing method, system, device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115827670A true CN115827670A (en) | 2023-03-21 |
Family
ID=85545428
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211570381.8A Pending CN115827670A (en) | 2022-12-08 | 2022-12-08 | DSL-based view processing method, system, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115827670A (en) |
-
2022
- 2022-12-08 CN CN202211570381.8A patent/CN115827670A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103020158A (en) | Report form creation method, device and system | |
| CN111079047A (en) | Web-oriented page construction system | |
| CN111414405A (en) | Data acquisition method and device and electronic equipment | |
| CN111914026A (en) | General data exchange sharing service platform | |
| CN111061756A (en) | Data platform, data processing method and electronic equipment | |
| CN115358204A (en) | Report generation method and device, electronic equipment and storage medium | |
| CN113268496A (en) | Client list screening method and device | |
| US7308457B1 (en) | Method and apparatus for providing customized filters to restrict datasets retrieved from a database | |
| CN111476007A (en) | Table generation method, table generation device, computer device and computer-readable storage medium | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN110083685B (en) | Data configuration method and device for intention recognition | |
| CN111797125A (en) | Report creating method and device, electronic equipment and computer readable storage medium | |
| CN116610667A (en) | Service data processing method, device, computer equipment and storage medium | |
| CN111027093A (en) | Access right control method and device, electronic equipment and storage medium | |
| CN115827670A (en) | DSL-based view processing method, system, device and storage medium | |
| CN114860125A (en) | Flow chart processing method, device, equipment and medium | |
| CN114996268A (en) | User-defined report generation method and user-defined report generation device | |
| CN113506099A (en) | Configuration system, method, computer device and storage medium for reporting service | |
| CN116955386A (en) | Data processing method and device and data processing task generation method and device | |
| CN111563221B (en) | Personalized site creation method | |
| CN114064786A (en) | Data display method, data display device and server | |
| CN109902275A (en) | A kind of method and electronic equipment of customized table | |
| CN114003329A (en) | Data display component creating method and device, storage medium and electronic device | |
| CN109766093B (en) | Method and device for collaborative real-time editing, electronic equipment and storage medium | |
| CN111831527A (en) | Method, apparatus, electronic device, and medium for scanning database performance problems |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |