Function table collection method and device, equipment and medium

Abstract

The invention relates to the technical field of data processing, and discloses a function table collection method and device, equipment and a medium, and the method comprises the steps: monitoring a preset target page in real time, and determining an access path according to an access action after the access action is detected on the preset target page; and confirming a target code according to the access path, and scanning the target code to extract a function table in the target code. The system migration cost can be reduced, and the function table arrangement efficiency can be improved.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a function table collection method, device, equipment and medium. Background Art

[0002] In the process of software development, if a project needs to be migrated, the tables used by the functions of each module in the system corresponding to the project need to be sorted out. Only after the sorting is completed can the project be migrated. Currently, the commonly used sorting method is manual sorting.

[0003] The inventors realize that when there are many modules, manually organizing the function table will consume a lot of manpower, which will not only increase the cost, but also be prone to errors and omissions, resulting in low efficiency. Summary of the invention

[0004] The present invention provides a function table collection method, device, computer equipment and medium to solve the technical problems of high cost and low efficiency caused by manual arrangement of function tables in the prior art.

[0005] In a first aspect, a function table collection method is provided, comprising:

[0006] Real-time monitoring of a preset target page, and when an access action is detected on the preset target page, confirming an access path according to the access action;

[0007] The target code is confirmed according to the access path, and the target code is scanned to extract a function table in the target code.

[0008] In a second aspect, a function table collection device is provided, comprising:

[0009] A monitoring module, used for real-time monitoring of a preset target page, and when an access action is detected on the preset target page, confirming an access path according to the access action;

[0010] The extraction module is used to confirm the target code according to the access path, and scan the target code to extract the function table in the target code.

[0011] In a third aspect, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the function table collection method when executing the computer program.

[0012] In a fourth aspect, a computer-readable storage medium is provided, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the above-mentioned function table collection method are implemented.

[0013] In the scheme implemented by the above-mentioned function table collection method, device, computer equipment and storage medium, the user's access actions can be monitored by real-time monitoring of the preset target page. When it is detected that the access action is triggered, the access path can be confirmed according to the access action, and then the target code can be confirmed according to the access path. Finally, the function table can be extracted from the target code. During the entire system migration process, the user does not need to manually organize the function table, which not only reduces the cost of migrating the system, but also improves the migration efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings required for use in the description of the embodiments of the present invention will be briefly introduced below. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without paying creative labor.

[0015] Figure 1 is a schematic diagram of an application environment of a function table collection method in an embodiment of the present invention;

[0016] Figure 2 is a flow chart of a function table collection method according to an embodiment of the present invention;

[0017] Figure 3 yes Figure 2 A schematic flow chart of a specific implementation of step S20;

[0018] Figure 4 yes Figure 3 A schematic flow chart of a specific implementation of step S21;

[0019] Figure 5 yes Figure 3 A schematic flow chart of a specific implementation of step S22

[0020] Figure 6 yes Figure 3 A schematic flow chart of a specific implementation of step S23

[0021] Figure 7 yes Figure 3 A schematic flow chart of a specific implementation of step S24

[0022] Figure 8 is a structural schematic diagram of a function table collection device in one embodiment of the present invention;

[0023] Fig. 9 is a schematic diagram of a structure of a computer device in one embodiment of the present invention;

[0024] Fig.10It is another structural schematic diagram of a computer device in one embodiment of the present invention. DETAILED DESCRIPTION

[0025] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0026] The function table collection method provided by the embodiment of the present invention can be applied in the following aspects: Figure 1 In an application environment, when a user accesses a system page, the user's access action can be detected, and the access path can be confirmed according to the access action. After the access path is confirmed, the target code is confirmed according to the access path, and then the function table is extracted according to the target code, thereby realizing automatic extraction of the function table. Among them, the computer device can be but not limited to various personal computers, laptops, smart phones, tablet computers and portable wearable devices. The present invention is described in detail below through specific embodiments.

[0027] See also Figure 2 As shown, Figure 2 A flowchart of a function table collection method provided by an embodiment of the present invention includes the following steps:

[0028] S10: monitoring a preset target page in real time, and when an access action is detected on the preset target page, confirming an access path according to the access action.

[0029] The function collection method provided by the present invention can be configured as a collection plug-in. When the system needs to be migrated, the collection plug-in is installed in the system. After the installation is completed, if the user needs to migrate the system, the project code path of the current system can be input into the collection plug-in. The collection plug-in obtains the project code path of the system and monitors the system page in real time.

[0030] The preset target page refers to a page that needs to be monitored in real time, which can be any system page. Preferably, all pages of the system can be monitored. When a user access action is detected, the access path corresponding to the access action is captured. For example, for a system page, it usually has multiple different function options. The user can jump to the corresponding function page by clicking any function option, and the single-click action can be regarded as an access action. It can be understood that in addition to a single-click action, the access action can also be a double-click action or access through a shortcut command. As long as the access action is detected to be triggered, the access path corresponding to the access action can be obtained.

[0031] S20: confirming the target code according to the access path, and scanning the target code to extract a function table in the target code.

[0032] After obtaining the access path, the target code corresponding to the access path can be confirmed according to the access path. It can be understood that different function pages correspond to different access paths, and different access paths correspond to different target codes. When the access path is confirmed, the target code is also confirmed. After confirming the target code, the target code can be scanned to confirm the function table in the target code, and the function table can be extracted.

[0033] For example, there is a management system, one of the functions of which is to input customer information, and the project system name of the management system is proj_client_manage. A new button is set in the system page of the management system. When it is detected that the new button is triggered, that is, the user triggers the new button through an access action, for example, clicking the new button, the access path of the new button can be obtained. If the access path is http: / / proj_client_manage.com.cn / apiUrl / um / client / add, the target code can be confirmed according to the access path. The target code is the project code of the management system, and the customer information table is extracted based on the target code.

[0034] Among them, Figure 3 As shown, in step S20, that is, scanning the target code to extract the function table in the target code, the following steps are included:

[0035] S21: Scan the target code to confirm a control layer entry, and confirm a control layer entry method matching the access path according to the control layer entry.

[0036] S22: confirming the business layer entry based on the control layer entry method, and confirming the business layer entry method according to the business layer entry.

[0037] S23: Scanning the persistence layer code in the target code based on the business layer entry method to confirm the persistence layer entry method.

[0038] S24: Extracting the function table in the target code based on the persistence layer entry method.

[0039] For steps S21-S24, the system project code may include a control layer, a business layer, and a persistence layer. The control layer may call the code of the business layer, and the business layer may call the code of the persistence layer. That is, the target code includes the control layer, the business layer, and the persistence layer. The control layer code is scanned and path matching is performed to confirm the control layer entry. After the control layer entry is confirmed, the control layer entry method is confirmed according to the control layer entry. The control layer code may include multiple code files. When confirming the control layer entry, each code file may be traversed to confirm whether there is a field in the code file that matches the access path. When a code file has a field that matches the access path, it indicates that the code file contains a control layer entry method.

[0040] After confirming the control layer entry method, decompose the control layer entry method to obtain multiple business layer entries. Scan the code of each business layer entry one by one to determine the business layer entry, and then confirm the business layer entry method. Specifically, the business layer file name is different from the current control layer file name, and the business layer file name will be declared as a private variable in the current control layer file. The type name of the variable is the same as the corresponding business layer file name, and the private variable will call the method in the business layer file.

[0041] After confirming the business layer entry method, scan the persistence layer code, confirm the persistence layer entry method in the persistence layer code, and finally extract the function table based on the persistence layer entry method.

[0042] Among them, Figure 4 As shown, in step S21, that is, scanning the target code to confirm the control layer entry, and confirming the control layer entry method matching the access path according to the control layer entry, includes the following steps:

[0043] S211: traverse the control layer code in the target code to obtain all code files in the control layer code;

[0044] S212: extracting one code file from all the code files and setting it as a target file;

[0045] S213: If there is a field in the target file that matches the access path, setting the field in the target file that matches the access path as the control layer entry method;

[0046] S214: If there is no field matching the access path in the target file, return to the step of extracting one code file from all the code files and setting it as the target file.

