CN112653745B

CN112653745B - Configurable message pushing method and device

Info

Publication number: CN112653745B
Application number: CN202011488376.3A
Authority: CN
Inventors: 谢福成
Original assignee: China Construction Bank Corp
Current assignee: China Construction Bank Corp
Priority date: 2020-12-16
Filing date: 2020-12-16
Publication date: 2022-08-09
Anticipated expiration: 2040-12-16
Also published as: CN112653745A

Abstract

The invention discloses a configurable message pushing method and a configurable message pushing device, and relates to the technical field of computers. One embodiment of the method comprises: in the configuration table, configuring data processing rules according to data requirements and configuring message template rules according to business requirements; processing the data to be pushed into message data written into a message table according to the data processing rule and the message template rule in the configuration table; and through scanning the configuration table and the message table, formatting and packaging the message data so as to push the message data to a corresponding data transmission interface. The invention also discloses a configurable message pushing device.

Description

Configurable message pushing method and device

Technical Field

The invention relates to the technical field of computers, in particular to a configurable message pushing method and a configurable message pushing device.

Background

In the development and deployment process of message data pushing in the past, special data processing scripts, message assembly scripts and pushing programs need to be written manually, so that time and labor are wasted, the messages cannot be reused, and problems are easy to occur in the online process. In the traditional message data pushing development process, scripts and configuration are not separated, any requirement such as data requirements, message formats or transmission requirements and the like changes, a program needs to be modified and manually deployed, a large amount of repeated work is generated, and implementation efficiency is reduced.

The conventional message data push scheme includes: compiling a data extraction script according to a specific database and business requirements, executing the script to acquire data, packaging the data into messages, and pushing the messages to a specified channel end; each message pushing requirement needs to be repeatedly developed according to the mode, and when the data requirement or the message format requirement is changed, the data extraction script needs to be modified again or the format of the message package needs to be adjusted, and the deployment work is carried out again.

In the existing scheme, data extraction scripts and message encapsulation processing are manual development operations, so that the workload is high, the development time is long, the multiplexing cannot be realized, and the efficiency is low. When the requirement is changed, more files are needed to be modified, the modification test needs to be carried out for a long time, and the related configuration needs to be optimized. Therefore, the existing scheme has the problems of large workload, low efficiency and the like.

Some terms associated with the present invention are listed below:

NFT: network File transfer (Network File Transport) is a process of receiving or sending a File or data over a local or global Network (e.g., the Internet) using the local Transport protocol of the Network.

Disclosure of Invention

In view of this, embodiments of the present invention provide a configurable message pushing method and a configurable message pushing apparatus. The method aims at a relatively common message data pushing scene, separates configuration and processing, separates data and a template, and can realize automatic batch running of data, automatic generation of a pushed file and automatic pushing of the generated pushed file to a WeChat enterprise number of a pushed object according to the specified pushing frequency by configuring a data processing rule and a message template rule and specifying the pushing frequency, the pushing time, the pushing object and the like by a user. The invention relates to a universal configurable automatic message pushing scheme, which can automatically complete the pushing work of message data by utilizing configuration information and a fixed script, a technician can save the workload of manually compiling a data extraction script and a message encapsulation script after configuration, and a rule configuration library and a message library are scanned in real time to encapsulate the message data, thereby realizing the real-time automatic pushing of the message, simplifying the online work, reducing the possibility of generating problems, improving the work quality, having certain universality and being suitable for the pushing and processing process of most message data.

To achieve the above object, according to an aspect of the embodiments of the present invention, there is provided a configurable message pushing method, including:

in the configuration table, configuring data processing rules according to data requirements and configuring message template rules according to business requirements;

processing the data to be pushed into message data written into a message table according to the data processing rule and the message template rule in the configuration table; and is

And formatting and packaging the message data by scanning the configuration table and the message table so as to push the message data to a corresponding data transmission interface.

Optionally, the data processing rule includes a data access ID, a data processing frequency, a data query sql, and the like, and the message template rule includes a message content template, a dynamic parameter value, and the like.

Optionally, the data processing rule is specifically a valid identifier, a processing frequency, a data access identifier, a dependent database table name, a data query SQL, an aggregation field, a receiver field, a system processing time, and a latest data date.

