CN114218080A - Output data multiplexing method, device, equipment and readable storage medium - Google Patents

Output data multiplexing method, device, equipment and readable storage medium Download PDF

Info

Publication number
CN114218080A
CN114218080A CN202111483236.1A CN202111483236A CN114218080A CN 114218080 A CN114218080 A CN 114218080A CN 202111483236 A CN202111483236 A CN 202111483236A CN 114218080 A CN114218080 A CN 114218080A
Authority
CN
China
Prior art keywords
data
multiplexing
project
parameterized
database
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111483236.1A
Other languages
Chinese (zh)
Inventor
张晓丽
刘光宇
熊严飞
于首阁
冷炜
高蕊
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Citic Bank Corp Ltd
Original Assignee
China Citic Bank Corp Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Citic Bank Corp Ltd filed Critical China Citic Bank Corp Ltd
Priority to CN202111483236.1A priority Critical patent/CN114218080A/en
Publication of CN114218080A publication Critical patent/CN114218080A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3688Test management for test execution, e.g. scheduling of test suites
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2465Query processing support for facilitating data mining operations in structured databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Quality & Reliability (AREA)
  • Computer Hardware Design (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The invention relates to the field of performance testing, in particular to a product data multiplexing method, a device, equipment and a readable storage medium. The method comprises the steps of obtaining project data to be measured, product data of inventory projects and multiplexing level information; inputting the output data of the inventory project into a first processing module to obtain project multiplexing data, and sending the project multiplexing data to a database to obtain a project multiplexing database; processing the multiplexing database by using the connection string data and the SQL statement to obtain parameterized data of the multiplexing database; inputting the item data to be tested, the parametric data and the multiplexing level information into a second processing module to obtain the multiplexing level of the parametric data; multiplexing the parametric data according to the multiplexing level of the parametric data. The invention realizes the full-process automatic intelligent matching screening, provides implementation materials for automatic regression execution and greatly improves the implementation efficiency of performance test.

Description

Output data multiplexing method, device, equipment and readable storage medium
Technical Field
The invention relates to the field of performance testing, in particular to a product data multiplexing method, a device, equipment and a readable storage medium.
Background
At present, in the performance test implementation process, because the filing of the test project products is not standard, the efficient utilization can not be achieved, so that the project reference difficulty is higher, only the storage materials can be manually searched and whether the multiplexing can be carried out can be artificially judged, if the multiplexing can be carried out, the multiplexing products need to be downloaded, and therefore, the multiplexing difficulty of the test project under the current background is higher, the test implementation efficiency is low, and the cost is high.
Disclosure of Invention
The present invention aims to provide a method, a device and a readable storage medium for reusing the produced product data, so as to improve the problems. In order to achieve the purpose, the technical scheme adopted by the invention is as follows:
in one aspect, the present application provides an effluent data multiplexing method, the method comprising:
acquiring data of a project to be tested, product data of inventory projects and multiplexing level information, wherein the product data of the inventory projects is the product data of the test projects in the performance test process, and the multiplexing level information comprises a multiplexing rule of the product data of at least one inventory project;
inputting the product data of the inventory project into a first processing module to obtain project multiplexing data, and sending the project multiplexing data to a database to obtain a project multiplexing database, wherein the first processing module is a data extraction module and is used for extracting data needing multiplexing in the product data;
acquiring connection string data of the project multiplexing database and SQL sentences of the project multiplexing database data, and processing the multiplexing database by using the connection string data and the SQL sentences to obtain parameterized data of the multiplexing database;
inputting the item data to be detected, the parametric data and the multiplexing level information into a second processing module to obtain the multiplexing level of the parametric data, wherein the second processing module is a keyword comparison module and is used for retrieving and comparing keywords;
multiplexing the parametric data according to the multiplexing level of the parametric data.
Optionally, the obtaining the project multiplexing data, and sending the project multiplexing data to a database to obtain a project multiplexing database includes:
performing data extraction on the output data of the inventory item, and extracting document data, transaction script data, environment data and test data in the output data of the inventory item, wherein the document data comprises test target data, pressure test transaction data, environment configuration parameter data and result data, the transaction script data is script frame data, and the environment data comprises tested server-side environment data and press machine environment data;
and summarizing the document data, the transaction script data, the environment data and the test data to obtain project multiplexing data, and sending the project multiplexing data to a database to form a project multiplexing database.
Optionally, the obtaining the connection string data of the project multiplexing database and the SQL statement of the project multiplexing database data, and processing the multiplexing database using the connection string data and the SQL statement to obtain the parameterized data of the multiplexing database includes:
calling the tested service end environment data and the press machine environment data in the multiplexing database;
replacing the connection string data with the tested service-end environment data and the press machine environment data to form new project connection string data;
inputting the new project connection string data and the SQL statement into an execution module to execute an SQL file to obtain an execution result;
and outputting the execution result according to a parameterized format to obtain parameterized data of the multiplexing database.
Optionally, the inputting the item data to be tested, the parameterized data, and the multiplexing level information into a second processing module for processing to obtain the multiplexing level of the parameterized data includes:
calling a keyword of the name of the tested system, a keyword of the tested system I D, a keyword of the environmental data of the tested service end, a keyword of the name of the tested transaction and a keyword of the transaction identity code in the item data to be tested;
searching and comparing the extracted keywords with the parameterized data, judging whether the keywords are consistent with the parameterized data or not, and obtaining a comparison result;
and determining the multiplexing level of the parameterized data according to the multiplexing level information by using the comparison result.
Optionally, the multiplexing the parameterized data according to the multiplexing level of the parameterized data includes:
if the multiplexing level is first-level multiplexing, the parameterized data is completely multiplexed;
if the multiplexing level is secondary multiplexing, automatically replacing script data in the project data to be tested into a script to be tested to form new script data, converting the new script data into parameterized script data, and multiplexing the parameterized script data;
if the multiplexing level is three-level multiplexing, calling script frame data in the project data to be tested, converting the script frame data into parameterized script frame data, and multiplexing the parameterized script frame data.
Optionally, the multiplexing the parameterized data according to the multiplexing level of the parameterized data further includes:
acquiring the multiplexing result data and a first threshold value, and sending the multiplexing result data to a multiplexing result database;
judging whether the multiplexing result data is greater than a first threshold value, if so, marking the multiplexing result as green, and sending an instruction that the performance of the system meets the requirement to a mobile phone of an operator;
and if the multiplexing result is smaller than a first threshold value, marking the multiplexing result as red, and sending an instruction that the performance of the system of the multiplexing personnel does not meet the requirement and the system needs to be repaired to a mobile phone of an operator.
In a second aspect, embodiments of the present application provide an effluent data multiplexing apparatus, the apparatus including:
the system comprises a first acquisition unit, a second acquisition unit and a control unit, wherein the first acquisition unit is used for acquiring to-be-tested project data, inventory project output data and multiplexing level information, the inventory project output data is test project output data in a performance test process, and the multiplexing level information comprises a multiplexing rule of at least one inventory project output data;
the first processing unit is used for inputting the product data of the inventory project into a first processing module to obtain project multiplexing data, and sending the project multiplexing data to a database to obtain a project multiplexing database, and the first processing module is a data extraction module and is used for extracting data needing multiplexing in the product data;
the second acquisition unit is used for acquiring the connection string data of the project multiplexing database and the SQL sentences of the project multiplexing database data, and processing the multiplexing database by using the connection string data and the SQL sentences to obtain the parameterized data of the multiplexing database;
the second processing unit is used for inputting the item data to be detected, the parametric data and the multiplexing level information into a second processing module to obtain the multiplexing level of the parametric data, and the second processing module is a keyword comparison module and is used for retrieving and comparing keywords;
a third processing unit, configured to multiplex the parameterized data according to a multiplexing level of the parameterized data.
Optionally, the obtaining the project multiplexing data, and sending the project multiplexing data to a database to obtain a project multiplexing database includes:
the first processing subunit is used for performing data extraction on the product data of the inventory item, and extracting document data, transaction script data, environment data and test data in the product data of the inventory item, wherein the document data comprises test target data, pressure test transaction data, environment configuration parameter data and result data, the transaction script data is script frame data, and the environment data comprises tested service-side environment data and press machine environment data;
and the second processing subunit is used for summarizing the document data, the transaction script data, the environment data and the test data to obtain project multiplexing data, and sending the project multiplexing data to a database to form a project multiplexing database.
Optionally, the obtaining the connection string data of the project multiplexing database and the SQL statement of the project multiplexing database data, and processing the multiplexing database using the connection string data and the SQL statement to obtain the parameterized data of the multiplexing database includes:
the third processing subunit is used for calling the tested service end environment data and the press machine environment data in the multiplexing database;
the fourth processing subunit is used for replacing the connection string data with the tested service-end environment data and the press environment data to form new project connection string data;
the fifth processing subunit is used for inputting the new project connection string data and the SQL statement into an execution module to execute the SQL file, so as to obtain an execution result;
and the sixth processing subunit is used for outputting the execution result according to a parameterized format to obtain parameterized data of the multiplexing database.
Optionally, the inputting the item data to be tested, the parameterized data, and the multiplexing level information into a second processing module for processing to obtain the multiplexing level of the parameterized data includes:
the seventh processing subunit is configured to call a keyword of the name of the system to be tested, a keyword of the system I D to be tested, a keyword of the environment data of the service end to be tested, a keyword of the name of the transaction to be tested, and a keyword of the transaction identification code in the item data to be tested;
the eighth processing subunit is used for retrieving and comparing the extracted keywords with the parameterized data, judging whether the keywords are consistent with the parameterized data or not and obtaining a comparison result;
a ninth processing subunit, configured to determine, according to the multiplexing level information, a multiplexing level of the parameterized data according to the comparison result.
Optionally, the multiplexing the parameterized data according to the multiplexing level of the parameterized data includes:
a first judging subunit, configured to multiplex all the parameterized data if the multiplexing level is first-level multiplexing;
the second judgment subunit is used for automatically replacing script data in the project data to be tested into the script to be tested to form new script data if the multiplexing level is two-stage multiplexing, converting the new script data into parameterized script data, and multiplexing the parameterized script data;
and the third judging subunit is used for calling script frame data in the item data to be tested if the multiplexing level is three-level multiplexing, converting the script frame data into parameterized script frame data, and multiplexing the parameterized script frame data.
Optionally, the multiplexing the parameterized data according to the multiplexing level of the parameterized data further includes:
a third obtaining unit, configured to obtain the multiplexing result data and the first threshold, and send the multiplexing result data to a multiplexing result database;
the first judgment unit is used for judging whether the multiplexing result data is greater than a first threshold value or not, if the multiplexing result is greater than the first threshold value, the multiplexing result is marked as green, and an instruction that the performance of the system meets the requirement is sent to a mobile phone of an operator;
and the second judgment unit is used for marking the multiplexing result as red if the multiplexing result is smaller than the first threshold value, and sending an instruction that the performance of the system of the multiplexing personnel does not meet the requirement and the system needs to be repaired to the mobile phone of the operator.
In a third aspect, an embodiment of the present application provides an effluent data multiplexing apparatus, including:
a memory for storing a computer program;
and the processor is used for realizing the steps of the output data multiplexing method when executing the computer program.
In a fourth aspect, the present application provides a readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements the steps of the above-mentioned output data multiplexing method.
The invention has the beneficial effects that:
1. the invention replaces the process of manually searching the reusable project information, creates an effective grading multiplexing library, realizes full-process automatic intelligent matching screening, provides implementation materials for automatic regression execution and greatly improves the implementation efficiency of performance test;
2. the implementation cost of a large amount of manual multiplexing is saved, and the multiplexing efficiency of the output data is ensured;
3. by extracting the inventory product in a standardized way, the product reusability in the performance test implementation is improved, and the overall implementation efficiency is improved.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the embodiments of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
FIG. 1 is a schematic flow chart of an effluent data multiplexing method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of an effluent data multiplexing apparatus according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of an effluent data multiplexing apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. The components of embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present invention, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance.
Example 1
As shown in fig. 1, the present embodiment provides an effluent data multiplexing method, which includes step S1, step S2, step S3, step S4 and step S5.
S1, acquiring data of a project to be tested, product data of inventory projects and multiplexing level information, wherein the product data of the inventory projects are the product data of the test projects in the performance test process, and the multiplexing level information comprises a multiplexing rule of the product data of at least one inventory project;
step S2, inputting the output data of the inventory project into a first processing module to obtain project multiplexing data, and sending the project multiplexing data to a database to obtain a project multiplexing database, wherein the first processing module is a data extraction module and is used for extracting the data to be multiplexed in the output data;
step S3, acquiring connection string data of the project multiplexing database and SQL sentences of the project multiplexing database data, and processing the multiplexing database by using the connection string data and the SQL sentences to obtain parameterized data of the multiplexing database;
step S4, inputting the item data to be tested, the parametric data and the multiplexing level information into a second processing module to obtain the multiplexing level of the parametric data, wherein the second processing module is a keyword comparison module and is used for retrieving and comparing keywords;
and step S5, multiplexing the parameterized data according to the multiplexing level of the parameterized data.
The method comprises the steps of extracting key effective information from output data of a storage project, extracting the key effective information from documents, transaction scripts, environments and test data according to project dimensions, putting the extracted key effective information into a database, automatically generating a corresponding parameterized data file according to provided database connection string information and SQL sentences, ensuring that a pressure test script can be directly quoted, comparing the parameterized data with data to be multiplexed in the database according to keywords, determining a corresponding multiplexing level according to a comparison result, and finally multiplexing according to the multiplexing level.
The method has the advantages that the process of manually searching the reusable project information is replaced, an effective grading multiplexing library is created, full-process automatic intelligent matching screening is realized, implementation materials are provided for automatic regression execution, and the implementation efficiency of performance test is greatly improved; the implementation cost of manual multiplexing is greatly saved, and the multiplexing efficiency of the output data is ensured; and the product reuse degree in the performance test implementation is improved and the overall implementation efficiency is improved by extracting the inventory product in a standardized way.
In a specific embodiment of the present disclosure, the step S2 includes steps S21 and S22.
Step S21, data extraction is carried out on the output data of the inventory item, and document data, transaction script data, environment data and test data in the output data of the inventory item are extracted, wherein the document data comprises test target data, pressure test transaction data, environment configuration parameter data and result data, the transaction script data is script frame data, and the environment data comprises tested service end environment data and press machine environment data;
and step S22, summarizing the document data, the transaction script data, the environment data and the test data to obtain project multiplexing data, and sending the project multiplexing data to a database to form a project multiplexing database.
It can be understood that the step asks for the key effective information of the output data of the inventory item, and sends the information to the database for storage, so as to extract the required effective data in a standard manner, improve the product reusability in the performance test implementation and improve the overall implementation efficiency.
In a specific embodiment of the present disclosure, the step S3 includes a step S31, a step S32, a step S33, and a step S34.
Step S31, calling the tested service end environment data and the press machine environment data in the multiplexing database;
step S32, replacing the connection string data with the tested service end environment data and the press machine environment data to form new project connection string data;
step S33, inputting the new project connection string data and the SQL statement into an execution module to execute the SQL file, and obtaining an execution result;
and step S34, outputting the execution result according to a parameterization format to obtain the parameterization data of the multiplexing database.
The method can be understood that the method forms the current new project connection string data by acquiring the database connection string information in the multiplexing database and the SQL sentences for extracting the data and replacing the connection string information in the multiplexing database according to the current environment information, and then converts the data in the multiplexing database into the file which can be automatically identified by the automatic script tool according to the tool.
In a specific embodiment of the present disclosure, the step S4 includes steps S41, S42 and S43.
Step S41, calling keywords of the name of the tested system, keywords of the tested system I D, keywords of the environmental data of the tested service end, keywords of the name of the tested transaction and keywords of the transaction identity code in the item data to be tested;
step S42, retrieving and comparing the extracted keywords with the parameterized data, judging whether the keywords are consistent with the parameterized data or not, and obtaining a comparison result;
step S43, determining the multiplexing level of the parameterized data according to the multiplexing level information from the comparison result.
It can be understood that the invention compares the data to be multiplexed in the library according to the rules of the name of the tested system +4 bit identification, the environment list of the tested service terminal, the name of the tested transaction + the transaction code, etc. and determines the corresponding multiplexing level according to the comparison result, thereby preparing for the next multiplexing according to the multiplexing level.
In a specific embodiment of the present disclosure, the step S5 includes steps S51, S52 and S53.
Step S51, if the multiplexing level is first-level multiplexing, multiplexing all the parameterized data;
step S52, if the multiplexing level is two-stage multiplexing, automatically replacing script data in the project data to be tested into the script to be tested to form new script data, converting the new script data into parameterized script data, and multiplexing the parameterized script data;
and step S53, if the multiplexing level is three-level multiplexing, calling script frame data in the item data to be tested, converting the script frame data into parameterized script frame data, and multiplexing the parameterized script frame data.
It is understood that the rule of one level of multiplexing is: when the tested system, the environment and the transaction are completely consistent, the corresponding script, the test data and the environment list are automatically extracted, and the automatic regression scene execution is carried out by the linkage of the automatic regression system and the automatic product; according to the secondary multiplexing rule, when a system to be tested is consistent with a transaction, script information in a project to be implemented is automatically replaced into a script to be tested to form a new available script, parameterized data are generated through an automatic test data generation tool, the parameterized data are automatically matched with a corresponding press machine through environment list information, and the parameterized script data are multiplexed; the rule of the three-level multiplexing is that when the tested systems are consistent, the script frame multiplexing can be adopted, the script information is replaced under the condition of the same protocol, the test data automatic generation tool is utilized to generate corresponding parameterized script frame data, the parameterized script frame data is multiplexed, when the two-level multiplexing and the three-level multiplexing are carried out, the tested systems are consistent and the transaction parts are consistent, wherein the same transaction can directly multiplex scripts, and when the inconsistent transaction is carried out, the script frame multiplexing is adopted.
In a specific embodiment of the present disclosure, the step S6 further includes a step S7, a step S8 and a step S6.
Step S7, obtaining the multiplexing result data and a first threshold value, and sending the multiplexing result data to a multiplexing result database;
step S8, judging whether the multiplexing result data is larger than a first threshold value, if the multiplexing result is larger than the first threshold value, marking the multiplexing result as green, and sending an instruction that the performance of the system meets the requirement to a mobile phone of an operator;
and step S9, if the multiplexing result is smaller than the first threshold value, marking the multiplexing result as red, and sending an instruction that the performance of the multiplexing personnel system does not meet the requirement and the system needs to be repaired to the mobile phone of the operator.
The invention can be understood by processing and judging the multiplexing result and automatically determining whether the system performance meets the requirements, thereby saving the workload of workers, saving the colleague of cost, accelerating the work progress and improving the overall implementation efficiency.
Example 2
As shown in fig. 2, the present embodiment provides an effluent data multiplexing apparatus, which includes a first obtaining unit 701, a first processing unit 702, a second obtaining unit 703, a second processing unit 704, and a third processing unit 705.
A first obtaining unit 701, configured to obtain data of a project to be tested, product data of inventory projects, and multiplexing level information, where the product data of the inventory projects is the product data of a test project in a performance test process, and the multiplexing level information includes a multiplexing rule of the product data of at least one inventory project;
a first processing unit 702, configured to input the effluent data of the inventory project into a first processing module to obtain project multiplexing data, and send the project multiplexing data to a database to obtain a project multiplexing database, where the first processing module is a data extraction module and is configured to extract data to be multiplexed in the effluent data;
a second obtaining unit 703, configured to obtain connection string data of the project multiplexing database and an SQL statement of the project multiplexing database, and process the multiplexing database using the connection string data and the SQL statement to obtain parameterized data of the multiplexing database;
a second processing unit 704, configured to input the item data to be tested, the parameterized data, and the multiplexing level information into a second processing module, so as to obtain the multiplexing level of the parameterized data, where the second processing module is a keyword comparison module, and is configured to retrieve and compare keywords;
a third processing unit 705 for multiplexing the parametric data according to the multiplexing level of the parametric data.
In a specific embodiment of the present disclosure, the first processing unit 702 includes a first processing subunit 7021 and a second processing subunit 7022.
A first processing subunit 7021, configured to perform data extraction on the product data of the inventory item, and extract document data, transaction script data, environment data, and test data in the product data of the inventory item, where the document data includes test target data, pressure test transaction data, environment configuration parameter data, and result data, the transaction script data is script frame data, and the environment data includes tested service-side environment data and press machine environment data;
and a second processing subunit 7022, configured to summarize the document data, the transaction script data, the environment data, and the test data to obtain item multiplexing data, and send the item multiplexing data to a database to form an item multiplexing database.
In a specific embodiment of the present disclosure, the second obtaining unit 703 includes a third processing subunit 7031, a fourth processing subunit 7032, a fifth processing subunit 7033, and a sixth processing subunit 7034.
A third processing subunit 7031, configured to invoke the measured service end environment data and the press environment data in the multiplexing database;
a fourth processing subunit 7032, configured to replace the connection string data with the measured service end environment data and the press environment data to form new project connection string data;
a fifth processing subunit 7033, configured to input the new project connection string data and the SQL statement to an execution module to execute the SQL file, so as to obtain an execution result;
a sixth processing subunit 7034, configured to output the execution result according to a parameterized format to obtain parameterized data of the multiplexing database.
In a specific embodiment of the present disclosure, the second processing unit 704 includes a seventh processing sub-unit 7041, an eighth processing sub-unit 7042, and a ninth processing sub-unit 7043.
A seventh processing subunit 7041, configured to invoke a keyword of the name of the system to be tested, a keyword of the system I D to be tested, a keyword of the environment data of the service end to be tested, a keyword of the name of the transaction to be tested, and a keyword of the transaction id;
an eighth processing subunit 7042, configured to search and compare the extracted keyword with the parameterized data, determine whether the keyword is consistent with the parameterized data, and obtain a comparison result;
a ninth processing subunit 7043, configured to determine, according to the multiplexing level information, the multiplexing level of the parameterized data according to the comparison result.
In a specific embodiment of the present disclosure, the third processing unit 705 includes a first determining subunit 7051, a second determining subunit 7052, and a third determining subunit 7053.
A first determining subunit 7051, configured to multiplex all the parameterized data if the multiplexing level is first-level multiplexing;
a second determining subunit 7052, configured to, if the multiplexing level is two-stage multiplexing, automatically replace script data in the item data to be tested into a script to be tested to form new script data, convert the new script data into parameterized script data, and multiplex the parameterized script data;
a third determining subunit 7053, configured to, if the multiplexing level is three-level multiplexing, call script frame data in the item data to be tested, convert the script frame data into parameterized script frame data, and multiplex the parameterized script frame data.
In a specific embodiment of the present disclosure, the third processing unit 705 further includes a third obtaining unit 706, a first determining unit 707, and a second determining unit 708.
A third obtaining unit 706, configured to obtain the multiplexing result data and the first threshold, and send the multiplexing result data to a multiplexing result database;
a first determining unit 707, configured to determine whether the multiplexing result data is greater than a first threshold, mark the multiplexing result as green if the multiplexing result is greater than the first threshold, and send an instruction that the performance of the system meets the requirement to a mobile phone of an operator;
a second determining unit 708, configured to mark the multiplexing result as red if the multiplexing result is smaller than the first threshold, and send an instruction that the performance of the system of the multiplexing staff does not meet the requirement and the system needs to be repaired to the mobile phone of the operator.
It should be noted that, regarding the apparatus in the above embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated herein.
Example 3
Corresponding to the above method embodiments, the embodiments of the present disclosure further provide an output data multiplexing device, and a product data multiplexing device described below and a product data multiplexing method described above may be referred to with reference to each other:
FIG. 3 is a block diagram illustrating an effluent data multiplexing apparatus 800 according to an exemplary embodiment. As shown in fig. 3, the output data multiplexing apparatus 800 may include: a processor 801, a memory 802. The output data multiplexing device 800 may also include one or more of a multimedia component 803, an input/output (I/O) interface 804, and a communication component 805.
The processor 801 is configured to control the overall operation of the output data multiplexing apparatus 800, so as to complete all or part of the steps in the output data multiplexing method. The memory 802 is used to store various types of data to support the operation of the output data multiplexing device 800, which may include, for example, instructions for any application or method operating on the output data multiplexing device 800, as well as application-related data, such as contact data, transceived messages, pictures, audio, video, and so forth. The Memory 802 may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as Static Random Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk or optical disk. The multimedia components 803 may include screen and audio components. Wherein the screen may be, for example, a touch screen and the audio component is used for outputting and/or inputting audio signals. For example, the audio component may include a microphone for receiving external audio signals. The received audio signal may further be stored in the memory 802 or transmitted through the communication component 805. The audio assembly also includes at least one speaker for outputting audio signals. The I/O interface 804 provides an interface between the processor 801 and other interface modules, such as a keyboard, mouse, buttons, etc. These buttons may be virtual buttons or physical buttons. The communication component 805 is used for wired or wireless communication between the output data multiplexing apparatus 800 and other apparatuses. Wireless communication, such as Wi-Fi, bluetooth, Near Field Communication (NFC), 2G, 3G, or 4G, or a combination of one or more of them, so that the corresponding communication component 805 may include: Wi-Fi module, bluetooth module, NFC module.
In an exemplary embodiment, the output data multiplexing Device 800 may be implemented by one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field Programmable Gate Arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic components for performing one of the output data multiplexing methods described above.
In another exemplary embodiment, there is also provided a computer readable storage medium comprising program instructions which, when executed by a processor, implement the steps of the above-described effluent data multiplexing method. For example, the computer readable storage medium can be the above-described memory 802 comprising program instructions executable by the processor 801 of the effluent data multiplexing apparatus 800 to perform the above-described effluent data multiplexing method.
Example 4
Corresponding to the above method embodiment, the embodiment of the present disclosure further provides a readable storage medium, and a readable storage medium described below and an effluent data multiplexing method described above can be correspondingly referred to each other.
A readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method for multiplexing output data of the above-described method embodiments.
The readable storage medium may be a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and various other readable storage media capable of storing program codes.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims (14)

1. A method for multiplexing output data, comprising:
acquiring data of a project to be tested, product data of inventory projects and multiplexing level information, wherein the product data of the inventory projects is the product data of the test projects in the performance test process, and the multiplexing level information comprises a multiplexing rule of the product data of at least one inventory project;
inputting the product data of the inventory project into a first processing module to obtain project multiplexing data, and sending the project multiplexing data to a database to obtain a project multiplexing database, wherein the first processing module is a data extraction module and is used for extracting data needing multiplexing in the product data;
acquiring connection string data of the project multiplexing database and SQL sentences of the project multiplexing database data, and processing the multiplexing database by using the connection string data and the SQL sentences to obtain parameterized data of the multiplexing database;
inputting the item data to be detected, the parametric data and the multiplexing level information into a second processing module to obtain the multiplexing level of the parametric data, wherein the second processing module is a keyword comparison module and is used for retrieving and comparing keywords;
multiplexing the parametric data according to the multiplexing level of the parametric data.
2. The effluent data reuse method of claim 1, wherein said obtaining project reuse data, sending said project reuse data to a database to obtain a project reuse database, comprises:
performing data extraction on the output data of the inventory item, and extracting document data, transaction script data, environment data and test data in the output data of the inventory item, wherein the document data comprises test target data, pressure test transaction data, environment configuration parameter data and result data, the transaction script data is script frame data, and the environment data comprises tested server-side environment data and press machine environment data;
and summarizing the document data, the transaction script data, the environment data and the test data to obtain project multiplexing data, and sending the project multiplexing data to a database to form a project multiplexing database.
3. The effluent data reuse method of claim 1, wherein said obtaining the join string data of the project reuse database and the SQL statements of the project reuse database data, and using the join string data and the SQL statements to process the reuse database to obtain the parameterized data of the reuse database comprises:
calling the tested service end environment data and the press machine environment data in the multiplexing database;
replacing the connection string data with the tested service-end environment data and the press machine environment data to form new project connection string data;
inputting the new project connection string data and the SQL statement into an execution module to execute an SQL file to obtain an execution result;
and outputting the execution result according to a parameterized format to obtain parameterized data of the multiplexing database.
4. The effluent data multiplexing method of claim 1, wherein said inputting said project data to be measured, said parameterized data and multiplexing level information into a second processing module for processing to obtain multiplexing level of said parameterized data comprises:
calling keywords of the name of the system to be tested, keywords of the ID of the system to be tested, keywords of the environment data of the service end to be tested, keywords of the name of the transaction to be tested and keywords of the transaction identity code in the item data to be tested;
searching and comparing the extracted keywords with the parameterized data, judging whether the keywords are consistent with the parameterized data or not, and obtaining a comparison result;
and determining the multiplexing level of the parameterized data according to the multiplexing level information by using the comparison result.
5. The effluent data multiplexing method of claim 1, wherein said multiplexing said parameterized data according to multiplexing levels of said parameterized data comprises:
if the multiplexing level is first-level multiplexing, the parameterized data is completely multiplexed;
if the multiplexing level is secondary multiplexing, automatically replacing script data in the project data to be tested into a script to be tested to form new script data, converting the new script data into parameterized script data, and multiplexing the parameterized script data;
if the multiplexing level is three-level multiplexing, calling script frame data in the project data to be tested, converting the script frame data into parameterized script frame data, and multiplexing the parameterized script frame data.
6. The effluent data multiplexing method of claim 1 wherein said multiplexing said parameterized data according to a multiplexing level of said parameterized data further comprises:
acquiring the multiplexing result data and a first threshold value, and sending the multiplexing result data to a multiplexing result database;
judging whether the multiplexing result data is greater than a first threshold value, if so, marking the multiplexing result as green, and sending an instruction that the performance of the system meets the requirement to a mobile phone of an operator;
and if the multiplexing result is smaller than a first threshold value, marking the multiplexing result as red, and sending an instruction that the performance of the system of the multiplexing personnel does not meet the requirement and the system needs to be repaired to a mobile phone of an operator.
7. An output data multiplexing apparatus, comprising:
the system comprises a first acquisition unit, a second acquisition unit and a control unit, wherein the first acquisition unit is used for acquiring to-be-tested project data, inventory project output data and multiplexing level information, the inventory project output data is test project output data in a performance test process, and the multiplexing level information comprises a multiplexing rule of at least one inventory project output data;
the first processing unit is used for inputting the product data of the inventory project into a first processing module to obtain project multiplexing data, and sending the project multiplexing data to a database to obtain a project multiplexing database, and the first processing module is a data extraction module and is used for extracting data needing multiplexing in the product data;
the second acquisition unit is used for acquiring the connection string data of the project multiplexing database and the SQL sentences of the project multiplexing database data, and processing the multiplexing database by using the connection string data and the SQL sentences to obtain the parameterized data of the multiplexing database;
the second processing unit is used for inputting the item data to be detected, the parametric data and the multiplexing level information into a second processing module to obtain the multiplexing level of the parametric data, and the second processing module is a keyword comparison module and is used for retrieving and comparing keywords;
a third processing unit, configured to multiplex the parameterized data according to a multiplexing level of the parameterized data.
8. The effluent data multiplexing apparatus of claim 7, wherein said obtaining project multiplexing data, sending said project multiplexing data to a database to obtain a project multiplexing database, comprises:
the first processing subunit is used for performing data extraction on the product data of the inventory item, and extracting document data, transaction script data, environment data and test data in the product data of the inventory item, wherein the document data comprises test target data, pressure test transaction data, environment configuration parameter data and result data, the transaction script data is script frame data, and the environment data comprises tested service-side environment data and press machine environment data;
and the second processing subunit is used for summarizing the document data, the transaction script data, the environment data and the test data to obtain project multiplexing data, and sending the project multiplexing data to a database to form a project multiplexing database.
9. The effluent data multiplexing apparatus of claim 7 wherein said obtaining the join string data of said project multiplexing database and the SQL statements of said project multiplexing database, and using said join string data and said SQL statements to process the multiplex database to obtain the parameterized data of said multiplex database comprises:
the third processing subunit is used for calling the tested service end environment data and the press machine environment data in the multiplexing database;
the fourth processing subunit is used for replacing the connection string data with the tested service-end environment data and the press environment data to form new project connection string data;
the fifth processing subunit is used for inputting the new project connection string data and the SQL statement into an execution module to execute the SQL file, so as to obtain an execution result;
and the sixth processing subunit is used for outputting the execution result according to a parameterized format to obtain parameterized data of the multiplexing database.
10. The output data multiplexing device of claim 7, wherein said inputting said item data to be measured, said parameterized data and multiplexing level information into a second processing module for processing to obtain multiplexing level of said parameterized data comprises:
the seventh processing subunit is used for calling a keyword of the name of the system to be tested, a keyword of the ID of the system to be tested, a keyword of the environment data of the service end to be tested, a keyword of the name of the transaction to be tested and a keyword of the transaction identity code in the item data to be tested;
the eighth processing subunit is used for retrieving and comparing the extracted keywords with the parameterized data, judging whether the keywords are consistent with the parameterized data or not and obtaining a comparison result;
a ninth processing subunit, configured to determine, according to the multiplexing level information, a multiplexing level of the parameterized data according to the comparison result.
11. The effluent data multiplexing apparatus of claim 7 wherein said multiplexing said parameterized data according to multiplexing levels of said parameterized data comprises:
a first judging subunit, configured to multiplex all the parameterized data if the multiplexing level is first-level multiplexing;
the second judgment subunit is used for automatically replacing script data in the project data to be tested into the script to be tested to form new script data if the multiplexing level is two-stage multiplexing, converting the new script data into parameterized script data, and multiplexing the parameterized script data;
and the third judging subunit is used for calling script frame data in the item data to be tested if the multiplexing level is three-level multiplexing, converting the script frame data into parameterized script frame data, and multiplexing the parameterized script frame data.
12. The effluent data multiplexing apparatus of claim 7 wherein said multiplexing said parameterized data according to a multiplexing level of said parameterized data further comprises:
a third obtaining unit, configured to obtain the multiplexing result data and the first threshold, and send the multiplexing result data to a multiplexing result database;
the first judgment unit is used for judging whether the multiplexing result data is greater than a first threshold value or not, if the multiplexing result is greater than the first threshold value, the multiplexing result is marked as green, and an instruction that the performance of the system meets the requirement is sent to a mobile phone of an operator;
and the second judgment unit is used for marking the multiplexing result as red if the multiplexing result is smaller than the first threshold value, and sending an instruction that the performance of the system of the multiplexing personnel does not meet the requirement and the system needs to be repaired to the mobile phone of the operator.
13. An output data multiplexing apparatus, comprising:
a memory for storing a computer program;
a processor for implementing the steps of the effluent data reuse method as claimed in any one of claims 1 to 6 when executing said computer program.
14. A readable storage medium, characterized by: the readable storage medium has stored thereon a computer program which, when executed by a processor, carries out the steps of the effluent data reuse method according to any one of claims 1 to 6.
CN202111483236.1A 2021-12-07 2021-12-07 Output data multiplexing method, device, equipment and readable storage medium Pending CN114218080A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111483236.1A CN114218080A (en) 2021-12-07 2021-12-07 Output data multiplexing method, device, equipment and readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111483236.1A CN114218080A (en) 2021-12-07 2021-12-07 Output data multiplexing method, device, equipment and readable storage medium

Publications (1)

Publication Number Publication Date
CN114218080A true CN114218080A (en) 2022-03-22

Family

ID=80699948

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111483236.1A Pending CN114218080A (en) 2021-12-07 2021-12-07 Output data multiplexing method, device, equipment and readable storage medium

Country Status (1)

Country Link
CN (1) CN114218080A (en)

Similar Documents

Publication Publication Date Title
CN108052408B (en) Alarm work order rapid submitting method and system based on alarm information content
CN111475694B (en) Data processing method, device, terminal and storage medium
CN110659206B (en) Simulation architecture establishment method and device based on micro-service, medium and electronic equipment
CN110688305B (en) Test environment synchronization method, device, medium and electronic equipment
CN111399848B (en) Hard-coded data detection method and device, electronic equipment and medium
CN112597020A (en) Interface testing method and device, computer equipment and storage medium
CN113760730A (en) Automatic testing method and device
CN110688315A (en) Interface code detection report generation method, electronic device, and storage medium
CN114186019A (en) Enterprise project auditing method and device combining RPA and AI
CN113110995A (en) System migration test method and device
CN113778864A (en) Test case generation method and device, electronic equipment and storage medium
CN111181805A (en) Micro-service test baffle generation method and system based on test case
CN112597034A (en) Test case generation method and device and computer readable storage medium
CN114647590A (en) Test case generation method and related device
CN112241362A (en) Test method, test device, server and storage medium
CN114218080A (en) Output data multiplexing method, device, equipment and readable storage medium
CN111562907A (en) Conversion method and system of user-defined interface data
CN113641523B (en) Log processing method and device
CN115510449A (en) Source code vulnerability detection method and device
CN114996758A (en) Data desensitization method and device and electronic equipment
CN113849415A (en) Control testing method and device, storage medium and electronic equipment
CN103778210A (en) Method and device for judging specific file type of file to be analyzed
CN111723580B (en) Power dispatching station information graph validation method based on voice recognition and image recognition
CN113672587A (en) New media update monitoring method, system, device and medium
CN115495057B (en) Method and system for realizing windows and HDFS communication

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination