在数据库事件上运行python脚本 [英] Run python script on Database event

问题描述

我正在运行一个python脚本，该脚本在特定数据库中进行了修改. 一旦数据库(本地服务器)上进行了修改，我想运行第二个脚本.

I'm running a python script that makes modifications in a specific database. I want to run a second script once there is a modification in my database (local server).

反正有这样做吗?

任何帮助将不胜感激. 谢谢！

Any help would be very appreciated. Thanks!

推荐答案

感谢您的回答，我在这里找到了解决方案:

Thanks for your answers, i found a solution here:

http://crazytechthoughts.blogspot.fr/2011/12/call-external-program-from-mysql.html

修改数据库表后，必须定义触发器以调用外部函数:

A Trigger must be defined to call an external function once the DB Table is modified:

DELIMITER $
CREATE TRIGGER Test_Trigger
AFTER INSERT ON SFCRoutingTable
FOR EACH ROW
BEGIN
DECLARE cmd CHAR(255);
DECLARE result int(10);
SET cmd = CONCAT('python /home/triggers.py');
SET result = sys_exec(cmd);
END;
$
DELIMITER ;

在这里，要调用我的python脚本，我使用UDF(用户定义函数)"sys_exec".您可以从此处下载该库: https://github.com/mysqludf/lib_mysqludf_sys

Here, to call my python script, I use 'sys_exec' which is a UDF (User Defined Function). You can download the library from here: https://github.com/mysqludf/lib_mysqludf_sys

这篇关于在数据库事件上运行python脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！