Using the SqlMonitor
Hi,
I'm trying to use the SqlMonitor feature, but somehow it is not working. I don't understand why.
Here is part of my Code:
statement in config.json:
"cmd": "statement",
"name": "add-entry",
"query": "INSERT INTO table (sip, guid, entry) VALUES (%s,%s,%s) RETURNING id",
"args": {
"@sip": { "type": "string" },
"guid": { "type": "string" },
"text": { "type": "string" }
},
"monitor": "monitorinsert"
},
In the app js file I use:
app.send({ mt: "SqlMonitor", name: "monitorinsert" });
If I'm understanding it correctly. Everytime some other user (including me on another device?) is using the Sql statement i should get a websocket update of the statement used.
But other than sending the monitor request nothing happens.
But other than sending the monitor request nothing happens.
Can somebody help me =)
Regards
Anton
