Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
The report generation and display method provided by the application can be applied to an application environment shown in figure 1. Wherein the terminal 102 communicates with the server 104 via a network. The user can generate a report generation request through the terminal and send the report generation request to the server 104, wherein the report generation request carries a service identifier of a service corresponding to the report to be generated and a report generation requirement. After receiving the report generation request, the server 104 obtains the data source of the corresponding service based on the service identifier, and configures the obtained data source to obtain the configured data source. Then, the server 104 may convert the configured data sources based on the report generation requirement, to obtain a data set corresponding to the report to be generated. Further, the server 104 may obtain an initial report style for displaying the data set, determine a target report style from the initial report style based on the received report style selection instruction, and display the data set through the target report style. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smartphones, tablet computers, and portable wearable devices, and the server 104 may be implemented by a stand-alone server or a server cluster composed of a plurality of servers.
In one embodiment, as shown in fig. 2, a report generating and displaying method is provided, and the method is applied to the server in fig. 1 for illustration, and includes the following steps:
Step S202, a report generation request is received, wherein the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement.
The report generation request refers to a request for requesting to generate a web report, and the report generation request carries a service identifier, such as a service name or a service ID, of a service corresponding to the report to be generated.
In this embodiment, the business may be various businesses in the enterprise operation, such as a financial business, an attendance business, or a workload statistics business. Those skilled in the art will appreciate that the business may include more in other embodiments, by way of example only, and the application is not limited in this regard.
The report generation requirements may include specific report requirements, such as a monthly report, a quarterly report, or a daily report, or may also include specific report content, such as a report of attendance of only a person or a department of a company, or a report of absences of all employees of a company, or the like.
In this embodiment, a user may log in the web report generation display system through a user name and a password, and then generate a report generation request by inputting or selecting a service identifier of a corresponding service, and send the report generation request to the server, so that the server performs subsequent processing.
Step S204, based on the service identification, obtaining the data source of the corresponding service, and configuring the obtained data source to obtain the configured data source.
The data source refers to original data corresponding to a business, and may include specific data content of a business, for example, attendance data corresponding to an attendance business, financial data corresponding to a financial business, and the like.
In this embodiment, the data sources may include data sources in a variety of different formats, including but not limited to mysql、oracle、sqlserver、h2、phoenix、mongodb、elasticSearch、presto、moonbox、cassandra、clickhouse、kylin、vertica、hana、impala, etc.
In this embodiment, the server may perform query on the data source according to the service identifier carried in the acquired report generation request, and acquire the queried data source corresponding to the service identifier.
Further, the server may configure the acquired data sources so that the acquired data sources may be subsequently processed.
And step S206, converting the configured data sources based on the report generation requirement to obtain a data set corresponding to the report to be generated.
Wherein, the data set refers to the original data used for generating the web-side business report.
In this embodiment, after completing the configuration of the data source, the server may perform data analysis on the configured data source, and perform data conversion processing, so as to extract data for generating a report, that is, a data set, from the configured data source.
Specifically, the server may process the configured data sources according to the report generation requirement, so as to extract the corresponding data set from the data sources.
Step S208, obtaining an initial report style for displaying the data set.
The report style may be a style for report presentation, and may include, but is not limited to, a table, a pivot table, a card flipping device, a line graph, a bar graph, a scatter graph, a pie chart, a funnel graph, a radar graph, a Sang Ji graph, a map, a web page embedding, a rich text, a fully custom configuration chart, and the like.
In this embodiment, after the server obtains the data set, an initial report pattern that can display the data set may be determined according to the content of the data set, for example, for meteorological data, a more suitable initial report pattern may be determined to be a radar chart, and for data related to geography, the corresponding initial report pattern may be a map, a scatter chart, or the like.
Step S210, determining a target report style from the initial report style based on the received report style selection instruction, and displaying the data set through the target report style.
In this embodiment, the server may determine, according to the extracted data set, an initial report style for displaying the data set, and send the initial report style to the web terminal for display.
In this embodiment, the user may determine a target report style from among the initial report styles displayed on the web terminal through selection of the initial report style.
In the report generating and displaying method, a report generating request is received, the report generating request carries a service identifier of a service corresponding to a report to be generated and a report generating requirement, a data source of the corresponding service is acquired based on the service identifier, the acquired data source is configured to obtain a configured data source, then the configured data source is converted based on the report generating requirement to obtain a data set of the report to be generated, further, an initial report pattern for displaying the data set is determined, and the data set is displayed according to a received selection instruction for a target report pattern in the initial report pattern and the target report pattern determined by the selection instruction. Therefore, the data source of the corresponding service can be obtained according to the obtained service identification and the report generation requirement, the data source is configured, then the corresponding data set is extracted from the data source, and the report is displayed according to the determined target style.
In one embodiment, configuring the acquired data source to obtain the configured data source may include determining a version type of the data source according to the acquired data source, determining a corresponding target driver according to the version type, acquiring data source connection information, and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
In this embodiment, after the server obtains the data source, the server may analyze the version of the data source from the obtained data source to determine the corresponding version type, for example mysql、oracle、sqlserver、h2、phoenix、mongodb、elasticSearch、presto、moonbox、cassandra、clickhouse、kylin、vertica、hana、impala as described above.
Further, the server may obtain a driving file of a corresponding version according to the obtained version type, and then establish a corresponding target driving and an alternative driving list according to the obtained driving file.
In this embodiment, the established target driver may be added to the driver candidate list and sent to the web terminal for display. And the user generates a drive selection instruction through selecting a target drive in a drive alternative list displayed by the web terminal and sends the drive selection instruction to the server.
In this embodiment, after receiving the driving selection instruction, the server may acquire a preconfigured data source connection information blank table template, and send the preconfigured data source connection information blank table template to the web terminal, so as to acquire data source connection information input in the data source connection information blank table template displayed by the web terminal by a user.
Further, the server can configure the data source according to the acquired data source connection information through the target driver, so as to complete connection configuration of the database.
In this embodiment, the data source connection information may further include tuning information, for example, a maximum connection number of the data source, a connection number of a single user, and the like.
In the above embodiment, the version type of the data source is determined according to the acquired data source, then the target drive corresponding to the data source is determined according to the version type, the data source connection information is further acquired, and the data source is configured through the target drive based on the data source connection information, so that the configured data source is obtained. Therefore, the data source of any business can be configured through the corresponding target drive, so that the configured data source can be used later, and the report generation efficiency is improved.
In one embodiment, determining the corresponding target drive based on the version type may include determining the target drive for the corresponding data source from the list of alternative drives based on the version type.
In the embodiment, the method for establishing the alternative drive list includes the steps of obtaining a drive file corresponding to a version type of a data source, storing the drive file in a drive management directory, analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information, and adding a target drive of the corresponding data source in an initial alternative drive list according to the file information to obtain the alternative drive list.
In this embodiment, the server may obtain, according to the obtained version type, a drive file of a corresponding version, for example, for a mysql data source, the corresponding drive file may be "mysql-connector-java-5.1.46.Ja".
In this embodiment, after the server obtains the drive file of the corresponding version, the drive file may be copied to the fixed drive directory, for example, to the lib directory.
In this embodiment, the server may parse the drive file added to the fixed drive directory, and generate file information corresponding to the drive file, such as a drive class file name and a physical address of the file.
Specifically, the server may obtain, by means of file parsing, a drive class file name and a physical address of the file, that is, file information, which are included in the drive file. For example, the server may use the java's file processing class to access the internal file, so as to achieve the purpose of parsing, and obtain the file information of the driving file.
Further, the server may add file information to the static object file to implement adding the target drive of the corresponding data source in the candidate drive list, e.g., adding the drive class file name and the physical address of the file to the static map object to obtain the target drive added to the candidate drive list.
In one embodiment, converting the configured data source to obtain the data set corresponding to the report to be generated may include obtaining corresponding query data and configuration data based on the configured data source, checking the configuration data to determine whether the configuration data has injection risk, screening variable assignment data from the query data and replacing the corresponding variable to be replaced in the configuration data based on the variable assignment data when the configuration data does not have injection risk, obtaining configuration information of the data source, generating a data source connection instance based on the configuration information, and converting the configured data source according to the connection instance and the replaced configuration data to obtain the data set corresponding to the report to be generated.
In this embodiment, the server may obtain, according to the configured data source, the corresponding configuration data, and send the configuration data to the web terminal. The user can input corresponding query variable parameters based on the configuration data displayed by the web terminal, and generate query data to be sent to the server.
In this embodiment, the configuration data may be an sql string, and the query data may be a variable information set.
Further, after the server obtains the query data and the configuration data, the configuration data can be checked to determine whether the injection risk exists in the configuration data. For example, the server performs injection verification on the sql string to avoid the risk of injecting the sql string, specifically, a regular expression may be used to remove the annotation statement in the sql string, and then match whether the sql string contains, but is not limited to, a risk operation instruction such as create, drop, delete, insert, update, truncate, so as to ensure that the sql statement only contains an instruction of a select related query statement.
In this embodiment, when the server determines that the risk instruction exists in the configuration data, an error message is immediately generated, and the web terminal is returned to prompt the user to re-modify the sql string.
In this embodiment, after the verification is passed, when the configuration data does not have the injection risk, the server may screen variable assignment data from the query data, and perform variable replacement on the configuration data according to the screened variable assignment data.
Specifically, the variables corresponding to the variable assignment data can be divided into query variables and authority variables, wherein the query variables are variable fields, specific values are given to the query variables during actual query, data filtering and screening are carried out on the configuration data, and the authority variables are specific values given to the configuration data according to the user roles of the current web report system login users, and data filtering and screening are carried out on the configuration data. The difference between the two is that the query variable needs to be assigned or a default value is used when each query is performed, all user values are the same, and the permission variable is that the users with the same role have the same value.
In this embodiment, after obtaining the variable assignment data, the server may replace the variable to be replaced corresponding to the configuration data, so as to obtain the replaced configuration data, that is, assign the variable assignment data to the configuration data, and generate the executable query script. For example, an sql string "select from user where id = $id$", where $id$is a query variable value of 1, then sql becomes "select from user where id =", and ". The placeholders are used to avoid the injection risk of the replaced values, and meanwhile, the hard analysis of the data SQL can be reduced, so that the execution efficiency is improved.
Further, the server may obtain configuration information of the data source, that is, the data source connection information described above, and generate a data source connection instance according to the data source connection information, so as to connect the data source.
Further, the server may perform data query on the configured data source according to the replaced configuration data, that is, the generated executable query script, and perform data conversion processing to generate a data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries a style identification of the selected target report style.
In the embodiment, the data set is displayed through the target report style, which can include determining a data display requirement corresponding to the target report style based on the style identification, processing the data set according to the data display requirement to obtain an abscissa, an ordinate and data content of the corresponding data set, and rendering the abscissa, the ordinate and the data content.
In this embodiment, the server may determine the selected target report sample according to the report identifier carried in the selection instruction, and obtain the data display requirement corresponding to the preset target report style.
In this embodiment, the resulting data set may include a column name and specific data content. The server may process the data set according to the data display requirement corresponding to the target report style, and process the data set into data corresponding to the report style, for example, data corresponding to the table style or data corresponding to the map style.
In this embodiment, the server may process the post-data set according to the data presentation requirement, and the obtained data may include abscissa data, ordinate data, and specific data content.
Further, the server can conduct data rendering on the abscissa, the ordinate and the data content obtained through processing, and then pushing the data to the web end for display.
In this embodiment, corresponding to different report styles, the abscissa, the ordinate, and the data content corresponding to the report styles are different, and the server may process the data set according to the corresponding data display requirement.
In the above embodiment, the data set is processed according to the corresponding data display requirement, so that the processed data better meets the requirement of the corresponding report style, and the rendering display effect can be improved.
In one embodiment, the method may further include obtaining service update data and updating the data source based on the service update data.
In this embodiment, each service system is updated in real time, and the service is continuously added, deleted or changed. Each service system may generate service update data at preset time intervals, for example, one week or one month, etc.
Further, the service system may send the generated service update data to the server, so that the server updates the data source according to the service update data.
In this embodiment, converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated may include converting the configured updated data source based on the report generation requirement to obtain an updated data set of the report to be generated.
In this embodiment, the server may perform conversion processing on the updated data source based on the report generation requirement, to obtain an updated data set corresponding to the report to be generated.
In this embodiment, the displaying of the data set by the target report style may include displaying the updated data set by the target report style.
Further, the server can display the updated data set according to the determined target report style so as to realize the update display of the report.
In this embodiment, when there is a great change in the data set, such that a specific data content changes by orders of magnitude, for example, the previous data is "10", and due to the update of the data set, the data becomes 1000, the server may adjust the displayed report, for example, adjust the order relation of the ordinate, and so on, by using the updated data set.
In the embodiment, the data source is updated based on the service update data, and then the data set is updated, so that the dynamic update display of the service report can be realized, and the timeliness of the report content can be improved.
In one embodiment, the method further comprises the steps of acquiring a report for displaying the data set through the target report style according to a timing task mode, generating report prompt information and sending the report prompt information to the user terminal.
In this embodiment, the server may configure a timing task, that is, obtain, by means of the timing task, a report shown by the target report rock, generate corresponding report prompt information, for example, mail, and send the report prompt information to the user terminal, and prompt the user to view the corresponding report.
In this embodiment, the mail may be configured for specific personnel to receive, or may be configured dynamically. The mail content, i.e. the report, can be Excel or a picture. The timing expression may be selected to be of a specific type, such as a day, month, etc., or may be configured directly using the cron expression string. And the timing task configuration can be immediately executed after the completion of the timing task configuration to verify the configuration correctness.
In the embodiment, the report is acquired in a timed task mode, the report prompt information is generated and sent to the user terminal, so that the user can acquire the report regularly, and the user can view the report in a more flexible mode.
In one embodiment, the method may further include uploading at least one of the report generation request, the data source, the data set, and the initial report style to the blockchain node for storage.
The blockchain refers to a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. The Block chain is essentially a decentralised database, and is a series of data blocks which are generated by correlation using a cryptography method, and each data Block contains information of a batch of network transactions and is used for verifying the validity (anti-counterfeiting) of the information and generating a next Block.
Specifically, the blockchain may include a blockchain underlying platform, a platform product services layer, an application services layer, and the like.
In this embodiment, the server may upload and store one or more data of the report generation request, the data source, the data set, and the initial report style in the nodes of the blockchain to ensure the privacy and security of the data.
In the above embodiment, at least one of the report generation request, the data source, the data set and the initial report style is uploaded to the blockchain and stored in the node of the blockchain, so that the privacy of the data stored in the blockchain link point can be ensured, and the security of the data can be improved.
It should be understood that, although the steps in the flowchart of fig. 2 are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in fig. 2 may include multiple sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the sub-steps or stages are performed necessarily performed in sequence, but may be performed alternately or alternately with at least a portion of the sub-steps or stages of other steps or other steps.
In one embodiment, as shown in fig. 3, a report generating display device is provided, which includes a report generating request receiving module 100, a data source acquiring and configuring module 200, a data source converting module 300, an initial report style acquiring module 400, and a presentation module 500, wherein:
The report generation request receiving module 100 is configured to receive a report generation request, where the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement.
The data source acquiring and configuring module 200 is configured to acquire a data source corresponding to a service based on the service identifier, and configure the acquired data source to obtain a configured data source.
The data source conversion module 300 is configured to convert the configured data source based on the report generation requirement, so as to obtain a data set corresponding to the report to be generated.
The initial report style acquisition module 400 is configured to acquire an initial report style for displaying a data set.
The display module 500 is configured to determine a target report style from the initial report style based on the received report style selection instruction, and display the data set according to the target report style.
In one embodiment, the data source acquisition and configuration module 200 may include:
And the version type acquisition sub-module is used for determining the version type of the data source according to the acquired data source.
And the target drive determining sub-module is used for determining the corresponding target drive according to the version type.
And the configuration sub-module is used for acquiring the data source connection information, and configuring the data source through the target drive based on the data source connection information to obtain the configured data source.
In one embodiment, the target drive determination submodule is configured to determine a target drive of the corresponding data source from the candidate drive list according to the version type.
In this embodiment, the apparatus may further include:
And the alternate drive list establishing module is used for establishing an alternate drive list.
In this embodiment, the alternate drive list creation module may include:
And the drive file acquisition sub-module is used for acquiring the drive file corresponding to the version type of the data source.
And the analysis sub-module is used for storing the driving file into the driving management directory, and analyzing the driving file in the driving management directory based on a preset analysis mode to obtain corresponding file information.
And the alternate drive list generation sub-module is used for adding target drives of corresponding data sources in the initial alternate drive list according to the file information to obtain an alternate drive list.
In one embodiment, the data source conversion module 300 may include:
and the acquisition sub-module is used for acquiring corresponding query data and configuration data based on the configured data source.
And the verification sub-module is used for verifying the configuration data and judging whether the configuration data has injection risk or not.
And the replacing sub-module is used for screening variable assignment data from the query data when the configuration data does not have injection risk, and replacing the corresponding variable to be replaced in the configuration data based on the variable assignment data to obtain the replaced configuration data.
And the connection instance generation sub-module is used for acquiring the configuration information of the data source and generating a data source connection instance based on the configuration information.
And the conversion sub-module is used for converting the data sources after configuration according to the connection instance and the replaced configuration data to obtain a data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries a style identification of the selected target report style.
In this embodiment, the display module 500 may include:
And the data display requirement determining sub-module is used for determining the data display requirement corresponding to the target report style based on the style identification.
And the processing sub-module is used for processing the data set according to the data display requirement to obtain the abscissa, the ordinate and the data content of the corresponding data set.
And the rendering sub-module is used for rendering the abscissa, the ordinate and the data content.
In one embodiment, the apparatus may further include:
and the updating data acquisition module is used for acquiring service updating data.
And the updating module is used for updating the data source based on the service updating data.
In this embodiment, the data source conversion module 300 is configured to convert the configured updated data source based on the report generation requirement, to obtain an updated data set of the report to be generated.
In this embodiment, the display module 500 is configured to display the updated data set according to the target report style.
In one embodiment, the apparatus further includes:
the report prompt sending module is used for obtaining a report for displaying the data set through the target report style according to the mode of the timing task, generating report prompt information and sending the report prompt information to the user terminal.
In one embodiment, the apparatus may further include:
And the storage module is used for uploading at least one of the report generation request, the data source, the data set and the initial report style to the blockchain node for storage.
The specific limitation of the report generation display device can be referred to the limitation of the report generation display method, and the description thereof is omitted here. The various modules in the report generating display device can be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 4. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer equipment is used for storing report generation requests, data sources, data sets, initial report patterns and other data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements a report generation display method.
It will be appreciated by persons skilled in the art that the architecture shown in fig. 4 is merely a block diagram of some of the architecture relevant to the present inventive arrangements and is not limiting as to the computer device to which the present inventive arrangements are applicable, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is provided, which comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the following steps when executing the computer program, the processor receives a report generation request, wherein the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement, acquires a data source corresponding to the service based on the service identifier, configures the acquired data source to obtain a configured data source, converts the configured data source to obtain a data set corresponding to the report to be generated based on the report generation requirement, acquires an initial report pattern for displaying the data set, and determines a target report pattern from the initial report pattern based on a received report pattern selection instruction and displays the data set through the target report pattern.
In one embodiment, the processor performs configuration on the acquired data source when executing the computer program to obtain the configured data source, and the configuration method may include determining a version type of the data source according to the acquired data source, determining a corresponding target driver according to the version type, acquiring data source connection information, and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
In one embodiment, the processor, when executing the computer program, implements determining the corresponding target drive according to the version type, may include determining the target drive for the corresponding data source from the list of candidate drives according to the version type.
In this embodiment, the method for creating the candidate drive list when the processor executes the computer program may include obtaining a drive file corresponding to a version type of the data source, storing the drive file in the drive management directory, analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information, and adding a target drive of the corresponding data source in the initial candidate drive list according to the file information to obtain the candidate drive list.
In one embodiment, the processor performs conversion on the configured data source to obtain the data set corresponding to the report to be generated when executing the computer program, and the method comprises the steps of acquiring corresponding query data and configuration data based on the configured data source, checking the configuration data to judge whether the configuration data has injection risk, screening variable assignment data from the query data and replacing the corresponding variable to be replaced in the configuration data based on the variable assignment data when the configuration data does not have injection risk, obtaining configuration information of the data source, generating a data source connection instance based on the configuration information, and converting the configured data source according to the connection instance and the replaced configuration data to obtain the data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries a style identification of the selected target report style.
In the embodiment, the processor realizes the display of the data set through the target report style when executing the computer program, and the method can comprise the steps of determining the data display requirement corresponding to the target report style based on the style identification, processing the data set according to the data display requirement to obtain the abscissa, the ordinate and the data content of the corresponding data set, and rendering the abscissa, the ordinate and the data content.
In one embodiment, the processor, when executing the computer program, may further perform the steps of obtaining service update data and updating the data source based on the service update data.
In this embodiment, the processor implements the report generation request based on the execution of the computer program, and converts the configured data source to obtain a data set corresponding to the report to be generated.
In this embodiment, the processor may implement, when executing the computer program, displaying the data set by using the target report style, which may include displaying the updated data set by using the target report style.
In one embodiment, the processor further performs the steps of acquiring a report for displaying the data set through the target report style according to the timing task mode, generating report prompt information and sending the report prompt information to the user terminal.
In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, which when executed by a processor performs the steps of receiving a report generation request, the report generation request carrying a service identifier of a service corresponding to a report to be generated and a report generation requirement, acquiring a data source corresponding to the service based on the service identifier, configuring the acquired data source to obtain a configured data source, converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated, acquiring an initial report pattern for displaying the data set, determining a target report pattern from the initial report pattern based on a received report pattern selection instruction, and displaying the data set through the target report pattern.
In one embodiment, the computer program when executed by the processor performs configuring the acquired data source to obtain the configured data source, and may include determining a version type of the data source according to the acquired data source, determining a corresponding target driver according to the version type, acquiring data source connection information, and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
In one embodiment, the computer program, when executed by the processor, implements determining a corresponding target drive based on the version type, may include determining a target drive for a corresponding data source from a list of candidate drives based on the version type.
In this embodiment, the method for creating the candidate drive list when the computer program is executed by the processor may include obtaining a drive file corresponding to a version type of the data source, storing the drive file in the drive management directory, analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information, and adding a target drive of the corresponding data source in the initial candidate drive list according to the file information to obtain the candidate drive list.
In one embodiment, the computer program is executed by a processor to convert a configured data source to obtain a data set corresponding to a report to be generated, and the method comprises the steps of acquiring corresponding query data and configuration data based on the configured data source, checking the configuration data to determine whether the configuration data has injection risk, screening variable assignment data from the query data and replacing corresponding variables to be replaced in the configuration data based on the variable assignment data when the configuration data does not have injection risk, obtaining configuration information of the data source, generating a data source connection instance based on the configuration information, and converting the configured data source according to the connection instance and the replaced configuration data to obtain the data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries a style identification of the selected target report style.
In this embodiment, the computer program when executed by the processor realizes the display of the data set by the target report style, and may include determining a data display requirement corresponding to the target report style based on the style identification, processing the data set according to the data display requirement to obtain an abscissa, an ordinate and a data content of the corresponding data set, and rendering the abscissa, the ordinate and the data content.
In one embodiment, the computer program when executed by the processor may further perform the steps of obtaining service update data and updating the data source based on the service update data.
In this embodiment, the computer program when executed by the processor implements conversion of the configured data sources based on the report generation requirements to obtain a data set corresponding to the report to be generated, and may include converting the configured updated data sources based on the report generation requirements to obtain an updated data set of the report to be generated.
In this embodiment, the computer program, when executed by the processor, implements the presentation of the data set by the target report style, which may include presenting the updated data set by the target report style.
In one embodiment, the computer program when executed by the processor further comprises the steps of acquiring a report for displaying the data set through the target report style according to the timing task mode, generating report prompt information and sending the report prompt information to the user terminal.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (SYNCHLINK) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.