A processing method and device for generating test quality report
By building a transfer library between the test-specific database and the office-specific system, the automatic generation of test quality reports is achieved, which solves the data accuracy and efficiency problems caused by manual operations in the existing technology and improves the aesthetics and generation efficiency of the report.
Patent Information
- Application Number
- CN202411777952.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-05
- Publication Date
- 2025-09-26
- Estimated Expiration
- 2044-12-05
AI Technical Summary
In the existing technology, the generation process of test quality reports relies on manual operations, resulting in unsatisfactory data accuracy and report generation efficiency. In particular, it is difficult to efficiently generate beautiful and accurate reports in a cross-platform environment.
A transfer library is built between the test-specific database and the office-specific system. Through this library, mirror table data is synchronized at specified time points, and test quality reports are generated based on multi-dimensional tables and visual data dashboards to achieve automated processing.
Through automated processing, the manpower workload of QA engineers is saved, the aesthetics and data accuracy of the test quality report are improved, and the report generation efficiency is improved.
Smart Images

Figure CN119621825B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of data processing, and in particular to a processing method and device for generating a test quality report. Background Art
[0002] With the in-depth application of various databases, systems, platforms or cloud services in the office field, some test departments may encounter situations where they need to connect to multiple types of databases, systems, platforms or clouds in their daily work, such as using one type of dedicated database, platform or cloud to store original test data reports and using another type of dedicated system, platform or cloud to handle daily office processes. In this case, when the quality assurance (QA) engineers of the test department generate test quality reports on a regular basis (weekly, monthly, quarterly or annually, etc.), they need to first manually export a series of table items from the dedicated database, platform or cloud that stores the original test data reports, perform manual data analysis and statistics on all exported table items locally, and manually write a test quality report based on the data analysis and statistical results obtained at that time. Finally, the test quality report written at that time is sent to all report requesters through file upload and distribution on the dedicated system, platform or cloud that handles daily office processes. Due to human factors, the data accuracy and report generation efficiency of this conventional cross-platform test quality report generation method are not ideal.
[0003] A multidimensional table is a table format that can store / display multidimensional data. A visual data dashboard is a visualization tool that can display data through visual objects (such as bar charts, line charts, pie charts, bar charts, scatter plots, combination charts, funnel charts, word clouds, statistics, etc.). Visual data dashboards are often linked with multidimensional tables, that is, each visual object in the dashboard is bound to the fields of the multidimensional table, and when the data in a multidimensional table is updated, the bound visual objects in the dashboard will also be refreshed synchronously. In recent years, many systems, platforms or clouds used to handle daily office processes have provided processing functions for multidimensional tables and data dashboards, such as OFFICE office system, WPS office system, Feishu office system, DingTalk office system, Tencent Cloud, Huawei Cloud, Alibaba Cloud, etc.
[0004] If an automated processing hub could be built between a dedicated test database (platform or cloud) and a dedicated office system (platform or cloud), and this hub were responsible for exporting data from the dedicated test database (platform or cloud) and regularly generating and distributing test quality reports based on the exported data and the multidimensional tables and visual data dashboards provided by the dedicated office system (platform or cloud), this would not only save a lot of manpower but also improve the aesthetics, data accuracy, and report generation efficiency of test quality reports. This is precisely the technical problem that the present invention aims to solve. Summary of the Invention
[0005] The purpose of the present invention is to address the shortcomings of the existing technology and provide a processing method, device, electronic device and computer-readable storage medium for generating a test quality report. The present invention first records each data source platform for storing original test data reports as a source platform, records an office system, platform or cloud that supports multidimensional tables and a visual data dashboard as a target platform, and designates a type of database as a corresponding transfer library; then, a corresponding mirror data table is constructed on the transfer library for each original test data report; and based on a preset dashboard-multidimensional table data mapping relationship, one or more corresponding multidimensional tables and a data dashboard are created on the target platform; and the data mapping relationship between each multidimensional table and all mirror data tables is configured; then, at a specified time point each day, mirror table data synchronization is performed on all mirror data tables based on all original test data reports; and at a specified time point on a specified single day within each specified time period, multidimensional table data synchronization is performed on all multidimensional tables based on all mirror data tables according to the multidimensional table-mirror table data mapping relationship; and when the multidimensional table data synchronization process is completed, the data dashboard is refreshed based on the dashboard-multidimensional table data mapping relationship and all the latest multidimensional tables; and a test quality report is generated and distributed each time the data dashboard is refreshed. The present invention constructs an automatic processing process between a test-specific database (platform or cloud) and an office-specific system (platform or cloud); the present invention can save the manpower workload of QA engineers and improve the report aesthetics, data accuracy and report generation efficiency of the test quality report.
[0006] To achieve the above-mentioned object, a first aspect of an embodiment of the present invention provides a method for generating a test quality report, the method comprising:
[0007] Each data source platform used to store original test data reports is recorded as the first source platform; an office system, platform, or cloud that supports multidimensional tables and visual data dashboards is recorded as the first target platform; and a type of database is designated as the corresponding first transfer library; the first source platform is a type of database, system, platform, or cloud;
[0008] Constructing a corresponding mirror data table on the first transfer library for each of the original test data reports, which is recorded as a corresponding first mirror data table; creating one or more corresponding multidimensional table objects and a data dashboard object on the first target platform based on a preset dashboard-multidimensional table data mapping relationship, and recording each created multidimensional table object as a corresponding first multidimensional table, and recording the created data dashboard object as a corresponding first dashboard; and configuring the data mapping relationship between the multidimensional table and the mirror data table to obtain a corresponding multidimensional table-mirror table data mapping relationship;
[0009] At a first designated time point each day, performing a mirror table data synchronization process on all the first mirror data tables based on all the original test data reports; the first designated time point is any time point within 24 hours of a single day;
[0010] At a second designated time point on a first designated single day within each first designated time period, multidimensional table data synchronization processing is performed on all first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all first mirror data tables; and when the multidimensional table data synchronization processing is completed, the first dashboard is refreshed once based on the dashboard-multidimensional table data mapping relationship and all the latest first multidimensional tables; the first designated time period includes at least weekly, monthly, quarterly, and annually; the first designated single day includes at least the first and last days of the designated time period; the second designated time point is any time point within the twenty-four hours of a single day and the second designated time point is later than the first designated time point;
[0011] Each time the first dashboard is refreshed, a test quality report conversion is performed based on the latest first dashboard to obtain a corresponding first report and send it to a preset report distribution interface.
[0012] Preferably, each of the original test data reports on the first source platform includes a plurality of first data fields; each of the original test data reports corresponds to an original table name; each of the first data fields corresponds to a field name recorded as a first field name;
[0013] The first source platform provides a data query interface for obtaining a specified field of a specified original table, which is recorded as a corresponding first platform interface; the first platform interface is a URL interface, and the interface parameters of the first platform interface include a first name parameter and a second name parameter; the first name parameter corresponds to the name of the original table; the second name parameter corresponds to the first field name; the first platform interface is used to extract the entire column of field data under the first data field specified by the second name parameter in the original test data report specified by the first name parameter to form a corresponding first text file, and return the first text file as interface feedback data; the specific data format of the first text file is composed of multiple first field data;
[0014] Each of the first mirror data tables on the first transfer library includes a plurality of second data fields; each of the first mirror data tables corresponds to a mirror table name; each of the second data fields corresponds to a field name recorded as a second field name; the first mirror data table has a one-to-one correspondence with the original test data report; the mutually corresponding original test data report and the first and second data fields in the first mirror data table have a one-to-one correspondence; the original table names and the mirror table names of the mutually corresponding original test data report and the first mirror data table are consistent; the first and second field names of the mutually corresponding first and second data fields are consistent;
[0015] Each of the first multidimensional tables on the first target platform includes a plurality of third data fields; each of the first multidimensional tables corresponds to a multidimensional table name; each of the third data fields corresponds to a field name recorded as a third field name;
[0016] The first target platform provides a data configuration interface for setting a specified field of a specified multidimensional table, which is recorded as the corresponding second platform interface; the second platform interface is a URL interface, and the interface parameters of the second platform interface include a third name parameter, a fourth name parameter and a second text file; the third name parameter corresponds to the multidimensional table name; the fourth name parameter corresponds to the third field name; the specific data format of the second text file consists of multiple second field data; the second platform interface is used to replace the entire column of field data under the third data field specified by the fourth name parameter in the first multidimensional table specified by the third name parameter according to all the second field data of the second text file.
[0017] Preferably, the dashboard-multidimensional table data mapping relationship is used to configure the first dashboard object type, first object data mapping relationship, first field condition screening relationship, and first statistical method configuration of each first visual dashboard object created on the first dashboard according to the dashboard object type, object data mapping relationship, field condition screening relationship, and statistical method configuration of all visual dashboard objects required for the test quality report;
[0018] The first dashboard includes a plurality of first visual dial objects; the first visual dial object includes the first dial object type, the first object data mapping relationship, the first field condition screening relationship and the first statistical method configuration;
[0019] The first dial object type includes at least a bar chart, a line chart, a pie chart, a bar chart, a scatter chart, a combination chart, a funnel chart, a word cloud, and statistical figures;
[0020] When the first dial object type is a bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart or word cloud, the corresponding first object data mapping relationship is the data mapping relationship between each data axis or data item on the current bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart or word cloud and the third data field specified in the specified first multidimensional table; the corresponding first field condition filtering relationship is the field data filtering condition setting corresponding to each data axis or data item on the corresponding bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart or word cloud, which is composed of the corresponding filtering condition and the condition threshold, and the filtering condition at least includes greater than, less than, equal to, not equal to, greater than or equal to, less than or equal to, include and exclude; the corresponding first statistical method configuration is empty by default;
[0021] When the first dial object type is a statistical number, the corresponding first object data mapping relationship is composed of one or more data source field mapping relationships corresponding to the current statistical number, and each of the data source field mapping relationships corresponds to one of the third data fields in the first multidimensional table; the corresponding first field condition screening relationship is composed of one or more field data screening condition settings, and the field data screening condition settings correspond one-to-one to the data source field mapping relationship; the corresponding first statistical method configuration includes multiple types of statistical methods, one of which is record total statistics, another type of statistical method is maximum value statistics, another type of statistical method is minimum value statistics, and another type of statistical method is mean statistics.
[0022] Preferably, the multidimensional table-mirror table data mapping relationship includes multiple first mapping relationships; the first mapping relationship includes a first target table item and a first source table item; the first target table item includes a first target table name and a first target field name; the first source table item includes a first source table name and a first source field name; the first target table name corresponds to one of the multidimensional table names; the first target field name corresponds to one of the third field names; the first source table name corresponds to one of the mirror table names; the first source field name corresponds to one of the second field names.
[0023] Preferably, the performing mirror table data synchronization processing on all the first mirror data tables based on all the original test data reports specifically includes:
[0024] A round of traversal is performed on all the original table names; and during this round of traversal, the original table name currently traversed is used as the corresponding current original table name; and the first mirror data table corresponding to the mirror table name and the current original table name on the first transfer library is used as the corresponding current mirror data table; and a round of polling is performed on all the first field names corresponding to the current original table name; and during this round of polling, the first field name currently polled is used as the corresponding current field name; and the current original table name and the current field name are sent to the first platform interface as the corresponding first name parameter and the second name parameter; and the first text file returned by the first platform interface is received; and the second field name in the current mirror data table and the second data field corresponding to the current field name are used as the corresponding current data field; and the entire column of field data corresponding to the current data field is replaced based on all the first field data of the first text file.
[0025] Preferably, performing a multidimensional table data synchronization process on all first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all first mirror data tables specifically includes:
[0026] Perform a round of traversal on all the first mapping relationships of the multidimensional table-mirror table data mapping relationship; and in this round of traversal, use the currently traversed first mapping relationship as the corresponding current mapping relationship; and use the first target table name and the first target field name of the first target table item of the current mapping relationship and the first source table name and the first source field name of the first source table item as the corresponding current target table name, current target field name, current source table name and current source field name; and use the first mirror data table corresponding to the mirror table name and the current source table name on the first transfer library as the corresponding current mirror data table, and use the second field name in the current mirror data table and the current source field The second data field corresponding to the name is used as the corresponding current source field, and the entire column of field data under the current source field in the current mirror data table is extracted to form the corresponding second text file; the current target table name and the current target field name are used as the corresponding third name parameter and the fourth name parameter; and the obtained third name parameter, the fourth name parameter and the second text file are sent to the second platform interface; the second platform interface replaces the entire column of field data under the third data field specified by the current fourth name parameter in the first multidimensional table specified by the current third name parameter according to all the second field data of the current second text file.
[0027] Preferably, each time the first dashboard is refreshed, converting the test quality report according to the latest first dashboard to obtain a corresponding first report and sending it to a preset report distribution interface specifically includes:
[0028] Each time the first dashboard is refreshed, an image transfer is performed on the visual interface of each of the first visual dial objects on the first dashboard to obtain a corresponding first dial object view; all the obtained first dial object views are brought into a preset first test quality report template to assemble the test quality report to obtain the corresponding first report; and the first report is sent to the report distribution interface;
[0029] Among them, the first test quality report template is composed of multiple first report sub-items; each first report sub-item is composed of a corresponding first text description area and a first view loading area; a descriptive text is preset in each first text description area; the first view loading area corresponds to the first visual dial object one by one; each first view loading area corresponds to an image loading area size, and each first view loading area is used to load the first dial object view of the corresponding first visual dial object and adaptively adjust the view size of the loaded first dial object view based on the corresponding image loading area size;
[0030] The report distribution interface consists of one or more preset first-member distribution interfaces; each first-member distribution interface corresponds to a test report requester; the interface types of the first-member distribution interface include at least an email interface, a multimedia SMS interface, an office system user interface, an office platform user interface, and an instant messaging software user interface.
[0031] A second aspect of an embodiment of the present invention provides an apparatus for implementing the processing method for generating a test quality report as described in the first aspect, the apparatus comprising: a first preprocessing module, a second preprocessing module, a mirror table synchronization module, a multidimensional table synchronization and dashboard refresh module, and a report generation and distribution module;
[0032] The first preprocessing module is used to record each data source platform for storing original test data reports as a first source platform; and record an office system, platform or cloud that supports multidimensional tables and visual data dashboards as a first target platform; and specify a type of database as the corresponding first transfer library; the first source platform is a type of database, system, platform or cloud;
[0033] The second preprocessing module is used to construct a corresponding mirror data table for each of the original test data reports on the first transfer library, which is recorded as a corresponding first mirror data table; and create one or more corresponding multidimensional table objects and a data dashboard object on the first target platform based on a preset dashboard-multidimensional table data mapping relationship, and record each created multidimensional table object as a corresponding first multidimensional table, and record the created data dashboard object as a corresponding first dashboard; and configure the data mapping relationship between the multidimensional table and the mirror data table to obtain a corresponding multidimensional table-mirror table data mapping relationship;
[0034] The mirror table synchronization module is used to perform a mirror table data synchronization process on all the first mirror data tables based on all the original test data reports at a first designated time point every day; the first designated time point is any time point within 24 hours of a single day;
[0035] The multidimensional table synchronization and dashboard refresh module is configured to perform a multidimensional table data synchronization process on all first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all first mirror data tables at a second designated time point on the first designated single day within each first designated time period; and refresh the first dashboard once based on the dashboard-multidimensional table data mapping relationship and all the latest first multidimensional tables when the multidimensional table data synchronization process is completed; the first designated time period includes at least weekly, monthly, quarterly, and annual; the first designated single day includes at least the first and last days of the designated time period; the second designated time point is any time point within the twenty-four hours of a single day and the second designated time point is later than the first designated time point;
[0036] The report generation and distribution module is used to convert the test quality report according to the latest first dashboard every time the first dashboard is refreshed, obtain the corresponding first report, and send it to the preset report distribution interface.
[0037] A third aspect of an embodiment of the present invention provides an electronic device, including: a memory, a processor, and a transceiver;
[0038] The processor is configured to be coupled to the memory, read and execute instructions in the memory, so as to implement the method steps described in the first aspect above;
[0039] The transceiver is coupled to the processor, and the processor controls the transceiver to send and receive messages.
[0040] A fourth aspect of an embodiment of the present invention provides a computer-readable storage medium, which stores computer instructions. When the computer instructions are executed by a computer, the computer executes the instructions of the method described in the first aspect above.
[0041] The embodiment of the present invention provides a processing method, device, electronic device and computer-readable storage medium for generating a test quality report. As can be seen from the above content, the embodiment of the present invention first records each data source platform used to store original test data reports as a source platform, records an office system, platform or cloud that supports multidimensional tables and visual data dashboards as a target platform, and designates a type of database as a corresponding transfer library; then builds a corresponding mirror data table for each original test data report on the transfer library; and creates one or more corresponding multidimensional tables and a data dashboard on the target platform based on the preset dashboard-multidimensional table data mapping relationship; and performs data mapping between each multidimensional table and all mirror data tables. Configuration; then, at a specified time point every day, all mirror data tables are synchronized with mirror table data based on all original test data reports; and at a specified time point on a specified single day within each specified time period, all multidimensional tables are synchronized with multidimensional table data based on all mirror data tables according to the multidimensional table-mirror table data mapping relationship, and when the multidimensional table data synchronization process is completed, the data dashboard is refreshed once based on the dashboard-multidimensional table data mapping relationship and all the latest multidimensional tables; and each time the data dashboard is refreshed, a test quality report is generated and distributed. The embodiment of the present invention constructs an automatic processing process between a test-specific database (platform or cloud) and an office-specific system (platform or cloud); the embodiment of the present invention saves the human workload of QA engineers and improves the report aesthetics, data accuracy and report generation efficiency of the test quality report. BRIEF DESCRIPTION OF THE DRAWINGS
[0042] Figure 1 A schematic diagram of a processing method for generating a test quality report provided in the first embodiment of the present invention;
[0043] Figure 2 A module structure diagram of a processing device for generating a test quality report provided in the second embodiment of the present invention;
[0044] Figure 3 This is a structural diagram of an electronic device provided in Example 3 of the present invention. DETAILED DESCRIPTION
[0045] To make the objectives, technical solutions, and advantages of the present invention more apparent, the present invention will be further described in detail below with reference to the accompanying drawings. It should be understood that the embodiments described herein are merely some, rather than all, of the present invention. All other embodiments derived by persons of ordinary skill in the art based on the embodiments of the present invention without inventive effort are intended to fall within the scope of protection of the present invention.
[0046] The first embodiment of the present invention provides a method for generating a test quality report, such as Figure 1A method for generating a test quality report according to the first embodiment of the present invention is shown in the following figure. The method mainly includes the following steps:
[0047] Step 1: record each data source platform used to store original test data reports as the first source platform; record an office system, platform or cloud that supports multidimensional tables and visual data dashboards as the first target platform; and designate a type of database as the corresponding first transfer library.
[0048] Here, the first source platform of an embodiment of the present invention is a type of database, system, platform or cloud, such as a test database built based on a relational database or a distributed non-relational database, a Sysbench system, a Jira platform, a GitLabCI / CD platform, a Jenkins platform, a Testin test cloud, Baidu MTC cloud, Tencent WeTest cloud, Alibaba MQC cloud, etc.
[0049] Each original test data report on the first source platform includes multiple first data fields; each original test data report corresponds to an original table name; each first data field corresponds to a field name recorded as a first field name.
[0050] The first source platform provides a data query interface for obtaining a specified field of a specified original table, which is recorded as the corresponding first platform interface. The first platform interface is a URL interface. The interface parameters of the first platform interface include a first name parameter and a second name parameter; wherein the first name parameter corresponds to the original table name; the second name parameter corresponds to the first field name. The first platform interface is used to extract the entire column of field data under the first data field specified by the second name parameter in the original test data report specified by the first name parameter to form a corresponding first text file, and return the first text file as interface feedback data; the specific data format of the first text file is composed of multiple first field data.
[0051] The first target platform of the embodiment of the present invention is a type of system, platform or cloud used for office work, such as OFFICE office system, WPS office system, Feishu office system, DingTalk office system, Tencent Cloud, Huawei Cloud, Alibaba Cloud, etc.
[0052] The first transfer library of the embodiment of the present invention can be implemented based on a type of relational database, a type of distributed non-relational database, or a database cluster consisting of one or more types of relational databases and one or more types of distributed non-relational databases.
[0053] Step 2: Construct a corresponding mirror data table for each original test data report on the first transfer library, which is recorded as the corresponding first mirror data table; and create one or more corresponding multidimensional table objects and a data dashboard object on the first target platform based on the preset dashboard-multidimensional table data mapping relationship, and record each created multidimensional table object as a corresponding first multidimensional table, and record the created data dashboard object as a corresponding first dashboard; and configure the data mapping relationship between the multidimensional table and the mirror data table to obtain a corresponding multidimensional table-mirror table data mapping relationship;
[0054] Specifically comprising: step 21, constructing a corresponding mirror data table for each original test data report on the first transfer library, denoted as the corresponding first mirror data table;
[0055] Here, each first mirror data table constructed on the first transfer library in an embodiment of the present invention includes multiple second data fields; each first mirror data table corresponds to a mirror table name; each second data field corresponds to a field name recorded as a second field name; the first mirror data table has a one-to-one correspondence with the original test data report; the mutually corresponding original test data report and the first and second data fields in the first mirror data table have a one-to-one correspondence; the mutually corresponding original test data report and the first mirror data table have the same original table name and mirror table name; the mutually corresponding first and second data fields have the same first and second field names;
[0056] Step 22: Based on the preset dashboard-multidimensional table data mapping relationship, one or more corresponding multidimensional table objects and a data dashboard object are created on the first target platform, and each created multidimensional table object is recorded as a corresponding first multidimensional table, and the created data dashboard object is recorded as a corresponding first dashboard;
[0057] Here, each first multidimensional table created on the first target platform in the embodiment of the present invention includes multiple third data fields; each first multidimensional table corresponds to a multidimensional table name; each third data field corresponds to a field name recorded as a third field name;
[0058] It should be noted that the first target platform of the embodiment of the present invention provides a data configuration interface for setting a specified field of a specified multidimensional table, which is recorded as a corresponding second platform interface; wherein the second platform interface is a URL interface; the interface parameters of the second platform interface include a third name parameter, a fourth name parameter, and a second text file; the third name parameter corresponds to the multidimensional table name; the fourth name parameter corresponds to the third field name; the specific data format of the second text file consists of multiple second field data; the second platform interface is used to replace the entire column of field data under the third data field specified by the fourth name parameter in the first multidimensional table specified by the third name parameter based on all the second field data in the second text file;
[0059] It should also be noted that the dashboard-multidimensional table data mapping relationship in the embodiment of the present invention is used to configure the first dial object type, first object data mapping relationship, first field condition screening relationship, and first statistical method configuration of each first visual dial object created on the first dashboard according to the dial object type, object data mapping relationship, field condition screening relationship, and statistical method configuration of all visual dial objects required for the test quality report;
[0060] It should also be noted that the first dashboard of the embodiment of the present invention includes multiple first visualization dial objects; the first visualization dial object includes a first dial object type, a first object data mapping relationship, a first field condition screening relationship, and a first statistical method configuration; wherein the first dial object type includes at least a bar chart, a line chart, a pie chart, a bar chart, a scatter chart, a combination chart, a funnel chart, a word cloud, and statistical numbers;
[0061] When the first dial object type is a bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart, or word cloud, the corresponding first object data mapping relationship is the data mapping relationship between each data axis or data item on the current bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart, or word cloud and the third data field specified in the specified first multidimensional table; the corresponding first field condition filtering relationship is the field data filtering condition setting corresponding to each data axis or data item on the corresponding bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart, or word cloud, which consists of the corresponding filtering condition and the condition threshold. The filtering condition includes at least greater than, less than, equal to, not equal to, greater than or equal to, less than or equal to, include, and exclude; the corresponding first statistical method configuration is empty by default;
[0062] When the first dial object type is a statistical number, the corresponding first object data mapping relationship is composed of one or more data source field mapping relationships corresponding to the current statistical number, and each data source field mapping relationship corresponds to a third data field in a first multidimensional table; the corresponding first field condition screening relationship is composed of one or more field data screening condition settings, and the field data screening condition settings correspond one-to-one to the data source field mapping relationship; the corresponding first statistical method configuration includes multiple types of statistical methods, one of which is record total statistics, another is maximum value statistics, another is minimum value statistics, and another is mean statistics;
[0063] Step 23: The data mapping relationship between the multidimensional table and the mirror data table is configured to obtain a corresponding multidimensional table-mirror table data mapping relationship.
[0064] Here, the multidimensional table-mirror table data mapping relationship of an embodiment of the present invention includes multiple first mapping relationships; the first mapping relationship includes a first target table item and a first source table item; the first target table item includes a first target table name and a first target field name; the first source table item includes a first source table name and a first source field name; the first target table name corresponds to a multidimensional table name; the first target field name corresponds to a third field name; the first source table name corresponds to a mirror table name; and the first source field name corresponds to a second field name.
[0065] Step 3: At the first designated time point of each day, perform mirror table data synchronization on all first mirror data tables based on all original test data reports;
[0066] The first designated time point is any time point within 24 hours of a single day, such as midnight;
[0067] Specifically, it includes: performing a round of traversal on all original table names; and during this round of traversal, using the currently traversed original table name as the corresponding current original table name; and using the first mirror data table corresponding to the mirror table name on the first transfer library and the current original table name as the corresponding current mirror data table; and performing a round of polling on all first field names corresponding to the current original table name; and during this round of polling, using the currently polled first field name as the corresponding current field name; and sending the current original table name and the current field name as the corresponding first name parameter and second name parameter to the first platform interface; and receiving the first text file returned by the first platform interface; and using the second field name in the current mirror data table and the second data field corresponding to the current field name as the corresponding current data field; and replacing the entire column of field data corresponding to the current data field based on all the first field data of the first text file.
[0068] Step 4: At a second designated time point on the first designated single day within each first designated time period, multidimensional table data synchronization is performed on all first multidimensional tables based on the multidimensional table-mirror table data mapping relationship and all first mirror data tables. Upon completion of the multidimensional table data synchronization, the first dashboard is refreshed based on the dashboard-multidimensional table data mapping relationship and the latest data of all first multidimensional tables.
[0069] The first designated time period includes at least weekly, monthly, quarterly, and annual periods; the first designated day includes at least the first and last days of the designated time period; the second designated time point is any time point within the twenty-four hours of a single day and is later than the first designated time point. For example, the first and second designated time points are set to midnight and 3 a.m., respectively.
[0070] Specifically, step 41 includes performing a multidimensional table data synchronization process on all first multidimensional tables according to all first mirror data tables based on a multidimensional table-mirror table data mapping relationship at a second designated time point on a first designated single day within each first designated time period;
[0071] Specifically, the method includes: performing a round of traversal on all first mapping relationships of the multidimensional table-mirror table data mapping relationship; and during this round of traversal, taking the currently traversed first mapping relationship as the corresponding current mapping relationship; taking the first target table name and the first target field name of the first target table item of the current mapping relationship and the first source table name and the first source field name of the first source table item as the corresponding current target table name, current target field name, current source table name, and current source field name; taking the first mirror data table corresponding to the mirror table name and the current source table name on the first transfer library as the corresponding current mirror data table, taking the second field name in the current mirror data table corresponding to the second field name and the current source field name as the corresponding current source field, and extracting the entire column of field data under the current source field in the current mirror data table to form a corresponding second text file; taking the current target table name and the current target field name as the corresponding third name parameter and fourth name parameter; and sending the obtained third name parameter, fourth name parameter, and second text file to the second platform interface; and replacing the entire column of field data under the third data field specified by the current fourth name parameter in the first multidimensional table specified by the current third name parameter according to all the second field data in the current second text file by the second platform interface.
[0072] In step 42 , when the multidimensional table data synchronization process is completed, the first dashboard is refreshed based on the dashboard-multidimensional table data mapping relationship and all the latest first multidimensional tables.
[0073] Step 5: Each time the first dashboard is refreshed, a test quality report is converted according to the latest first dashboard to obtain a corresponding first report and send it to a preset report distribution interface;
[0074] Specifically, it includes: each time the first dashboard completes a refresh, the visual interface of each first visual dial object on the first dashboard is converted into an image to obtain a corresponding first dial object view; and all the obtained first dial object views are brought into the preset first test quality report template to assemble the test quality report to obtain the corresponding first report; and the first report is sent to the report distribution interface.
[0075] Here, the first test quality report template of the embodiment of the present invention is composed of multiple first report sub-items; each first report sub-item is composed of a corresponding first text description area and a first view loading area; a descriptive text is preset in each first text description area; the first view loading area corresponds one-to-one to the first visual dial object; each first view loading area corresponds to an image loading area size, and each first view loading area is used to load the first dial object view of the corresponding first visual dial object and adaptively adjust the view size of the loaded first dial object view based on the corresponding image loading area size. The report distribution interface of the embodiment of the present invention is composed of one or more preset first member distribution interfaces; each first member distribution interface corresponds to a test report requester; the interface types of the first member distribution interface include at least an email interface, a multimedia SMS interface, an office system user interface, an office platform user interface, and an instant messaging software user interface.
[0076] Figure 2 This is a module structure diagram of a processing device for generating a test quality report provided in the second embodiment of the present invention. The device is a terminal device or server that implements the aforementioned method embodiment, and can also be a device that enables the aforementioned terminal device or server to implement the aforementioned method embodiment. For example, the device can be a device or chip system of the aforementioned terminal device or server. Figure 2 As shown, the apparatus includes: a first preprocessing module 201 , a second preprocessing module 202 , a mirror table synchronization module 203 , a multi-dimensional table synchronization and dashboard refresh module 204 , and a report generation and distribution module 205 .
[0077] The first preprocessing module 201 is used to record each data source platform used to store original test data reports as a first source platform; and record an office system, platform or cloud that supports multidimensional tables and visual data dashboards as a first target platform; and specify a type of database as the corresponding first transfer library; the first source platform is a type of database, system, platform or cloud.
[0078] The second preprocessing module 202 is used to construct a corresponding mirror data table for each original test data report on the first transfer library, which is recorded as the corresponding first mirror data table; and based on the preset dashboard-multidimensional table data mapping relationship, create one or more corresponding multidimensional table objects and a data dashboard object on the first target platform, and record each created multidimensional table object as the corresponding first multidimensional table, and record the created data dashboard object as the corresponding first dashboard; and configure the data mapping relationship between the multidimensional table and the mirror data table to obtain the corresponding multidimensional table-mirror table data mapping relationship.
[0079] The mirror table synchronization module 203 is used to perform a mirror table data synchronization process on all first mirror data tables based on all original test data reports at the first designated time point every day; the first designated time point is any time point within 24 hours of a single day.
[0080] The multidimensional table synchronization and dashboard refresh module 204 is used to perform a multidimensional table data synchronization process on all first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all first mirror data tables at the second designated time point of the first designated single day within each first designated time period; and when the multidimensional table data synchronization process is completed, refresh the first dashboard once based on the dashboard-multidimensional table data mapping relationship and all the latest first multidimensional tables; the first designated time period includes at least weekly, monthly, quarterly and annual; the first designated single day includes at least the first and last days of the designated time period; the second designated time point is any time point within the twenty-four hours of a single day and the second designated time point is later than the first designated time point.
[0081] The report generation and distribution module 205 is used to convert the test quality report according to the latest first dashboard every time the first dashboard is refreshed, obtain the corresponding first report, and send it to the preset report distribution interface.
[0082] An embodiment of the present invention provides a processing device for generating a test quality report, which can execute the method steps in the above method embodiment. Its implementation principle and technical effects are similar and will not be repeated here.
[0083] It should be noted that it should be understood that the division of the various modules of the above device is merely a division of logical functions. In actual implementation, they can be fully or partially integrated into one physical entity, or they can be physically separated. Moreover, these modules can all be implemented in the form of software called by a processing element; or they can all be implemented in the form of hardware; or some modules can be implemented in the form of software called by a processing element, and some modules can be implemented in the form of hardware. For example, the report generation and distribution module can be a separately established processing element, or it can be integrated into a chip of the above device. In addition, it can also be stored in the memory of the above device in the form of program code, and called by a processing element of the above device to perform the functions of the above-mentioned module. The implementation of other modules is similar. In addition, these modules can all or partly be integrated together, or they can be implemented independently. The processing element described here can be an integrated circuit with signal processing capabilities. In the implementation process, each step of the above method or each of the above modules can be completed by the hardware integrated logic circuit in the processor element or by instructions in the form of software.
[0084] For example, the above modules may be one or more integrated circuits configured to implement the above methods, such as one or more application-specific integrated circuits (ASICs), one or more digital signal processors (DSPs), or one or more field programmable gate arrays (FPGAs). For another example, when a module is implemented by scheduling program code through a processing element, the processing element may be a general-purpose processor, such as a central processing unit (CPU) or other processor that can call program code. For another example, these modules may be integrated together and implemented in the form of a system-on-a-chip (SOC).
[0085] In the above embodiments, all or part of the embodiments may be implemented using software, hardware, firmware, or any combination thereof. When implemented using software, all or part of the embodiments may be implemented in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the processes or functions described in the above method embodiments are generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The above-mentioned computer instructions can be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the above-mentioned computer instructions can be transmitted from one website, computer, server or data center to another website, computer, server or data center via wired (such as coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (such as infrared, wireless, Bluetooth, microwave, etc.) means. The above-mentioned computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device such as a server or data center that includes one or more available media. The above-mentioned available medium can be a magnetic medium (such as a floppy disk, hard disk, tape), an optical medium (such as a DVD), or a semiconductor medium (such as a solid state disk (SSD)), etc.
[0086] Figure 3 This is a schematic diagram of the structure of an electronic device provided in the third embodiment of the present invention. The electronic device can be a terminal device or server that implements the method of the aforementioned embodiment, or it can be a terminal device or server that implements the method of the aforementioned embodiment connected to the aforementioned terminal device or server. Figure 3As shown, the electronic device may include: a processor 301 (such as a CPU), a memory 302, and a transceiver 303; the transceiver 303 is coupled to the processor 301, and the processor 301 controls the transceiver 303's transceiver actions. Various instructions may be stored in the memory 302 for completing various processing functions and implementing the processing steps described in the aforementioned embodiment method. Preferably, the electronic device involved in the embodiment of the present invention further includes: a power supply 304, a system bus 305, and a communication port 306. The system bus 305 is used to realize communication connections between components. The above-mentioned communication port 306 is used for connecting and communicating between the electronic device and other peripherals.
[0087] exist Figure 3 The system bus 305 mentioned in the figure can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The system bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus. The communication interface is used to realize communication between the database access device and other devices (such as clients, read-write libraries, and read-only libraries). The memory may include random access memory (RAM) and may also include non-volatile memory (Non-Volatile Memory), such as at least one disk storage.
[0088] The above-mentioned processors can be general-purpose processors, including central processing units (CPUs), network processors (NPs), graphics processing units (GPUs), etc.; they can also be digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components.
[0089] It should be noted that an embodiment of the present invention further provides a computer-readable storage medium, which stores instructions. When the computer-readable storage medium is run on a computer, it enables the computer to execute the methods and processing procedures provided in the above embodiments.
[0090] The embodiment of the present invention provides a processing method, device, electronic device and computer-readable storage medium for generating a test quality report. As can be seen from the above content, the embodiment of the present invention first records each data source platform used to store original test data reports as a source platform, records an office system, platform or cloud that supports multidimensional tables and visual data dashboards as a target platform, and designates a type of database as a corresponding transfer library; then builds a corresponding mirror data table for each original test data report on the transfer library; and creates one or more corresponding multidimensional tables and a data dashboard on the target platform based on the preset dashboard-multidimensional table data mapping relationship; and performs data mapping between each multidimensional table and all mirror data tables. Configuration; then, at a specified time point every day, all mirror data tables are synchronized with mirror table data based on all original test data reports; and at a specified time point on a specified single day within each specified time period, all multidimensional tables are synchronized with multidimensional table data based on all mirror data tables according to the multidimensional table-mirror table data mapping relationship, and when the multidimensional table data synchronization process is completed, the data dashboard is refreshed once based on the dashboard-multidimensional table data mapping relationship and all the latest multidimensional tables; and each time the data dashboard is refreshed, a test quality report is generated and distributed. The embodiment of the present invention constructs an automatic processing process between a test-specific database (platform or cloud) and an office-specific system (platform or cloud); the embodiment of the present invention saves the human workload of QA engineers and improves the report aesthetics, data accuracy and report generation efficiency of the test quality report.
[0091] The steps of the methods or algorithms described in conjunction with the embodiments disclosed herein may be implemented using hardware, a software module executed by a processor, or a combination of the two. The software module may be placed in a random access memory (RAM), a memory, a read-only memory (ROM), an electrically programmable ROM, an electrically erasable programmable ROM, a register, a hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
[0092] The specific implementation methods described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific implementation method of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.
Claims
1. A method for generating a test quality report, characterized in that: The method comprises: Each data source platform used to store original test data reports is recorded as the first source platform; an office system, platform, or cloud that supports multidimensional tables and visual data dashboards is recorded as the first target platform; and a type of database is designated as the corresponding first transfer library; the first source platform is a type of database, system, platform, or cloud; Constructing a corresponding mirror data table on the first transfer library for each of the original test data reports, denoted as a corresponding first mirror data table; creating one or more corresponding multidimensional table objects and a data dashboard object on the first target platform based on a preset dashboard-multidimensional table data mapping relationship, and denoting each created multidimensional table object as a corresponding first multidimensional table, and denoting the created data dashboard object as a corresponding first dashboard; and configuring a data mapping relationship between the multidimensional table and the mirror data table to obtain a corresponding multidimensional table-mirror table data mapping relationship; At a first designated time point each day, performing a mirror table data synchronization process on all the first mirror data tables based on all the original test data reports; the first designated time point is any time point within 24 hours of a single day; At a second designated time point on a first designated single day within each first designated time period, multidimensional table data synchronization processing is performed on all first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all first mirror data tables; and when the multidimensional table data synchronization processing is completed, the first dashboard is refreshed once based on the dashboard-multidimensional table data mapping relationship and all the latest first multidimensional tables; the first designated time period includes at least weekly, monthly, quarterly, and annually; the first designated single day includes at least the first and last days of the designated time period; the second designated time point is any time point within a twenty-four-hour period of a single day and the second designated time point is later than the first designated time point; Each time the first dashboard is refreshed, a test quality report conversion is performed based on the latest first dashboard to obtain a corresponding first report and send it to a preset report distribution interface.
2. The method for generating a test quality report according to claim 1, wherein: Each of the original test data reports on the first source platform includes a plurality of first data fields; each of the original test data reports corresponds to an original table name; each of the first data fields corresponds to a field name recorded as a first field name; The first source platform provides a data query interface for obtaining a specified field of a specified original table, which is recorded as the corresponding first platform interface; The first platform interface is a URL interface, and the interface parameters of the first platform interface include a first name parameter and a second name parameter; the first name parameter corresponds to the original table name; the second name parameter corresponds to the first field name; the first platform interface is used to extract the entire column of field data under the first data field specified by the second name parameter in the original test data report specified by the first name parameter to form a corresponding first text file, and return the first text file as interface feedback data; the specific data format of the first text file is composed of multiple first field data; Each of the first mirror data tables on the first transfer library includes a plurality of second data fields; each of the first mirror data tables corresponds to a mirror table name; each of the second data fields corresponds to a field name recorded as a second field name; The first mirror data table corresponds to the original test data report in one-to-one correspondence; the mutually corresponding original test data report and the first and second data fields in the first mirror data table correspond in one-to-one correspondence; the original table names and the mirror table names of the mutually corresponding original test data report and the first mirror data table are consistent; The first and second field names of the first and second data fields corresponding to each other are consistent; Each of the first multidimensional tables on the first target platform includes a plurality of third data fields; each of the first multidimensional tables corresponds to a multidimensional table name; each of the third data fields corresponds to a field name recorded as a third field name; The first target platform provides a data configuration interface for setting a specified field of a specified multidimensional table, which is recorded as the corresponding second platform interface; The second platform interface is a URL interface, and the interface parameters of the second platform interface include a third name parameter, a fourth name parameter and a second text file; the third name parameter corresponds to the name of the multidimensional table; the fourth name parameter corresponds to the third field name; the specific data format of the second text file consists of multiple second field data; the second platform interface is used to replace the entire column of field data under the third data field specified by the fourth name parameter in the first multidimensional table specified by the third name parameter according to all the second field data of the second text file.
3. The method for generating a test quality report according to claim 2, wherein: The dashboard-multidimensional table data mapping relationship is used to configure the first dashboard object type, first object data mapping relationship, first field condition screening relationship and first statistical method configuration of each first visual dashboard object created on the first dashboard according to the dashboard object type, object data mapping relationship, field condition screening relationship and statistical method configuration of all visual dashboard objects required for the test quality report; The first dashboard includes a plurality of the first visual dial objects; The first visual dial object includes the first dial object type, the first object data mapping relationship, the first field condition screening relationship and the first statistical method configuration; The first dial object type includes at least a bar chart, a line chart, a pie chart, a bar chart, a scatter chart, a combination chart, a funnel chart, a word cloud, and statistical figures; When the first dial object type is a bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart or word cloud, the corresponding first object data mapping relationship is the data mapping relationship between each data axis or data item on the current bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart or word cloud and the third data field specified in the specified first multidimensional table; the corresponding first field condition filtering relationship is the field data filtering condition setting corresponding to each data axis or data item on the corresponding bar chart, line chart, pie chart, bar chart, scatter chart, combination chart, funnel chart or word cloud, which is composed of the corresponding filtering condition and the condition threshold, and the filtering condition at least includes greater than, less than, equal to, not equal to, greater than or equal to, less than or equal to, include and exclude; the corresponding first statistical method configuration is empty by default; When the first dial object type is a statistical number, the corresponding first object data mapping relationship is composed of one or more data source field mapping relationships corresponding to the current statistical number, and each of the data source field mapping relationships corresponds to one of the third data fields in the first multidimensional table; the corresponding first field condition screening relationship is composed of one or more field data screening condition settings, and the field data screening condition settings correspond one-to-one to the data source field mapping relationship; the corresponding first statistical method configuration includes multiple types of statistical methods, one of which is record total statistics, another type of statistical method is maximum value statistics, another type of statistical method is minimum value statistics, and another type of statistical method is mean statistics.
4. The method for generating a test quality report according to claim 2, wherein: The multidimensional table-mirror table data mapping relationship includes a plurality of first mapping relationships; the first mapping relationship includes a first target table item and a first source table item; the first target table item includes a first target table name and a first target field name; the first source table item includes a first source table name and a first source field name; the first target table name corresponds to a multidimensional table name; The first target field name corresponds to one of the third field names; the first source table name corresponds to one of the mirror table names; and the first source field name corresponds to one of the second field names.
5. The method for generating a test quality report according to claim 2, wherein: The performing mirror table data synchronization processing on all the first mirror data tables based on all the original test data reports specifically includes: A round of traversal is performed on all the original table names; and during this round of traversal, the original table name currently traversed is used as the corresponding current original table name; and the first mirror data table corresponding to the mirror table name and the current original table name on the first transfer library is used as the corresponding current mirror data table; and a round of polling is performed on all the first field names corresponding to the current original table name; and during this round of polling, the first field name currently polled is used as the corresponding current field name; and the current original table name and the current field name are sent to the first platform interface as the corresponding first name parameter and the second name parameter; and the first text file returned by the first platform interface is received; and the second field name in the current mirror data table and the second data field corresponding to the current field name are used as the corresponding current data field; and the entire column of field data corresponding to the current data field is replaced based on all the first field data of the first text file.
6. The method for generating a test quality report according to claim 4, wherein: The performing a multidimensional table data synchronization process on all the first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all the first mirror data tables specifically includes: Perform a round of traversal on all the first mapping relationships of the multidimensional table-mirror table data mapping relationship; and in this round of traversal, use the currently traversed first mapping relationship as the corresponding current mapping relationship; and use the first target table name and the first target field name of the first target table item of the current mapping relationship and the first source table name and the first source field name of the first source table item as the corresponding current target table name, current target field name, current source table name and current source field name; and use the first mirror data table corresponding to the mirror table name and the current source table name on the first transfer library as the corresponding current mirror data table, and use the second field name in the current mirror data table and the current source field The second data field corresponding to the name is used as the corresponding current source field, and the entire column of field data under the current source field in the current mirror data table is extracted to form the corresponding second text file; the current target table name and the current target field name are used as the corresponding third name parameter and the fourth name parameter; and the obtained third name parameter, the fourth name parameter and the second text file are sent to the second platform interface; the second platform interface replaces the entire column of field data under the third data field specified by the current fourth name parameter in the first multidimensional table specified by the current third name parameter according to all the second field data of the current second text file.
7. The method for generating a test quality report according to claim 3, wherein: The step of converting the test quality report according to the latest first dashboard into a corresponding first report each time the first dashboard is refreshed includes: Each time the first dashboard is refreshed, an image transfer is performed on the visual interface of each of the first visual dial objects on the first dashboard to obtain a corresponding first dial object view; all the obtained first dial object views are brought into a preset first test quality report template to assemble the test quality report to obtain the corresponding first report; and the first report is sent to the report distribution interface; Among them, the first test quality report template is composed of multiple first report sub-items; each first report sub-item is composed of a corresponding first text description area and a first view loading area; a descriptive text is preset in each first text description area; the first view loading area corresponds to the first visual dial object one by one; each first view loading area corresponds to an image loading area size, and each first view loading area is used to load the first dial object view of the corresponding first visual dial object and adaptively adjust the view size of the loaded first dial object view based on the corresponding image loading area size; The report distribution interface consists of one or more preset first-member distribution interfaces; each first-member distribution interface corresponds to a test report requester; the interface types of the first-member distribution interface include at least an email interface, a multimedia SMS interface, an office system user interface, an office platform user interface, and an instant messaging software user interface.
8. A device for executing the method for generating a test quality report according to any one of claims 1 to 7, characterized in that: The device comprises: a first pre-processing module, a second pre-processing module, a mirror table synchronization module, a multi-dimensional table synchronization and dashboard refresh module and a report generation and distribution module; The first preprocessing module is used to record each data source platform for storing original test data reports as a first source platform; and record an office system, platform or cloud that supports multidimensional tables and visual data dashboards as a first target platform; and specify a type of database as the corresponding first transfer library; the first source platform is a type of database, system, platform or cloud; The second preprocessing module is used to construct a corresponding mirror data table for each of the original test data reports on the first transfer library, which is recorded as a corresponding first mirror data table; and create one or more corresponding multidimensional table objects and a data dashboard object on the first target platform based on a preset dashboard-multidimensional table data mapping relationship, and record each created multidimensional table object as a corresponding first multidimensional table, and record the created data dashboard object as a corresponding first dashboard; and configure the data mapping relationship between the multidimensional table and the mirror data table to obtain a corresponding multidimensional table-mirror table data mapping relationship; The mirror table synchronization module is used to perform a mirror table data synchronization process on all the first mirror data tables based on all the original test data reports at a first designated time point every day; the first designated time point is any time point within 24 hours of a single day; The multidimensional table synchronization and dashboard refresh module is configured to perform a multidimensional table data synchronization process on all first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all first mirror data tables at a second designated time point on the first designated single day within each first designated time period; and upon completion of the multidimensional table data synchronization process, refresh the first dashboard based on the dashboard-multidimensional table data mapping relationship and all the latest first multidimensional tables; the first designated time period includes at least weekly, monthly, quarterly, and annual; the first designated single day includes at least the first and last days of the designated time period; the second designated time point is any time point within the twenty-four hours of a single day and is later than the first designated time point; The report generation and distribution module is used to convert the test quality report according to the latest first dashboard every time the first dashboard is refreshed, obtain the corresponding first report, and send it to the preset report distribution interface.
9. An electronic device, characterized in that: include: memory, processors, and transceivers; The processor is configured to be coupled to the memory, read and execute instructions in the memory, so as to implement the method according to any one of claims 1 to 7; The transceiver is coupled to the processor, and the processor controls the transceiver to send and receive messages.
10. A computer-readable storage medium, characterized in that The computer-readable storage medium stores computer instructions, and when the computer instructions are executed by a computer, the computer is caused to execute the method according to any one of claims 1 to 7.
Citation Information
Patent Citations
Order-based data mirror image backup method, test method and system
CN111767286A
Data mapping file test method and device, equipment and storage medium
CN114185791A