HTTP log playback-based boost test method and device, and computer equipment

Abstract

Embodiments of the present application relate to the technical field of testing, and disclose a pressure boosting test method and device based on HTTP log playback, computer equipment and a computer readable storage medium, the method comprising: forming HTTP log data at recording time when it is detected that the current system initiates each preset operation instruction to a target database table in a database according to a target HTTP request; replacing a playback primary key value with a recording time primary key value according to the HTTP log data at playback time; determining a dependency relationship between each target HTTP request and a dependency relationship between each preset operation instruction corresponding to the HTTP request; re-arranging each HTTP request according to the dependency relationship between each target HTTP request and the dependency relationship between each preset operation instruction corresponding to the HTTP request, forming a concurrent test strategy; and performing stress testing on the current system according to the concurrent test strategy. The embodiments of the present application effectively improve the test efficiency and test effect of pressure boosting test.

Description

A method, apparatus, and computer equipment for pressure testing based on HTTP log playback. Technical Field

[0001] The embodiments of the present invention relate to the field of testing technology, specifically to a pressure boosting test method based on HTTP log playback, a pressure boosting test device based on HTTP log playback, a computer device, and a computer-readable storage medium. Background Technology

[0002] Currently, in the fields of log replay and load testing, requests are typically edited manually before replaying and testing. This method is cumbersome, error-prone, and has limited interface coverage. Existing technologies can automatically obtain HTTP requests by retrieving their logs, eliminating the need for manual editing. However, while this method improves efficiency, the presence of stateful components in the database and the inherent dependencies between requests lead to inconsistencies in database state changes, causing replay failures.

[0003] Existing solutions to the problem of inconsistent database state changes during playback typically rely on identifying specific system identifiers. However, the inventors of this application have discovered that existing methods, by increasing test concurrency settings, are unreasonable and only applicable to specific systems, lacking universality. Summary of the Invention

[0004] In view of the above problems, embodiments of the present invention provide a pressure testing method based on HTTP log replay, a pressure testing device based on HTTP log replay, a computer device, and a computer-readable storage medium, to solve the technical problems of unreasonable concurrent settings and lack of universality in the existing pressure testing technology.

[0005] According to one aspect of the present invention, a method for pressure testing based on HTTP log replay is provided, the method comprising:

[0006] During recording, when the system detects that it has initiated various preset operation instructions to the target database table based on the target HTTP request, it records the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording, thus forming the recording time.

[0007] HTTP log data;

[0008] During playback, the preset operation command during the current system playback is intercepted, and the playback primary key value corresponding to the target primary key generated according to the preset operation command is replaced with the primary key value at the time of recording based on the HTTP log data; the preset operation command during playback is the command initiated to the target database table in the database based on the target HTTP request during playback;

[0009] Based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions, determine the dependencies between each target HTTP request and the dependencies between each preset operation instruction corresponding to the HTTP request;

[0010] Based on the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests, the HTTP requests are rearranged to form a concurrent testing strategy.

[0011] According to the concurrency testing strategy, stress test the current system.

[0012] In one optional approach, the preset operation instruction is an SQL operation statement; during playback, intercepting the preset operation instruction during the current system playback, and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation instruction with the primary key value at the time of recording based on the HTTP log data, includes:

[0013] The SQL operation statement initiated by the current system to the database is intercepted by the replay script;

[0014] Based on the HTTP log data, determine the primary key value recorded during the playback of the target primary key value corresponding to the SQL operation statement;

[0015] Replace the playback primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table with the recording primary key value.

[0016] In one optional approach, the step of intercepting the preset operation command during playback and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation command with the primary key value at the time of recording includes:

[0017] Intercept all preset operation commands sent by the current system to the database during playback;

[0018] When it is found that the target primary key of the target database table to be operated by the preset operation instruction during playback is the same as the target primary key of the target database table to be operated by the preset operation instruction during recording in the HTTP log data, the primary key value at the time of recording is retrieved from the HTTP log data;

[0019] Replace the playback primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table with the recording primary key value.

[0020] In one optional approach, determining the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests, based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions, includes:

[0021] Each line of HTTP log data is converted into a four-tuple; the four-tuple data includes HTTP request information at the time of recording, read operation information, write operation information, and the target primary key parameter at the time of the write operation;

[0022] The read / write dependencies between the preset operation instructions corresponding to the HTTP request are determined based on the quadruple data.

[0023] Based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, the dependencies between the HTTP requests corresponding to the same target database table are determined.

[0024] In one optional approach, the step of rearranging each HTTP request based on the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests to form a concurrent testing strategy includes:

[0025] Based on the read-write dependency relationship between each preset operation instruction corresponding to each HTTP request, preset operation instructions that do not have read-write dependency relationship and preset operation instructions that have read-write dependency relationship are determined in chronological order.

[0026] Preset operation instructions that do not have read / write dependencies are rearranged into concurrent instructions according to time order, while preset operation instructions that have read / write dependencies are determined as non-concurrent instructions.

[0027] Based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, each HTTP request is rearranged into concurrent HTTP requests and non-concurrent HTTP requests.

[0028] Determine the concurrency testing strategy based on concurrent instructions, non-concurrent instructions, concurrent HTTP requests, and non-concurrent HTTP requests.

[0029] In an optional manner, before recording the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording when the current system initiates various preset operation instructions to the target database table according to the target HTTP request, and before forming the HTTP log data at the time of recording, the method further includes:

[0030] Obtain the target database table information and target primary key information of each target database table in the database corresponding to the current system;

