CN115328801A - Database access log generation method, device, storage medium and computer device - Google Patents

Abstract

The application provides a database access log generation method, a database access log generation device, a storage medium and computer equipment, which are used for acquiring instruction information returned by an instruction information acquisition function and a call stack corresponding to the instruction information acquisition function in the call process under the condition that an application to be tested calls the instruction information acquisition function. For the call stack, the method and the device can match function information of call functions at all levels in the call stack in sequence according to the direction from the stack top to the stack bottom so as to determine the interface name of a target interface for sending the database access instruction corresponding to the instruction information. And generating log information of the instruction information acquisition function in local call after obtaining the interface name and the instruction information, and writing the log information into a database access log of the application to be tested to obtain a complete database access log of the application to be tested in the execution process, so that the data problem can be checked based on the database access log to accelerate the checking efficiency.

Description

Database access log generation method, device, storage medium and computer equipment

technical field

The present application relates to the technical field of databases, in particular to a database access log generation method, device, storage medium and computer equipment.

Background technique

In order to reduce the amount of data stored locally, some data is generally stored in a database, and the application can read data from the database or write data to the database, so as to process or update data in the database according to the acquired data. During this process, both the reading of data and the writing of data may affect the execution of the application. Therefore, in order to ensure that the application can run normally after it is officially launched, it is necessary to test the application before going online. During the test, if there is a data problem in the execution of the application, you need to troubleshoot the cause of the data problem. However, considering that various factors may cause data problems, there is a problem of low efficiency in the current investigation.

Contents of the invention

The purpose of this application is to at least solve one of the above-mentioned technical defects, especially the technical defect of low troubleshooting efficiency in the prior art.

In the first aspect, the embodiment of the present application provides a method for generating a database access log, the method comprising:

Obtain the instruction information returned by the instruction information acquisition function and obtain the call stack corresponding to the instruction information acquisition function in this call when the application to be tested is monitored to call the instruction information acquisition function; the instruction The information acquisition function is used to acquire the instruction information of the database access instruction;

According to the direction from the top of the stack to the bottom of the stack, the function information of the call function at each level in the call stack is matched in turn to determine the interface name of the target interface; the target interface is to send a database corresponding to the instruction information Interface functions for accessing instructions;

Generate log information in this call of the instruction information acquisition function according to the instruction information and the interface name of the target interface, and write the log information into the database access log of the application to be tested.

In one of the embodiments, the step of sequentially matching the function information of the calling functions at all levels in the call stack in the direction from the top of the stack to the bottom of the stack to determine the interface name of the target interface includes:

According to the direction from the top of the stack to the bottom of the stack, the function information of the calling functions at all levels is used as the current function information to be matched, until the class name included in the current function information to be matched has a preset key field, and the Describe the current function information to be matched as the target function information;

The interface name of the target interface is determined according to the class name and function name included in the target function information.

In one of the embodiments, the step of generating the log information of the instruction information acquisition function in this call according to the instruction information and the interface name of the target interface includes:

Assembling the instruction information according to a preset database access instruction format to obtain a target database access instruction; the target database access instruction is a database access instruction corresponding to the instruction information;

Generate log information of the instruction information acquisition function in this call based on the target database access instruction and the interface name of the target interface, so that the log information includes the target database access instruction and the interface name.

In one of the embodiments, based on the target database access command and the interface name of the target interface, the log information of the instruction information acquisition function in this call is generated, so that the log information includes the target database access The steps of the instruction and the name of the interface include:

Extracting the operation label in the target database access instruction from the instruction information, and determining the read-write attribute of the target interface according to the operation label;

Generate log information of the command information acquisition function in this call based on the target database access command, the interface name of the target interface, and the read-write attribute of the target interface, so that the log information includes the target Database access instruction, the interface name and the read-write attribute.

In one of the embodiments, the step of determining the read-write attribute of the target interface according to the operation tag includes:

