⚠️ Warring! this may cause slowdowns on your database. This will introduce relatively poor performance given sys exec’ing curl for every insert. Far better to also have a trigger write the message to another table and have another process checking for new rows in a loop.

MysqL使您可以通过存储过程将编码包装到易于访问的TRIGGERS中.您可以使用推送器创建类似的东西,我知道如何使用PubNub执行此操作;所以这里是PubNub和MysqL的快速指南.简单就是您所寻求的,这是您的解决方案！我将引导您通过一种简单的方法将表上的任何UPDATE,INSERT和DELETE操作绑定到每次都会调用的存储函数,使用PubNub轻松向您的移动和Web应用程序发送推送通知.

PubNub推送消息

DELIMITER $$
CREATE PROCEDURE push_message
(p1   DOUBLE,p2   DOUBLE,p3 BIGINT)
BEGIN
 DECLARE cmd CHAR(255);
 DECLARE result CHAR(255);
 SET cmd = CONCAT('curl https://pubsub.pubnub.com/publish/demo/demo/0/MysqL_triggers/0/%22',p1,',p2,p3,'%22');
 SET result = sys_eval(cmd);
END$$;

注意：确保您的PROCEDURE类型正确DOUBLE或VARCHAR或TEXT.

MysqL触发代码INSERT示例

CREATE TRIGGER push_message_trigger AFTER INSERT ON your_table_name_here
FOR EACH ROW
CALL push_message(NEW.Column1,NEW.Column2,NEW.Column3);

注意：确保在推送消息中包含此处所需的列.

MysqL触发器代码更新示例

CREATE TRIGGER push_message_trigger AFTER UPDATE ON your_table_name_here
FOR EACH ROW
CALL push_message(NEW.Column1,NEW.Column3);

通过调试控制台监控推送消息

http://www.pubnub.com/console?sub=demo&pub=demo&channel=mysql_triggers – 您可以通过PubNub Dev Console观看触发器.通过这种方式,您可以了解需要更改哪些参数以及哪些数据对于您可以包含在PubNub websocket以及移动和Web设备上可以接收的每个推送通知中.

在JavaScript中接收推送消息

MysqL_triggers',callback : function(MysqL_trigger_details) {
            alert(MysqL_trigger_details);
        }
    });

})();