mysql - Run python script on Database event

Question

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).

Is there anyway to do that?

Any help would be very appreciated. Thanks!

There's no such thing as event in most of DBs. You'll need to have a loop, repeatedly checking for any changes in DB. — vaultah
@frostnational Nope. Mysql and postgres both support triggers. Postgres triggers can be written in Python. — Leonardo.Z

HaTiMuX HaTiMuX · Accepted Answer · 2014-04-30T09:21:50

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 ;

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

mysql - Run python script on Database event

2 Answers