If the operation tag is a selection tag, then determine that the read-write attribute of the target interface is a read attribute;

If the operation tag is an insert tag, an update tag, or a delete tag, it is determined that the read-write attribute of the target interface is a write attribute.

In one of the embodiments, when it is detected that the application under test calls the instruction information acquisition function, the instruction information returned by the instruction information acquisition function is obtained, and the instruction information acquisition function is obtained in this call Before the steps of the corresponding call stack, it also includes:

A test function is inserted into the application under test by using a program insertion technology, so as to monitor whether the application under test calls the instruction information acquisition function through the test function.

In one of the embodiments, the step of inserting a test function into the application under test by using the program insertion technology includes:

Inserting the test function at a specified location of the application to be tested by using a program insertion technique, the specified location is a location where the test function and the instruction information acquisition function run in the same thread.

In the second aspect, the embodiment of the present application provides a database access log generating device, the device comprising:

The call information acquisition module is used to obtain the instruction information returned by the instruction information acquisition function and obtain the instruction information corresponding to the instruction information acquisition function in this call when the application to be tested is monitored to call the instruction information acquisition function. the call stack; the instruction information obtaining function is used to obtain the instruction information of the database access instruction;

The interface name acquisition module is used to match the function information of the call functions at all levels in the call stack in turn according to the direction from the top of the stack to the bottom of the stack, so as to determine the interface name of the target interface; The interface function of the database access command corresponding to the above command information;

A log generating module, configured to generate log information of the instruction information acquisition function in this call according to the instruction information and the interface name of the target interface, and write the log information into the database of the application to be tested in the access log.

In a third aspect, the embodiment of the present application provides a storage medium, the storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by one or more processors, one or more processors Execute the steps of the database access log generation method described in any of the above embodiments.

In a fourth aspect, the embodiment of the present application provides a computer device, including: one or more processors, and a memory;

Computer-readable instructions are stored in the memory, and when the computer-readable instructions are executed by the one or more processors, the steps of the method for generating a database access log in any of the above embodiments are executed.

In the database access log generation method, device, storage medium, and computer equipment of the present application, the instruction information acquisition function can be monitored, and when the application to be tested is detected to call the instruction information acquisition function, the information returned by the instruction information acquisition function can be obtained. The instruction information and the instruction information obtains the corresponding call stack of the function during this call. For the call stack, the application can sequentially match the function information of the call functions at all levels in the call stack in the direction from the top of the stack to the bottom of the stack, so as to determine the target interface for sending the database access instruction corresponding to the instruction information Interface name. After obtaining the interface name and instruction information, generating instruction information, obtaining the log information in the local call of the function, and writing the log information into the database access log of the application to be tested, so as to obtain a complete database of the application to be tested during execution Access logs, so that you can troubleshoot data problems based on the database access logs to speed up troubleshooting.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present application. Those skilled in the art can also obtain other drawings based on these drawings without any creative effort.

Fig. 1 is a schematic flow diagram of a method for generating a database access log in an embodiment;

Fig. 2 is a schematic structural diagram of a database access log generation device in an embodiment;

Fig. 3 is a schematic structural diagram of a computer device in an embodiment.

Detailed ways

The technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only some of the embodiments of the present application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

In one embodiment, the present application provides a method for generating a database access log. The following embodiments are described by taking the method applied to a server as an example. It can be understood that the server executing the database access log generation method may be a single server or a server cluster composed of multiple servers, which is not specifically limited in this application. As shown in Figure 1, the method specifically includes the following steps:

S102. Obtain the instruction information returned by the instruction information acquisition function, and acquire the call stack corresponding to the instruction information acquisition function in this call, when it is detected that the application to be tested calls the instruction information acquisition function; The instruction information obtaining function described above is used to obtain the instruction information of the database access instruction.