[0031] Stores information about each target database table and the target primary key information of each target database table in the database corresponding to the current system.

[0032] In one optional approach, obtaining the target database table information and the target primary key information of each target database table in the database corresponding to the current system includes:

[0033] The target database table information and target primary key information of each target database table in the database corresponding to the current system are obtained by querying with SQL statements.

[0034] According to another aspect of the present invention, a pressure testing device based on HTTP log playback is provided, comprising:

[0035] The recording module is used to record the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table and the corresponding primary key value at the time of recording when the current system detects that it has initiated various preset operation instructions to the target database table in the database according to the target HTTP request during recording, thereby forming HTTP log data at the time of recording.

[0036] The playback module is used to intercept the preset operation command during the current system playback, and replace the playback primary key value corresponding to the target primary key generated according to the preset operation command with the primary key value at the time of recording based on the HTTP log data; the preset operation command during playback is an instruction initiated to the target database table in the database based on the target HTTP request during playback;

[0037] The determination module is used to determine the dependency relationship between each target HTTP request and the dependency relationship between each preset operation instruction corresponding to the HTTP request based on the operation of each target HTTP request on the target database table and the attributes of the preset operation instructions.

[0038] The reordering module is used to reorder each HTTP request according to the dependency relationship between each target HTTP request and the dependency relationship between each preset operation instruction corresponding to the HTTP request, so as to form a concurrent testing strategy.

[0039] The testing module is used to perform stress tests on the current system according to the concurrency testing strategy.

[0040] According to another aspect of the present invention, a computer device is provided, including: a processor, a memory, a communication interface, and a communication bus, wherein the processor, the memory, and the communication interface communicate with each other through the communication bus;

[0041] The memory is used to store at least one executable instruction that causes the processor to perform the operation of the pressure testing method based on HTTP log playback.

[0042] According to another aspect of the present invention, a computer-readable storage medium is provided, the storage medium storing at least one executable instruction, which, when executed on a computer device, causes the computer device to perform the operation of the pressure testing method based on HTTP log playback.

[0043] This invention, in its embodiments, records HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value during recording when the current system detects that it has initiated various preset operation instructions to the target database table based on a target HTTP request, thus forming HTTP log data during recording. During playback, the preset operation instructions during current system playback are intercepted, and the playback primary key value corresponding to the target primary key generated according to the preset operation instructions is replaced with the primary key value during recording based on the HTTP log data. The preset operation instructions during playback are the instructions initiated to the target database table based on the target HTTP request during playback. The following steps are taken: Based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions, the dependencies between each target HTTP request and the dependencies between the preset operation instructions corresponding to each HTTP request are determined; based on the dependencies between each target HTTP request and the dependencies between the preset operation instructions corresponding to each HTTP request, each HTTP request is rearranged to form a concurrent testing strategy; based on the concurrent testing strategy, stress testing is performed on the current system, which can effectively improve the testing efficiency and effect of stress testing, and has universality, adapting to the playback and stress testing of various systems.

[0044] The above description is merely an overview of the technical solutions of the embodiments of the present invention. In order to better understand the technical means of the embodiments of the present invention and to implement them in accordance with the contents of the specification, and to make the above and other objects, features and advantages of the embodiments of the present invention more apparent and understandable, specific embodiments of the present invention are described below. Attached Figure Description

[0045] The accompanying drawings are for illustrative purposes only and are not intended to limit the invention. Furthermore, the same reference numerals denote the same parts throughout the drawings. In the drawings:

[0046] Figure 1 shows a flowchart of the pressure boosting test method based on HTTP log playback provided in an embodiment of the present invention;

[0047] Figure 2 shows a schematic diagram of the overall scheme of the pressure testing method based on HTTP log playback provided in an embodiment of the present invention;

[0048] Figure 3 illustrates the database evolution in the pressure testing method based on HTTP log replay provided in this embodiment of the invention;

[0049] Figure 4 shows a schematic diagram of HTTP log data recording in the pressure boosting test method based on HTTP log playback provided in an embodiment of the present invention;

[0050] Figure 5 shows a schematic diagram of HTTP log data playback in the pressure boosting test method based on HTTP log playback provided in an embodiment of the present invention;

[0051] Figure 6 shows a schematic diagram of the pressure boosting test device based on HTTP log playback provided in an embodiment of the present invention;

[0052] Figure 7 shows a schematic diagram of the structure of the computer device provided in an embodiment of the present invention. Detailed Implementation

[0053] Exemplary embodiments of the invention will now be described in more detail with reference to the accompanying drawings. While exemplary embodiments of the invention are shown in the drawings, it should be understood that the invention can be implemented in various forms and should not be limited to the embodiments set forth herein.

[0054] First, let's further elaborate on the problems existing in the current technology:

[0055] Challenge 1: In existing technologies, the new primary keys generated during replay cannot correspond one-to-one with historical logs. As shown in Figure 3, assume two environments exist simultaneously with identical initial database states (objects A and B exist respectively). Circles represent database operations at time T (and the resulting objects), and arrows represent the objects being operated on. Assuming that HTTP requests in the production environment conform to the business process, there is no consistency issue with database state changes, and the NGINX server accurately records all information from the HTTP requests. However, replaying the HTTP requests accurately recorded by the NGINX server in the replay environment causes inconsistencies with the production environment. This is because the database object IDs generated in the production environment (e.g., ID=D) are usually random, and subsequent accesses to these objects are entirely based on the previously randomly generated IDs (e.g., ID=D). However, in the replay environment, the generated object has a different ID (e.g., ID=F), and subsequent log requests still use the object with ID=D. The database cannot associate with the object with ID=D (the object with ID=D does not exist in the replay environment), thus causing a business data consistency problem, and replay fails.