Optionally, the message template rule is specifically a message title, a function description, a message type, a function description, a dynamic parameter value, and a message content template.

Optionally, processing the data to be pushed into the message data written into the message table according to the data processing rule and the message template rule in the configuration table, including:

and processing the data to be pushed into the message data written into the message table manually or automatically according to the data processing rule and the message template rule in the configuration table.

Optionally, automatically processing the data to be pushed into the message data written in the message table according to the data processing rule and the message template rule in the configuration table, including:

reading data query SQL in the configuration table by a timing script, judging whether to execute data processing according to processing frequency and data latest time, if the current time exceeds the latest data time in the configuration table, executing the data processing, and writing message data into the message table; and if not, not executing the data processing.

Optionally, scanning the configuration table and the message table to format and package the message data, including:

and formatting and packaging the message data in a dat file format by scanning the configuration table and the message table.

Optionally, the data transmission interface includes a data transmission interface compliant with NFT, EDA, SMTP protocols.

According to a second aspect of the embodiments of the present invention, there is provided a configurable message pushing apparatus, including:

the configuration module is used for configuring the data processing rule according to the data requirement and configuring the message template rule according to the service requirement in the configuration table;

the processing module is used for processing the data to be pushed into message data written into the message table according to the data processing rule and the message template rule in the configuration table; and is

And the pushing module is used for formatting and packaging the message data by scanning the configuration table and the message table so as to push the message data to a corresponding data transmission interface.

According to a third aspect of the embodiments of the present invention, there is provided an electronic device for implementing configurable message pushing, including:

one or more processors;

a storage device for storing one or more programs,

when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the method provided by the first aspect of the embodiments of the present invention.

According to a fourth aspect of embodiments of the present invention, there is provided a computer readable medium, on which a computer program is stored, which when executed by a processor, implements the method provided by the first aspect of embodiments of the present invention.

One embodiment of the above invention has the following advantages or benefits: the data configuration and processing are separated, so that the maintenance and the use are convenient, and the online cost of data change is reduced; the separation of the message data and the template reduces the coupling of the message processing module and improves the message processing efficiency; the automation and the real-time of the message data processing not only reduce the risks of data change and version errors, but also meet the real-time requirements of business on the data processing.

Further effects of the above-mentioned non-conventional alternatives will be described below in connection with specific embodiments.

Drawings

The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:

fig. 1 is a schematic diagram of a main flow of a configurable message pushing method according to an embodiment of the present invention;

FIG. 2 is a schematic diagram of a configurable message push process according to an embodiment of the invention;

FIG. 3 is a schematic diagram of the main modules of a configurable message pushing device according to an embodiment of the present invention;

FIG. 4 is an architectural diagram of an exemplary device in which embodiments of the present invention may be used;

fig. 5 is a schematic structural diagram of a computer apparatus of a terminal device or a server suitable for implementing an embodiment of the present invention.

Detailed Description

Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, in which various details of embodiments of the invention are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

The invention designs a configurable message pushing method and a configurable message pushing device, wherein core logic is the separation of configuration and processing, the separation of data and a template, a timing script execution task and a message processing program are solidified, and only relevant configuration or the template needs to be modified when the configurable message pushing device is used.

Configuring data processing rules on an interface according to data requirements, wherein the data processing rules comprise data access IDs, data processing frequency, data query sql and the like; configuring message template rules according to business requirements, wherein the message template rules comprise a message content template, dynamic parameter values and the like; reading data query SQL of a configuration library by a timing script, judging whether to execute or not according to the processing frequency and the latest data time, submitting the data to a data source for execution if the current time exceeds the latest data time in a configuration table, and inserting a message data result into a message table; if not, not executing; the message processing program reads the message content in the message table in quasi-real time and matches the message content with the message template of the configuration table to generate an actual html, a message log is formed according to the message content, the actual html and corresponding user information are packaged into a dat file, the dat file is transmitted to a corresponding channel through a corresponding transmission protocol, for example, the dat file is transmitted to a WeChat public number service terminal through NFT, and meanwhile, the generated file path is stored in a message notification file table. And displaying the corresponding channel according to the received dat file, for example, displaying the channel on a wechat public number according to the received dat file by the wechat terminal.