Wherein, the application to be tested can obtain the instruction information of the database access instruction by calling the instruction information acquisition function, the instruction information includes but not limited to the operation label, operation object and operation condition of the database access instruction. In one of the embodiments, the command information acquisition function can be the getBoundSql() function of the MappedStatement class. In other words, the server can monitor whether the application under test calls the getBoundSql() function, and when it detects that the application under test calls the method, Get the instruction information returned by the getBoundSql() function and the call stack corresponding to the getBoundSql() function in the local call.

The call stack records the function information corresponding to the call function at each level in the current call process of the instruction information acquisition function, such as the function name of the call function at each level, the class name corresponding to the call function at each level, and so on. In one embodiment, the server may call the Thread.currentThread().getStackTrace() method to obtain instruction information and obtain the call stack of the function during this call.

S104, according to the direction from the top of the stack to the bottom of the stack, sequentially match the function information of the call function at each level in the call stack to determine the interface name of the target interface; The interface function of the database access instruction.

Wherein, the stack top of the call stack records the function information corresponding to the call function executed first, and the stack bottom of the call stack records the function information corresponding to the call function executed latest. For example, in this calling process of the instruction information acquisition function, the application under test calls function A first, then calls function B in function A, and then calls the instruction information acquisition function in function B, then the function information corresponding to function A It is located at the top of the call stack, and the function information corresponding to function B is located at the bottom of the call stack.

The server can analyze the source interface for calling the instruction information acquisition function according to the call stack. Specifically, the server can sequentially match the function information corresponding to the call functions at all levels in the call stack in the direction from the top of the stack to the bottom of the stack, and obtain the corresponding function information of the target interface according to the first function information that meets the preset matching rules. interface name. For example, in the above example, the server can first match the function information corresponding to function A to determine whether the function information corresponding to function A satisfies the preset matching rules, and if so, determine the target according to the function information corresponding to function A The interface name of the interface, if not, match the function information corresponding to function B to determine whether it satisfies the preset matching rules, and so on.

The present application sequentially matches the function information of calling functions at various levels in the call stack in the direction from the top of the stack to the bottom of the stack, thereby improving the efficiency of obtaining interface names and further improving the testing efficiency.

S106. Generate log information in this call of the instruction information acquisition function according to the instruction information and the interface name of the target interface, and write the log information into the database access log of the application to be tested.

After obtaining the instruction information and the interface name of the target interface, the server can generate corresponding log information according to the instruction information and the interface name of the target interface, and the log information records the instruction information and the interface name of the target interface. In one of the embodiments, the log information may also record the call time of the instruction information acquisition function or the database access time.

After obtaining the log information, the server may write the log information into the database access log of the application to be tested.

In this application, the instruction information acquisition function can be monitored, and when the application to be tested is monitored to call the instruction information acquisition function, the instruction information returned by the instruction information acquisition function and the instruction information acquisition function during this call The corresponding call stack. For the call stack, the application can sequentially match the function information of the call functions at all levels in the call stack in the direction from the top of the stack to the bottom of the stack, so as to determine the target interface for sending the database access instruction corresponding to the instruction information Interface name. After obtaining the interface name and instruction information, generating instruction information, obtaining the log information in the local call of the function, and writing the log information into the database access log of the application to be tested, so as to obtain a complete database of the application to be tested during execution Access logs, so that you can troubleshoot data problems based on the database access logs to speed up troubleshooting.

In one embodiment, the step of sequentially matching the function information of the calling functions at various levels in the call stack from the top of the stack to the bottom of the stack to determine the interface name of the target interface includes:

According to the direction from the top of the stack to the bottom of the stack, the function information of the calling functions at all levels is used as the current function information to be matched, until the class name included in the current function information to be matched has a preset key field, and the Describe the current function information to be matched as the target function information;

The interface name of the target interface is determined according to the class name and function name included in the target function information.