[0056] Challenge 2: There are strict dependencies between requests, making it impossible to increase concurrency and implement load testing while ensuring the correctness of the dependencies between requests.

[0057] Challenge 3: Each business system has different request dependencies, making it impossible to implement a universal method for analyzing request dependencies.

[0058] Figure 1 shows a flowchart of the pressure boosting test method based on HTTP log replay provided in an embodiment of the present invention. This method is executed by a computer device. The computer device can be a desktop computer, a laptop computer, a distributed device, etc., and the embodiments of the present invention do not impose specific limitations. As shown in Figure 1, the method includes the following steps:

[0059] Step 110: During recording, when it is detected that the current system initiates various preset operation instructions to the target database table in the database according to the target HTTP request, the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table and the corresponding primary key value during recording are recorded to form HTTP log data during recording.

[0060] Before recording, this embodiment of the invention first obtains the target database table information and target primary key information of each target database table in the database corresponding to the current system; then stores the target database table information and target primary key information. Specifically, the target database table information and target primary key information of each target database table in the database corresponding to the current system can be obtained through SQL statements and stored in memory.

[0061] During recording, each HTTP request from the client is recorded as a log text, and the HTTP request logs are recorded through the production environment NGINX server. Specifically, when it is detected that the current system initiates various preset operation instructions to the target database table based on the target HTTP request, the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording are recorded. Since the current system is built on a JAVA application (open-source framework code for database operations), the interception point during recording in this embodiment of the invention is the standardized interface between the application layer of the JAVA application and the database, which is unrelated to the current system itself. The application layer maintains a session connection with the database and constructs an SQL query statement to retrieve all data tables of the current system and their corresponding target primary keys, which are then saved for subsequent matching analysis. The preset operation instructions are SQL operation statements, that is, the SQL statements before the application layer queries the database. During recording, each time the application receives an HTTP request, the SQL statement before the application layer queries the database is intercepted. The SQL statement is analyzed to determine if it is an SQL operation statement. If so, a preset standard function is used to determine if the SQL operation statement modifies the target primary key. If it does, the recording is performed, and the HTTP request information corresponding to the preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording are used to form the HTTP log data during recording.<step,pk_val> The SQL operation statement can be an insert, update, or similar statement. For example, in one embodiment of this invention, the SQL operation statement can be an insert statement: insert into user(id,name,age)values(?,?,?). The default standard functions for setting SQL parameters at the application layer can be PreparedStatementsttLong(x,xx), PreparedStatement setString(xxx,“xxxxx”), PreparedStatementsttInt(y,xxxxxx), and PreparedStatement sttDate() / / ignore. For example, recognizing the above insert statement insert into user(id,name,age)values(23,“guoxin”,34) yields PreparedStatementsttLong(1,23), PreparedStatement setString(2,“guoxin”), PreparedStatementsttInt(3,34), and PreparedStatement sttDate() / / ignore.If the `id` column in the `user` table is identified as the primary key and `id = 23`, then "23" is recorded. Figure 4 shows the key nodes the recording script focuses on. The script intercepts the current system's database connection acquisition method, intercepts all SQL statements, and intercepts all `INSERT` statements. For intercepting the current system's application-layer database connection acquisition method, it specifically retrieves the primary keys of all tables using SQL and stores them in the memory variable `PKS`. For intercepting all SQL statements, it analyzes all tables involved in the SQL statements, storing read tables in the `rtbs` set and write tables in the `wtbs` set. For intercepting all `INSERT` statements, it retrieves the corresponding table from `PKS`, matches it with the primary key column of the current statement, retrieves the primary key value `pk_val` for this insertion, and pairs it with `step`.<step,pk_val> .

[0062] The JAVA application can be a J2EE application. As shown in Figure 2, this embodiment of the invention records HTTP request logs through an NGINX server in a production environment. A general script based on JVM-Sandbox technology is embedded within the J2EE application to record key data for write requests. The recorded points are all standard interfaces or protocols, essential interfaces for all systems (or applications) interacting with the database, eliminating the need to consider the application's own characteristics and thus improving versatility.

[0063] Step 120: During playback, intercept the preset operation command during the current system playback, and replace the playback primary key value corresponding to the target primary key generated according to the preset operation command with the primary key value at the time of recording based on the HTTP log data; the preset operation command during playback is the command initiated to the target database table in the database based on the target HTTP request during playback.

[0064] This invention replays the SQL operation statements initiated by the current system to the database using a replay script. Based on the HTTP log data, the recording primary key value of the target primary key corresponding to the SQL operation statement during replay is determined. The replay primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table is replaced with the recording primary key value. Specifically, all preset operation instructions initiated by the current system to the database during replay are intercepted. When it is found that the target primary key of the target database table operated by the preset operation instruction during replay is the same as the target primary key of the target database table operated by the preset operation instruction during recording in the HTTP log data, the recording primary key value is retrieved from the HTTP log data. The replay primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table is replaced with the recording primary key value. Specifically, the HTTP client sends the recorded HTTP request parameters and the database primary key to the server. The replay script intercepts the SQL INSERT statements sent by the application to the database and replaces the primary key values ​​generated during this replay with the previously recorded primary key values. Figure 5 illustrates the key points the replay script focuses on. For the default operation instruction being an INSERT statement, during replay, it intercepts the HTTP request entry point, targeting the necessary top-down process of the J2EE server, and extracts all previously recorded data from the header.<step,pk_val> Intercept all insert statements, and when a step is found to be different from previous steps...<step,pk_val> If any step is equal, then retrieve the corresponding pk_val and replace the current insert's primary key value.