[0047] For steps S211-S214, the control layer code may include multiple code files, and each code file needs to be traversed to find the control layer entry method. When traversing, each code file may be traversed one by one in the order in which the files are arranged, or a code file may be randomly selected from all code files for confirmation until the control layer entry method is obtained or all code files are traversed. In addition, all code files may be sorted before traversing the code files, and the sorting may be from the front to the back or from the back to the front according to the first letter.

[0048] For example, there is a management system, one of the functions of which is to enter customer information, and the project system name of the management system is proj_client_manage. A new button is provided in the system page of the management system. When it is detected that the new button is triggered, that is, the user triggers the new button through an access action, for example, by clicking the new button, the access path of the new button can be obtained, and the access path is assumed to be http: / / proj_client_manage.com.cn / apiUrl / um / client / add. The control layer code of the management system is proj_client_manage, and the control layer has three code files, namely AController, BController, and CController. AController, BController, and CController are scanned respectively to confirm whether there are fields matching the access path http: / / proj_client_manage.com.cn / apiUrl / um / client / add in the above three code files. For example, if the first-level path of the AController code file is / fileTemplate, match fileTemplate with http: / / proj_client_manage.com.cn / apiUrl / um / client / add. Through matching, it can be found that there is no field matching / fileTemplate in the access path, then the BController code file can be scanned. If the path of the BController code file is / bill, match / bill with the access path. Through matching, it can be found that there is no field matching / bill in the access path, then the CController code file can be scanned.

[0049] If the first-level path of the CController code file is / client, match / client with the access path and confirm that the fields in the access path that match / client exist. Then continue to scan the CController code file to obtain the second-level path. If the second-level path contains / add and / update, that is, the second-level paths are / client / add and / client / update, match / client / add and / client / update with the access path and find that / client / add matches the access path. Then it can be confirmed that the control layer entry method is the add method.

[0050] Among them, Figure 5 As shown, in step S22, that is, confirming the business layer entry based on the control layer entry method, and confirming the business layer entry method according to the business layer entry, includes the following steps:

[0051] S221: Decomposing the control layer entry method to obtain multiple business layer entries;

[0052] S222: Traverse all the business layer entries to confirm the business layer entry method.

[0053] For steps S221-S222, after obtaining the control layer entry method, the control layer entry method is decomposed to obtain multiple business layer entries, and the codes of all business layer entries are scanned to confirm the business layer entry method. Specifically, the business layer entry method can be confirmed by the method: the business layer file name is different from the current control layer file name, and the business layer file name will be declared as a private variable in the current control layer file, and the type name of the variable is the same as the corresponding business layer file name. The private variable will call the method in the business layer file, and the method is the entry of the business layer, and then start to confirm the business layer entry and the business layer entry method.

[0054] For example, continuing with the example mentioned in steps S211-S214, if the control layer entry method is the add method, the business layer entry can be found in the add method in the CController code file of the control layer. By calling the business layer method through a variable and the type of the variable is the same as the business layer file name, it can be confirmed that the business layer entry method is insertClientInfo in the CService file.

[0055] Among them, Figure 6 As shown, in step S23, that is, scanning the persistence layer code in the target code based on the business layer entry method to confirm the persistence layer entry method includes the following steps:

[0056] S231: Obtain the business layer entry method name corresponding to the business layer entry method;

[0057] S232: confirming the persistence layer entry method name that is the same as the business layer entry method name in the persistence layer code, and confirming the persistence layer entry according to the persistence layer entry method name.

[0058] For steps S231-S232, after the business layer entry method name is confirmed, the persistence layer method name that is the same as the business layer entry method name is confirmed in the persistence layer code, and the persistence layer entry is confirmed according to the persistence layer method name.

[0059] For example, continuing with the example mentioned in steps S221-S222, the business layer entry method is insertClientInfo in the CService file, and insertClientInfo is the business layer entry method name. All codes in the persistence layer are traversed to confirm the method name that is the same as insertClientInfo. After confirmation, the file containing insertClientInfo is confirmed in the persistence layer to obtain the persistence layer entry. For example, if the file name containing insertClientInfo in the persistence layer is a CDao file, then the persistence layer entry is CDao, and the persistence layer entry method is insertClientInfo in the CDao file.