According to an aspect of an embodiment of the present invention, a configurable message pushing method is provided. Fig. 1 is a schematic diagram of a main flow of a configurable message pushing method according to an embodiment of the present invention, and as shown in fig. 1, the configurable message pushing method according to an embodiment of the present invention includes: step S101, step S102, and step S103.

In step S101, in the configuration table, the data processing rule is configured according to the data requirement and the message template rule is configured according to the service requirement. The method and the device provide separation of configuration and processing, and when the service or data requirement is changed, only relevant configuration parameters need to be modified, and the timed execution script does not need to be modified.

In step S102, the data to be pushed is processed into the message data written into the message table according to the data processing rule and the message template rule in the configuration table. Through the timing access script and the real-time message processing program, the message data can be automatically accessed at regular time and subjected to real-time data push processing after relevant configuration, so that the automation and the real-time performance of the whole function processing are ensured.

In step S103, the message data is formatted and encapsulated by scanning the configuration table and the message table, so as to be pushed to the corresponding data transmission interface. And separating the data from the template, wherein the data of the message is acquired from the data source base through the timing execution script, the template is used as a packaging form of the message display format, the change of the data and the template is not influenced mutually, and the data and the template are associated with each other only when the final data is packaged into the message in the specified format.

Fig. 2 is a schematic diagram of a configurable message pushing process according to an embodiment of the present invention, in which three control logic parts, which are rule configuration, message data processing and message pushing, are mainly shown. As shown, data processing rules and message template rules are configured at the interface, and the configured data template rules may also be queried. Thereafter, the timing script reads the data processing rule of the configuration library, accords with the processing condition, submits to the data source for execution, and writes the data result back to the message data table. And then, scanning the configuration library and the message library in real time through a message processing program, and matching the message content with the template to generate the actual html. And finally, formatting and packaging the message content, and calling a corresponding data transmission interface according to the configuration of the configuration library to push the message.

Therefore, two configuration tables, i.e., a data processing rule configuration table for the data processing rule and a message template rule configuration table for the message template rule, need to be maintained in the database. The data processing rule configuration table comprises the following main fields:

and (4) effective identification: whether the message template is valid, 1: effective, 0: invalid; if the data processing fails, the data processing module is automatically modified to be invalid.

Processing frequency: the frequency used to define the period of the message batch is divided into "real time _10 minutes", "non-real time _30 minutes", "non-real time _6 hours", "non-real time _24 hours", e.g., real time _10 minutes, which represents that the job is called up every 10 minutes (relative to the last job execution end time). The data table with data updated for multiple times in one day should be configured as a real-time job. The data table updated once a day or once more than one day should be configured as a non-real-time job.

Data access identification: database access control ID (not SCHEMA), a connection string used to connect to the database, where details of the connection database are configured, and the query SQL statement will run in the access control ID defined by the connection.

Dependent database table names: the input format is schema, table name, dependent time/date field, which is used to implement execution according to frequency, and needs to set dependent judgment condition, then the acquired time/date is compared with the latest data time, and when the condition greater than the acquired time/date is satisfied, the subsequent SQL script is executed; data that does not satisfy the dependency table is not updated and the skip execution is indicated in the log. For example, the dependency list is:

ngb440view.F_IA_CST_BIGAMT_FNDS_FLDCT_DTL:TXN_LCL_TM；

the system executes the select statement and then takes the minimum time/date value to compare with the latest data date to trigger execution conditions consistent with the single dependency table.

Data query SQL: compiling a database SELECT query statement, wherein a returned data result is used for message content template configuration;

an aggregation field: and the system can respectively synthesize a message according to different values of the aggregated fields for sending, and if the aggregated fields are not specified, all contents are sent as a message. All the field filling is the field alias in the query SQL statement. Common scenarios for the aggregation field are: and generating a plurality of pieces of data according to the employee number of the client manager, wherein each piece of data is information of the client under the name of the corresponding client manager, and the client information needs to be sent to the corresponding client manager, so that the employee number of the client manager needs to be specified as an aggregation field.

A recipient field: the function is to decide who the message is sent to, and field names or specific employee numbers can be filled in. For example, if a field "number of receiving employee" is returned in the query SQL statement, then "number of receiving employee" may be filled in. Or fill in a fixed employee number: 10447534, the message is sent to the employee 10447534. Multiple employee numbers may be filled out and separated by commas, e.g., 10447534,10337856, and all messages sent to the employees corresponding to the two employee numbers.

