CN-116186100-B - Configured data query method, device, system and medium

CN116186100BCN 116186100 BCN116186100 BCN 116186100BCN-116186100-B

Abstract

The invention discloses a configured data query method, a device, a system and a medium, wherein the method comprises the steps of responding to the operation of a query user on a visual interface, acquiring a target function and a query parameter input by the query user; the method comprises the steps of obtaining a pre-stored configuration query file of a target function, analyzing the configuration query file, carrying out data query in a corresponding database according to an analysis result and query parameters of the configuration query file, and displaying a query data result returned by the database on a visual interface. Through the configuration query files stored in advance by each partner, a query user can efficiently and conveniently acquire a data query result through the configured data query logic only by flexibly selecting different functions and inputting query parameters according to requirements, and the manpower communication among multiparty staff is not needed, so that the manpower cost is reduced, and the query efficiency is improved.

Inventors

WANG SHANSHAN

Assignees

平安科技（深圳）有限公司

Dates

Publication Date: 20260505
Application Date: 20230327

Claims (5)

1. A method for configurable data querying, comprising: data query operation among different partners is carried out through a visual interface, and a target function and query parameters input by a query user are obtained in response to the operation of the query user on the visual interface; Acquiring a pre-stored configured query file of the target function, wherein the configured query file is used for storing data query logic of the target function, and the data query logic comprises a plurality of query tables and linkage query relations among the query tables; analyzing the configured query file, and carrying out data query in a corresponding database according to the analysis result of the configured query file and the query parameters; Displaying query data results returned by the database on the visual interface; the method further comprises the steps of, before the target function and the query parameter input by the query user are acquired in response to the operation of the query user on the visual interface: displaying a query configuration template on a visual interface; receiving data query logic and parameter requirements of a plurality of functions input by a configuration user through the query configuration template, wherein the configuration user is a different function developer; Packaging the query logic and parameter requirements of each function to generate a corresponding configured query file and a visual function query card; the responding to the operation of the inquiring user on the visual interface, obtaining the target function and the inquiring parameter input by the inquiring user comprises the following steps: based on all the current configured query functions, displaying a plurality of function query cards on a visual interface; Acquiring a currently selected target function according to the selection operation of the function query card by a query user; the parameter input component displays the target function, and receives the query parameters input by the query user through the parameter input component so as to initiate a data query request for the development function of the partner; After the target function and the query parameter input by the query user are acquired in response to the operation of the query user on the visual interface, the method further comprises the following steps: Acquiring authority information of the inquiring user based on data security levels among different partners, and confirming whether the inquiring user has inquiring authority on the target function; The parsing the configured query file, and performing data query in a corresponding database according to the parsing result of the configured query file and the query parameters, includes: analyzing the configured query file to obtain a corresponding SQL statement, wherein the SQL statement corresponds to the data query logic; And carrying out linkage query on the query table in the corresponding database according to the SQL statement.
2. The method of claim 1, wherein the configurable query file is an XML file.
3. A configurable data querying device, comprising: The first acquisition module is used for carrying out data query operation among different partners through a visual interface, and responding to the operation of a query user on the visual interface to acquire a target function and query parameters input by the query user; The second acquisition module is used for acquiring a pre-stored configured query file of the target function, wherein the configured query file is used for storing data query logic of the target function, and the data query logic comprises a plurality of query tables and linkage query relations among the query tables; the analysis query module is used for analyzing the configured query file and carrying out data query in a corresponding database according to the analysis result of the configured query file and the query parameters; The result display module is used for displaying the query data result returned by the database on the visual interface; the template display module is used for displaying the query configuration template on the visual interface; The configuration module is used for receiving data query logic and parameter requirements of a plurality of functions input by a configuration user through the query configuration template, wherein the configuration user is a different function developer; The generation module is used for packaging the query logic and the parameter requirements of each function to generate a corresponding configured query file and a visual function query card; The first acquisition module comprises: the card display unit is used for displaying a plurality of function query cards on the visual interface based on all the current configured query functions; The function confirmation unit is used for acquiring a currently selected target function according to the selection operation of the function query card by a query user; The parameter acquisition unit is used for displaying the parameter input component of the target function and receiving the query parameters input by the query user through the parameter input component so as to initiate a data query request for the development function of the partner; The device further comprises: The permission verification module is used for acquiring permission information of the inquiring user based on data security levels among different partners and confirming whether the inquiring user has inquiring permission on the target function; the analysis query module comprises: The analysis unit is used for analyzing the configured query file to obtain a corresponding SQL statement, and the SQL statement corresponds to the data query logic; And the query unit is used for carrying out linkage query on the query table in the corresponding database according to the SQL statement.
4. A configured data query system, wherein the system comprises at least one processor, and A memory communicatively coupled to the at least one processor, wherein, The memory stores instructions executable by the at least one processor to enable the at least one processor to perform the configured data query method of any one of claims 1-2.
5. A non-transitory computer-readable storage medium storing computer-executable instructions which, when executed by one or more processors, cause the one or more processors to perform the configured data query method of any of claims 1-2.