[0065] Step 130: Based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions, determine the dependencies between each target HTTP request and the dependencies between each preset operation instruction corresponding to the HTTP request.

[0066] Specifically, this is achieved through the following steps:

[0067] Step 1301: Convert each line of HTTP log data into a four-tuple; the four-tuple includes HTTP request information at the time of recording, read operation information, write operation information, and the target primary key parameter at the time of the write operation. It can be represented as: [regular HTTP request information, read tables, write tables, primary key parameter at the time of writing tables (may be multiple)].

[0068] Step 1302: Determine the read / write dependencies between the preset operation instructions corresponding to the HTTP request based on the quadruple data. It is known that a single HTTP request may generate 0 to N read table requests and 0 to N write table requests. This embodiment of the invention analyzes the read / write dependencies of database tables from the perspective of database table read / write operations. For example, in a simple system with only one database table T, all requests in the system involve only read or write operations on T. R represents a read operation, and W represents a write operation. Assume the following database operation sequence exists: [R1, R2, R3, W1, R4, R5, R6, W2]. For an R operation, it depends only on the most recent W operation that occurred earlier than it, while a W operation depends on all R operations following its preceding W operation. Operations without dependencies can be executed concurrently. Through the above analysis, the read / write dependencies between the preset operation instructions corresponding to the HTTP request can be determined.

[0069] Step 1303: Determine the dependencies between HTTP requests corresponding to the same target database table based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request.

[0070] For the database operation sequence: [R1, R2, R3, W1, R4, R5, R6, W2], let H be an HTTP request symbol. H1 contains R1 and R2, and H2 contains R3. There is no dependency between H1 and H2, so the concurrency relationship is satisfied. Therefore, the dependencies between individual HTTP requests can be determined by analyzing the dependencies of database table operations within the HTTP requests.

[0071] Step 140: Based on the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests, rearrange the HTTP requests to form a concurrent testing strategy.

[0072] Specifically, this includes: based on the read-write dependencies between the preset operation instructions corresponding to each HTTP request, determining the preset operation instructions without read-write dependencies and those with read-write dependencies in chronological order. The preset operation instructions without read-write dependencies are then rearranged into concurrent instructions in chronological order, while those with read-write dependencies are determined as non-concurrent instructions. Based on the read-write dependencies between the preset operation instructions corresponding to each HTTP request, each HTTP request is rearranged into concurrent HTTP requests and non-concurrent HTTP requests. For example, for a database operation sequence: [R1, R2, R3, W1, R4, R5, R6, W2], the R operation only depends on the most recent W operation that occurred earlier than it, while the W operation depends on all R operations after its preceding W operation. Operations without dependencies can be executed concurrently.

[0073] Therefore, the sequence can be rearranged as: [R1, R2, R3 are concurrent] -> [W1] -> [R4, R5, R6 are concurrent] -> [W2]. Thus, a concurrency testing strategy can be determined based on concurrent instructions, non-concurrent instructions, concurrent HTTP requests, and non-concurrent HTTP requests. Specifically, a directed acyclic graph (DAG) can be constructed based on this dependency relationship; the nodes of the DAG represent HTTP requests, and the edges between nodes represent dependencies; the concurrency testing strategy is obtained from the DAG. The concurrency testing strategy refers to the strategy of performing concurrency testing according to concurrent HTTP requests. Specifically, the DAG can be traversed according to a preset priority algorithm; when any HTTP request node is found to have no preceding dependencies, one or more HTTP requests are sent to the test server.

[0074] Step 150: Perform stress testing on the current system according to the concurrency testing strategy.

[0075] The test server performs load testing based on received HTTP requests. This method allows for on-demand increases in concurrency and interface coverage during load testing. Furthermore, because it intercepts the interaction information between the underlying Java application and the database, rather than using the system's own identification characteristics, this load testing method has broad applicability.

[0076] This invention, in its embodiments, records HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording when the current system detects that it has initiated various preset operation instructions to the target database table based on a target HTTP request during recording, thus forming HTTP log data at the time of recording. During playback, the preset operation instructions at the time of playback are intercepted, and the playback primary key value corresponding to the target primary key generated according to the preset operation instructions is replaced with the primary key value at the time of recording based on the HTTP log data. The preset operation instructions at the time of playback are those initiated to the target database table based on the target HTTP request during playback. The instructions involve determining the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to each HTTP request, based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions. Then, based on these dependencies, the HTTP requests are rearranged to form a concurrent testing strategy. Finally, the current system is stress-tested according to the concurrent testing strategy. This effectively improves the efficiency and effectiveness of stress testing and has universality, adapting to playback and stress testing of various systems.

[0077] Figure 6 shows a schematic diagram of the pressure boosting test device based on HTTP log playback provided in an embodiment of the present invention. As shown in Figure 6, the device 200 includes:

[0078] Recording module 210 is used to record, during recording, the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table and the corresponding primary key value during recording when it is detected that the current system initiates each preset operation instruction to the target database table in the database according to the target HTTP request, to form HTTP log data during recording;

[0079] The playback module 220 is used to intercept the preset operation command during the current system playback, and replace the playback primary key value corresponding to the target primary key generated according to the preset operation command with the primary key value at the time of recording according to the HTTP log data; the preset operation command during playback is an instruction initiated to the target database table in the database according to the target HTTP request during playback;