Specifically, the server can sequentially use the function information of the calling functions at all levels as the current function information to be matched according to the direction from the top of the stack to the bottom of the stack, and judge whether there is a preset keyword in the class name of the current function information to be matched segment, if it exists, use the current function information to be matched as the target function information, if it does not exist, use the function information of the next-level call function as the current function information to be matched, and judge whether the class name of the current function information to be matched is There are preset key fields, and the preceding steps are followed until the objective function information is determined. It can be understood that the preset key fields may be determined according to actual conditions. In one embodiment, the preset key fields include "Service" and "Help". In other words, the server can use the function information whose first class name includes both Service and Help in the direction from the top of the stack to the bottom of the stack as Objective function information.

After obtaining the target function information, the application can determine the interface name of the target interface according to the class name and function name in the target function information. In one embodiment, the interface name of the target interface may include the class name and function name in the target function information.

In the embodiment of the present application, by following the direction from the top of the stack to the bottom of the stack, the function information of the first class name in the call stack including the preset key field is used as the target function information, and the interface of the target interface is determined according to the target function information Name, so that the interface name of the target interface can be obtained quickly and accurately, which can improve the test efficiency and the accuracy of log information.

In one embodiment, the step of generating the log information of the instruction information acquisition function in this call according to the instruction information and the interface name of the target interface includes:

Assembling the instruction information according to a preset database access instruction format to obtain a target database access instruction; the target database access instruction is a database access instruction corresponding to the instruction information;

Generate log information of the instruction information acquisition function in this call based on the target database access instruction and the interface name of the target interface, so that the log information includes the target database access instruction and the interface name.

Specifically, in the process of generating log information based on the command information and the interface name of the target interface, since the command information returned by the command information acquisition function is the description object of the parsed target database access command, the server can The command information returned by the acquisition function is assembled to obtain the target database access command, and the log information corresponding to the command information acquisition function in this calling process is generated accordingly, so that the log information can record the target database access command and the interface name of the target interface at the same time . In this way, a more complete database access log can be obtained, so that data problems can be checked based on the database access log, so as to further speed up the checking efficiency.

In one embodiment, based on the target database access command and the interface name of the target interface, the log information of the instruction information acquisition function in this call is generated, so that the log information includes the target database access command and the steps of the interface name, including:

Extracting the operation label in the target database access instruction from the instruction information, and determining the read-write attribute of the target interface according to the operation label;

Generate log information of the command information acquisition function in this call based on the target database access command, the interface name of the target interface, and the read-write attribute of the target interface, so that the log information includes the target Database access instruction, the interface name and the read-write attribute.

Specifically, the server can extract the operation label of the target database access instruction from the instruction information returned by the instruction information acquisition function. The operation label can be the selection label "select", the insertion label "insert", the update label "update" or delete Label "delete". After obtaining the operation label of the target database access instruction, the server can determine the read and write operation attributes of the target database access instruction according to the operation label, and the read and write operation attributes are the read and write attributes of the target interface.

After obtaining the target database access command, the interface name of the target interface, and the read/write attributes of the target interface, the server can generate command information according to the aforementioned information to obtain the log information of the function during this call, and the log information includes all the aforementioned information. The server can write the generated log information into the database access log of the application to be tested.

In this embodiment, the read-write attribute of the target interface is determined according to the operation label of the target database access command, and the read-write attribute is written into the database access log, so that the production traffic can be played back according to the read-write attribute of the target interface to further Reduce labor maintenance costs.

In one embodiment, the step of determining the read-write attribute of the target interface according to the operation tag includes:

If the operation tag is a selection tag, then determine that the read-write attribute of the target interface is a read attribute;

If the operation tag is an insert tag, an update tag, or a delete tag, it is determined that the read-write attribute of the target interface is a write attribute.

