processmaker mysql から websock ref: https://qiita.com/miyataken999/items/fefcd5fef7f89e440814

sendWebSock.sql

BEGIN

set @word = casea;

set @cmd = concat('import websocket
if __name__ == "__main__":
        websocket.enableTrace(True)
        ws = websocket.create_connection("wss://***.***.***.***:9000")
        ws.send("',@word,'")
        result = ws.recv()
        print(result)
        ws.close()');
　 　　 select sys_eval(concat("python3 -c '",@cmd,"'>/dev/null 2>&1 ")) into @d;
    RETURN 0;
END