The system processing time: the system processing event is the time for the system to call the job, and the system automatically writes when the job is called.

Date of the latest data: the latest data date represents the variable value of eddt in the last execution of the job, the value in the dependency condition statement in the last execution, and the variable value of stdt introduced by the next execution statement. The variable value also need not be set, and each time the execution system writes the latest data time.

The message template rule configuration table contains the following main fields:

message title: filling out the title name of the push message.

Description of the function: a detailed description of the template functions, such as "intelligent digital error checking notification".

Message type: the method comprises three types of WeChat public numbers, APP messages and mails.

Dynamic parameter values: the file name format for defining the automatic generation of the system, the configuration example is as follows:

{"ccbinsId":"440000000","systemName":"EDAGDZH","projectName":"LCDQTX","fileName":"@systemName@_MESSAGE_@projectName@_@SYSDATE@_@SEQ@.dat"}

wherein, the 'ccbinsId' is the branch organization number; "systemName" is a system name abbreviation of push WeChat Enterprise number column; "project name" is the project code; "fileName" is the name format of the file to be pushed.

Message content template: the method is realized by adopting a mode of separating a template from data, defines the content structure of the message and adopts a Freemarker format to write. The part of codes are transmitted into a body version block of html when a file is generated later, the form and the function of push presentation can be customized, and cs, html and js codes can be written.

Fig. 3 is a schematic diagram of main modules of a configurable message pushing device 300 according to an embodiment of the present invention, as shown in fig. 3, the configurable message pushing device 300 includes: a configuration module 301, configured to configure a data processing rule according to a data requirement and a message template rule according to a service requirement in a configuration table; a processing module 302, configured to process data to be pushed into message data written in a message table according to the data processing rule and the message template rule in the configuration table; and a pushing module 303, configured to perform format encapsulation on the message data by scanning the configuration table and the message table, so as to push the message data to a corresponding data transmission interface.

According to an embodiment of the present invention, there is provided a configurable message push electronic device, including:

one or more processors;

a storage device for storing one or more programs,

According to a further embodiment of the present invention, there is provided a computer readable medium, on which a computer program is stored, which program, when executed by a processor, performs the method provided by the first aspect of an embodiment of the present invention.

Fig. 4 shows an exemplary device architecture 400 to which the configurable message pushing method or the configurable message pushing device of an embodiment of the invention may be applied.

As shown in fig. 4, the device architecture 400 may include

terminal devices

401, 402, 403, a network 404, and a server 405. The network 404 serves as a medium for providing communication links between the

terminal devices

401, 402, 403 and the server 405. Network 404 may include various types of connections, such as wire, wireless communication links, or fiber optic cables, to name a few.

A user may use

terminal devices

401, 402, 403 to interact with a server 405 over a network 404 to receive or send messages or the like. The

terminal devices

401, 402, 403 may have various communication client applications installed thereon, such as shopping applications, web browser applications, search applications, instant messaging tools, mailbox clients, social platform software, and the like.

The

terminal devices

401, 402, 403 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.

It should be understood that the number of terminal devices, networks, and servers in fig. 4 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

Referring now to fig. 5, a block diagram of a computer apparatus 500 suitable for use in implementing a terminal device of an embodiment of the invention is shown. The terminal device shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.

As shown in fig. 5, the computer apparatus 500 includes a Central Processing Unit (CPU)501 that can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)502 or a program loaded from a storage section 508 into a Random Access Memory (RAM) 503. In the RAM 503, various programs and data necessary for the operation of the apparatus 500 are also stored. The CPU 501, ROM 502, and RAM 503 are connected to each other via a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.

The following components are connected to the I/O interface 505: an input portion 506 including a keyboard, a mouse, and the like; an output portion 507 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 508 including a hard disk and the like; and a communication section 509 including a network interface card such as a LAN card, a modem, or the like. The communication section 509 performs communication processing via a network such as the internet. The driver 510 is also connected to the I/O interface 505 as necessary. A removable medium 511 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 510 as necessary, so that a computer program read out therefrom is mounted into the storage section 508 as necessary.