[0080] The determining module 230 is used to determine the dependency relationship between each target HTTP request and the dependency relationship between each preset operation instruction corresponding to the HTTP request based on the operation of each target HTTP request on the target database table and the attributes of the preset operation instruction.

[0081] The reordering module 240 is used to reorder each HTTP request according to the dependency relationship between each target HTTP request and the dependency relationship between each preset operation instruction corresponding to the HTTP request, so as to form a concurrent testing strategy.

[0082] The testing module 250 is used to perform stress tests on the current system according to the concurrency testing strategy.

[0083] In one optional approach, the preset operation instruction is an SQL operation statement; during playback, intercepting the preset operation instruction during the current system playback, and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation instruction with the primary key value at the time of recording based on the HTTP log data, includes:

[0084] The SQL operation statement initiated by the current system to the database is intercepted by the replay script;

[0085] Based on the HTTP log data, determine the primary key value recorded during the playback of the target primary key value corresponding to the SQL operation statement;

[0086] Replace the playback primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table with the recording primary key value.

[0087] In one optional approach, the step of intercepting the preset operation command during playback and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation command with the primary key value at the time of recording includes:

[0088] Intercept all preset operation commands sent by the current system to the database during playback;

[0089] When it is found that the target primary key of the target database table to be operated by the preset operation instruction during playback is the same as the target primary key of the target database table to be operated by the preset operation instruction during recording in the HTTP log data, the primary key value at the time of recording is retrieved from the HTTP log data;

[0090] Replace the playback primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table with the recording primary key value.

[0091] In one optional approach, determining the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests, based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions, includes:

[0092] Each line of HTTP log data is converted into a four-tuple; the four-tuple data includes HTTP request information at the time of recording, read operation information, write operation information, and the target primary key parameter at the time of the write operation;

[0093] The read / write dependencies between the preset operation instructions corresponding to the HTTP request are determined based on the quadruple data.

[0094] Based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, the dependencies between the HTTP requests corresponding to the same target database table are determined.

[0095] In one optional approach, the step of rearranging each HTTP request based on the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests to form a concurrent testing strategy includes:

[0096] Based on the read-write dependency relationship between each preset operation instruction corresponding to each HTTP request, preset operation instructions that do not have read-write dependency relationship and preset operation instructions that have read-write dependency relationship are determined in chronological order.

[0097] Preset operation instructions that do not have read / write dependencies are rearranged into concurrent instructions according to time order, while preset operation instructions that have read / write dependencies are determined as non-concurrent instructions.

[0098] Based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, each HTTP request is rearranged into concurrent HTTP requests and non-concurrent HTTP requests.

[0099] Determine the concurrency testing strategy based on concurrent instructions, non-concurrent instructions, concurrent HTTP requests, and non-concurrent HTTP requests.

[0100] In an optional manner, before recording the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording when the current system initiates various preset operation instructions to the target database table according to the target HTTP request, and before forming the HTTP log data at the time of recording, the method further includes:

[0101] Obtain the target database table information and target primary key information of each target database table in the database corresponding to the current system;

[0102] Stores information about each target database table and the target primary key information of each target database table in the database corresponding to the current system.

[0103] In one optional approach, obtaining the target database table information and the target primary key information of each target database table in the database corresponding to the current system includes:

[0104] The target database table information and target primary key information of each target database table in the database corresponding to the current system are obtained by querying with SQL statements.

[0105] The specific working process of the pressure boosting test device based on HTTP log playback in this embodiment of the invention is largely the same as the specific working steps of the above method embodiment, and will not be repeated here.

[0106] This invention, in its embodiments, records HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording when the current system detects that it has initiated various preset operation instructions to the target database table based on a target HTTP request during recording, thus forming HTTP log data at the time of recording. During playback, the preset operation instructions at the time of playback are intercepted, and the playback primary key value corresponding to the target primary key generated according to the preset operation instructions is replaced with the primary key value at the time of recording based on the HTTP log data. The preset operation instructions at the time of playback are those initiated to the target database table based on the target HTTP request during playback. The instructions involve determining the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to each HTTP request, based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions. Then, based on these dependencies, the HTTP requests are rearranged to form a concurrent testing strategy. Finally, the current system is stress-tested according to the concurrent testing strategy. This effectively improves the efficiency and effectiveness of stress testing and has universality, adapting to playback and stress testing of various systems.

[0107] Figure 7 shows a schematic diagram of the structure of a computer device provided in an embodiment of the present invention. The specific implementation of the computer device is not limited by the specific embodiments of the present invention.

[0108] As shown in Figure 7, the computer device may include: a processor 302, a communications interface 304, a memory 306, and a communications bus 308.

[0109] The processor 302, communication interface 304, and memory 306 communicate with each other via communication bus 408. Communication interface 304 is used to communicate with other network elements such as clients or other servers. The processor 302 executes program 310, specifically performing the relevant steps described in the embodiment of the pressure boosting test method based on HTTP log playback.

[0110] Specifically, program 310 may include program code, which includes computer-executable instructions.

[0111] Processor 302 may be a central processing unit (CPU), an application-specific integrated circuit (ASIC), or one or more integrated circuits configured to implement embodiments of the present invention. The computer device includes one or more processors, which may be processors of the same type, such as one or more CPUs; or processors of different types, such as one or more CPUs and one or more ASICs.

[0112] Memory 306 is used to store program 310. Memory 306 may include high-speed RAM memory, and may also include non-volatile memory, such as at least one disk storage device.