Description

Configured data query method, device, system and medium Technical Field The present invention relates to the field of computer technologies, and in particular, to a method, an apparatus, a system, and a medium for configured data query. Background In the software testing process, most of software has the data processing condition of cooperation with a third party or cross-team, so that the data in the opposite party library needs to be checked in the testing process, thereby verifying whether the data is correct or not. The traditional data query interaction process is based on the consideration of data confidentiality and safety, and generally depends on the cooperation of testers of both parties, and results are fed back after the databases are checked according to the requirements of query parties, so that the manual interaction query increases the labor cost and the time cost, and efficient data query among different partners is difficult to realize. Disclosure of Invention In view of the above-mentioned shortcomings of the prior art, an object of the present invention is to provide a configured data query method, device, system and medium applicable to the fields of financial science and technology or other related fields, which aims to ensure security and improve data query efficiency between multiple partners. The technical scheme of the invention is as follows: A method of configurable data querying, the method further comprising: Responding to the operation of a query user on a visual interface, and acquiring a target function and a query parameter input by the query user; acquiring a pre-stored configured query file of the target function, wherein the configured query file is used for storing data query logic of the target function; analyzing the configured query file, and carrying out data query in a corresponding database according to the analysis result of the configured query file and the query parameters; and displaying the query data result returned by the database on the visual interface. In one embodiment, the responding to the operation of the query user on the visual interface, obtaining the target function and the query parameter input by the query user includes: Displaying a plurality of function query cards on a visual interface; Acquiring a currently selected target function according to the selection operation of the function query card by a query user; And the parameter input component displays the target function and receives the query parameters input by the query user through the parameter input component. In one embodiment, before the target function and the query parameter input by the query user are acquired in response to the operation of the query user on the visual interface, the method further includes: displaying a query configuration template on a visual interface; Receiving data query logic and parameter requirements of a plurality of functions input by a configuration user through the query configuration template; And packaging the query logic and the parameter requirements of each function to generate a corresponding configured query file and a visual function query card. In one embodiment, after the target function and the query parameter input by the query user are acquired in response to the operation of the query user on the visual interface, the method further includes: and acquiring the authority information of the inquiring user, and confirming whether the inquiring user has the inquiring authority to the target function. In one embodiment, the data query logic includes a number of query tables, and a linkage query relationship between the respective query tables. In one embodiment, the parsing the configured query file, and performing a data query in a corresponding database according to the parsing result of the configured query file and the query parameter, includes: analyzing the configured query file to obtain a corresponding SQL statement, wherein the SQL statement corresponds to the data query logic; And carrying out linkage query on the query table in the corresponding database according to the SQL statement. In one embodiment, the configured query file is an XML file. A configurable data querying device, comprising: The first acquisition module is used for responding to the operation of a query user on a visual interface and acquiring a target function and a query parameter input by the query user; the second acquisition module is used for acquiring a pre-stored configured query file of the target function, wherein the configured query file is used for storing data query logic of the target function; the analysis query module is used for analyzing the configured query file and carrying out data query in a corresponding database according to the analysis result of the configured query file and the query parameters; And the result display module is used for displaying the query data result returned by the database on the visual interface. A configurable