[0060] Among them, Figure 7 As shown, in step S24, extracting the function table in the target code based on the persistence layer entry method includes the following steps:

[0061] S241: confirming a script file matching the persistence layer entry method according to the persistence layer entry method;

[0062] S242: confirming a matching tag in the script file according to the persistence layer entry method name corresponding to the persistence layer entry method;

[0063] S243: Parse the script statement corresponding to the tag to extract the function table.

[0064] For steps S241-S243, after confirming the persistent layer entry method, confirm the matching script file according to the persistent layer entry method, and then confirm the tag matching the persistent layer entry method name in the script file. The script statement corresponding to the tag is the script used when the user performs the access action. Then parse the script statement corresponding to the tag to extract the function table. When extracting the function table, it can be located by keywords, such as from, where, update, set, join, into, etc. The function table is usually located after from and before where.

[0065] For example, continuing with the example mentioned in steps S231-S232, the persistence layer entry is CDao, and the persistence layer entry method is insertClientInfo in the CDao file. Then, the tag with the same name as insertClientInfo can be queried in the script file. The script statement corresponding to the tag contains the function table, and then the function table is extracted.

[0066] It can be seen that in the above scheme, the access path can be captured by real-time monitoring of the user's access actions, and after the access path is confirmed, the target code can be confirmed according to the access path, and then the function table can be automatically extracted from the target code, thereby improving the efficiency of system migration.

[0067] It should be understood that the order of execution of the steps in the above embodiment does not necessarily mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiment of the present invention.

[0068] In one embodiment, a function table collection device is provided, and the function table collection device corresponds one-to-one to the function table collection method in the above embodiment. Figure 8 As shown, the function table collection device includes a monitoring module 101 and an extraction module 102. Each function module is described in detail as follows:

[0069] A monitoring module, used for real-time monitoring of a preset target page, and when an access action is detected on the preset target page, confirming an access path according to the access action;

[0070] The extraction module is used to confirm the target code according to the access path, and scan the target code to extract the function table in the target code.

[0071] In one embodiment, the extraction module 102 is specifically configured to:

[0072] Scanning the target code to confirm a control layer entry, and confirming a control layer entry method matching the access path according to the control layer entry;

[0073] Confirming a business layer entry based on the control layer entry method, and confirming a business layer entry method according to the business layer entry;

[0074] Scanning the persistence layer code in the target code based on the business layer entry method to confirm the persistence layer entry method;

[0075] A function table in the target code is extracted based on the persistence layer entry method.

[0076] In one embodiment, the extraction module 102 is specifically configured to:

[0077] Traversing the control layer code in the target code to obtain all code files in the control layer code;

[0078] Extract one code file from all the code files and set it as a target file;

[0079] If there is a field in the target file that matches the access path, setting the field in the target file that matches the access path as the control layer entry method;

[0080] If there is no field matching the access path in the target file, the step of returning to the step of extracting one code file from all the code files and setting it as the target file is performed.

[0081] In one embodiment, the extraction module 102 is further configured to:

[0082] Decomposing the control layer entry method to obtain multiple business layer entry methods;

[0083] All the business layer entries are traversed to confirm the business layer entry method.

[0084] In one embodiment, the extraction module 102 is further configured to:

[0085] Get the business layer entry method name corresponding to the business layer entry method;

[0086] A persistence layer entry method name that is the same as the business layer entry method name is confirmed in the persistence layer code, and the persistence layer entry is confirmed according to the persistence layer entry method name.

[0087] In one embodiment, the extraction module 102 is further configured to:

[0088] Confirming a script file matching the persistence layer entry method according to the persistence layer entry method;

[0089] Confirming a matching tag in the script file according to the persistence layer entry method name corresponding to the persistence layer entry method;

[0090] The script statement corresponding to the tag is parsed to extract the function table.

[0091] The present invention provides a function table collection device, which can capture the access path by real-time monitoring of the user's access actions, and after confirming the access path, can confirm the target code according to the access path, and then automatically extract the function table from the target code, thereby improving the efficiency of system migration.

[0092] For the specific definition of the function table collection device, please refer to the definition of the function table collection method above, which will not be repeated here. Each module in the above function table collection device can be implemented in whole or in part by software, hardware and a combination thereof. Each of the above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.