Specifically, if the extracted operation label is a selection label, it can be determined that the target database access instruction is only used to obtain data in the target database, and does not involve adding or deleting data in the target database, that is, does not involve write operations, so The read-write attribute of the target interface may be determined as a read attribute. When the extracted operation label is insert label, update label or delete label, it can be determined that the execution of the target database access command will add, delete or modify the data in the target database, that is, the target database access command involves in the execution process Database write operation, so it can be determined that the read-write attribute of the target interface is the write attribute.

In the embodiment of the present application, by extracting the operation label of the target database access instruction from the instruction information, the read-write attribute of the target interface can be quickly determined according to the operation label.

In one embodiment, when it is detected that the application to be tested calls the instruction information acquisition function, the instruction information returned by the instruction information acquisition function is obtained, and the instruction information obtained by the instruction information acquisition function in this call is obtained. Before the steps of the corresponding call stack, it also includes:

A test function is inserted into the application under test by using a program insertion technology, so as to monitor whether the application under test calls the instruction information acquisition function through the test function.

It can be understood that the application can use any type of program insertion technology to implement the insertion of test functions. In one embodiment, the program insertion technology can be JVM-Sandbox (Java Virtual Machine Sandbox) technology.

In one of the embodiments, the test function can be used to monitor whether the application to be tested calls the instruction information acquisition function, and execute the steps of the database access log generation method described in any of the above embodiments. In order to ensure that the test function can accurately obtain the call stack of the instruction information acquisition function in this call process when it detects that the application to be tested calls the instruction information acquisition function, this application can use the program instrumentation technology in the specified application to be tested. The test function is inserted at a position where the test function and the instruction information acquisition function run in the same thread.

The database access log generation device provided by the embodiment of the present application is described below, and the database access log generation device described below and the database access log generation method described above can be referred to in correspondence.

In one embodiment, the present application provides an apparatus 200 for generating a database access log. As shown in FIG. 2 , the device 200 specifically includes a call information acquisition module 210, an interface name acquisition module 220, and a log generation module 230, wherein:

The call information acquisition module 210 is configured to acquire the instruction information returned by the instruction information acquisition function when the application to be tested is detected to call the instruction information acquisition function, and to acquire the instruction information obtained by the instruction information acquisition function in this call. Corresponding call stack; the instruction information obtaining function is used to obtain the instruction information of the database access instruction;

The interface name acquisition module 220 is used to match the function information of the calling functions at all levels in the call stack in turn according to the direction from the top of the stack to the bottom of the stack, so as to determine the interface name of the target interface; The interface function of the database access instruction corresponding to the instruction information;

The log generating module 230 is configured to generate the log information of the instruction information acquisition function in this call according to the instruction information and the interface name of the target interface, and write the log information into the application to be tested in the database access log.

In one embodiment, the interface name acquisition module 220 includes an objective function information acquisition unit and an interface name determination unit. Wherein, the target function information acquisition unit is used to sequentially use the function information of the calling functions at all levels as the current function information to be matched according to the direction from the top of the stack to the bottom of the stack, until the class name included in the current function information to be matched has a predetermined Set the key field, and use the current function information to be matched as the target function information. The interface name determination unit is configured to determine the interface name of the target interface according to the class name and function name included in the target function information.

In one embodiment, the log generation module 230 includes a target instruction acquisition unit and a first log information generation unit. Wherein, the target instruction acquisition unit is configured to assemble the instruction information according to a preset database access instruction format to obtain a target database access instruction; the target database access instruction is a database access instruction corresponding to the instruction information. The first log information generation unit is configured to generate the log information of the instruction information acquisition function in this call based on the target database access instruction and the interface name of the target interface, so that the log information includes the target database Access instructions and the name of the interface.

In one embodiment, the first log information generation unit includes a read/write attribute acquisition unit and a second log information generation unit. Wherein, the read-write attribute acquisition unit is configured to extract the operation label in the target database access instruction from the instruction information, and determine the read-write attribute of the target interface according to the operation label. The second log information generation unit is configured to generate the log information of the instruction information acquisition function in this call based on the target database access instruction, the interface name of the target interface, and the read-write attribute of the target interface, so that The log information includes the target database access command, the interface name and the read-write attribute.