[0113] Specifically, program 310 can be called by processor 302 to cause the computer device to perform the following operations:

[0114] In one optional approach, the preset operation instruction is an SQL operation statement; during playback, intercepting the preset operation instruction during the current system playback, and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation instruction with the primary key value at the time of recording based on the HTTP log data, includes:

[0115] The SQL operation statement initiated by the current system to the database is intercepted by the replay script;

[0116] Based on the HTTP log data, determine the primary key value recorded during the playback of the target primary key value corresponding to the SQL operation statement;

[0117] Replace the playback primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table with the recording primary key value.

[0118] In one optional approach, the step of intercepting the preset operation command during playback and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation command with the primary key value at the time of recording includes:

[0119] Intercept all preset operation commands sent by the current system to the database during playback;

[0120] When it is found that the target primary key of the target database table to be operated by the preset operation instruction during playback is the same as the target primary key of the target database table to be operated by the preset operation instruction during recording in the HTTP log data, the primary key value at the time of recording is retrieved from the HTTP log data;

[0121] Replace the playback primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table with the recording primary key value.

[0122] In one optional approach, determining the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests, based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions, includes:

[0123] Each line of HTTP log data is converted into a four-tuple; the four-tuple data includes HTTP request information at the time of recording, read operation information, write operation information, and the target primary key parameter at the time of the write operation;

[0124] The read / write dependencies between the preset operation instructions corresponding to the HTTP request are determined based on the quadruple data.

[0125] Based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, the dependencies between the HTTP requests corresponding to the same target database table are determined.

[0126] In one optional approach, the step of rearranging each HTTP request based on the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests to form a concurrent testing strategy includes:

[0127] Based on the read-write dependency relationship between each preset operation instruction corresponding to each HTTP request, preset operation instructions that do not have read-write dependency relationship and preset operation instructions that have read-write dependency relationship are determined in chronological order.

[0128] Preset operation instructions that do not have read / write dependencies are rearranged into concurrent instructions according to time order, while preset operation instructions that have read / write dependencies are determined as non-concurrent instructions.

[0129] Based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, each HTTP request is rearranged into concurrent HTTP requests and non-concurrent HTTP requests.

[0130] Determine the concurrency testing strategy based on concurrent instructions, non-concurrent instructions, concurrent HTTP requests, and non-concurrent HTTP requests.

[0131] In an optional manner, before recording the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording when the current system initiates various preset operation instructions to the target database table according to the target HTTP request, and before forming the HTTP log data at the time of recording, the method further includes:

[0132] Obtain the target database table information and target primary key information of each target database table in the database corresponding to the current system;

[0133] Stores information about each target database table and the target primary key information of each target database table in the database corresponding to the current system.

[0134] In one optional approach, obtaining the target database table information and the target primary key information of each target database table in the database corresponding to the current system includes:

[0135] The target database table information and target primary key information of each target database table in the database corresponding to the current system are obtained by querying with SQL statements.

[0136] The specific working process of the pressure boosting test device based on HTTP log playback in this embodiment of the invention is largely the same as the specific working steps of the above method embodiment, and will not be repeated here.

[0137] This invention, in its embodiments, records HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording when the current system detects that it has initiated various preset operation instructions to the target database table based on a target HTTP request during recording, thus forming HTTP log data at the time of recording. During playback, the preset operation instructions at the time of playback are intercepted, and the playback primary key value corresponding to the target primary key generated according to the preset operation instructions is replaced with the primary key value at the time of recording based on the HTTP log data. The preset operation instructions at the time of playback are those initiated to the target database table based on the target HTTP request during playback. The instructions involve determining the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to each HTTP request, based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions. Then, based on these dependencies, the HTTP requests are rearranged to form a concurrent testing strategy. Finally, the current system is stress-tested according to the concurrent testing strategy. This effectively improves the efficiency and effectiveness of stress testing and has universality, adapting to playback and stress testing of various systems.

[0138] This invention provides a computer-readable storage medium storing at least one executable instruction that, when executed on a computer device, causes the computer device to perform the pressure testing method based on HTTP log playback in any of the above method embodiments.

[0139] Executable instructions can be used to cause computer devices to perform the following operations:

[0140] In one optional approach, the preset operation instruction is an SQL operation statement; during playback, intercepting the preset operation instruction during the current system playback, and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation instruction with the primary key value at the time of recording based on the HTTP log data, includes:

[0141] The SQL operation statement initiated by the current system to the database is intercepted by the replay script;

[0142] Based on the HTTP log data, determine the primary key value recorded during the playback of the target primary key value corresponding to the SQL operation statement;

[0143] Replace the playback primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table with the recording primary key value.

[0144] In one optional approach, the step of intercepting the preset operation command during playback and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation command with the primary key value at the time of recording includes:

[0145] Intercept all preset operation commands sent by the current system to the database during playback;

[0146] When it is found that the target primary key of the target database table to be operated by the preset operation instruction during playback is the same as the target primary key of the target database table to be operated by the preset operation instruction during recording in the HTTP log data, the primary key value at the time of recording is retrieved from the HTTP log data;

[0147] Replace the playback primary key value corresponding to the target primary key generated according to the preset operation instruction in the target database table with the recording primary key value.

[0148] In one optional approach, determining the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests, based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions, includes:

[0149] Each line of HTTP log data is converted into a four-tuple; the four-tuple data includes HTTP request information at the time of recording, read operation information, write operation information, and the target primary key parameter at the time of the write operation;