In particular, according to the embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 509, and/or installed from the removable medium 511. The computer program performs the above-described functions defined in the apparatus of the present invention when executed by the Central Processing Unit (CPU) 501.

It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor device, apparatus, or a combination of any of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution apparatus, device, or apparatus. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution apparatus, device, or apparatus. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based apparatus that perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The modules described in the embodiments of the present invention may be implemented by software or hardware. The described modules may also be provided in a processor, which may be described as: a processor comprising: the task generation module is used for responding to a task application of a user for storing a tail box to generate a box storing task request and sending the box storing task request to a server; the task execution module is used for receiving a first dynamic password generated by the server end in response to the box storing task request and a box storing password input by the user; and verifying the first dynamic password and the storage password, and executing a storage task when the verification is passed so as to store the storage bag bound with the tail box into the data box separation device. Where the names of these modules do not in some cases constitute a limitation on the module itself, for example, a task generation module may also be described as a "module that performs a binning task".

As another aspect, the present invention also provides a computer-readable medium, which may be contained in the apparatus described in the above embodiments; or may be separate and not incorporated into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to comprise: responding to a task application of a user for storing a tail box to generate a box storing task request, and sending the box storing task request to a server; receiving a first dynamic password generated by the server end in response to the box storing task request and a box storing password input by the user; and verifying the first dynamic password and the storage password, and executing a storage task when the verification is passed so as to store the storage bag bound with the tail box into the data box separation device.

According to the technical scheme of the embodiment of the invention, the trunk of the network point is bound with the storage bag in advance, and the storage bag stores the articles in the trunk to the data box separating device of the network point, so that the normal opening of the network point for business can be ensured under the conditions of special weather conditions, traffic jam and the like. Meanwhile, as escort is not required at the end of the day, the escort cost and the storage cost can be reduced, the operation cost is reduced, the working time of network business personnel can be reduced, and the working efficiency is improved.

The above-described embodiments should not be construed as limiting the scope of the invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions can occur, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A configurable message pushing method, comprising:

in the configuration table, configuring data processing rules according to data requirements and configuring message template rules according to business requirements; wherein the data requirements and the service requirements are independent of each other;

processing the data to be pushed into message data written into a message table according to the data processing rule and the message template rule in the configuration table; the method comprises the steps that a timing script reads data query SQL in a configuration table, whether data processing is executed or not is judged according to processing frequency and data latest time, if the current time exceeds the latest data time in the configuration table, the data processing is executed, and message data are written into a message table; if not, the data processing is not executed; and is

2. The method of claim 1, wherein the data processing rules include data access IDs, data processing frequencies, and data queries sql, and the message template rules include message content templates, dynamic parameter values.

3. The method of claim 2, wherein the data processing rules are embodied as valid identifiers, processing frequency, data access identifiers, dependent database table names, data query SQL, aggregation fields, recipient fields, system processing time, latest data date.

4. The method of claim 2, wherein the message template rules are embodied as message header, function description, message type, dynamic parameter values, message content template.

5. The method of claim 1, wherein the step of processing the data to be pushed into the message data written into the message table according to the data processing rule and the message template rule in the configuration table comprises:

6. The method of claim 5, wherein the formatting the message data by scanning the configuration table and the message table comprises:

7. The method of claim 1, wherein the data transmission interface comprises a data transmission interface compliant with NFT, EDA, SMTP protocols.

8. A configurable message pushing apparatus, comprising:

the configuration module is used for configuring the data processing rule according to the data requirement and configuring the message template rule according to the service requirement in the configuration table; wherein the data requirements and the service requirements are independent of each other;

the processing module is used for processing the data to be pushed into message data written into the message table according to the data processing rule and the message template rule in the configuration table; the method comprises the steps that a timing script reads data query SQL in a configuration table, whether data processing is executed or not is judged according to processing frequency and data latest time, if the current time exceeds the latest data time in the configuration table, the data processing is executed, and message data are written into a message table; if not, the data processing is not executed; and is

9. An electronic device implementing configurable message pushing, comprising:

one or more processors;

a storage device for storing one or more programs,

the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1-7.

10. A computer-readable medium, on which a computer program is stored, which program, when being executed by a processor, is adapted to carry out the method of any one of claims 1-7.