In one embodiment, the read-write attribute acquisition unit includes a read-attribute determination unit and a write-attribute determination unit. Wherein, the read attribute determining unit is configured to determine that the read/write attribute of the target interface is a read attribute if the operation tag is a selection tag. The write attribute determining unit is configured to determine that the read-write attribute of the target interface is a write attribute if the operation tag is an insert tag, an update tag or a delete tag.

In one embodiment, the apparatus 200 further includes a function insertion module, which is used to insert a test function into the application under test by using the program insertion technology, so as to listen to the application under test through the test function Whether to call the command information acquisition function.

In one embodiment, the function insertion module includes a first insertion unit, and the first insertion unit is used to insert the test function at a designated position of the application to be tested by using a program insertion technology, and the designated position is such that The position where the test function and the instruction information acquisition function run in the same thread.

In one embodiment, the present application also provides a storage medium, in which computer-readable instructions are stored, and when the computer-readable instructions are executed by one or more processors, one or more processing The server executes the steps of the database access log generation method described in any one of the above-mentioned embodiments.

In an embodiment, the present application also provides a computer device. Computer-readable instructions are stored in the computer device, and when the computer-readable instructions are executed by one or more processors, one or more processors are executed to generate database access logs as described in any one of the above-mentioned embodiments. method steps.

Schematically, FIG. 3 is a schematic diagram of an internal structure of a computer device provided in an embodiment of the present application. In an example, the computer device may be a server. Referring to FIG. 3 , computer device 900 includes processing component 902 , which further includes one or more processors, and a memory resource represented by memory 901 for storing instructions executable by processing component 902 , such as application programs. The application program stored in memory 901 may include one or more modules each corresponding to a set of instructions. In addition, the processing component 902 is configured to execute instructions to execute the steps of the database access log generation method described in any of the above embodiments.

The computer device 900 may also include a power supply component 903 configured to perform power management of the computer device 900, a wired or wireless network interface 904 configured to connect the computer device 900 to a network, and an input output (I/O) interface 905 . The computer device 900 can operate based on an operating system stored in the memory 901, such as Windows Server™, Mac OS X™, Unix™, Linux™, Free BSD™ or the like.

Those skilled in the art can understand that the internal structure of the computer equipment shown in this application is only a block diagram of a part of the structure related to the solution of this application, and does not constitute a limitation on the computer equipment on which the solution of this application is applied. The computer device may include more or fewer components than shown in the figures, or combine certain components, or have a different arrangement of components.

Finally, it should also be noted that in this text, relational terms such as first and second etc. are only used to distinguish one entity or operation from another, and do not necessarily require or imply that these entities or operations, any such actual relationship or order exists. Furthermore, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus comprising a set of elements includes not only those elements, but also includes elements not expressly listed. other elements of or also include elements inherent in such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article or apparatus comprising said element. As used herein, "a", "an", "the", "the" and "it" may also include plural forms unless the context clearly dictates otherwise. A plurality refers to at least two situations, such as 2, 3, 5 or 8 and so on. "And/or" includes any and all combinations of the associated listed items.

Each embodiment in this specification is described in a progressive manner. Each embodiment focuses on the difference from other embodiments. The various embodiments can be combined as needed, and the same and similar parts can be referred to each other. .

The above description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the application. Therefore, the present application will not be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (10)

1. A method of generating a database access log, the method comprising:

under the condition that the application to be tested calls the instruction information acquisition function, acquiring instruction information returned by the instruction information acquisition function and acquiring a call stack corresponding to the instruction information acquisition function in the call; the instruction information acquisition function is used for acquiring instruction information of a database access instruction;