[0150] The read / write dependencies between the preset operation instructions corresponding to the HTTP request are determined based on the quadruple data.

[0151] Based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, the dependencies between the HTTP requests corresponding to the same target database table are determined.

[0152] In one optional approach, the step of rearranging each HTTP request based on the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests to form a concurrent testing strategy includes:

[0153] Based on the read-write dependency relationship between each preset operation instruction corresponding to each HTTP request, preset operation instructions that do not have read-write dependency relationship and preset operation instructions that have read-write dependency relationship are determined in chronological order.

[0154] Preset operation instructions that do not have read / write dependencies are rearranged into concurrent instructions according to time order, while preset operation instructions that have read / write dependencies are determined as non-concurrent instructions.

[0155] Based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, each HTTP request is rearranged into concurrent HTTP requests and non-concurrent HTTP requests.

[0156] Determine the concurrency testing strategy based on concurrent instructions, non-concurrent instructions, concurrent HTTP requests, and non-concurrent HTTP requests.

[0157] In an optional manner, before recording the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording when the current system initiates various preset operation instructions to the target database table according to the target HTTP request, and before forming the HTTP log data at the time of recording, the method further includes:

[0158] Obtain the target database table information and target primary key information of each target database table in the database corresponding to the current system;

[0159] Stores information about each target database table and the target primary key information of each target database table in the database corresponding to the current system.

[0160] In one optional approach, obtaining the target database table information and the target primary key information of each target database table in the database corresponding to the current system includes:

[0161] The target database table information and target primary key information of each target database table in the database corresponding to the current system are obtained by querying with SQL statements.

[0162] The specific working process of the pressure boosting test device based on HTTP log playback in this embodiment of the invention is largely the same as the specific working steps of the above method embodiment, and will not be repeated here.

[0163] This invention, in its embodiments, records HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording when the current system detects that it has initiated various preset operation instructions to the target database table based on a target HTTP request during recording, thus forming HTTP log data at the time of recording. During playback, the preset operation instructions at the time of playback are intercepted, and the playback primary key value corresponding to the target primary key generated according to the preset operation instructions is replaced with the primary key value at the time of recording based on the HTTP log data. The preset operation instructions at the time of playback are those initiated to the target database table based on the target HTTP request during playback. The instructions involve determining the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to each HTTP request, based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions. Then, based on these dependencies, the HTTP requests are rearranged to form a concurrent testing strategy. Finally, the current system is stress-tested according to the concurrent testing strategy. This effectively improves the efficiency and effectiveness of stress testing and has universality, adapting to playback and stress testing of various systems.

[0164] This invention provides a pressure boosting test device based on HTTP log playback, used to execute the aforementioned pressure boosting test method based on HTTP log playback.

[0165] This invention provides a computer program that can be called by a processor to cause a computer device to execute the pressure boosting test method based on HTTP log playback in any of the above method embodiments.

[0166] This invention provides a computer program product, which includes a computer program stored on a computer-readable storage medium. The computer program includes program instructions, which, when executed on a computer, cause the computer to perform the pressure testing method based on HTTP log playback in any of the above method embodiments.

[0167] The algorithms or displays provided herein are not inherently related to any particular computer, virtual system, or other device. Various general-purpose systems can also be used in conjunction with the teachings herein. The required structure for constructing such systems is apparent from the above description. Furthermore, the embodiments of the present invention are not directed to any particular programming language. It should be understood that the content of the invention described herein can be implemented using various programming languages, and the above description of specific languages ​​is for the purpose of disclosing the best mode of implementation of the invention.

[0168] Numerous specific details are set forth in the specification provided herein. However, it will be understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures, and techniques have not been shown in detail so as not to obscure the understanding of this specification.

[0169] Similarly, it should be understood that, in order to streamline the invention and aid in understanding one or more of the various aspects of the invention, features of the embodiments of the invention are sometimes grouped together in a single embodiment, figure, or description thereof in the above description of exemplary embodiments of the invention. However, this disclosure should not be construed as reflecting an intention that the claimed invention requires more features than are expressly recited in each claim.

[0170] Those skilled in the art will understand that modules in the device of the embodiments can be adaptively changed and placed in one or more devices different from that embodiment. Modules, units, or components in the embodiments can be combined into a single module, unit, or component, and can be divided into multiple sub-modules, sub-units, or sub-components. Except where at least some of such features and / or processes or units are mutually exclusive, any combination can be used to combine all features disclosed in this specification (including the accompanying claims, abstract, and drawings) and all processes or units of any method or device so disclosed. Unless expressly stated otherwise, each feature disclosed in this specification (including the accompanying claims, abstract, and drawings) may be replaced by an alternative feature that serves the same, equivalent, or similar purpose.

[0171] It should be noted that the above embodiments are illustrative of the invention and not restrictive, and that those skilled in the art can devise alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses should not be construed as limiting the claims. The word "comprising" does not exclude the presence of elements or steps not listed in the claims. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention can be implemented by means of hardware comprising several different elements and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by the same item of hardware. The use of the words first, second, and third, etc., does not indicate any order. These words can be interpreted as names. The steps in the above embodiments, unless otherwise specified, should not be construed as limiting the order of execution.

Claims

