Database form change notification method and device, computer equipment and storage medium

Abstract

The invention discloses a database form change notification method and apparatus, a computer device and a storage medium. The method comprises the steps of adding an event for uniformly receiving andforwarding a change notification and an attribute marked on a method of a functional interface on a service interface project of a database code; the code generator checks whether the method of each functional interface in the event processing program comprises the attribute or not; if the attribute is included, automatically adding a code for transmitting a change notification parameter behind the corresponding method; and when the database form is changed, executing the method, triggering a change notification, transmitting the change notification to the event, and forwarding the change notification by the event. According to the method and the device, perception of program codes on database data change is solved, and the perceived change is notified to other parts of the program to realize response to the change.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database form change notification method, device, computer equipment and storage medium. Background technique [0002] When a user enters a form on a terminal device (such as an application program, a handheld device, a web page, etc.) and requests to export the form according to the form, the back-end server device starts to execute the corresponding action. The user hopes to see the delivery status information of the form, such as the completed shipment of each item. In order to realize the function of querying the status, the terminal needs to re-display the information when necessary. Therefore, the terminal needs Know when you need to perform this redisplay action. Specifically, there are several methods to achieve the above functions: [0003] One method (i.e. scheme 1) is to re-refresh at regular intervals, that is, regardless of whether the current execution status ...

AI Technical Summary

Problems solved by technology

[0005] Regarding the above four schemes, although each scheme has a solution, in actual operation, each scheme has certain defects. Large, low density and slow information update

And because it is impossible to predict whether the data will change, the data consumption generated by refreshing may not necessarily produce actual value, thereby reducing work efficiency;

[0006] In solution 2, complex coding needs to be done on the database, and the reverse call needs to use the advanced functions of the database, which will have clear requirements on the version and function of the database, and when triggers and transactions are used at the same time, many problems will be generated data issues;

[0007] In solution 3, you can use a third-party functional class library (such as SqlDependencyEx released by dyatchenko on github) or a function provided by a database developer (such as Microsoft's SqlDependence), but this method is not stable because none of the above components can It is guaranteed to be valid all the time, and it cannot guarantee that all changes that users care about will be captured;

[0008] In solution 4, since the data changer and the terminal developer are usually not the same developer, there may be some differences in the definition and understanding of the data structure

Moreover, in most cases, the data changing party itself does not use this function, and there may be differences between the developer's understanding of the scene and the development and testing, and the situation of unfinished work

In addition, because the work of terminal developers is relatively lagging behind, and multiple data needs to be connected, it is easy to cause inconsistency of data interfaces and increase the difficulty of development

Images