sequentially matching function information of calling functions at all levels in the calling stack according to the direction from the top of the stack to the bottom of the stack to determine the interface name of a target interface; the target interface is an interface function for sending a database access instruction corresponding to the instruction information;

and generating log information of the instruction information acquisition function in the current call according to the instruction information and the interface name of the target interface, and writing the log information into a database access log of the application to be tested.

2. The method according to claim 1, wherein the step of sequentially matching function information of call functions at each level in the call stack in a direction from the stack top to the stack bottom to determine an interface name of the target interface comprises:

according to the direction from the stack top to the stack bottom, sequentially taking function information of calling functions at all levels as current function information to be matched until a preset key field exists in a class name included in the current function information to be matched, and taking the current function information to be matched as target function information;

and determining the interface name of the target interface according to the class name and the function name included in the target function information.

3. The method according to claim 1, wherein the step of generating log information of the instruction information obtaining function in the current call according to the instruction information and the interface name of the target interface includes:

assembling the instruction information according to a preset database access instruction format to obtain a target database access instruction; the target database access instruction is a database access instruction corresponding to the instruction information;

and generating log information of the instruction information acquisition function in the current call based on the target database access instruction and the interface name of the target interface, so that the log information comprises the target database access instruction and the interface name.

4. The method according to claim 3, wherein the step of generating log information of the instruction information obtaining function in the current call based on the target database access instruction and the interface name of the target interface so that the log information includes the target database access instruction and the interface name includes:

extracting an operation label in the target database access instruction from the instruction information, and determining the read-write attribute of the target interface according to the operation label;

and generating log information of the instruction information acquisition function in the current call based on the target database access instruction, the interface name of the target interface and the read-write attribute of the target interface, so that the log information comprises the target database access instruction, the interface name and the read-write attribute.

5. The method according to claim 4, wherein the step of determining the read-write attribute of the target interface according to the operation tag comprises:

if the operation tag is a selection tag, determining the read-write attribute of the target interface as a read attribute;

and if the operation tag is an insertion tag, an update tag or a deletion tag, determining the read-write attribute of the target interface as a write attribute.

6. The method according to any one of claims 1 to 5, wherein before the steps of obtaining the instruction information returned by the instruction information obtaining function and obtaining the call stack corresponding to the instruction information obtaining function in the current call, in the case that it is monitored that the application to be tested calls the instruction information obtaining function, the method further comprises:

and inserting a test function into the application to be tested by utilizing a program instrumentation technology so as to monitor whether the application to be tested calls the instruction information acquisition function or not through the test function.

7. The method of claim 6, wherein the step of using program instrumentation techniques to insert test functions into the application under test comprises:

and inserting the test function at a specified position of the application to be tested by utilizing a program instrumentation technology, wherein the specified position is a position at which the test function and the instruction information acquisition function run in the same thread.

8. An apparatus for generating a database access log, the apparatus comprising:

the call information acquisition module is used for acquiring the instruction information returned by the instruction information acquisition function and acquiring a call stack corresponding to the instruction information acquisition function in the call under the condition that the application to be tested calls the instruction information acquisition function; the instruction information acquisition function is used for acquiring instruction information of a database access instruction;

the interface name acquisition module is used for sequentially matching function information of calling functions at all levels in the call stack according to the direction from the stack top to the stack bottom so as to determine the interface name of the target interface; the target interface is an interface function for sending a database access instruction corresponding to the instruction information;

and the log generation module is used for generating the log information of the instruction information acquisition function in the calling according to the instruction information and the interface name of the target interface, and writing the log information into the database access log of the application to be tested.

9. A storage medium having stored therein computer-readable instructions, which, when executed by one or more processors, cause the one or more processors to perform the steps of the database access log generation method of any of claims 1 to 7.

10. A computer device, comprising: one or more processors, and a memory;

the memory has stored therein computer readable instructions which, when executed by the one or more processors, perform the steps of the database access log generation method of any of claims 1 to 7.

Images