1. A method for pressure testing based on HTTP log replay, characterized in that, The method includes: during recording, when it is detected that the current system initiates various preset operation instructions to a target database table in the database according to a target HTTP request, recording the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value during recording, forming HTTP log data during recording; the preset operation instructions are SQL operation statements; during playback, the preset operation instructions during playback are intercepted, and the playback primary key value corresponding to the target primary key generated according to the preset operation instructions is replaced with the primary key value during recording based on the HTTP log data; the preset operation instructions during playback are instructions initiated to the target database table in the database according to the target HTTP request during playback; based on the operations of each target HTTP request on the target database table and the attributes of the preset operation instructions, determining the dependencies between each target HTTP request and the dependencies between each preset operation instruction corresponding to the HTTP request, including: converting each line of HTTP log data into four-tuple data; the four-tuple data includes HTTP request information during recording, read operation information, write operation information, and the target primary key during write operations. The parameters are as follows: Based on the four-tuple data, the read / write dependencies between the preset operation instructions corresponding to the HTTP requests are determined; based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, the dependencies between HTTP requests corresponding to the same target database table are determined; based on the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to the HTTP requests, each HTTP request is rearranged to form a concurrency testing strategy, including: based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request, determining the preset operation instructions without read / write dependencies and the preset operation instructions with read / write dependencies in chronological order; rearranging the preset operation instructions without read / write dependencies into concurrent instructions in chronological order, and determining the preset operation instructions with read / write dependencies as non-concurrent instructions; rearranging each HTTP request into concurrent HTTP requests and non-concurrent HTTP requests based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request; and performing stress testing on the current system according to the concurrency testing strategy.

2. The method according to claim 1, characterized in that, During playback, intercepting the preset operation command during the current system playback, and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation command with the recording primary key value based on the HTTP log data, includes: intercepting the SQL operation statement initiated by the current system to the database through the playback script; determining the recording primary key value of the target primary key value corresponding to the SQL operation statement during playback based on the HTTP log data; and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation command in the target database table with the recording primary key value.

3. The method according to claim 1, characterized in that, During playback, intercepting the preset operation commands during the current system playback and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation commands with the recording primary key value includes: intercepting all preset operation commands initiated by the current system to the database during playback; when it is found that the target primary key in the target database table to be operated by the preset operation command during playback is the same as the target primary key in the target database table to be operated by the preset operation command during recording in the HTTP log data, retrieving the recording primary key value from the HTTP log data; and replacing the playback primary key value corresponding to the target primary key generated according to the preset operation commands in the target database table with the recording primary key value.

4. The method according to any one of claims 1-3, characterized in that, During recording, before detecting that the current system initiates various preset operation instructions to the target database table in the database according to the target HTTP request, and before recording the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value during recording to form the HTTP log data during recording, the method further includes: obtaining the information of each target database table and the target primary key information of each target database table in the database corresponding to the current system; and storing the information of each target database table and the target primary key information of each target database table in the database corresponding to the current system.

5. The method according to claim 4, characterized in that, The step of obtaining the target database table information and the target primary key information of each target database table in the database corresponding to the current system includes: obtaining the target database table information and the target primary key information of each target database table in the database corresponding to the current system through SQL statements.

6. A pressure testing device based on HTTP log playback, characterized in that, The device includes: a recording module, used to record, during recording, when the current system detects that it has initiated various preset operation instructions to a target database table in the database according to a target HTTP request, the HTTP request information corresponding to each preset operation instruction, the target primary key of the target database table, and the corresponding primary key value at the time of recording, forming HTTP log data at the time of recording; the preset operation instructions are SQL operation statements; a playback module, used to intercept the preset operation instructions at the time of playback of the current system, and replace the playback primary key value corresponding to the target primary key generated according to the preset operation instructions with the primary key value at the time of recording based on the HTTP log data; the preset operation instructions at the time of playback are instructions initiated to the target database table in the database according to the target HTTP request at the time of playback; a determination module, used to determine the dependency relationship between each target HTTP request and the dependency relationship between each preset operation instruction corresponding to the HTTP request based on the operation of each target HTTP request to the target database table and the attributes of each preset operation instruction, including: converting each line of HTTP log data into four-tuple data; the four-tuple data includes HTTP request information at the time of recording, read operation information, write operation information, and write operation information. The system includes: a target primary key parameter; determining the read / write dependencies between preset operation instructions corresponding to each HTTP request based on the four-tuple data; determining the dependencies between HTTP requests corresponding to the same target database table based on the read / write dependencies between the preset operation instructions corresponding to each HTTP request; a reordering module, used to reorder each HTTP request according to the dependencies between the target HTTP requests and the dependencies between the preset operation instructions corresponding to each HTTP request, forming a concurrent testing strategy, including: determining preset operation instructions without read / write dependencies and preset operation instructions with read / write dependencies in chronological order according to the read / write dependencies between the preset operation instructions corresponding to each HTTP request; reordering preset operation instructions without read / write dependencies into concurrent instructions in chronological order, and determining preset operation instructions with read / write dependencies as non-concurrent instructions; reordering each HTTP request into concurrent HTTP requests and non-concurrent HTTP requests according to the read / write dependencies between the preset operation instructions corresponding to each HTTP request; and a testing module, used to perform stress testing on the current system according to the concurrent testing strategy.

7. A computer device, characterized in that, include: The processor, memory, communication interface, and communication bus are provided, wherein the processor, memory, and communication interface communicate with each other via the communication bus. The memory is used to store at least one executable instruction that causes the processor to perform the operation of the pressure testing method based on HTTP log playback as described in any one of claims 1-5.

8. A computer-readable storage medium, characterized in that, The storage medium stores at least one executable instruction, which, when executed on a computer device, causes the computer device to perform the operation of the pressure testing method based on HTTP log playback as described in any one of claims 1-5.

Images