![]() ![]() The sys_get and sys_set functions are used for setting/getting environment variables. I am using lib_mysqludf_sys which defines sys_get, sys_set, sys_exec, and sys_eval functions. Creating a trigger which can execute external binaries requires creating a UDF (user-defined function). SQL code does not natively POST data to a URI. ![]() To add triggers, you will need a SQL client logged into the ZoneMinder database. Since both inserting a motion event and updating the event when motion ends are events within tables, a trigger can use the openHAB REST API to update an item state without much impact to system load. When motion is no longer detected, the motion event is updated with event info (number of frames, event duration). When ZoneMinder first detects motion, an event is recorded in the database. A TRIGGER is essentially a bit of SQL automatically executed by the database when operations occur within a table - table activity triggers execution. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |