Method and apparatus for determining a business entity primary key value

Abstract

The application discloses a method and device for determining a primary key value of a business entity, and the method comprises the following steps: obtaining request traffic of a test application; performing analysis based on the request traffic, and extracting key-value pair information; locating a business module and determining whether there is other business operation with a dependent relationship in a deletion operation associated with the business module; if there is other business operation with a dependent relationship, obtaining corresponding key information extracted from the request content of other business operation based on the key information extracted from the request content of the deletion operation, and obtaining other key-value pair information with the same key information in the request content of other business operation based on the corresponding key information; performing business operation based on the other key-value pair information, and judging whether the key information extracted from the request content of the deletion operation is primary key information through response content. The application can extract key-value information corresponding to the deletion operation and determine whether the key-value information is primary key information, thereby facilitating subsequent replay of the deletion operation.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of permission detection, in particular to a method and device for determining a business entity primary key value. BACKGROUND

[0002] In the over-authorization test scenario, the original request is a delete operation, but the data after deletion cannot be directly replayed. This means that we cannot use the original request for mutation detection because we cannot recreate the delete operation. In order to facilitate the recreation of the delete operation, the primary key value information corresponding to the delete operation needs to be identified and extracted first. However, there is no method in the prior art to determine the primary key value information corresponding to the delete operation. SUMMARY

[0003] The present application aims to provide a method and device for determining a business entity primary key value, electronic equipment and computer readable storage medium, which can solve at least one technical problem in the background art.

[0004] To achieve the above-mentioned purpose, the present application provides a method for determining a business entity primary key value, comprising:

[0005] Obtaining request traffic of a test application;

[0006] Based on the request traffic, the key-value pair information is extracted;

[0007] Locating a business module and determining whether there is a dependent relationship between the delete operation and other business operations in the business operation associated with the business module;

[0008] If there is a dependent relationship between the other business operations, based on the key information extracted from the request content of the delete operation, the corresponding key information extracted from the request content of the other business operation with a dependent relationship is obtained, and based on the corresponding key information, other key-value pair information with the same key information in the request content of the other business operation is obtained;

[0009] Based on the obtained other key-value pair information, the business operation is executed, and it is judged whether the key information extracted from the request content of the delete operation is the primary key information through the response content.

[0010] Optionally, the request traffic of the test application includes:

[0011] Obtaining a set of request traffic of the test application;

[0012] The request traffic of the test application is aggregated and sorted through the request feature information;

[0013] The aggregated and sorted request traffic is stored.

[0014] extracting the stored request traffic for testing.

[0015] Optionally, the locating service module comprises:

[0016] The service module is located by a path in the request URL.

[0017] Optionally, the determining whether there is other business operation dependent on the deletion operation in the business operation associated with the service module comprises:

[0018] traversing the key-value pair information appearing in the request content of the deletion operation, and querying in the request content of other types of business operation, if the number of completely same key-value pairs is M, M pieces of mapping information are added and a first weight value is given, if the number of key-value pairs with the same value but not completely same key is T, T pieces of mapping information are added and a second weight value is given, the second weight value is less than the first weight value;

[0019] Based on the number of key-value pairs appearing in the request content of the deletion operation, the M pieces of mapping information and the first weight value thereof, and the T pieces of mapping information and the second weight value thereof, a dependency degree is obtained.

[0020] If the dependency degree is greater than or equal to a dependency degree threshold value, the corresponding other types of business operation is the other business operation dependent on the deletion operation.

[0021] Optionally, the first weight value is 1, the second weight value is greater than 0 and less than 1, the dependency degree is equal to the ratio of the value obtained by multiplying M by the first weight value and adding T by the second weight value to N, N is the number of key-value pairs appearing in the request content of the deletion operation.

[0022] To achieve the above object, the application further provides a device for determining a business entity primary key value, comprising:

[0023] A first acquisition module is configured to acquire request traffic of a test application.

[0024] An extraction module is configured to analyze the request traffic based on the request traffic to extract key-value pair information therefrom.

[0025] A locating and determining module is configured to locate a service module and determine whether there is other business operation dependent on the deletion operation in the business operation associated with the service module.

[0026] The second obtaining module is configured to, if there is the other business operation dependent on the deletion operation, obtain corresponding key information extracted from the request content of the other business operation dependent on the deletion operation based on the one key information extracted from the request content of the deletion operation, and obtain other key-value pair information with the same key information in the request content of the other business operation based on the corresponding key information.

[0027] The judging module is configured to execute the business operation based on the obtained other key-value pair information, and determine whether the key information extracted from the request content of the deletion operation is primary key information based on response content.

[0028] Optionally, the determining whether the deletion operation in the business operation associated with the business module has the other business operation dependent on the deletion operation comprises:

[0029] traversing the key-value pair information in the request content of the deletion operation, and querying the request content of the other type of business operation, if the number of the completely same key-value pairs is M, adding M pieces of mapping information and assigning a first weight value, if the number of the key-value pairs with the same value but not completely same key is T, adding T pieces of mapping information and assigning a second weight value, the second weight value being less than the first weight value;

[0030] obtaining a dependency degree based on the number of the key-value pairs in the request content of the deletion operation, the M pieces of mapping information and the first weight value, and the T pieces of mapping information and the second weight value;

[0031] if the dependency degree is greater than or equal to a dependency degree threshold value, the corresponding other type of business operation is the other business operation dependent on the deletion operation.

[0032] Optionally, the first weight value is 1, the second weight value is greater than 0 and less than 1, the dependency degree is equal to the ratio of the value obtained by multiplying M by the first weight value and adding T by the second weight value to N, and N is the number of the key-value pairs in the request content of the deletion operation.

[0033] To achieve the above object, the application further provides an electronic device comprising:

[0034] a processor;

[0035] a memory having executable instructions of the processor stored therein;

[0036] The processor is configured to execute the executable instructions to perform the method for determining the primary key value of the business entity as described above.

[0037] To achieve the above object, the application further provides a computer readable storage medium, which stores a program, and the program is executed by a processor to implement the method for determining the primary key value of a business entity as described above.

[0038] The application further provides a computer program product or a computer program, which comprises computer instructions stored in a computer readable storage medium. A processor of an electronic device reads the computer instructions from the computer readable storage medium, and the processor executes the computer instructions to enable the electronic device to execute the method for determining the primary key value of a business entity as described above.

[0039] The application extracts the key-value pair information from the request flow of the test application, locates the business module, and determines whether there is a dependent other business operation in the deletion operation of the business operation associated with the business module; if there is a dependent other business operation, based on the key information (key information in the key-value pair information) extracted from the request content of the deletion operation, the corresponding key information extracted from the request content of the dependent other business operation is obtained, and based on the corresponding key information, other key-value pair information with the same key information in the request content of the other business operation is obtained; and then based on the obtained other key-value pair information, the business operation is executed, and it is judged whether the key information extracted from the request content of the deletion operation is the primary key information through the response content, and then the primary key value information corresponding to the deletion operation can be determined. BRIEF DESCRIPTION OF DRAWINGS

[0040] Figure 1 is a flowchart of the method for determining the primary key value of a business entity according to an embodiment of the application.

[0041] Figure 2 is a flowchart of step S3 according to an embodiment of the application.

[0042] Figure 3 is a schematic block diagram of the device for determining the primary key value of a business entity according to an embodiment of the application.

[0043] Figure 4 is an example block diagram of an electronic device according to an embodiment of the application. DETAILED DESCRIPTION

[0044] In order to describe the technical content, structural features, achieved purposes and effects of the application in detail, the following will be described in detail in combination with the embodiments and the accompanying drawings.

[0045] Embodiment One

[0046] Please refer to Figure 1 The application discloses a method for determining the primary key value of a business entity, comprising:

[0047] S1, obtaining the request flow of a test application.

[0048] Request traffic refers to network requests generated during the running of an application. These requests usually include user-initiated requests such as accessing a website, purchasing a product, or submitting a form, as well as application-initiated requests such as querying data from a database or calling APIs of other services.

[0049] Specifically, obtaining the request traffic of the test application includes:

[0050] Obtaining a set of request traffic of the test application. Optionally, it can be obtained through browser traffic proxy, switch traffic mirroring, operating system traffic sniffing, test application probe crawling, etc.

[0051] Aggregating and sorting the request traffic of the test application through request feature information. Request feature information can include time period, request domain name, and / or other request feature information.

[0052] Data storage of the aggregated and sorted request traffic, which facilitates subsequent multiple tests.

[0053] Extracting the stored request traffic for testing.

[0054] S2, based on the request traffic, extracting the key-value pair information.

[0055] Here, the analysis of the request traffic refers to the analysis of the request path, request query string, request body, response body, and other request content carrying request and response parameters, extracting the general key-value pair storage form for subsequent use.

[0056] The following is an example of extracting key-value pair information:

[0057] Extraction of response content:

[0058]

[0059]

[0060] Can be obtained[

[0061]

[0062]

[0063]

[0064] Extraction of request parameters:

[0065] Can be extracted:

[0066]

[0067]

[0068] Can be extracted to:

[0069]

[0070] S3, locate the business module and determine whether there is a dependent relationship between the delete operation and other business operations in the business operation associated with the business module (i.e. the business operation for the business module). For example, a business module associated business operation includes a delete operation and multiple other business operations (such as query operations), and there may be at least one other business operation that depends on the delete operation.

[0071] Specifically, the business module is located by the path (path) in the request url.

[0072] If it is a Restful request, it can be directly extracted by segmenting the path of the url, such as api / users / xxx can locate the users module, / api / orders can locate the orders module. If it is a non-Restful request, the path of the url can be parsed by NLP technology, such as / api / updateUsers, / api / userList can locate the users module.

[0073] After locating the business module, in order to facilitate the determination of the dependency between the operations, the division of the business operation set associated with the business module can be performed, such as dividing the delete operation into a set, dividing the query operation into a set, and dividing the modification operation into a set. In this way, when determining whether there is a dependent relationship between the delete operation and other business operations, the set can be processed, and after the business operations in one set are confirmed to be completed, the business operations in another set are confirmed.

[0074] Dependency refers to the judgment of whether there is a dependent relationship between different requests by judging whether there is the same value in the content of the request parameters and the response parameters, such as the two requests of getting user list and deleting certain user information exist dependent relationship.

[0075] Please combine Figure 2 , specifically, determine whether there is a dependent relationship between the delete operation and other business operations in the business operation associated with the business module, including:

[0076] S31, traverse the key-value pair information appearing in the request content of the deletion operation, and traverse the request content of other types of business operations (non-deletion operations) to query, if the number of completely same key-value pairs is M, add M pieces of mapping information and assign a first weight value, if the number of key-value pairs with the same value but not completely same key (there are partial same strings) is T, add T pieces of mapping information and assign a second weight value, the second weight value is less than the first weight value. Wherein, M is greater than or equal to 0, T is greater than or equal to 0, and the sum of M and T is less than the sum of the key-value pairs appearing in the request content of the deletion operation.

[0077] The following is an example of a mapping relationship, in which the key-value pairs of the two parties are completely same.

[0078] The data is:

[0079]

[0080] Specifically, the first weight value is 1, the second weight value is greater than 0 and less than 1, and the dependency degree is equal to the ratio of the value obtained by multiplying M by the first weight value and adding T by the second weight value to N, N is the number of key-value pairs appearing in the request content of the deletion operation.

[0081] S32, based on the number of key-value pairs appearing in the request content of the deletion operation, M pieces of mapping information and the first weight value thereof, and T pieces of mapping information and the second weight value thereof, obtain the dependency degree.

[0082] When the second weight value is 0.5, the calculation formula of the dependency degree Q can be: (M+0.5*T) / N.

[0083] S33, if the dependency degree is greater than or equal to the dependency degree threshold, the corresponding other type of business operation is the other business operation that has a dependency relationship with the deletion operation.

[0084] The greater the dependency degree Q, the closer the dependency relationship, so the dependency degree threshold can be set, for example, greater than or equal to 0.75 means that there is a dependency relationship. When there are two or more other business operations that satisfy the dependency relationship, the other business operation with the highest dependency degree is preferred to execute the subsequent steps.

[0085] S4, if there is a business operation with a dependency relationship, based on the key information extracted from the request content of the deletion operation, obtain the corresponding key information extracted from the request content of the other business operation with a dependency relationship, and based on the corresponding key information, obtain other key-value pair information with the same key information in the request content of the other business operation.

[0086] For example, after the dependency determination step, the dependency between DELETE / api / users?id=0e3e3b3c-8j23-4e8d-b81f-62b9f9c2b6d8->GET / api / users is finally obtained. The above step obtains the key information id in the request parameter / api / users?id=0e3e3b3c-8j23-4e8d-b81f-62b9f9c2b6d8 of the delete operation, and then obtains the name and realName information in the targetKeyValue according to the obtained dependency relationship. Further, the other key-value pair information of the same name can be obtained through the targetUrl in the request response parameter.

[0087] S5, based on the obtained other key-value pair information, performing a business operation, and judging whether the key information extracted from the request content of the delete operation is the primary key information through the response content. Since the key information in the other key-value pair information corresponds to the key information extracted from the request content of the delete operation, and the business operation (such as a delete operation) is performed through the other key-value pair information, if the response content conforms to the response content based on the primary key value information to perform the business operation, it can be determined that the key information extracted from the request content of the delete operation is the primary key information. If the response content does not conform to the response content based on the primary key value information to perform the business operation, it can be determined that the corresponding key information extracted from the request content of the delete operation is not the primary key information. Under normal circumstances, it indicates that at least one other key information is extracted from the request content of the delete operation, and the primary key information is the other key information. At this time, the other key information can be used for verification, that is, the above steps S4 and S5 are executed. Of course, specifically, if more than one key-value pair information is extracted from the request content of the delete operation, the order of verification of each key information can be selected according to the mapping of other business operations in which each key-value pair information exists.

[0088] In the following example, the delete operation has two key-value pairs, and the completely mapped key-value pair (the key-value pair is completely the same) is isAdmin=true, but the key-value pair is not the primary key value information, that is, the key information in the key-value pair is not the primary key information. After the verification step, it will be confirmed, and then it is necessary to verify whether the key information in the other key-value pair is the primary key information, and finally it will be confirmed that id is the primary key information.

[0089] / user / delete?id=1&isAdmin=true

[0090] / user / select?userId=1&isAdmin=true

[0091] Regarding the "primary key" mentioned in this application, it is explained as follows:

[0092] The primary key of a business entity refers to a property or combination of properties that uniquely identifies an entity within a business. Each business entity should have a primary key to accurately locate and operate the entity in business operations.

[0093] For example, an order may have multiple attributes such as order number, order time, customer information, etc. In this case, the order number is usually used as the primary key of the business entity because it is unique and unchangeable, and can be used to accurately identify and locate the order.

[0094] In the database, the primary key of the business entity is usually used as the primary key of the table to quickly locate and access data when querying and operating data.

[0095] The primary key extraction of the business entity refers to locating the primary key information of the business entity by analyzing the request context dependency and the associated relationship of the query and modification, deletion of the business resource.

[0096] This application extracts the key-value pair information from the request traffic of the test application, locates the business module and determines whether there are other business operations with dependent relationships in the deletion operation associated with the business module; if there are other business operations with dependent relationships, based on the key information extracted from the request content of the deletion operation (key information in the key-value pair information), the corresponding key information extracted from the request content of the other business operations with dependent relationships is obtained, and based on the corresponding key information, other key-value pair information with the same key information in the request content of the other business operations is obtained; then based on the obtained other key-value pair information, the business operation is executed, and through the response content, it is determined whether the key information extracted from the request content of the deletion operation is the primary key information, and then the primary key value information corresponding to the deletion operation can be determined, which is convenient for subsequent replay of the deletion operation.

[0097] Embodiment two

[0098] Please combine Figure 3 The application discloses a kind of determining business entity primary key value device, comprising:

[0099] First acquisition module 201, for obtaining the request traffic of test application.

[0100] Extraction module 202, for parsing based on request traffic, extract the key-value pair information therein;

[0101] Positioning and determining module 203, for locating business module and determining whether there are other business operations with dependent relationships in the deletion operation associated with the business module.

[0102] The second obtaining module 204 is configured to, if there is other service operation having a dependency relationship, obtain corresponding key information extracted from the request content of the other service operation having the dependency relationship based on the one key information extracted from the request content of the delete operation, and obtain other key-value pair information having the same key information in the request content of the other service operation based on the corresponding key information.

[0103] The judging module 205 is configured to execute the service operation based on the obtained other key-value pair information, and determine whether the key information extracted from the request content of the delete operation is primary key information by judging the response content.

[0104] Specifically, determining whether the delete operation in the service operation associated with the service module has other service operation having a dependency relationship includes:

[0105] traversing the key-value pair information in the request content of the delete operation, and querying the request content of the other type of service operation, if the number of completely same key-value pairs is M, adding M pieces of mapping information and assigning a first weight value, if the number of key-value pairs having the same value but not completely same key is T, adding T pieces of mapping information and assigning a second weight value, and the second weight value is less than the first weight value;

[0106] obtaining the dependency degree based on the number of key-value pairs in the request content of the delete operation, the M pieces of mapping information and the first weight value, and the T pieces of mapping information and the second weight value;

[0107] if the dependency degree is greater than or equal to a dependency degree threshold value, the corresponding other type of service operation is the other service operation having a dependency relationship with the delete operation.

[0108] Further, the first weight value is 1, the second weight value is greater than 0 and less than 1, the dependency degree is equal to the ratio of the value obtained by multiplying M by the first weight value and adding T multiplied by the second weight value to N, and N is the number of key-value pairs in the request content of the delete operation.

[0109] The application extracts the key-value pair information from the request traffic of the test application, locates the service module and determines whether the delete operation in the service operation associated with the service module has other service operation having a dependency relationship, if there is other service operation having a dependency relationship, obtains corresponding key information extracted from the request content of the other service operation having the dependency relationship based on one key information extracted from the request content of the delete operation, and obtains other key-value pair information having the same key information in the request content of the other service operation based on the key information, and further executes the service operation based on the obtained other key-value pair information, and determines whether the key information extracted from the request content of the delete operation is primary key information by judging the response content, and further determines the primary key value information corresponding to the delete operation, facilitating subsequent replay of the delete operation.

[0110] Embodiment three

[0111] Please combine Figure 4 The application discloses an electronic device, comprising:

[0112] A processor 30;

[0113] A memory 40, wherein executable instructions of the processor 30 are stored;

[0114] The processor 30 is configured to execute the method for determining the business entity primary key value as described in embodiment one by executing the executable instructions.

[0115] Embodiment four

[0116] The application discloses a computer readable storage medium, which stores a program, and the program is executed by a processor to implement the method for determining the business entity primary key value as described in embodiment one.

[0117] Embodiment five

[0118] The application discloses an embodiment of a computer program product or a computer program, which comprises computer instructions stored in a computer readable storage medium. The processor of the electronic device reads the computer instructions from the computer readable storage medium, and the processor executes the computer instructions, so that the electronic device executes the above-mentioned method for determining the business entity primary key value.

[0119] It should be understood that, in the embodiments of the application, the processor can be a central processing module (CPU), and the processor can also be other general-purpose processors, digital signal processors (DSP), application specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor.

[0120] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by computer program instructions related to hardware, and the program can be stored in a computer readable storage medium. When the program is executed, the program can include the processes of the above-mentioned embodiment methods. The storage medium can be a magnetic disc, an optical disc, a read-only memory (ROM), a random access memory (RAM), or the like.

[0121] In the above embodiments, the description of each embodiment has its own focus, and the parts not described in detail in a certain embodiment can be referred to the related description of other embodiments.

[0122] The above disclosure is only the preferred embodiment of the present application, and cannot limit the scope of the right of the present application. Therefore, equivalent changes made according to the claims of the present application are all within the scope covered by the present application.

Claims

1. A method of determining a business entity primary key value, the method comprising: receiving a business entity primary key value; and determining whether the business entity primary key value is valid. The method comprises the following steps: obtaining request traffic of a test application; extracting key-value pair information from the request traffic based on analysis of the request traffic; locating a business module and determining whether there is other business operation dependent on a deletion operation associated with the business operation of the business module; if there is other business operation dependent on the deletion operation, obtaining corresponding key information extracted from request content of the other business operation dependent on the deletion operation based on key information extracted from the key-value pair information in the request content of the deletion operation, and obtaining other key-value pair information with the same key information in the request content of the other business operation based on the corresponding key information; performing business operation based on the obtained other key-value pair information, determining whether the key information extracted from the request content of the deletion operation is primary key information by judging the response content, and further determining the primary key value information corresponding to the deletion operation to perform a replay deletion operation; The determination of whether there is other business operation dependent on the deletion operation associated with the business operation of the business module comprises: traversing the key-value pair information in the request content of the deletion operation, and querying the request content of other types of business operation, if the number of completely same key-value pairs is M, adding M pieces of mapping information and assigning a first weight value, if the number of key-value pairs with the same value but not completely same key is T, adding T pieces of mapping information and assigning a second weight value, the second weight value is less than the first weight value; obtaining the dependency degree based on the number of key-value pairs in the request content of the deletion operation, the M pieces of mapping information and the first weight value, and the T pieces of mapping information and the second weight value; if the dependency degree is greater than or equal to a dependency degree threshold, the corresponding other type of business operation is the other business operation dependent on the deletion operation.

2. The method of determining a business entity primary key value of claim 1, wherein, The method for obtaining request traffic of a test application comprises the following steps: obtaining a set of request traffic of the test application; aggregating and sorting the request traffic of the test application through request characteristic information; storing the aggregated and sorted request traffic; extracting the stored request traffic for testing.

3. The method of determining a business entity primary key value of claim 1, wherein, The method for locating a business module comprises the following steps: locating the business module through the path in the request URL.

4. The method of determining a business entity primary key value of claim 1, wherein, The first weight value is 1, the second weight value is greater than 0 and less than 1, the dependency degree is equal to the ratio of the value obtained by multiplying M by the first weight value and adding T by the second weight value to N, and N is the number of key-value pairs in the request content of the deletion operation.

5. An apparatus for determining the primary key value of a business entity, characterized in that, The method comprises the following steps: a first obtaining module for obtaining request traffic of a test application; an extracting module for extracting key-value pair information from the request traffic based on analysis of the request traffic; a locating and determining module for locating a business module and determining whether there is other business operation dependent on a deletion operation associated with the business operation of the business module; The second obtaining module is configured to, if there is the other service operation having a dependency relationship, obtain corresponding key information extracted from the request content of the other service operation having a dependency relationship based on the key information in the key-value pair information extracted from the request content of the delete operation, and obtain other key-value pair information having the same key information in the request content of the other service operation based on the corresponding key information; The judging module is configured to execute the service operation based on the obtained other key-value pair information, determine whether the key information extracted from the request content of the delete operation is primary key information by judging the response content, and further determine the primary key value information corresponding to the delete operation to perform the replay delete operation. The determining whether the delete operation among the service operations associated with the service module has the other service operation having a dependency relationship comprises: traversing the key-value pair information appearing in the request content of the delete operation, querying the request content of the other type of service operation, if the number of completely same key-value pairs is M, adding M pieces of mapping information and assigning a first weight value, if the number of key-value pairs with the same value but not completely same key is T, adding T pieces of mapping information and assigning a second weight value, the second weight value being less than the first weight value; obtaining a dependency degree based on the number of key-value pairs appearing in the request content of the delete operation, the M pieces of mapping information and the first weight value, and the T pieces of mapping information and the second weight value; if the dependency degree is greater than or equal to a dependency degree threshold, the corresponding other type of service operation is the other service operation having a dependency relationship with the delete operation.

6. The apparatus for determining a business entity primary key value of claim 5, wherein, The first weight value is 1, the second weight value is greater than 0 and less than 1, the dependency degree is equal to the ratio of the value obtained by multiplying M by the first weight value and adding T times the second weight value to N, and N is the number of key-value pairs appearing in the request content of the delete operation.

7. An electronic device, comprising: comprise: a processor; a memory having executable instructions of the processor stored therein; wherein the processor is configured to execute the executable instructions to perform the method for determining the primary key value of the service entity according to any one of claims 1 to 4.

8. A computer-readable storage medium having stored thereon a program, characterized in that, The program is executed by the processor to implement the method for determining the primary key value of the service entity according to any one of claims 1 to 4.

Images