Processing method and device for generating test quality report

Abstract

The embodiment of the invention relates to a processing method and device for generating a test quality report. The method comprises the following steps: recording data source platforms for storing original test data reports as source platforms; recording an office system, a platform or a cloud supporting a multi-dimensional table and a visual data instrument panel as a target platform; assigning a transfer library; constructing a mirror data table for each original test data report on a transfer library; creating one or more multi-dimensional tables and an instrument panel on the target platform based on the instrument panel-multi-dimensional table data mapping relation; configuring a data mapping relation between the multi-dimensional table and the mirror image data table; synchronizing all the mirror image data tables at the appointed time every day; synchronizing all the multi-dimensional tables at specified time of a specified single day in each specified time period, and refreshing the instrument panel when the current synchronization is completed; and generating and distributing a test quality report once when the instrument panel is refreshed once. According to the invention, the report generation efficiency can be improved.

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 have situations in which they are connected to multiple types of databases, systems, platforms or clouds in their daily work, such as using a special database, platform or cloud to store original test data reports and using another special system, platform or cloud to process daily office processes. In this case, when the quality assurance (QA) engineer of the test department generates a test quality report regularly (weekly, monthly, quarterly or annually, etc.), he needs to first export a series of table items from the special database, platform or cloud that stores the original test data reports based on manual operation, and perform manual data analysis and statistics on all exported table items locally, and write a test quality report based on the data analysis and statistical results obtained at that time based on the manual writing method, and finally send the test quality report written at that time to all report demanders through file upload and distribution on the special system, platform or cloud that processes daily office processes. Affected by 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 visualization 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 visualization object in the dashboard is bound to the fields of the multidimensional table, and when the data in a multidimensional table is updated, the visualization objects bound 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 automatic processing transfer hub can be built between the test-specific database (platform or cloud) and the office-specific system (platform or cloud), and the transfer hub is responsible for exporting data from the test-specific database (platform or cloud) and regularly generating and distributing test quality reports based on the exported data and the multidimensional tables and visual data dashboard functions provided by the office-specific system (platform or cloud), it will not only save a lot of manpower workload, but also improve the report aesthetics, data accuracy and report generation efficiency of the test quality report. This is exactly the technical problem that the present invention aims to solve. Summary of the invention

[0005] The purpose of the present invention is to provide a processing method, device, electronic device and computer-readable storage medium for generating a test quality report in view of the defects of the prior art. The present invention firstly records each data source platform for storing original test data reports as a source platform, records an office system, platform or cloud supporting multidimensional tables and a visualized 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 for each original test data report on the transfer library; and one or more corresponding multidimensional tables and a data dashboard are created on the target platform based on a preset dashboard-multidimensional table data mapping relationship; and the data mapping relationship between each multidimensional table and all mirror data tables is configured; then, mirror table data synchronization is performed on all mirror data tables based on all original test data reports at a specified time point every day; and at a specified time point of a specified single day within each specified time period, multidimensional table data synchronization is performed on all multidimensional tables according to the multidimensional table-mirror table data mapping relationship according to all mirror data tables, and when the multidimensional table data synchronization processing is completed, the data dashboard is refreshed once based on the dashboard-multidimensional table data mapping relationship and all the latest multidimensional tables; and when the data dashboard is refreshed once, a test quality report is generated and distributed. 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 can improve the report aesthetics, data accuracy and report generation efficiency of the test quality report.

[0006] To achieve the above 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 for storing original test data reports is recorded as a first source platform; an office system, platform or cloud supporting multi-dimensional tables and visual data dashboards is recorded as a 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 for each of the original test data reports on the first transfer library, 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 of the created multidimensional table objects 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 every day, a mirror table data synchronization process is performed 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 twenty-four hours of a single day;

[0010] At the second designated time point of the first designated single day within each first designated time period, a multidimensional table data synchronization process is performed on all the first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all the first mirror data tables; and when the multidimensional table data synchronization process 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 day and the last day of the designated time period; the second designated time point is any time point within 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 according to the latest first dashboard to obtain a corresponding first report which is sent 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 consists 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 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 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;

[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 dial object type, the first object data mapping relationship, the first field condition screening relationship and the first statistical method configuration of each first visualization dial object created on the first dashboard according to the dial object type, the object data mapping relationship, the field condition screening relationship and the statistical method configuration of all visualization dial objects required for the test quality report;

[0018] 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;

[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 screening relationship is the field data screening 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 screening condition and the condition threshold, and the screening condition at least includes greater than, less than, equal to, not equal to, greater than or equal to, less than or equal to, including and excluding; 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 the total number of records statistics, another type of statistical method is the maximum value statistics, another type of statistical method is the minimum value statistics, and another type of statistical method is the 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 a mirror table data synchronization process 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 on the first transfer library and the current original table name 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 data field corresponding to the second field name in the current mirror data table and the current field name is 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 the first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all the first mirror data tables specifically includes:

[0026] A round of traversal is performed on all the first mapping relationships of the multidimensional table-mirror table data mapping relationship; and in this round of traversal, the first mapping relationship currently traversed is used as the corresponding current mapping relationship; and 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 are used as the corresponding current target table name, current target field name, current source table name and current source field name; and the first mirror data table corresponding to the mirror table name and the current source table name on the first transfer library is used as the corresponding current mirror data table, and the second field name in the current mirror data table is used as the current source field name. 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; and 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; and 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, a test quality report conversion is performed according to the latest first dashboard to obtain a corresponding first report and send it to a preset report distribution interface, specifically including:

[0028] Each time the first dashboard is refreshed, an image transfer is performed on the visualization interface of each of the first visualization dial objects on the first dashboard to obtain a corresponding first dial object view; and 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 of the first report sub-items is composed of a corresponding first text description area and a first view loading area; a descriptive text is preset in each of the first text description areas; the first view loading areas correspond to the first visual dial objects one by one; each of the first view loading areas corresponds to an image loading area size, and each of the first view loading areas 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 is composed of one or more preset first member distribution interfaces; each of the first member distribution interfaces corresponds to a test report demander; the interface types of the first member distribution interfaces 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 a device for implementing the processing method for generating a test quality report described in the first aspect, the device 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 based on a 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 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 used to perform 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 at the second designated time point of 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 annually; the first designated single day includes at least the first day and the last day 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 a test quality report according to the latest first dashboard every time the first dashboard is refreshed, obtain a corresponding first report and send it to a 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 used 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, wherein the computer-readable storage medium 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 embodiments of the present invention provide 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 embodiments of the present invention first record each data source platform used to store original test data reports as a source platform, record an office system, platform or cloud that supports multidimensional tables and visual data dashboards as a target platform, and designate a type of database as a corresponding transfer library; then build a corresponding mirror data table for each original test data report on the transfer library; and create 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 perform 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 of a specified single day within each specified time period, all multidimensional tables are synchronized with multidimensional table data according to all mirror data tables according to the multidimensional table-mirror table data mapping relationship, and when the multidimensional table data synchronization processing is completed, the data dashboard is refreshed once based on the dashboard-multidimensional table data mapping relationship and all the latest multidimensional tables; and the generation and distribution of a test quality report is performed once the data dashboard is refreshed. 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 Embodiment 1 of the present invention;

[0043] Figure 2 A module structure diagram of a processing device for generating a test quality report provided in Embodiment 2 of the present invention;

[0044] Figure 3 A schematic diagram of the structure of an electronic device provided in Embodiment 3 of the present invention. DETAILED DESCRIPTION

[0045] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0046] Embodiment 1 of the present invention provides a method for generating a test quality report. Figure 1As shown in the schematic diagram of a processing method for generating a test quality report provided in the first embodiment of the present invention, 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 specify 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 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 a plurality of 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; and 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 consists 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 switching 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 composed 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 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;

[0054] Specifically comprising: step 21, constructing a corresponding mirror data table for each original test data report on the first transfer library, recorded as the corresponding first mirror data table;

[0055] Here, each first mirror data table constructed on the first transfer library in the 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 corresponds to the original test data report one-to-one; the mutually corresponding original test data report and the first and second data fields in the first mirror data table correspond one-to-one; 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 field names of the first and second data fields are consistent;

[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 a plurality of 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 the 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 a plurality of 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;

[0059] It should also be noted that the dashboard-multidimensional table data mapping relationship of the embodiment of the present invention is used to configure the first dial object type, the first object data mapping relationship, the first field condition screening relationship and the first statistical method configuration of each first visualization dial object created on the first dashboard according to the dial object type, the object data mapping relationship, the field condition screening relationship and the statistical method configuration of all visualization 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 figures;

[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 screening relationship is the field data screening 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 screening condition and the condition threshold, and the screening condition at least includes greater than, less than, equal to, not equal to, greater than or equal to, less than or equal to, including and excluding; 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 to the data source field mapping relationship one by one; the corresponding first statistical method configuration includes multiple types of statistical methods, one type of statistical method is record total number 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 value 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 the 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; the first source field name corresponds to a second field name.

[0065] Step 3: at the first designated time point of each day, perform a mirror table data synchronization process 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, the method includes: performing a round of traversal of all original table names; and during this round of traversal, taking the original table name currently traversed as the corresponding current original table name; and taking 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 of all first field names corresponding to the current original table name; and during this round of polling, taking the first field name currently polled 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 taking the second data field corresponding to the second field name in the current mirror data table and 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 the second designated time point of the first designated single day within each first designated time period, 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; and when the multidimensional table data synchronization process is completed, refresh the first dashboard based on the dashboard-multidimensional table data mapping relationship and all the latest first multidimensional tables;

[0069] The first designated time period includes at least one of weekly, monthly, quarterly and annual periods; the first designated day includes at least one of 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 the day and the second designated time point 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, it includes: step 41, at the second designated time point of the first designated single day within each first designated time period, 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;

[0071] Specifically, it includes: performing a round of traversal of all first mapping relationships of the multidimensional table-mirror table data mapping relationship; and in 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 and the second data field corresponding to the current source field name in the current mirror data table 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 of the current second text file by the second platform interface;

[0072] 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: when the first dashboard is refreshed once, a test quality report conversion is performed 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 transferred once to obtain a corresponding first dial object view; and 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.

[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 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 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 demander; 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 The 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 a 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 device 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 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.

[0078] The second preprocessing module 202 is used to build 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 of each 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 annually; the first designated single day includes at least the first day and the last day of the designated time period; the second designated time point is any time point within the twenty-four hours of the 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 a test quality report according to the latest first dashboard every time the first dashboard is refreshed, and obtain a corresponding first report and send it to a preset report distribution interface.

[0082] A processing device for generating a test quality report provided in an embodiment of the present invention 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 only 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. And these modules can all be implemented in the form of software called by processing elements; they can also be all implemented in the form of hardware; some modules can also be implemented in the form of software called by processing elements, 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 in 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 and executed by a processing element of the above device. The function of the above-mentioned module is determined. The implementation of other modules is similar. In addition, these modules can be fully or partially 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 module above can be completed by an integrated logic circuit of hardware in the processor element or 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 (ASIC), or one or more digital signal processors (DSP), or one or more field programmable gate arrays (FPGA). For another example, when a module above is implemented in the form of a processing element scheduling program code, 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 by software, hardware, firmware or any combination thereof. When implemented by 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, all or part of the processes or functions described in the above method embodiments are generated. The above computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. 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 through wired (such as coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (such as infrared, wireless, Bluetooth, microwave, etc.) methods. 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 integrated. The above-mentioned available medium can be a magnetic medium (such as a floppy disk, a hard disk, a 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 Embodiment 3 of the present invention. The electronic device may be a terminal device or a server for implementing the method of the aforementioned embodiment, or may be a terminal device or a server for implementing 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. Various instructions may be stored in the memory 302 to complete various processing functions and implement the processing steps described in the aforementioned embodiment method. Preferably, the electronic device involved in the embodiment of the present invention also includes: a power supply 304, a system bus 305 and a communication port 306. The system bus 305 is used to realize the communication connection 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 the 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 processor can be a general-purpose processor, including a central processing unit CPU, a network processor (Network Processor, NP), a graphics processing unit (Graphics Processing Unit, GPU), etc.; it can also be a digital signal processor DSP, an application-specific integrated circuit ASIC, a field programmable gate array FPGA or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.

[0089] It should be noted that an embodiment of the present invention further provides a computer-readable storage medium, in which instructions are stored. When the computer-readable storage medium is run on a computer, the computer executes the method and processing process provided in the above embodiments.

[0090] The embodiments of the present invention provide 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 embodiments of the present invention first record each data source platform used to store original test data reports as a source platform, record an office system, platform or cloud that supports multidimensional tables and visual data dashboards as a target platform, and designate a type of database as a corresponding transfer library; then build a corresponding mirror data table for each original test data report on the transfer library; and create 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 perform 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 of a specified single day within each specified time period, all multidimensional tables are synchronized with multidimensional table data according to all mirror data tables according to the multidimensional table-mirror table data mapping relationship, and when the multidimensional table data synchronization processing is completed, the data dashboard is refreshed once based on the dashboard-multidimensional table data mapping relationship and all the latest multidimensional tables; and the generation and distribution of a test quality report is performed once the data dashboard is refreshed. 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 method or algorithm 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 processing method for generating a test quality report, characterized in that: The method comprises: Each data source platform for storing original test data reports is recorded as a first source platform; an office system, platform or cloud supporting multi-dimensional tables and visual data dashboards is recorded as a 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 for each of the original test data reports on the first transfer library, 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 of the created multidimensional table objects 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; At a first designated time point every day, a mirror table data synchronization process is performed 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 twenty-four hours of a single day; At the second designated time point of the first designated single day within each first designated time period, a multidimensional table data synchronization process is performed on all the first multidimensional tables according to the multidimensional table-mirror table data mapping relationship and all the first mirror data tables; and when the multidimensional table data synchronization process 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 day and the last day of the designated time period; the second designated time point is any time point within twenty-four hours 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 according to the latest first dashboard to obtain a corresponding first report which is sent to a preset report distribution interface.

2. The method for generating a test quality report according to claim 1, characterized in that: 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 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 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 consists 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 original test data report and the first and second data fields in the first mirror data table that correspond to each other correspond to each other in one-to-one correspondence; the original table name and the mirror table name of the original test data report and the first mirror data table that correspond to each other 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 a 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, characterized in that: The dashboard-multidimensional table data mapping relationship is used to configure the first dashboard object type, the first object data mapping relationship, the first field condition screening relationship and the first statistical method configuration of each first visualization dashboard object created on the first dashboard according to the dashboard object type, the object data mapping relationship, the field condition screening relationship and the statistical method configuration of all visualization 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 screening relationship is the field data screening 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 screening condition and the condition threshold, and the screening condition at least includes greater than, less than, equal to, not equal to, greater than or equal to, less than or equal to, including and excluding; 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 the total number of records statistics, another type of statistical method is the maximum value statistics, another type of statistical method is the minimum value statistics, and another type of statistical method is the mean statistics.

4. The method for generating a test quality report according to claim 2, characterized in that: 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 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.

5. The method for generating a test quality report according to claim 2, characterized in that: The performing a mirror table data synchronization process 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 on the first transfer library and the current original table name 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 data field corresponding to the second field name in the current mirror data table and the current field name is 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, characterized in that: 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: A round of traversal is performed on all the first mapping relationships of the multidimensional table-mirror table data mapping relationship; and in this round of traversal, the first mapping relationship currently traversed is used as the corresponding current mapping relationship; and 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 are used as the corresponding current target table name, current target field name, current source table name and current source field name; and the first mirror data table corresponding to the mirror table name and the current source table name on the first transfer library is used as the corresponding current mirror data table, and the second field name in the current mirror data table is used as the current source field name. 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; and 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; and 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, characterized in that: The step of converting a test quality report according to the latest first dashboard each time the first dashboard is refreshed to obtain a corresponding first report and sending it to a preset report distribution interface specifically includes: Each time the first dashboard is refreshed, an image transfer is performed on the visualization interface of each of the first visualization dial objects on the first dashboard to obtain a corresponding first dial object view; and 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 of the first report sub-items is composed of a corresponding first text description area and a first view loading area; a descriptive text is preset in each of the first text description areas; the first view loading areas correspond to the first visual dial objects one by one; each of the first view loading areas corresponds to an image loading area size, and each of the first view loading areas 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 is composed of one or more preset first member distribution interfaces; each of the first member distribution interfaces corresponds to a test report demander; the interface types of the first member distribution interfaces 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 processing method for generating a test quality report according to any one of claims 1 to 7, characterized in that: The device comprises: 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; 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 based on a 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 of the created multidimensional table objects 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 used to perform 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 at the second designated time point of 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 annually; the first designated single day includes at least the first day and the last day 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; The report generation and distribution module is used to convert a test quality report according to the latest first dashboard every time the first dashboard is refreshed, obtain a corresponding first report and send it to a preset report distribution interface.

9. An electronic device, characterized in that: include: memory, processors, and transceivers; The processor is used to couple with 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 enabled to execute the method according to any one of claims 1 to 7.

Images