[0093] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Fig. 9 As shown. The computer device includes a processor, a memory, a network interface and a database connected via a system bus. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile and / or volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external client via a network connection. When the computer program is executed by the processor, it implements the functions or steps of a function table collection method service side.

[0094] In one embodiment, a computer device is provided. The computer device may be a client, and its internal structure diagram may be as follows: Fig.10 As shown. The computer device includes a processor, a memory, a network interface, a display screen and an input device connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external server through a network connection. When the computer program is executed by the processor, it implements the functions or steps of the client side of a function table collection method

[0095] In one embodiment, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the following steps when executing the computer program:

[0096] Real-time monitoring of a preset target page, and when an access action is detected on the preset target page, confirming an access path according to the access action;

[0097] The target code is confirmed according to the access path, and the target code is scanned to extract a function table in the target code.

[0098] In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:

[0099] Real-time monitoring of a preset target page, and when an access action is detected on the preset target page, confirming an access path according to the access action;

[0100] The target code is confirmed according to the access path, and the target code is scanned to extract a function table in the target code.

[0101] It should be noted that the above functions or steps that can be implemented by the computer-readable storage medium or computer device can refer to the relevant descriptions on the server side and the client side in the aforementioned method embodiment. To avoid repetition, they will not be described one by one here.

[0102] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

[0103] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be distributed and completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above.

[0104] The embodiments described above are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention, and should all be included in the protection scope of the present invention.

Claims

1. A function table collection method, characterized in that: include: Real-time monitoring of a preset target page, and when an access action is detected on the preset target page, confirming an access path according to the access action; The target code is confirmed according to the access path, and the target code is scanned to extract a function table in the target code.

2. The method according to claim 1, characterized in that The scanning of the target code to extract the function table in the target code comprises: Scanning the target code to confirm a control layer entry, and confirming a control layer entry method matching the access path according to the control layer entry; Confirming a business layer entry based on the control layer entry method, and confirming a business layer entry method according to the business layer entry; Scanning the persistence layer code in the target code based on the business layer entry method to confirm the persistence layer entry method; A function table in the target code is extracted based on the persistence layer entry method.

3. The method according to claim 2, characterized in that The method of scanning the target code to confirm a control layer entry and confirming a control layer entry matching the access path according to the control layer entry includes: Traversing the control layer code in the target code to obtain all code files in the control layer code; Extract one code file from all the code files and set it as a target file; If there is a field in the target file that matches the access path, the field in the target file that matches the access path is set as the control layer entry method.

4. The method according to claim 3, characterized in that The method of scanning the target code to confirm the control layer entry, and confirming the control layer entry matching the access path according to the control layer entry, further includes: If there is no field matching the access path in the target file, the step of returning to the step of extracting one code file from all the code files and setting it as the target file is performed.

5. The method according to claim 2, characterized in that The confirming the business layer entry based on the control layer entry method, and confirming the business layer entry method according to the business layer entry, includes: Decomposing the control layer entry method to obtain multiple business layer entry methods; All the business layer entries are traversed to confirm the business layer entry method.

6. The method according to claim 2, characterized in that The step of scanning the persistence layer code in the target code based on the business layer entry method to confirm the persistence layer entry method includes: Get the business layer entry method name corresponding to the business layer entry method; A persistence layer entry method name that is the same as the business layer entry method name is confirmed in the persistence layer code, and the persistence layer entry is confirmed according to the persistence layer entry method name.

7. The method according to claim 2, characterized in that The extracting the function table in the target code based on the persistence layer entry method comprises: Confirming a script file matching the persistence layer entry method according to the persistence layer entry method; Confirming a matching tag in the script file according to the persistence layer entry method name corresponding to the persistence layer entry method; The script statement corresponding to the tag is parsed to extract the function table.

8. A function table collection device, characterized in that: include: A monitoring module, used for real-time monitoring of a preset target page, and when an access action is detected on the preset target page, confirming an access path according to the access action; The extraction module is used to confirm the target code according to the access path, and scan the target code to extract the function table in the target code.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the function table collection method according to any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the function table collection method according to any one of claims 1 to 7 are implemented.

Images